INSITITUIONS | Dynamic | newInstitTable | Changed the Cusip/Sector/Shs Out? |
|
|||||||
Total Insititutions : | 82 | 73 | Update Insititution By Cusips | ||||||||
% Owned by Insititutions: | 42.76 % | 78.49 % | |||||||||
pricingQuarterAdminPageOn:
|
2024-03-31 | New % | |||||||||
|
|||||||||||
the compid is:152085 |
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 | ||
5581463 | 5581463 | DIVIDEND | ADD | 97717W836 | 0 | 0 | 1 | 0 | .2425 | 00 | 2024-06-25 | 2024-06-25 | 2024-06-27 | 2024-06-24 | 0 | 2024-06-24 | ? | 0 | 0006936853 | 20240624.ifs | 2024-06-24 | 2024-06-25 | |||||||
5520587 | 5520587 | DIVIDEND | ADD | 97717W836 | 0 | 0 | 1 | 0 | .615 | 00 | 2024-03-22 | 2024-03-25 | 2024-03-27 | 2024-03-21 | 0 | 2024-03-21 | ? | 0 | 0006893656 | 20240321.ifs | 2024-03-21 | 2024-03-22 | |||||||
5462466 | 5462466 | DIVIDEND | ADD | 97717W836 | 0 | 0 | 1 | 0 | .04591 | 00 | 2023-12-28 | 2023-12-29 | 2024-01-03 | 2023-12-27 | 0 | 2023-12-27 | ? | 0 | 0006853135 | 20231227.ifs | 2023-12-27 | 2023-12-28 | |||||||
5455130 | 5455130 | DIVIDEND | ADD | 97717W836 | 0 | 0 | 1 | 0 | .53 | 00 | 2023-12-22 | 2023-12-26 | 2023-12-28 | 2023-12-21 | 0 | 2023-12-21 | ? | 0 | 0006846774 | 20231221.ifs | 2023-12-21 | 2023-12-22 | |||||||
5378911 | 5378911 | DIVIDEND | ADD | 97717W836 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2023-09-28 | 2023-09-22 | 0 | 2023-09-22 | ? | 0 | 0006786864 | 20230922.ifs | 2023-09-22 | 2023-09-23 | |||||||
5317469 | 5317469 | DIVIDEND | ADD | 97717W836 | 0 | 0 | 1 | 0 | .46091 | 00 | 2023-06-26 | 2023-06-27 | 2023-06-29 | 2023-06-23 | 0 | 2023-06-23 | ? | 0 | 0006743654 | 20230623.ifs | 2023-06-23 | 2023-06-24 | |||||||
5254640 | 5254640 | DIVIDEND | ADD | 97717W836 | 0 | 0 | 1 | 0 | .785 | 00 | 2023-03-27 | 2023-03-28 | 2023-03-30 | 2023-03-24 | 0 | 2023-03-24 | ? | 0 | 0006700141 | 20230324.ifs | 2023-03-24 | 2023-03-25 | |||||||
5185461 | 5185461 | DIVIDEND | ADD | 97717W836 | 0 | 0 | 1 | 0 | .6612 | 00 | 2022-12-23 | 2022-12-27 | 2022-12-29 | 2022-12-22 | 0 | 2022-12-22 | ? | 0 | 0006650910 | 20221222.ifs | 2022-12-22 | 2022-12-23 | |||||||
5103264 | 5103264 | DIVIDEND | ADD | 97717W836 | 0 | 0 | 1 | 0 | .00087 | 00 | 2022-09-26 | 2022-09-27 | 2022-09-29 | 2022-09-23 | 0 | 2022-09-23 | ? | 0 | 0006587877 | 20220923.ifs | 2022-09-23 | 2022-09-24 | |||||||
5039529 | 5039529 | DIVIDEND | ADD | 97717W836 | 0 | 0 | 1 | 0 | .995 | 00 | 2022-06-24 | 2022-06-27 | 2022-06-29 | 2022-06-23 | 0 | 2022-06-23 | ? | 0 | 0006543284 | 20220623.ifs | 2022-06-23 | 2022-06-24 | |||||||
4976790 | 4976790 | DIVIDEND | ADD | 97717W836 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2022-03-30 | 2022-03-24 | 0 | 2022-03-24 | ? | 0 | 0006499047 | 20220324.ifs | 2022-03-24 | 2022-03-25 | |||||||
4910907 | 4910907 | DIVIDEND | ADD | 97717W836 | 0 | 0 | 1 | 0 | .75297 | 00 | 2021-12-27 | 2021-12-28 | 2021-12-30 | 2021-12-23 | 0 | 2021-12-23 | ? | 0 | 0006447639 | 20211223.ifs | 2021-12-23 | 2021-12-24 | |||||||
4808135 | 4808135 | DIVIDEND | ADD | 97717W836 | 0 | 0 | 1 | 0 | .025 | 00 | 2021-09-24 | 2021-09-27 | 2021-09-29 | 2021-09-23 | 0 | 2021-09-23 | ? | 0 | 0006371713 | 20210923.ifs | 2021-09-23 | 2021-09-24 | |||||||
4735988 | 4735988 | DIVIDEND | ADD | 97717W836 | 0 | 0 | 1 | 0 | .69775 | 00 | 2021-06-24 | 2021-06-25 | 2021-06-29 | 2021-06-23 | 0 | 2021-06-23 | ? | 0 | 0006326348 | 20210623.ifs | 2021-06-23 | 2021-06-24 | |||||||
4660623 | 4660623 | DIVIDEND | ADD | 97717W836 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2021-03-30 | 2021-03-24 | 0 | 2021-03-24 | ? | 0 | 0006281274 | 20210324.ifs | 2021-03-24 | 2021-03-25 | |||||||
4553768 | 4553768 | DIVIDEND | ADD | 97717W836 | 0 | 0 | 1 | 0 | .94379 | 00 | 2020-12-21 | 2020-12-22 | 2020-12-24 | 2020-12-18 | 0 | 2020-12-18 | ? | 0 | 0006223309 | 20201218.ifs | 2020-12-18 | 2020-12-19 | |||||||
4466333 | 4466333 | DIVIDEND | ADD | 97717W836 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2020-09-25 | 2020-09-21 | 0 | 2020-09-21 | ? | 0 | 0006161339 | 20200921.ifs | 2020-09-21 | 2020-09-22 | |||||||
4396972 | 4396972 | DIVIDEND | ADD | 97717W836 | 0 | 0 | 1 | 0 | .93519 | 00 | 2020-06-23 | 2020-06-24 | 2020-06-26 | 2020-06-22 | 0 | 2020-06-22 | ? | 0 | 0006116192 | 20200622.ifs | 2020-06-22 | 2020-06-23 | |||||||
4248291 | 4248291 | DIVIDEND | ADD | 97717W836 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2020-03-27 | 2020-03-23 | 0 | 2020-03-23 | ? | 0 | 0006072237 | 20200323.ifs | 2020-03-23 | 2020-03-24 | |||||||
4248360 | 4248360 | DIVIDEND | ADD | 97717W836 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2020-03-27 | 2020-03-23 | 0 | 2020-03-23 | ? | 0 | 0006072237 | 20200323.ifs | 2020-03-23 | 2020-03-24 | |||||||
4101712 | 4101712 | DIVIDEND | ADD | 97717W836 | 0 | 0 | 1 | 0 | .79141 | 00 | 2019-12-23 | 2019-12-24 | 2019-12-27 | 2019-12-20 | 0 | 2019-12-20 | ? | 0 | 0006018618 | 20191220.ifs | 2019-12-20 | 2019-12-21 | |||||||
4102629 | 4102629 | DIVIDEND | ADD | 97717W836 | 0 | 0 | 1 | 0 | .79141 | 00 | 2019-12-23 | 2019-12-24 | 2019-12-27 | 2019-12-20 | 0 | 2019-12-20 | ? | 0 | 0006018618 | 20191220.ifs | 2019-12-20 | 2019-12-21 | |||||||
3933358 | 3933358 | DIVIDEND | ADD | 97717W836 | 0 | 0 | 1 | 0 | .06 | 00 | 2019-09-24 | 2019-09-25 | 2019-09-27 | 2019-09-23 | 0 | 2019-09-23 | ? | 0 | 0005948995 | 20190923.ifs | 2019-09-23 | 2019-09-24 | |||||||
3933359 | 3933359 | DIVIDEND | ADD | 97717W836 | 0 | 0 | 1 | 0 | .06 | 00 | 2019-09-24 | 2019-09-25 | 2019-09-27 | 2019-09-23 | 0 | 2019-09-23 | ? | 0 | 0005948995 | 20190923.ifs | 2019-09-23 | 2019-09-24 | |||||||
3792188 | 3792188 | DIVIDEND | ADD | 97717W836 | 0 | 0 | 1 | 0 | .79473 | 00 | 2019-06-24 | 2019-06-25 | 2019-06-28 | 2019-06-21 | 0 | 2019-06-21 | ? | 0 | 0005902461 | 20190621.ifs | 2019-06-21 | 2019-06-22 | |||||||
3792189 | 3792189 | DIVIDEND | ADD | 97717W836 | 0 | 0 | 1 | 0 | .79473 | 00 | 2019-06-24 | 2019-06-25 | 2019-06-28 | 2019-06-21 | 0 | 2019-06-21 | ? | 0 | 0005902461 | 20190621.ifs | 2019-06-21 | 2019-06-22 | |||||||
3646092 | 3646092 | DIVIDEND | ADD | 97717W836 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2019-03-29 | 2019-03-25 | 0 | 2019-03-25 | ? | 0 | 0005857622 | 20190325.ifs | 2019-03-25 | 2019-03-26 | |||||||
3646117 | 3646117 | DIVIDEND | ADD | 97717W836 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2019-03-29 | 2019-03-25 | 0 | 2019-03-25 | ? | 0 | 0005857622 | 20190325.ifs | 2019-03-25 | 2019-03-26 | |||||||
3485457 | 3485457 | DIVIDEND | ADD | 97717W836 | 0 | 0 | 1 | 0 | .57958 | 00 | 2018-12-24 | 2018-12-26 | 2018-12-28 | 2018-12-21 | 0 | 2018-12-21 | ? | 0 | 0005802865 | 20181221.ifs | 2018-12-21 | 2018-12-22 | |||||||
3485458 | 3485458 | DIVIDEND | ADD | 97717W836 | 0 | 0 | 1 | 0 | .57958 | 00 | 2018-12-24 | 2018-12-26 | 2018-12-28 | 2018-12-21 | 0 | 2018-12-21 | ? | 0 | 0005802865 | 20181221.ifs | 2018-12-21 | 2018-12-22 | |||||||
3296342 | 3296342 | DIVIDEND | ADD | 97717W836 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2018-09-28 | 2018-09-24 | 0 | 2018-09-24 | ? | 0 | 0005727876 | 20180924.ifs | 2018-09-24 | 2018-09-25 | |||||||
3296347 | 3296347 | DIVIDEND | ADD | 97717W836 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2018-09-28 | 2018-09-24 | 0 | 2018-09-24 | ? | 0 | 0005727876 | 20180924.ifs | 2018-09-24 | 2018-09-25 | |||||||
3153546 | 3153546 | DIVIDEND | ADD | 97717W836 | 0 | 0 | 1 | 0 | .64035 | 00 | 2018-06-25 | 2018-06-26 | 2018-06-28 | 2018-06-22 | 0 | 2018-06-22 | ? | 0 | 0005679947 | 20180622.ifs | 2018-06-22 | 2018-06-23 | |||||||
3153547 | 3153547 | DIVIDEND | ADD | 97717W836 | 0 | 0 | 1 | 0 | .64035 | 00 | 2018-06-25 | 2018-06-26 | 2018-06-28 | 2018-06-22 | 0 | 2018-06-22 | ? | 0 | 0005679947 | 20180622.ifs | 2018-06-22 | 2018-06-23 | |||||||
2996469 | 2996469 | DIVIDEND | ADD | 97717W836 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2018-03-23 | 2018-03-19 | 0 | 2018-03-19 | ? | 0 | 0005631012 | 20180319.ifs | 2018-03-19 | 2018-03-20 | |||||||
2996470 | 2996470 | DIVIDEND | ADD | 97717W836 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2018-03-23 | 2018-03-19 | 0 | 2018-03-19 | ? | 0 | 0005631012 | 20180319.ifs | 2018-03-19 | 2018-03-20 | |||||||
2863125 | 2863125 | DIVIDEND | ADD | 97717W836 | 0 | 0 | 1 | 0 | .64737 | 00 | 2017-12-26 | 2017-12-27 | 2017-12-29 | 2017-12-22 | 0 | 2017-12-22 | ? | 0 | 0005579445 | 20171222.ifs | 2017-12-22 | 2017-12-23 | |||||||
2863198 | 2863198 | DIVIDEND | ADD | 97717W836 | 0 | 0 | 1 | 0 | .64737 | 00 | 2017-12-26 | 2017-12-27 | 2017-12-29 | 2017-12-22 | 0 | 2017-12-22 | ? | 0 | 0005579445 | 20171222.ifs | 2017-12-22 | 2017-12-23 | |||||||
2686006 | 2686006 | DIVIDEND | ADD | 97717W836 | 0 | 0 | 1 | 0 | .00166 | 00 | 2017-09-26 | 2017-09-27 | 2017-09-29 | 2017-09-25 | 0 | 2017-09-25 | ? | 0 | 0005501938 | 20170925.ifs | 2017-09-25 | 2017-09-26 | |||||||
2686055 | 2686055 | DIVIDEND | ADD | 97717W836 | 0 | 0 | 1 | 0 | .00166 | 00 | 2017-09-26 | 2017-09-27 | 2017-09-29 | 2017-09-25 | 0 | 2017-09-25 | ? | 0 | 0005501938 | 20170925.ifs | 2017-09-25 | 2017-09-26 | |||||||
2599883 | 2599883 | DIVIDEND | ADD | 97717W836 | 0 | 0 | 1 | 0 | .64 | 00 | 2017-06-26 | 2017-06-28 | 2017-06-30 | 2017-06-23 | 0 | 2017-06-23 | ? | 0 | 0005454374 | 20170623.ifs | 2017-06-23 | 2017-06-24 | |||||||
2519339 | 2519339 | DIVIDEND | ADD | 97717W836 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2017-03-31 | 2017-03-24 | 0 | 2017-03-24 | ? | 0 | 0005407519 | 20170324.ifs | 2017-03-24 | 2017-03-25 | |||||||
2447904 | 2447904 | EQUITY | CHANGE | 97717W836 | JPN SMCP DIVID FD | 0 | A | 2006-04-10 | ? | 0 | no | no | no | 2006-06-19 | 2008-03-25 | ? | 20170123.ifs | 2017-01-23 | 2017-01-24 | ||||||||||
2447905 | 2447904 | EQUITY | CHANGE | 97717W836 | JPN SMCP DIVID FD | 0 | A | 2006-04-10 | ? | 4 | no | no | no | 2006-06-19 | 2008-03-25 | ? | 20170123.ifs | 2017-01-23 | 2017-01-24 | ||||||||||
2392879 | 2392879 | DIVIDEND | ADD | 97717W836 | 0 | 0 | 1 | 0 | .61913 | 00 | 2016-12-23 | 2016-12-28 | 2016-12-30 | 2016-12-22 | 0 | 2016-12-22 | ? | 0 | 0005352418 | 20161222.ifs | 2016-12-22 | 2016-12-23 | |||||||
2300843 | 2300843 | DIVIDEND | ADD | 97717W836 | 0 | 0 | 1 | 0 | .005 | 00 | 2016-09-26 | 2016-09-28 | 2016-09-30 | 2016-09-23 | 0 | 2016-09-23 | ? | 0 | 0005284990 | 20160923.ifs | 2016-09-23 | 2016-09-24 | |||||||
2223735 | 2223735 | DIVIDEND | ADD | 97717W836 | 0 | 0 | 1 | 0 | .465 | 00 | 2016-06-20 | 2016-06-22 | 2016-06-24 | 2016-06-17 | 0 | 2016-06-17 | ? | 0 | 0005234871 | 20160617.ifs | 2016-06-17 | 2016-06-18 | |||||||
2138232 | 2138232 | DIVIDEND | ADD | 97717W836 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2016-03-28 | 2016-03-18 | 0 | 2016-03-18 | ? | 0 | 0005189422 | 20160318.ifs | 2016-03-18 | 2016-03-19 | |||||||
2051036 | 2051036 | DIVIDEND | ADD | 97717W836 | 0 | 0 | 1 | 0 | .35004 | 00 | 2015-12-21 | 2015-12-23 | 2015-12-28 | 2015-12-18 | 0 | 2015-12-18 | ? | 0 | 0005130099 | 20151218.ifs | 2015-12-18 | 2015-12-19 | |||||||
1969061 | 1969061 | DIVIDEND | ADD | 97717W836 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2015-09-25 | 2015-09-18 | 0 | 2015-09-18 | ? | 0 | 0005064684 | 20150918.ifs | 2015-09-18 | 2015-09-19 | |||||||
1890874 | 1890874 | DIVIDEND | ADD | 97717W836 | 0 | 0 | 1 | 0 | .34609 | 00 | 2015-06-22 | 2015-06-24 | 2015-06-26 | 2015-06-19 | 0 | 2015-06-19 | ? | 0 | 0005017017 | 20150619.ifs | 2015-06-19 | 2015-06-20 | |||||||
1816904 | 1816904 | DIVIDEND | ADD | 97717W836 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2015-03-27 | 2015-03-20 | 0 | 2015-03-20 | ? | 0 | 0004971736 | 20150320.ifs | 2015-03-20 | 2015-03-21 | |||||||
1726058 | 1726058 | DIVIDEND | ADD | 97717W836 | 0 | 0 | 1 | 0 | .3556 | 00 | 2014-12-19 | 2014-12-23 | 2014-12-26 | 2014-12-18 | 0 | 2014-12-18 | ? | 0 | 0004908857 | 20141218.ifs | 2014-12-18 | 2014-12-19 | |||||||
1634114 | 1634114 | DIVIDEND | ADD | 97717W836 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2014-09-26 | 2014-09-19 | 0 | 2014-09-19 | ? | 0 | 0004845705 | 20140919.ifs | 2014-09-19 | 2014-09-20 | |||||||
1554974 | 1554974 | DIVIDEND | ADD | 97717W836 | 0 | 0 | 1 | 0 | .4356 | 00 | 2014-06-23 | 2014-06-25 | 2014-06-27 | 2014-06-20 | 0 | 2014-06-20 | ? | 0 | 0004800004 | 20140620.ifs | 2014-06-20 | 2014-06-21 | |||||||
1473200 | 1473200 | DIVIDEND | ADD | 97717W836 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2014-03-28 | 2014-03-21 | 0 | 2014-03-21 | ? | 0 | 0004753808 | 20140321.ifs | 2014-03-21 | 2014-03-22 | |||||||
1391726 | 1391726 | DIVIDEND | ADD | 97717W836 | 0 | 0 | 1 | 0 | .4473 | 00 | 2013-12-24 | 2013-12-27 | 2013-12-31 | 2013-12-23 | 0 | 2013-12-23 | ? | 0 | 0004702310 | 20131223.ifs | 2013-12-23 | 2013-12-24 | |||||||
1292495 | 1292495 | DIVIDEND | ADD | 97717W836 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2013-09-27 | 2013-09-20 | 0 | 2013-09-20 | ? | 0 | 0004631965 | 20130920.ifs | 2013-09-20 | 2013-09-21 | |||||||
1214313 | 1214313 | DIVIDEND | ADD | 97717W836 | 0 | 0 | 1 | 0 | .67546 | 00 | 2013-06-24 | 2013-06-26 | 2013-06-28 | 2013-06-21 | 0 | 2013-06-21 | ? | 0 | 0004587567 | 20130621.ifs | 2013-06-21 | 2013-06-22 | |||||||
1138310 | 1138310 | DIVIDEND | ADD | 97717W836 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2013-03-28 | 2013-03-21 | 0 | 2013-03-21 | ? | 0 | 0004544345 | 20130321.ifs | 2013-03-21 | 2013-03-22 | |||||||
1055240 | 1055240 | DIVIDEND | ADD | 97717W836 | 0 | 0 | 1 | 0 | .36222 | 00 | 2012-12-24 | 2012-12-27 | 2012-12-31 | 2012-12-21 | 0 | 2012-12-21 | ? | 0 | 0004492563 | 20121221.ifs | 2012-12-21 | 2012-12-22 | |||||||
961706 | 961706 | DIVIDEND | ADD | 97717W836 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2012-09-28 | 2012-09-21 | 0 | 2012-09-21 | ? | 0 | 0004432568 | 20120921.ifs | 2012-09-21 | 2012-09-22 | |||||||
891835 | 891835 | DIVIDEND | ADD | 97717W836 | 0 | 0 | 1 | 0 | .6108 | 00 | 2012-06-25 | 2012-06-27 | 2012-06-29 | 2012-06-22 | 0 | 2012-06-22 | ? | 0 | 0004390624 | 20120622.ifs | 2012-06-22 | 2012-06-23 | |||||||
809301 | 809301 | DIVIDEND | ADD | 97717W836 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2012-03-30 | 2012-03-23 | 0 | 2012-03-23 | ? | 0 | 0004349423 | 20120323.ifs | 2012-03-23 | 2012-03-24 | |||||||
732402 | 732402 | DIVIDEND | ADD | 97717W836 | 0 | 0 | 1 | 0 | .36339 | 00 | 2011-12-21 | 2011-12-23 | 2011-12-28 | 2011-12-20 | 0 | 2011-12-20 | ? | 0 | 0004296884 | 20111220.ifs | 2011-12-20 | 2011-12-21 | |||||||
651674 | 651674 | DIVIDEND | ADD | 97717W836 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2011-09-30 | 2011-09-23 | 0 | 2011-09-23 | ? | 0 | 0004246346 | 20110923.ifs | 2011-09-23 | 2011-09-24 | |||||||
565407 | 565407 | DIVIDEND | ADD | 97717W836 | 0 | 0 | 1 | 0 | .53356 | 00 | 2011-06-22 | 2011-06-24 | 2011-06-28 | 2011-06-21 | 0 | 2011-06-21 | ? | 0 | 0004203873 | 20110621.ifs | 2011-06-21 | 2011-06-22 | |||||||
474535 | 474535 | DIVIDEND | ADD | 97717W836 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2011-03-25 | 2011-03-18 | 0 | 2011-03-18 | ? | 0 | 0004161049 | 20110318.ifs | 2011-03-18 | 2011-03-19 | |||||||
388243 | 388243 | DIVIDEND | ADD | 97717W836 | 0 | 0 | 1 | 0 | .38824 | 00 | 2010-12-22 | 2010-12-27 | 2010-12-29 | 2010-12-21 | 0 | 2010-12-21 | ? | 0 | 0004114046 | 20101221.ifs | 2010-12-21 | 2010-12-22 | |||||||
309679 | 309679 | DIVIDEND | ADD | 97717W836 | 0 | 0 | 1 | 0 | .05086 | 00 | 2010-09-20 | 2010-09-22 | 2010-09-24 | 2010-09-17 | 0 | 2010-09-17 | ? | 0 | 0004061448 | 20100917.ifs | 2010-09-17 | 2010-09-18 | |||||||
229356 | 229356 | DIVIDEND | ADD | 97717W836 | 0 | 0 | 1 | 0 | .31298 | 00 | 2010-06-28 | 2010-06-30 | 2010-07-02 | 2010-06-25 | 0 | 2010-06-25 | ? | 0 | 0004023313 | 20100625.ifs | 2010-06-25 | 2010-06-26 | |||||||
141784 | 141784 | DIVIDEND | ADD | 97717W836 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2010-04-05 | 2010-03-26 | 0 | 2010-03-26 | ? | 0 | 0003983057 | 20100326.ifs | 2010-03-26 | 2010-04-07 | |||||||
55365 | 55365 | DIVIDEND | ADD | 97717W836 | 0 | 0 | 1 | 0 | .28914 | 00 | 2009-12-21 | 2009-12-23 | 2009-12-28 | 2009-12-18 | 0 | 2009-12-18 | ? | 0 | 0003932268 | 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 = 152085
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