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:159804 |
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 | ||
2424956 | 2424956 | EQUITY | CHANGE | 902664408 | E TRACS LKD WELLS FARGO MASTER LTD PARTNERSHIP INDEX | C | 0 | 2010-11-01 | 2016-08-16 | 0 | no | no | no | ? | 2016-08-16 | ? | 20170112.ifs | 2017-01-12 | 2017-01-13 | ||||||||||
2424957 | 2424956 | EQUITY | CHANGE | 902664408 | E TRACS LKD WELLS FARGO MASTER LTD PARTNERSHIP INDEX | C | A | 2010-11-01 | 2016-08-16 | 0 | no | no | no | ? | 2016-08-16 | ? | 20170112.ifs | 2017-01-12 | 2017-01-13 | ||||||||||
2302513 | 2302513 | DIVIDEND | DELETE | 902664408 | 0 | 0 | 1 | 6 | 0 | 08 | ? | ? | 2016-08-16 | 2016-07-26 | 0 | 2016-07-26 | ? | 0 | 0005254165 | 20160927.ifs | 2016-09-27 | 2016-09-28 | |||||||
2302514 | 2302514 | DIVIDEND | CHANGE | 902664408 | 0 | 0 | C | 0 | 0 | 12 | ? | ? | 2016-08-16 | 2016-07-26 | 0 | ? | 2016-08-16 | 0 | 20160927.ifs | 2016-09-27 | 2016-09-28 | ||||||||
2302515 | 2302514 | DIVIDEND | CHANGE | 902664408 | 0 | 0 | C | 0 | 23.5709 | 0 | 12 | ? | ? | 2016-08-16 | 2016-07-26 | 0 | ? | 2016-09-27 | 0 | 20160927.ifs | 2016-09-27 | 2016-09-28 | |||||||
2271417 | 2271417 | CORPACTION | ADD | 902664408 | 04 | C | 2016-08-16 | ? | 20160816.ifs | 2016-08-16 | 2016-08-17 | ||||||||||||||||||
2271418 | 2271418 | EQUITY | CHANGE | 902664408 | E TRACS LKD WELLS FARGO MASTER LTD PARTNERSHIP INDEX | 0 | 0 | 2010-11-01 | ? | 0 | no | no | no | ? | 2010-11-02 | ? | 20160816.ifs | 2016-08-16 | 2016-08-17 | ||||||||||
2271419 | 2271418 | EQUITY | CHANGE | 902664408 | E TRACS LKD WELLS FARGO MASTER LTD PARTNERSHIP INDEX | C | 0 | 2010-11-01 | 2016-08-16 | 0 | no | no | no | ? | 2016-08-16 | ? | 20160816.ifs | 2016-08-16 | 2016-08-17 | ||||||||||
2271530 | 2271530 | DIVIDEND | ADD | 902664408 | 0 | 0 | C | 0 | 0 | 12 | ? | ? | 2016-08-16 | 2016-07-26 | 0 | ? | 2016-08-16 | 0 | 20160816.ifs | 2016-08-16 | 2016-08-17 | ||||||||
2257050 | 2257050 | DIVIDEND | ADD | 902664408 | 0 | 0 | 1 | 6 | 0 | 08 | ? | ? | 2016-08-16 | 2016-07-26 | 0 | 2016-07-26 | ? | 0 | 0005254165 | 20160726.ifs | 2016-07-26 | 2016-07-27 | |||||||
2246656 | 2246656 | DIVIDEND | ADD | 902664408 | 0 | 0 | 1 | 0 | .3629 | 00 | 2016-07-12 | 2016-07-14 | 2016-07-22 | 2016-07-06 | 0 | 2016-07-06 | ? | 0 | 0005249918 | 20160706.ifs | 2016-07-06 | 2016-07-07 | |||||||
2158409 | 2158409 | DIVIDEND | ADD | 902664408 | 0 | 0 | 1 | 0 | .3989 | 00 | 2016-04-08 | 2016-04-12 | 2016-04-20 | 2016-04-05 | 0 | 2016-04-05 | ? | 0 | 0005203609 | 20160405.ifs | 2016-04-05 | 2016-04-06 | |||||||
2088566 | 2088566 | DIVIDEND | ADD | 902664408 | 0 | 0 | 1 | 0 | .4295 | 00 | 2016-01-11 | 2016-01-13 | 2016-01-22 | 2016-01-06 | 0 | 2016-01-06 | ? | 0 | 0005158144 | 20160106.ifs | 2016-01-06 | 2016-01-07 | |||||||
1987043 | 1987043 | DIVIDEND | ADD | 902664408 | 0 | 0 | 1 | 0 | .4628 | 00 | 2015-10-08 | 2015-10-13 | 2015-10-21 | 2015-10-06 | 0 | 2015-10-06 | ? | 0 | 0005078418 | 20151006.ifs | 2015-10-06 | 2015-10-07 | |||||||
1834349 | 1834349 | DIVIDEND | ADD | 902664408 | 0 | 0 | 1 | 0 | .3887 | 00 | 2015-04-09 | 2015-04-13 | 2015-04-21 | 2015-04-02 | 0 | 2015-04-02 | ? | 0 | 0004983890 | 20150402.ifs | 2015-04-02 | 2015-04-03 | |||||||
1765340 | 1765340 | DIVIDEND | ADD | 902664408 | 0 | 0 | 1 | 0 | .4152 | 00 | 2015-01-09 | 2015-01-13 | 2015-01-22 | 2015-01-06 | 0 | 2015-01-06 | ? | 0 | 0004940243 | 20150106.ifs | 2015-01-06 | 2015-01-07 | |||||||
1654066 | 1654066 | DIVIDEND | ADD | 902664408 | 0 | 0 | 1 | 0 | .3911 | 00 | 2014-10-08 | 2014-10-13 | 2014-10-21 | 2014-10-07 | 0 | 2014-10-07 | ? | 0 | 0004858628 | 20141007.ifs | 2014-10-07 | 2014-10-08 | |||||||
1576528 | 1576528 | DIVIDEND | ADD | 902664408 | 0 | 0 | 1 | 0 | .3868 | 00 | 2014-07-10 | 2014-07-14 | 2014-07-22 | 2014-07-08 | 0 | 2014-07-08 | ? | 0 | 0004813908 | 20140708.ifs | 2014-07-08 | 2014-07-09 | |||||||
1489663 | 1489663 | DIVIDEND | ADD | 902664408 | 0 | 0 | 1 | 0 | .3921 | 00 | 2014-04-09 | 2014-04-11 | 2014-04-22 | 2014-04-02 | 0 | 2014-04-02 | ? | 0 | 0004765443 | 20140402.ifs | 2014-04-02 | 2014-04-03 | |||||||
1417438 | 1417438 | DIVIDEND | ADD | 902664408 | 0 | 0 | 1 | 0 | .3909 | 00 | 2014-01-09 | 2014-01-13 | 2014-01-22 | 2014-01-06 | 0 | 2014-01-06 | ? | 0 | 0004721418 | 20140106.ifs | 2014-01-06 | 2014-01-07 | |||||||
1309631 | 1309631 | DIVIDEND | DELETE | 902664408 | 0 | 0 | 1 | 0 | .3948 | 00 | 2013-10-09 | 2013-10-11 | 2013-10-12 | 2013-10-01 | 0 | 2013-10-01 | ? | 0 | 0004642047 | 20131002.ifs | 2013-10-02 | 2013-10-03 | |||||||
1309632 | 1309632 | DIVIDEND | ADD | 902664408 | 0 | 0 | 1 | 0 | .3948 | 00 | 2013-10-09 | 2013-10-11 | 2013-10-21 | 2013-10-01 | 1 | 2013-10-01 | 2013-10-02 | 0 | 0004642047 | 20131002.ifs | 2013-10-02 | 2013-10-03 | |||||||
1305950 | 1305950 | DIVIDEND | ADD | 902664408 | 0 | 0 | 1 | 0 | .3948 | 00 | 2013-10-09 | 2013-10-11 | 2013-10-12 | 2013-10-01 | 0 | 2013-10-01 | ? | 0 | 0004642047 | 20131001.ifs | 2013-10-01 | 2013-10-02 | |||||||
1232687 | 1232687 | DIVIDEND | ADD | 902664408 | 0 | 0 | 1 | 0 | .3835 | 00 | 2013-07-11 | 2013-07-15 | 2013-07-23 | 2013-07-02 | 0 | 2013-07-02 | ? | 0 | 0004598450 | 20130702.ifs | 2013-07-02 | 2013-07-03 | |||||||
1148496 | 1148496 | DIVIDEND | ADD | 902664408 | 0 | 0 | 1 | 0 | .3713 | 00 | 2013-04-10 | 2013-04-12 | 2013-04-22 | 2013-04-01 | 0 | 2013-04-01 | ? | 0 | 0004552267 | 20130401.ifs | 2013-04-01 | 2013-04-02 | |||||||
1081054 | 1081054 | DIVIDEND | ADD | 902664408 | 0 | 0 | 1 | 0 | .3732 | 00 | 2013-01-10 | 2013-01-14 | 2013-01-23 | 2012-01-03 | 0 | 2012-01-03 | ? | 0 | 0004510864 | 20130104.ifs | 2013-01-04 | 2013-01-05 | |||||||
1081647 | 1081647 | DIVIDEND | ADD | 902664408 | 0 | 0 | 1 | 0 | .3732 | 00 | 2013-01-10 | 2013-01-14 | 2013-01-23 | 2013-01-03 | 0 | 2013-01-03 | ? | 0 | 0004510864 | 20130104.ifs | 2013-01-04 | 2013-01-05 | |||||||
1083304 | 1083304 | DIVIDEND | DELETE | 902664408 | 0 | 0 | 1 | 0 | .3732 | 00 | 2013-01-10 | 2013-01-14 | 2013-01-23 | 2012-01-03 | 0 | 2012-01-03 | ? | 0 | 0004510864 | 20130104.ifs | 2013-01-04 | 2013-01-05 | |||||||
979348 | 979348 | DIVIDEND | ADD | 902664408 | 0 | 0 | 1 | 0 | .3635 | 00 | 2012-10-10 | 2012-10-12 | 2012-10-22 | 2012-10-03 | 0 | 2012-10-03 | ? | 0 | 0004443131 | 20121003.ifs | 2012-10-03 | 2012-10-04 | |||||||
909124 | 909124 | DIVIDEND | ADD | 902664408 | 0 | 0 | 1 | 0 | .3535 | 00 | 2012-07-12 | 2012-07-16 | 2012-07-24 | 2012-07-06 | 0 | 2012-07-06 | ? | 0 | 0004401508 | 20120706.ifs | 2012-07-06 | 2012-07-07 | |||||||
832228 | 832228 | DIVIDEND | ADD | 902664408 | 0 | 0 | 1 | 0 | .3516 | 00 | 2012-04-11 | 2012-04-13 | 2012-04-23 | 2012-04-09 | 0 | 2012-04-09 | ? | 0 | 0004360433 | 20120409.ifs | 2012-04-09 | 2012-04-10 | |||||||
749793 | 749793 | DIVIDEND | ADD | 902664408 | 0 | 0 | 1 | 0 | .3457 | 00 | 2012-01-11 | 2012-01-13 | 2012-01-24 | 2012-01-04 | 0 | 2012-01-04 | ? | 0 | 0004317137 | 20120104.ifs | 2012-01-04 | 2012-01-05 | |||||||
669700 | 669700 | DIVIDEND | ADD | 902664408 | 0 | 0 | 1 | 0 | .3425 | 00 | 2011-10-11 | 2011-10-13 | 2011-10-21 | 2011-10-07 | 0 | 2011-10-07 | ? | 0 | 0004256378 | 20111007.ifs | 2011-10-07 | 2011-10-08 | |||||||
578534 | 578534 | DIVIDEND | ADD | 902664408 | 0 | 0 | 1 | 0 | .3278 | 00 | 2011-07-12 | 2011-07-14 | 2011-07-22 | 2011-07-01 | 0 | 2011-07-01 | ? | 0 | 0004212229 | 20110701.ifs | 2011-07-01 | 2011-07-02 | |||||||
494420 | 494420 | DIVIDEND | ADD | 902664408 | 0 | 0 | 1 | 0 | .3222 | 00 | 2011-04-08 | 2011-04-12 | 2011-04-20 | 2011-04-04 | 0 | 2011-04-04 | ? | 0 | 0004172675 | 20110404.ifs | 2011-04-04 | 2011-04-05 | |||||||
407949 | 407949 | DIVIDEND | ADD | 902664408 | 0 | 0 | 1 | 4 | .129 | 00 | 2011-01-10 | 2011-01-12 | 2011-01-21 | 2011-01-03 | 0 | 2011-01-03 | ? | 0 | 0004129654 | 20110103.ifs | 2011-01-03 | 2011-01-04 | |||||||
347572 | 347572 | EQUITY | ADD | 902664408 | NEW ISSUE | 0 | 0 | 2010-11-02 | ? | 0 | no | no | no | ? | ? | ? | 20101102.ifs | 2010-11-02 | 2010-11-03 | ||||||||||
347573 | 347573 | EQUITY | CHANGE | 902664408 | NEW ISSUE | 0 | 0 | 2010-11-02 | ? | 0 | no | no | no | ? | ? | ? | 20101102.ifs | 2010-11-02 | 2010-11-03 | ||||||||||
347574 | 347573 | EQUITY | CHANGE | 902664408 | E TRACS LKD WELLS FARGO MASTER LTD PARTNERSHIP INDEX | 0 | 0 | 2010-11-02 | ? | 0 | no | no | no | ? | 2010-11-02 | ? | 20101102.ifs | 2010-11-02 | 2010-11-03 | ||||||||||
347575 | 347575 | EXCHANGE | ADD | 902664408 | 04 | 2010-11-02 | 2010-11-02 | MLPW | 0 | 0 | ? | 2010-11-02 | 20101102.ifs | 2010-11-02 | 2010-11-03 | ||||||||||||||
347576 | 347576 | EXCHANGE | DELETE | 902664408 | 04 | 2010-11-02 | 2010-11-02 | MLPW | 0 | 0 | ? | 2010-11-02 | 20101102.ifs | 2010-11-02 | 2010-11-03 | ||||||||||||||
347577 | 347577 | EXCHANGE | ADD | 902664408 | 04 | 2010-11-01 | 2010-11-02 | MLPW | 0 | 0 | ? | 2010-11-02 | 20101102.ifs | 2010-11-02 | 2010-11-03 | ||||||||||||||
347589 | 347589 | EXCHANGE | CHANGE | 902664408 | 04 | 2010-11-01 | 2010-11-02 | MLPW | 0 | 0 | ? | 2010-11-02 | 20101102.ifs | 2010-11-02 | 2010-11-03 | ||||||||||||||
347590 | 347589 | EXCHANGE | CHANGE | 902664408 | 04 | 2010-11-01 | 2010-11-01 | MLPW | 0 | 0 | ? | 2010-11-02 | 20101102.ifs | 2010-11-02 | 2010-11-03 | ||||||||||||||
347591 | 347591 | EQUITY | CHANGE | 902664408 | E TRACS LKD WELLS FARGO MASTER LTD PARTNERSHIP INDEX | 0 | 0 | 2010-11-02 | ? | 0 | no | no | no | ? | 2010-11-02 | ? | 20101102.ifs | 2010-11-02 | 2010-11-03 | ||||||||||
347592 | 347591 | EQUITY | CHANGE | 902664408 | E TRACS LKD WELLS FARGO MASTER LTD PARTNERSHIP INDEX | 0 | 0 | 2010-11-01 | ? | 0 | no | no | no | ? | 2010-11-02 | ? | 20101102.ifs | 2010-11-02 | 2010-11-03 |
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 = 159804
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