| INSITITUIONS | Dynamic | newInstitTable | Changed the Cusip/Sector/Shs Out? |
|
|||||||
| Total Insititutions : | 13 | 8 | Update Insititution By Cusips | ||||||||
| % Owned by Insititutions: | 0.01 % | 0.01 % | |||||||||
|
pricingQuarterAdminPageOn:
|
2024-03-31 | New % | |||||||||
|
|
|||||||||||
the compid is:160352 |
|||||||||||
| 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 | ||
| 5578662 | 5578662 | DIVIDEND | DELETE | 23381D102 | 0 | 1 | 0 | .190104 | 00 | ? | 2024-03-28 | 2024-06-25 | ? | 0 | 2024-06-18 | ? | 0 | 0006889130 | 20240620.ifs | 2024-06-20 | 2024-06-21 | ||||||||
| 5578663 | 5578663 | DIVIDEND | ADD | 23381D102 | No Ex-Date set by OTC. | 0 | 0 | 1 | 0 | .190104 | 0 | 00 | ? | 2024-03-28 | 2024-06-25 | 2024-03-12 | 0 | ? | 2024-06-19 | 0 | 0006889130 | 20240620.ifs | 2024-06-20 | 2024-06-21 | |||||
| 5578359 | 5578359 | DIVIDEND | ADD | 23381D102 | 0 | 1 | 0 | .190104 | 00 | ? | 2024-03-28 | 2024-06-25 | ? | 0 | 2024-06-18 | ? | 0 | 0006889130 | 20240618.ifs | 2024-06-18 | 2024-06-19 | ||||||||
| 5515733 | 5515733 | DIVIDEND | DELETE | 23381D102 | 0 | 0 | 1 | 6 | 0 | 08 | ? | 2024-03-28 | ? | 2024-03-12 | 0 | 2024-03-12 | ? | 0 | 0006889130 | 20240313.ifs | 2024-03-13 | 2024-03-14 | |||||||
| 5515285 | 5515285 | DIVIDEND | ADD | 23381D102 | 0 | 0 | 1 | 6 | 0 | 08 | ? | 2024-03-28 | ? | 2024-03-12 | 0 | 2024-03-12 | ? | 0 | 0006889130 | 20240312.ifs | 2024-03-12 | 2024-03-13 | |||||||
| 5317405 | 5317405 | DIVIDEND | ADD | 23381D102 | No Ex-Date set by OTC. | 0 | 0 | 1 | 0 | .10613 | 00 | ? | 2023-03-31 | 2023-06-27 | 2023-02-23 | 0 | ? | 2023-06-23 | 0 | 0006685026 | 20230623.ifs | 2023-06-23 | 2023-06-24 | ||||||
| 5154957 | 5154957 | DIVIDEND | CHANGE | 23381D102 | 0 | 0 | 1 | 0 | .1104 | 0 | 00 | ? | 2022-09-30 | 2022-12-08 | 2022-08-26 | 1 | 2022-08-26 | 2022-12-05 | 0 | 0006573157 | 20221206.ifs | 2022-12-06 | 2022-12-07 | ||||||
| 5154958 | 5154957 | DIVIDEND | CHANGE | 23381D102 | No Ex-Date set by OTC | 0 | 0 | 1 | 0 | .1104 | 0 | 00 | ? | 2022-09-30 | 2022-12-08 | 2022-08-26 | 1 | 2022-08-26 | 2022-12-06 | 0 | 0006573157 | 20221206.ifs | 2022-12-06 | 2022-12-07 | |||||
| 5154791 | 5154791 | DIVIDEND | DELETE | 23381D102 | 0 | 0 | 1 | 6 | 0 | 0 | 08 | ? | 2022-09-30 | ? | 2022-08-26 | 0 | 2022-08-26 | 2022-08-29 | 0 | 0006573157 | 20221205.ifs | 2022-12-05 | 2022-12-06 | ||||||
| 5154792 | 5154792 | DIVIDEND | ADD | 23381D102 | 0 | 0 | 1 | 0 | .1104 | 0 | 00 | ? | 2022-09-30 | 2022-12-08 | 2022-08-26 | 1 | 2022-08-26 | 2022-12-05 | 0 | 0006573157 | 20221205.ifs | 2022-12-05 | 2022-12-06 | ||||||
| 5083382 | 5083382 | DIVIDEND | ADD | 23381D102 | 0 | 0 | 1 | 6 | 0 | 08 | ? | 2022-09-30 | ? | 2022-08-26 | 0 | 2022-08-26 | ? | 0 | 0006573157 | 20220826.ifs | 2022-08-26 | 2022-08-27 | |||||||
| 5045177 | 5045177 | DIVIDEND | ADD | 23381D102 | No Ex-Date set by OTC. | 0 | 0 | 1 | 0 | .09906 | 00 | ? | 2022-03-31 | 2022-07-05 | 2022-03-16 | 0 | ? | 2022-06-30 | 0 | 0006494889 | 20220630.ifs | 2022-06-30 | 2022-07-01 | ||||||
| 4865965 | 4865965 | DIVIDEND | CHANGE | 23381D102 | 0 | 0 | 1 | 0 | .119421 | 00 | ? | 2021-09-29 | 2021-12-09 | 2021-09-16 | 0 | ? | 2021-12-03 | 0 | 0006368565 | 20211206.ifs | 2021-12-06 | 2021-12-07 | |||||||
| 4865966 | 4865965 | DIVIDEND | CHANGE | 23381D102 | No Ex-Date set by OTC. | 0 | 0 | 1 | 0 | .119421 | 0 | 00 | ? | 2021-09-29 | 2021-12-09 | 2021-09-16 | 0 | ? | 2021-12-06 | 0 | 0006368565 | 20211206.ifs | 2021-12-06 | 2021-12-07 | |||||
| 4865452 | 4865452 | DIVIDEND | DELETE | 23381D102 | No Ex-Date set by OTC | 0 | 0 | 1 | 0 | 0 | 00 | ? | 2021-09-29 | ? | 2021-09-16 | 0 | ? | 2021-09-20 | 0 | 0006368565 | 20211203.ifs | 2021-12-03 | 2021-12-04 | ||||||
| 4865453 | 4865453 | DIVIDEND | ADD | 23381D102 | 0 | 0 | 1 | 0 | .119421 | 00 | ? | 2021-09-29 | 2021-12-09 | 2021-09-16 | 0 | ? | 2021-12-03 | 0 | 0006368565 | 20211203.ifs | 2021-12-03 | 2021-12-04 | |||||||
| 4804993 | 4804993 | DIVIDEND | ADD | 23381D102 | No Ex-Date set by OTC | 0 | 0 | 1 | 0 | 0 | 00 | ? | 2021-09-29 | ? | 2021-09-16 | 0 | ? | 2021-09-20 | 0 | 0006368565 | 20210920.ifs | 2021-09-20 | 2021-09-21 | ||||||
| 4804845 | 4804845 | DIVIDEND | DELETE | 23381D102 | 0 | 0 | 1 | 6 | 0 | 08 | ? | 2021-09-29 | ? | 2021-09-16 | 0 | 2021-09-16 | ? | 0 | 0006368565 | 20210917.ifs | 2021-09-17 | 2021-09-18 | |||||||
| 4803800 | 4803800 | DIVIDEND | ADD | 23381D102 | 0 | 0 | 1 | 6 | 0 | 08 | ? | 2021-09-29 | ? | 2021-09-16 | 0 | 2021-09-16 | ? | 0 | 0006368565 | 20210916.ifs | 2021-09-16 | 2021-09-17 | |||||||
| 4736909 | 4736909 | DIVIDEND | ADD | 23381D102 | No Ex-Date set by OTC. | 0 | 0 | 1 | 0 | .122074 | 00 | ? | 2021-03-30 | 2021-06-29 | 2021-02-24 | 0 | ? | 2021-06-24 | 0 | 0006266697 | 20210624.ifs | 2021-06-24 | 2021-06-25 | ||||||
| 4523809 | 4523809 | DIVIDEND | ADD | 23381D102 | 0 | 0 | 1 | 0 | .387971 | 00 | ? | 2020-09-29 | 2020-12-08 | 2020-09-02 | 0 | ? | 2020-12-02 | 0 | 0006155137 | 20201202.ifs | 2020-12-02 | 2020-12-03 | |||||||
| 4523810 | 4523810 | DIVIDEND | CHANGE | 23381D102 | 0 | 0 | 1 | 0 | .387971 | 00 | ? | 2020-09-29 | 2020-12-08 | 2020-09-02 | 0 | ? | 2020-12-02 | 0 | 0006155137 | 20201202.ifs | 2020-12-02 | 2020-12-03 | |||||||
| 4523811 | 4523810 | DIVIDEND | CHANGE | 23381D102 | No Ex-Date set by NBB. | 0 | 0 | 1 | 0 | .387971 | 00 | ? | 2020-09-29 | 2020-12-08 | 2020-09-02 | 0 | ? | 2020-12-02 | 0 | 0006155137 | 20201202.ifs | 2020-12-02 | 2020-12-03 | ||||||
| 4523812 | 4523812 | DIVIDEND | CHANGE | 23381D102 | 0 | 0 | 6 | 0 | 2 | 0 | 11 | 2020-10-09 | 2020-09-30 | 2020-10-08 | 2020-08-19 | 1 | 2020-08-19 | 2020-09-02 | 1 | 0006145113 | 20201202.ifs | 2020-12-02 | 2020-12-03 | ||||||
| 4523813 | 4523812 | DIVIDEND | CHANGE | 23381D102 | Special ex-date set by OTC. | 0 | 0 | 6 | 0 | 2 | 0 | 11 | 2020-10-09 | 2020-09-30 | 2020-10-08 | 2020-08-19 | 1 | 2020-08-19 | 2020-12-02 | 1 | 0006145113 | 20201202.ifs | 2020-12-02 | 2020-12-03 | |||||
| 4456074 | 4456074 | DIVIDEND | CHANGE | 23381D102 | Special ex-date set by OTC. | 0 | 0 | 6 | 0 | 2 | 0 | 11 | 2020-10-09 | 2020-09-30 | 2020-10-08 | 2020-08-19 | 0 | 2020-08-19 | 2020-08-20 | 0 | 0006145113 | 20200902.ifs | 2020-09-02 | 2020-09-03 | |||||
| 4456075 | 4456074 | DIVIDEND | CHANGE | 23381D102 | 0 | 0 | 6 | 0 | 2 | 0 | 11 | 2020-10-09 | 2020-09-30 | 2020-10-08 | 2020-08-19 | 1 | 2020-08-19 | 2020-09-02 | 1 | 0006145113 | 20200902.ifs | 2020-09-02 | 2020-09-03 | ||||||
| 4442671 | 4442671 | DIVIDEND | ADD | 23381D102 | 0 | 0 | 6 | 0 | 2 | 11 | 2020-10-09 | 2020-09-30 | 2020-10-08 | 2020-08-19 | 0 | 2020-08-19 | ? | 0 | 0006145113 | 20200819.ifs | 2020-08-19 | 2020-08-20 | |||||||
| 4442672 | 4442672 | SPLIT | ADD | 23381D102 | .3333333333 | 2020-10-09 | 11 | 2020-08-19 | ? | 20200819.ifs | 2020-08-19 | 2020-08-20 | |||||||||||||||||
| 4393118 | 4393118 | DIVIDEND | ADD | 23381D102 | 0 | 0 | 1 | 0 | .325854 | 00 | ? | 2020-03-30 | 2020-06-23 | 2020-03-13 | 0 | ? | 2020-06-17 | 0 | 0006068715 | 20200617.ifs | 2020-06-17 | 2020-06-18 | |||||||
| 4393119 | 4393119 | DIVIDEND | CHANGE | 23381D102 | 0 | 0 | 1 | 0 | .325854 | 00 | ? | 2020-03-30 | 2020-06-23 | 2020-03-13 | 0 | ? | 2020-06-17 | 0 | 0006068715 | 20200617.ifs | 2020-06-17 | 2020-06-18 | |||||||
| 4393120 | 4393119 | DIVIDEND | CHANGE | 23381D102 | No Ex-Date set by NBB. | 0 | 0 | 1 | 0 | .325854 | 00 | ? | 2020-03-30 | 2020-06-23 | 2020-03-13 | 0 | ? | 2020-06-17 | 0 | 0006068715 | 20200617.ifs | 2020-06-17 | 2020-06-18 | ||||||
| 4048460 | 4048460 | DIVIDEND | ADD | 23381D102 | 0 | 0 | 1 | 0 | .322482 | 00 | ? | 2019-09-27 | 2019-12-10 | 2019-09-12 | 0 | ? | 2019-12-09 | 0 | 0005944948 | 20191209.ifs | 2019-12-09 | 2019-12-10 | |||||||
| 4048461 | 4048461 | DIVIDEND | ADD | 23381D102 | 0 | 0 | 1 | 0 | .322482 | 00 | ? | 2019-09-27 | 2019-12-10 | 2019-09-12 | 0 | ? | 2019-12-09 | 0 | 0005944948 | 20191209.ifs | 2019-12-09 | 2019-12-10 | |||||||
| 4048462 | 4048462 | DIVIDEND | CHANGE | 23381D102 | 0 | 0 | 1 | 0 | .322482 | 00 | ? | 2019-09-27 | 2019-12-10 | 2019-09-12 | 0 | ? | 2019-12-09 | 0 | 0005944948 | 20191209.ifs | 2019-12-09 | 2019-12-10 | |||||||
| 4048463 | 4048463 | DIVIDEND | CHANGE | 23381D102 | 0 | 0 | 1 | 0 | .322482 | 00 | ? | 2019-09-27 | 2019-12-10 | 2019-09-12 | 0 | ? | 2019-12-09 | 0 | 0005944948 | 20191209.ifs | 2019-12-09 | 2019-12-10 | |||||||
| 4048464 | 4048463 | DIVIDEND | CHANGE | 23381D102 | No Ex-Date set by NBB. | 0 | 0 | 1 | 0 | .322482 | 00 | ? | 2019-09-27 | 2019-12-10 | 2019-09-12 | 0 | ? | 2019-12-09 | 0 | 0005944948 | 20191209.ifs | 2019-12-09 | 2019-12-10 | ||||||
| 4048465 | 4048464 | DIVIDEND | CHANGE | 23381D102 | No Ex-Date set by NBB. | 0 | 0 | 1 | 0 | .322482 | 00 | ? | 2019-09-27 | 2019-12-10 | 2019-09-12 | 0 | ? | 2019-12-09 | 0 | 0005944948 | 20191209.ifs | 2019-12-09 | 2019-12-10 | ||||||
| 3794612 | 3794612 | DIVIDEND | ADD | 23381D102 | No Ex-Date set by NBB. | 0 | 0 | 1 | 0 | .322239 | 00 | ? | 2019-03-29 | 2019-06-26 | 2019-03-19 | 0 | ? | 2019-06-24 | 0 | 0005854103 | 20190624.ifs | 2019-06-24 | 2019-06-25 | ||||||
| 3794633 | 3794633 | DIVIDEND | ADD | 23381D102 | No Ex-Date set by NBB. | 0 | 0 | 1 | 0 | .322239 | 00 | ? | 2019-03-29 | 2019-06-26 | 2019-03-19 | 0 | ? | 2019-06-24 | 0 | 0005854103 | 20190624.ifs | 2019-06-24 | 2019-06-25 | ||||||
| 3405831 | 3405831 | DIVIDEND | ADD | 23381D102 | 0 | 1 | 0 | .308198 | 00 | ? | 2018-09-28 | 2018-12-10 | ? | 0 | 2018-12-05 | ? | 0 | 0005724573 | 20181206.ifs | 2018-12-06 | 2018-12-07 | ||||||||
| 3405850 | 3405850 | DIVIDEND | ADD | 23381D102 | 0 | 1 | 0 | .308198 | 00 | ? | 2018-09-28 | 2018-12-10 | ? | 0 | 2018-12-05 | ? | 0 | 0005724573 | 20181206.ifs | 2018-12-06 | 2018-12-07 | ||||||||
| 3405940 | 3405940 | DIVIDEND | DELETE | 23381D102 | 0 | 1 | 0 | .308198 | 00 | ? | 2018-09-28 | 2018-12-10 | ? | 0 | 2018-12-05 | ? | 0 | 0005724573 | 20181206.ifs | 2018-12-06 | 2018-12-07 | ||||||||
| 3405942 | 3405942 | DIVIDEND | ADD | 23381D102 | No Ex-Date set by NBB. | 0 | 0 | 1 | 0 | .308198 | 0 | 00 | ? | 2018-09-28 | 2018-12-10 | 2018-09-17 | 0 | ? | 2018-12-06 | 0 | 0005724573 | 20181206.ifs | 2018-12-06 | 2018-12-07 | |||||
| 3405951 | 3405951 | DIVIDEND | DELETE | 23381D102 | 0 | 1 | 0 | .308198 | 00 | ? | 2018-09-28 | 2018-12-10 | ? | 0 | 2018-12-05 | ? | 0 | 0005724573 | 20181206.ifs | 2018-12-06 | 2018-12-07 | ||||||||
| 3405953 | 3405953 | DIVIDEND | ADD | 23381D102 | No Ex-Date set by NBB. | 0 | 0 | 1 | 0 | .308198 | 0 | 00 | ? | 2018-09-28 | 2018-12-10 | 2018-09-17 | 0 | ? | 2018-12-06 | 0 | 0005724573 | 20181206.ifs | 2018-12-06 | 2018-12-07 | |||||
| 3287457 | 3287457 | DIVIDEND | DELETE | 23381D102 | 0 | 0 | 1 | 6 | 0 | 08 | ? | 2018-09-28 | ? | 2018-09-17 | 0 | 2018-09-17 | ? | 0 | 0005724573 | 20180918.ifs | 2018-09-18 | 2018-09-19 | |||||||
| 3287460 | 3287460 | DIVIDEND | DELETE | 23381D102 | 0 | 0 | 1 | 6 | 0 | 08 | ? | 2018-09-28 | ? | 2018-09-17 | 0 | 2018-09-17 | ? | 0 | 0005724573 | 20180918.ifs | 2018-09-18 | 2018-09-19 | |||||||
| 3286762 | 3286762 | DIVIDEND | ADD | 23381D102 | 0 | 0 | 1 | 6 | 0 | 08 | ? | 2018-09-28 | ? | 2018-09-17 | 0 | 2018-09-17 | ? | 0 | 0005724573 | 20180917.ifs | 2018-09-17 | 2018-09-18 | |||||||
| 3286763 | 3286763 | DIVIDEND | ADD | 23381D102 | 0 | 0 | 1 | 6 | 0 | 08 | ? | 2018-09-28 | ? | 2018-09-17 | 0 | 2018-09-17 | ? | 0 | 0005724573 | 20180917.ifs | 2018-09-17 | 2018-09-18 | |||||||
| 3152700 | 3152700 | DIVIDEND | ADD | 23381D102 | No Ex-Date set by NBB. | 0 | 0 | 1 | 0 | .318816 | 00 | ? | 2018-03-29 | 2018-06-26 | 2018-03-06 | 0 | ? | 2018-06-22 | 0 | 0005627258 | 20180622.ifs | 2018-06-22 | 2018-06-23 | ||||||
| 3152701 | 3152701 | DIVIDEND | ADD | 23381D102 | No Ex-Date set by NBB. | 0 | 0 | 1 | 0 | .318816 | 00 | ? | 2018-03-29 | 2018-06-26 | 2018-03-06 | 0 | ? | 2018-06-22 | 0 | 0005627258 | 20180622.ifs | 2018-06-22 | 2018-06-23 | ||||||
| 2799836 | 2799836 | DIVIDEND | DELETE | 23381D102 | 0 | 1 | 0 | .31243 | 00 | ? | 2017-09-29 | 2017-12-08 | ? | 0 | 2017-12-04 | ? | 0 | 0005498128 | 20171205.ifs | 2017-12-05 | 2017-12-06 | ||||||||
| 2799837 | 2799837 | DIVIDEND | ADD | 23381D102 | No Ex-Date set by NBB. | 0 | 0 | 1 | 0 | .31243 | 0 | 00 | ? | 2017-09-29 | 2017-12-08 | 2017-09-15 | 0 | ? | 2017-12-05 | 0 | 0005498128 | 20171205.ifs | 2017-12-05 | 2017-12-06 | |||||
| 2802257 | 2802257 | DIVIDEND | DELETE | 23381D102 | 0 | 1 | 0 | .31243 | 00 | ? | 2017-09-29 | 2017-12-08 | ? | 0 | 2017-12-04 | ? | 0 | 0005498128 | 20171205.ifs | 2017-12-05 | 2017-12-06 | ||||||||
| 2802259 | 2802259 | DIVIDEND | ADD | 23381D102 | No Ex-Date set by NBB. | 0 | 0 | 1 | 0 | .31243 | 0 | 00 | ? | 2017-09-29 | 2017-12-08 | 2017-09-15 | 0 | ? | 2017-12-05 | 0 | 0005498128 | 20171205.ifs | 2017-12-05 | 2017-12-06 | |||||
| 2798788 | 2798788 | DIVIDEND | ADD | 23381D102 | 0 | 1 | 0 | .31243 | 00 | ? | 2017-09-29 | 2017-12-08 | ? | 0 | 2017-12-04 | ? | 0 | 0005498128 | 20171204.ifs | 2017-12-04 | 2017-12-05 | ||||||||
| 2798918 | 2798918 | DIVIDEND | ADD | 23381D102 | 0 | 1 | 0 | .31243 | 00 | ? | 2017-09-29 | 2017-12-08 | ? | 0 | 2017-12-04 | ? | 0 | 0005498128 | 20171204.ifs | 2017-12-04 | 2017-12-05 | ||||||||
| 2676534 | 2676534 | DIVIDEND | DELETE | 23381D102 | 0 | 0 | 1 | 6 | 0 | 08 | ? | 2017-09-29 | ? | 2017-09-15 | 0 | 2017-09-15 | ? | 0 | 0005498128 | 20170918.ifs | 2017-09-18 | 2017-09-19 | |||||||
| 2676595 | 2676595 | DIVIDEND | DELETE | 23381D102 | 0 | 0 | 1 | 6 | 0 | 08 | ? | 2017-09-29 | ? | 2017-09-15 | 0 | 2017-09-15 | ? | 0 | 0005498128 | 20170918.ifs | 2017-09-18 | 2017-09-19 | |||||||
| 2674416 | 2674416 | DIVIDEND | ADD | 23381D102 | 0 | 0 | 1 | 6 | 0 | 08 | ? | 2017-09-29 | ? | 2017-09-15 | 0 | 2017-09-15 | ? | 0 | 0005498128 | 20170915.ifs | 2017-09-15 | 2017-09-16 | |||||||
| 2674920 | 2674920 | DIVIDEND | ADD | 23381D102 | 0 | 0 | 1 | 6 | 0 | 08 | ? | 2017-09-29 | ? | 2017-09-15 | 0 | 2017-09-15 | ? | 0 | 0005498128 | 20170915.ifs | 2017-09-15 | 2017-09-16 | |||||||
| 2599314 | 2599314 | DIVIDEND | DELETE | 23381D102 | 0 | 1 | 0 | .313707 | 00 | ? | 2017-03-30 | 2017-06-27 | ? | 0 | 2017-06-22 | ? | 0 | 0005404201 | 20170623.ifs | 2017-06-23 | 2017-06-24 | ||||||||
| 2599315 | 2599315 | DIVIDEND | ADD | 23381D102 | No Ex-Date set by NBB. | 0 | 0 | 1 | 0 | .313707 | 0 | 00 | ? | 2017-03-30 | 2017-06-27 | 2017-03-17 | 0 | ? | 2017-06-23 | 0 | 0005404201 | 20170623.ifs | 2017-06-23 | 2017-06-24 | |||||
| 2598962 | 2598962 | DIVIDEND | ADD | 23381D102 | 0 | 1 | 0 | .313707 | 00 | ? | 2017-03-30 | 2017-06-27 | ? | 0 | 2017-06-22 | ? | 0 | 0005404201 | 20170622.ifs | 2017-06-22 | 2017-06-23 | ||||||||
| 2516578 | 2516578 | DIVIDEND | DELETE | 23381D102 | 0 | 0 | 1 | 6 | 0 | 08 | ? | 2017-03-30 | ? | 2017-03-17 | 0 | 2017-03-17 | ? | 0 | 0005404201 | 20170320.ifs | 2017-03-20 | 2017-03-21 | |||||||
| 2515653 | 2515653 | DIVIDEND | ADD | 23381D102 | 0 | 0 | 1 | 6 | 0 | 08 | ? | 2017-03-30 | ? | 2017-03-17 | 0 | 2017-03-17 | ? | 0 | 0005404201 | 20170317.ifs | 2017-03-17 | 2017-03-18 | |||||||
| 2449884 | 2449884 | EQUITY | CHANGE | 23381D102 | SPONSORED ADR LEVEL 1 | 0 | 0 | 2011-11-09 | ? | 0 | no | no | no | 2011-11-09 | 2011-11-15 | ? | 20170124.ifs | 2017-01-24 | 2017-01-25 | ||||||||||
| 2449885 | 2449884 | EQUITY | CHANGE | 23381D102 | SPONSORED ADR LEVEL 1 | 0 | 0 | 2011-11-09 | ? | 2 | no | no | no | 2011-11-09 | 2011-11-15 | ? | 20170124.ifs | 2017-01-24 | 2017-01-25 | ||||||||||
| 2364769 | 2364769 | DIVIDEND | ADD | 23381D102 | No Ex-Date set by NBB. | B | 0 | 1 | 0 | .306308 | 02 | ? | 2016-09-29 | 2016-12-08 | 2016-09-08 | 0 | ? | 2016-12-08 | 0 | 0005278515 | 20161208.ifs | 2016-12-08 | 2016-12-09 | ||||||
| 2230624 | 2230624 | DIVIDEND | ADD | 23381D102 | No Ex-Date set by NBB. | B | 0 | 1 | 0 | .287084 | 02 | ? | 2016-03-30 | 2016-06-30 | 2016-03-18 | 0 | ? | 2016-06-27 | 0 | 0005189096 | 20160627.ifs | 2016-06-27 | 2016-06-28 | ||||||
| 2024152 | 2024152 | DIVIDEND | ADD | 23381D102 | No Ex-Date set by NBB. | B | 0 | 1 | 0 | .252012 | 52 | ? | 2015-09-29 | 2015-12-08 | 2015-12-03 | 0 | ? | 2015-12-04 | 0 | 0005064880 | 20151204.ifs | 2015-12-04 | 2015-12-05 | ||||||
| 1926801 | 1926801 | DIVIDEND | CHANGE | 23381D102 | B | 0 | 1 | 0 | .181459 | 52 | ? | 2015-03-30 | 2015-07-10 | 2015-07-09 | 0 | ? | 2015-07-30 | 0 | 0004970164 | 20150731.ifs | 2015-07-31 | 2015-08-01 | |||||||
| 1926802 | 1926801 | DIVIDEND | CHANGE | 23381D102 | No Ex-Date set by NBB. | B | 0 | 1 | 0 | .181459 | 0 | 52 | ? | 2015-03-30 | 2015-07-10 | 2015-07-09 | 0 | ? | 2015-07-31 | 0 | 0004970164 | 20150731.ifs | 2015-07-31 | 2015-08-01 | |||||
| 1926474 | 1926474 | DIVIDEND | DELETE | 23381D102 | No Ex-Date set by NBB. | B | 0 | 1 | 0 | .171459 | 02 | ? | 2015-03-30 | 2015-07-10 | 2015-07-09 | 0 | ? | 2015-07-10 | 0 | 0004970164 | 20150730.ifs | 2015-07-30 | 2015-07-31 | ||||||
| 1926475 | 1926475 | DIVIDEND | ADD | 23381D102 | B | 0 | 1 | 0 | .181459 | 52 | ? | 2015-03-30 | 2015-07-10 | 2015-07-09 | 0 | ? | 2015-07-30 | 0 | 0004970164 | 20150730.ifs | 2015-07-30 | 2015-07-31 | |||||||
| 1914026 | 1914026 | DIVIDEND | ADD | 23381D102 | No Ex-Date set by NBB. | B | 0 | 1 | 0 | .171459 | 02 | ? | 2015-03-30 | 2015-07-10 | 2015-07-09 | 0 | ? | 2015-07-10 | 0 | 0004970164 | 20150710.ifs | 2015-07-10 | 2015-07-11 | ||||||
| 1710454 | 1710454 | DIVIDEND | ADD | 23381D102 | B | 0 | 1 | 0 | .205374 | 02 | ? | 2014-09-29 | 2014-12-15 | 2014-08-28 | 0 | ? | 2014-12-12 | 0 | 0004832594 | 20141212.ifs | 2014-12-12 | 2014-12-13 | |||||||
| 1710455 | 1710455 | DIVIDEND | CHANGE | 23381D102 | B | 0 | 1 | 0 | .205374 | 02 | ? | 2014-09-29 | 2014-12-15 | 2014-08-28 | 0 | ? | 2014-12-12 | 0 | 0004832594 | 20141212.ifs | 2014-12-12 | 2014-12-13 | |||||||
| 1710456 | 1710455 | DIVIDEND | CHANGE | 23381D102 | No Ex-Date set by NBB. | B | 0 | 1 | 0 | .205374 | 02 | ? | 2014-09-29 | 2014-12-15 | 2014-08-28 | 0 | ? | 2014-12-12 | 0 | 0004832594 | 20141212.ifs | 2014-12-12 | 2014-12-13 | ||||||
| 1559618 | 1559618 | DIVIDEND | ADD | 23381D102 | No Ex-Date set by NBB. | B | 0 | 1 | 0 | .228257 | 02 | ? | 2014-03-28 | 2014-07-01 | 2014-03-11 | 0 | ? | 2014-06-25 | 0 | 0004749370 | 20140625.ifs | 2014-06-25 | 2014-06-26 | ||||||
| 1358394 | 1358394 | DIVIDEND | ADD | 23381D102 | No Ex-Date set by NBB. | B | 0 | 1 | 0 | .246627 | 02 | ? | 2013-09-27 | 2013-12-09 | 2013-08-23 | 0 | ? | 2013-12-05 | 0 | 0004617548 | 20131205.ifs | 2013-12-05 | 2013-12-06 | ||||||
| 1216584 | 1216584 | DIVIDEND | ADD | 23381D102 | No Ex-Date set by NBB. | B | 0 | 1 | 0 | .261117 | 02 | ? | 2013-03-28 | 2013-07-01 | 2013-03-18 | 0 | ? | 2013-06-25 | 0 | 0004542249 | 20130625.ifs | 2013-06-25 | 2013-06-26 | ||||||
| 1029081 | 1029081 | DIVIDEND | ADD | 23381D102 | B | 0 | 1 | 0 | .314786 | 02 | ? | 2012-09-27 | 2012-12-10 | 2012-09-11 | 0 | ? | 2012-12-06 | 0 | 0004428133 | 20121206.ifs | 2012-12-06 | 2012-12-07 | |||||||
| 894580 | 894580 | DIVIDEND | ADD | 23381D102 | B | 0 | 1 | 0 | .37723 | 02 | ? | 2012-03-29 | 2012-07-02 | 2012-03-16 | 0 | ? | 2012-06-27 | 0 | 0004346311 | 20120627.ifs | 2012-06-27 | 2012-06-28 | |||||||
| 714235 | 714235 | DIVIDEND | ADD | 23381D102 | B | 0 | 1 | 0 | .385733 | 02 | ? | 2011-09-29 | 2011-12-15 | 2011-09-16 | 0 | ? | 2011-12-07 | 0 | 0004243139 | 20111207.ifs | 2011-12-07 | 2011-12-08 | |||||||
| 694634 | 694634 | CORPACTION | ADD | 23381D102 | 66 | # | 2011-11-15 | 23381D102 | 66 | ? | 20111115.ifs | 2011-11-15 | 2011-11-16 | ||||||||||||||||
| 694635 | 694635 | CORPACTIONAUX | ADD | 23381D102 | 66 | 2011-11-15 | DSKYL | DAIICHI SANKYO CO LTD | SPONSORED ADR L | DSNKY | DAIICHI SANKYO CO LTD | SPONSORED ADR L | 2011-11-15 | ? | 20111115.ifs | 2011-11-15 | 2011-11-16 | ||||||||||||
| 694636 | 694636 | EXCHANGE | CHANGE | 23381D102 | 66 | 2011-11-09 | 2011-11-14 | DSKYL | 0 | 0 | 2011-11-09 | ? | 20111115.ifs | 2011-11-15 | 2011-11-16 | ||||||||||||||
| 694637 | 694636 | EXCHANGE | CHANGE | 23381D102 | 66 | 2011-11-09 | 2011-11-14 | DSNKY | 0 | 0 | 2011-11-09 | 2011-11-15 | 20111115.ifs | 2011-11-15 | 2011-11-16 | ||||||||||||||
| 694873 | 694873 | EQUITY | CHANGE | 23381D102 | SPONSORED ADR LEVEL 1 | N | 0 | 2011-11-09 | ? | 0 | no | no | no | 2011-11-09 | ? | ? | 20111115.ifs | 2011-11-15 | 2011-11-16 | ||||||||||
| 694874 | 694873 | EQUITY | CHANGE | 23381D102 | SPONSORED ADR LEVEL 1 | 0 | 0 | 2011-11-09 | ? | 0 | no | no | no | 2011-11-09 | 2011-11-15 | ? | 20111115.ifs | 2011-11-15 | 2011-11-16 | ||||||||||
| 692244 | 692244 | EQUITY | ADD | 23381D102 | SPONSORED ADR LEVEL 1 | N | 0 | 2011-11-09 | ? | 0 | no | no | no | 2011-11-09 | ? | ? | 20111109.ifs | 2011-11-09 | 2011-11-10 | ||||||||||
| 692245 | 692245 | EXCHANGE | ADD | 23381D102 | 66 | 2011-11-09 | ? | DSKYL | 0 | 0 | 2011-11-09 | ? | 20111109.ifs | 2011-11-09 | 2011-11-10 |
| 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 = 160352
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