INSITITUIONS | Dynamic | newInstitTable | Changed the Cusip/Sector/Shs Out? |
|
|||||||
Total Insititutions : | 157 | 142 | Update Insititution By Cusips | ||||||||
% Owned by Insititutions: | 75.30 % | 68.86 % | |||||||||
pricingQuarterAdminPageOn:
|
2024-03-31 | New % | |||||||||
|
|||||||||||
the compid is:160358 |
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 | ||
5573973 | 5573973 | DIVIDEND | ADD | 464286319 | 0 | 0 | 1 | 0 | .710634 | 00 | 2024-06-11 | 2024-06-11 | 2024-06-17 | 2024-06-10 | 0 | 2024-06-10 | ? | 0 | 0006931103 | 20240610.ifs | 2024-06-10 | 2024-06-11 | |||||||
5519619 | 5519619 | DIVIDEND | ADD | 464286319 | 0 | 0 | 1 | 0 | .106287 | 00 | 2024-03-21 | 2024-03-22 | 2024-03-27 | 2024-03-20 | 0 | 2024-03-20 | ? | 0 | 0006892695 | 20240320.ifs | 2024-03-20 | 2024-03-21 | |||||||
5450484 | 5450484 | DIVIDEND | ADD | 464286319 | 0 | 0 | 1 | 0 | .748129 | 00 | 2023-12-20 | 2023-12-21 | 2023-12-27 | 2023-12-19 | 0 | 2023-12-19 | ? | 0 | 0006840671 | 20231219.ifs | 2023-12-19 | 2023-12-20 | |||||||
5380147 | 5380147 | DIVIDEND | ADD | 464286319 | 0 | 0 | 1 | 0 | .692751 | 00 | 2023-09-26 | 2023-09-27 | 2023-10-02 | 2023-09-25 | 0 | 2023-09-25 | ? | 0 | 0006787350 | 20230925.ifs | 2023-09-25 | 2023-09-26 | |||||||
5307720 | 5307720 | DIVIDEND | ADD | 464286319 | 0 | 0 | 1 | 0 | .866411 | 00 | 2023-06-07 | 2023-06-08 | 2023-06-13 | 2023-06-06 | 0 | 2023-06-06 | ? | 0 | 0006737070 | 20230606.ifs | 2023-06-06 | 2023-06-07 | |||||||
5252955 | 5252955 | DIVIDEND | ADD | 464286319 | 0 | 0 | 1 | 0 | .090162 | 00 | 2023-03-23 | 2023-03-24 | 2023-03-29 | 2023-03-22 | 0 | 2023-03-22 | ? | 0 | 0006698772 | 20230322.ifs | 2023-03-22 | 2023-03-23 | |||||||
5162550 | 5162550 | DIVIDEND | ADD | 464286319 | 0 | 0 | 1 | 0 | .734031 | 00 | 2022-12-13 | 2022-12-14 | 2022-12-19 | 2022-12-12 | 0 | 2022-12-12 | ? | 0 | 0006629561 | 20221212.ifs | 2022-12-12 | 2022-12-13 | |||||||
5103633 | 5103633 | DIVIDEND | ADD | 464286319 | 0 | 0 | 1 | 0 | .772759 | 00 | 2022-09-26 | 2022-09-27 | 2022-09-30 | 2022-09-23 | 0 | 2022-09-23 | ? | 0 | 0006587892 | 20220923.ifs | 2022-09-23 | 2022-09-24 | |||||||
5030270 | 5030270 | DIVIDEND | ADD | 464286319 | 0 | 0 | 1 | 0 | .632535 | 00 | 2022-06-09 | 2022-06-10 | 2022-06-15 | 2022-06-08 | 0 | 2022-06-08 | ? | 0 | 0006536823 | 20220608.ifs | 2022-06-08 | 2022-06-09 | |||||||
4976197 | 4976197 | DIVIDEND | ADD | 464286319 | 0 | 0 | 1 | 0 | .24733 | 00 | 2022-03-24 | 2022-03-25 | 2022-03-30 | 2022-03-23 | 0 | 2022-03-23 | ? | 0 | 0006498183 | 20220323.ifs | 2022-03-23 | 2022-03-24 | |||||||
4919531 | 4919531 | DIVIDEND | ADD | 464286319 | 0 | 0 | 1 | 0 | .090593 | 00 | 2021-12-30 | 2021-12-31 | 2022-01-05 | 2021-12-29 | 0 | 2021-12-29 | ? | 0 | 0006454883 | 20211229.ifs | 2021-12-29 | 2021-12-30 | |||||||
4877217 | 4877217 | DIVIDEND | ADD | 464286319 | 0 | 0 | 1 | 0 | .44365 | 00 | 2021-12-13 | 2021-12-14 | 2021-12-17 | 2021-12-10 | 0 | 2021-12-10 | ? | 0 | 0006417624 | 20211210.ifs | 2021-12-10 | 2021-12-11 | |||||||
4808714 | 4808714 | DIVIDEND | ADD | 464286319 | 0 | 0 | 1 | 0 | .67595 | 00 | 2021-09-24 | 2021-09-27 | 2021-09-30 | 2021-09-23 | 0 | 2021-09-23 | ? | 0 | 0006371669 | 20210923.ifs | 2021-09-23 | 2021-09-24 | |||||||
4726043 | 4726043 | DIVIDEND | ADD | 464286319 | 0 | 0 | 1 | 0 | 1.302096 | 00 | 2021-06-10 | 2021-06-11 | 2021-06-16 | 2021-06-09 | 0 | 2021-06-09 | ? | 0 | 0006320352 | 20210609.ifs | 2021-06-09 | 2021-06-10 | |||||||
4661065 | 4661065 | DIVIDEND | ADD | 464286319 | 0 | 0 | 1 | 0 | .300263 | 00 | 2021-03-25 | 2021-03-26 | 2021-03-31 | 2021-03-24 | 0 | 2021-03-24 | ? | 0 | 0006281379 | 20210324.ifs | 2021-03-24 | 2021-03-25 | |||||||
4580145 | 4580145 | DIVIDEND | ADD | 464286319 | 0 | 0 | 1 | 0 | .075955 | 00 | 2020-12-30 | 2020-12-31 | 2021-01-06 | 2020-12-29 | 0 | 2020-12-29 | ? | 0 | 0006237387 | 20201229.ifs | 2020-12-29 | 2020-12-30 | |||||||
4539267 | 4539267 | DIVIDEND | ADD | 464286319 | 0 | 0 | 1 | 0 | .320027 | 00 | 2020-12-14 | 2020-12-15 | 2020-12-18 | 2020-12-11 | 0 | 2020-12-11 | ? | 0 | 0006209184 | 20201211.ifs | 2020-12-11 | 2020-12-12 | |||||||
4467431 | 4467431 | DIVIDEND | ADD | 464286319 | 0 | 0 | 1 | 0 | .492601 | 00 | 2020-09-23 | 2020-09-24 | 2020-09-29 | 2020-09-22 | 0 | 2020-09-22 | ? | 0 | 0006161968 | 20200922.ifs | 2020-09-22 | 2020-09-23 | |||||||
4391145 | 4391145 | DIVIDEND | ADD | 464286319 | 0 | 0 | 1 | 0 | .720394 | 00 | 2020-06-15 | 2020-06-16 | 2020-06-19 | 2020-06-12 | 0 | 2020-06-12 | ? | 0 | 0006112156 | 20200612.ifs | 2020-06-12 | 2020-06-13 | |||||||
4252532 | 4252532 | DIVIDEND | ADD | 464286319 | 0 | 0 | 1 | 0 | .353534 | 00 | 2020-03-25 | 2020-03-26 | 2020-03-31 | 2020-03-24 | 0 | 2020-03-24 | ? | 0 | 0006072832 | 20200324.ifs | 2020-03-24 | 2020-03-25 | |||||||
4252783 | 4252783 | DIVIDEND | ADD | 464286319 | 0 | 0 | 1 | 0 | .353534 | 00 | 2020-03-25 | 2020-03-26 | 2020-03-31 | 2020-03-24 | 0 | 2020-03-24 | ? | 0 | 0006072832 | 20200324.ifs | 2020-03-24 | 2020-03-25 | |||||||
4068231 | 4068231 | DIVIDEND | ADD | 464286319 | 0 | 0 | 1 | 0 | .457706 | 00 | 2019-12-16 | 2019-12-17 | 2019-12-20 | 2019-12-13 | 0 | 2019-12-13 | ? | 0 | 0005999978 | 20191213.ifs | 2019-12-13 | 2019-12-14 | |||||||
4068307 | 4068307 | DIVIDEND | ADD | 464286319 | 0 | 0 | 1 | 0 | .457706 | 00 | 2019-12-16 | 2019-12-17 | 2019-12-20 | 2019-12-13 | 0 | 2019-12-13 | ? | 0 | 0005999978 | 20191213.ifs | 2019-12-13 | 2019-12-14 | |||||||
3934102 | 3934102 | DIVIDEND | ADD | 464286319 | 0 | 0 | 1 | 0 | .782125 | 00 | 2019-09-24 | 2019-09-25 | 2019-09-30 | 2019-09-23 | 0 | 2019-09-23 | ? | 0 | 0005949077 | 20190923.ifs | 2019-09-23 | 2019-09-24 | |||||||
3934103 | 3934103 | DIVIDEND | ADD | 464286319 | 0 | 0 | 1 | 0 | .782125 | 00 | 2019-09-24 | 2019-09-25 | 2019-09-30 | 2019-09-23 | 0 | 2019-09-23 | ? | 0 | 0005949077 | 20190923.ifs | 2019-09-23 | 2019-09-24 | |||||||
3781221 | 3781221 | DIVIDEND | ADD | 464286319 | 0 | 0 | 1 | 0 | .938427 | 00 | 2019-06-17 | 2019-06-18 | 2019-06-21 | 2019-06-14 | 0 | 2019-06-14 | ? | 0 | 0005898664 | 20190614.ifs | 2019-06-14 | 2019-06-15 | |||||||
3781243 | 3781243 | DIVIDEND | ADD | 464286319 | 0 | 0 | 1 | 0 | .938427 | 00 | 2019-06-17 | 2019-06-18 | 2019-06-21 | 2019-06-14 | 0 | 2019-06-14 | ? | 0 | 0005898664 | 20190614.ifs | 2019-06-14 | 2019-06-15 | |||||||
3638203 | 3638203 | DIVIDEND | ADD | 464286319 | 0 | 0 | 1 | 0 | .24482 | 00 | 2019-03-20 | 2019-03-21 | 2019-03-26 | 2019-03-19 | 0 | 2019-03-19 | ? | 0 | 0005854904 | 20190319.ifs | 2019-03-19 | 2019-03-20 | |||||||
3638206 | 3638206 | DIVIDEND | ADD | 464286319 | 0 | 0 | 1 | 0 | .24482 | 00 | 2019-03-20 | 2019-03-21 | 2019-03-26 | 2019-03-19 | 0 | 2019-03-19 | ? | 0 | 0005854904 | 20190319.ifs | 2019-03-19 | 2019-03-20 | |||||||
3452540 | 3452540 | DIVIDEND | ADD | 464286319 | 0 | 0 | 1 | 0 | .411912 | 00 | 2018-12-18 | 2018-12-19 | 2018-12-24 | 2018-12-17 | 0 | 2018-12-17 | ? | 0 | 0005785584 | 20181217.ifs | 2018-12-17 | 2018-12-18 | |||||||
3452702 | 3452702 | DIVIDEND | ADD | 464286319 | 0 | 0 | 1 | 0 | .411912 | 00 | 2018-12-18 | 2018-12-19 | 2018-12-24 | 2018-12-17 | 0 | 2018-12-17 | ? | 0 | 0005785584 | 20181217.ifs | 2018-12-17 | 2018-12-18 | |||||||
3299269 | 3299269 | DIVIDEND | ADD | 464286319 | 0 | 0 | 1 | 0 | 1.05099 | 00 | 2018-09-26 | 2018-09-27 | 2018-10-02 | 2018-09-25 | 0 | 2018-09-25 | ? | 0 | 0005728813 | 20180925.ifs | 2018-09-25 | 2018-09-26 | |||||||
3299376 | 3299376 | DIVIDEND | ADD | 464286319 | 0 | 0 | 1 | 0 | 1.05099 | 00 | 2018-09-26 | 2018-09-27 | 2018-10-02 | 2018-09-25 | 0 | 2018-09-25 | ? | 0 | 0005728813 | 20180925.ifs | 2018-09-25 | 2018-09-26 | |||||||
3144186 | 3144186 | DIVIDEND | ADD | 464286319 | 0 | 0 | 1 | 0 | .51105 | 00 | 2018-06-19 | 2018-06-20 | 2018-06-25 | 2018-06-18 | 0 | 2018-06-18 | ? | 0 | 0005676440 | 20180618.ifs | 2018-06-18 | 2018-06-19 | |||||||
3144187 | 3144187 | DIVIDEND | ADD | 464286319 | 0 | 0 | 1 | 0 | .51105 | 00 | 2018-06-19 | 2018-06-20 | 2018-06-25 | 2018-06-18 | 0 | 2018-06-18 | ? | 0 | 0005676440 | 20180618.ifs | 2018-06-18 | 2018-06-19 | |||||||
3000923 | 3000923 | DIVIDEND | ADD | 464286319 | 0 | 0 | 1 | 0 | .157371 | 00 | 2018-03-22 | 2018-03-23 | 2018-03-28 | 2018-03-21 | 0 | 2018-03-21 | ? | 0 | 0005632698 | 20180321.ifs | 2018-03-21 | 2018-03-22 | |||||||
3000944 | 3000944 | DIVIDEND | ADD | 464286319 | 0 | 0 | 1 | 0 | .157371 | 00 | 2018-03-22 | 2018-03-23 | 2018-03-28 | 2018-03-21 | 0 | 2018-03-21 | ? | 0 | 0005632698 | 20180321.ifs | 2018-03-21 | 2018-03-22 | |||||||
2852176 | 2852176 | DIVIDEND | ADD | 464286319 | 0 | 0 | 1 | 0 | .457394 | 00 | 2017-12-21 | 2017-12-22 | 2017-12-28 | 2017-12-20 | 0 | 2017-12-20 | ? | 0 | 0005571800 | 20171220.ifs | 2017-12-20 | 2017-12-21 | |||||||
2856003 | 2856003 | DIVIDEND | ADD | 464286319 | 0 | 0 | 1 | 0 | .457394 | 00 | 2017-12-21 | 2017-12-22 | 2017-12-28 | 2017-12-20 | 0 | 2017-12-20 | ? | 0 | 0005571800 | 20171220.ifs | 2017-12-20 | 2017-12-21 | |||||||
2686875 | 2686875 | DIVIDEND | ADD | 464286319 | 0 | 0 | 1 | 0 | .902287 | 00 | 2017-09-26 | 2017-09-27 | 2017-09-29 | 2017-09-25 | 0 | 2017-09-25 | ? | 0 | 0005501957 | 20170925.ifs | 2017-09-25 | 2017-09-26 | |||||||
2686920 | 2686920 | DIVIDEND | ADD | 464286319 | 0 | 0 | 1 | 0 | .902287 | 00 | 2017-09-26 | 2017-09-27 | 2017-09-29 | 2017-09-25 | 0 | 2017-09-25 | ? | 0 | 0005501957 | 20170925.ifs | 2017-09-25 | 2017-09-26 | |||||||
2595117 | 2595117 | DIVIDEND | ADD | 464286319 | 0 | 0 | 1 | 0 | .530871 | 00 | 2017-06-20 | 2017-06-22 | 2017-06-26 | 2017-06-19 | 0 | 2017-06-19 | ? | 0 | 0005451172 | 20170619.ifs | 2017-06-19 | 2017-06-20 | |||||||
2518919 | 2518919 | DIVIDEND | ADD | 464286319 | 0 | 0 | 1 | 0 | .12149 | 00 | 2017-03-24 | 2017-03-28 | 2017-03-30 | 2017-03-23 | 0 | 2017-03-23 | ? | 0 | 0005406907 | 20170323.ifs | 2017-03-23 | 2017-03-24 | |||||||
2439820 | 2439820 | EQUITY | CHANGE | 464286319 | EMERGING MARKETS DIVID ETF | 0 | A | 2012-02-24 | ? | 0 | no | no | no | 2012-02-24 | 2013-07-01 | ? | 20170123.ifs | 2017-01-23 | 2017-01-24 | ||||||||||
2439821 | 2439820 | EQUITY | CHANGE | 464286319 | EMERGING MARKETS DIVID ETF | 0 | A | 2012-02-24 | ? | 4 | no | no | no | 2012-02-24 | 2013-07-01 | ? | 20170123.ifs | 2017-01-23 | 2017-01-24 | ||||||||||
2398570 | 2398570 | DIVIDEND | ADD | 464286319 | 0 | 0 | 1 | 0 | .031081 | 00 | 2016-12-28 | 2016-12-30 | 2017-01-04 | 2016-12-27 | 0 | 2016-12-27 | ? | 0 | 0005355836 | 20161227.ifs | 2016-12-27 | 2016-12-28 | |||||||
2391719 | 2391719 | DIVIDEND | ADD | 464286319 | 0 | 0 | 1 | 0 | .081776 | 00 | 2016-12-22 | 2016-12-27 | 2016-12-29 | 2016-12-21 | 0 | 2016-12-21 | ? | 0 | 0005349809 | 20161221.ifs | 2016-12-21 | 2016-12-22 | |||||||
2301242 | 2301242 | DIVIDEND | ADD | 464286319 | 0 | 0 | 1 | 0 | .674297 | 00 | 2016-09-26 | 2016-09-28 | 2016-09-30 | 2016-09-23 | 0 | 2016-09-23 | ? | 0 | 0005285068 | 20160923.ifs | 2016-09-23 | 2016-09-24 | |||||||
2225372 | 2225372 | DIVIDEND | ADD | 464286319 | 0 | 0 | 1 | 0 | .683573 | 00 | 2016-06-21 | 2016-06-23 | 2016-06-27 | 2016-06-20 | 0 | 2016-06-20 | ? | 0 | 0005235498 | 20160620.ifs | 2016-06-20 | 2016-06-21 | |||||||
2140533 | 2140533 | DIVIDEND | ADD | 464286319 | 0 | 0 | 1 | 0 | .106315 | 00 | 2016-03-23 | 2016-03-28 | 2016-03-30 | 2016-03-22 | 0 | 2016-03-22 | ? | 0 | 0005190698 | 20160322.ifs | 2016-03-22 | 2016-03-23 | |||||||
2053036 | 2053036 | DIVIDEND | ADD | 464286319 | 0 | 0 | 1 | 0 | .177172 | 00 | 2015-12-21 | 2015-12-23 | 2015-12-28 | 2015-12-18 | 0 | 2015-12-18 | ? | 0 | 0005130210 | 20151218.ifs | 2015-12-18 | 2015-12-19 | |||||||
1972307 | 1972307 | DIVIDEND | ADD | 464286319 | 0 | 0 | 1 | 0 | .758 | 00 | 2015-09-25 | 2015-09-29 | 2015-10-01 | 2015-09-24 | 0 | 2015-09-24 | ? | 0 | 0005067287 | 20150924.ifs | 2015-09-24 | 2015-09-25 | |||||||
1893700 | 1893700 | DIVIDEND | ADD | 464286319 | 0 | 0 | 1 | 0 | .779496 | 00 | 2015-06-24 | 2015-06-26 | 2015-06-30 | 2015-06-23 | 0 | 2015-06-23 | ? | 0 | 0005018428 | 20150623.ifs | 2015-06-23 | 2015-06-24 | |||||||
1819345 | 1819345 | DIVIDEND | ADD | 464286319 | 0 | 0 | 1 | 0 | .250492 | 00 | 2015-03-25 | 2015-03-27 | 2015-03-31 | 2015-03-24 | 0 | 2015-03-24 | ? | 0 | 0004972924 | 20150324.ifs | 2015-03-24 | 2015-03-25 | |||||||
1727888 | 1727888 | DIVIDEND | ADD | 464286319 | 0 | 0 | 1 | 0 | .052545 | 00 | 2014-12-19 | 2014-12-23 | 2014-12-29 | 2014-12-18 | 0 | 2014-12-18 | ? | 0 | 0004908433 | 20141218.ifs | 2014-12-18 | 2014-12-19 | |||||||
1636589 | 1636589 | DIVIDEND | ADD | 464286319 | 0 | 0 | 1 | 0 | .761223 | 00 | 2014-09-24 | 2014-09-26 | 2014-10-01 | 2014-09-23 | 0 | 2014-09-23 | ? | 0 | 0004846710 | 20140923.ifs | 2014-09-23 | 2014-09-24 | |||||||
1557127 | 1557127 | DIVIDEND | ADD | 464286319 | 0 | 0 | 1 | 0 | .826054 | 00 | 2014-06-24 | 2014-06-26 | 2014-07-01 | 2014-06-23 | 0 | 2014-06-23 | ? | 0 | 0004800686 | 20140623.ifs | 2014-06-23 | 2014-06-24 | |||||||
1474627 | 1474627 | DIVIDEND | ADD | 464286319 | 0 | 0 | 1 | 0 | .245127 | 00 | 2014-03-25 | 2014-03-27 | 2014-04-01 | 2014-03-24 | 0 | 2014-03-24 | ? | 0 | 0004754619 | 20140324.ifs | 2014-03-24 | 2014-03-25 | |||||||
1374611 | 1374611 | DIVIDEND | ADD | 464286319 | 0 | 0 | 1 | 0 | .416305 | 00 | 2013-12-17 | 2013-12-19 | 2013-12-27 | 2013-12-16 | 0 | 2013-12-16 | ? | 0 | 0004685269 | 20131216.ifs | 2013-12-16 | 2013-12-17 | |||||||
1299569 | 1299569 | DIVIDEND | ADD | 464286319 | 0 | 0 | 1 | 0 | .75401 | 00 | 2013-09-30 | 2013-10-02 | 2013-10-04 | 2013-09-27 | 0 | 2013-09-27 | ? | 0 | 0004635349 | 20130927.ifs | 2013-09-27 | 2013-09-28 | |||||||
1226937 | 1226937 | CORPACTION | ADD | 464286319 | 04 | # | 2013-07-01 | 464286319 | 04 | ? | 20130701.ifs | 2013-07-01 | 2013-07-02 | ||||||||||||||||
1226938 | 1226938 | CORPACTIONAUX | ADD | 464286319 | 04 | 2013-07-01 | DVYE | ISHARES INC | ISHARES INC- EM | DVYE | ISHARES INC | EMERGING MARKET | 2013-07-01 | ? | 20130701.ifs | 2013-07-01 | 2013-07-02 | ||||||||||||
1226939 | 1226939 | EQUITY | CHANGE | 464286319 | EMERGING MARKETS DIVID INDEX FD | 0 | A | 2012-02-24 | ? | 0 | no | no | no | 2012-02-24 | 2012-02-24 | ? | 20130701.ifs | 2013-07-01 | 2013-07-02 | ||||||||||
1226940 | 1226939 | EQUITY | CHANGE | 464286319 | EMERGING MARKETS DIVID ETF | 0 | A | 2012-02-24 | ? | 0 | no | no | no | 2012-02-24 | 2013-07-01 | ? | 20130701.ifs | 2013-07-01 | 2013-07-02 | ||||||||||
1216250 | 1216250 | DIVIDEND | ADD | 464286319 | 0 | 0 | 1 | 0 | .830511 | 00 | 2013-06-25 | 2013-06-27 | 2013-07-02 | 2013-06-24 | 0 | 2013-06-24 | ? | 0 | 0004588155 | 20130624.ifs | 2013-06-24 | 2013-06-25 | |||||||
1138767 | 1138767 | DIVIDEND | ADD | 464286319 | 0 | 0 | 1 | 0 | .238444 | 00 | 2013-03-22 | 2013-03-26 | 2013-03-28 | 2013-03-21 | 0 | 2013-03-21 | ? | 0 | 0004544516 | 20130321.ifs | 2013-03-21 | 2013-03-22 | |||||||
1039335 | 1039335 | DIVIDEND | ADD | 464286319 | 0 | 0 | 1 | 0 | .132386 | 00 | 2012-12-14 | 2012-12-18 | 2012-12-24 | 2012-12-13 | 0 | 2012-12-13 | ? | 0 | 0004477733 | 20121213.ifs | 2012-12-13 | 2012-12-14 | |||||||
961932 | 961932 | DIVIDEND | ADD | 464286319 | 0 | 0 | 1 | 0 | .754202 | 00 | 2012-09-24 | 2012-09-26 | 2012-09-28 | 2012-09-21 | 0 | 2012-09-21 | ? | 0 | 0004432620 | 20120921.ifs | 2012-09-21 | 2012-09-22 | |||||||
888549 | 888549 | DIVIDEND | ADD | 464286319 | 0 | 0 | 1 | 0 | .885639 | 00 | 2012-06-20 | 2012-06-22 | 2012-06-27 | 2012-06-19 | 0 | 2012-06-19 | ? | 0 | 0004388206 | 20120619.ifs | 2012-06-19 | 2012-06-20 | |||||||
808524 | 808524 | DIVIDEND | ADD | 464286319 | 0 | 0 | 1 | 4 | .14248 | 00 | 2012-03-23 | 2012-03-27 | 2012-03-29 | 2012-03-22 | 0 | 2012-03-22 | ? | 0 | 0004348967 | 20120322.ifs | 2012-03-22 | 2012-03-23 | |||||||
784598 | 784598 | EQUITY | ADD | 464286319 | EMERGING MARKETS DIVID INDEX FD | N | 7 | 2012-02-24 | ? | 0 | no | no | no | 2012-02-24 | ? | ? | 20120224.ifs | 2012-02-24 | 2012-02-25 | ||||||||||
784599 | 784599 | EXCHANGE | ADD | 464286319 | 04 | 2012-02-24 | 2012-02-24 | DVYE | 0 | A | 2012-02-24 | ? | 20120224.ifs | 2012-02-24 | 2012-02-25 | ||||||||||||||
784680 | 784680 | EQUITY | CHANGE | 464286319 | EMERGING MARKETS DIVID INDEX FD | N | 7 | 2012-02-24 | ? | 0 | no | no | no | 2012-02-24 | ? | ? | 20120224.ifs | 2012-02-24 | 2012-02-25 | ||||||||||
784681 | 784680 | EQUITY | CHANGE | 464286319 | EMERGING MARKETS DIVID INDEX FD | N | A | 2012-02-24 | ? | 0 | no | no | no | 2012-02-24 | 2012-02-24 | ? | 20120224.ifs | 2012-02-24 | 2012-02-25 | ||||||||||
785150 | 785150 | EQUITY | CHANGE | 464286319 | EMERGING MARKETS DIVID INDEX FD | N | A | 2012-02-24 | ? | 0 | no | no | no | 2012-02-24 | 2012-02-24 | ? | 20120224.ifs | 2012-02-24 | 2012-02-25 | ||||||||||
785151 | 785150 | EQUITY | CHANGE | 464286319 | EMERGING MARKETS DIVID INDEX FD | 0 | A | 2012-02-24 | ? | 0 | no | no | no | 2012-02-24 | 2012-02-24 | ? | 20120224.ifs | 2012-02-24 | 2012-02-25 |
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 = 160358
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