INSITITUIONS | Dynamic | newInstitTable | Changed the Cusip/Sector/Shs Out? |
|
||||||||||
Total Insititutions : | N/A | 0 | Update Insititution By Cusips | |||||||||||
% Owned by Insititutions: | N/A % | 0 % | ||||||||||||
pricingQuarterAdminPageOn:
|
2024-03-31 | New % | ||||||||||||
|
||||||||||||||
the compid is:159803 |
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 | ||
4512774 | 4512774 | CORPACTION | ADD | 902641620 | 04 | C | 2020-11-24 | ? | 20201124.ifs | 2020-11-24 | 2020-11-25 | ||||||||||||||||||
4512775 | 4512775 | EQUITY | CHANGE | 902641620 | E TRACS LKD ALERIAN NATURAL GAS INDEX | 0 | A | 2010-07-14 | ? | 4 | no | no | no | 2010-07-14 | 2010-07-14 | ? | 20201124.ifs | 2020-11-24 | 2020-11-25 | ||||||||||
4512776 | 4512775 | EQUITY | CHANGE | 902641620 | E TRACS LKD ALERIAN NATURAL GAS INDEX | C | A | 2010-07-14 | 2020-11-24 | 4 | no | no | no | 2010-07-14 | 2020-11-24 | ? | 20201124.ifs | 2020-11-24 | 2020-11-25 | ||||||||||
4501505 | 4501505 | DIVIDEND | CHANGE | 902641620 | 0 | 0 | 1 | 0 | .3367 | 00 | 2020-10-09 | 2020-10-13 | 2020-10-21 | 2020-10-05 | 0 | 2020-10-05 | ? | 0 | 0006173827 | 20201103.ifs | 2020-11-03 | 2020-11-04 | |||||||
4501506 | 4501505 | DIVIDEND | CHANGE | 902641620 | 0 | 0 | 1 | 0 | .3367 | 00 | 2020-10-09 | 2020-10-13 | 2020-10-21 | 2020-10-05 | 1 | 2020-10-05 | 2020-11-03 | 0 | 0006173827 | 20201103.ifs | 2020-11-03 | 2020-11-04 | |||||||
4482641 | 4482641 | DIVIDEND | ADD | 902641620 | 0 | 0 | 1 | 0 | .3367 | 00 | 2020-10-09 | 2020-10-13 | 2020-10-21 | 2020-10-05 | 0 | 2020-10-05 | ? | 0 | 0006173827 | 20201005.ifs | 2020-10-05 | 2020-10-06 | |||||||
4416723 | 4416723 | DIVIDEND | ADD | 902641620 | 0 | 0 | 1 | 0 | .2746 | 00 | 2020-07-13 | 2020-07-14 | 2020-07-22 | 2020-07-09 | 0 | 2020-07-09 | ? | 0 | 0006129667 | 20200709.ifs | 2020-07-09 | 2020-07-10 | |||||||
4282372 | 4282372 | DIVIDEND | ADD | 902641620 | 0 | 0 | 1 | 0 | .4576 | 00 | 2020-04-09 | 2020-04-13 | 2020-04-21 | 2020-04-06 | 0 | 2020-04-06 | ? | 0 | 0006084044 | 20200406.ifs | 2020-04-06 | 2020-04-07 | |||||||
4282448 | 4282448 | DIVIDEND | ADD | 902641620 | 0 | 0 | 1 | 0 | .4576 | 00 | 2020-04-09 | 2020-04-13 | 2020-04-21 | 2020-04-06 | 0 | 2020-04-06 | ? | 0 | 0006084044 | 20200406.ifs | 2020-04-06 | 2020-04-07 | |||||||
4165795 | 4165795 | DIVIDEND | ADD | 902641620 | 0 | 0 | 1 | 0 | .4376 | 00 | 2020-01-10 | 2020-01-13 | 2020-01-22 | 2020-01-07 | 0 | 2020-01-08 | ? | 0 | 0006041871 | 20200108.ifs | 2020-01-08 | 2020-01-09 | |||||||
4165798 | 4165798 | DIVIDEND | ADD | 902641620 | 0 | 0 | 1 | 0 | .4376 | 00 | 2020-01-10 | 2020-01-13 | 2020-01-22 | 2020-01-07 | 0 | 2020-01-08 | ? | 0 | 0006041871 | 20200108.ifs | 2020-01-08 | 2020-01-09 | |||||||
3965992 | 3965992 | DIVIDEND | ADD | 902641620 | 0 | 0 | 1 | 0 | .4136 | 00 | 2019-10-10 | 2019-10-11 | 2019-10-21 | 2019-10-04 | 0 | 2019-10-04 | ? | 0 | 0005960789 | 20191004.ifs | 2019-10-04 | 2019-10-05 | |||||||
3966045 | 3966045 | DIVIDEND | ADD | 902641620 | 0 | 0 | 1 | 0 | .4136 | 00 | 2019-10-10 | 2019-10-11 | 2019-10-21 | 2019-10-04 | 0 | 2019-10-04 | ? | 0 | 0005960789 | 20191004.ifs | 2019-10-04 | 2019-10-05 | |||||||
3829906 | 3829906 | DIVIDEND | ADD | 902641620 | 0 | 0 | 1 | 0 | .4025 | 00 | 2019-07-12 | 2019-07-15 | 2019-07-23 | 2019-07-08 | 0 | 2019-07-08 | ? | 0 | 0005915249 | 20190708.ifs | 2019-07-08 | 2019-07-09 | |||||||
3829933 | 3829933 | DIVIDEND | ADD | 902641620 | 0 | 0 | 1 | 0 | .4025 | 00 | 2019-07-12 | 2019-07-15 | 2019-07-23 | 2019-07-08 | 0 | 2019-07-08 | ? | 0 | 0005915249 | 20190708.ifs | 2019-07-08 | 2019-07-09 | |||||||
3677122 | 3677122 | DIVIDEND | ADD | 902641620 | 0 | 0 | 1 | 0 | .4048 | 00 | 2019-04-11 | 2019-04-12 | 2019-04-23 | 2019-04-05 | 0 | 2019-04-05 | ? | 0 | 0005868902 | 20190405.ifs | 2019-04-05 | 2019-04-06 | |||||||
3677127 | 3677127 | DIVIDEND | ADD | 902641620 | 0 | 0 | 1 | 0 | .4048 | 00 | 2019-04-11 | 2019-04-12 | 2019-04-23 | 2019-04-05 | 0 | 2019-04-05 | ? | 0 | 0005868902 | 20190405.ifs | 2019-04-05 | 2019-04-06 | |||||||
3541144 | 3541144 | DIVIDEND | ADD | 902641620 | 0 | 0 | 1 | 0 | .4064 | 00 | 2019-01-11 | 2019-01-14 | 2019-01-23 | 2019-01-04 | 0 | 2019-01-04 | ? | 0 | 0005824126 | 20190104.ifs | 2019-01-04 | 2019-01-05 | |||||||
3541151 | 3541151 | DIVIDEND | ADD | 902641620 | 0 | 0 | 1 | 0 | .4064 | 00 | 2019-01-11 | 2019-01-14 | 2019-01-23 | 2019-01-04 | 0 | 2019-01-04 | ? | 0 | 0005824126 | 20190104.ifs | 2019-01-04 | 2019-01-05 | |||||||
3324484 | 3324484 | DIVIDEND | ADD | 902641620 | 0 | 0 | 1 | 0 | .4034 | 00 | 2018-10-11 | 2018-10-12 | 2018-10-22 | 2018-10-05 | 0 | 2018-10-05 | ? | 0 | 0005739581 | 20181005.ifs | 2018-10-05 | 2018-10-06 | |||||||
3324547 | 3324547 | DIVIDEND | ADD | 902641620 | 0 | 0 | 1 | 0 | .4034 | 00 | 2018-10-11 | 2018-10-12 | 2018-10-22 | 2018-10-05 | 0 | 2018-10-05 | ? | 0 | 0005739581 | 20181005.ifs | 2018-10-05 | 2018-10-06 | |||||||
3185323 | 3185323 | DIVIDEND | ADD | 902641620 | 0 | 0 | 1 | 0 | .3736 | 00 | 2018-07-13 | 2018-07-16 | 2018-07-24 | 2018-07-06 | 0 | 2018-07-06 | ? | 0 | 0005691930 | 20180706.ifs | 2018-07-06 | 2018-07-07 | |||||||
3185326 | 3185326 | DIVIDEND | ADD | 902641620 | 0 | 0 | 1 | 0 | .3736 | 00 | 2018-07-13 | 2018-07-16 | 2018-07-24 | 2018-07-06 | 0 | 2018-07-06 | ? | 0 | 0005691930 | 20180706.ifs | 2018-07-06 | 2018-07-07 | |||||||
3030970 | 3030970 | DIVIDEND | ADD | 902641620 | 0 | 0 | 1 | 0 | .3847 | 00 | 2018-04-12 | 2018-04-13 | 2018-04-23 | 2018-04-06 | 0 | 2018-04-06 | ? | 0 | 0005645641 | 20180406.ifs | 2018-04-06 | 2018-04-07 | |||||||
3030971 | 3030971 | DIVIDEND | ADD | 902641620 | 0 | 0 | 1 | 0 | .3847 | 00 | 2018-04-12 | 2018-04-13 | 2018-04-23 | 2018-04-06 | 0 | 2018-04-06 | ? | 0 | 0005645641 | 20180406.ifs | 2018-04-06 | 2018-04-07 | |||||||
2912792 | 2912792 | DIVIDEND | ADD | 902641620 | 0 | 0 | 1 | 0 | .354 | 00 | 2018-01-12 | 2018-01-16 | 2018-01-24 | 2018-01-05 | 0 | 2018-01-05 | ? | 0 | 0005600717 | 20180105.ifs | 2018-01-05 | 2018-01-06 | |||||||
2912795 | 2912795 | DIVIDEND | ADD | 902641620 | 0 | 0 | 1 | 0 | .354 | 00 | 2018-01-12 | 2018-01-16 | 2018-01-24 | 2018-01-05 | 0 | 2018-01-05 | ? | 0 | 0005600717 | 20180105.ifs | 2018-01-05 | 2018-01-06 | |||||||
2717925 | 2717925 | DIVIDEND | ADD | 902641620 | 0 | 0 | 1 | 0 | .3588 | 00 | 2017-10-12 | 2017-10-13 | 2017-10-23 | 2017-10-06 | 0 | 2017-10-06 | ? | 0 | 0005513316 | 20171006.ifs | 2017-10-06 | 2017-10-07 | |||||||
2718077 | 2718077 | DIVIDEND | ADD | 902641620 | 0 | 0 | 1 | 0 | .3588 | 00 | 2017-10-12 | 2017-10-13 | 2017-10-23 | 2017-10-06 | 0 | 2017-10-06 | ? | 0 | 0005513316 | 20171006.ifs | 2017-10-06 | 2017-10-07 | |||||||
2616519 | 2616519 | DIVIDEND | ADD | 902641620 | 0 | 0 | 1 | 0 | .3471 | 00 | 2017-07-12 | 2017-07-14 | 2017-07-24 | 2017-07-06 | 0 | 2017-07-06 | ? | 0 | 0005466407 | 20170706.ifs | 2017-07-06 | 2017-07-07 | |||||||
2537121 | 2537121 | DIVIDEND | ADD | 902641620 | 0 | 0 | 1 | 0 | .3564 | 00 | 2017-04-10 | 2017-04-12 | 2017-04-21 | 2017-04-05 | 0 | 2017-04-05 | ? | 0 | 0005419131 | 20170405.ifs | 2017-04-05 | 2017-04-06 | |||||||
2446550 | 2446550 | EQUITY | CHANGE | 902641620 | E TRACS LKD ALERIAN NATURAL GAS INDEX | 0 | A | 2010-07-14 | ? | 0 | no | no | no | 2010-07-14 | 2010-07-14 | ? | 20170123.ifs | 2017-01-23 | 2017-01-24 | ||||||||||
2446551 | 2446550 | EQUITY | CHANGE | 902641620 | E TRACS LKD ALERIAN NATURAL GAS INDEX | 0 | A | 2010-07-14 | ? | 4 | no | no | no | 2010-07-14 | 2010-07-14 | ? | 20170123.ifs | 2017-01-23 | 2017-01-24 | ||||||||||
2424950 | 2424950 | EQUITY | CHANGE | 902641620 | E TRACS LKD ALERIAN NATURAL GAS INDEX | 0 | 0 | 2010-07-14 | ? | 0 | no | no | no | 2010-07-14 | 2010-07-14 | ? | 20170112.ifs | 2017-01-12 | 2017-01-13 | ||||||||||
2424951 | 2424950 | EQUITY | CHANGE | 902641620 | E TRACS LKD ALERIAN NATURAL GAS INDEX | 0 | A | 2010-07-14 | ? | 0 | no | no | no | 2010-07-14 | 2010-07-14 | ? | 20170112.ifs | 2017-01-12 | 2017-01-13 | ||||||||||
2420514 | 2420514 | DIVIDEND | ADD | 902641620 | 0 | 0 | 1 | 0 | .3675 | 00 | 2017-01-11 | 2017-01-13 | 2017-01-24 | 2017-01-06 | 0 | 2017-01-06 | ? | 0 | 0005373195 | 20170106.ifs | 2017-01-06 | 2017-01-07 | |||||||
2316889 | 2316889 | DIVIDEND | ADD | 902641620 | 0 | 0 | 1 | 0 | .3691 | 00 | 2016-10-11 | 2016-10-13 | 2016-10-21 | 2016-10-05 | 0 | 2016-10-05 | ? | 0 | 0005296460 | 20161005.ifs | 2016-10-05 | 2016-10-06 | |||||||
2246658 | 2246658 | DIVIDEND | ADD | 902641620 | 0 | 0 | 1 | 0 | .3505 | 00 | 2016-07-12 | 2016-07-14 | 2016-07-22 | 2016-07-06 | 0 | 2016-07-06 | ? | 0 | 0005249917 | 20160706.ifs | 2016-07-06 | 2016-07-07 | |||||||
2158411 | 2158411 | DIVIDEND | ADD | 902641620 | 0 | 0 | 1 | 0 | .5075 | 00 | 2016-04-08 | 2016-04-12 | 2016-04-20 | 2016-04-05 | 0 | 2016-04-05 | ? | 0 | 0005203608 | 20160405.ifs | 2016-04-05 | 2016-04-06 | |||||||
2088569 | 2088569 | DIVIDEND | ADD | 902641620 | 0 | 0 | 1 | 0 | .466 | 00 | 2016-01-11 | 2016-01-13 | 2016-01-22 | 2016-01-06 | 0 | 2016-01-06 | ? | 0 | 0005158143 | 20160106.ifs | 2016-01-06 | 2016-01-07 | |||||||
1987046 | 1987046 | DIVIDEND | ADD | 902641620 | 0 | 0 | 1 | 0 | .4412 | 00 | 2015-10-08 | 2015-10-13 | 2015-10-21 | 2015-10-06 | 0 | 2015-10-06 | ? | 0 | 0005078417 | 20151006.ifs | 2015-10-06 | 2015-10-07 | |||||||
1834352 | 1834352 | DIVIDEND | ADD | 902641620 | 0 | 0 | 1 | 0 | .4735 | 00 | 2015-04-09 | 2015-04-13 | 2015-04-21 | 2015-04-02 | 0 | 2015-04-02 | ? | 0 | 0004983958 | 20150402.ifs | 2015-04-02 | 2015-04-03 | |||||||
1765343 | 1765343 | DIVIDEND | ADD | 902641620 | 0 | 0 | 1 | 0 | .471 | 00 | 2015-01-09 | 2015-01-13 | 2015-01-22 | 2015-01-06 | 0 | 2015-01-06 | ? | 0 | 0004940242 | 20150106.ifs | 2015-01-06 | 2015-01-07 | |||||||
1654069 | 1654069 | DIVIDEND | ADD | 902641620 | 0 | 0 | 1 | 0 | .4474 | 00 | 2014-10-08 | 2014-10-13 | 2014-10-21 | 2014-10-07 | 0 | 2014-10-07 | ? | 0 | 0004858624 | 20141007.ifs | 2014-10-07 | 2014-10-08 | |||||||
1576531 | 1576531 | DIVIDEND | ADD | 902641620 | 0 | 0 | 1 | 0 | .4326 | 00 | 2014-07-10 | 2014-07-14 | 2014-07-22 | 2014-07-08 | 0 | 2014-07-08 | ? | 0 | 0004813907 | 20140708.ifs | 2014-07-08 | 2014-07-09 | |||||||
1489666 | 1489666 | DIVIDEND | ADD | 902641620 | 0 | 0 | 1 | 0 | .4398 | 00 | 2014-04-09 | 2014-04-11 | 2014-04-22 | 2014-04-02 | 0 | 2014-04-02 | ? | 0 | 0004765440 | 20140402.ifs | 2014-04-02 | 2014-04-03 | |||||||
1417441 | 1417441 | DIVIDEND | ADD | 902641620 | 0 | 0 | 1 | 0 | .4523 | 00 | 2014-01-09 | 2014-01-13 | 2014-01-22 | 2014-01-06 | 0 | 2014-01-06 | ? | 0 | 0004721415 | 20140106.ifs | 2014-01-06 | 2014-01-07 | |||||||
1309637 | 1309637 | DIVIDEND | DELETE | 902641620 | 0 | 0 | 1 | 0 | .4596 | 00 | 2013-10-09 | 2013-10-11 | 2013-10-12 | 2013-10-01 | 0 | 2013-10-01 | ? | 0 | 0004642041 | 20131002.ifs | 2013-10-02 | 2013-10-03 | |||||||
1309638 | 1309638 | DIVIDEND | ADD | 902641620 | 0 | 0 | 1 | 0 | .4596 | 00 | 2013-10-09 | 2013-10-11 | 2013-10-21 | 2013-10-01 | 1 | 2013-10-01 | 2013-10-02 | 0 | 0004642041 | 20131002.ifs | 2013-10-02 | 2013-10-03 | |||||||
1305953 | 1305953 | DIVIDEND | ADD | 902641620 | 0 | 0 | 1 | 0 | .4596 | 00 | 2013-10-09 | 2013-10-11 | 2013-10-12 | 2013-10-01 | 0 | 2013-10-01 | ? | 0 | 0004642041 | 20131001.ifs | 2013-10-01 | 2013-10-02 | |||||||
1232690 | 1232690 | DIVIDEND | ADD | 902641620 | 0 | 0 | 1 | 0 | .4407 | 00 | 2013-07-11 | 2013-07-15 | 2013-07-23 | 2013-07-02 | 0 | 2013-07-02 | ? | 0 | 0004598440 | 20130702.ifs | 2013-07-02 | 2013-07-03 | |||||||
1148499 | 1148499 | DIVIDEND | ADD | 902641620 | 0 | 0 | 1 | 0 | .4368 | 00 | 2013-04-10 | 2013-04-12 | 2013-04-22 | 2013-04-01 | 0 | 2013-04-01 | ? | 0 | 0004552264 | 20130401.ifs | 2013-04-01 | 2013-04-02 | |||||||
1081057 | 1081057 | DIVIDEND | ADD | 902641620 | 0 | 0 | 1 | 0 | .4433 | 00 | 2013-01-10 | 2013-01-14 | 2013-01-23 | 2012-01-03 | 0 | 2012-01-03 | ? | 0 | 0004510859 | 20130104.ifs | 2013-01-04 | 2013-01-05 | |||||||
1081650 | 1081650 | DIVIDEND | ADD | 902641620 | 0 | 0 | 1 | 0 | .4433 | 00 | 2013-01-10 | 2013-01-14 | 2013-01-23 | 2013-01-03 | 0 | 2013-01-03 | ? | 0 | 0004510859 | 20130104.ifs | 2013-01-04 | 2013-01-05 | |||||||
1083301 | 1083301 | DIVIDEND | DELETE | 902641620 | 0 | 0 | 1 | 0 | .4433 | 00 | 2013-01-10 | 2013-01-14 | 2013-01-23 | 2012-01-03 | 0 | 2012-01-03 | ? | 0 | 0004510859 | 20130104.ifs | 2013-01-04 | 2013-01-05 | |||||||
979351 | 979351 | DIVIDEND | ADD | 902641620 | 0 | 0 | 1 | 0 | .4287 | 00 | 2012-10-10 | 2012-10-12 | 2012-10-22 | 2012-10-03 | 0 | 2012-10-03 | ? | 0 | 0004443127 | 20121003.ifs | 2012-10-03 | 2012-10-04 | |||||||
909127 | 909127 | DIVIDEND | ADD | 902641620 | 0 | 0 | 1 | 0 | .4487 | 00 | 2012-07-12 | 2012-07-16 | 2012-07-24 | 2012-07-06 | 0 | 2012-07-06 | ? | 0 | 0004401507 | 20120706.ifs | 2012-07-06 | 2012-07-07 | |||||||
832231 | 832231 | DIVIDEND | ADD | 902641620 | 0 | 0 | 1 | 0 | .4366 | 00 | 2012-04-11 | 2012-04-13 | 2012-04-23 | 2012-04-09 | 0 | 2012-04-09 | ? | 0 | 0004360430 | 20120409.ifs | 2012-04-09 | 2012-04-10 | |||||||
749796 | 749796 | DIVIDEND | ADD | 902641620 | 0 | 0 | 1 | 0 | .4202 | 00 | 2012-01-11 | 2012-01-13 | 2012-01-24 | 2012-01-04 | 0 | 2012-01-04 | ? | 0 | 0004317133 | 20120104.ifs | 2012-01-04 | 2012-01-05 | |||||||
669703 | 669703 | DIVIDEND | ADD | 902641620 | 0 | 0 | 1 | 0 | .3961 | 00 | 2011-10-11 | 2011-10-13 | 2011-10-21 | 2011-10-07 | 0 | 2011-10-07 | ? | 0 | 0004256375 | 20111007.ifs | 2011-10-07 | 2011-10-08 | |||||||
578537 | 578537 | DIVIDEND | ADD | 902641620 | 0 | 0 | 1 | 0 | .3741 | 00 | 2011-07-12 | 2011-07-14 | 2011-07-22 | 2011-07-01 | 0 | 2011-07-01 | ? | 0 | 0004212226 | 20110701.ifs | 2011-07-01 | 2011-07-02 | |||||||
494423 | 494423 | DIVIDEND | ADD | 902641620 | 0 | 0 | 1 | 0 | .3672 | 00 | 2011-04-08 | 2011-04-12 | 2011-04-20 | 2011-04-04 | 0 | 2011-04-04 | ? | 0 | 0004172668 | 20110404.ifs | 2011-04-04 | 2011-04-05 | |||||||
407952 | 407952 | DIVIDEND | ADD | 902641620 | 0 | 0 | 1 | 0 | .3648 | 00 | 2011-01-10 | 2011-01-12 | 2011-01-21 | 2011-01-03 | 0 | 2011-01-03 | ? | 0 | 0004129649 | 20110103.ifs | 2011-01-03 | 2011-01-04 | |||||||
327931 | 327931 | DIVIDEND | ADD | 902641620 | 0 | 0 | 1 | 4 | .3568 | 00 | 2010-10-08 | 2010-10-13 | 2010-10-21 | 2010-10-04 | 0 | 2010-10-04 | ? | 0 | 0004072946 | 20101004.ifs | 2010-10-04 | 2010-10-05 | |||||||
249368 | 249368 | EQUITY | ADD | 902641620 | E TRACS LKD ALERIAN NATURAL GAS INDEX | N | 1 | 2010-07-14 | ? | 0 | no | no | no | 2010-07-14 | ? | ? | 20100714.ifs | 2010-07-14 | 2010-07-15 | ||||||||||
249369 | 249369 | EXCHANGE | ADD | 902641620 | 04 | 2010-07-14 | 2010-07-14 | MLPG | 0 | 0 | 2010-07-14 | ? | 20100714.ifs | 2010-07-14 | 2010-07-15 | ||||||||||||||
249879 | 249879 | EQUITY | CHANGE | 902641620 | E TRACS LKD ALERIAN NATURAL GAS INDEX | N | 1 | 2010-07-14 | ? | 0 | no | no | no | 2010-07-14 | ? | ? | 20100714.ifs | 2010-07-14 | 2010-07-15 | ||||||||||
249880 | 249879 | EQUITY | CHANGE | 902641620 | E TRACS LKD ALERIAN NATURAL GAS INDEX | N | A | 2010-07-14 | ? | 0 | no | no | no | 2010-07-14 | 2010-07-14 | ? | 20100714.ifs | 2010-07-14 | 2010-07-15 | ||||||||||
250004 | 250004 | EQUITY | CHANGE | 902641620 | E TRACS LKD ALERIAN NATURAL GAS INDEX | N | A | 2010-07-14 | ? | 0 | no | no | no | 2010-07-14 | 2010-07-14 | ? | 20100714.ifs | 2010-07-14 | 2010-07-15 | ||||||||||
250005 | 250004 | EQUITY | CHANGE | 902641620 | E TRACS LKD ALERIAN NATURAL GAS INDEX | N | 0 | 2010-07-14 | ? | 0 | no | no | no | 2010-07-14 | 2010-07-14 | ? | 20100714.ifs | 2010-07-14 | 2010-07-15 | ||||||||||
250475 | 250475 | EQUITY | CHANGE | 902641620 | E TRACS LKD ALERIAN NATURAL GAS INDEX | N | 0 | 2010-07-14 | ? | 0 | no | no | no | 2010-07-14 | 2010-07-14 | ? | 20100714.ifs | 2010-07-14 | 2010-07-15 | ||||||||||
250476 | 250475 | EQUITY | CHANGE | 902641620 | E TRACS LKD ALERIAN NATURAL GAS INDEX | 0 | 0 | 2010-07-14 | ? | 0 | no | no | no | 2010-07-14 | 2010-07-14 | ? | 20100714.ifs | 2010-07-14 | 2010-07-15 |
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 = 159803
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