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:146366 |
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 | ||
5558559 | 5558559 | DIVIDEND | CHANGE | Y38472125 | 0 | 0 | 1 | 0 | .729298 | 0 | 00 | ? | 2024-03-31 | 2024-05-14 | 2024-03-22 | 0 | ? | 2024-05-15 | 0 | 0006895559 | 20240516.ifs | 2024-05-16 | 2024-05-17 | ||||||
5558560 | 5558559 | DIVIDEND | CHANGE | Y38472125 | No Ex-Date set by OTC. | 0 | 0 | 1 | 0 | .729298 | 0 | 00 | ? | 2024-03-31 | 2024-05-14 | 2024-03-22 | 0 | ? | 2024-05-16 | 0 | 0006895559 | 20240516.ifs | 2024-05-16 | 2024-05-17 | |||||
5558106 | 5558106 | DIVIDEND | DELETE | Y38472125 | 0 | 0 | 1 | 6 | 0 | 0 | 08 | ? | 2024-03-31 | ? | 2024-03-22 | 0 | ? | 2024-04-30 | 0 | 0006895559 | 20240515.ifs | 2024-05-15 | 2024-05-16 | ||||||
5558107 | 5558107 | DIVIDEND | ADD | Y38472125 | 0 | 0 | 1 | 0 | .729298 | 0 | 00 | ? | 2024-03-31 | 2024-05-14 | 2024-03-22 | 0 | ? | 2024-05-15 | 0 | 0006895559 | 20240515.ifs | 2024-05-15 | 2024-05-16 | ||||||
5545243 | 5545243 | DIVIDEND | DELETE | Y38472125 | 0 | 0 | 1 | 6 | 0 | 08 | ? | 2024-03-31 | ? | 2024-03-26 | 0 | 2024-03-26 | ? | 0 | 0006895559 | 20240430.ifs | 2024-04-30 | 2024-05-01 | |||||||
5545244 | 5545244 | DIVIDEND | ADD | Y38472125 | 0 | 0 | 1 | 6 | 0 | 0 | 08 | ? | 2024-03-31 | ? | 2024-03-22 | 0 | ? | 2024-04-30 | 0 | 0006895559 | 20240430.ifs | 2024-04-30 | 2024-05-01 | ||||||
5544644 | 5544644 | DIVIDEND | ADD | Y38472125 | 0 | 1 | 1 | 0 | 3.032695 | 14 | ? | 2024-02-29 | 2024-04-19 | 2024-04-29 | 0 | 2024-04-29 | ? | 0 | 0006910183 | 20240429.ifs | 2024-04-29 | 2024-04-30 | |||||||
5523553 | 5523553 | DIVIDEND | ADD | Y38472125 | 0 | 0 | 1 | 6 | 0 | 08 | ? | 2024-03-31 | ? | 2024-03-26 | 0 | 2024-03-26 | ? | 0 | 0006895559 | 20240326.ifs | 2024-03-26 | 2024-03-27 | |||||||
5357212 | 5357212 | DIVIDEND | ADD | Y38472125 | 0 | 1 | 1 | 0 | .562999 | 14 | ? | 2023-06-30 | 2023-08-21 | 2023-08-23 | 0 | 2023-08-23 | ? | 0 | 0006771024 | 20230823.ifs | 2023-08-23 | 2023-08-24 | |||||||
5285558 | 5285558 | DIVIDEND | ADD | Y38472125 | 0 | 1 | 1 | 0 | 2.272283 | 14 | ? | 2023-01-03 | 2023-04-28 | 2023-05-02 | 0 | 2023-05-02 | ? | 0 | 0006722608 | 20230502.ifs | 2023-05-02 | 2023-05-03 | |||||||
5087575 | 5087575 | DIVIDEND | CHANGE | Y38472125 | 0 | 0 | 1 | 0 | .382409 | 0 | 00 | ? | 2022-06-30 | 2022-08-09 | 2022-06-15 | 2 | 2022-06-15 | 2022-08-31 | 0 | 0006538707 | 20220901.ifs | 2022-09-01 | 2022-09-02 | ||||||
5087576 | 5087575 | DIVIDEND | CHANGE | Y38472125 | No Ex-Date set by OTC | 0 | 0 | 1 | 0 | .382409 | 0 | 00 | ? | 2022-06-30 | 2022-08-09 | 2022-06-15 | 2 | 2022-06-15 | 2022-09-01 | 0 | 0006538707 | 20220901.ifs | 2022-09-01 | 2022-09-02 | |||||
5085326 | 5085326 | DIVIDEND | CHANGE | Y38472125 | No Ex-Date set by OTC. | 0 | 0 | 1 | 0 | .382409 | 0 | 00 | ? | 2022-06-30 | 2022-08-09 | 2022-06-15 | 1 | 2022-06-15 | 2022-08-19 | 0 | 0006538707 | 20220831.ifs | 2022-08-31 | 2022-09-01 | |||||
5085327 | 5085326 | DIVIDEND | CHANGE | Y38472125 | 0 | 0 | 1 | 0 | .382409 | 0 | 00 | ? | 2022-06-30 | 2022-08-09 | 2022-06-15 | 2 | 2022-06-15 | 2022-08-31 | 0 | 0006538707 | 20220831.ifs | 2022-08-31 | 2022-09-01 | ||||||
5079790 | 5079790 | DIVIDEND | CHANGE | Y38472125 | 0 | 0 | 1 | 0 | .382409 | 00 | ? | 2022-06-30 | 2022-08-09 | 2022-06-15 | 1 | 2022-06-15 | 2022-08-18 | 0 | 0006538707 | 20220819.ifs | 2022-08-19 | 2022-08-20 | |||||||
5079791 | 5079790 | DIVIDEND | CHANGE | Y38472125 | No Ex-Date set by OTC. | 0 | 0 | 1 | 0 | .382409 | 0 | 00 | ? | 2022-06-30 | 2022-08-09 | 2022-06-15 | 1 | 2022-06-15 | 2022-08-19 | 0 | 0006538707 | 20220819.ifs | 2022-08-19 | 2022-08-20 | |||||
5079156 | 5079156 | DIVIDEND | DELETE | Y38472125 | 0 | 0 | 1 | 6 | 0 | 08 | ? | 2022-06-30 | ? | 2022-06-15 | 0 | 2022-06-15 | ? | 0 | 0006538707 | 20220818.ifs | 2022-08-18 | 2022-08-19 | |||||||
5079157 | 5079157 | DIVIDEND | ADD | Y38472125 | 0 | 0 | 1 | 0 | .382409 | 00 | ? | 2022-06-30 | 2022-08-09 | 2022-06-15 | 1 | 2022-06-15 | 2022-08-18 | 0 | 0006538707 | 20220818.ifs | 2022-08-18 | 2022-08-19 | |||||||
5033058 | 5033058 | DIVIDEND | ADD | Y38472125 | 0 | 0 | 1 | 6 | 0 | 08 | ? | 2022-06-30 | ? | 2022-06-15 | 0 | 2022-06-15 | ? | 0 | 0006538707 | 20220615.ifs | 2022-06-15 | 2022-06-16 | |||||||
4997487 | 4997487 | DIVIDEND | DELETE | Y38472125 | 0 | 0 | 1 | 6 | 0 | 08 | ? | 2021-12-31 | ? | 2021-12-16 | 0 | 2021-12-16 | ? | 0 | 0006430284 | 20220425.ifs | 2022-04-25 | 2022-04-26 | |||||||
4997488 | 4997488 | DIVIDEND | ADD | Y38472125 | 0 | 0 | 1 | 0 | 1.624913 | 00 | ? | 2021-12-31 | 2022-04-29 | 2021-12-16 | 1 | 2021-12-16 | 2022-04-25 | 0 | 0006430284 | 20220425.ifs | 2022-04-25 | 2022-04-26 | |||||||
4890320 | 4890320 | DIVIDEND | ADD | Y38472125 | 0 | 0 | 1 | 6 | 0 | 08 | ? | 2021-12-31 | ? | 2021-12-16 | 0 | 2021-12-16 | ? | 0 | 0006430284 | 20211216.ifs | 2021-12-16 | 2021-12-17 | |||||||
4780639 | 4780639 | DIVIDEND | CHANGE | Y38472125 | 0 | 0 | 1 | 0 | .434816 | 00 | ? | 2021-06-30 | 2021-08-17 | 2021-06-16 | 1 | 2021-06-16 | 2021-08-11 | 0 | 0006323005 | 20210812.ifs | 2021-08-12 | 2021-08-13 | |||||||
4780640 | 4780639 | DIVIDEND | CHANGE | Y38472125 | No Ex-Date set by OTC. | 0 | 0 | 1 | 0 | .434816 | 0 | 00 | ? | 2021-06-30 | 2021-08-17 | 2021-06-16 | 1 | 2021-06-16 | 2021-08-12 | 0 | 0006323005 | 20210812.ifs | 2021-08-12 | 2021-08-13 | |||||
4780324 | 4780324 | DIVIDEND | DELETE | Y38472125 | 0 | 0 | 1 | 6 | 0 | 08 | ? | 2021-06-30 | ? | 2021-06-16 | 0 | 2021-06-16 | ? | 0 | 0006323005 | 20210811.ifs | 2021-08-11 | 2021-08-12 | |||||||
4780325 | 4780325 | DIVIDEND | ADD | Y38472125 | 0 | 0 | 1 | 0 | .434816 | 00 | ? | 2021-06-30 | 2021-08-17 | 2021-06-16 | 1 | 2021-06-16 | 2021-08-11 | 0 | 0006323005 | 20210811.ifs | 2021-08-11 | 2021-08-12 | |||||||
4730581 | 4730581 | DIVIDEND | ADD | Y38472125 | 0 | 0 | 1 | 6 | 0 | 08 | ? | 2021-06-30 | ? | 2021-06-16 | 0 | 2021-06-16 | ? | 0 | 0006323005 | 20210616.ifs | 2021-06-16 | 2021-06-17 | |||||||
4687604 | 4687604 | DIVIDEND | CHANGE | Y38472125 | 0 | 1 | 1 | 0 | 1.362361 | 14 | ? | 2020-12-31 | 2021-04-30 | 2021-04-07 | 1 | 2021-04-07 | 2021-04-23 | 0 | 0006293365 | 20210426.ifs | 2021-04-26 | 2021-04-27 | |||||||
4687605 | 4687604 | DIVIDEND | CHANGE | Y38472125 | No Ex-Date set by NBB | 0 | 1 | 1 | 0 | 1.362361 | 0 | 14 | ? | 2020-12-31 | 2021-04-30 | 2021-04-07 | 1 | 2021-04-07 | 2021-04-26 | 0 | 0006293365 | 20210426.ifs | 2021-04-26 | 2021-04-27 | |||||
4687229 | 4687229 | DIVIDEND | DELETE | Y38472125 | 0 | 1 | 1 | 6 | 0 | 08 | ? | 2020-12-31 | ? | 2021-04-07 | 0 | 2021-04-07 | ? | 0 | 0006293365 | 20210423.ifs | 2021-04-23 | 2021-04-24 | |||||||
4687230 | 4687230 | DIVIDEND | ADD | Y38472125 | 0 | 1 | 1 | 0 | 1.362361 | 14 | ? | 2020-12-31 | 2021-04-30 | 2021-04-07 | 1 | 2021-04-07 | 2021-04-23 | 0 | 0006293365 | 20210423.ifs | 2021-04-23 | 2021-04-24 | |||||||
4677840 | 4677840 | DIVIDEND | ADD | Y38472125 | 0 | 1 | 1 | 6 | 0 | 08 | ? | 2020-12-31 | ? | 2021-04-07 | 0 | 2021-04-07 | ? | 0 | 0006293365 | 20210407.ifs | 2021-04-07 | 2021-04-08 | |||||||
4646742 | 4646742 | CORPACTION | ADD | Y38472125 | 66 | D | 2021-03-03 | ? | 20210303.ifs | 2021-03-03 | 2021-03-04 | ||||||||||||||||||
4646743 | 4646743 | EQUITY | CHANGE | Y38472125 | ORD | 0 | 0 | 2005-05-19 | ? | 2 | no | no | no | 2005-05-25 | 2005-05-20 | ? | 20210303.ifs | 2021-03-03 | 2021-03-04 | ||||||||||
4646744 | 4646743 | EQUITY | CHANGE | Y38472125 | ORD | D | 0 | 2005-05-19 | 2021-03-03 | 2 | no | no | no | 2005-05-25 | 2021-03-03 | ? | 20210303.ifs | 2021-03-03 | 2021-03-04 | ||||||||||
4646794 | 4646794 | CORPACTION | DELETE | Y38472125 | 66 | D | 2021-03-03 | ? | 20210303.ifs | 2021-03-03 | 2021-03-04 | ||||||||||||||||||
4646795 | 4646795 | EQUITY | CHANGE | Y38472125 | ORD | D | 0 | 2005-05-19 | 2021-03-03 | 2 | no | no | no | 2005-05-25 | 2021-03-03 | ? | 20210303.ifs | 2021-03-03 | 2021-03-04 | ||||||||||
4646796 | 4646795 | EQUITY | CHANGE | Y38472125 | ORD | 0 | 0 | 2005-05-19 | ? | 2 | no | no | no | 2005-05-25 | 2021-03-03 | ? | 20210303.ifs | 2021-03-03 | 2021-03-04 | ||||||||||
4530428 | 4530428 | EQUITY | CHANGE | Y38472125 | ORD | 0 | 0 | 2005-05-19 | ? | 1 | no | no | no | 2005-05-25 | 2005-05-20 | ? | 20201208.ifs | 2020-12-08 | 2020-12-09 | ||||||||||
4530429 | 4530428 | EQUITY | CHANGE | Y38472125 | ORD | 0 | 0 | 2005-05-19 | ? | 2 | no | no | no | 2005-05-25 | 2005-05-20 | ? | 20201208.ifs | 2020-12-08 | 2020-12-09 | ||||||||||
4325107 | 4325107 | DIVIDEND | CHANGE | Y38472125 | 0 | 0 | 1 | 0 | 1.249856 | 00 | ? | 2019-12-31 | 2020-04-24 | 2019-12-16 | 1 | 2019-12-16 | 2020-05-05 | 0 | 0006004222 | 20200506.ifs | 2020-05-06 | 2020-05-07 | |||||||
4325108 | 4325108 | DIVIDEND | CHANGE | Y38472125 | 0 | 0 | 1 | 0 | 1.249856 | 00 | ? | 2019-12-31 | 2020-04-24 | 2019-12-16 | 1 | 2019-12-16 | 2020-05-05 | 0 | 0006004222 | 20200506.ifs | 2020-05-06 | 2020-05-07 | |||||||
4325109 | 4325108 | DIVIDEND | CHANGE | Y38472125 | No Ex-Date set by NBB. | 0 | 0 | 1 | 0 | 1.249856 | 0 | 00 | ? | 2019-12-31 | 2020-04-24 | 2019-12-16 | 1 | 2019-12-16 | 2020-05-06 | 0 | 0006004222 | 20200506.ifs | 2020-05-06 | 2020-05-07 | |||||
4325110 | 4325109 | DIVIDEND | CHANGE | Y38472125 | No Ex-Date set by NBB. | 0 | 0 | 1 | 0 | 1.249856 | 0 | 00 | ? | 2019-12-31 | 2020-04-24 | 2019-12-16 | 1 | 2019-12-16 | 2020-05-06 | 0 | 0006004222 | 20200506.ifs | 2020-05-06 | 2020-05-07 | |||||
4323335 | 4323335 | DIVIDEND | DELETE | Y38472125 | 0 | 0 | 1 | 6 | 0 | 08 | ? | 2019-12-31 | ? | 2019-12-16 | 0 | 2019-12-16 | ? | 0 | 0006004222 | 20200505.ifs | 2020-05-05 | 2020-05-06 | |||||||
4323337 | 4323337 | DIVIDEND | ADD | Y38472125 | 0 | 0 | 1 | 0 | 1.249856 | 00 | ? | 2019-12-31 | 2020-04-24 | 2019-12-16 | 1 | 2019-12-16 | 2020-05-05 | 0 | 0006004222 | 20200505.ifs | 2020-05-05 | 2020-05-06 | |||||||
4323385 | 4323385 | DIVIDEND | DELETE | Y38472125 | 0 | 0 | 1 | 6 | 0 | 08 | ? | 2019-12-31 | ? | 2019-12-16 | 0 | 2019-12-16 | ? | 0 | 0006004222 | 20200505.ifs | 2020-05-05 | 2020-05-06 | |||||||
4323387 | 4323387 | DIVIDEND | ADD | Y38472125 | 0 | 0 | 1 | 0 | 1.249856 | 00 | ? | 2019-12-31 | 2020-04-24 | 2019-12-16 | 1 | 2019-12-16 | 2020-05-05 | 0 | 0006004222 | 20200505.ifs | 2020-05-05 | 2020-05-06 | |||||||
4070662 | 4070662 | DIVIDEND | ADD | Y38472125 | 0 | 0 | 1 | 6 | 0 | 08 | ? | 2019-12-31 | ? | 2019-12-16 | 0 | 2019-12-16 | ? | 0 | 0006004222 | 20191216.ifs | 2019-12-16 | 2019-12-17 | |||||||
4070724 | 4070724 | DIVIDEND | ADD | Y38472125 | 0 | 0 | 1 | 6 | 0 | 08 | ? | 2019-12-31 | ? | 2019-12-16 | 0 | 2019-12-16 | ? | 0 | 0006004222 | 20191216.ifs | 2019-12-16 | 2019-12-17 | |||||||
3878926 | 3878926 | DIVIDEND | CHANGE | Y38472125 | 0 | 0 | 1 | 0 | .412694 | 00 | ? | 2019-06-28 | 2019-08-16 | 2019-06-14 | 1 | 2019-06-14 | 2019-08-13 | 0 | 0005898304 | 20190814.ifs | 2019-08-14 | 2019-08-15 | |||||||
3878927 | 3878927 | DIVIDEND | CHANGE | Y38472125 | 0 | 0 | 1 | 0 | .412694 | 00 | ? | 2019-06-28 | 2019-08-16 | 2019-06-14 | 1 | 2019-06-14 | 2019-08-13 | 0 | 0005898304 | 20190814.ifs | 2019-08-14 | 2019-08-15 | |||||||
3878928 | 3878927 | DIVIDEND | CHANGE | Y38472125 | No Ex-Date set by NBB. | 0 | 0 | 1 | 0 | .412694 | 0 | 00 | ? | 2019-06-28 | 2019-08-16 | 2019-06-14 | 1 | 2019-06-14 | 2019-08-14 | 0 | 0005898304 | 20190814.ifs | 2019-08-14 | 2019-08-15 | |||||
3878929 | 3878928 | DIVIDEND | CHANGE | Y38472125 | No Ex-Date set by NBB. | 0 | 0 | 1 | 0 | .412694 | 0 | 00 | ? | 2019-06-28 | 2019-08-16 | 2019-06-14 | 1 | 2019-06-14 | 2019-08-14 | 0 | 0005898304 | 20190814.ifs | 2019-08-14 | 2019-08-15 | |||||
3878460 | 3878460 | DIVIDEND | DELETE | Y38472125 | 0 | 0 | 1 | 6 | 0 | 08 | ? | 2019-06-28 | ? | 2019-06-14 | 0 | 2019-06-14 | ? | 0 | 0005898304 | 20190813.ifs | 2019-08-13 | 2019-08-14 | |||||||
3878461 | 3878461 | DIVIDEND | DELETE | Y38472125 | 0 | 0 | 1 | 6 | 0 | 08 | ? | 2019-06-28 | ? | 2019-06-14 | 0 | 2019-06-14 | ? | 0 | 0005898304 | 20190813.ifs | 2019-08-13 | 2019-08-14 | |||||||
3878462 | 3878462 | DIVIDEND | ADD | Y38472125 | 0 | 0 | 1 | 0 | .412694 | 00 | ? | 2019-06-28 | 2019-08-16 | 2019-06-14 | 1 | 2019-06-14 | 2019-08-13 | 0 | 0005898304 | 20190813.ifs | 2019-08-13 | 2019-08-14 | |||||||
3878463 | 3878463 | DIVIDEND | ADD | Y38472125 | 0 | 0 | 1 | 0 | .412694 | 00 | ? | 2019-06-28 | 2019-08-16 | 2019-06-14 | 1 | 2019-06-14 | 2019-08-13 | 0 | 0005898304 | 20190813.ifs | 2019-08-13 | 2019-08-14 | |||||||
3779725 | 3779725 | DIVIDEND | ADD | Y38472125 | 0 | 0 | 1 | 6 | 0 | 08 | ? | 2019-06-28 | ? | 2019-06-14 | 0 | 2019-06-14 | ? | 0 | 0005898304 | 20190614.ifs | 2019-06-14 | 2019-06-15 | |||||||
3779791 | 3779791 | DIVIDEND | ADD | Y38472125 | 0 | 0 | 1 | 6 | 0 | 08 | ? | 2019-06-28 | ? | 2019-06-14 | 0 | 2019-06-14 | ? | 0 | 0005898304 | 20190614.ifs | 2019-06-14 | 2019-06-15 | |||||||
3692204 | 3692204 | DIVIDEND | CHANGE | Y38472125 | 0 | 0 | 1 | 0 | 1.338282 | 00 | ? | 2018-12-31 | 2019-04-26 | 2018-12-14 | 1 | 2018-12-14 | 2019-04-23 | 0 | 0005778882 | 20190424.ifs | 2019-04-24 | 2019-04-25 | |||||||
3692205 | 3692205 | DIVIDEND | CHANGE | Y38472125 | 0 | 0 | 1 | 0 | 1.338282 | 00 | ? | 2018-12-31 | 2019-04-26 | 2018-12-14 | 1 | 2018-12-14 | 2019-04-23 | 0 | 0005778882 | 20190424.ifs | 2019-04-24 | 2019-04-25 | |||||||
3692206 | 3692205 | DIVIDEND | CHANGE | Y38472125 | No Ex-Date set by NBB. | 0 | 0 | 1 | 0 | 1.338282 | 0 | 00 | ? | 2018-12-31 | 2019-04-26 | 2018-12-14 | 1 | 2018-12-14 | 2019-04-24 | 0 | 0005778882 | 20190424.ifs | 2019-04-24 | 2019-04-25 | |||||
3692207 | 3692206 | DIVIDEND | CHANGE | Y38472125 | No Ex-Date set by NBB. | 0 | 0 | 1 | 0 | 1.338282 | 0 | 00 | ? | 2018-12-31 | 2019-04-26 | 2018-12-14 | 1 | 2018-12-14 | 2019-04-24 | 0 | 0005778882 | 20190424.ifs | 2019-04-24 | 2019-04-25 | |||||
3691114 | 3691114 | DIVIDEND | DELETE | Y38472125 | 0 | 0 | 1 | 6 | 0 | 08 | ? | 2018-12-31 | ? | 2018-12-14 | 0 | 2018-12-14 | ? | 0 | 0005778882 | 20190423.ifs | 2019-04-23 | 2019-04-24 | |||||||
3691115 | 3691115 | DIVIDEND | DELETE | Y38472125 | 0 | 0 | 1 | 6 | 0 | 08 | ? | 2018-12-31 | ? | 2018-12-14 | 0 | 2018-12-14 | ? | 0 | 0005778882 | 20190423.ifs | 2019-04-23 | 2019-04-24 | |||||||
3691116 | 3691116 | DIVIDEND | ADD | Y38472125 | 0 | 0 | 1 | 0 | 1.338282 | 00 | ? | 2018-12-31 | 2019-04-26 | 2018-12-14 | 1 | 2018-12-14 | 2019-04-23 | 0 | 0005778882 | 20190423.ifs | 2019-04-23 | 2019-04-24 | |||||||
3691117 | 3691117 | DIVIDEND | ADD | Y38472125 | 0 | 0 | 1 | 0 | 1.338282 | 00 | ? | 2018-12-31 | 2019-04-26 | 2018-12-14 | 1 | 2018-12-14 | 2019-04-23 | 0 | 0005778882 | 20190423.ifs | 2019-04-23 | 2019-04-24 | |||||||
3437974 | 3437974 | DIVIDEND | ADD | Y38472125 | 0 | 0 | 1 | 6 | 0 | 08 | ? | 2018-12-31 | ? | 2018-12-14 | 0 | 2018-12-14 | ? | 0 | 0005778882 | 20181214.ifs | 2018-12-14 | 2018-12-15 | |||||||
3438853 | 3438853 | DIVIDEND | ADD | Y38472125 | 0 | 0 | 1 | 6 | 0 | 08 | ? | 2018-12-31 | ? | 2018-12-14 | 0 | 2018-12-14 | ? | 0 | 0005778882 | 20181214.ifs | 2018-12-14 | 2018-12-15 | |||||||
3244100 | 3244100 | DIVIDEND | CHANGE | Y38472125 | 0 | 0 | 1 | 0 | .440226 | 00 | ? | 2018-07-02 | 2018-08-21 | 2018-06-20 | 2 | 2018-06-20 | 2018-08-20 | 0 | 0005677892 | 20180821.ifs | 2018-08-21 | 2018-08-22 | |||||||
3244102 | 3244101 | DIVIDEND | CHANGE | Y38472125 | No Ex-Date set by NBB. | 0 | 0 | 1 | 0 | .440226 | 0 | 00 | ? | 2018-07-02 | 2018-08-21 | 2018-06-20 | 2 | 2018-06-20 | 2018-08-21 | 0 | 0005677892 | 20180821.ifs | 2018-08-21 | 2018-08-22 | |||||
3244105 | 3244105 | DIVIDEND | CHANGE | Y38472125 | 0 | 0 | 1 | 0 | .440226 | 00 | ? | 2018-07-02 | 2018-08-21 | 2018-06-20 | 2 | 2018-06-20 | 2018-08-20 | 0 | 0005677892 | 20180821.ifs | 2018-08-21 | 2018-08-22 | |||||||
3244107 | 3244106 | DIVIDEND | CHANGE | Y38472125 | No Ex-Date set by NBB. | 0 | 0 | 1 | 0 | .440226 | 0 | 00 | ? | 2018-07-02 | 2018-08-21 | 2018-06-20 | 2 | 2018-06-20 | 2018-08-21 | 0 | 0005677892 | 20180821.ifs | 2018-08-21 | 2018-08-22 | |||||
3243360 | 3243360 | DIVIDEND | CHANGE | Y38472125 | 0 | 0 | 1 | 0 | 813 | 00 | ? | 2018-07-02 | 2018-08-21 | 2018-06-20 | 1 | 2018-06-20 | 2018-08-17 | 0 | 0005677892 | 20180820.ifs | 2018-08-20 | 2018-08-21 | |||||||
3243361 | 3243361 | DIVIDEND | CHANGE | Y38472125 | 0 | 0 | 1 | 0 | 813 | 00 | ? | 2018-07-02 | 2018-08-21 | 2018-06-20 | 1 | 2018-06-20 | 2018-08-17 | 0 | 0005677892 | 20180820.ifs | 2018-08-20 | 2018-08-21 | |||||||
3243362 | 3243361 | DIVIDEND | CHANGE | Y38472125 | 0 | 0 | 1 | 0 | .440226 | 00 | ? | 2018-07-02 | 2018-08-21 | 2018-06-20 | 2 | 2018-06-20 | 2018-08-20 | 0 | 0005677892 | 20180820.ifs | 2018-08-20 | 2018-08-21 | |||||||
3243363 | 3243362 | DIVIDEND | CHANGE | Y38472125 | 0 | 0 | 1 | 0 | .440226 | 00 | ? | 2018-07-02 | 2018-08-21 | 2018-06-20 | 2 | 2018-06-20 | 2018-08-20 | 0 | 0005677892 | 20180820.ifs | 2018-08-20 | 2018-08-21 | |||||||
3242248 | 3242248 | DIVIDEND | DELETE | Y38472125 | 0 | 0 | 1 | 6 | 0 | 08 | ? | 2018-07-02 | ? | 2018-06-20 | 0 | 2018-06-20 | ? | 0 | 0005677892 | 20180817.ifs | 2018-08-17 | 2018-08-18 | |||||||
3242249 | 3242249 | DIVIDEND | DELETE | Y38472125 | 0 | 0 | 1 | 6 | 0 | 08 | ? | 2018-07-02 | ? | 2018-06-20 | 0 | 2018-06-20 | ? | 0 | 0005677892 | 20180817.ifs | 2018-08-17 | 2018-08-18 | |||||||
3242250 | 3242250 | DIVIDEND | ADD | Y38472125 | 0 | 0 | 1 | 0 | 813 | 00 | ? | 2018-07-02 | 2018-08-21 | 2018-06-20 | 1 | 2018-06-20 | 2018-08-17 | 0 | 0005677892 | 20180817.ifs | 2018-08-17 | 2018-08-18 | |||||||
3242251 | 3242251 | DIVIDEND | ADD | Y38472125 | 0 | 0 | 1 | 0 | 813 | 00 | ? | 2018-07-02 | 2018-08-21 | 2018-06-20 | 1 | 2018-06-20 | 2018-08-17 | 0 | 0005677892 | 20180817.ifs | 2018-08-17 | 2018-08-18 | |||||||
3148266 | 3148266 | DIVIDEND | ADD | Y38472125 | 0 | 0 | 1 | 6 | 0 | 08 | ? | 2018-07-02 | ? | 2018-06-20 | 0 | 2018-06-20 | ? | 0 | 0005677892 | 20180620.ifs | 2018-06-20 | 2018-06-21 | |||||||
3148268 | 3148268 | DIVIDEND | CHANGE | Y38472125 | 0 | 0 | 1 | 0 | 1.422959 | 00 | ? | 2017-12-29 | 2018-04-20 | 2017-12-22 | 1 | 2017-12-22 | 2018-04-18 | 0 | 0005577722 | 20180620.ifs | 2018-06-20 | 2018-06-21 | |||||||
3148270 | 3148269 | DIVIDEND | CHANGE | Y38472125 | 0 | 0 | 1 | 0 | 1.422959 | 00 | ? | 2017-12-29 | 2018-04-20 | 2017-12-22 | 2 | 2017-12-22 | 2018-06-20 | 0 | 0005577722 | 20180620.ifs | 2018-06-20 | 2018-06-21 | |||||||
3148271 | 3148271 | DIVIDEND | ADD | Y38472125 | 0 | 0 | 1 | 6 | 0 | 08 | ? | 2018-07-02 | ? | 2018-06-20 | 0 | 2018-06-20 | ? | 0 | 0005677892 | 20180620.ifs | 2018-06-20 | 2018-06-21 | |||||||
3148273 | 3148273 | DIVIDEND | CHANGE | Y38472125 | 0 | 0 | 1 | 0 | 1.422959 | 00 | ? | 2017-12-29 | 2018-04-20 | 2017-12-22 | 1 | 2017-12-22 | 2018-04-18 | 0 | 0005577722 | 20180620.ifs | 2018-06-20 | 2018-06-21 | |||||||
3148275 | 3148274 | DIVIDEND | CHANGE | Y38472125 | 0 | 0 | 1 | 0 | 1.422959 | 00 | ? | 2017-12-29 | 2018-04-20 | 2017-12-22 | 2 | 2017-12-22 | 2018-06-20 | 0 | 0005577722 | 20180620.ifs | 2018-06-20 | 2018-06-21 | |||||||
3041968 | 3041968 | DIVIDEND | DELETE | Y38472125 | 0 | 0 | 1 | 6 | 0 | 08 | ? | 2017-12-29 | ? | 2017-12-22 | 0 | 2017-12-22 | ? | 0 | 0005577722 | 20180418.ifs | 2018-04-18 | 2018-04-19 | |||||||
3041970 | 3041970 | DIVIDEND | ADD | Y38472125 | 0 | 0 | 1 | 0 | 1.422959 | 00 | ? | 2017-12-29 | 2018-04-20 | 2017-12-22 | 1 | 2017-12-22 | 2018-04-18 | 0 | 0005577722 | 20180418.ifs | 2018-04-18 | 2018-04-19 | |||||||
3041985 | 3041985 | DIVIDEND | DELETE | Y38472125 | 0 | 0 | 1 | 6 | 0 | 08 | ? | 2017-12-29 | ? | 2017-12-22 | 0 | 2017-12-22 | ? | 0 | 0005577722 | 20180418.ifs | 2018-04-18 | 2018-04-19 | |||||||
3041987 | 3041987 | DIVIDEND | ADD | Y38472125 | 0 | 0 | 1 | 0 | 1.422959 | 00 | ? | 2017-12-29 | 2018-04-20 | 2017-12-22 | 1 | 2017-12-22 | 2018-04-18 | 0 | 0005577722 | 20180418.ifs | 2018-04-18 | 2018-04-19 | |||||||
2862986 | 2862986 | DIVIDEND | ADD | Y38472125 | 0 | 0 | 1 | 6 | 0 | 08 | ? | 2017-12-29 | ? | 2017-12-22 | 0 | 2017-12-22 | ? | 0 | 0005577722 | 20171222.ifs | 2017-12-22 | 2017-12-23 | |||||||
2863065 | 2863065 | DIVIDEND | ADD | Y38472125 | 0 | 0 | 1 | 6 | 0 | 08 | ? | 2017-12-29 | ? | 2017-12-22 | 0 | 2017-12-22 | ? | 0 | 0005577722 | 20171222.ifs | 2017-12-22 | 2017-12-23 | |||||||
2652471 | 2652471 | DIVIDEND | DELETE | Y38472125 | 0 | 0 | 1 | 6 | 0 | 08 | ? | 2017-07-03 | ? | 2017-06-23 | 0 | 2017-06-23 | ? | 0 | 0005453906 | 20170822.ifs | 2017-08-22 | 2017-08-23 | |||||||
2652472 | 2652472 | DIVIDEND | ADD | Y38472125 | 0 | 0 | 1 | 0 | .438889 | 00 | ? | 2017-07-03 | 2017-08-21 | 2017-06-23 | 1 | 2017-06-23 | 2017-08-22 | 0 | 0005453906 | 20170822.ifs | 2017-08-22 | 2017-08-23 | |||||||
2599800 | 2599800 | DIVIDEND | ADD | Y38472125 | 0 | 0 | 1 | 6 | 0 | 08 | ? | 2017-07-03 | ? | 2017-06-23 | 0 | 2017-06-23 | ? | 0 | 0005453906 | 20170623.ifs | 2017-06-23 | 2017-06-24 | |||||||
2543204 | 2543204 | DIVIDEND | ADD | Y38472125 | 0 | 1 | 1 | 0 | 1.336406 | 14 | ? | 2016-12-30 | 2017-04-21 | 2017-04-18 | 0 | 2017-04-18 | ? | 0 | 0005421536 | 20170418.ifs | 2017-04-18 | 2017-04-19 | |||||||
2473047 | 2473047 | EQUITY | CHANGE | Y38472125 | ORD | 0 | 0 | 2005-05-19 | ? | 0 | no | no | no | 2005-05-25 | 2005-05-20 | ? | 20170126.ifs | 2017-01-26 | 2017-01-27 | ||||||||||
2473048 | 2473047 | EQUITY | CHANGE | Y38472125 | ORD | 0 | 0 | 2005-05-19 | ? | 1 | no | no | no | 2005-05-25 | 2005-05-20 | ? | 20170126.ifs | 2017-01-26 | 2017-01-27 | ||||||||||
2272143 | 2272143 | DIVIDEND | ADD | Y38472125 | 0 | 0 | 1 | 0 | .454731 | 00 | ? | 2016-06-30 | 2016-08-19 | 2016-06-20 | 0 | ? | 2016-08-18 | 0 | 0005237377 | 20160818.ifs | 2016-08-18 | 2016-08-19 | |||||||
2244696 | 2244696 | DIVIDEND | DELETE | Y38472125 | 0 | 0 | 1 | 6 | 0 | 08 | ? | 2016-06-30 | ? | 2016-06-23 | 0 | 2016-06-23 | ? | 0 | 0005237377 | 20160705.ifs | 2016-07-05 | 2016-07-06 | |||||||
2228663 | 2228663 | DIVIDEND | ADD | Y38472125 | 0 | 0 | 1 | 6 | 0 | 08 | ? | 2016-06-30 | ? | 2016-06-23 | 0 | 2016-06-23 | ? | 0 | 0005237377 | 20160623.ifs | 2016-06-23 | 2016-06-24 | |||||||
2163561 | 2163561 | DIVIDEND | ADD | Y38472125 | 0 | 0 | 1 | 0 | 1.310452 | 00 | ? | 2015-12-31 | 2016-04-15 | 2015-12-15 | 0 | ? | 2016-04-13 | 0 | 0005162329 | 20160413.ifs | 2016-04-13 | 2016-04-14 | |||||||
1965455 | 1965455 | DIVIDEND | DELETE | Y38472125 | 0 | 1 | 0 | .424376 | 00 | ? | 2015-06-30 | 2015-09-04 | ? | 0 | 2015-09-09 | ? | 0 | 0005029014 | 20150915.ifs | 2015-09-15 | 2015-09-16 | ||||||||
1965456 | 1965456 | DIVIDEND | ADD | Y38472125 | 0 | 0 | 1 | 0 | .424376 | 0 | 00 | ? | 2015-06-30 | 2015-09-04 | 2015-07-01 | 0 | ? | 2015-09-15 | 0 | 0005029014 | 20150915.ifs | 2015-09-15 | 2015-09-16 | ||||||
1961750 | 1961750 | DIVIDEND | ADD | Y38472125 | 0 | 1 | 0 | .424376 | 00 | ? | 2015-06-30 | 2015-09-04 | ? | 0 | 2015-09-09 | ? | 0 | 0005029014 | 20150909.ifs | 2015-09-09 | 2015-09-10 | ||||||||
1843841 | 1843841 | DIVIDEND | ADD | Y38472125 | 0 | 1 | 1 | 0 | 1.390535 | 14 | ? | 2014-12-31 | 2015-04-17 | 2015-04-21 | 0 | 2015-04-21 | ? | 0 | 0004987631 | 20150421.ifs | 2015-04-21 | 2015-04-22 | |||||||
1498046 | 1498046 | DIVIDEND | ADD | Y38472125 | 0 | 0 | 1 | 0 | .958956 | 00 | ? | 2013-12-31 | 2014-04-18 | 2013-12-18 | 0 | ? | 2014-04-21 | 0 | 0004734793 | 20140421.ifs | 2014-04-21 | 2014-04-22 | |||||||
1162735 | 1162735 | DIVIDEND | DELETE | Y38472125 | 0 | 0 | 1 | 0 | .790374 | 00 | ? | 2011-12-30 | 2012-04-23 | ? | 0 | ? | 2012-05-03 | 0 | 0004304581 | 20130419.ifs | 2013-04-19 | 2013-04-20 | |||||||
1162736 | 1162736 | DIVIDEND | ADD | Y38472125 | 0 | 0 | 1 | 0 | .790374 | 0 | 00 | ? | 2011-12-30 | 2012-04-23 | 2012-12-15 | 0 | ? | 2013-04-19 | 0 | 0004304581 | 20130419.ifs | 2013-04-19 | 2013-04-20 | ||||||
1162739 | 1162739 | DIVIDEND | DELETE | Y38472125 | 0 | 0 | 1 | 0 | .790374 | 0 | 00 | ? | 2011-12-30 | 2012-04-23 | 2012-12-15 | 0 | ? | 2013-04-19 | 0 | 0004304581 | 20130419.ifs | 2013-04-19 | 2013-04-20 | ||||||
1162740 | 1162740 | DIVIDEND | ADD | Y38472125 | 0 | 0 | 1 | 0 | .790374 | 0 | 00 | ? | 2011-12-30 | 2012-04-23 | 2011-12-15 | 0 | ? | 2013-04-19 | 0 | 0004304581 | 20130419.ifs | 2013-04-19 | 2013-04-20 | ||||||
1162741 | 1162741 | DIVIDEND | DELETE | Y38472125 | 0 | 1 | 0 | .714483 | 00 | ? | 2010-12-31 | 2011-04-18 | ? | 0 | 2011-04-11 | ? | 0 | 0004105844 | 20130419.ifs | 2013-04-19 | 2013-04-20 | ||||||||
1162742 | 1162742 | DIVIDEND | ADD | Y38472125 | 0 | 0 | 1 | 0 | .714483 | 0 | 00 | ? | 2010-12-31 | 2011-04-18 | 2010-12-15 | 0 | ? | 2013-04-19 | 0 | 0004105844 | 20130419.ifs | 2013-04-19 | 2013-04-20 | ||||||
1162743 | 1162743 | DIVIDEND | ADD | Y38472125 | 0 | 0 | 1 | 0 | .860927 | 00 | ? | 2012-12-31 | 2013-04-19 | 2012-12-17 | 0 | ? | 2013-04-19 | 0 | 0004483755 | 20130419.ifs | 2013-04-19 | 2013-04-20 | |||||||
854285 | 854285 | DIVIDEND | ADD | Y38472125 | 0 | 1 | 1 | 0 | .790374 | 14 | ? | 2011-12-30 | 2012-04-23 | ? | 0 | ? | 2012-05-03 | 0 | 0004304581 | 20120503.ifs | 2012-05-03 | 2012-05-04 | |||||||
854286 | 854286 | DIVIDEND | DELETE | Y38472125 | 0 | 1 | 1 | 0 | .790374 | 14 | ? | 2011-12-30 | 2012-04-23 | ? | 0 | ? | 2012-05-03 | 0 | 0004304581 | 20120503.ifs | 2012-05-03 | 2012-05-04 | |||||||
854287 | 854287 | DIVIDEND | ADD | Y38472125 | 0 | 0 | 1 | 0 | .790374 | 00 | ? | 2011-12-30 | 2012-04-23 | ? | 0 | ? | 2012-05-03 | 0 | 0004304581 | 20120503.ifs | 2012-05-03 | 2012-05-04 | |||||||
500253 | 500253 | DIVIDEND | ADD | Y38472125 | 0 | 1 | 0 | .714483 | 00 | ? | 2010-12-31 | 2011-04-18 | ? | 0 | 2011-04-11 | ? | 0 | 0004105844 | 20110411.ifs | 2011-04-11 | 2011-04-12 | ||||||||
379126 | 379126 | DIVIDEND | DELETE | Y38472125 | 0 | 0 | 1 | 6 | 0 | 08 | ? | 2010-12-31 | ? | 2010-12-15 | 0 | 2010-12-15 | ? | 0 | 0004105844 | 20101216.ifs | 2010-12-16 | 2010-12-17 | |||||||
377843 | 377843 | DIVIDEND | ADD | Y38472125 | 0 | 0 | 1 | 6 | 0 | 08 | ? | 2010-12-31 | ? | 2010-12-15 | 0 | 2010-12-15 | ? | 0 | 0004105844 | 20101215.ifs | 2010-12-15 | 2010-12-16 | |||||||
163098 | 163098 | DIVIDEND | ADD | Y38472125 | 0 | 1 | 1 | 0 | .53865 | 14 | ? | 2009-12-31 | 2010-04-19 | 2010-04-21 | 0 | 2010-04-21 | ? | 0 | 0003994465 | 20100421.ifs | 2010-04-21 | 2010-04-22 | |||||||
113087 | 113087 | DIVIDEND | ADD | Y38472125 | 0 | 1 | 1 | 0 | .47346 | 14 | ? | 2005-12-19 | 2006-04-17 | 2010-02-19 | 0 | 2010-02-19 | ? | 0 | 0003966853 | 20100219.ifs | 2010-02-19 | 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 = 146366
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