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:151521 |
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 | ||
3604610 | 3604610 | CORPACTION | ADD | 08171T102 | 60 | M | 2019-03-01 | 929328102 | 60 | ? | 20190301.ifs | 2019-03-01 | 2019-03-02 | ||||||||||||||||
3604613 | 3604613 | EQUITY | CHANGE | 08171T102 | COM | 0 | 0 | 2015-01-13 | ? | 4 | no | no | yes | 2015-01-13 | 2015-02-27 | ? | 20190301.ifs | 2019-03-01 | 2019-03-02 | ||||||||||
3604614 | 3604613 | EQUITY | CHANGE | 08171T102 | COM | M | 0 | 2015-01-13 | 2019-03-01 | 4 | no | no | 929328102 | yes | 2015-01-13 | 2019-03-01 | ? | 20190301.ifs | 2019-03-01 | 2019-03-02 | |||||||||
3604859 | 3604859 | CORPACTION | ADD | 08171T102 | 60 | M | 2019-03-01 | 929328102 | 60 | ? | 20190301.ifs | 2019-03-01 | 2019-03-02 | ||||||||||||||||
3604861 | 3604861 | EQUITY | CHANGE | 08171T102 | COM | 0 | 0 | 2015-01-13 | ? | 4 | no | no | yes | 2015-01-13 | 2015-02-27 | ? | 20190301.ifs | 2019-03-01 | 2019-03-02 | ||||||||||
3604863 | 3604862 | EQUITY | CHANGE | 08171T102 | COM | M | 0 | 2015-01-13 | 2019-03-01 | 4 | no | no | 929328102 | yes | 2015-01-13 | 2019-03-01 | ? | 20190301.ifs | 2019-03-01 | 2019-03-02 | |||||||||
3612232 | 3612232 | DIVIDEND | CHANGE | 08171T102 | 0 | 0 | 1 | 0 | .06 | 00 | 2019-02-08 | 2019-02-11 | 2019-02-21 | 2019-01-31 | 0 | 2019-02-01 | ? | 0 | 0005832333 | 20190301.ifs | 2019-03-01 | 2019-03-02 | |||||||
3612233 | 3612232 | DIVIDEND | CHANGE | 08171T102 | 0 | 0 | 1 | 0 | .06 | 00 | 2019-02-08 | 2019-02-11 | 2019-02-21 | 2019-01-31 | 1 | 2019-02-01 | 2019-03-01 | 0 | 0005832333 | 20190301.ifs | 2019-03-01 | 2019-03-02 | |||||||
3612475 | 3612475 | DIVIDEND | CHANGE | 08171T102 | 0 | 0 | 1 | 0 | .06 | 00 | 2019-02-08 | 2019-02-11 | 2019-02-21 | 2019-01-31 | 0 | 2019-02-01 | ? | 0 | 0005832333 | 20190301.ifs | 2019-03-01 | 2019-03-02 | |||||||
3612476 | 3612475 | DIVIDEND | CHANGE | 08171T102 | 0 | 0 | 1 | 0 | .06 | 00 | 2019-02-08 | 2019-02-11 | 2019-02-21 | 2019-01-31 | 1 | 2019-02-01 | 2019-03-01 | 0 | 0005832333 | 20190301.ifs | 2019-03-01 | 2019-03-02 | |||||||
3334772 | 3334772 | DIVIDEND | ADD | 08171T102 | 0 | 0 | 1 | 0 | .06 | 00 | 2018-10-26 | 2018-10-29 | 2018-11-08 | 2018-10-18 | 0 | 2018-10-19 | ? | 0 | 0005742000 | 20181019.ifs | 2018-10-19 | 2018-10-20 | |||||||
3334777 | 3334777 | DIVIDEND | ADD | 08171T102 | 0 | 0 | 1 | 0 | .06 | 00 | 2018-10-26 | 2018-10-29 | 2018-11-08 | 2018-10-18 | 0 | 2018-10-19 | ? | 0 | 0005742000 | 20181019.ifs | 2018-10-19 | 2018-10-20 | |||||||
3201608 | 3201608 | DIVIDEND | ADD | 08171T102 | 0 | 0 | 1 | 0 | .06 | 00 | 2018-07-27 | 2018-07-30 | 2018-08-09 | 2018-07-19 | 0 | 2018-07-20 | ? | 0 | 0005695714 | 20180720.ifs | 2018-07-20 | 2018-07-21 | |||||||
3201688 | 3201688 | DIVIDEND | ADD | 08171T102 | 0 | 0 | 1 | 0 | .06 | 00 | 2018-07-27 | 2018-07-30 | 2018-08-09 | 2018-07-19 | 0 | 2018-07-20 | ? | 0 | 0005695714 | 20180720.ifs | 2018-07-20 | 2018-07-21 | |||||||
3046064 | 3046064 | DIVIDEND | ADD | 08171T102 | 0 | 0 | 1 | 0 | .06 | 00 | 2018-04-27 | 2018-04-30 | 2018-05-10 | 2018-04-19 | 0 | 2018-04-20 | ? | 0 | 0005648624 | 20180420.ifs | 2018-04-20 | 2018-04-21 | |||||||
3046065 | 3046065 | DIVIDEND | ADD | 08171T102 | 0 | 0 | 1 | 0 | .06 | 00 | 2018-04-27 | 2018-04-30 | 2018-05-10 | 2018-04-19 | 0 | 2018-04-20 | ? | 0 | 0005648624 | 20180420.ifs | 2018-04-20 | 2018-04-21 | |||||||
2942032 | 2942032 | DIVIDEND | ADD | 08171T102 | 0 | 0 | 1 | 9 | .25 | 03 | 2018-02-02 | 2018-02-05 | 2018-02-15 | 2018-01-25 | 0 | 2018-02-01 | ? | 1 | 0005608861 | 20180201.ifs | 2018-02-01 | 2018-02-02 | |||||||
2942033 | 2942033 | DIVIDEND | ADD | 08171T102 | 0 | 0 | 1 | 0 | .06 | 00 | 2018-02-02 | 2018-02-05 | 2018-02-15 | 2018-01-25 | 0 | 2018-02-01 | ? | 0 | 0005608856 | 20180201.ifs | 2018-02-01 | 2018-02-02 | |||||||
2731141 | 2731141 | DIVIDEND | ADD | 08171T102 | 0 | 0 | 1 | 0 | .06 | 00 | 2017-10-27 | 2017-10-30 | 2017-11-09 | 2017-10-19 | 0 | 2017-10-20 | ? | 0 | 0005516287 | 20171020.ifs | 2017-10-20 | 2017-10-21 | |||||||
2731142 | 2731142 | DIVIDEND | ADD | 08171T102 | 0 | 0 | 1 | 0 | .06 | 00 | 2017-10-27 | 2017-10-30 | 2017-11-09 | 2017-10-19 | 0 | 2017-10-20 | ? | 0 | 0005516287 | 20171020.ifs | 2017-10-20 | 2017-10-21 | |||||||
2716376 | 2716376 | SPLIT | ADD | 08171T102 | .9091735612 | 2015-01-13 | 11 | ? | 2017-10-05 | 20171005.ifs | 2017-10-05 | 2017-10-06 | |||||||||||||||||
2628833 | 2628833 | DIVIDEND | ADD | 08171T102 | 0 | 0 | 1 | 0 | .06 | 00 | 2017-07-28 | 2017-08-01 | 2017-08-11 | 2017-07-20 | 0 | 2017-07-21 | ? | 0 | 0005470320 | 20170721.ifs | 2017-07-21 | 2017-07-22 | |||||||
2545951 | 2545951 | DIVIDEND | ADD | 08171T102 | 0 | 0 | 1 | 0 | .06 | 00 | 2017-04-27 | 2017-05-01 | 2017-05-11 | 2017-04-20 | 0 | 2017-04-21 | ? | 0 | 0005422700 | 20170421.ifs | 2017-04-21 | 2017-04-22 | |||||||
2483328 | 2483328 | DIVIDEND | ADD | 08171T102 | 0 | 0 | 1 | 0 | .06 | 00 | 2017-02-09 | 2017-02-13 | 2017-02-23 | 2017-01-26 | 0 | 2017-02-01 | ? | 0 | 0005382190 | 20170201.ifs | 2017-02-01 | 2017-02-02 | |||||||
2435136 | 2435136 | EQUITY | CHANGE | 08171T102 | COM | 0 | 0 | 2015-01-13 | ? | 0 | no | no | yes | 2015-01-13 | 2015-02-27 | ? | 20170123.ifs | 2017-01-23 | 2017-01-24 | ||||||||||
2435137 | 2435136 | EQUITY | CHANGE | 08171T102 | COM | 0 | 0 | 2015-01-13 | ? | 4 | no | no | yes | 2015-01-13 | 2015-02-27 | ? | 20170123.ifs | 2017-01-23 | 2017-01-24 | ||||||||||
2324910 | 2324910 | DIVIDEND | ADD | 08171T102 | 0 | 0 | 1 | 0 | .06 | 00 | 2016-10-27 | 2016-10-31 | 2016-11-10 | 2016-10-21 | 0 | 2016-10-21 | ? | 0 | 0005299771 | 20161021.ifs | 2016-10-21 | 2016-10-22 | |||||||
2255845 | 2255845 | DIVIDEND | ADD | 08171T102 | 0 | 0 | 1 | 4 | .06 | 00 | 2016-07-28 | 2016-08-01 | 2016-08-11 | 2016-07-21 | 0 | 2016-07-22 | ? | 0 | 0005253561 | 20160722.ifs | 2016-07-22 | 2016-07-23 | |||||||
1797142 | 1797142 | EQUITY | CHANGE | 08171T102 | COM | 0 | 0 | 2015-01-13 | ? | 0 | no | no | no | 2015-01-13 | 2015-01-13 | ? | 20150227.ifs | 2015-02-27 | 2015-02-28 | ||||||||||
1797143 | 1797142 | EQUITY | CHANGE | 08171T102 | COM | 0 | 0 | 2015-01-13 | ? | 0 | no | no | yes | 2015-01-13 | 2015-02-27 | ? | 20150227.ifs | 2015-02-27 | 2015-02-28 | ||||||||||
1768400 | 1768400 | EQUITY | CHANGE | 08171T102 | COM | N | 0 | 2015-01-13 | ? | 0 | no | no | no | 2015-01-13 | ? | ? | 20150114.ifs | 2015-01-14 | 2015-01-15 | ||||||||||
1768401 | 1768400 | EQUITY | CHANGE | 08171T102 | COM | 0 | 0 | 2015-01-13 | ? | 0 | no | no | no | 2015-01-13 | 2015-01-13 | ? | 20150114.ifs | 2015-01-14 | 2015-01-15 | ||||||||||
1768178 | 1768178 | EXCHANGE | ADD | 08171T102 | 60 | 2015-01-13 | ? | BNCL | 0 | 0 | 2015-01-13 | ? | 20150113.ifs | 2015-01-13 | 2015-01-14 | ||||||||||||||
1768179 | 1768179 | EQUITY | ADD | 08171T102 | COM | N | 0 | 2015-01-13 | ? | 0 | no | no | no | 2015-01-13 | ? | ? | 20150113.ifs | 2015-01-13 | 2015-01-14 |
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 = 151521
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