| INSITITUIONS | Dynamic | newInstitTable | Changed the Cusip/Sector/Shs Out? |
|
||||||||||
| Total Insititutions : | 418 | 382 | Update Insititution By Cusips | |||||||||||
| % Owned by Insititutions: | 92.63 % | 88.73 % | ||||||||||||
|
pricingQuarterAdminPageOn:
|
2024-03-31 | New % | ||||||||||||
|
|
||||||||||||||
the compid is:160355 |
||||||||||||||
| 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 | ||
| 5587235 | 5587235 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .37 | 00 | 2024-07-01 | 2024-07-01 | 2024-07-03 | 2024-06-28 | 0 | 2024-06-28 | ? | 0 | 0006941443 | 20240628.ifs | 2024-06-28 | 2024-06-29 | |||||||
| 5565137 | 5565137 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .38 | 00 | 2024-06-03 | 2024-06-03 | 2024-06-05 | 2024-05-31 | 0 | 2024-05-31 | ? | 0 | 0006924135 | 20240531.ifs | 2024-05-31 | 2024-06-01 | |||||||
| 5546267 | 5546267 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .375 | 00 | 2024-05-01 | 2024-05-02 | 2024-05-06 | 2024-04-30 | 0 | 2024-04-30 | ? | 0 | 0006911134 | 20240430.ifs | 2024-04-30 | 2024-05-01 | |||||||
| 5526772 | 5526772 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .37 | 00 | 2024-04-01 | 2024-04-02 | 2024-04-04 | 2024-03-28 | 0 | 2024-03-28 | ? | 0 | 0006898294 | 20240328.ifs | 2024-03-28 | 2024-03-29 | |||||||
| 5505831 | 5505831 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .36 | 00 | 2024-03-01 | 2024-03-04 | 2024-03-06 | 2024-02-29 | 0 | 2024-02-29 | ? | 0 | 0006881489 | 20240229.ifs | 2024-02-29 | 2024-03-01 | |||||||
| 5487926 | 5487926 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .345 | 00 | 2024-02-01 | 2024-02-02 | 2024-02-06 | 2024-01-31 | 0 | 2024-01-31 | ? | 0 | 0006868775 | 20240131.ifs | 2024-01-31 | 2024-02-01 | |||||||
| 5463162 | 5463162 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .34 | 00 | 2023-12-28 | 2023-12-29 | 2024-01-03 | 2023-12-27 | 0 | 2023-12-27 | ? | 0 | 0006853144 | 20231227.ifs | 2023-12-27 | 2023-12-28 | |||||||
| 5422092 | 5422092 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .325 | 00 | 2023-12-01 | 2023-12-04 | 2023-12-06 | 2023-11-30 | 0 | 2023-11-30 | ? | 0 | 0006816326 | 20231130.ifs | 2023-11-30 | 2023-12-01 | |||||||
| 5403824 | 5403824 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .32 | 00 | 2023-11-01 | 2023-11-02 | 2023-11-06 | 2023-10-31 | 0 | 2023-10-31 | ? | 0 | 0006803836 | 20231031.ifs | 2023-10-31 | 2023-11-01 | |||||||
| 5384816 | 5384816 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .34 | 00 | 2023-10-02 | 2023-10-03 | 2023-10-05 | 2023-09-29 | 0 | 2023-09-29 | ? | 0 | 0006791283 | 20230929.ifs | 2023-09-29 | 2023-09-30 | |||||||
| 5361830 | 5361830 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .33 | 00 | 2023-09-01 | 2023-09-05 | 2023-09-07 | 2023-08-31 | 0 | 2023-08-31 | ? | 0 | 0006774177 | 20230831.ifs | 2023-08-31 | 2023-09-01 | |||||||
| 5342800 | 5342800 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .29 | 00 | 2023-08-01 | 2023-08-02 | 2023-08-04 | 2023-07-31 | 0 | 2023-07-31 | ? | 0 | 0006761037 | 20230731.ifs | 2023-07-31 | 2023-08-01 | |||||||
| 5323819 | 5323819 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .33 | 00 | 2023-07-03 | 2023-07-05 | 2023-07-07 | 2023-06-30 | 0 | 2023-06-30 | ? | 0 | 0006748243 | 20230630.ifs | 2023-06-30 | 2023-07-01 | |||||||
| 5299710 | 5299710 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .31 | 00 | 2023-06-01 | 2023-06-02 | 2023-06-06 | 2023-05-31 | 0 | 2023-05-31 | ? | 0 | 0006730387 | 20230531.ifs | 2023-05-31 | 2023-06-01 | |||||||
| 5279795 | 5279795 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .295 | 00 | 2023-05-01 | 2023-05-02 | 2023-05-04 | 2023-04-28 | 0 | 2023-04-28 | ? | 0 | 0006717274 | 20230428.ifs | 2023-04-28 | 2023-04-29 | |||||||
| 5260319 | 5260319 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .3 | 00 | 2023-04-03 | 2023-04-04 | 2023-04-06 | 2023-03-31 | 0 | 2023-03-31 | ? | 0 | 0006704437 | 20230331.ifs | 2023-03-31 | 2023-04-01 | |||||||
| 5236964 | 5236964 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .29 | 00 | 2023-03-01 | 2023-03-02 | 2023-03-06 | 2023-02-28 | 0 | 2023-02-28 | ? | 0 | 0006687810 | 20230228.ifs | 2023-02-28 | 2023-03-01 | |||||||
| 5219666 | 5219666 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .28 | 00 | 2023-02-01 | 2023-02-02 | 2023-02-06 | 2023-01-31 | 0 | 2023-01-31 | ? | 0 | 0006674533 | 20230131.ifs | 2023-01-31 | 2023-02-01 | |||||||
| 5192431 | 5192431 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .29 | 00 | 2022-12-29 | 2022-12-30 | 2023-01-04 | 2022-12-28 | 0 | 2022-12-28 | ? | 0 | 0006657242 | 20221228.ifs | 2022-12-28 | 2022-12-29 | |||||||
| 5160156 | 5160156 | DIVIDEND | ADD | 72201R775 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2022-12-15 | 2022-12-09 | 0 | 2022-12-09 | ? | 0 | 0006628426 | 20221209.ifs | 2022-12-09 | 2022-12-10 | |||||||
| 5146946 | 5146946 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .28 | 00 | 2022-12-01 | 2022-12-02 | 2022-12-06 | 2022-11-30 | 0 | 2022-11-30 | ? | 0 | 0006617311 | 20221130.ifs | 2022-11-30 | 2022-12-01 | |||||||
| 5139397 | 5139397 | CORPACTION | ADD | 72201R775 | 04 | X | 2022-11-14 | 72201R775 | 01 | ? | 20221114.ifs | 2022-11-14 | 2022-11-15 | ||||||||||||||||
| 5139398 | 5139398 | EXCHANGE | ADD | 72201R775 | 01 | 2022-11-14 | 2022-11-14 | BOND | 0 | A | 2022-11-14 | ? | 20221114.ifs | 2022-11-14 | 2022-11-15 | ||||||||||||||
| 5128226 | 5128226 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .27 | 00 | 2022-11-01 | 2022-11-02 | 2022-11-04 | 2022-10-31 | 0 | 2022-10-31 | ? | 0 | 0006604584 | 20221031.ifs | 2022-10-31 | 2022-11-01 | |||||||
| 5109131 | 5109131 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .27 | 00 | 2022-10-03 | 2022-10-04 | 2022-10-06 | 2022-09-30 | 0 | 2022-09-30 | ? | 0 | 0006591847 | 20220930.ifs | 2022-09-30 | 2022-10-01 | |||||||
| 5086027 | 5086027 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .27 | 00 | 2022-09-01 | 2022-09-02 | 2022-09-07 | 2022-08-31 | 0 | 2022-08-31 | ? | 0 | 0006575174 | 20220831.ifs | 2022-08-31 | 2022-09-01 | |||||||
| 5066462 | 5066462 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .27 | 00 | 2022-08-01 | 2022-08-02 | 2022-08-04 | 2022-07-29 | 0 | 2022-07-29 | ? | 0 | 0006561164 | 20220729.ifs | 2022-07-29 | 2022-07-30 | |||||||
| 5046591 | 5046591 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .26 | 00 | 2022-07-01 | 2022-07-05 | 2022-07-07 | 2022-06-30 | 0 | 2022-06-30 | ? | 0 | 0006547839 | 20220630.ifs | 2022-06-30 | 2022-07-01 | |||||||
| 5020359 | 5020359 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .25 | 00 | 2022-06-01 | 2022-06-02 | 2022-06-06 | 2022-05-31 | 0 | 2022-05-31 | ? | 0 | 0006529139 | 20220531.ifs | 2022-05-31 | 2022-06-01 | |||||||
| 5000989 | 5000989 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .25 | 00 | 2022-05-02 | 2022-05-03 | 2022-05-05 | 2022-04-29 | 0 | 2022-04-29 | ? | 0 | 0006515675 | 20220429.ifs | 2022-04-29 | 2022-04-30 | |||||||
| 4982502 | 4982502 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .24 | 00 | 2022-04-01 | 2022-04-04 | 2022-04-06 | 2022-03-31 | 0 | 2022-03-31 | ? | 0 | 0006503463 | 20220331.ifs | 2022-03-31 | 2022-04-01 | |||||||
| 4959620 | 4959620 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .23 | 00 | 2022-03-01 | 2022-03-02 | 2022-03-04 | 2022-02-28 | 0 | 2022-02-28 | ? | 0 | 0006485426 | 20220228.ifs | 2022-02-28 | 2022-03-01 | |||||||
| 4942447 | 4942447 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .23 | 00 | 2022-02-01 | 2022-02-02 | 2022-02-04 | 2022-01-31 | 0 | 2022-01-31 | ? | 0 | 0006472622 | 20220131.ifs | 2022-01-31 | 2022-02-01 | |||||||
| 4918287 | 4918287 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .23 | 00 | 2021-12-30 | 2021-12-31 | 2022-01-04 | 2021-12-29 | 0 | 2021-12-29 | ? | 0 | 0006454408 | 20211229.ifs | 2021-12-29 | 2021-12-30 | |||||||
| 4856136 | 4856136 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .23 | 00 | 2021-12-01 | 2021-12-02 | 2021-12-06 | 2021-11-30 | 0 | 2021-11-30 | ? | 0 | 0006401374 | 20211130.ifs | 2021-11-30 | 2021-12-01 | |||||||
| 4835993 | 4835993 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .23 | 00 | 2021-11-01 | 2021-11-02 | 2021-11-04 | 2021-10-29 | 0 | 2021-10-29 | ? | 0 | 0006388645 | 20211029.ifs | 2021-10-29 | 2021-10-30 | |||||||
| 4814568 | 4814568 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .24 | 00 | 2021-10-01 | 2021-10-04 | 2021-10-06 | 2021-09-30 | 0 | 2021-09-30 | ? | 0 | 0006375826 | 20210930.ifs | 2021-09-30 | 2021-10-01 | |||||||
| 4789960 | 4789960 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .24 | 00 | 2021-09-01 | 2021-09-02 | 2021-09-07 | 2021-08-31 | 0 | 2021-08-31 | ? | 0 | 0006358503 | 20210831.ifs | 2021-08-31 | 2021-09-01 | |||||||
| 4768849 | 4768849 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .24 | 00 | 2021-08-02 | 2021-08-03 | 2021-08-05 | 2021-07-30 | 0 | 2021-07-30 | ? | 0 | 0006345058 | 20210730.ifs | 2021-07-30 | 2021-07-31 | |||||||
| 4743684 | 4743684 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .24 | 00 | 2021-07-01 | 2021-07-02 | 2021-07-07 | 2021-06-30 | 0 | 2021-06-30 | ? | 0 | 0006331155 | 20210630.ifs | 2021-06-30 | 2021-07-01 | |||||||
| 4714386 | 4714386 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .24 | 00 | 2021-06-01 | 2021-06-02 | 2021-06-04 | 2021-05-28 | 0 | 2021-05-28 | ? | 0 | 0006312604 | 20210528.ifs | 2021-05-28 | 2021-05-29 | |||||||
| 4692662 | 4692662 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .24 | 00 | 2021-05-03 | 2021-05-04 | 2021-05-06 | 2021-04-30 | 0 | 2021-04-30 | ? | 0 | 0006299568 | 20210430.ifs | 2021-04-30 | 2021-05-01 | |||||||
| 4668359 | 4668359 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .23 | 00 | 2021-04-01 | 2021-04-05 | 2021-04-07 | 2021-03-31 | 0 | 2021-03-31 | ? | 0 | 0006286142 | 20210331.ifs | 2021-03-31 | 2021-04-01 | |||||||
| 4638782 | 4638782 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .23 | 00 | 2021-03-01 | 2021-03-02 | 2021-03-04 | 2021-02-26 | 0 | 2021-02-26 | ? | 0 | 0006268890 | 20210226.ifs | 2021-02-26 | 2021-02-27 | |||||||
| 4615692 | 4615692 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .23 | 00 | 2021-02-01 | 2021-02-02 | 2021-02-04 | 2021-01-29 | 0 | 2021-01-29 | ? | 0 | 0006255951 | 20210129.ifs | 2021-01-29 | 2021-01-30 | |||||||
| 4578319 | 4578319 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .23 | 00 | 2020-12-30 | 2020-12-31 | 2021-01-05 | 2020-12-29 | 0 | 2020-12-29 | ? | 0 | 0006237898 | 20201229.ifs | 2020-12-29 | 2020-12-30 | |||||||
| 4517370 | 4517370 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .23 | 00 | 2020-12-01 | 2020-12-02 | 2020-12-04 | 2020-11-30 | 0 | 2020-11-30 | ? | 0 | 0006192982 | 20201130.ifs | 2020-11-30 | 2020-12-01 | |||||||
| 4495436 | 4495436 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .23 | 00 | 2020-11-02 | 2020-11-03 | 2020-11-05 | 2020-10-30 | 0 | 2020-10-30 | ? | 0 | 0006180525 | 20201030.ifs | 2020-10-30 | 2020-10-31 | |||||||
| 4473863 | 4473863 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .23 | 00 | 2020-10-01 | 2020-10-02 | 2020-10-06 | 2020-09-30 | 0 | 2020-09-30 | ? | 0 | 0006167312 | 20200930.ifs | 2020-09-30 | 2020-10-01 | |||||||
| 4449075 | 4449075 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .23 | 00 | 2020-09-01 | 2020-09-02 | 2020-09-04 | 2020-08-31 | 0 | 2020-08-31 | ? | 0 | 0006149466 | 20200831.ifs | 2020-08-31 | 2020-09-01 | |||||||
| 4428859 | 4428859 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .24405 | 00 | 2020-08-03 | 2020-08-04 | 2020-08-06 | 2020-07-31 | 0 | 2020-07-31 | ? | 0 | 0006135845 | 20200731.ifs | 2020-07-31 | 2020-08-01 | |||||||
| 4406005 | 4406005 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .25 | 00 | 2020-07-01 | 2020-07-02 | 2020-07-07 | 2020-06-30 | 0 | 2020-06-30 | ? | 0 | 0006122475 | 20200630.ifs | 2020-06-30 | 2020-07-01 | |||||||
| 4354314 | 4354314 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .24 | 00 | 2020-06-01 | 2020-06-02 | 2020-06-04 | 2020-05-29 | 0 | 2020-05-29 | ? | 0 | 0006103789 | 20200529.ifs | 2020-05-29 | 2020-05-30 | |||||||
| 4354509 | 4354509 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .24 | 00 | 2020-06-01 | 2020-06-02 | 2020-06-04 | 2020-05-29 | 0 | 2020-05-29 | ? | 0 | 0006103789 | 20200529.ifs | 2020-05-29 | 2020-05-30 | |||||||
| 4308879 | 4308879 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .26 | 00 | 2020-05-01 | 2020-05-04 | 2020-05-06 | 2020-04-30 | 0 | 2020-04-30 | ? | 0 | 0006090692 | 20200430.ifs | 2020-04-30 | 2020-05-01 | |||||||
| 4308880 | 4308880 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .26 | 00 | 2020-05-01 | 2020-05-04 | 2020-05-06 | 2020-04-30 | 0 | 2020-04-30 | ? | 0 | 0006090692 | 20200430.ifs | 2020-04-30 | 2020-05-01 | |||||||
| 4265386 | 4265386 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .28 | 00 | 2020-04-01 | 2020-04-02 | 2020-04-06 | 2020-03-31 | 0 | 2020-03-31 | ? | 0 | 0006077408 | 20200331.ifs | 2020-03-31 | 2020-04-01 | |||||||
| 4265588 | 4265588 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .28 | 00 | 2020-04-01 | 2020-04-02 | 2020-04-06 | 2020-03-31 | 0 | 2020-03-31 | ? | 0 | 0006077408 | 20200331.ifs | 2020-03-31 | 2020-04-01 | |||||||
| 4221778 | 4221778 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .29 | 00 | 2020-03-02 | 2020-03-03 | 2020-03-05 | 2020-02-28 | 0 | 2020-02-28 | ? | 0 | 0006060226 | 20200228.ifs | 2020-02-28 | 2020-02-29 | |||||||
| 4221781 | 4221781 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .29 | 00 | 2020-03-02 | 2020-03-03 | 2020-03-05 | 2020-02-28 | 0 | 2020-02-28 | ? | 0 | 0006060226 | 20200228.ifs | 2020-02-28 | 2020-02-29 | |||||||
| 4185448 | 4185448 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .29 | 00 | 2020-02-03 | 2020-02-04 | 2020-02-06 | 2020-01-31 | 0 | 2020-01-31 | ? | 0 | 0006047418 | 20200131.ifs | 2020-01-31 | 2020-02-01 | |||||||
| 4185531 | 4185531 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .29 | 00 | 2020-02-03 | 2020-02-04 | 2020-02-06 | 2020-01-31 | 0 | 2020-01-31 | ? | 0 | 0006047418 | 20200131.ifs | 2020-01-31 | 2020-02-01 | |||||||
| 4126265 | 4126265 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .29 | 00 | 2019-12-30 | 2019-12-31 | 2020-01-03 | 2019-12-27 | 0 | 2019-12-27 | ? | 0 | 0006027983 | 20191227.ifs | 2019-12-27 | 2019-12-28 | |||||||
| 4126384 | 4126384 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .29 | 00 | 2019-12-30 | 2019-12-31 | 2020-01-03 | 2019-12-27 | 0 | 2019-12-27 | ? | 0 | 0006027983 | 20191227.ifs | 2019-12-27 | 2019-12-28 | |||||||
| 3992481 | 3992481 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .3 | 00 | 2019-11-01 | 2019-11-04 | 2019-11-06 | 2019-10-31 | 0 | 2019-10-31 | ? | 0 | 0005967758 | 20191031.ifs | 2019-10-31 | 2019-11-01 | |||||||
| 3992528 | 3992528 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .3 | 00 | 2019-11-01 | 2019-11-04 | 2019-11-06 | 2019-10-31 | 0 | 2019-10-31 | ? | 0 | 0005967758 | 20191031.ifs | 2019-10-31 | 2019-11-01 | |||||||
| 3948494 | 3948494 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .3 | 00 | 2019-10-01 | 2019-10-02 | 2019-10-04 | 2019-09-30 | 0 | 2019-09-30 | ? | 0 | 0005954521 | 20190930.ifs | 2019-09-30 | 2019-10-01 | |||||||
| 3948499 | 3948499 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .3 | 00 | 2019-10-01 | 2019-10-02 | 2019-10-04 | 2019-09-30 | 0 | 2019-09-30 | ? | 0 | 0005954521 | 20190930.ifs | 2019-09-30 | 2019-10-01 | |||||||
| 3898446 | 3898446 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .3 | 00 | 2019-09-03 | 2019-09-04 | 2019-09-06 | 2019-08-30 | 0 | 2019-08-30 | ? | 0 | 0005936154 | 20190830.ifs | 2019-08-30 | 2019-08-31 | |||||||
| 3898531 | 3898531 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .3 | 00 | 2019-09-03 | 2019-09-04 | 2019-09-06 | 2019-08-30 | 0 | 2019-08-30 | ? | 0 | 0005936154 | 20190830.ifs | 2019-08-30 | 2019-08-31 | |||||||
| 3856064 | 3856064 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .31 | 00 | 2019-08-01 | 2019-08-02 | 2019-08-06 | 2019-07-31 | 0 | 2019-07-31 | ? | 0 | 0005921944 | 20190731.ifs | 2019-07-31 | 2019-08-01 | |||||||
| 3856069 | 3856069 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .31 | 00 | 2019-08-01 | 2019-08-02 | 2019-08-06 | 2019-07-31 | 0 | 2019-07-31 | ? | 0 | 0005921944 | 20190731.ifs | 2019-07-31 | 2019-08-01 | |||||||
| 3809894 | 3809894 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .3 | 00 | 2019-07-01 | 2019-07-02 | 2019-07-05 | 2019-06-28 | 0 | 2019-06-28 | ? | 0 | 0005908939 | 20190628.ifs | 2019-06-28 | 2019-06-29 | |||||||
| 3809974 | 3809974 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .3 | 00 | 2019-07-01 | 2019-07-02 | 2019-07-05 | 2019-06-28 | 0 | 2019-06-28 | ? | 0 | 0005908939 | 20190628.ifs | 2019-06-28 | 2019-06-29 | |||||||
| 3749106 | 3749106 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .3 | 00 | 2019-06-03 | 2019-06-04 | 2019-06-06 | 2019-05-31 | 0 | 2019-05-31 | ? | 0 | 0005889239 | 20190531.ifs | 2019-05-31 | 2019-06-01 | |||||||
| 3749115 | 3749115 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .3 | 00 | 2019-06-03 | 2019-06-04 | 2019-06-06 | 2019-05-31 | 0 | 2019-05-31 | ? | 0 | 0005889239 | 20190531.ifs | 2019-05-31 | 2019-06-01 | |||||||
| 3701772 | 3701772 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .3 | 00 | 2019-05-01 | 2019-05-02 | 2019-05-06 | 2019-04-30 | 0 | 2019-04-30 | ? | 0 | 0005875574 | 20190430.ifs | 2019-04-30 | 2019-05-01 | |||||||
| 3701773 | 3701773 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .3 | 00 | 2019-05-01 | 2019-05-02 | 2019-05-06 | 2019-04-30 | 0 | 2019-04-30 | ? | 0 | 0005875574 | 20190430.ifs | 2019-04-30 | 2019-05-01 | |||||||
| 3658333 | 3658333 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .31 | 00 | 2019-04-01 | 2019-04-02 | 2019-04-04 | 2019-03-29 | 0 | 2019-03-29 | ? | 0 | 0005862282 | 20190329.ifs | 2019-03-29 | 2019-03-30 | |||||||
| 3658371 | 3658371 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .31 | 00 | 2019-04-01 | 2019-04-02 | 2019-04-04 | 2019-03-29 | 0 | 2019-03-29 | ? | 0 | 0005862282 | 20190329.ifs | 2019-03-29 | 2019-03-30 | |||||||
| 3600480 | 3600480 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .32 | 00 | 2019-03-01 | 2019-03-04 | 2019-03-06 | 2019-02-28 | 0 | 2019-02-28 | ? | 0 | 0005844270 | 20190228.ifs | 2019-02-28 | 2019-03-01 | |||||||
| 3600884 | 3600884 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .32 | 00 | 2019-03-01 | 2019-03-04 | 2019-03-06 | 2019-02-28 | 0 | 2019-02-28 | ? | 0 | 0005844270 | 20190228.ifs | 2019-02-28 | 2019-03-01 | |||||||
| 3568860 | 3568860 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .32 | 00 | 2019-02-01 | 2019-02-04 | 2019-02-06 | 2019-01-31 | 0 | 2019-01-31 | ? | 0 | 0005830941 | 20190131.ifs | 2019-01-31 | 2019-02-01 | |||||||
| 3568867 | 3568867 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .32 | 00 | 2019-02-01 | 2019-02-04 | 2019-02-06 | 2019-01-31 | 0 | 2019-01-31 | ? | 0 | 0005830941 | 20190131.ifs | 2019-01-31 | 2019-02-01 | |||||||
| 3500885 | 3500885 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .3 | 00 | 2018-12-28 | 2018-12-31 | 2019-01-03 | 2018-12-27 | 0 | 2018-12-27 | ? | 0 | 0005810502 | 20181227.ifs | 2018-12-27 | 2018-12-28 | |||||||
| 3502666 | 3502666 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .3 | 00 | 2018-12-28 | 2018-12-31 | 2019-01-03 | 2018-12-27 | 0 | 2018-12-27 | ? | 0 | 0005810502 | 20181227.ifs | 2018-12-27 | 2018-12-28 | |||||||
| 3389321 | 3389321 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .32 | 00 | 2018-12-03 | 2018-12-04 | 2018-12-06 | 2018-11-30 | 0 | 2018-11-30 | ? | 0 | 0005760394 | 20181130.ifs | 2018-11-30 | 2018-12-01 | |||||||
| 3389405 | 3389405 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .32 | 00 | 2018-12-03 | 2018-12-04 | 2018-12-06 | 2018-11-30 | 0 | 2018-11-30 | ? | 0 | 0005760394 | 20181130.ifs | 2018-11-30 | 2018-12-01 | |||||||
| 3347042 | 3347042 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .32 | 00 | 2018-11-01 | 2018-11-02 | 2018-11-06 | 2018-10-31 | 0 | 2018-10-31 | ? | 0 | 0005746275 | 20181031.ifs | 2018-10-31 | 2018-11-01 | |||||||
| 3347090 | 3347090 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .32 | 00 | 2018-11-01 | 2018-11-02 | 2018-11-06 | 2018-10-31 | 0 | 2018-10-31 | ? | 0 | 0005746275 | 20181031.ifs | 2018-10-31 | 2018-11-01 | |||||||
| 3305595 | 3305595 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .3 | 00 | 2018-10-01 | 2018-10-02 | 2018-10-04 | 2018-09-28 | 0 | 2018-09-28 | ? | 0 | 0005732786 | 20180928.ifs | 2018-09-28 | 2018-09-29 | |||||||
| 3305610 | 3305610 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .3 | 00 | 2018-10-01 | 2018-10-02 | 2018-10-04 | 2018-09-28 | 0 | 2018-09-28 | ? | 0 | 0005732786 | 20180928.ifs | 2018-09-28 | 2018-09-29 | |||||||
| 3256492 | 3256492 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .3 | 00 | 2018-09-04 | 2018-09-05 | 2018-09-07 | 2018-08-31 | 0 | 2018-08-31 | ? | 0 | 0005714099 | 20180831.ifs | 2018-08-31 | 2018-09-01 | |||||||
| 3256549 | 3256549 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .3 | 00 | 2018-09-04 | 2018-09-05 | 2018-09-07 | 2018-08-31 | 0 | 2018-08-31 | ? | 0 | 0005714099 | 20180831.ifs | 2018-08-31 | 2018-09-01 | |||||||
| 3213225 | 3213225 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .29 | 00 | 2018-08-01 | 2018-08-02 | 2018-08-06 | 2018-07-31 | 0 | 2018-07-31 | ? | 0 | 0005699811 | 20180731.ifs | 2018-07-31 | 2018-08-01 | |||||||
| 3213675 | 3213675 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .29 | 00 | 2018-08-01 | 2018-08-02 | 2018-08-06 | 2018-07-31 | 0 | 2018-07-31 | ? | 0 | 0005699811 | 20180731.ifs | 2018-07-31 | 2018-08-01 | |||||||
| 3166587 | 3166587 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .3 | 00 | 2018-07-02 | 2018-07-03 | 2018-07-06 | 2018-06-29 | 0 | 2018-06-29 | ? | 0 | 0005685778 | 20180629.ifs | 2018-06-29 | 2018-06-30 | |||||||
| 3166630 | 3166630 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .3 | 00 | 2018-07-02 | 2018-07-03 | 2018-07-06 | 2018-06-29 | 0 | 2018-06-29 | ? | 0 | 0005685778 | 20180629.ifs | 2018-06-29 | 2018-06-30 | |||||||
| 3110067 | 3110067 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .3 | 00 | 2018-06-01 | 2018-06-04 | 2018-06-06 | 2018-05-31 | 0 | 2018-05-31 | ? | 0 | 0005666480 | 20180531.ifs | 2018-05-31 | 2018-06-01 | |||||||
| 3110562 | 3110562 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .3 | 00 | 2018-06-01 | 2018-06-04 | 2018-06-06 | 2018-05-31 | 0 | 2018-05-31 | ? | 0 | 0005666480 | 20180531.ifs | 2018-05-31 | 2018-06-01 | |||||||
| 3061314 | 3061314 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .295 | 00 | 2018-05-01 | 2018-05-02 | 2018-05-04 | 2018-04-30 | 0 | 2018-04-30 | ? | 0 | 0005652802 | 20180430.ifs | 2018-04-30 | 2018-05-01 | |||||||
| 3061319 | 3061319 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .295 | 00 | 2018-05-01 | 2018-05-02 | 2018-05-04 | 2018-04-30 | 0 | 2018-04-30 | ? | 0 | 0005652802 | 20180430.ifs | 2018-04-30 | 2018-05-01 | |||||||
| 3014256 | 3014256 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .35 | 00 | 2018-04-02 | 2018-04-03 | 2018-04-05 | 2018-03-29 | 0 | 2018-03-29 | ? | 0 | 0005639212 | 20180329.ifs | 2018-03-29 | 2018-03-30 | |||||||
| 2968974 | 2968974 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .22 | 00 | 2018-03-01 | 2018-03-02 | 2018-03-06 | 2018-02-28 | 0 | 2018-02-28 | ? | 0 | 0005620398 | 20180228.ifs | 2018-02-28 | 2018-03-01 | |||||||
| 2936517 | 2936517 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .27 | 00 | 2018-02-01 | 2018-02-02 | 2018-02-06 | 2018-01-31 | 0 | 2018-01-31 | ? | 0 | 0005606936 | 20180131.ifs | 2018-01-31 | 2018-02-01 | |||||||
| 2872464 | 2872464 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .26935 | 00 | 2017-12-28 | 2017-12-29 | 2018-01-03 | 2017-12-27 | 0 | 2017-12-27 | ? | 0 | 0005584886 | 20171227.ifs | 2017-12-27 | 2017-12-28 | |||||||
| 2878593 | 2878593 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .26935 | 00 | 2017-12-28 | 2017-12-29 | 2018-01-03 | 2017-12-27 | 0 | 2017-12-27 | ? | 0 | 0005584886 | 20171227.ifs | 2017-12-27 | 2017-12-28 | |||||||
| 2782740 | 2782740 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .275 | 00 | 2017-12-01 | 2017-12-04 | 2017-12-06 | 2017-11-30 | 0 | 2017-11-30 | ? | 0 | 0005535795 | 20171204.ifs | 2017-12-04 | 2017-12-05 | |||||||
| 2782799 | 2782799 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .275 | 00 | 2017-12-01 | 2017-12-04 | 2017-12-06 | 2017-11-30 | 0 | 2017-11-30 | ? | 0 | 0005535795 | 20171204.ifs | 2017-12-04 | 2017-12-05 | |||||||
| 2742890 | 2742890 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .275 | 00 | 2017-11-01 | 2017-11-02 | 2017-11-06 | 2017-10-31 | 0 | 2017-10-31 | ? | 0 | 0005520887 | 20171031.ifs | 2017-10-31 | 2017-11-01 | |||||||
| 2743507 | 2743507 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .275 | 00 | 2017-11-01 | 2017-11-02 | 2017-11-06 | 2017-10-31 | 0 | 2017-10-31 | ? | 0 | 0005520887 | 20171031.ifs | 2017-10-31 | 2017-11-01 | |||||||
| 2696234 | 2696234 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .29 | 00 | 2017-10-02 | 2017-10-03 | 2017-10-05 | 2017-09-29 | 0 | 2017-09-29 | ? | 0 | 0005506569 | 20170929.ifs | 2017-09-29 | 2017-09-30 | |||||||
| 2696574 | 2696574 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .29 | 00 | 2017-10-02 | 2017-10-03 | 2017-10-05 | 2017-09-29 | 0 | 2017-09-29 | ? | 0 | 0005506569 | 20170929.ifs | 2017-09-29 | 2017-09-30 | |||||||
| 2658921 | 2658921 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .29 | 00 | 2017-09-01 | 2017-09-06 | 2017-09-08 | 2017-08-31 | 0 | 2017-08-31 | ? | 0 | 0005488397 | 20170831.ifs | 2017-08-31 | 2017-09-01 | |||||||
| 2635111 | 2635111 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .26 | 00 | 2017-08-01 | 2017-08-03 | 2017-08-07 | 2017-07-31 | 0 | 2017-07-31 | ? | 0 | 0005473901 | 20170731.ifs | 2017-07-31 | 2017-08-01 | |||||||
| 2607973 | 2607973 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .23 | 00 | 2017-07-03 | 2017-07-06 | 2017-07-10 | 2017-06-30 | 0 | 2017-06-30 | ? | 0 | 0005459964 | 20170630.ifs | 2017-06-30 | 2017-07-01 | |||||||
| 2577525 | 2577525 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .23 | 00 | 2017-06-01 | 2017-06-05 | 2017-06-07 | 2017-05-31 | 0 | 2017-05-31 | ? | 0 | 0005440177 | 20170531.ifs | 2017-05-31 | 2017-06-01 | |||||||
| 2568826 | 2568826 | CORPACTION | ADD | 72201R775 | 04 | # | 2017-05-17 | 72201R775 | 04 | ? | 20170517.ifs | 2017-05-17 | 2017-05-18 | ||||||||||||||||
| 2568827 | 2568827 | CORPACTIONAUX | ADD | 72201R775 | 04 | 2017-05-17 | BOND | PIMCO ETF TR | PIMCO ETF TRUST | BOND | PIMCO ETF TR | ACTIVE BOND ETF | 2017-05-17 | ? | 20170517.ifs | 2017-05-17 | 2017-05-18 | ||||||||||||
| 2568828 | 2568828 | EQUITY | CHANGE | 72201R775 | TOTAL RETURN ACTIVE ETF | 0 | A | 2012-03-01 | ? | 5 | no | no | no | 2012-03-01 | 2014-10-31 | ? | 20170517.ifs | 2017-05-17 | 2017-05-18 | ||||||||||
| 2568829 | 2568828 | EQUITY | CHANGE | 72201R775 | ACTIVE BOND ETF | 0 | A | 2012-03-01 | ? | 5 | no | no | no | 2012-03-01 | 2017-05-17 | ? | 20170517.ifs | 2017-05-17 | 2017-05-18 | ||||||||||
| 2551250 | 2551250 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .2 | 00 | 2017-05-01 | 2017-05-03 | 2017-05-05 | 2017-04-28 | 0 | 2017-04-28 | ? | 0 | 0005426242 | 20170428.ifs | 2017-04-28 | 2017-04-29 | |||||||
| 2526845 | 2526845 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .24 | 00 | 2017-04-03 | 2017-04-05 | 2017-04-07 | 2017-03-31 | 0 | 2017-03-31 | ? | 0 | 0005412538 | 20170331.ifs | 2017-03-31 | 2017-04-01 | |||||||
| 2498784 | 2498784 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .23 | 00 | 2017-03-01 | 2017-03-03 | 2017-03-07 | 2017-02-28 | 0 | 2017-02-28 | ? | 0 | 0005393376 | 20170228.ifs | 2017-02-28 | 2017-03-01 | |||||||
| 2477236 | 2477236 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .25 | 00 | 2017-02-01 | 2017-02-03 | 2017-02-07 | 2017-01-31 | 0 | 2017-01-31 | ? | 0 | 0005380255 | 20170131.ifs | 2017-01-31 | 2017-02-01 | |||||||
| 2398072 | 2398072 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .68 | 00 | 2016-12-28 | 2016-12-30 | 2017-01-04 | 2016-12-27 | 0 | 2016-12-27 | ? | 0 | 0005355983 | 20161227.ifs | 2016-12-27 | 2016-12-28 | |||||||
| 2352287 | 2352287 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .24 | 00 | 2016-12-01 | 2016-12-05 | 2016-12-07 | 2016-11-30 | 0 | 2016-11-30 | ? | 0 | 0005316740 | 20161130.ifs | 2016-11-30 | 2016-12-01 | |||||||
| 2330714 | 2330714 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .19 | 00 | 2016-11-01 | 2016-11-03 | 2016-11-07 | 2016-10-31 | 0 | 2016-10-31 | ? | 0 | 0005303507 | 20161031.ifs | 2016-10-31 | 2016-11-01 | |||||||
| 2307792 | 2307792 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .33 | 00 | 2016-10-03 | 2016-10-05 | 2016-10-07 | 2016-09-30 | 0 | 2016-09-30 | ? | 0 | 0005290151 | 20160930.ifs | 2016-09-30 | 2016-10-01 | |||||||
| 2281230 | 2281230 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .3 | 00 | 2016-09-01 | 2016-09-06 | 2016-09-08 | 2016-08-31 | 0 | 2016-08-31 | ? | 0 | 0005272477 | 20160831.ifs | 2016-08-31 | 2016-09-01 | |||||||
| 2260786 | 2260786 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .24 | 00 | 2016-08-01 | 2016-08-03 | 2016-08-05 | 2016-07-29 | 0 | 2016-07-29 | ? | 0 | 0005257029 | 20160729.ifs | 2016-07-29 | 2016-07-30 | |||||||
| 2237289 | 2237289 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .19 | 00 | 2016-07-01 | 2016-07-06 | 2016-07-08 | 2016-06-30 | 0 | 2016-06-30 | ? | 0 | 0005243245 | 20160630.ifs | 2016-06-30 | 2016-07-01 | |||||||
| 2206323 | 2206323 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .12 | 00 | 2016-06-01 | 2016-06-03 | 2016-06-07 | 2016-05-31 | 0 | 2016-05-31 | ? | 0 | 0005224066 | 20160531.ifs | 2016-05-31 | 2016-06-01 | |||||||
| 2182687 | 2182687 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .16 | 00 | 2016-05-02 | 2016-05-04 | 2016-05-06 | 2016-04-29 | 0 | 2016-04-29 | ? | 0 | 0005210742 | 20160429.ifs | 2016-04-29 | 2016-04-30 | |||||||
| 2149130 | 2149130 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .16 | 00 | 2016-04-01 | 2016-04-05 | 2016-04-07 | 2016-03-31 | 0 | 2016-03-31 | ? | 0 | 0005196327 | 20160331.ifs | 2016-03-31 | 2016-04-01 | |||||||
| 2122040 | 2122040 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .16 | 00 | 2016-03-01 | 2016-03-03 | 2016-03-07 | 2016-02-29 | 0 | 2016-02-29 | ? | 0 | 0005178496 | 20160229.ifs | 2016-02-29 | 2016-03-01 | |||||||
| 2101583 | 2101583 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .2 | 00 | 2016-02-01 | 2016-02-03 | 2016-02-05 | 2016-01-29 | 0 | 2016-01-29 | ? | 0 | 0005164615 | 20160129.ifs | 2016-01-29 | 2016-01-30 | |||||||
| 2066235 | 2066235 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | 1.14 | 00 | 2015-12-29 | 2015-12-31 | 2016-01-05 | 2015-12-28 | 0 | 2015-12-28 | ? | 0 | 0005141136 | 20151228.ifs | 2015-12-28 | 2015-12-29 | |||||||
| 2000702 | 2000702 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .39 | 00 | 2015-11-02 | 2015-11-04 | 2015-11-06 | 2015-10-30 | 0 | 2015-10-30 | ? | 0 | 0005084687 | 20151030.ifs | 2015-10-30 | 2015-10-31 | |||||||
| 1974567 | 1974567 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .39 | 00 | 2015-09-30 | 2015-10-02 | 2015-10-06 | 2015-09-29 | 0 | 2015-09-29 | ? | 0 | 0005069569 | 20150929.ifs | 2015-09-29 | 2015-09-30 | |||||||
| 1949606 | 1949606 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .37 | 00 | 2015-08-31 | 2015-09-02 | 2015-09-04 | 2015-08-28 | 0 | 2015-08-28 | ? | 0 | 0005052160 | 20150828.ifs | 2015-08-28 | 2015-08-29 | |||||||
| 1926046 | 1926046 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .3 | 00 | 2015-07-31 | 2015-08-04 | 2015-08-06 | 2015-07-30 | 0 | 2015-07-30 | ? | 0 | 0005037601 | 20150730.ifs | 2015-07-30 | 2015-07-31 | |||||||
| 1898357 | 1898357 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .3 | 00 | 2015-06-30 | 2015-07-02 | 2015-07-07 | 2015-06-29 | 0 | 2015-06-29 | ? | 0 | 0005022254 | 20150629.ifs | 2015-06-29 | 2015-06-30 | |||||||
| 1871829 | 1871829 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .3 | 00 | 2015-05-29 | 2015-06-02 | 2015-06-04 | 2015-05-28 | 0 | 2015-05-28 | ? | 0 | 0005004484 | 20150528.ifs | 2015-05-28 | 2015-05-29 | |||||||
| 1849888 | 1849888 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .22 | 00 | 2015-04-30 | 2015-05-04 | 2015-05-06 | 2015-04-29 | 0 | 2015-04-29 | ? | 0 | 0004990916 | 20150429.ifs | 2015-04-29 | 2015-04-30 | |||||||
| 1823970 | 1823970 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .18 | 00 | 2015-03-31 | 2015-04-02 | 2015-04-07 | 2015-03-30 | 0 | 2015-03-30 | ? | 0 | 0004975986 | 20150330.ifs | 2015-03-30 | 2015-03-31 | |||||||
| 1796242 | 1796242 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .16 | 00 | 2015-02-27 | 2015-03-03 | 2015-03-05 | 2015-02-26 | 0 | 2015-02-26 | ? | 0 | 0004958582 | 20150226.ifs | 2015-02-26 | 2015-02-27 | |||||||
| 1776965 | 1776965 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .17 | 00 | 2015-01-30 | 2015-02-03 | 2015-02-05 | 2015-01-29 | 0 | 2015-01-29 | ? | 0 | 0004945671 | 20150129.ifs | 2015-01-29 | 2015-01-30 | |||||||
| 1743466 | 1743466 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | 1.7 | 00 | 2014-12-29 | 2014-12-31 | 2015-01-05 | 2014-12-26 | 0 | 2014-12-26 | ? | 0 | 0004922298 | 20141226.ifs | 2014-12-26 | 2014-12-27 | |||||||
| 1688748 | 1688748 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | 1.12 | 00 | 2014-11-28 | 2014-12-02 | 2014-12-04 | 2014-11-26 | 0 | 2014-11-26 | ? | 0 | 0004877022 | 20141126.ifs | 2014-11-26 | 2014-11-27 | |||||||
| 1666782 | 1666782 | CORPACTION | ADD | 72201R775 | 04 | # | 2014-10-31 | 72201R775 | 04 | ? | 20141031.ifs | 2014-10-31 | 2014-11-01 | ||||||||||||||||
| 1666783 | 1666783 | CORPACTIONAUX | ADD | 72201R775 | 04 | 2014-10-31 | BOND | PIMCO ETF TR | PIMCO ETF TRUST | BOND | PIMCO ETF TR | TOTAL RETURN AC | 2014-10-31 | ? | 20141031.ifs | 2014-10-31 | 2014-11-01 | ||||||||||||
| 1666784 | 1666784 | EQUITY | CHANGE | 72201R775 | TOTAL RETURN EXCHG-TRADED FD | 0 | A | 2012-03-01 | ? | 0 | no | no | no | 2012-03-01 | 2012-03-05 | ? | 20141031.ifs | 2014-10-31 | 2014-11-01 | ||||||||||
| 1666785 | 1666784 | EQUITY | CHANGE | 72201R775 | TOTAL RETURN ACTIVE ETF | 0 | A | 2012-03-01 | ? | 0 | no | no | no | 2012-03-01 | 2014-10-31 | ? | 20141031.ifs | 2014-10-31 | 2014-11-01 | ||||||||||
| 1665938 | 1665938 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .4 | 00 | 2014-10-31 | 2014-11-04 | 2014-11-06 | 2014-10-30 | 0 | 2014-10-30 | ? | 0 | 0004863787 | 20141030.ifs | 2014-10-30 | 2014-10-31 | |||||||
| 1641079 | 1641079 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .275 | 00 | 2014-09-30 | 2014-10-02 | 2014-10-06 | 2014-09-29 | 0 | 2014-09-29 | ? | 0 | 0004849585 | 20140929.ifs | 2014-09-29 | 2014-09-30 | |||||||
| 1615028 | 1615028 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .3 | 00 | 2014-08-29 | 2014-09-03 | 2014-09-05 | 2014-08-28 | 0 | 2014-08-28 | ? | 0 | 0004833136 | 20140828.ifs | 2014-08-28 | 2014-08-29 | |||||||
| 1589583 | 1589583 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .28 | 00 | 2014-07-31 | 2014-08-04 | 2014-08-06 | 2014-07-30 | 0 | 2014-07-30 | ? | 0 | 0004819084 | 20140730.ifs | 2014-07-30 | 2014-07-31 | |||||||
| 1566065 | 1566065 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .05 | 00 | 2014-06-30 | 2014-07-02 | 2014-07-07 | 2014-06-27 | 0 | 2014-06-30 | ? | 0 | 0004804271 | 20140630.ifs | 2014-06-30 | 2014-07-01 | |||||||
| 1532500 | 1532500 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .05 | 00 | 2014-05-30 | 2014-06-03 | 2014-06-05 | 2014-05-29 | 0 | 2014-05-29 | ? | 0 | 0004786296 | 20140529.ifs | 2014-05-29 | 2014-05-30 | |||||||
| 1504035 | 1504035 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .05 | 00 | 2014-04-30 | 2014-05-02 | 2014-05-06 | 2014-04-29 | 0 | 2014-04-29 | ? | 0 | 0004772505 | 20140429.ifs | 2014-04-29 | 2014-04-30 | |||||||
| 1479226 | 1479226 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .05 | 00 | 2014-03-31 | 2014-04-02 | 2014-04-04 | 2014-03-28 | 0 | 2014-03-28 | ? | 0 | 0004757770 | 20140328.ifs | 2014-03-28 | 2014-03-29 | |||||||
| 1450992 | 1450992 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .05 | 00 | 2014-02-28 | 2014-03-04 | 2014-03-06 | 2014-02-27 | 0 | 2014-02-27 | ? | 0 | 0004740564 | 20140227.ifs | 2014-02-27 | 2014-02-28 | |||||||
| 1430330 | 1430330 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .1 | 00 | 2014-01-31 | 2014-02-04 | 2014-02-06 | 2014-01-30 | 0 | 2014-01-30 | ? | 0 | 0004727502 | 20140130.ifs | 2014-01-30 | 2014-01-31 | |||||||
| 1396290 | 1396290 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .14 | 00 | 2013-12-27 | 2013-12-31 | 2014-01-03 | 2013-12-26 | 0 | 2013-12-26 | ? | 0 | 0004705317 | 20131226.ifs | 2013-12-26 | 2013-12-27 | |||||||
| 1361927 | 1361927 | DIVIDEND | ADD | 72201R775 | 8 | 0 | 1 | 9 | .436846 | 95 | 2013-12-11 | 2013-12-13 | 2013-12-17 | 2013-12-10 | 0 | 2013-12-10 | ? | 0 | 0004675299 | 20131210.ifs | 2013-12-10 | 2013-12-11 | |||||||
| 1347174 | 1347174 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .19 | 00 | 2013-11-29 | 2013-12-03 | 2013-12-05 | 2013-11-27 | 0 | 2013-11-27 | ? | 0 | 0004662574 | 20131127.ifs | 2013-11-27 | 2013-11-28 | |||||||
| 1325639 | 1325639 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .2 | 00 | 2013-10-31 | 2013-11-04 | 2013-11-06 | 2013-10-30 | 0 | 2013-10-30 | ? | 0 | 0004649080 | 20131030.ifs | 2013-10-30 | 2013-10-31 | |||||||
| 1299150 | 1299150 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .25 | 00 | 2013-09-30 | 2013-10-02 | 2013-10-04 | 2013-09-27 | 0 | 2013-09-27 | ? | 0 | 0004635429 | 20130927.ifs | 2013-09-27 | 2013-09-28 | |||||||
| 1272706 | 1272706 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .3 | 00 | 2013-08-30 | 2013-09-04 | 2013-09-06 | 2013-08-29 | 0 | 2013-08-29 | ? | 0 | 0004619329 | 20130829.ifs | 2013-08-29 | 2013-08-30 | |||||||
| 1249411 | 1249411 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .255 | 00 | 2013-07-31 | 2013-08-02 | 2013-08-06 | 2013-07-30 | 0 | 2013-07-30 | ? | 0 | 0004605817 | 20130730.ifs | 2013-07-30 | 2013-07-31 | |||||||
| 1220253 | 1220253 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .22 | 00 | 2013-06-28 | 2013-07-02 | 2013-07-05 | 2013-06-27 | 0 | 2013-06-27 | ? | 0 | 0004590880 | 20130627.ifs | 2013-06-27 | 2013-06-28 | |||||||
| 1195285 | 1195285 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .225 | 00 | 2013-05-31 | 2013-06-04 | 2013-06-06 | 2013-05-30 | 0 | 2013-05-30 | ? | 0 | 0004574698 | 20130530.ifs | 2013-05-30 | 2013-05-31 | |||||||
| 1169344 | 1169344 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .21 | 00 | 2013-04-30 | 2013-05-02 | 2013-05-06 | 2013-04-29 | 0 | 2013-04-29 | ? | 0 | 0004561790 | 20130429.ifs | 2013-04-29 | 2013-04-30 | |||||||
| 1142434 | 1142434 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .18 | 00 | 2013-03-28 | 2013-04-02 | 2013-04-04 | 2013-03-27 | 0 | 2013-03-27 | ? | 0 | 0004547508 | 20130327.ifs | 2013-03-27 | 2013-03-28 | |||||||
| 1118810 | 1118810 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .174 | 00 | 2013-02-28 | 2013-03-04 | 2013-03-06 | 2013-02-27 | 0 | 2013-02-27 | ? | 0 | 0004531557 | 20130227.ifs | 2013-02-27 | 2013-02-28 | |||||||
| 1098835 | 1098835 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .174 | 00 | 2013-01-31 | 2013-02-04 | 2013-02-06 | 2013-01-30 | 0 | 2013-01-30 | ? | 0 | 0004519050 | 20130130.ifs | 2013-01-30 | 2013-01-31 | |||||||
| 1060639 | 1060639 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .18 | 00 | 2012-12-27 | 2012-12-31 | 2013-01-03 | 2012-12-26 | 0 | 2012-12-26 | ? | 0 | 0004496107 | 20121226.ifs | 2012-12-26 | 2012-12-27 | |||||||
| 1035404 | 1035404 | DIVIDEND | ADD | 72201R775 | 8 | 0 | 1 | 9 | .882644 | 95 | 2012-12-12 | 2012-12-14 | 2012-12-18 | 2012-12-11 | 0 | 2012-12-11 | ? | 0 | 0004475242 | 20121211.ifs | 2012-12-11 | 2012-12-12 | |||||||
| 1018165 | 1018165 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .2 | 00 | 2012-11-30 | 2012-12-04 | 2012-12-06 | 2012-11-29 | 0 | 2012-11-29 | ? | 0 | 0004462379 | 20121129.ifs | 2012-11-29 | 2012-11-30 | |||||||
| 994671 | 994671 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .2 | 00 | 2012-10-31 | 2012-11-02 | 2012-11-06 | 2012-10-30 | 0 | 2012-10-30 | ? | 0 | 0004448730 | 20121030.ifs | 2012-10-30 | 2012-10-31 | |||||||
| 966573 | 966573 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .195 | 00 | 2012-09-28 | 2012-10-02 | 2012-10-04 | 2012-09-27 | 0 | 2012-09-27 | ? | 0 | 0004435247 | 20120927.ifs | 2012-09-27 | 2012-09-28 | |||||||
| 922731 | 922731 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .18 | 00 | 2012-07-31 | 2012-08-02 | 2012-08-06 | 2012-07-30 | 0 | 2012-07-30 | ? | 0 | 0004406474 | 20120730.ifs | 2012-07-30 | 2012-07-31 | |||||||
| 896715 | 896715 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .21 | 00 | 2012-06-29 | 2012-07-03 | 2012-07-06 | 2012-06-28 | 0 | 2012-06-28 | ? | 0 | 0004393024 | 20120628.ifs | 2012-06-28 | 2012-06-29 | |||||||
| 869649 | 869649 | DIVIDEND | CHANGE | 72201R775 | 0 | 0 | 1 | 0 | .2 | 00 | 2012-05-31 | 2012-06-04 | 2012-06-06 | 2012-05-30 | 0 | 2012-05-30 | ? | 0 | 0004377682 | 20120531.ifs | 2012-05-31 | 2012-06-01 | |||||||
| 869650 | 869649 | DIVIDEND | CHANGE | 72201R775 | 0 | 0 | 1 | 0 | .2 | 00 | 2012-05-31 | 2012-06-04 | 2012-06-06 | 2012-05-30 | 0 | 2012-05-30 | ? | 0 | 0004377682 | 20120531.ifs | 2012-05-31 | 2012-06-01 | |||||||
| 867419 | 867419 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .2 | 00 | 2012-05-31 | 2012-06-04 | 2012-06-06 | 2012-05-30 | 0 | 2012-05-30 | ? | 0 | 0004377682 | 20120530.ifs | 2012-05-30 | 2012-05-31 | |||||||
| 844682 | 844682 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 0 | .18 | 00 | 2012-04-30 | 2012-05-02 | 2012-05-04 | 2012-04-27 | 0 | 2012-04-27 | ? | 0 | 0004365197 | 20120427.ifs | 2012-04-27 | 2012-04-28 | |||||||
| 829676 | 829676 | CORPACTION | ADD | 72201R775 | 04 | # | 2012-04-04 | 72201R775 | 04 | ? | 20120404.ifs | 2012-04-04 | 2012-04-05 | ||||||||||||||||
| 829677 | 829677 | CORPACTIONAUX | ADD | 72201R775 | 04 | 2012-04-04 | TRXT | PIMCO ETF TR | TOTAL RETURN EX | BOND | PIMCO ETF TR | TOTAL RETURN EX | 2012-04-04 | ? | 20120404.ifs | 2012-04-04 | 2012-04-05 | ||||||||||||
| 829678 | 829678 | EXCHANGE | CHANGE | 72201R775 | 04 | 2012-03-01 | 2012-04-03 | TRXT | 0 | A | 2012-03-01 | ? | 20120404.ifs | 2012-04-04 | 2012-04-05 | ||||||||||||||
| 829679 | 829678 | EXCHANGE | CHANGE | 72201R775 | 04 | 2012-03-01 | 2012-04-03 | BOND | 0 | A | 2012-03-01 | 2012-04-04 | 20120404.ifs | 2012-04-04 | 2012-04-05 | ||||||||||||||
| 817828 | 817828 | DIVIDEND | CHANGE | 72201R775 | 0 | 0 | 1 | 4 | .12 | 00 | 2012-03-30 | 2012-04-03 | 2012-04-05 | 2012-03-29 | 0 | 2012-03-29 | ? | 0 | 0004351815 | 20120330.ifs | 2012-03-30 | 2012-03-31 | |||||||
| 817829 | 817828 | DIVIDEND | CHANGE | 72201R775 | 0 | 0 | 1 | 4 | .12 | 00 | 2012-03-30 | 2012-04-03 | 2012-04-05 | 2012-03-29 | 1 | 2012-03-29 | 2012-03-30 | 0 | 0004351815 | 20120330.ifs | 2012-03-30 | 2012-03-31 | |||||||
| 814029 | 814029 | DIVIDEND | ADD | 72201R775 | 0 | 0 | 1 | 4 | .12 | 00 | 2012-03-30 | 2012-04-03 | 2012-04-05 | 2012-03-29 | 0 | 2012-03-29 | ? | 0 | 0004351815 | 20120329.ifs | 2012-03-29 | 2012-03-30 | |||||||
| 796641 | 796641 | EQUITY | CHANGE | 72201R775 | TOTAL RETURN EXCHG-TRADED FD | N | A | 2012-03-01 | ? | 0 | no | no | no | 2012-03-01 | 2012-03-01 | ? | 20120305.ifs | 2012-03-05 | 2012-03-06 | ||||||||||
| 796642 | 796641 | EQUITY | CHANGE | 72201R775 | TOTAL RETURN EXCHG-TRADED FD | 0 | A | 2012-03-01 | ? | 0 | no | no | no | 2012-03-01 | 2012-03-05 | ? | 20120305.ifs | 2012-03-05 | 2012-03-06 | ||||||||||
| 791802 | 791802 | EQUITY | ADD | 72201R775 | TOTAL RETURN EXCHG-TRADED FD | N | 7 | 2012-03-01 | ? | 0 | no | no | no | 2012-03-01 | ? | ? | 20120301.ifs | 2012-03-01 | 2012-03-02 | ||||||||||
| 791803 | 791803 | EXCHANGE | ADD | 72201R775 | 04 | 2012-03-01 | ? | TRXT | 0 | A | 2012-03-01 | ? | 20120301.ifs | 2012-03-01 | 2012-03-02 | ||||||||||||||
| 791918 | 791918 | EQUITY | CHANGE | 72201R775 | TOTAL RETURN EXCHG-TRADED FD | N | 7 | 2012-03-01 | ? | 0 | no | no | no | 2012-03-01 | ? | ? | 20120301.ifs | 2012-03-01 | 2012-03-02 | ||||||||||
| 791919 | 791918 | EQUITY | CHANGE | 72201R775 | TOTAL RETURN EXCHG-TRADED FD | N | A | 2012-03-01 | ? | 0 | no | no | no | 2012-03-01 | 2012-03-01 | ? | 20120301.ifs | 2012-03-01 | 2012-03-02 |
| 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 = 160355
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