INSITITUIONS | Dynamic | newInstitTable | Changed the Cusip/Sector/Shs Out? |
|
|||||||
Total Insititutions : | N/A | 0 | Update Insititution By Cusips | ||||||||
% Owned by Insititutions: | N/A % | 0 % | |||||||||
pricingQuarterAdminPageOn:
|
2024-03-31 | New % | |||||||||
|
|||||||||||
the compid is:130649 |
reportDate | ratio | endQuaterAffected | dayFrom | dayTo |
Cusip
entryId | groupId | EQUITY | CHANGE | CUSIP | DESCRIPTION | ISSUE STATUS CODE |
ISSUE TYPE CODE |
ADD DATE |
EXPIRATION DATE |
PAYMENT FREQUENCY CODE |
MARGIN FLAG |
OPTION FLAG |
CONVERTED CUSIP |
NASDAQ MARKET CODE |
INDEX ISSUER |
CHANGE DATE |
MERGENT CHANGE DATE |
MATURE DATE |
undefined1 | undefined2 | undefined3 | undefined4 | temp1 | temp2 | fileName | fileDate | processDate | ||
4657919 | 4657919 | CORPACTION | ADD | 16944W104 | 01 | M | 2021-03-22 | 2021-03-22 | 20210322.ifs | 2021-03-22 | 2021-03-23 | ||||||||||||||||||
4657920 | 4657920 | EQUITY | CHANGE | 16944W104 | SPONSORED ADR | 0 | 0 | 2008-07-30 | ? | 7 | no | no | no | 2008-07-30 | 2021-03-18 | ? | 20210322.ifs | 2021-03-22 | 2021-03-23 | ||||||||||
4657921 | 4657920 | EQUITY | CHANGE | 16944W104 | SPONSORED ADR | M | 0 | 2008-07-30 | 2021-03-22 | 7 | no | no | no | 2008-07-30 | 2021-03-22 | ? | 20210322.ifs | 2021-03-22 | 2021-03-23 | ||||||||||
4657922 | 4657922 | CORPACTION | DELETE | 16944W104 | 01 | M | 2021-03-22 | 2021-03-22 | 20210322.ifs | 2021-03-22 | 2021-03-23 | ||||||||||||||||||
4657923 | 4657923 | CORPACTION | ADD | 16944W104 | 01 | M | 2021-03-19 | 2021-03-22 | 20210322.ifs | 2021-03-22 | 2021-03-23 | ||||||||||||||||||
4657924 | 4657924 | EQUITY | CHANGE | 16944W104 | SPONSORED ADR | M | 0 | 2008-07-30 | 2021-03-22 | 7 | no | no | no | 2008-07-30 | 2021-03-22 | ? | 20210322.ifs | 2021-03-22 | 2021-03-23 | ||||||||||
4657925 | 4657924 | EQUITY | CHANGE | 16944W104 | SPONSORED ADR | M | 0 | 2008-07-30 | 2021-03-19 | 7 | no | no | no | 2008-07-30 | 2021-03-22 | ? | 20210322.ifs | 2021-03-22 | 2021-03-23 | ||||||||||
4655457 | 4655457 | CORPACTION | ADD | 16944W104 | 01 | A | 2021-03-18 | ? | 20210318.ifs | 2021-03-18 | 2021-03-19 | ||||||||||||||||||
4655458 | 4655458 | EQUITY | CHANGE | 16944W104 | SPONSORED ADR | 0 | 0 | 2008-07-30 | ? | 7 | no | no | no | 2008-07-30 | ? | ? | 20210318.ifs | 2021-03-18 | 2021-03-19 | ||||||||||
4655459 | 4655458 | EQUITY | CHANGE | 16944W104 | SPONSORED ADR | A | 0 | 2008-07-30 | 2021-03-18 | 7 | no | no | no | 2008-07-30 | 2021-03-18 | ? | 20210318.ifs | 2021-03-18 | 2021-03-19 | ||||||||||
4655552 | 4655552 | CORPACTION | DELETE | 16944W104 | 01 | A | 2021-03-18 | ? | 20210318.ifs | 2021-03-18 | 2021-03-19 | ||||||||||||||||||
4655553 | 4655553 | EQUITY | CHANGE | 16944W104 | SPONSORED ADR | A | 0 | 2008-07-30 | 2021-03-18 | 7 | no | no | no | 2008-07-30 | 2021-03-18 | ? | 20210318.ifs | 2021-03-18 | 2021-03-19 | ||||||||||
4655554 | 4655553 | EQUITY | CHANGE | 16944W104 | SPONSORED ADR | 0 | 0 | 2008-07-30 | ? | 7 | no | no | no | 2008-07-30 | 2021-03-18 | ? | 20210318.ifs | 2021-03-18 | 2021-03-19 | ||||||||||
4656210 | 4656210 | DIVIDEND | CHANGE | 16944W104 | 6 | 0 | 1 | 9 | .56 | 25 | 2020-03-30 | 2020-03-31 | 2020-04-24 | 2020-03-18 | 1 | 2020-03-18 | 2021-03-09 | 0 | 0006069720 | 20210318.ifs | 2021-03-18 | 2021-03-19 | |||||||
4656211 | 4656210 | DIVIDEND | CHANGE | 16944W104 | 6 | 0 | 1 | 9 | .56 | 25 | 2020-03-30 | 2020-03-31 | 2020-04-24 | 2020-03-18 | 2 | 2020-03-18 | 2021-03-18 | 0 | 0006069720 | 20210318.ifs | 2021-03-18 | 2021-03-19 | |||||||
4650157 | 4650157 | DIVIDEND | CHANGE | 16944W104 | 6 | 0 | 1 | 9 | .56 | 25 | 2020-03-30 | 2020-03-31 | 2020-04-24 | 2020-03-18 | 0 | 2020-03-18 | ? | 0 | 0006069720 | 20210309.ifs | 2021-03-09 | 2021-03-10 | |||||||
4650158 | 4650157 | DIVIDEND | CHANGE | 16944W104 | 6 | 0 | 1 | 9 | .56 | 25 | 2020-03-30 | 2020-03-31 | 2020-04-24 | 2020-03-18 | 1 | 2020-03-18 | 2021-03-09 | 0 | 0006069720 | 20210309.ifs | 2021-03-09 | 2021-03-10 | |||||||
4650159 | 4650159 | EQUITY | CHANGE | 16944W104 | SPONSORED ADR | 0 | 0 | 2008-07-30 | ? | 0 | no | no | no | 2008-07-30 | ? | ? | 20210309.ifs | 2021-03-09 | 2021-03-10 | ||||||||||
4650160 | 4650159 | EQUITY | CHANGE | 16944W104 | SPONSORED ADR | 0 | 0 | 2008-07-30 | ? | 7 | no | no | no | 2008-07-30 | ? | ? | 20210309.ifs | 2021-03-09 | 2021-03-10 | ||||||||||
4242995 | 4242995 | DIVIDEND | ADD | 16944W104 | 6 | 0 | 1 | 9 | .56 | 25 | 2020-03-30 | 2020-03-31 | 2020-04-24 | 2020-03-18 | 0 | 2020-03-18 | ? | 0 | 0006069720 | 20200318.ifs | 2020-03-18 | 2020-03-19 | |||||||
4242996 | 4242996 | DIVIDEND | ADD | 16944W104 | 6 | 0 | 1 | 9 | .56 | 25 | 2020-03-30 | 2020-03-31 | 2020-04-24 | 2020-03-18 | 0 | 2020-03-18 | ? | 0 | 0006069720 | 20200318.ifs | 2020-03-18 | 2020-03-19 | |||||||
2780661 | 2780661 | DIVIDEND | ADD | 16944W104 | 6 | 0 | 1 | 9 | .43 | 25 | 2018-01-11 | 2018-01-12 | 2018-01-18 | 2017-11-29 | 0 | 2017-11-29 | ? | 0 | 0005534105 | 20171129.ifs | 2017-11-29 | 2017-11-30 | |||||||
2780885 | 2780885 | DIVIDEND | ADD | 16944W104 | 6 | 0 | 1 | 9 | .43 | 25 | 2018-01-11 | 2018-01-12 | 2018-01-18 | 2017-11-29 | 0 | 2017-11-29 | ? | 0 | 0005534105 | 20171129.ifs | 2017-11-29 | 2017-11-30 | |||||||
2368579 | 2368579 | DIVIDEND | ADD | 16944W104 | 6 | 0 | 1 | 0 | .45 | 05 | 2017-01-04 | 2017-01-06 | 2017-01-13 | 2016-12-08 | 0 | 2016-12-09 | ? | 0 | 0005327987 | 20161209.ifs | 2016-12-09 | 2016-12-10 | |||||||
2110846 | 2110846 | DIVIDEND | DELETE | 16944W104 | 6 | 0 | 1 | 5 | .9 | 26 | 2016-01-04 | 2016-01-06 | ? | 2015-12-11 | 0 | 2015-12-14 | ? | 0 | 0005115691 | 20160208.ifs | 2016-02-08 | 2016-02-09 | |||||||
2110847 | 2110847 | DIVIDEND | ADD | 16944W104 | 6 | 0 | 1 | 9 | .9 | 25 | 2016-01-04 | 2016-01-06 | 2016-01-13 | 2015-12-11 | 1 | 2015-12-14 | 2016-02-08 | 0 | 0005115691 | 20160208.ifs | 2016-02-08 | 2016-02-09 | |||||||
2038592 | 2038592 | DIVIDEND | ADD | 16944W104 | 6 | 0 | 1 | 5 | .9 | 26 | 2016-01-04 | 2016-01-06 | ? | 2015-12-11 | 0 | 2015-12-14 | ? | 0 | 0005115691 | 20151214.ifs | 2015-12-14 | 2015-12-15 | |||||||
1767998 | 1767998 | DIVIDEND | CHANGE | 16944W104 | 6 | 0 | 1 | 5 | .8 | 26 | 2015-01-02 | 2015-01-06 | 2015-01-14 | 2014-11-19 | 1 | 2014-11-20 | 2015-01-08 | 0 | 0004874361 | 20150112.ifs | 2015-01-12 | 2015-01-13 | |||||||
1767999 | 1767998 | DIVIDEND | CHANGE | 16944W104 | 6 | 0 | 1 | 5 | .78 | 26 | 2015-01-02 | 2015-01-06 | 2015-01-14 | 2014-11-19 | 2 | 2014-11-20 | 2015-01-12 | 0 | 0004874361 | 20150112.ifs | 2015-01-12 | 2015-01-13 | |||||||
1766781 | 1766781 | DIVIDEND | DELETE | 16944W104 | 6 | 0 | 1 | 5 | .78 | 26 | 2015-01-02 | 2015-01-06 | ? | 2014-11-19 | 0 | 2014-11-20 | ? | 0 | 0004874361 | 20150108.ifs | 2015-01-08 | 2015-01-09 | |||||||
1766782 | 1766782 | DIVIDEND | ADD | 16944W104 | 6 | 0 | 1 | 5 | .8 | 26 | 2015-01-02 | 2015-01-06 | 2015-01-14 | 2014-11-19 | 1 | 2014-11-20 | 2015-01-08 | 0 | 0004874361 | 20150108.ifs | 2015-01-08 | 2015-01-09 | |||||||
1685013 | 1685013 | DIVIDEND | ADD | 16944W104 | 6 | 0 | 1 | 5 | .78 | 26 | 2015-01-02 | 2015-01-06 | ? | 2014-11-19 | 0 | 2014-11-20 | ? | 0 | 0004874361 | 20141120.ifs | 2014-11-20 | 2014-11-21 | |||||||
1420563 | 1420563 | DIVIDEND | DELETE | 16944W104 | 6 | 0 | 1 | 0 | .58 | 05 | 2014-01-06 | 2014-01-08 | ? | 2013-11-21 | 0 | 2013-11-21 | ? | 0 | 0004660314 | 20140109.ifs | 2014-01-09 | 2014-01-10 | |||||||
1420564 | 1420564 | DIVIDEND | ADD | 16944W104 | 6 | 0 | 1 | 0 | .58 | 05 | 2014-01-06 | 2014-01-08 | 2014-01-10 | 2013-11-21 | 1 | 2013-11-21 | 2014-01-09 | 0 | 0004660314 | 20140109.ifs | 2014-01-09 | 2014-01-10 | |||||||
1343737 | 1343737 | DIVIDEND | ADD | 16944W104 | 6 | 0 | 1 | 0 | .58 | 05 | 2014-01-06 | 2014-01-08 | ? | 2013-11-21 | 0 | 2013-11-21 | ? | 0 | 0004660314 | 20131121.ifs | 2013-11-21 | 2013-11-22 | |||||||
1042758 | 1042758 | DIVIDEND | DELETE | 16944W104 | 6 | 0 | 1 | 9 | .48 | 25 | 2012-12-05 | 2012-12-07 | ? | 2012-11-14 | 1 | 2012-11-15 | 2012-12-04 | 0 | 0004458415 | 20121214.ifs | 2012-12-14 | 2012-12-15 | |||||||
1042759 | 1042759 | DIVIDEND | ADD | 16944W104 | 6 | 0 | 1 | 9 | .48 | 25 | 2012-12-05 | 2012-12-07 | 2012-12-17 | 2012-11-14 | 2 | 2012-11-15 | 2012-12-14 | 0 | 0004458415 | 20121214.ifs | 2012-12-14 | 2012-12-15 | |||||||
1027582 | 1027582 | DIVIDEND | CHANGE | 16944W104 | 6 | 0 | 1 | 9 | .48 | 25 | 2012-12-05 | 2012-12-07 | ? | 2012-11-14 | 0 | 2012-11-15 | ? | 0 | 0004458415 | 20121204.ifs | 2012-12-04 | 2012-12-05 | |||||||
1027583 | 1027582 | DIVIDEND | CHANGE | 16944W104 | 6 | 0 | 1 | 9 | .48 | 25 | 2012-12-05 | 2012-12-07 | ? | 2012-11-14 | 1 | 2012-11-15 | 2012-12-04 | 0 | 0004458415 | 20121204.ifs | 2012-12-04 | 2012-12-05 | |||||||
1010460 | 1010460 | DIVIDEND | ADD | 16944W104 | 6 | 0 | 1 | 9 | .48 | 25 | 2012-12-05 | 2012-12-07 | ? | 2012-11-14 | 0 | 2012-11-15 | ? | 0 | 0004458415 | 20121115.ifs | 2012-11-15 | 2012-11-16 | |||||||
698338 | 698338 | DIVIDEND | CHANGE | 16944W104 | 6 | 0 | 1 | 4 | .46 | 26 | 2011-12-13 | 2011-12-15 | ? | 2011-11-17 | 0 | 2011-11-17 | ? | 0 | 0004270696 | 20111121.ifs | 2011-11-21 | 2011-11-22 | |||||||
698339 | 698338 | DIVIDEND | CHANGE | 16944W104 | 6 | 0 | 1 | 4 | .46 | 26 | 2011-12-13 | 2011-12-15 | ? | 2011-11-17 | 1 | 2011-11-17 | 2011-11-21 | 0 | 0004270696 | 20111121.ifs | 2011-11-21 | 2011-11-22 | |||||||
696503 | 696503 | DIVIDEND | ADD | 16944W104 | 6 | 0 | 1 | 4 | .46 | 26 | 2011-12-13 | 2011-12-15 | ? | 2011-11-17 | 0 | 2011-11-17 | ? | 0 | 0004270696 | 20111117.ifs | 2011-11-17 | 2011-11-18 |
entryId | groupId | EQUITY | CHANGE | CUSIP | DESCRIPTION | ISSUE STATUS CODE |
ISSUE TYPE CODE |
ADD DATE |
EXPIRATION DATE |
PAYMENT FREQUENCY CODE |
MARGIN FLAG |
OPTION FLAG |
CONVERTED CUSIP |
NASDAQ MARKET CODE |
INDEX ISSUER |
CHANGE DATE |
MERGENT CHANGE DATE |
MATURE DATE |
undefined1 | undefined2 | undefined3 | undefined4 | temp1 | temp2 | fileName | fileDate | processDate |
BACK UP Institutions before committing
SELECT institutionciklist.institutionid AS theinstitutionID, institutionciklist.institutionCik, institutionciklist.institutionName, institutionciklist.isGuru, all13ffilings. * , current13Fpositions. *
FROM current13Fpositions, all13ffilings, institutionciklist
WHERE current13Fpositions.compid = 130649
AND all13ffilings.entryId = current13Fpositions.linkID
AND all13ffilings.institutionid = institutionciklist.institutionid
AND institutionciklist.alive ='yes'
AND all13ffilings.done ='yes'
AND reportDate >='2012-06-30'
ORDER BY value ASC