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:145379 |
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 | ||
5511660 | 5511660 | DIVIDEND | ADD | A11123105 | A | 0 | 3 | 0 | 2.5 | 53 | ? | 2024-03-26 | 2024-03-28 | 2024-03-04 | 0 | 2024-03-04 | ? | 0 | 0006886888 | 20240304.ifs | 2024-03-04 | 2024-03-05 | |||||||
5247117 | 5247117 | DIVIDEND | ADD | A11123105 | A | 0 | 3 | 0 | 2.1 | 53 | ? | 2023-04-03 | 2023-04-05 | 2023-03-10 | 0 | 2023-03-10 | ? | 0 | 0006694621 | 20230310.ifs | 2023-03-10 | 2023-03-11 | |||||||
4973319 | 4973319 | DIVIDEND | ADD | A11123105 | A | 0 | 3 | 0 | 1.65 | 53 | ? | 2022-04-12 | 2022-04-13 | 2022-03-18 | 0 | 2022-03-18 | ? | 0 | 0006496037 | 20220318.ifs | 2022-03-18 | 2022-03-19 | |||||||
4648444 | 4648444 | DIVIDEND | ADD | A11123105 | A | 0 | 3 | 0 | 1 | 53 | ? | 2021-03-29 | 2021-03-30 | 2021-03-05 | 0 | 2021-03-05 | ? | 0 | 0006275501 | 20210305.ifs | 2021-03-05 | 2021-03-06 | |||||||
4392673 | 4392673 | DIVIDEND | DELETE | A11123105 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2020-03-31 | 2020-03-05 | 1 | 2020-03-05 | 2020-03-31 | 0 | 0006066781 | 20200616.ifs | 2020-06-16 | 2020-06-17 | |||||||
4392674 | 4392674 | DIVIDEND | ADD | A11123105 | A | 0 | 3 | 0 | .5 | 53 | ? | 2020-07-10 | 2020-07-13 | 2020-03-05 | 2 | 2020-03-05 | 2020-06-16 | 0 | 0006066781 | 20200616.ifs | 2020-06-16 | 2020-06-17 | |||||||
4263917 | 4263917 | DIVIDEND | DELETE | A11123105 | A | 0 | 3 | 0 | .7 | 53 | ? | 2020-03-30 | 2020-03-31 | 2020-03-05 | 0 | 2020-03-05 | ? | 0 | 0006066781 | 20200331.ifs | 2020-03-31 | 2020-04-01 | |||||||
4263919 | 4263919 | DIVIDEND | ADD | A11123105 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2020-03-31 | 2020-03-05 | 1 | 2020-03-05 | 2020-03-31 | 0 | 0006066781 | 20200331.ifs | 2020-03-31 | 2020-04-01 | |||||||
4263925 | 4263925 | DIVIDEND | DELETE | A11123105 | A | 0 | 3 | 0 | .7 | 53 | ? | 2020-03-30 | 2020-03-31 | 2020-03-05 | 0 | 2020-03-05 | ? | 0 | 0006066781 | 20200331.ifs | 2020-03-31 | 2020-04-01 | |||||||
4263927 | 4263927 | DIVIDEND | ADD | A11123105 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2020-03-31 | 2020-03-05 | 1 | 2020-03-05 | 2020-03-31 | 0 | 0006066781 | 20200331.ifs | 2020-03-31 | 2020-04-01 | |||||||
4233263 | 4233263 | DIVIDEND | ADD | A11123105 | A | 0 | 3 | 0 | .7 | 53 | ? | 2020-03-30 | 2020-03-31 | 2020-03-05 | 0 | 2020-03-05 | ? | 0 | 0006066781 | 20200305.ifs | 2020-03-05 | 2020-03-06 | |||||||
4233370 | 4233370 | DIVIDEND | ADD | A11123105 | A | 0 | 3 | 0 | .7 | 53 | ? | 2020-03-30 | 2020-03-31 | 2020-03-05 | 0 | 2020-03-05 | ? | 0 | 0006066781 | 20200305.ifs | 2020-03-05 | 2020-03-06 | |||||||
3675766 | 3675766 | DIVIDEND | CHANGE | A11123105 | A | 0 | 3 | 0 | 1.55 | 53 | ? | 2019-04-01 | 2019-04-02 | 2019-03-11 | 1 | 2019-03-11 | 2019-04-03 | 0 | 0005851251 | 20190404.ifs | 2019-04-04 | 2019-04-05 | |||||||
3675767 | 3675767 | DIVIDEND | CHANGE | A11123105 | A | 0 | 3 | 0 | 1.55 | 53 | ? | 2019-04-01 | 2019-04-02 | 2019-03-11 | 1 | 2019-03-11 | 2019-04-03 | 0 | 0005851251 | 20190404.ifs | 2019-04-04 | 2019-04-05 | |||||||
3675768 | 3675767 | DIVIDEND | CHANGE | A11123105 | A | 0 | 3 | 0 | 1.55 | 53 | ? | 2019-04-01 | 2019-04-02 | 2019-03-11 | 2 | 2019-03-11 | 2019-04-04 | 0 | 0005851251 | 20190404.ifs | 2019-04-04 | 2019-04-05 | |||||||
3675769 | 3675768 | DIVIDEND | CHANGE | A11123105 | A | 0 | 3 | 0 | 1.55 | 53 | ? | 2019-04-01 | 2019-04-02 | 2019-03-11 | 2 | 2019-03-11 | 2019-04-04 | 0 | 0005851251 | 20190404.ifs | 2019-04-04 | 2019-04-05 | |||||||
3674586 | 3674586 | DIVIDEND | CHANGE | A11123105 | A | 0 | 3 | 0 | 1.55 | 53 | ? | 2019-04-01 | 2019-04-02 | 2019-03-11 | 0 | 2019-03-11 | ? | 0 | 0005851251 | 20190403.ifs | 2019-04-03 | 2019-04-04 | |||||||
3674587 | 3674587 | DIVIDEND | CHANGE | A11123105 | A | 0 | 3 | 0 | 1.55 | 53 | ? | 2019-04-01 | 2019-04-02 | 2019-03-11 | 0 | 2019-03-11 | ? | 0 | 0005851251 | 20190403.ifs | 2019-04-03 | 2019-04-04 | |||||||
3674588 | 3674587 | DIVIDEND | CHANGE | A11123105 | A | 0 | 3 | 0 | 1.55 | 53 | ? | 2019-04-01 | 2019-04-02 | 2019-03-11 | 1 | 2019-03-11 | 2019-04-03 | 0 | 0005851251 | 20190403.ifs | 2019-04-03 | 2019-04-04 | |||||||
3674589 | 3674588 | DIVIDEND | CHANGE | A11123105 | A | 0 | 3 | 0 | 1.55 | 53 | ? | 2019-04-01 | 2019-04-02 | 2019-03-11 | 1 | 2019-03-11 | 2019-04-03 | 0 | 0005851251 | 20190403.ifs | 2019-04-03 | 2019-04-04 | |||||||
3622841 | 3622841 | DIVIDEND | ADD | A11123105 | A | 0 | 3 | 0 | 1.55 | 53 | ? | 2019-04-01 | 2019-04-02 | 2019-03-11 | 0 | 2019-03-11 | ? | 0 | 0005851251 | 20190311.ifs | 2019-03-11 | 2019-03-12 | |||||||
3622936 | 3622936 | DIVIDEND | ADD | A11123105 | A | 0 | 3 | 0 | 1.55 | 53 | ? | 2019-04-01 | 2019-04-02 | 2019-03-11 | 0 | 2019-03-11 | ? | 0 | 0005851251 | 20190311.ifs | 2019-03-11 | 2019-03-12 | |||||||
3013594 | 3013594 | DIVIDEND | CHANGE | A11123105 | A | 0 | 3 | 0 | 1.55 | 53 | 2018-03-27 | 2018-03-28 | 2018-03-29 | 2018-03-05 | 0 | 2018-03-05 | ? | 0 | 0005626940 | 20180329.ifs | 2018-03-29 | 2018-03-30 | |||||||
3013595 | 3013594 | DIVIDEND | CHANGE | A11123105 | A | 0 | 3 | 0 | 1.55 | 53 | 2018-03-27 | 2018-03-28 | 2018-03-29 | 2018-03-05 | 1 | 2018-03-05 | 2018-03-29 | 0 | 0005626940 | 20180329.ifs | 2018-03-29 | 2018-03-30 | |||||||
2981749 | 2981749 | DIVIDEND | ADD | A11123105 | A | 0 | 3 | 0 | 1.55 | 53 | 2018-03-27 | 2018-03-28 | 2018-03-29 | 2018-03-05 | 0 | 2018-03-05 | ? | 0 | 0005626940 | 20180305.ifs | 2018-03-05 | 2018-03-06 | |||||||
2982370 | 2982370 | DIVIDEND | ADD | A11123105 | A | 0 | 3 | 0 | 1.55 | 53 | 2018-03-27 | 2018-03-28 | 2018-03-29 | 2018-03-05 | 0 | 2018-03-05 | ? | 0 | 0005626940 | 20180305.ifs | 2018-03-05 | 2018-03-06 | |||||||
2530851 | 2530851 | DIVIDEND | CHANGE | A11123105 | A | 0 | 3 | 0 | 1.5 | 53 | 2017-03-30 | 2017-03-31 | 2017-04-03 | 2017-03-09 | 0 | 2017-03-09 | ? | 0 | 0005401051 | 20170403.ifs | 2017-04-03 | 2017-04-04 | |||||||
2530852 | 2530851 | DIVIDEND | CHANGE | A11123105 | A | 0 | 3 | 0 | 1.5 | 53 | 2017-03-30 | 2017-03-31 | 2017-04-03 | 2017-03-09 | 1 | 2017-03-09 | 2017-04-03 | 0 | 0005401051 | 20170403.ifs | 2017-04-03 | 2017-04-04 | |||||||
2509900 | 2509900 | DIVIDEND | ADD | A11123105 | A | 0 | 3 | 0 | 1.5 | 53 | 2017-03-30 | 2017-03-31 | 2017-04-03 | 2017-03-09 | 0 | 2017-03-09 | ? | 0 | 0005401051 | 20170309.ifs | 2017-03-09 | 2017-03-10 | |||||||
2159642 | 2159642 | DIVIDEND | CHANGE | A11123105 | A | 0 | 3 | 0 | 1.35 | 53 | 2016-04-01 | 2016-04-04 | 2016-04-05 | 2016-03-09 | 1 | 2016-03-09 | 2016-03-10 | 0 | 0005185681 | 20160406.ifs | 2016-04-06 | 2016-04-07 | |||||||
2159643 | 2159642 | DIVIDEND | CHANGE | A11123105 | A | 0 | 3 | 0 | 1.35 | 53 | 2016-04-01 | 2016-04-04 | 2016-04-05 | 2016-03-09 | 2 | 2016-03-09 | 2016-04-06 | 0 | 0005185681 | 20160406.ifs | 2016-04-06 | 2016-04-07 | |||||||
2133041 | 2133041 | DIVIDEND | DELETE | A11123105 | A | 0 | 3 | 0 | 1.35 | 53 | ? | 2016-04-04 | 2016-04-05 | 2016-03-09 | 0 | 2016-03-09 | ? | 0 | 0005185681 | 20160310.ifs | 2016-03-10 | 2016-03-11 | |||||||
2133042 | 2133042 | DIVIDEND | ADD | A11123105 | A | 0 | 3 | 0 | 1.35 | 53 | 2016-04-01 | 2016-04-04 | 2016-04-05 | 2016-03-09 | 1 | 2016-03-09 | 2016-03-10 | 0 | 0005185681 | 20160310.ifs | 2016-03-10 | 2016-03-11 | |||||||
2132427 | 2132427 | DIVIDEND | ADD | A11123105 | A | 0 | 3 | 0 | 1.35 | 53 | ? | 2016-04-04 | 2016-04-05 | 2016-03-09 | 0 | 2016-03-09 | ? | 0 | 0005185681 | 20160309.ifs | 2016-03-09 | 2016-03-10 | |||||||
1836036 | 1836036 | DIVIDEND | ADD | A11123105 | A | 0 | 3 | 0 | 1 | 53 | ? | 2015-03-30 | 2015-04-02 | 2015-03-10 | 0 | ? | 2015-04-07 | 0 | 0004966977 | 20150407.ifs | 2015-04-07 | 2015-04-08 | |||||||
1460857 | 1460857 | DIVIDEND | ADD | A11123105 | A | 0 | 3 | 0 | .5 | 53 | ? | 2014-03-24 | 2014-03-27 | 2014-03-05 | 0 | 2014-03-05 | ? | 0 | 0004748036 | 20140305.ifs | 2014-03-05 | 2014-03-06 | |||||||
1131311 | 1131311 | DIVIDEND | ADD | A11123105 | A | 0 | 3 | 1 | 1.2 | 44 | ? | 2013-03-25 | 2013-03-28 | 2013-03-12 | 0 | 2013-03-12 | ? | 0 | 0004540415 | 20130312.ifs | 2013-03-12 | 2013-03-13 | |||||||
835821 | 835821 | DIVIDEND | DELETE | A11123105 | 0 | 0 | 6 | 0 | 1 | 11 | 2012-04-23 | 2012-04-20 | 2012-04-23 | 2012-04-13 | 0 | 2012-04-13 | ? | 0 | 0004361353 | 20120416.ifs | 2012-04-16 | 2012-04-17 | |||||||
835822 | 835822 | DIVIDEND | ADD | A11123105 | 0 | 0 | 5 | 0 | 1 | 10 | 2012-04-23 | 2012-04-20 | 2012-04-23 | 2012-04-13 | 1 | 2012-04-13 | 2012-04-16 | 0 | 0004361353 | 20120416.ifs | 2012-04-16 | 2012-04-17 | |||||||
835823 | 835823 | SPLIT | CHANGE | A11123105 | .5 | 2012-04-23 | 11 | 2012-04-13 | ? | 20120416.ifs | 2012-04-16 | 2012-04-17 | |||||||||||||||||
835824 | 835823 | SPLIT | CHANGE | A11123105 | .5 | 2012-04-23 | 10 | 2012-04-13 | 2012-04-16 | 20120416.ifs | 2012-04-16 | 2012-04-17 | |||||||||||||||||
834990 | 834990 | DIVIDEND | ADD | A11123105 | 0 | 0 | 6 | 0 | 1 | 11 | 2012-04-23 | 2012-04-20 | 2012-04-23 | 2012-04-13 | 0 | 2012-04-13 | ? | 0 | 0004361353 | 20120413.ifs | 2012-04-13 | 2012-04-14 | |||||||
834991 | 834991 | SPLIT | ADD | A11123105 | .5 | 2012-04-23 | 11 | 2012-04-13 | ? | 20120413.ifs | 2012-04-13 | 2012-04-14 | |||||||||||||||||
802643 | 802643 | DIVIDEND | ADD | A11123105 | A | 0 | 3 | 0 | 2.2 | 53 | ? | 2012-03-23 | 2012-03-28 | 2012-03-15 | 0 | 2012-03-15 | ? | 0 | 0004345639 | 20120315.ifs | 2012-03-15 | 2012-03-16 | |||||||
470507 | 470507 | EQUITY | CHANGE | A11123105 | ORD | 0 | 0 | 2002-09-06 | ? | 0 | no | no | no | 2002-10-31 | 2002-09-09 | ? | 20110314.ifs | 2011-03-14 | 2011-03-15 | ||||||||||
470508 | 470507 | EQUITY | CHANGE | A11123105 | ORD | 0 | 0 | 2002-09-06 | ? | 1 | no | no | no | 2002-10-31 | 2011-03-14 | ? | 20110314.ifs | 2011-03-14 | 2011-03-15 | ||||||||||
469314 | 469314 | DIVIDEND | ADD | A11123105 | A | 0 | 3 | 0 | 1.7 | 53 | ? | 2011-03-30 | 2011-04-04 | 2011-03-10 | 0 | 2011-03-10 | ? | 0 | 0004158676 | 20110310.ifs | 2011-03-10 | 2011-03-11 | |||||||
131161 | 131161 | DIVIDEND | ADD | A11123105 | A | 0 | 3 | 4 | 1 | 53 | ? | 2010-03-29 | 2010-04-01 | 2010-03-11 | 0 | 2010-03-11 | ? | 0 | 0003977280 | 20100311.ifs | 2010-03-11 | 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 = 145379
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