INSITITUIONS | Dynamic | newInstitTable | Changed the Cusip/Sector/Shs Out? |
|
||||||||||
Total Insititutions : | 318 | 249 | Update Insititution By Cusips | |||||||||||
% Owned by Insititutions: | 71.81 % | 62.14 % | ||||||||||||
pricingQuarterAdminPageOn:
|
2024-03-31 | New % | ||||||||||||
|
||||||||||||||
the compid is:152084 |
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 | ||
5581461 | 5581461 | DIVIDEND | ADD | 97717W851 | 0 | 0 | 1 | 0 | .51814 | 00 | 2024-06-25 | 2024-06-25 | 2024-06-27 | 2024-06-24 | 0 | 2024-06-24 | ? | 0 | 0006936852 | 20240624.ifs | 2024-06-24 | 2024-06-25 | |||||||
5520585 | 5520585 | DIVIDEND | ADD | 97717W851 | 0 | 0 | 1 | 0 | .305 | 00 | 2024-03-22 | 2024-03-25 | 2024-03-27 | 2024-03-21 | 0 | 2024-03-21 | ? | 0 | 0006893655 | 20240321.ifs | 2024-03-21 | 2024-03-22 | |||||||
5455128 | 5455128 | DIVIDEND | ADD | 97717W851 | 0 | 0 | 1 | 0 | 1.61 | 00 | 2023-12-22 | 2023-12-26 | 2023-12-28 | 2023-12-21 | 0 | 2023-12-21 | ? | 0 | 0006846772 | 20231221.ifs | 2023-12-21 | 2023-12-22 | |||||||
5378909 | 5378909 | DIVIDEND | ADD | 97717W851 | 0 | 0 | 1 | 0 | .01155 | 00 | 2023-09-25 | 2023-09-26 | 2023-09-28 | 2023-09-22 | 0 | 2023-09-22 | ? | 0 | 0006786904 | 20230922.ifs | 2023-09-22 | 2023-09-23 | |||||||
5317467 | 5317467 | DIVIDEND | ADD | 97717W851 | 0 | 0 | 1 | 0 | .78207 | 00 | 2023-06-26 | 2023-06-27 | 2023-06-29 | 2023-06-23 | 0 | 2023-06-23 | ? | 0 | 0006743653 | 20230623.ifs | 2023-06-23 | 2023-06-24 | |||||||
5254638 | 5254638 | DIVIDEND | ADD | 97717W851 | 0 | 0 | 1 | 0 | .625 | 00 | 2023-03-27 | 2023-03-28 | 2023-03-30 | 2023-03-24 | 0 | 2023-03-24 | ? | 0 | 0006700140 | 20230324.ifs | 2023-03-24 | 2023-03-25 | |||||||
5185459 | 5185459 | DIVIDEND | ADD | 97717W851 | 0 | 0 | 1 | 0 | 1.0647 | 00 | 2022-12-23 | 2022-12-27 | 2022-12-29 | 2022-12-22 | 0 | 2022-12-22 | ? | 0 | 0006650909 | 20221222.ifs | 2022-12-22 | 2022-12-23 | |||||||
5103262 | 5103262 | DIVIDEND | ADD | 97717W851 | 0 | 0 | 1 | 0 | .13 | 00 | 2022-09-26 | 2022-09-27 | 2022-09-29 | 2022-09-23 | 0 | 2022-09-23 | ? | 0 | 0006587876 | 20220923.ifs | 2022-09-23 | 2022-09-24 | |||||||
5039527 | 5039527 | DIVIDEND | ADD | 97717W851 | 0 | 0 | 1 | 0 | .75 | 00 | 2022-06-24 | 2022-06-27 | 2022-06-29 | 2022-06-23 | 0 | 2022-06-23 | ? | 0 | 0006543283 | 20220623.ifs | 2022-06-23 | 2022-06-24 | |||||||
4976788 | 4976788 | DIVIDEND | ADD | 97717W851 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2022-03-30 | 2022-03-24 | 0 | 2022-03-24 | ? | 0 | 0006499045 | 20220324.ifs | 2022-03-24 | 2022-03-25 | |||||||
4910905 | 4910905 | DIVIDEND | ADD | 97717W851 | 0 | 0 | 1 | 0 | 1.10976 | 00 | 2021-12-27 | 2021-12-28 | 2021-12-30 | 2021-12-23 | 0 | 2021-12-23 | ? | 0 | 0006447638 | 20211223.ifs | 2021-12-23 | 2021-12-24 | |||||||
4808133 | 4808133 | DIVIDEND | ADD | 97717W851 | 0 | 0 | 1 | 0 | .065 | 00 | 2021-09-24 | 2021-09-27 | 2021-09-29 | 2021-09-23 | 0 | 2021-09-23 | ? | 0 | 0006371712 | 20210923.ifs | 2021-09-23 | 2021-09-24 | |||||||
4735986 | 4735986 | DIVIDEND | ADD | 97717W851 | 0 | 0 | 1 | 0 | .47345 | 00 | 2021-06-24 | 2021-06-25 | 2021-06-29 | 2021-06-23 | 0 | 2021-06-23 | ? | 0 | 0006326347 | 20210623.ifs | 2021-06-23 | 2021-06-24 | |||||||
4660621 | 4660621 | DIVIDEND | ADD | 97717W851 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2021-03-30 | 2021-03-24 | 0 | 2021-03-24 | ? | 0 | 0006281273 | 20210324.ifs | 2021-03-24 | 2021-03-25 | |||||||
4553766 | 4553766 | DIVIDEND | ADD | 97717W851 | 0 | 0 | 1 | 0 | .79231 | 00 | 2020-12-21 | 2020-12-22 | 2020-12-24 | 2020-12-18 | 0 | 2020-12-18 | ? | 0 | 0006223308 | 20201218.ifs | 2020-12-18 | 2020-12-19 | |||||||
4466331 | 4466331 | DIVIDEND | ADD | 97717W851 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2020-09-25 | 2020-09-21 | 0 | 2020-09-21 | ? | 0 | 0006161338 | 20200921.ifs | 2020-09-21 | 2020-09-22 | |||||||
4396970 | 4396970 | DIVIDEND | ADD | 97717W851 | 0 | 0 | 1 | 0 | .58606 | 00 | 2020-06-23 | 2020-06-24 | 2020-06-26 | 2020-06-22 | 0 | 2020-06-22 | ? | 0 | 0006116191 | 20200622.ifs | 2020-06-22 | 2020-06-23 | |||||||
4248287 | 4248287 | DIVIDEND | ADD | 97717W851 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2020-03-27 | 2020-03-23 | 0 | 2020-03-23 | ? | 0 | 0006072235 | 20200323.ifs | 2020-03-23 | 2020-03-24 | |||||||
4248356 | 4248356 | DIVIDEND | ADD | 97717W851 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2020-03-27 | 2020-03-23 | 0 | 2020-03-23 | ? | 0 | 0006072235 | 20200323.ifs | 2020-03-23 | 2020-03-24 | |||||||
4101708 | 4101708 | DIVIDEND | ADD | 97717W851 | 0 | 0 | 1 | 0 | .66427 | 00 | 2019-12-23 | 2019-12-24 | 2019-12-27 | 2019-12-20 | 0 | 2019-12-20 | ? | 0 | 0006018617 | 20191220.ifs | 2019-12-20 | 2019-12-21 | |||||||
4102625 | 4102625 | DIVIDEND | ADD | 97717W851 | 0 | 0 | 1 | 0 | .66427 | 00 | 2019-12-23 | 2019-12-24 | 2019-12-27 | 2019-12-20 | 0 | 2019-12-20 | ? | 0 | 0006018617 | 20191220.ifs | 2019-12-20 | 2019-12-21 | |||||||
3933354 | 3933354 | DIVIDEND | ADD | 97717W851 | 0 | 0 | 1 | 0 | .065 | 00 | 2019-09-24 | 2019-09-25 | 2019-09-27 | 2019-09-23 | 0 | 2019-09-23 | ? | 0 | 0005948994 | 20190923.ifs | 2019-09-23 | 2019-09-24 | |||||||
3933355 | 3933355 | DIVIDEND | ADD | 97717W851 | 0 | 0 | 1 | 0 | .065 | 00 | 2019-09-24 | 2019-09-25 | 2019-09-27 | 2019-09-23 | 0 | 2019-09-23 | ? | 0 | 0005948994 | 20190923.ifs | 2019-09-23 | 2019-09-24 | |||||||
3792184 | 3792184 | DIVIDEND | ADD | 97717W851 | 0 | 0 | 1 | 0 | .57766 | 00 | 2019-06-24 | 2019-06-25 | 2019-06-28 | 2019-06-21 | 0 | 2019-06-21 | ? | 0 | 0005902460 | 20190621.ifs | 2019-06-21 | 2019-06-22 | |||||||
3792185 | 3792185 | DIVIDEND | ADD | 97717W851 | 0 | 0 | 1 | 0 | .57766 | 00 | 2019-06-24 | 2019-06-25 | 2019-06-28 | 2019-06-21 | 0 | 2019-06-21 | ? | 0 | 0005902460 | 20190621.ifs | 2019-06-21 | 2019-06-22 | |||||||
3646088 | 3646088 | DIVIDEND | ADD | 97717W851 | 0 | 0 | 1 | 0 | .02 | 00 | 2019-03-26 | 2019-03-27 | 2019-03-29 | 2019-03-25 | 0 | 2019-03-25 | ? | 0 | 0005857603 | 20190325.ifs | 2019-03-25 | 2019-03-26 | |||||||
3646113 | 3646113 | DIVIDEND | ADD | 97717W851 | 0 | 0 | 1 | 0 | .02 | 00 | 2019-03-26 | 2019-03-27 | 2019-03-29 | 2019-03-25 | 0 | 2019-03-25 | ? | 0 | 0005857603 | 20190325.ifs | 2019-03-25 | 2019-03-26 | |||||||
3485453 | 3485453 | DIVIDEND | ADD | 97717W851 | 0 | 0 | 1 | 0 | .26199 | 00 | 2018-12-24 | 2018-12-26 | 2018-12-28 | 2018-12-21 | 0 | 2018-12-21 | ? | 0 | 0005802861 | 20181221.ifs | 2018-12-21 | 2018-12-22 | |||||||
3485454 | 3485454 | DIVIDEND | ADD | 97717W851 | 0 | 0 | 1 | 0 | .26199 | 00 | 2018-12-24 | 2018-12-26 | 2018-12-28 | 2018-12-21 | 0 | 2018-12-21 | ? | 0 | 0005802861 | 20181221.ifs | 2018-12-21 | 2018-12-22 | |||||||
3296338 | 3296338 | DIVIDEND | ADD | 97717W851 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2018-09-28 | 2018-09-24 | 0 | 2018-09-24 | ? | 0 | 0005727873 | 20180924.ifs | 2018-09-24 | 2018-09-25 | |||||||
3296343 | 3296343 | DIVIDEND | ADD | 97717W851 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2018-09-28 | 2018-09-24 | 0 | 2018-09-24 | ? | 0 | 0005727873 | 20180924.ifs | 2018-09-24 | 2018-09-25 | |||||||
3153542 | 3153542 | DIVIDEND | ADD | 97717W851 | 0 | 0 | 1 | 0 | 1.09212 | 00 | 2018-06-25 | 2018-06-26 | 2018-06-28 | 2018-06-22 | 0 | 2018-06-22 | ? | 0 | 0005679948 | 20180622.ifs | 2018-06-22 | 2018-06-23 | |||||||
3153543 | 3153543 | DIVIDEND | ADD | 97717W851 | 0 | 0 | 1 | 0 | 1.09212 | 00 | 2018-06-25 | 2018-06-26 | 2018-06-28 | 2018-06-22 | 0 | 2018-06-22 | ? | 0 | 0005679948 | 20180622.ifs | 2018-06-22 | 2018-06-23 | |||||||
2996465 | 2996465 | DIVIDEND | ADD | 97717W851 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2018-03-23 | 2018-03-19 | 0 | 2018-03-19 | ? | 0 | 0005631009 | 20180319.ifs | 2018-03-19 | 2018-03-20 | |||||||
2996466 | 2996466 | DIVIDEND | ADD | 97717W851 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2018-03-23 | 2018-03-19 | 0 | 2018-03-19 | ? | 0 | 0005631009 | 20180319.ifs | 2018-03-19 | 2018-03-20 | |||||||
2863121 | 2863121 | DIVIDEND | ADD | 97717W851 | 0 | 0 | 1 | 0 | .49233 | 00 | 2017-12-26 | 2017-12-27 | 2017-12-29 | 2017-12-22 | 0 | 2017-12-22 | ? | 0 | 0005579441 | 20171222.ifs | 2017-12-22 | 2017-12-23 | |||||||
2863194 | 2863194 | DIVIDEND | ADD | 97717W851 | 0 | 0 | 1 | 0 | .49233 | 00 | 2017-12-26 | 2017-12-27 | 2017-12-29 | 2017-12-22 | 0 | 2017-12-22 | ? | 0 | 0005579441 | 20171222.ifs | 2017-12-22 | 2017-12-23 | |||||||
2686002 | 2686002 | DIVIDEND | ADD | 97717W851 | 0 | 0 | 1 | 0 | .045 | 00 | 2017-09-26 | 2017-09-27 | 2017-09-29 | 2017-09-25 | 0 | 2017-09-25 | ? | 0 | 0005501933 | 20170925.ifs | 2017-09-25 | 2017-09-26 | |||||||
2686051 | 2686051 | DIVIDEND | ADD | 97717W851 | 0 | 0 | 1 | 0 | .045 | 00 | 2017-09-26 | 2017-09-27 | 2017-09-29 | 2017-09-25 | 0 | 2017-09-25 | ? | 0 | 0005501933 | 20170925.ifs | 2017-09-25 | 2017-09-26 | |||||||
2599881 | 2599881 | DIVIDEND | ADD | 97717W851 | 0 | 0 | 1 | 0 | .83 | 00 | 2017-06-26 | 2017-06-28 | 2017-06-30 | 2017-06-23 | 0 | 2017-06-23 | ? | 0 | 0005454375 | 20170623.ifs | 2017-06-23 | 2017-06-24 | |||||||
2519337 | 2519337 | DIVIDEND | ADD | 97717W851 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2017-03-31 | 2017-03-24 | 0 | 2017-03-24 | ? | 0 | 0005407522 | 20170324.ifs | 2017-03-24 | 2017-03-25 | |||||||
2447908 | 2447908 | EQUITY | CHANGE | 97717W851 | JAPAN HEDGED EQUITY FD | 0 | A | 2006-04-10 | ? | 0 | no | no | no | 2006-06-19 | 2013-03-13 | ? | 20170123.ifs | 2017-01-23 | 2017-01-24 | ||||||||||
2447909 | 2447908 | EQUITY | CHANGE | 97717W851 | JAPAN HEDGED EQUITY FD | 0 | A | 2006-04-10 | ? | 4 | no | no | no | 2006-06-19 | 2013-03-13 | ? | 20170123.ifs | 2017-01-23 | 2017-01-24 | ||||||||||
2392877 | 2392877 | DIVIDEND | ADD | 97717W851 | 0 | 0 | 1 | 0 | .49557 | 00 | 2016-12-23 | 2016-12-28 | 2016-12-30 | 2016-12-22 | 0 | 2016-12-22 | ? | 0 | 0005352417 | 20161222.ifs | 2016-12-22 | 2016-12-23 | |||||||
2300841 | 2300841 | DIVIDEND | ADD | 97717W851 | 0 | 0 | 1 | 0 | .05 | 00 | 2016-09-26 | 2016-09-28 | 2016-09-30 | 2016-09-23 | 0 | 2016-09-23 | ? | 0 | 0005285005 | 20160923.ifs | 2016-09-23 | 2016-09-24 | |||||||
2223733 | 2223733 | DIVIDEND | ADD | 97717W851 | 0 | 0 | 1 | 0 | .435 | 00 | 2016-06-20 | 2016-06-22 | 2016-06-24 | 2016-06-17 | 0 | 2016-06-17 | ? | 0 | 0005234874 | 20160617.ifs | 2016-06-17 | 2016-06-18 | |||||||
2138230 | 2138230 | DIVIDEND | ADD | 97717W851 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2016-03-28 | 2016-03-18 | 0 | 2016-03-18 | ? | 0 | 0005189423 | 20160318.ifs | 2016-03-18 | 2016-03-19 | |||||||
2051032 | 2051032 | DIVIDEND | ADD | 97717W851 | 8 | 0 | 1 | 9 | .76167 | 95 | 2015-12-21 | 2015-12-23 | 2015-12-28 | 2015-12-18 | 0 | 2015-12-18 | ? | 1 | 0005130062 | 20151218.ifs | 2015-12-18 | 2015-12-19 | |||||||
2051033 | 2051033 | DIVIDEND | ADD | 97717W851 | 8 | 0 | 1 | 9 | 1.46219 | 96 | 2015-12-21 | 2015-12-23 | 2015-12-28 | 2015-12-18 | 0 | 2015-12-18 | ? | 0 | 0005130059 | 20151218.ifs | 2015-12-18 | 2015-12-19 | |||||||
2051034 | 2051034 | DIVIDEND | ADD | 97717W851 | 0 | 0 | 1 | 0 | .39568 | 00 | 2015-12-21 | 2015-12-23 | 2015-12-28 | 2015-12-18 | 0 | 2015-12-18 | ? | 0 | 0005130001 | 20151218.ifs | 2015-12-18 | 2015-12-19 | |||||||
1969059 | 1969059 | DIVIDEND | ADD | 97717W851 | 0 | 0 | 1 | 0 | .03571 | 00 | 2015-09-21 | 2015-09-23 | 2015-09-25 | 2015-09-18 | 0 | 2015-09-18 | ? | 0 | 0005064666 | 20150918.ifs | 2015-09-18 | 2015-09-19 | |||||||
1890872 | 1890872 | DIVIDEND | ADD | 97717W851 | 0 | 0 | 1 | 0 | .32358 | 00 | 2015-06-22 | 2015-06-24 | 2015-06-26 | 2015-06-19 | 0 | 2015-06-19 | ? | 0 | 0005017018 | 20150619.ifs | 2015-06-19 | 2015-06-20 | |||||||
1816902 | 1816902 | DIVIDEND | ADD | 97717W851 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2015-03-27 | 2015-03-20 | 0 | 2015-03-20 | ? | 0 | 0004971767 | 20150320.ifs | 2015-03-20 | 2015-03-21 | |||||||
1726054 | 1726054 | DIVIDEND | ADD | 97717W851 | 8 | 0 | 1 | 9 | 1.81537 | 95 | 2014-12-19 | 2014-12-23 | 2014-12-26 | 2014-12-18 | 0 | 2014-12-18 | ? | 2 | 0004908726 | 20141218.ifs | 2014-12-18 | 2014-12-19 | |||||||
1726055 | 1726055 | DIVIDEND | ADD | 97717W851 | 8 | 0 | 1 | 9 | 2.9621 | 96 | 2014-12-19 | 2014-12-23 | 2014-12-26 | 2014-12-18 | 0 | 2014-12-18 | ? | 1 | 0004908723 | 20141218.ifs | 2014-12-18 | 2014-12-19 | |||||||
1726056 | 1726056 | DIVIDEND | ADD | 97717W851 | 0 | 0 | 1 | 0 | .39465 | 00 | 2014-12-19 | 2014-12-23 | 2014-12-26 | 2014-12-18 | 0 | 2014-12-18 | ? | 0 | 0004908720 | 20141218.ifs | 2014-12-18 | 2014-12-19 | |||||||
1634112 | 1634112 | DIVIDEND | ADD | 97717W851 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2014-09-26 | 2014-09-19 | 0 | 2014-09-19 | ? | 0 | 0004845703 | 20140919.ifs | 2014-09-19 | 2014-09-20 | |||||||
1554972 | 1554972 | DIVIDEND | ADD | 97717W851 | 0 | 0 | 1 | 0 | .54592 | 00 | 2014-06-23 | 2014-06-25 | 2014-06-27 | 2014-06-20 | 0 | 2014-06-20 | ? | 0 | 0004800005 | 20140620.ifs | 2014-06-20 | 2014-06-21 | |||||||
1473198 | 1473198 | DIVIDEND | ADD | 97717W851 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2014-03-28 | 2014-03-21 | 0 | 2014-03-21 | ? | 0 | 0004753807 | 20140321.ifs | 2014-03-21 | 2014-03-22 | |||||||
1391722 | 1391722 | DIVIDEND | ADD | 97717W851 | 8 | 0 | 1 | 9 | .18384 | 95 | 2013-12-24 | 2013-12-27 | 2013-12-31 | 2013-12-23 | 0 | 2013-12-23 | ? | 2 | 0004702353 | 20131223.ifs | 2013-12-23 | 2013-12-24 | |||||||
1391723 | 1391723 | DIVIDEND | ADD | 97717W851 | 8 | 0 | 1 | 9 | .43777 | 96 | 2013-12-24 | 2013-12-27 | 2013-12-31 | 2013-12-23 | 0 | 2013-12-23 | ? | 1 | 0004702351 | 20131223.ifs | 2013-12-23 | 2013-12-24 | |||||||
1391724 | 1391724 | DIVIDEND | ADD | 97717W851 | 0 | 0 | 1 | 0 | .37082 | 00 | 2013-12-24 | 2013-12-27 | 2013-12-31 | 2013-12-23 | 0 | 2013-12-23 | ? | 0 | 0004702313 | 20131223.ifs | 2013-12-23 | 2013-12-24 | |||||||
1292493 | 1292493 | DIVIDEND | ADD | 97717W851 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2013-09-27 | 2013-09-20 | 0 | 2013-09-20 | ? | 0 | 0004631964 | 20130920.ifs | 2013-09-20 | 2013-09-21 | |||||||
1214311 | 1214311 | DIVIDEND | ADD | 97717W851 | 0 | 0 | 1 | 0 | .24687 | 00 | 2013-06-24 | 2013-06-26 | 2013-06-28 | 2013-06-21 | 0 | 2013-06-21 | ? | 0 | 0004587568 | 20130621.ifs | 2013-06-21 | 2013-06-22 | |||||||
1138308 | 1138308 | DIVIDEND | ADD | 97717W851 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2013-03-28 | 2013-03-21 | 0 | 2013-03-21 | ? | 0 | 0004544340 | 20130321.ifs | 2013-03-21 | 2013-03-22 | |||||||
1131941 | 1131941 | EQUITY | CHANGE | 97717W851 | JPN TTL DIV FD | 0 | A | 2006-04-10 | ? | 0 | no | no | no | 2006-06-19 | 2008-03-25 | ? | 20130313.ifs | 2013-03-13 | 2013-03-14 | ||||||||||
1131942 | 1131941 | EQUITY | CHANGE | 97717W851 | JAPAN HEDGED EQUITY FD | 0 | A | 2006-04-10 | ? | 0 | no | no | no | 2006-06-19 | 2013-03-13 | ? | 20130313.ifs | 2013-03-13 | 2013-03-14 | ||||||||||
1131943 | 1131943 | CORPACTION | ADD | 97717W851 | 04 | # | 2010-04-01 | 97717W851 | 04 | 2013-03-13 | 20130313.ifs | 2013-03-13 | 2013-03-14 | ||||||||||||||||
1131944 | 1131944 | CORPACTIONAUX | ADD | 97717W851 | 04 | 2010-04-01 | DXJ | WISDOMTREE TR | JPN TTL DIV FD | DXJ | WISDOMTREE TR | JAPAN HEDGED EQ | ? | 2013-03-13 | 20130313.ifs | 2013-03-13 | 2013-03-14 | ||||||||||||
1131945 | 1131945 | EXCHANGE | CHANGE | 97717W851 | 04 | 2007-10-11 | 2013-03-12 | DXJ | 0 | A | ? | 2008-03-25 | 20130313.ifs | 2013-03-13 | 2013-03-14 | ||||||||||||||
1131946 | 1131945 | EXCHANGE | CHANGE | 97717W851 | 04 | 2007-10-11 | 2013-03-12 | DXJ | 0 | A | ? | 2013-03-13 | 20130313.ifs | 2013-03-13 | 2013-03-14 | ||||||||||||||
1055238 | 1055238 | DIVIDEND | ADD | 97717W851 | 0 | 0 | 1 | 0 | .23252 | 00 | 2012-12-24 | 2012-12-27 | 2012-12-31 | 2012-12-21 | 0 | 2012-12-21 | ? | 0 | 0004492412 | 20121221.ifs | 2012-12-21 | 2012-12-22 | |||||||
961704 | 961704 | DIVIDEND | ADD | 97717W851 | 0 | 0 | 1 | 0 | .00381 | 00 | 2012-09-24 | 2012-09-26 | 2012-09-28 | 2012-09-21 | 0 | 2012-09-21 | ? | 0 | 0004432555 | 20120921.ifs | 2012-09-21 | 2012-09-22 | |||||||
891833 | 891833 | DIVIDEND | ADD | 97717W851 | 0 | 0 | 1 | 0 | .31575 | 00 | 2012-06-25 | 2012-06-27 | 2012-06-29 | 2012-06-22 | 0 | 2012-06-22 | ? | 0 | 0004390625 | 20120622.ifs | 2012-06-22 | 2012-06-23 | |||||||
809299 | 809299 | DIVIDEND | ADD | 97717W851 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2012-03-30 | 2012-03-23 | 0 | 2012-03-23 | ? | 0 | 0004349425 | 20120323.ifs | 2012-03-23 | 2012-03-24 | |||||||
732400 | 732400 | DIVIDEND | ADD | 97717W851 | 0 | 0 | 1 | 0 | .27007 | 00 | 2011-12-21 | 2011-12-23 | 2011-12-28 | 2011-12-20 | 0 | 2011-12-20 | ? | 0 | 0004296893 | 20111220.ifs | 2011-12-20 | 2011-12-21 | |||||||
651672 | 651672 | DIVIDEND | ADD | 97717W851 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2011-09-30 | 2011-09-23 | 0 | 2011-09-23 | ? | 0 | 0004246348 | 20110923.ifs | 2011-09-23 | 2011-09-24 | |||||||
565405 | 565405 | DIVIDEND | ADD | 97717W851 | 0 | 0 | 1 | 0 | .47581 | 00 | 2011-06-22 | 2011-06-24 | 2011-06-28 | 2011-06-21 | 0 | 2011-06-21 | ? | 0 | 0004203874 | 20110621.ifs | 2011-06-21 | 2011-06-22 | |||||||
474533 | 474533 | DIVIDEND | ADD | 97717W851 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2011-03-25 | 2011-03-18 | 0 | 2011-03-18 | ? | 0 | 0004161047 | 20110318.ifs | 2011-03-18 | 2011-03-19 | |||||||
388241 | 388241 | DIVIDEND | ADD | 97717W851 | 0 | 0 | 1 | 0 | .26381 | 00 | 2010-12-22 | 2010-12-27 | 2010-12-29 | 2010-12-21 | 0 | 2010-12-21 | ? | 0 | 0004114092 | 20101221.ifs | 2010-12-21 | 2010-12-22 | |||||||
309677 | 309677 | DIVIDEND | ADD | 97717W851 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2010-09-24 | 2010-09-17 | 0 | 2010-09-17 | ? | 0 | 0004061457 | 20100917.ifs | 2010-09-17 | 2010-09-18 | |||||||
229354 | 229354 | DIVIDEND | ADD | 97717W851 | 0 | 0 | 1 | 0 | .18488 | 00 | 2010-06-28 | 2010-06-30 | 2010-07-02 | 2010-06-25 | 0 | 2010-06-25 | ? | 0 | 0004023315 | 20100625.ifs | 2010-06-25 | 2010-06-26 | |||||||
141782 | 141782 | DIVIDEND | ADD | 97717W851 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2010-04-05 | 2010-03-26 | 0 | 2010-03-26 | ? | 0 | 0003983059 | 20100326.ifs | 2010-03-26 | 2010-04-07 | |||||||
55364 | 55364 | DIVIDEND | ADD | 97717W851 | 0 | 0 | 1 | 0 | .18274 | 00 | 2009-12-21 | 2009-12-23 | 2009-12-28 | 2009-12-18 | 0 | 2009-12-18 | ? | 0 | 0003932255 | 20091218.ifs | 2009-12-18 | 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 = 152084
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