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:151511 |
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 | ||
5143757 | 5143757 | CORPACTION | ADD | 212015101 | 01 | S | 2022-11-23 | 2022-11-24 | 20221125.ifs | 2022-11-25 | 2022-11-26 | ||||||||||||||||||
5143758 | 5143758 | EQUITY | CHANGE | 212015101 | COM | 0 | 0 | 2007-05-10 | 2022-11-22 | 4 | no | no | no | ? | 2022-11-22 | ? | 20221125.ifs | 2022-11-25 | 2022-11-26 | ||||||||||
5143759 | 5143758 | EQUITY | CHANGE | 212015101 | COM | S | 0 | 2007-05-10 | 2022-11-23 | 4 | no | no | no | ? | 2022-11-24 | ? | 20221125.ifs | 2022-11-25 | 2022-11-26 | ||||||||||
5142627 | 5142627 | CORPACTION | ADD | 212015101 | 01 | A | 2022-11-22 | ? | 20221122.ifs | 2022-11-22 | 2022-11-23 | ||||||||||||||||||
5142628 | 5142628 | EQUITY | CHANGE | 212015101 | COM | 0 | 0 | 2007-05-10 | ? | 4 | no | no | no | ? | 2008-04-24 | ? | 20221122.ifs | 2022-11-22 | 2022-11-23 | ||||||||||
5142629 | 5142628 | EQUITY | CHANGE | 212015101 | COM | A | 0 | 2007-05-10 | 2022-11-22 | 4 | no | no | no | ? | 2022-11-22 | ? | 20221122.ifs | 2022-11-22 | 2022-11-23 | ||||||||||
5142660 | 5142660 | CORPACTION | DELETE | 212015101 | 01 | A | 2022-11-22 | ? | 20221122.ifs | 2022-11-22 | 2022-11-23 | ||||||||||||||||||
5142661 | 5142661 | EQUITY | CHANGE | 212015101 | COM | A | 0 | 2007-05-10 | 2022-11-22 | 4 | no | no | no | ? | 2022-11-22 | ? | 20221122.ifs | 2022-11-22 | 2022-11-23 | ||||||||||
5142662 | 5142661 | EQUITY | CHANGE | 212015101 | COM | 0 | 0 | 2007-05-10 | 2022-11-22 | 4 | no | no | no | ? | 2022-11-22 | ? | 20221122.ifs | 2022-11-22 | 2022-11-23 | ||||||||||
5065260 | 5065260 | DIVIDEND | ADD | 212015101 | 0 | 0 | 1 | 0 | .28 | 00 | 2022-08-05 | 2022-08-08 | 2022-08-22 | 2022-07-28 | 0 | 2022-07-28 | ? | 0 | 0006559946 | 20220728.ifs | 2022-07-28 | 2022-07-29 | |||||||
4998975 | 4998975 | DIVIDEND | ADD | 212015101 | 0 | 0 | 1 | 0 | .28 | 00 | 2022-05-06 | 2022-05-09 | 2022-05-23 | 2022-04-26 | 0 | 2022-04-27 | ? | 0 | 0006513650 | 20220427.ifs | 2022-04-27 | 2022-04-28 | |||||||
4951247 | 4951247 | DIVIDEND | ADD | 212015101 | 0 | 0 | 1 | 0 | .23 | 00 | 2022-02-18 | 2022-02-22 | 2022-03-04 | 2022-02-09 | 0 | 2022-02-09 | ? | 0 | 0006479681 | 20220209.ifs | 2022-02-09 | 2022-02-10 | |||||||
4843390 | 4843390 | DIVIDEND | ADD | 212015101 | 0 | 0 | 1 | 0 | .2 | 00 | 2021-11-12 | 2021-11-15 | 2021-11-26 | 2021-11-01 | 0 | 2021-11-03 | ? | 0 | 0006394784 | 20211103.ifs | 2021-11-03 | 2021-11-04 | |||||||
4769929 | 4769929 | DIVIDEND | ADD | 212015101 | 0 | 0 | 1 | 0 | .15 | 00 | 2021-08-09 | 2021-08-10 | 2021-08-20 | 2021-07-30 | 0 | 2021-07-30 | ? | 0 | 0006344837 | 20210730.ifs | 2021-07-30 | 2021-07-31 | |||||||
4690158 | 4690158 | DIVIDEND | ADD | 212015101 | 0 | 0 | 1 | 0 | .11 | 00 | 2021-05-07 | 2021-05-10 | 2021-05-24 | 2021-04-27 | 0 | 2021-04-28 | ? | 0 | 0006298146 | 20210428.ifs | 2021-04-28 | 2021-04-29 | |||||||
4518598 | 4518598 | DIVIDEND | CHANGE | 212015101 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2020-05-21 | 2020-04-07 | 0 | 2020-04-07 | ? | 0 | 0006084234 | 20201130.ifs | 2020-11-30 | 2020-12-01 | |||||||
4518599 | 4518598 | DIVIDEND | CHANGE | 212015101 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2020-05-21 | 2020-04-07 | 1 | 2020-04-07 | 2020-11-30 | 0 | 0006084234 | 20201130.ifs | 2020-11-30 | 2020-12-01 | |||||||
4283672 | 4283672 | DIVIDEND | ADD | 212015101 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2020-05-21 | 2020-04-07 | 0 | 2020-04-07 | ? | 0 | 0006084234 | 20200407.ifs | 2020-04-07 | 2020-04-08 | |||||||
4283675 | 4283675 | DIVIDEND | ADD | 212015101 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2020-05-21 | 2020-04-07 | 0 | 2020-04-07 | ? | 0 | 0006084234 | 20200407.ifs | 2020-04-07 | 2020-04-08 | |||||||
4179127 | 4179127 | DIVIDEND | ADD | 212015101 | 0 | 0 | 1 | 0 | .05 | 00 | 2020-02-06 | 2020-02-07 | 2020-02-21 | 2020-01-27 | 0 | 2020-01-27 | ? | 0 | 0006045234 | 20200127.ifs | 2020-01-27 | 2020-01-28 | |||||||
4179128 | 4179128 | DIVIDEND | ADD | 212015101 | 0 | 0 | 1 | 0 | .05 | 00 | 2020-02-06 | 2020-02-07 | 2020-02-21 | 2020-01-27 | 0 | 2020-01-27 | ? | 0 | 0006045234 | 20200127.ifs | 2020-01-27 | 2020-01-28 | |||||||
3762213 | 3762213 | DIVIDEND | ADD | 212015101 | 0 | 0 | 1 | 0 | .05 | 35 | 2019-11-06 | 2019-11-07 | 2019-11-21 | 2019-06-03 | 0 | 2019-06-03 | ? | 0 | 0005893200 | 20190603.ifs | 2019-06-03 | 2019-06-04 | |||||||
3762445 | 3762445 | DIVIDEND | ADD | 212015101 | 0 | 0 | 1 | 0 | .05 | 35 | 2019-11-06 | 2019-11-07 | 2019-11-21 | 2019-06-03 | 0 | 2019-06-03 | ? | 0 | 0005893200 | 20190603.ifs | 2019-06-03 | 2019-06-04 | |||||||
1609324 | 1609324 | DIVIDEND | DELETE | 212015101 | 0 | 0 | 6 | 0 | 1 | 11 | ? | 2014-09-03 | 2014-09-10 | 2014-08-18 | 0 | 2014-08-18 | ? | 0 | 0004829759 | 20140819.ifs | 2014-08-19 | 2014-08-20 | |||||||
1609325 | 1609325 | DIVIDEND | ADD | 212015101 | 0 | 0 | 6 | 0 | 1 | 11 | 2014-09-11 | 2014-09-03 | 2014-09-10 | 2014-08-18 | 1 | 2014-08-18 | 2014-08-19 | 0 | 0004829759 | 20140819.ifs | 2014-08-19 | 2014-08-20 | |||||||
1609326 | 1609326 | SPLIT | ADD | 212015101 | .5 | 2014-09-11 | 11 | 2014-08-19 | ? | 20140819.ifs | 2014-08-19 | 2014-08-20 | |||||||||||||||||
1608642 | 1608642 | DIVIDEND | ADD | 212015101 | 0 | 0 | 6 | 0 | 1 | 11 | ? | 2014-09-03 | 2014-09-10 | 2014-08-18 | 0 | 2014-08-18 | ? | 0 | 0004829759 | 20140818.ifs | 2014-08-18 | 2014-08-19 |
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 = 151511
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