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:159591 |
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 | ||
2293362 | 2293362 | CORPACTION | ADD | 253868707 | 01 | C | 2016-09-15 | ? | 20160915.ifs | 2016-09-15 | 2016-09-16 | ||||||||||||||||||
2293363 | 2293363 | EQUITY | CHANGE | 253868707 | REDEEMABLE PFD SER E 7% | 0 | 1 | 2011-09-12 | ? | 0 | no | no | no | 2011-09-12 | 2011-09-14 | ? | 20160915.ifs | 2016-09-15 | 2016-09-16 | ||||||||||
2293364 | 2293363 | EQUITY | CHANGE | 253868707 | REDEEMABLE PFD SER E 7% | C | 1 | 2011-09-12 | 2016-09-15 | 0 | no | no | no | 2011-09-12 | 2016-09-15 | ? | 20160915.ifs | 2016-09-15 | 2016-09-16 | ||||||||||
2293455 | 2293455 | DIVIDEND | CHANGE | 253868707 | 0 | 0 | C | 0 | .35972 | 12 | ? | ? | 2016-09-15 | 2016-08-15 | 0 | ? | 2016-08-16 | 0 | 20160915.ifs | 2016-09-15 | 2016-09-16 | ||||||||
2293456 | 2293455 | DIVIDEND | CHANGE | 253868707 | 0 | 0 | C | 0 | 25 | 0 | 12 | ? | ? | 2016-09-15 | 2016-08-15 | 0 | ? | 2016-09-15 | 0 | 20160915.ifs | 2016-09-15 | 2016-09-16 | |||||||
2271297 | 2271297 | DIVIDEND | ADD | 253868707 | 0 | 0 | C | 0 | .35972 | 12 | ? | ? | 2016-09-15 | 2016-08-15 | 0 | ? | 2016-08-16 | 0 | 20160816.ifs | 2016-08-16 | 2016-08-17 | ||||||||
2271176 | 2271176 | DIVIDEND | DELETE | 253868707 | 0 | 0 | 1 | 0 | .4375 | 00 | 2016-09-13 | 2016-09-15 | 2016-09-30 | 2016-08-10 | 0 | 2016-08-11 | ? | 0 | 0005264953 | 20160815.ifs | 2016-08-15 | 2016-08-16 | |||||||
2271177 | 2271177 | DIVIDEND | ADD | 253868707 | 0 | 0 | 1 | 0 | .35972 | 00 | ? | ? | 2016-09-15 | 2016-08-10 | 1 | 2016-08-11 | 2016-08-15 | 0 | 0005264953 | 20160815.ifs | 2016-08-15 | 2016-08-16 | |||||||
2269717 | 2269717 | DIVIDEND | ADD | 253868707 | 0 | 0 | 1 | 0 | .4375 | 00 | 2016-09-13 | 2016-09-15 | 2016-09-30 | 2016-08-10 | 0 | 2016-08-11 | ? | 0 | 0005264953 | 20160811.ifs | 2016-08-11 | 2016-08-12 | |||||||
2196015 | 2196015 | DIVIDEND | ADD | 253868707 | 0 | 0 | 1 | 0 | .4375 | 00 | 2016-06-13 | 2016-06-15 | 2016-06-30 | 2016-05-11 | 0 | 2016-05-12 | ? | 0 | 0005218316 | 20160513.ifs | 2016-05-13 | 2016-05-14 | |||||||
2115092 | 2115092 | DIVIDEND | ADD | 253868707 | 0 | 0 | 1 | 0 | .4375 | 00 | 2016-03-11 | 2016-03-15 | 2016-03-31 | 2016-02-17 | 0 | 2016-02-18 | ? | 0 | 0005173383 | 20160218.ifs | 2016-02-18 | 2016-02-19 | |||||||
2008121 | 2008121 | DIVIDEND | ADD | 253868707 | 0 | 0 | 1 | 0 | .4375 | 00 | 2015-12-11 | 2015-12-15 | 2015-12-31 | 2015-11-12 | 0 | 2015-11-12 | ? | 0 | 0005092864 | 20151112.ifs | 2015-11-12 | 2015-11-13 | |||||||
1940038 | 1940038 | DIVIDEND | ADD | 253868707 | 0 | 0 | 1 | 0 | .4375 | 00 | 2015-09-11 | 2015-09-15 | 2015-09-30 | 2015-08-11 | 0 | 2015-08-12 | ? | 0 | 0005046638 | 20150812.ifs | 2015-08-12 | 2015-08-13 | |||||||
1863626 | 1863626 | DIVIDEND | ADD | 253868707 | 0 | 0 | 1 | 0 | .4375 | 00 | 2015-06-11 | 2015-06-15 | 2015-06-30 | 2015-05-13 | 0 | 2015-05-14 | ? | 0 | 0005000179 | 20150514.ifs | 2015-05-14 | 2015-05-15 | |||||||
1799020 | 1799020 | DIVIDEND | ADD | 253868707 | 0 | 0 | 1 | 0 | .4375 | 00 | 2015-03-11 | 2015-03-13 | 2015-03-31 | 2015-02-26 | 0 | 2015-02-27 | ? | 0 | 0004959037 | 20150227.ifs | 2015-02-27 | 2015-02-28 | |||||||
1676207 | 1676207 | DIVIDEND | ADD | 253868707 | 0 | 0 | 1 | 0 | .4375 | 00 | 2014-12-11 | 2014-12-15 | 2014-12-31 | 2014-11-04 | 0 | 2014-11-05 | ? | 0 | 0004871021 | 20141105.ifs | 2014-11-05 | 2014-11-06 | |||||||
1584784 | 1584784 | DIVIDEND | ADD | 253868707 | 0 | 0 | 1 | 0 | .4375 | 00 | 2014-09-11 | 2014-09-15 | 2014-09-30 | 2014-07-21 | 0 | 2014-07-22 | ? | 0 | 0004816513 | 20140722.ifs | 2014-07-22 | 2014-07-23 | |||||||
1504395 | 1504395 | DIVIDEND | ADD | 253868707 | 0 | 0 | 1 | 0 | .4375 | 00 | 2014-06-11 | 2014-06-13 | 2014-06-30 | 2014-04-29 | 0 | 2014-04-29 | ? | 0 | 0004772585 | 20140429.ifs | 2014-04-29 | 2014-04-30 | |||||||
1442835 | 1442835 | DIVIDEND | ADD | 253868707 | 0 | 0 | 1 | 0 | .4375 | 00 | 2014-03-12 | 2014-03-14 | 2014-03-31 | 2014-02-11 | 0 | 2014-02-12 | ? | 0 | 0004736014 | 20140212.ifs | 2014-02-12 | 2014-02-13 | |||||||
1321751 | 1321751 | DIVIDEND | ADD | 253868707 | 0 | 0 | 1 | 0 | .4375 | 00 | 2013-12-11 | 2013-12-13 | 2013-12-31 | 2013-10-22 | 0 | 2013-10-23 | ? | 0 | 0004646965 | 20131023.ifs | 2013-10-23 | 2013-10-24 | |||||||
1245954 | 1245954 | DIVIDEND | ADD | 253868707 | 0 | 0 | 1 | 0 | .4375 | 00 | 2013-09-11 | 2013-09-13 | 2013-09-30 | 2013-07-23 | 0 | 2013-07-24 | ? | 0 | 0004603710 | 20130724.ifs | 2013-07-24 | 2013-07-25 | |||||||
1179065 | 1179065 | DIVIDEND | ADD | 253868707 | 0 | 0 | 1 | 0 | .4375 | 00 | 2013-06-12 | 2013-06-14 | 2013-06-28 | 2013-05-01 | 0 | 2013-05-02 | ? | 0 | 0004568519 | 20130502.ifs | 2013-05-02 | 2013-05-03 | |||||||
1111980 | 1111980 | DIVIDEND | ADD | 253868707 | 0 | 0 | 1 | 0 | .4375 | 00 | 2013-03-13 | 2013-03-15 | 2013-03-29 | 2013-02-12 | 0 | 2013-02-13 | ? | 0 | 0004527651 | 20130213.ifs | 2013-02-13 | 2013-02-14 | |||||||
998131 | 998131 | DIVIDEND | ADD | 253868707 | 0 | 0 | 1 | 0 | .4375 | 00 | 2012-12-12 | 2012-12-14 | 2012-12-31 | 2012-10-31 | 0 | 2012-10-31 | ? | 0 | 0004448769 | 20121031.ifs | 2012-10-31 | 2012-11-01 | |||||||
916044 | 916044 | DIVIDEND | ADD | 253868707 | 0 | 0 | 1 | 0 | .4375 | 00 | 2012-09-12 | 2012-09-14 | 2012-09-28 | 2012-07-19 | 0 | 2012-07-20 | ? | 0 | 0004403818 | 20120720.ifs | 2012-07-20 | 2012-07-21 | |||||||
841981 | 841981 | DIVIDEND | ADD | 253868707 | 0 | 0 | 1 | 0 | .4375 | 00 | 2012-06-13 | 2012-06-15 | 2012-06-29 | 2012-04-23 | 0 | 2012-04-24 | ? | 0 | 0004363560 | 20120424.ifs | 2012-04-24 | 2012-04-25 | |||||||
780059 | 780059 | DIVIDEND | ADD | 253868707 | 0 | 0 | 1 | 0 | .4375 | 00 | 2012-03-13 | 2012-03-15 | 2012-03-30 | 2012-02-15 | 0 | 2012-02-15 | ? | 0 | 0004332970 | 20120215.ifs | 2012-02-15 | 2012-02-16 | |||||||
678356 | 678356 | DIVIDEND | ADD | 253868707 | 0 | 0 | 1 | 4 | .515278 | 00 | 2011-12-13 | 2011-12-15 | 2011-12-30 | 2011-10-24 | 0 | 2011-10-25 | ? | 0 | 0004259921 | 20111025.ifs | 2011-10-25 | 2011-10-26 | |||||||
643289 | 643289 | CORPACTION | ADD | 253868707 | 66 | X | 2011-09-15 | 253868707 | 01 | ? | 20110915.ifs | 2011-09-15 | 2011-09-16 | ||||||||||||||||
643290 | 643290 | EXCHANGE | ADD | 253868707 | 01 | 2011-09-15 | 2011-09-15 | DLR_PE | 0 | 1 | 2011-09-15 | ? | 20110915.ifs | 2011-09-15 | 2011-09-16 | ||||||||||||||
642236 | 642236 | EQUITY | CHANGE | 253868707 | REDEEMABLE PFD SER E | 0 | 1 | 2011-09-12 | ? | 0 | no | no | no | 2011-09-12 | ? | ? | 20110914.ifs | 2011-09-14 | 2011-09-15 | ||||||||||
642237 | 642236 | EQUITY | CHANGE | 253868707 | REDEEMABLE PFD SER E 7% | 0 | 1 | 2011-09-12 | ? | 0 | no | no | no | 2011-09-12 | 2011-09-14 | ? | 20110914.ifs | 2011-09-14 | 2011-09-15 | ||||||||||
640904 | 640904 | EQUITY | ADD | 253868707 | REDEEMABLE PFD SER E | N | 1 | 2011-09-12 | ? | 0 | no | no | no | 2011-09-12 | ? | ? | 20110912.ifs | 2011-09-12 | 2011-09-13 | ||||||||||
640905 | 640905 | EXCHANGE | ADD | 253868707 | 66 | 2011-09-12 | 2011-09-12 | DLRPP | 0 | 1 | 2011-09-12 | ? | 20110912.ifs | 2011-09-12 | 2011-09-13 | ||||||||||||||
641272 | 641272 | EQUITY | CHANGE | 253868707 | REDEEMABLE PFD SER E | N | 1 | 2011-09-12 | ? | 0 | no | no | no | 2011-09-12 | ? | ? | 20110912.ifs | 2011-09-12 | 2011-09-13 | ||||||||||
641273 | 641272 | EQUITY | CHANGE | 253868707 | REDEEMABLE PFD SER E | 0 | 1 | 2011-09-12 | ? | 0 | no | no | no | 2011-09-12 | ? | ? | 20110912.ifs | 2011-09-12 | 2011-09-13 |
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 = 159591
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