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:159637 |
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 | ||
4277969 | 4277969 | CORPACTION | ADD | 90267B765 | 04 | C | 2020-04-02 | ? | 20200402.ifs | 2020-04-02 | 2020-04-03 | ||||||||||||||||||
4277972 | 4277972 | EQUITY | CHANGE | 90267B765 | 2X LEVERAGED LONG EXCHANGE TRADED ACCESS SECS LKD WELLS | 0 | A | 2011-05-25 | ? | 4 | no | no | no | 2011-05-25 | ? | ? | 20200402.ifs | 2020-04-02 | 2020-04-03 | ||||||||||
4277974 | 4277973 | EQUITY | CHANGE | 90267B765 | 2X LEVERAGED LONG EXCHANGE TRADED ACCESS SECS LKD WELLS | C | A | 2011-05-25 | 2020-04-02 | 4 | no | no | no | 2011-05-25 | 2020-04-02 | ? | 20200402.ifs | 2020-04-02 | 2020-04-03 | ||||||||||
4278016 | 4278016 | CORPACTION | ADD | 90267B765 | 04 | C | 2020-04-02 | ? | 20200402.ifs | 2020-04-02 | 2020-04-03 | ||||||||||||||||||
4278018 | 4278018 | EQUITY | CHANGE | 90267B765 | 2X LEVERAGED LONG EXCHANGE TRADED ACCESS SECS LKD WELLS | 0 | A | 2011-05-25 | ? | 4 | no | no | no | 2011-05-25 | ? | ? | 20200402.ifs | 2020-04-02 | 2020-04-03 | ||||||||||
4278020 | 4278019 | EQUITY | CHANGE | 90267B765 | 2X LEVERAGED LONG EXCHANGE TRADED ACCESS SECS LKD WELLS | C | A | 2011-05-25 | 2020-04-02 | 4 | no | no | no | 2011-05-25 | 2020-04-02 | ? | 20200402.ifs | 2020-04-02 | 2020-04-03 | ||||||||||
4165791 | 4165791 | DIVIDEND | ADD | 90267B765 | 0 | 0 | 1 | 0 | .5912 | 00 | 2020-01-10 | 2020-01-13 | 2020-01-22 | 2020-01-07 | 0 | 2020-01-08 | ? | 0 | 0006041857 | 20200108.ifs | 2020-01-08 | 2020-01-09 | |||||||
4165794 | 4165794 | DIVIDEND | ADD | 90267B765 | 0 | 0 | 1 | 0 | .5912 | 00 | 2020-01-10 | 2020-01-13 | 2020-01-22 | 2020-01-07 | 0 | 2020-01-08 | ? | 0 | 0006041857 | 20200108.ifs | 2020-01-08 | 2020-01-09 | |||||||
3965987 | 3965987 | DIVIDEND | ADD | 90267B765 | 0 | 0 | 1 | 0 | .5448 | 00 | 2019-10-10 | 2019-10-11 | 2019-10-21 | 2019-10-04 | 0 | 2019-10-04 | ? | 0 | 0005960778 | 20191004.ifs | 2019-10-04 | 2019-10-05 | |||||||
3966041 | 3966041 | DIVIDEND | ADD | 90267B765 | 0 | 0 | 1 | 0 | .5448 | 00 | 2019-10-10 | 2019-10-11 | 2019-10-21 | 2019-10-04 | 0 | 2019-10-04 | ? | 0 | 0005960778 | 20191004.ifs | 2019-10-04 | 2019-10-05 | |||||||
3829902 | 3829902 | DIVIDEND | ADD | 90267B765 | 0 | 0 | 1 | 0 | .5494 | 00 | 2019-07-12 | 2019-07-15 | 2019-07-23 | 2019-07-08 | 0 | 2019-07-08 | ? | 0 | 0005915260 | 20190708.ifs | 2019-07-08 | 2019-07-09 | |||||||
3829928 | 3829928 | DIVIDEND | ADD | 90267B765 | 0 | 0 | 1 | 0 | .5494 | 00 | 2019-07-12 | 2019-07-15 | 2019-07-23 | 2019-07-08 | 0 | 2019-07-08 | ? | 0 | 0005915260 | 20190708.ifs | 2019-07-08 | 2019-07-09 | |||||||
3677118 | 3677118 | DIVIDEND | ADD | 90267B765 | 0 | 0 | 1 | 0 | .5388 | 00 | 2019-04-11 | 2019-04-12 | 2019-04-23 | 2019-04-05 | 0 | 2019-04-05 | ? | 0 | 0005868904 | 20190405.ifs | 2019-04-05 | 2019-04-06 | |||||||
3677123 | 3677123 | DIVIDEND | ADD | 90267B765 | 0 | 0 | 1 | 0 | .5388 | 00 | 2019-04-11 | 2019-04-12 | 2019-04-23 | 2019-04-05 | 0 | 2019-04-05 | ? | 0 | 0005868904 | 20190405.ifs | 2019-04-05 | 2019-04-06 | |||||||
3541140 | 3541140 | DIVIDEND | ADD | 90267B765 | 0 | 0 | 1 | 0 | .595 | 00 | 2019-01-11 | 2019-01-14 | 2019-01-23 | 2019-01-04 | 0 | 2019-01-04 | ? | 0 | 0005824114 | 20190104.ifs | 2019-01-04 | 2019-01-05 | |||||||
3541147 | 3541147 | DIVIDEND | ADD | 90267B765 | 0 | 0 | 1 | 0 | .595 | 00 | 2019-01-11 | 2019-01-14 | 2019-01-23 | 2019-01-04 | 0 | 2019-01-04 | ? | 0 | 0005824114 | 20190104.ifs | 2019-01-04 | 2019-01-05 | |||||||
3324480 | 3324480 | DIVIDEND | ADD | 90267B765 | 0 | 0 | 1 | 0 | .5942 | 00 | 2018-10-11 | 2018-10-12 | 2018-10-22 | 2018-10-05 | 0 | 2018-10-05 | ? | 0 | 0005739570 | 20181005.ifs | 2018-10-05 | 2018-10-06 | |||||||
3324543 | 3324543 | DIVIDEND | ADD | 90267B765 | 0 | 0 | 1 | 0 | .5942 | 00 | 2018-10-11 | 2018-10-12 | 2018-10-22 | 2018-10-05 | 0 | 2018-10-05 | ? | 0 | 0005739570 | 20181005.ifs | 2018-10-05 | 2018-10-06 | |||||||
3185319 | 3185319 | DIVIDEND | ADD | 90267B765 | 0 | 0 | 1 | 0 | .591 | 00 | 2018-07-13 | 2018-07-16 | 2018-07-24 | 2018-07-06 | 0 | 2018-07-06 | ? | 0 | 0005691932 | 20180706.ifs | 2018-07-06 | 2018-07-07 | |||||||
3185322 | 3185322 | DIVIDEND | ADD | 90267B765 | 0 | 0 | 1 | 0 | .591 | 00 | 2018-07-13 | 2018-07-16 | 2018-07-24 | 2018-07-06 | 0 | 2018-07-06 | ? | 0 | 0005691932 | 20180706.ifs | 2018-07-06 | 2018-07-07 | |||||||
3030966 | 3030966 | DIVIDEND | ADD | 90267B765 | 0 | 0 | 1 | 0 | .5624 | 00 | 2018-04-12 | 2018-04-13 | 2018-04-23 | 2018-04-06 | 0 | 2018-04-06 | ? | 0 | 0005645643 | 20180406.ifs | 2018-04-06 | 2018-04-07 | |||||||
3030967 | 3030967 | DIVIDEND | ADD | 90267B765 | 0 | 0 | 1 | 0 | .5624 | 00 | 2018-04-12 | 2018-04-13 | 2018-04-23 | 2018-04-06 | 0 | 2018-04-06 | ? | 0 | 0005645643 | 20180406.ifs | 2018-04-06 | 2018-04-07 | |||||||
2912788 | 2912788 | DIVIDEND | ADD | 90267B765 | 0 | 0 | 1 | 0 | .6802 | 00 | 2018-01-12 | 2018-01-16 | 2018-01-24 | 2018-01-05 | 0 | 2018-01-05 | ? | 0 | 0005600751 | 20180105.ifs | 2018-01-05 | 2018-01-06 | |||||||
2912791 | 2912791 | DIVIDEND | ADD | 90267B765 | 0 | 0 | 1 | 0 | .6802 | 00 | 2018-01-12 | 2018-01-16 | 2018-01-24 | 2018-01-05 | 0 | 2018-01-05 | ? | 0 | 0005600751 | 20180105.ifs | 2018-01-05 | 2018-01-06 | |||||||
2717920 | 2717920 | DIVIDEND | ADD | 90267B765 | 0 | 0 | 1 | 0 | .7127 | 00 | 2017-10-12 | 2017-10-13 | 2017-10-23 | 2017-10-06 | 0 | 2017-10-06 | ? | 0 | 0005513318 | 20171006.ifs | 2017-10-06 | 2017-10-07 | |||||||
2718072 | 2718072 | DIVIDEND | ADD | 90267B765 | 0 | 0 | 1 | 0 | .7127 | 00 | 2017-10-12 | 2017-10-13 | 2017-10-23 | 2017-10-06 | 0 | 2017-10-06 | ? | 0 | 0005513318 | 20171006.ifs | 2017-10-06 | 2017-10-07 | |||||||
2616517 | 2616517 | DIVIDEND | ADD | 90267B765 | 0 | 0 | 1 | 0 | .8137 | 00 | 2017-07-12 | 2017-07-14 | 2017-07-24 | 2017-07-06 | 0 | 2017-07-06 | ? | 0 | 0005466409 | 20170706.ifs | 2017-07-06 | 2017-07-07 | |||||||
2537119 | 2537119 | DIVIDEND | ADD | 90267B765 | 0 | 0 | 1 | 0 | .7728 | 00 | 2017-04-10 | 2017-04-12 | 2017-04-21 | 2017-04-05 | 0 | 2017-04-05 | ? | 0 | 0005419133 | 20170405.ifs | 2017-04-05 | 2017-04-06 | |||||||
2446556 | 2446556 | EQUITY | CHANGE | 90267B765 | 2X LEVERAGED LONG EXCHANGE TRADED ACCESS SECS LKD WELLS | 0 | A | 2011-05-25 | ? | 0 | no | no | no | 2011-05-25 | ? | ? | 20170123.ifs | 2017-01-23 | 2017-01-24 | ||||||||||
2446557 | 2446556 | EQUITY | CHANGE | 90267B765 | 2X LEVERAGED LONG EXCHANGE TRADED ACCESS SECS LKD WELLS | 0 | A | 2011-05-25 | ? | 4 | no | no | no | 2011-05-25 | ? | ? | 20170123.ifs | 2017-01-23 | 2017-01-24 | ||||||||||
2424958 | 2424958 | EQUITY | CHANGE | 90267B765 | 2X LEVERAGED LONG EXCHANGE TRADED ACCESS SECS LKD WELLS | 0 | 1 | 2011-05-25 | ? | 0 | no | no | no | 2011-05-25 | ? | ? | 20170112.ifs | 2017-01-12 | 2017-01-13 | ||||||||||
2424959 | 2424958 | EQUITY | CHANGE | 90267B765 | 2X LEVERAGED LONG EXCHANGE TRADED ACCESS SECS LKD WELLS | 0 | A | 2011-05-25 | ? | 0 | no | no | no | 2011-05-25 | ? | ? | 20170112.ifs | 2017-01-12 | 2017-01-13 | ||||||||||
2420512 | 2420512 | DIVIDEND | ADD | 90267B765 | 0 | 0 | 1 | 0 | .7393 | 00 | 2017-01-11 | 2017-01-13 | 2017-01-24 | 2017-01-06 | 0 | 2017-01-06 | ? | 0 | 0005373197 | 20170106.ifs | 2017-01-06 | 2017-01-07 | |||||||
2316887 | 2316887 | DIVIDEND | ADD | 90267B765 | 0 | 0 | 1 | 0 | .7331 | 00 | 2016-10-11 | 2016-10-13 | 2016-10-21 | 2016-10-05 | 0 | 2016-10-05 | ? | 0 | 0005296464 | 20161005.ifs | 2016-10-05 | 2016-10-06 | |||||||
2246655 | 2246655 | DIVIDEND | ADD | 90267B765 | 0 | 0 | 1 | 0 | .71 | 00 | 2016-07-12 | 2016-07-14 | 2016-07-22 | 2016-07-06 | 0 | 2016-07-06 | ? | 0 | 0005249921 | 20160706.ifs | 2016-07-06 | 2016-07-07 | |||||||
2158408 | 2158408 | DIVIDEND | ADD | 90267B765 | 0 | 0 | 1 | 0 | .6706 | 00 | 2016-04-08 | 2016-04-12 | 2016-04-20 | 2016-04-05 | 0 | 2016-04-05 | ? | 0 | 0005203611 | 20160405.ifs | 2016-04-05 | 2016-04-06 | |||||||
2088565 | 2088565 | DIVIDEND | ADD | 90267B765 | 0 | 0 | 1 | 0 | .7764 | 00 | 2016-01-11 | 2016-01-13 | 2016-01-22 | 2016-01-06 | 0 | 2016-01-06 | ? | 0 | 0005158147 | 20160106.ifs | 2016-01-06 | 2016-01-07 | |||||||
1987042 | 1987042 | DIVIDEND | ADD | 90267B765 | 0 | 0 | 1 | 0 | .7782 | 00 | 2015-10-08 | 2015-10-13 | 2015-10-21 | 2015-10-06 | 0 | 2015-10-06 | ? | 0 | 0005078422 | 20151006.ifs | 2015-10-06 | 2015-10-07 | |||||||
1834348 | 1834348 | DIVIDEND | ADD | 90267B765 | 0 | 0 | 1 | 0 | .8265 | 00 | 2015-04-09 | 2015-04-13 | 2015-04-21 | 2015-04-02 | 0 | 2015-04-02 | ? | 0 | 0004983892 | 20150402.ifs | 2015-04-02 | 2015-04-03 | |||||||
1765339 | 1765339 | DIVIDEND | ADD | 90267B765 | 0 | 0 | 1 | 0 | .9648 | 00 | 2015-01-09 | 2015-01-13 | 2015-01-22 | 2015-01-06 | 0 | 2015-01-06 | ? | 0 | 0004940246 | 20150106.ifs | 2015-01-06 | 2015-01-07 | |||||||
1654065 | 1654065 | DIVIDEND | ADD | 90267B765 | 0 | 0 | 1 | 0 | 1.0148 | 00 | 2014-10-08 | 2014-10-13 | 2014-10-21 | 2014-10-07 | 0 | 2014-10-07 | ? | 0 | 0004858612 | 20141007.ifs | 2014-10-07 | 2014-10-08 | |||||||
1576527 | 1576527 | DIVIDEND | ADD | 90267B765 | 0 | 0 | 1 | 0 | .9955 | 00 | 2014-07-10 | 2014-07-14 | 2014-07-22 | 2014-07-08 | 0 | 2014-07-08 | ? | 0 | 0004813910 | 20140708.ifs | 2014-07-08 | 2014-07-09 | |||||||
1489662 | 1489662 | DIVIDEND | ADD | 90267B765 | 0 | 0 | 1 | 0 | 1.0509 | 00 | 2014-04-09 | 2014-04-11 | 2014-04-22 | 2014-04-02 | 0 | 2014-04-02 | ? | 0 | 0004765435 | 20140402.ifs | 2014-04-02 | 2014-04-03 | |||||||
1417437 | 1417437 | DIVIDEND | ADD | 90267B765 | 0 | 0 | 1 | 0 | 1.0761 | 00 | 2014-01-09 | 2014-01-13 | 2014-01-22 | 2014-01-06 | 0 | 2014-01-06 | ? | 0 | 0004721408 | 20140106.ifs | 2014-01-06 | 2014-01-07 | |||||||
1309629 | 1309629 | DIVIDEND | DELETE | 90267B765 | 0 | 0 | 1 | 0 | 1.0022 | 00 | 2013-10-09 | 2013-10-11 | 2013-10-12 | 2013-10-01 | 0 | 2013-10-01 | ? | 0 | 0004642024 | 20131002.ifs | 2013-10-02 | 2013-10-03 | |||||||
1309630 | 1309630 | DIVIDEND | ADD | 90267B765 | 0 | 0 | 1 | 0 | 1.0022 | 00 | 2013-10-09 | 2013-10-11 | 2013-10-21 | 2013-10-01 | 1 | 2013-10-01 | 2013-10-02 | 0 | 0004642024 | 20131002.ifs | 2013-10-02 | 2013-10-03 | |||||||
1305949 | 1305949 | DIVIDEND | ADD | 90267B765 | 0 | 0 | 1 | 0 | 1.0022 | 00 | 2013-10-09 | 2013-10-11 | 2013-10-12 | 2013-10-01 | 0 | 2013-10-01 | ? | 0 | 0004642024 | 20131001.ifs | 2013-10-01 | 2013-10-02 | |||||||
1232686 | 1232686 | DIVIDEND | ADD | 90267B765 | 0 | 0 | 1 | 0 | 1.0485 | 00 | 2013-07-11 | 2013-07-15 | 2013-07-23 | 2013-07-02 | 0 | 2013-07-02 | ? | 0 | 0004598428 | 20130702.ifs | 2013-07-02 | 2013-07-03 | |||||||
1148495 | 1148495 | DIVIDEND | ADD | 90267B765 | 0 | 0 | 1 | 0 | 1.0293 | 00 | 2013-04-10 | 2013-04-12 | 2013-04-22 | 2013-04-01 | 0 | 2013-04-01 | ? | 0 | 0004552261 | 20130401.ifs | 2013-04-01 | 2013-04-02 | |||||||
1081053 | 1081053 | DIVIDEND | ADD | 90267B765 | 0 | 0 | 1 | 0 | .9859 | 00 | 2013-01-10 | 2013-01-14 | 2013-01-23 | 2012-01-03 | 0 | 2012-01-03 | ? | 0 | 0004510855 | 20130104.ifs | 2013-01-04 | 2013-01-05 | |||||||
1081646 | 1081646 | DIVIDEND | ADD | 90267B765 | 0 | 0 | 1 | 0 | .9859 | 00 | 2013-01-10 | 2013-01-14 | 2013-01-23 | 2013-01-03 | 0 | 2013-01-03 | ? | 0 | 0004510855 | 20130104.ifs | 2013-01-04 | 2013-01-05 | |||||||
1083305 | 1083305 | DIVIDEND | DELETE | 90267B765 | 0 | 0 | 1 | 0 | .9859 | 00 | 2013-01-10 | 2013-01-14 | 2013-01-23 | 2012-01-03 | 0 | 2012-01-03 | ? | 0 | 0004510855 | 20130104.ifs | 2013-01-04 | 2013-01-05 | |||||||
979347 | 979347 | DIVIDEND | ADD | 90267B765 | 0 | 0 | 1 | 0 | .9169 | 00 | 2012-10-10 | 2012-10-12 | 2012-10-22 | 2012-10-03 | 0 | 2012-10-03 | ? | 0 | 0004443124 | 20121003.ifs | 2012-10-03 | 2012-10-04 | |||||||
909123 | 909123 | DIVIDEND | ADD | 90267B765 | 0 | 0 | 1 | 0 | .8852 | 00 | 2012-07-12 | 2012-07-16 | 2012-07-24 | 2012-07-06 | 0 | 2012-07-06 | ? | 0 | 0004401510 | 20120706.ifs | 2012-07-06 | 2012-07-07 | |||||||
832227 | 832227 | DIVIDEND | ADD | 90267B765 | 0 | 0 | 1 | 0 | .7378 | 00 | 2012-04-11 | 2012-04-13 | 2012-04-23 | 2012-04-09 | 0 | 2012-04-09 | ? | 0 | 0004360427 | 20120409.ifs | 2012-04-09 | 2012-04-10 | |||||||
749792 | 749792 | DIVIDEND | ADD | 90267B765 | 0 | 0 | 1 | 0 | .8197 | 00 | 2012-01-11 | 2012-01-13 | 2012-01-24 | 2012-01-04 | 0 | 2012-01-04 | ? | 0 | 0004317131 | 20120104.ifs | 2012-01-04 | 2012-01-05 | |||||||
669699 | 669699 | DIVIDEND | ADD | 90267B765 | 0 | 0 | 1 | 0 | .8265 | 00 | 2011-10-11 | 2011-10-13 | 2011-10-21 | 2011-10-07 | 0 | 2011-10-07 | ? | 0 | 0004256379 | 20111007.ifs | 2011-10-07 | 2011-10-08 | |||||||
578533 | 578533 | DIVIDEND | ADD | 90267B765 | 0 | 0 | 1 | 4 | .7843 | 00 | 2011-07-12 | 2011-07-14 | 2011-07-22 | 2011-07-01 | 0 | 2011-07-01 | ? | 0 | 0004212230 | 20110701.ifs | 2011-07-01 | 2011-07-02 | |||||||
534285 | 534285 | EQUITY | ADD | 90267B765 | 2X LEVERAGED LONG EXCHANGE TRADED ACCESS SECS LKD WELLS | N | 1 | 2011-05-25 | ? | 0 | no | no | no | 2011-05-25 | ? | ? | 20110525.ifs | 2011-05-25 | 2011-05-26 | ||||||||||
534286 | 534286 | EXCHANGE | ADD | 90267B765 | 04 | 2011-05-25 | 2011-05-25 | BDCL | 0 | 1 | 2011-05-25 | ? | 20110525.ifs | 2011-05-25 | 2011-05-26 | ||||||||||||||
534786 | 534786 | EQUITY | CHANGE | 90267B765 | 2X LEVERAGED LONG EXCHANGE TRADED ACCESS SECS LKD WELLS | N | 1 | 2011-05-25 | ? | 0 | no | no | no | 2011-05-25 | ? | ? | 20110525.ifs | 2011-05-25 | 2011-05-26 | ||||||||||
534787 | 534786 | EQUITY | CHANGE | 90267B765 | 2X LEVERAGED LONG EXCHANGE TRADED ACCESS SECS LKD WELLS | 0 | 1 | 2011-05-25 | ? | 0 | no | no | no | 2011-05-25 | ? | ? | 20110525.ifs | 2011-05-25 | 2011-05-26 |
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 = 159637
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