INSITITUIONS | Dynamic | newInstitTable | Changed the Cusip/Sector/Shs Out? |
|
||||||||||
Total Insititutions : | 146 | 123 | Update Insititution By Cusips | |||||||||||
% Owned by Insititutions: | 60.27 % | 55.78 % | ||||||||||||
pricingQuarterAdminPageOn:
|
2024-03-31 | New % | ||||||||||||
|
||||||||||||||
the compid is:136809 |
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 | ||
5499851 | 5499851 | DIVIDEND | ADD | 637215104 | 0 | 0 | 1 | 9 | 3.5 | 03 | 2024-02-29 | 2024-03-01 | 2024-03-15 | 2024-02-16 | 0 | 2024-02-16 | ? | 1 | 0006877411 | 20240216.ifs | 2024-02-16 | 2024-02-17 | |||||||
5499852 | 5499852 | DIVIDEND | ADD | 637215104 | 0 | 0 | 1 | 0 | 1 | 00 | 2024-02-29 | 2024-03-01 | 2024-03-15 | 2024-02-16 | 0 | 2024-02-16 | ? | 0 | 0006877409 | 20240216.ifs | 2024-02-16 | 2024-02-17 | |||||||
5232013 | 5232013 | DIVIDEND | ADD | 637215104 | 0 | 0 | 1 | 9 | 3 | 03 | 2023-02-28 | 2023-03-01 | 2023-03-15 | 2023-02-17 | 0 | 2023-02-17 | ? | 1 | 0006683713 | 20230217.ifs | 2023-02-17 | 2023-02-18 | |||||||
5232014 | 5232014 | DIVIDEND | ADD | 637215104 | 0 | 0 | 1 | 0 | 1 | 00 | 2023-02-28 | 2023-03-01 | 2023-03-15 | 2023-02-17 | 0 | 2023-02-17 | ? | 0 | 0006683712 | 20230217.ifs | 2023-02-17 | 2023-02-18 | |||||||
4952611 | 4952611 | DIVIDEND | ADD | 637215104 | 0 | 0 | 1 | 9 | 3.5 | 03 | 2022-02-28 | 2022-03-01 | 2022-03-15 | 2022-02-11 | 0 | 2022-02-11 | ? | 1 | 0006480658 | 20220211.ifs | 2022-02-11 | 2022-02-12 | |||||||
4952612 | 4952612 | DIVIDEND | ADD | 637215104 | 0 | 0 | 1 | 0 | 1 | 00 | 2022-02-28 | 2022-03-01 | 2022-03-15 | 2022-02-11 | 0 | 2022-02-11 | ? | 0 | 0006480657 | 20220211.ifs | 2022-02-11 | 2022-02-12 | |||||||
4632969 | 4632969 | DIVIDEND | ADD | 637215104 | 0 | 0 | 1 | 9 | 5.25 | 03 | 2021-02-26 | 2021-03-01 | 2021-03-12 | 2021-02-19 | 0 | 2021-02-19 | ? | 1 | 0006265785 | 20210219.ifs | 2021-02-19 | 2021-02-20 | |||||||
4632970 | 4632970 | DIVIDEND | ADD | 637215104 | 0 | 0 | 1 | 0 | 1 | 00 | 2021-02-26 | 2021-03-01 | 2021-03-12 | 2021-02-19 | 0 | 2021-02-19 | ? | 0 | 0006265784 | 20210219.ifs | 2021-02-19 | 2021-02-20 | |||||||
4215179 | 4215179 | DIVIDEND | ADD | 637215104 | 0 | 0 | 1 | 9 | 5 | 03 | 2020-02-28 | 2020-03-02 | 2020-03-13 | 2020-02-21 | 0 | 2020-02-25 | ? | 1 | 0006057827 | 20200225.ifs | 2020-02-25 | 2020-02-26 | |||||||
4215180 | 4215180 | DIVIDEND | ADD | 637215104 | 0 | 0 | 1 | 9 | 5 | 03 | 2020-02-28 | 2020-03-02 | 2020-03-13 | 2020-02-21 | 0 | 2020-02-25 | ? | 1 | 0006057827 | 20200225.ifs | 2020-02-25 | 2020-02-26 | |||||||
4215181 | 4215181 | DIVIDEND | ADD | 637215104 | 0 | 0 | 1 | 0 | 1 | 00 | 2020-02-28 | 2020-03-02 | 2020-03-13 | 2020-02-21 | 0 | 2020-02-25 | ? | 0 | 0006057826 | 20200225.ifs | 2020-02-25 | 2020-02-26 | |||||||
4215182 | 4215182 | DIVIDEND | ADD | 637215104 | 0 | 0 | 1 | 0 | 1 | 00 | 2020-02-28 | 2020-03-02 | 2020-03-13 | 2020-02-21 | 0 | 2020-02-25 | ? | 0 | 0006057826 | 20200225.ifs | 2020-02-25 | 2020-02-26 | |||||||
2951332 | 2951332 | DIVIDEND | ADD | 637215104 | 0 | 0 | 1 | 9 | 5 | 03 | 2018-02-28 | 2018-03-01 | 2018-03-15 | 2018-02-09 | 0 | 2018-02-12 | ? | 1 | 0005614585 | 20180212.ifs | 2018-02-12 | 2018-02-13 | |||||||
2951333 | 2951333 | DIVIDEND | ADD | 637215104 | 0 | 0 | 1 | 0 | 1 | 00 | 2018-02-28 | 2018-03-01 | 2018-03-15 | 2018-02-09 | 0 | 2018-02-12 | ? | 0 | 0005614584 | 20180212.ifs | 2018-02-12 | 2018-02-13 | |||||||
2489363 | 2489363 | DIVIDEND | ADD | 637215104 | 0 | 0 | 1 | 9 | 4.5 | 03 | 2017-02-27 | 2017-03-01 | 2017-03-15 | 2017-02-10 | 0 | 2017-02-13 | ? | 1 | 0005388047 | 20170213.ifs | 2017-02-13 | 2017-02-14 | |||||||
2489364 | 2489364 | DIVIDEND | ADD | 637215104 | 0 | 0 | 1 | 0 | 1 | 00 | 2017-02-27 | 2017-03-01 | 2017-03-15 | 2017-02-10 | 0 | 2017-02-13 | ? | 0 | 0005388046 | 20170213.ifs | 2017-02-13 | 2017-02-14 | |||||||
1791588 | 1791588 | DIVIDEND | ADD | 637215104 | 0 | 0 | 1 | 9 | 3.05 | 03 | 2015-02-26 | 2015-03-02 | 2015-03-13 | 2015-02-13 | 0 | 2015-02-17 | ? | 1 | 0004954966 | 20150217.ifs | 2015-02-17 | 2015-02-18 | |||||||
1791589 | 1791589 | DIVIDEND | ADD | 637215104 | 0 | 0 | 1 | 0 | 1 | 00 | 2015-02-26 | 2015-03-02 | 2015-03-13 | 2015-02-13 | 0 | 2015-02-17 | ? | 0 | 0004954964 | 20150217.ifs | 2015-02-17 | 2015-02-18 | |||||||
1445230 | 1445230 | DIVIDEND | ADD | 637215104 | 0 | 0 | 1 | 9 | 4.05 | 03 | 2014-02-27 | 2014-03-03 | 2014-03-14 | 2014-02-14 | 0 | 2014-02-18 | ? | 1 | 0004737349 | 20140218.ifs | 2014-02-18 | 2014-02-19 | |||||||
1445231 | 1445231 | DIVIDEND | ADD | 637215104 | 0 | 0 | 1 | 0 | 1 | 00 | 2014-02-27 | 2014-03-03 | 2014-03-14 | 2014-02-14 | 0 | 2014-02-18 | ? | 0 | 0004737348 | 20140218.ifs | 2014-02-18 | 2014-02-19 | |||||||
1034212 | 1034212 | DIVIDEND | ADD | 637215104 | 0 | 0 | 1 | 9 | 5.5 | 03 | 2012-12-13 | 2012-12-17 | 2012-12-28 | 2012-12-07 | 0 | 2012-12-10 | ? | 1 | 0004474400 | 20121210.ifs | 2012-12-10 | 2012-12-11 | |||||||
1034213 | 1034213 | DIVIDEND | ADD | 637215104 | 0 | 0 | 1 | 0 | 1 | 00 | 2012-12-13 | 2012-12-17 | 2012-12-28 | 2012-12-07 | 0 | 2012-12-10 | ? | 0 | 0004474399 | 20121210.ifs | 2012-12-10 | 2012-12-11 | |||||||
783980 | 783980 | DIVIDEND | ADD | 637215104 | 0 | 0 | 1 | 9 | 5 | 03 | 2012-02-29 | 2012-03-02 | 2012-03-15 | 2012-02-17 | 0 | 2012-02-23 | ? | 1 | 0004334832 | 20120223.ifs | 2012-02-23 | 2012-02-24 | |||||||
783981 | 783981 | DIVIDEND | ADD | 637215104 | 0 | 0 | 1 | 0 | 1 | 00 | 2012-02-29 | 2012-03-02 | 2012-03-15 | 2012-02-17 | 0 | 2012-02-23 | ? | 0 | 0004334831 | 20120223.ifs | 2012-02-23 | 2012-02-24 | |||||||
450216 | 450216 | DIVIDEND | ADD | 637215104 | 0 | 0 | 1 | 9 | 7.25 | 03 | 2011-03-02 | 2011-03-04 | 2011-03-15 | 2011-02-18 | 0 | 2011-02-23 | ? | 1 | 0004149335 | 20110223.ifs | 2011-02-23 | 2011-02-24 | |||||||
450217 | 450217 | DIVIDEND | ADD | 637215104 | 0 | 0 | 1 | 0 | 1 | 00 | 2011-03-02 | 2011-03-04 | 2011-03-15 | 2011-02-18 | 0 | 2011-02-23 | ? | 0 | 0004149334 | 20110223.ifs | 2011-02-23 | 2011-02-24 | |||||||
114459 | 114459 | DIVIDEND | ADD | 637215104 | 0 | 0 | 1 | 9 | 7.15 | 03 | 2010-03-02 | 2010-03-04 | 2010-03-15 | 2010-02-19 | 0 | 2010-02-22 | ? | 1 | 0003967460 | 20100222.ifs | 2010-02-22 | 2010-04-07 | |||||||
114460 | 114460 | DIVIDEND | ADD | 637215104 | 0 | 0 | 1 | 0 | 1 | 00 | 2010-03-02 | 2010-03-04 | 2010-03-15 | 2010-02-19 | 0 | 2010-02-22 | ? | 0 | 0003967425 | 20100222.ifs | 2010-02-22 | 2010-04-07 |
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 = 136809
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