INSITITUIONS | Dynamic | newInstitTable | Changed the Cusip/Sector/Shs Out? |
|
||||||||||
Total Insititutions : | 116 | 117 | Update Insititution By Cusips | |||||||||||
% Owned by Insititutions: | 8.16 % | 12.21 % | ||||||||||||
pricingQuarterAdminPageOn:
|
2024-03-31 | New % | ||||||||||||
|
||||||||||||||
the compid is:159715 |
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 | ||
5584248 | 5584248 | DIVIDEND | ADD | 33737J174 | 0 | 0 | 1 | 0 | .8713 | 00 | 2024-06-27 | 2024-06-27 | 2024-06-28 | 2024-06-26 | 0 | 2024-06-26 | ? | 0 | 0006938768 | 20240626.ifs | 2024-06-26 | 2024-06-27 | |||||||
5519836 | 5519836 | DIVIDEND | ADD | 33737J174 | 0 | 0 | 1 | 0 | .1962 | 00 | 2024-03-21 | 2024-03-22 | 2024-03-28 | 2024-03-20 | 0 | 2024-03-20 | ? | 0 | 0006892785 | 20240320.ifs | 2024-03-20 | 2024-03-21 | |||||||
5457245 | 5457245 | DIVIDEND | ADD | 33737J174 | 0 | 0 | 1 | 0 | .9269 | 00 | 2023-12-22 | 2023-12-26 | 2023-12-29 | 2023-12-21 | 0 | 2023-12-21 | ? | 0 | 0006846869 | 20231221.ifs | 2023-12-21 | 2023-12-22 | |||||||
5378387 | 5378387 | DIVIDEND | ADD | 33737J174 | 0 | 0 | 1 | 0 | .2756 | 00 | 2023-09-22 | 2023-09-25 | 2023-09-29 | 2023-09-21 | 0 | 2023-09-21 | ? | 0 | 0006786271 | 20230921.ifs | 2023-09-21 | 2023-09-22 | |||||||
5318813 | 5318813 | DIVIDEND | ADD | 33737J174 | 0 | 0 | 1 | 0 | .8802 | 00 | 2023-06-27 | 2023-06-28 | 2023-06-30 | 2023-06-26 | 0 | 2023-06-26 | ? | 0 | 0006744192 | 20230626.ifs | 2023-06-26 | 2023-06-27 | |||||||
5254079 | 5254079 | DIVIDEND | ADD | 33737J174 | 0 | 0 | 1 | 0 | .2049 | 00 | 2023-03-24 | 2023-03-27 | 2023-03-31 | 2023-03-23 | 0 | 2023-03-23 | ? | 0 | 0006699609 | 20230323.ifs | 2023-03-23 | 2023-03-24 | |||||||
5186791 | 5186791 | DIVIDEND | ADD | 33737J174 | 0 | 0 | 1 | 0 | .1878 | 00 | 2022-12-23 | 2022-12-27 | 2022-12-30 | 2022-12-22 | 0 | 2022-12-22 | ? | 0 | 0006651105 | 20221222.ifs | 2022-12-22 | 2022-12-23 | |||||||
5102634 | 5102634 | DIVIDEND | ADD | 33737J174 | 0 | 0 | 1 | 0 | .1617 | 00 | 2022-09-23 | 2022-09-26 | 2022-09-30 | 2022-09-22 | 0 | 2022-09-22 | ? | 0 | 0006587257 | 20220922.ifs | 2022-09-22 | 2022-09-23 | |||||||
5040113 | 5040113 | DIVIDEND | ADD | 33737J174 | 0 | 0 | 1 | 0 | .6581 | 00 | 2022-06-24 | 2022-06-27 | 2022-06-30 | 2022-06-23 | 0 | 2022-06-23 | ? | 0 | 0006543162 | 20220623.ifs | 2022-06-23 | 2022-06-24 | |||||||
4977255 | 4977255 | DIVIDEND | ADD | 33737J174 | 0 | 0 | 1 | 0 | .0838 | 00 | 2022-03-25 | 2022-03-28 | 2022-03-31 | 2022-03-24 | 0 | 2022-03-24 | ? | 0 | 0006498996 | 20220324.ifs | 2022-03-24 | 2022-03-25 | |||||||
4909130 | 4909130 | DIVIDEND | ADD | 33737J174 | 0 | 0 | 1 | 0 | 1.108 | 00 | 2021-12-23 | 2021-12-27 | 2021-12-31 | 2021-12-22 | 0 | 2021-12-22 | ? | 0 | 0006445345 | 20211222.ifs | 2021-12-22 | 2021-12-23 | |||||||
4807608 | 4807608 | DIVIDEND | ADD | 33737J174 | 0 | 0 | 1 | 0 | .3553 | 00 | 2021-09-23 | 2021-09-24 | 2021-09-30 | 2021-09-22 | 0 | 2021-09-22 | ? | 0 | 0006370771 | 20210922.ifs | 2021-09-22 | 2021-09-23 | |||||||
4736455 | 4736455 | DIVIDEND | ADD | 33737J174 | 0 | 0 | 1 | 0 | .6103 | 00 | 2021-06-24 | 2021-06-25 | 2021-06-30 | 2021-06-23 | 0 | 2021-06-23 | ? | 0 | 0006326279 | 20210623.ifs | 2021-06-23 | 2021-06-24 | |||||||
4661256 | 4661256 | DIVIDEND | ADD | 33737J174 | 0 | 0 | 1 | 0 | .2339 | 00 | 2021-03-25 | 2021-03-26 | 2021-03-31 | 2021-03-24 | 0 | 2021-03-24 | ? | 0 | 0006281222 | 20210324.ifs | 2021-03-24 | 2021-03-25 | |||||||
4572319 | 4572319 | DIVIDEND | ADD | 33737J174 | 0 | 0 | 1 | 0 | .8998 | 00 | 2020-12-24 | 2020-12-28 | 2020-12-31 | 2020-12-23 | 0 | 2020-12-23 | ? | 0 | 0006232305 | 20201223.ifs | 2020-12-23 | 2020-12-24 | |||||||
4468493 | 4468493 | DIVIDEND | ADD | 33737J174 | 0 | 0 | 1 | 0 | .0605 | 00 | 2020-09-24 | 2020-09-25 | 2020-09-30 | 2020-09-23 | 0 | 2020-09-23 | ? | 0 | 0006162624 | 20200923.ifs | 2020-09-23 | 2020-09-24 | |||||||
4399527 | 4399527 | DIVIDEND | ADD | 33737J174 | 0 | 0 | 1 | 0 | .358 | 00 | 2020-06-25 | 2020-06-26 | 2020-06-30 | 2020-06-24 | 0 | 2020-06-24 | ? | 0 | 0006117761 | 20200624.ifs | 2020-06-24 | 2020-06-25 | |||||||
4255755 | 4255755 | DIVIDEND | ADD | 33737J174 | 0 | 0 | 1 | 0 | .0491 | 00 | 2020-03-26 | 2020-03-27 | 2020-03-31 | 2020-03-25 | 0 | 2020-03-25 | ? | 0 | 0006073717 | 20200325.ifs | 2020-03-25 | 2020-03-26 | |||||||
4255756 | 4255756 | DIVIDEND | ADD | 33737J174 | 0 | 0 | 1 | 0 | .0491 | 00 | 2020-03-26 | 2020-03-27 | 2020-03-31 | 2020-03-25 | 0 | 2020-03-25 | ? | 0 | 0006073717 | 20200325.ifs | 2020-03-25 | 2020-03-26 | |||||||
4062605 | 4062605 | DIVIDEND | ADD | 33737J174 | 0 | 0 | 1 | 0 | .6269 | 00 | 2019-12-13 | 2019-12-16 | 2019-12-31 | 2019-12-12 | 0 | 2019-12-12 | ? | 0 | 0005996512 | 20191212.ifs | 2019-12-12 | 2019-12-13 | |||||||
4062704 | 4062704 | DIVIDEND | ADD | 33737J174 | 0 | 0 | 1 | 0 | .6269 | 00 | 2019-12-13 | 2019-12-16 | 2019-12-31 | 2019-12-12 | 0 | 2019-12-12 | ? | 0 | 0005996512 | 20191212.ifs | 2019-12-12 | 2019-12-13 | |||||||
3936969 | 3936969 | DIVIDEND | ADD | 33737J174 | 0 | 0 | 1 | 0 | .2947 | 00 | 2019-09-25 | 2019-09-26 | 2019-09-30 | 2019-09-24 | 0 | 2019-09-24 | ? | 0 | 0005949742 | 20190924.ifs | 2019-09-24 | 2019-09-25 | |||||||
3937096 | 3937096 | DIVIDEND | ADD | 33737J174 | 0 | 0 | 1 | 0 | .2947 | 00 | 2019-09-25 | 2019-09-26 | 2019-09-30 | 2019-09-24 | 0 | 2019-09-24 | ? | 0 | 0005949742 | 20190924.ifs | 2019-09-24 | 2019-09-25 | |||||||
3778458 | 3778458 | DIVIDEND | ADD | 33737J174 | 0 | 0 | 1 | 0 | .5137 | 00 | 2019-06-14 | 2019-06-17 | 2019-06-28 | 2019-06-13 | 0 | 2019-06-13 | ? | 0 | 0005897625 | 20190613.ifs | 2019-06-13 | 2019-06-14 | |||||||
3778459 | 3778459 | DIVIDEND | ADD | 33737J174 | 0 | 0 | 1 | 0 | .5137 | 00 | 2019-06-14 | 2019-06-17 | 2019-06-28 | 2019-06-13 | 0 | 2019-06-13 | ? | 0 | 0005897625 | 20190613.ifs | 2019-06-13 | 2019-06-14 | |||||||
3640386 | 3640386 | DIVIDEND | ADD | 33737J174 | 0 | 0 | 1 | 0 | .112 | 00 | 2019-03-21 | 2019-03-22 | 2019-03-29 | 2019-03-20 | 0 | 2019-03-20 | ? | 0 | 0005855732 | 20190320.ifs | 2019-03-20 | 2019-03-21 | |||||||
3640387 | 3640387 | DIVIDEND | ADD | 33737J174 | 0 | 0 | 1 | 0 | .112 | 00 | 2019-03-21 | 2019-03-22 | 2019-03-29 | 2019-03-20 | 0 | 2019-03-20 | ? | 0 | 0005855732 | 20190320.ifs | 2019-03-20 | 2019-03-21 | |||||||
3454415 | 3454415 | DIVIDEND | ADD | 33737J174 | 0 | 0 | 1 | 0 | .2544 | 00 | 2018-12-18 | 2018-12-19 | 2018-12-31 | 2018-12-17 | 0 | 2018-12-17 | ? | 0 | 0005784816 | 20181217.ifs | 2018-12-17 | 2018-12-18 | |||||||
3454582 | 3454582 | DIVIDEND | ADD | 33737J174 | 0 | 0 | 1 | 0 | .2544 | 00 | 2018-12-18 | 2018-12-19 | 2018-12-31 | 2018-12-17 | 0 | 2018-12-17 | ? | 0 | 0005784816 | 20181217.ifs | 2018-12-17 | 2018-12-18 | |||||||
3281857 | 3281857 | DIVIDEND | ADD | 33737J174 | 0 | 0 | 1 | 0 | .235 | 00 | 2018-09-14 | 2018-09-17 | 2018-09-28 | 2018-09-13 | 0 | 2018-09-13 | ? | 0 | 0005723000 | 20180913.ifs | 2018-09-13 | 2018-09-14 | |||||||
3281931 | 3281931 | DIVIDEND | ADD | 33737J174 | 0 | 0 | 1 | 0 | .235 | 00 | 2018-09-14 | 2018-09-17 | 2018-09-28 | 2018-09-13 | 0 | 2018-09-13 | ? | 0 | 0005723000 | 20180913.ifs | 2018-09-13 | 2018-09-14 | |||||||
3149451 | 3149451 | DIVIDEND | ADD | 33737J174 | 0 | 0 | 1 | 0 | .4985 | 00 | 2018-06-21 | 2018-06-22 | 2018-06-29 | 2018-06-20 | 0 | 2018-06-20 | ? | 0 | 0005678283 | 20180620.ifs | 2018-06-20 | 2018-06-21 | |||||||
3149470 | 3149470 | DIVIDEND | ADD | 33737J174 | 0 | 0 | 1 | 0 | .4985 | 00 | 2018-06-21 | 2018-06-22 | 2018-06-29 | 2018-06-20 | 0 | 2018-06-20 | ? | 0 | 0005678283 | 20180620.ifs | 2018-06-20 | 2018-06-21 | |||||||
3001130 | 3001130 | DIVIDEND | ADD | 33737J174 | 0 | 0 | 1 | 0 | .0579 | 00 | 2018-03-22 | 2018-03-23 | 2018-03-29 | 2018-03-21 | 0 | 2018-03-21 | ? | 0 | 0005632587 | 20180321.ifs | 2018-03-21 | 2018-03-22 | |||||||
3001153 | 3001153 | DIVIDEND | ADD | 33737J174 | 0 | 0 | 1 | 0 | .0579 | 00 | 2018-03-22 | 2018-03-23 | 2018-03-29 | 2018-03-21 | 0 | 2018-03-21 | ? | 0 | 0005632587 | 20180321.ifs | 2018-03-21 | 2018-03-22 | |||||||
2852963 | 2852963 | DIVIDEND | ADD | 33737J174 | 0 | 0 | 1 | 0 | .5493 | 00 | 2017-12-21 | 2017-12-22 | 2017-12-29 | 2017-12-20 | 0 | 2017-12-20 | ? | 0 | 0005570558 | 20171220.ifs | 2017-12-20 | 2017-12-21 | |||||||
2856396 | 2856396 | DIVIDEND | ADD | 33737J174 | 0 | 0 | 1 | 0 | .5493 | 00 | 2017-12-21 | 2017-12-22 | 2017-12-29 | 2017-12-20 | 0 | 2017-12-20 | ? | 0 | 0005570558 | 20171220.ifs | 2017-12-20 | 2017-12-21 | |||||||
2680363 | 2680363 | DIVIDEND | ADD | 33737J174 | 0 | 0 | 1 | 0 | .0909 | 00 | 2017-09-21 | 2017-09-22 | 2017-09-29 | 2017-09-20 | 0 | 2017-09-20 | ? | 0 | 0005500121 | 20170920.ifs | 2017-09-20 | 2017-09-21 | |||||||
2680394 | 2680394 | DIVIDEND | ADD | 33737J174 | 0 | 0 | 1 | 0 | .0909 | 00 | 2017-09-21 | 2017-09-22 | 2017-09-29 | 2017-09-20 | 0 | 2017-09-20 | ? | 0 | 0005500121 | 20170920.ifs | 2017-09-20 | 2017-09-21 | |||||||
2597587 | 2597587 | DIVIDEND | ADD | 33737J174 | 0 | 0 | 1 | 0 | .2609 | 00 | 2017-06-22 | 2017-06-26 | 2017-06-30 | 2017-06-21 | 0 | 2017-06-21 | ? | 0 | 0005452828 | 20170621.ifs | 2017-06-21 | 2017-06-22 | |||||||
2438228 | 2438228 | EQUITY | CHANGE | 33737J174 | DEV MKTS EX US ALPHADEX FD | N | A | 2011-04-19 | ? | 0 | no | no | yes | 2011-04-19 | 2015-10-13 | ? | 20170123.ifs | 2017-01-23 | 2017-01-24 | ||||||||||
2438229 | 2438228 | EQUITY | CHANGE | 33737J174 | DEV MKTS EX US ALPHADEX FD | N | A | 2011-04-19 | ? | 4 | no | no | yes | 2011-04-19 | 2015-10-13 | ? | 20170123.ifs | 2017-01-23 | 2017-01-24 | ||||||||||
2388736 | 2388736 | DIVIDEND | ADD | 33737J174 | 0 | 0 | 1 | 0 | .2809 | 00 | 2016-12-21 | 2016-12-23 | 2016-12-30 | 2016-12-20 | 0 | 2016-12-20 | ? | 0 | 0005346814 | 20161220.ifs | 2016-12-20 | 2016-12-21 | |||||||
2297951 | 2297951 | DIVIDEND | ADD | 33737J174 | 0 | 0 | 1 | 0 | .0764 | 00 | 2016-09-21 | 2016-09-23 | 2016-09-30 | 2016-09-20 | 0 | 2016-09-20 | ? | 0 | 0005283143 | 20160920.ifs | 2016-09-20 | 2016-09-21 | |||||||
2226821 | 2226821 | DIVIDEND | ADD | 33737J174 | 0 | 0 | 1 | 0 | .4136 | 00 | 2016-06-22 | 2016-06-24 | 2016-06-30 | 2016-06-21 | 0 | 2016-06-21 | ? | 0 | 0005236392 | 20160621.ifs | 2016-06-21 | 2016-06-22 | |||||||
2140745 | 2140745 | DIVIDEND | ADD | 33737J174 | 0 | 0 | 1 | 0 | .0596 | 00 | 2016-03-23 | 2016-03-28 | 2016-03-31 | 2016-03-22 | 0 | 2016-03-22 | ? | 0 | 0005190602 | 20160322.ifs | 2016-03-22 | 2016-03-23 | |||||||
2060128 | 2060128 | DIVIDEND | ADD | 33737J174 | 0 | 0 | 1 | 0 | .342 | 00 | 2015-12-23 | 2015-12-28 | 2015-12-31 | 2015-12-22 | 0 | 2015-12-22 | ? | 0 | 0005136118 | 20151222.ifs | 2015-12-22 | 2015-12-23 | |||||||
1989759 | 1989759 | CORPACTION | ADD | 33737J174 | 04 | X | 2015-10-13 | 33737J174 | 60 | ? | 20151013.ifs | 2015-10-13 | 2015-10-14 | ||||||||||||||||
1989760 | 1989760 | EXCHANGE | ADD | 33737J174 | 60 | 2015-10-13 | 2015-10-13 | FDT | 0 | A | 2015-10-13 | ? | 20151013.ifs | 2015-10-13 | 2015-10-14 | ||||||||||||||
1989761 | 1989761 | EQUITY | CHANGE | 33737J174 | DEV MKTS EX US ALPHADEX FD | 0 | A | 2011-04-19 | ? | 0 | no | no | no | 2011-04-19 | 2011-04-19 | ? | 20151013.ifs | 2015-10-13 | 2015-10-14 | ||||||||||
1989762 | 1989761 | EQUITY | CHANGE | 33737J174 | DEV MKTS EX US ALPHADEX FD | 0 | A | 2011-04-19 | ? | 0 | no | no | yes | 2011-04-19 | 2015-10-13 | ? | 20151013.ifs | 2015-10-13 | 2015-10-14 | ||||||||||
1989858 | 1989858 | EQUITY | CHANGE | 33737J174 | DEV MKTS EX US ALPHADEX FD | 0 | A | 2011-04-19 | ? | 0 | no | no | yes | 2011-04-19 | 2015-10-13 | ? | 20151013.ifs | 2015-10-13 | 2015-10-14 | ||||||||||
1989859 | 1989858 | EQUITY | CHANGE | 33737J174 | DEV MKTS EX US ALPHADEX FD | N | A | 2011-04-19 | ? | 0 | no | no | yes | 2011-04-19 | 2015-10-13 | ? | 20151013.ifs | 2015-10-13 | 2015-10-14 | ||||||||||
1819419 | 1819419 | DIVIDEND | ADD | 33737J174 | 0 | 0 | 1 | 0 | .0905 | 00 | 2015-03-25 | 2015-03-27 | 2015-03-31 | 2015-03-24 | 0 | 2015-03-24 | ? | 0 | 0004972624 | 20150324.ifs | 2015-03-24 | 2015-03-25 | |||||||
1737686 | 1737686 | DIVIDEND | ADD | 33737J174 | 0 | 0 | 1 | 0 | .2731 | 00 | 2014-12-23 | 2014-12-26 | 2014-12-31 | 2014-12-22 | 0 | 2014-12-22 | ? | 0 | 0004916154 | 20141222.ifs | 2014-12-22 | 2014-12-23 | |||||||
1635548 | 1635548 | DIVIDEND | ADD | 33737J174 | 0 | 0 | 1 | 0 | .0322 | 00 | 2014-09-23 | 2014-09-25 | 2014-09-30 | 2014-09-22 | 0 | 2014-09-22 | ? | 0 | 0004846052 | 20140922.ifs | 2014-09-22 | 2014-09-23 | |||||||
1557409 | 1557409 | DIVIDEND | ADD | 33737J174 | 0 | 0 | 1 | 0 | .4838 | 00 | 2014-06-24 | 2014-06-26 | 2014-06-30 | 2014-06-23 | 0 | 2014-06-23 | ? | 0 | 0004800511 | 20140623.ifs | 2014-06-23 | 2014-06-24 | |||||||
1474711 | 1474711 | DIVIDEND | ADD | 33737J174 | 0 | 0 | 1 | 0 | .0361 | 00 | 2014-03-25 | 2014-03-27 | 2014-03-31 | 2014-03-24 | 0 | 2014-03-24 | ? | 0 | 0004754552 | 20140324.ifs | 2014-03-24 | 2014-03-25 | |||||||
1377390 | 1377390 | DIVIDEND | ADD | 33737J174 | 0 | 0 | 1 | 0 | .3087 | 00 | 2013-12-18 | 2013-12-20 | 2013-12-31 | 2013-12-17 | 0 | 2013-12-17 | ? | 0 | 0004688733 | 20131217.ifs | 2013-12-17 | 2013-12-18 | |||||||
1291586 | 1291586 | DIVIDEND | ADD | 33737J174 | 0 | 0 | 1 | 0 | .145 | 00 | 2013-09-20 | 2013-09-24 | 2013-09-30 | 2013-09-19 | 0 | 2013-09-19 | ? | 0 | 0004630850 | 20130919.ifs | 2013-09-19 | 2013-09-20 | |||||||
1213715 | 1213715 | DIVIDEND | ADD | 33737J174 | 0 | 0 | 1 | 0 | .4375 | 00 | 2013-06-21 | 2013-06-25 | 2013-06-28 | 2013-06-20 | 0 | 2013-06-20 | ? | 0 | 0004586658 | 20130620.ifs | 2013-06-20 | 2013-06-21 | |||||||
1137758 | 1137758 | DIVIDEND | ADD | 33737J174 | 0 | 0 | 1 | 0 | .0768 | 00 | 2013-03-21 | 2013-03-25 | 2013-03-28 | 2013-03-20 | 0 | 2013-03-20 | ? | 0 | 0004543603 | 20130320.ifs | 2013-03-20 | 2013-03-21 | |||||||
1053328 | 1053328 | DIVIDEND | ADD | 33737J174 | 0 | 0 | 1 | 0 | .2821 | 00 | 2012-12-21 | 2012-12-26 | 2012-12-31 | 2012-12-20 | 0 | 2012-12-20 | ? | 0 | 0004489666 | 20121220.ifs | 2012-12-20 | 2012-12-21 | |||||||
960851 | 960851 | DIVIDEND | ADD | 33737J174 | 0 | 0 | 1 | 0 | .0584 | 00 | 2012-09-21 | 2012-09-25 | 2012-09-28 | 2012-09-20 | 0 | 2012-09-20 | ? | 0 | 0004431789 | 20120920.ifs | 2012-09-20 | 2012-09-21 | |||||||
960852 | 960852 | DIVIDEND | CHANGE | 33737J174 | 0 | 0 | 1 | 0 | .5216 | 00 | 2012-06-21 | 2012-06-25 | 2012-06-29 | 2012-06-20 | 0 | 2012-06-20 | ? | 0 | 0004389076 | 20120920.ifs | 2012-09-20 | 2012-09-21 | |||||||
960853 | 960852 | DIVIDEND | CHANGE | 33737J174 | 0 | 0 | 1 | 0 | .5216 | 00 | 2012-06-21 | 2012-06-25 | 2012-06-29 | 2012-06-20 | 1 | 2012-06-20 | 2012-09-20 | 0 | 0004389076 | 20120920.ifs | 2012-09-20 | 2012-09-21 | |||||||
889867 | 889867 | DIVIDEND | ADD | 33737J174 | 0 | 0 | 1 | 0 | .5216 | 00 | 2012-06-21 | 2012-06-25 | 2012-06-29 | 2012-06-20 | 0 | 2012-06-20 | ? | 0 | 0004389076 | 20120620.ifs | 2012-06-20 | 2012-06-21 | |||||||
733333 | 733333 | DIVIDEND | ADD | 33737J174 | 0 | 0 | 1 | 0 | .1766 | 00 | 2011-12-21 | 2011-12-23 | 2011-12-30 | 2011-12-20 | 0 | 2011-12-20 | ? | 0 | 0004296784 | 20111220.ifs | 2011-12-20 | 2011-12-21 | |||||||
564518 | 564518 | DIVIDEND | ADD | 33737J174 | 0 | 0 | 1 | 4 | .3949 | 00 | 2011-06-21 | 2011-06-23 | 2011-06-30 | 2011-06-20 | 0 | 2011-06-20 | ? | 0 | 0004203062 | 20110620.ifs | 2011-06-20 | 2011-06-21 | |||||||
504294 | 504294 | EQUITY | ADD | 33737J174 | DEV MKTS EX US ALPHADEX FD | N | 7 | 2011-04-19 | ? | 0 | no | no | no | 2011-04-19 | ? | ? | 20110419.ifs | 2011-04-19 | 2011-04-20 | ||||||||||
504295 | 504295 | EXCHANGE | ADD | 33737J174 | 04 | 2011-04-19 | 2011-04-19 | FDT | 0 | A | 2011-04-19 | ? | 20110419.ifs | 2011-04-19 | 2011-04-20 | ||||||||||||||
504399 | 504399 | EQUITY | CHANGE | 33737J174 | DEV MKTS EX US ALPHADEX FD | N | 7 | 2011-04-19 | ? | 0 | no | no | no | 2011-04-19 | ? | ? | 20110419.ifs | 2011-04-19 | 2011-04-20 | ||||||||||
504400 | 504399 | EQUITY | CHANGE | 33737J174 | DEV MKTS EX US ALPHADEX FD | N | A | 2011-04-19 | ? | 0 | no | no | no | 2011-04-19 | 2011-04-19 | ? | 20110419.ifs | 2011-04-19 | 2011-04-20 | ||||||||||
504602 | 504602 | EQUITY | CHANGE | 33737J174 | DEV MKTS EX US ALPHADEX FD | N | A | 2011-04-19 | ? | 0 | no | no | no | 2011-04-19 | 2011-04-19 | ? | 20110419.ifs | 2011-04-19 | 2011-04-20 | ||||||||||
504603 | 504602 | EQUITY | CHANGE | 33737J174 | DEV MKTS EX US ALPHADEX FD | 0 | A | 2011-04-19 | ? | 0 | no | no | no | 2011-04-19 | 2011-04-19 | ? | 20110419.ifs | 2011-04-19 | 2011-04-20 |
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 = 159715
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