INSITITUIONS | Dynamic | newInstitTable | Changed the Cusip/Sector/Shs Out? |
|
|||||||
Total Insititutions : | 1 | 1 | Update Insititution By Cusips | ||||||||
% Owned by Insititutions: | 0.00 % | 0 % | |||||||||
pricingQuarterAdminPageOn:
|
2024-03-31 | New % | |||||||||
|
|||||||||||
the compid is:147566 |
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 | ||
5574336 | 5574336 | DIVIDEND | ADD | J95776126 | 0 | 0 | 3 | 6 | 0 | 08 | ? | 2024-06-30 | ? | 2024-06-11 | 0 | 2024-06-11 | ? | 0 | 0006931585 | 20240611.ifs | 2024-06-11 | 2024-06-12 | |||||||
5521777 | 5521777 | DIVIDEND | ADD | J95776126 | A | 0 | 3 | 0 | 72.5 | 44 | ? | 2024-12-31 | 2024-12-22 | 2024-03-22 | 0 | 2024-03-22 | ? | 0 | 0006894181 | 20240322.ifs | 2024-03-22 | 2024-03-23 | |||||||
5437754 | 5437754 | DIVIDEND | ADD | J95776126 | 0 | 0 | 6 | 0 | 2 | 11 | 2023-12-28 | 2023-12-31 | 2024-01-01 | 2023-12-13 | 0 | 2023-12-13 | ? | 0 | 0006830402 | 20231213.ifs | 2023-12-13 | 2023-12-14 | |||||||
5437755 | 5437755 | SPLIT | ADD | J95776126 | .3333333333 | 2023-12-28 | 11 | 2023-12-13 | ? | 20231213.ifs | 2023-12-13 | 2023-12-14 | |||||||||||||||||
5424014 | 5424014 | DIVIDEND | ADD | J95776126 | 0 | 0 | 3 | 6 | 0 | 08 | ? | 2023-12-31 | ? | 2023-12-01 | 0 | 2023-12-01 | ? | 0 | 0006820776 | 20231201.ifs | 2023-12-01 | 2023-12-02 | |||||||
5370287 | 5370287 | DIVIDEND | DELETE | J95776126 | 0 | 0 | 3 | 6 | 0 | 08 | ? | 2023-06-30 | ? | 2023-06-02 | 0 | 2023-06-02 | ? | 0 | 0006735847 | 20230908.ifs | 2023-09-08 | 2023-09-09 | |||||||
5370288 | 5370288 | DIVIDEND | ADD | J95776126 | A | 0 | 3 | 0 | 72.5 | 53 | ? | 2023-06-30 | 2023-09-08 | 2023-06-02 | 1 | 2023-06-02 | 2023-09-08 | 0 | 0006735847 | 20230908.ifs | 2023-09-08 | 2023-09-09 | |||||||
5305601 | 5305601 | DIVIDEND | ADD | J95776126 | 0 | 0 | 3 | 6 | 0 | 08 | ? | 2023-06-30 | ? | 2023-06-02 | 0 | 2023-06-02 | ? | 0 | 0006735847 | 20230602.ifs | 2023-06-02 | 2023-06-03 | |||||||
5253512 | 5253512 | DIVIDEND | DELETE | J95776126 | 0 | 0 | 3 | 6 | 0 | 08 | ? | 2022-12-31 | ? | 2022-12-07 | 0 | 2022-12-07 | ? | 0 | 0006624581 | 20230323.ifs | 2023-03-23 | 2023-03-24 | |||||||
5253513 | 5253513 | DIVIDEND | ADD | J95776126 | A | 0 | 3 | 0 | 67.5 | 53 | ? | 2022-12-31 | 2023-03-23 | 2022-12-07 | 1 | 2022-12-07 | 2023-03-23 | 0 | 0006624581 | 20230323.ifs | 2023-03-23 | 2023-03-24 | |||||||
5156358 | 5156358 | DIVIDEND | ADD | J95776126 | 0 | 0 | 3 | 6 | 0 | 08 | ? | 2022-12-31 | ? | 2022-12-07 | 0 | 2022-12-07 | ? | 0 | 0006624581 | 20221207.ifs | 2022-12-07 | 2022-12-08 | |||||||
5094596 | 5094596 | DIVIDEND | DELETE | J95776126 | 0 | 0 | 3 | 6 | 0 | 08 | ? | 2022-06-30 | ? | 2022-06-07 | 0 | 2022-06-07 | ? | 0 | 0006535737 | 20220909.ifs | 2022-09-09 | 2022-09-10 | |||||||
5094597 | 5094597 | DIVIDEND | ADD | J95776126 | A | 0 | 3 | 0 | 57.5 | 53 | ? | 2022-06-30 | 2022-09-09 | 2022-06-07 | 1 | 2022-06-07 | 2022-09-09 | 0 | 0006535737 | 20220909.ifs | 2022-09-09 | 2022-09-10 | |||||||
5028773 | 5028773 | DIVIDEND | ADD | J95776126 | 0 | 0 | 3 | 6 | 0 | 08 | ? | 2022-06-30 | ? | 2022-06-07 | 0 | 2022-06-07 | ? | 0 | 0006535737 | 20220607.ifs | 2022-06-07 | 2022-06-08 | |||||||
4976742 | 4976742 | DIVIDEND | DELETE | J95776126 | 0 | 0 | 3 | 6 | 0 | 08 | ? | 2021-12-31 | ? | 2021-12-09 | 0 | 2021-12-09 | ? | 0 | 0006414627 | 20220324.ifs | 2022-03-24 | 2022-03-25 | |||||||
4976743 | 4976743 | DIVIDEND | ADD | J95776126 | A | 0 | 3 | 0 | 65 | 53 | ? | 2021-12-31 | 2022-03-24 | 2021-12-09 | 1 | 2021-12-09 | 2022-03-24 | 0 | 0006414627 | 20220324.ifs | 2022-03-24 | 2022-03-25 | |||||||
4872956 | 4872956 | DIVIDEND | ADD | J95776126 | 0 | 0 | 3 | 6 | 0 | 08 | ? | 2021-12-31 | ? | 2021-12-09 | 0 | 2021-12-09 | ? | 0 | 0006414627 | 20211209.ifs | 2021-12-09 | 2021-12-10 | |||||||
4813238 | 4813238 | DIVIDEND | DELETE | J95776126 | 0 | 0 | 3 | 6 | 0 | 08 | ? | 2021-09-30 | ? | 2021-09-02 | 0 | 2021-09-02 | ? | 0 | 0006364449 | 20210930.ifs | 2021-09-30 | 2021-10-01 | |||||||
4799981 | 4799981 | DIVIDEND | DELETE | J95776126 | 0 | 1 | 3 | 6 | 0 | 08 | ? | 2021-06-30 | ? | 2021-08-05 | 0 | 2021-08-05 | ? | 0 | 0006352335 | 20210910.ifs | 2021-09-10 | 2021-09-11 | |||||||
4799982 | 4799982 | DIVIDEND | ADD | J95776126 | A | 1 | 3 | 0 | 50 | 53 | ? | 2021-06-30 | 2021-09-10 | 2021-08-05 | 1 | 2021-08-05 | 2021-09-10 | 0 | 0006352335 | 20210910.ifs | 2021-09-10 | 2021-09-11 | |||||||
4796100 | 4796100 | DIVIDEND | ADD | J95776126 | 0 | 0 | 3 | 6 | 0 | 08 | ? | 2021-09-30 | ? | 2021-09-02 | 0 | 2021-09-02 | ? | 0 | 0006364449 | 20210902.ifs | 2021-09-02 | 2021-09-03 | |||||||
4777504 | 4777504 | DIVIDEND | ADD | J95776126 | 0 | 1 | 3 | 6 | 0 | 08 | ? | 2021-06-30 | ? | 2021-08-05 | 0 | 2021-08-05 | ? | 0 | 0006352335 | 20210805.ifs | 2021-08-05 | 2021-08-06 | |||||||
4663155 | 4663155 | DIVIDEND | DELETE | J95776126 | 0 | 0 | 3 | 6 | 0 | 08 | ? | 2020-12-31 | ? | 2020-12-04 | 0 | 2020-12-04 | ? | 0 | 0006200554 | 20210326.ifs | 2021-03-26 | 2021-03-27 | |||||||
4663156 | 4663156 | DIVIDEND | ADD | J95776126 | A | 0 | 3 | 0 | 60 | 53 | ? | 2020-12-31 | 2021-03-25 | 2020-12-04 | 1 | 2020-12-04 | 2021-03-26 | 0 | 0006200554 | 20210326.ifs | 2021-03-26 | 2021-03-27 | |||||||
4663157 | 4663157 | EQUITY | CHANGE | J95776126 | ORD | 0 | 0 | 2005-07-08 | ? | 0 | no | no | no | 2005-07-12 | 2005-07-11 | ? | 20210326.ifs | 2021-03-26 | 2021-03-27 | ||||||||||
4663158 | 4663157 | EQUITY | CHANGE | J95776126 | ORD | 0 | 0 | 2005-07-08 | ? | 7 | no | no | no | 2005-07-12 | 2005-07-11 | ? | 20210326.ifs | 2021-03-26 | 2021-03-27 | ||||||||||
4526920 | 4526920 | DIVIDEND | ADD | J95776126 | 0 | 0 | 3 | 6 | 0 | 08 | ? | 2020-12-31 | ? | 2020-12-04 | 0 | 2020-12-04 | ? | 0 | 0006200554 | 20201204.ifs | 2020-12-04 | 2020-12-05 | |||||||
4357553 | 4357553 | DIVIDEND | ADD | J95776126 | 0 | 0 | 3 | 6 | 0 | 08 | ? | 2020-06-30 | ? | 2020-06-01 | 0 | 2020-06-01 | ? | 0 | 0006107281 | 20200601.ifs | 2020-06-01 | 2020-06-02 | |||||||
4361947 | 4361947 | DIVIDEND | ADD | J95776126 | 0 | 0 | 3 | 6 | 0 | 08 | ? | 2020-06-30 | ? | 2020-06-01 | 0 | 2020-06-01 | ? | 0 | 0006107281 | 20200601.ifs | 2020-06-01 | 2020-06-02 | |||||||
4366341 | 4366341 | DIVIDEND | ADD | J95776126 | 0 | 0 | 3 | 6 | 0 | 08 | ? | 2020-06-30 | ? | 2020-06-01 | 0 | 2020-06-01 | ? | 0 | 0006107281 | 20200601.ifs | 2020-06-01 | 2020-06-02 | |||||||
4370735 | 4370735 | DIVIDEND | ADD | J95776126 | 0 | 0 | 3 | 6 | 0 | 08 | ? | 2020-06-30 | ? | 2020-06-01 | 0 | 2020-06-01 | ? | 0 | 0006107281 | 20200601.ifs | 2020-06-01 | 2020-06-02 | |||||||
4375129 | 4375129 | DIVIDEND | ADD | J95776126 | 0 | 0 | 3 | 6 | 0 | 08 | ? | 2020-06-30 | ? | 2020-06-01 | 0 | 2020-06-01 | ? | 0 | 0006107281 | 20200601.ifs | 2020-06-01 | 2020-06-02 | |||||||
4379523 | 4379523 | DIVIDEND | ADD | J95776126 | 0 | 0 | 3 | 6 | 0 | 08 | ? | 2020-06-30 | ? | 2020-06-01 | 0 | 2020-06-01 | ? | 0 | 0006107281 | 20200601.ifs | 2020-06-01 | 2020-06-02 | |||||||
4160487 | 4160487 | DIVIDEND | DELETE | J95776126 | 0 | 0 | 3 | 6 | 0 | 08 | ? | 2019-12-31 | ? | 2019-12-05 | 0 | 2019-12-05 | ? | 0 | 0005987839 | 20200103.ifs | 2020-01-03 | 2020-01-04 | |||||||
4160494 | 4160494 | DIVIDEND | DELETE | J95776126 | 0 | 0 | 3 | 6 | 0 | 08 | ? | 2019-12-31 | ? | 2019-12-05 | 0 | 2019-12-05 | ? | 0 | 0005987839 | 20200103.ifs | 2020-01-03 | 2020-01-04 | |||||||
4041806 | 4041806 | DIVIDEND | ADD | J95776126 | 0 | 0 | 3 | 6 | 0 | 08 | ? | 2019-12-31 | ? | 2019-12-05 | 0 | 2019-12-05 | ? | 0 | 0005987839 | 20191205.ifs | 2019-12-05 | 2019-12-06 | |||||||
4041807 | 4041807 | DIVIDEND | ADD | J95776126 | 0 | 0 | 3 | 6 | 0 | 08 | ? | 2019-12-31 | ? | 2019-12-05 | 0 | 2019-12-05 | ? | 0 | 0005987839 | 20191205.ifs | 2019-12-05 | 2019-12-06 | |||||||
3878488 | 3878488 | DIVIDEND | ADD | J95776126 | 0 | 1 | 3 | 6 | 0 | 08 | ? | 2019-06-30 | ? | 2019-08-13 | 0 | 2019-08-13 | ? | 0 | 0005930221 | 20190813.ifs | 2019-08-13 | 2019-08-14 | |||||||
3878489 | 3878489 | DIVIDEND | ADD | J95776126 | 0 | 1 | 3 | 6 | 0 | 08 | ? | 2019-06-30 | ? | 2019-08-13 | 0 | 2019-08-13 | ? | 0 | 0005930221 | 20190813.ifs | 2019-08-13 | 2019-08-14 | |||||||
3647392 | 3647392 | DIVIDEND | DELETE | J95776126 | 0 | 0 | 3 | 6 | 0 | 08 | ? | 2019-03-31 | ? | 2019-03-08 | 0 | 2019-03-08 | ? | 0 | 0005850863 | 20190326.ifs | 2019-03-26 | 2019-03-27 | |||||||
3647393 | 3647393 | DIVIDEND | DELETE | J95776126 | 0 | 0 | 3 | 6 | 0 | 08 | ? | 2019-03-31 | ? | 2019-03-08 | 0 | 2019-03-08 | ? | 0 | 0005850863 | 20190326.ifs | 2019-03-26 | 2019-03-27 | |||||||
3621284 | 3621284 | DIVIDEND | ADD | J95776126 | 0 | 0 | 3 | 6 | 0 | 08 | ? | 2019-03-31 | ? | 2019-03-08 | 0 | 2019-03-08 | ? | 0 | 0005850863 | 20190308.ifs | 2019-03-08 | 2019-03-09 | |||||||
3621285 | 3621285 | DIVIDEND | ADD | J95776126 | 0 | 0 | 3 | 6 | 0 | 08 | ? | 2019-03-31 | ? | 2019-03-08 | 0 | 2019-03-08 | ? | 0 | 0005850863 | 20190308.ifs | 2019-03-08 | 2019-03-09 | |||||||
3028649 | 3028649 | DIVIDEND | CHANGE | J95776126 | 0 | 0 | 3 | 6 | 0 | 08 | ? | 2018-03-31 | ? | 2018-03-02 | 0 | 2018-03-02 | ? | 0 | 0005626289 | 20180404.ifs | 2018-04-04 | 2018-04-05 | |||||||
3028651 | 3028650 | DIVIDEND | CHANGE | J95776126 | 0 | 0 | 3 | 6 | 0 | 08 | ? | 2018-03-31 | ? | 2018-03-02 | 1 | 2018-03-02 | 2018-04-04 | 0 | 0005626289 | 20180404.ifs | 2018-04-04 | 2018-04-05 | |||||||
3028786 | 3028786 | DIVIDEND | CHANGE | J95776126 | 0 | 0 | 3 | 6 | 0 | 08 | ? | 2018-03-31 | ? | 2018-03-02 | 0 | 2018-03-02 | ? | 0 | 0005626289 | 20180404.ifs | 2018-04-04 | 2018-04-05 | |||||||
3028788 | 3028787 | DIVIDEND | CHANGE | J95776126 | 0 | 0 | 3 | 6 | 0 | 08 | ? | 2018-03-31 | ? | 2018-03-02 | 1 | 2018-03-02 | 2018-04-04 | 0 | 0005626289 | 20180404.ifs | 2018-04-04 | 2018-04-05 | |||||||
2979802 | 2979802 | DIVIDEND | ADD | J95776126 | 0 | 0 | 3 | 6 | 0 | 08 | ? | 2018-03-31 | ? | 2018-03-02 | 0 | 2018-03-02 | ? | 0 | 0005626289 | 20180302.ifs | 2018-03-02 | 2018-03-03 | |||||||
2979809 | 2979809 | DIVIDEND | ADD | J95776126 | 0 | 0 | 3 | 6 | 0 | 08 | ? | 2018-03-31 | ? | 2018-03-02 | 0 | 2018-03-02 | ? | 0 | 0005626289 | 20180302.ifs | 2018-03-02 | 2018-03-03 |
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 = 147566
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