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:159599 |
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 | ||
1897847 | 1897847 | CORPACTION | ADD | G62185114 | 01 | C | 2015-06-29 | ? | 20150629.ifs | 2015-06-29 | 2015-06-30 | ||||||||||||||||||
1897848 | 1897848 | EQUITY | CHANGE | G62185114 | 8.875% PFD NON CUMULATIVE SHS SER A | 0 | 1 | 2011-05-05 | ? | 0 | no | no | no | 2011-05-05 | 2015-06-12 | ? | 20150629.ifs | 2015-06-29 | 2015-06-30 | ||||||||||
1897849 | 1897848 | EQUITY | CHANGE | G62185114 | 8.875% PFD NON CUMULATIVE SHS SER A | C | 1 | 2011-05-05 | 2015-06-29 | 0 | no | no | no | 2011-05-05 | 2015-06-29 | ? | 20150629.ifs | 2015-06-29 | 2015-06-30 | ||||||||||
1885087 | 1885087 | CORPACTION | DELETE | G62185114 | 01 | C | 2015-05-29 | 2015-05-29 | 20150612.ifs | 2015-06-12 | 2015-06-13 | ||||||||||||||||||
1885088 | 1885088 | EQUITY | CHANGE | G62185114 | 8.875% PFD NON CUMULATIVE SHS SER A | C | 1 | 2011-05-05 | 2015-05-29 | 0 | no | no | no | 2011-05-05 | 2015-05-29 | ? | 20150612.ifs | 2015-06-12 | 2015-06-13 | ||||||||||
1885089 | 1885088 | EQUITY | CHANGE | G62185114 | 8.875% PFD NON CUMULATIVE SHS SER A | 0 | 1 | 2011-05-05 | ? | 0 | no | no | no | 2011-05-05 | 2015-06-12 | ? | 20150612.ifs | 2015-06-12 | 2015-06-13 | ||||||||||
1872485 | 1872485 | DIVIDEND | ADD | G62185114 | 0 | 0 | C | 0 | 25 | 12 | ? | ? | 2015-06-29 | 2015-05-28 | 0 | ? | 2015-05-29 | 0 | 20150529.ifs | 2015-05-29 | 2015-05-30 | ||||||||
1872486 | 1872486 | DIVIDEND | CHANGE | G62185114 | 0 | 0 | C | 0 | 25 | 12 | ? | ? | 2015-06-29 | 2015-05-28 | 0 | ? | 2015-05-29 | 0 | 20150529.ifs | 2015-05-29 | 2015-05-30 | ||||||||
1872487 | 1872486 | DIVIDEND | CHANGE | G62185114 | 0 | 0 | C | 0 | 26 | 12 | ? | ? | 2015-06-29 | 2015-05-28 | 0 | ? | 2015-05-29 | 0 | 20150529.ifs | 2015-05-29 | 2015-05-30 | ||||||||
1872764 | 1872764 | CORPACTION | ADD | G62185114 | 01 | C | 2015-05-29 | 2015-05-29 | 20150529.ifs | 2015-05-29 | 2015-05-30 | ||||||||||||||||||
1872765 | 1872765 | EQUITY | CHANGE | G62185114 | 8.875% PFD NON CUMULATIVE SHS SER A | 0 | 1 | 2011-05-05 | ? | 0 | no | no | no | 2011-05-05 | 2011-05-05 | ? | 20150529.ifs | 2015-05-29 | 2015-05-30 | ||||||||||
1872766 | 1872765 | EQUITY | CHANGE | G62185114 | 8.875% PFD NON CUMULATIVE SHS SER A | C | 1 | 2011-05-05 | 2015-05-29 | 0 | no | no | no | 2011-05-05 | 2015-05-29 | ? | 20150529.ifs | 2015-05-29 | 2015-05-30 | ||||||||||
1871588 | 1871588 | DIVIDEND | ADD | G62185114 | 0 | 0 | 1 | 0 | .554688 | 00 | 2015-06-11 | 2015-06-15 | 2015-06-29 | 2015-05-28 | 0 | 2015-05-28 | ? | 0 | 0005003854 | 20150528.ifs | 2015-05-28 | 2015-05-29 | |||||||
1811482 | 1811482 | DIVIDEND | ADD | G62185114 | 0 | 0 | 1 | 0 | .554688 | 00 | 2015-03-27 | 2015-03-31 | 2015-04-15 | 2015-03-13 | 0 | 2015-03-13 | ? | 0 | 0004968433 | 20150313.ifs | 2015-03-13 | 2015-03-14 | |||||||
1715529 | 1715529 | DIVIDEND | ADD | G62185114 | 0 | 0 | 1 | 0 | .554688 | 00 | 2014-12-29 | 2014-12-31 | 2015-01-15 | 2014-12-15 | 0 | 2014-12-15 | ? | 0 | 0004897973 | 20141215.ifs | 2014-12-15 | 2014-12-16 | |||||||
1589354 | 1589354 | DIVIDEND | ADD | G62185114 | 0 | 0 | 1 | 0 | .554688 | 00 | 2014-09-26 | 2014-09-30 | 2014-10-15 | 2014-07-30 | 0 | 2014-07-30 | ? | 0 | 0004818936 | 20140730.ifs | 2014-07-30 | 2014-07-31 | |||||||
1546933 | 1546933 | DIVIDEND | ADD | G62185114 | 0 | 0 | 1 | 0 | .554688 | 00 | 2014-06-26 | 2014-06-30 | 2014-07-15 | 2014-06-11 | 0 | 2014-06-11 | ? | 0 | 0004795278 | 20140611.ifs | 2014-06-11 | 2014-06-12 | |||||||
1465633 | 1465633 | DIVIDEND | ADD | G62185114 | 0 | 0 | 1 | 0 | .554688 | 00 | 2014-03-27 | 2014-03-31 | 2014-04-15 | 2014-03-13 | 0 | 2014-03-13 | ? | 0 | 0004750126 | 20140313.ifs | 2014-03-13 | 2014-03-14 | |||||||
1286994 | 1286994 | DIVIDEND | ADD | G62185114 | 0 | 0 | 1 | 0 | .554688 | 00 | 2013-09-26 | 2013-09-30 | 2013-10-15 | 2013-09-13 | 0 | 2013-09-13 | ? | 0 | 0004629193 | 20130913.ifs | 2013-09-13 | 2013-09-14 | |||||||
1208534 | 1208534 | DIVIDEND | ADD | G62185114 | 0 | 0 | 1 | 0 | .554688 | 00 | 2013-06-26 | 2013-06-28 | 2013-07-15 | 2013-06-12 | 0 | 2013-06-12 | ? | 0 | 0004583192 | 20130612.ifs | 2013-06-12 | 2013-06-13 | |||||||
1132149 | 1132149 | DIVIDEND | ADD | G62185114 | 0 | 0 | 1 | 0 | .554688 | 00 | 2013-03-26 | 2013-03-28 | 2013-04-15 | 2013-03-13 | 0 | 2013-03-13 | ? | 0 | 0004540707 | 20130313.ifs | 2013-03-13 | 2013-03-14 | |||||||
1011897 | 1011897 | DIVIDEND | ADD | G62185114 | 0 | 0 | 1 | 0 | .554688 | 00 | 2012-12-27 | 2012-12-31 | 2013-01-15 | 2012-11-19 | 0 | 2012-11-19 | ? | 0 | 0004459013 | 20121119.ifs | 2012-11-19 | 2012-11-20 | |||||||
953284 | 953284 | DIVIDEND | ADD | G62185114 | 0 | 0 | 1 | 0 | .554688 | 00 | 2012-09-26 | 2012-09-28 | 2012-10-15 | 2012-09-10 | 0 | 2012-09-10 | ? | 0 | 0004427685 | 20120910.ifs | 2012-09-10 | 2012-09-11 | |||||||
886132 | 886132 | DIVIDEND | ADD | G62185114 | 0 | 0 | 1 | 0 | .554688 | 00 | 2012-06-27 | 2012-06-29 | 2012-07-15 | 2012-06-15 | 0 | 2012-06-15 | ? | 0 | 0004386653 | 20120615.ifs | 2012-06-15 | 2012-06-16 | |||||||
804113 | 804113 | DIVIDEND | DELETE | G62185114 | 0 | 0 | 1 | 0 | .554688 | 00 | 2012-03-28 | 2012-03-31 | 2012-04-15 | 2012-03-15 | 0 | 2012-03-15 | ? | 0 | 0004345521 | 20120316.ifs | 2012-03-16 | 2012-03-17 | |||||||
804114 | 804114 | DIVIDEND | ADD | G62185114 | 0 | 0 | 1 | 0 | .554688 | 00 | 2012-03-28 | 2012-03-30 | 2012-04-15 | 2012-03-15 | 1 | 2012-03-15 | 2012-03-16 | 0 | 0004345521 | 20120316.ifs | 2012-03-16 | 2012-03-17 | |||||||
802638 | 802638 | DIVIDEND | ADD | G62185114 | 0 | 0 | 1 | 0 | .554688 | 00 | 2012-03-28 | 2012-03-31 | 2012-04-15 | 2012-03-15 | 0 | 2012-03-15 | ? | 0 | 0004345521 | 20120315.ifs | 2012-03-15 | 2012-03-16 | |||||||
697088 | 697088 | DIVIDEND | ADD | G62185114 | 0 | 0 | 1 | 0 | .554688 | 00 | 2011-12-28 | 2011-12-31 | 2012-01-15 | 2011-11-18 | 0 | 2011-11-18 | ? | 0 | 0004270732 | 20111118.ifs | 2011-11-18 | 2011-11-19 | |||||||
643549 | 643549 | DIVIDEND | ADD | G62185114 | 0 | 0 | 1 | 0 | .554688 | 00 | 2011-09-28 | 2011-09-30 | 2011-10-15 | 2011-09-15 | 0 | 2011-09-15 | ? | 0 | 0004242614 | 20110915.ifs | 2011-09-15 | 2011-09-16 | |||||||
561420 | 561420 | DIVIDEND | CHANGE | G62185114 | 0 | 0 | 1 | 4 | .400061 | 00 | 2011-06-28 | 2011-06-30 | 2011-07-15 | 2011-06-15 | 0 | 2011-06-15 | ? | 0 | 0004200778 | 20110616.ifs | 2011-06-16 | 2011-06-17 | |||||||
561421 | 561420 | DIVIDEND | CHANGE | G62185114 | 0 | 0 | 1 | 4 | .400608 | 00 | 2011-06-28 | 2011-06-30 | 2011-07-15 | 2011-06-15 | 1 | 2011-06-15 | 2011-06-16 | 0 | 0004200778 | 20110616.ifs | 2011-06-16 | 2011-06-17 | |||||||
559893 | 559893 | DIVIDEND | ADD | G62185114 | 0 | 0 | 1 | 4 | .400061 | 00 | 2011-06-28 | 2011-06-30 | 2011-07-15 | 2011-06-15 | 0 | 2011-06-15 | ? | 0 | 0004200778 | 20110615.ifs | 2011-06-15 | 2011-06-16 | |||||||
524810 | 524810 | CORPACTION | ADD | G62185114 | 66 | X | 2011-05-12 | G62185114 | 01 | ? | 20110512.ifs | 2011-05-12 | 2011-05-13 | ||||||||||||||||
524811 | 524811 | EXCHANGE | ADD | G62185114 | 01 | 2011-05-12 | 2011-05-12 | MRH_PA | 0 | 1 | 2011-05-12 | ? | 20110512.ifs | 2011-05-12 | 2011-05-13 | ||||||||||||||
520643 | 520643 | EQUITY | ADD | G62185114 | ORD | N | 0 | 2011-05-05 | ? | 0 | no | no | no | 2011-05-05 | ? | ? | 20110505.ifs | 2011-05-05 | 2011-05-06 | ||||||||||
520644 | 520644 | EXCHANGE | ADD | G62185114 | 66 | 2011-05-05 | 2011-05-05 | MRHSF | 0 | 1 | 2011-05-05 | ? | 20110505.ifs | 2011-05-05 | 2011-05-06 | ||||||||||||||
520771 | 520771 | EQUITY | CHANGE | G62185114 | ORD | N | 0 | 2011-05-05 | ? | 0 | no | no | no | 2011-05-05 | ? | ? | 20110505.ifs | 2011-05-05 | 2011-05-06 | ||||||||||
520772 | 520771 | EQUITY | CHANGE | G62185114 | 8.875% PFD NON CUMULATIVE SHS SER A | N | 1 | 2011-05-05 | ? | 0 | no | no | no | 2011-05-05 | 2011-05-05 | ? | 20110505.ifs | 2011-05-05 | 2011-05-06 | ||||||||||
521179 | 521179 | EQUITY | CHANGE | G62185114 | 8.875% PFD NON CUMULATIVE SHS SER A | N | 1 | 2011-05-05 | ? | 0 | no | no | no | 2011-05-05 | 2011-05-05 | ? | 20110505.ifs | 2011-05-05 | 2011-05-06 | ||||||||||
521180 | 521179 | EQUITY | CHANGE | G62185114 | 8.875% PFD NON CUMULATIVE SHS SER A | 0 | 1 | 2011-05-05 | ? | 0 | no | no | no | 2011-05-05 | 2011-05-05 | ? | 20110505.ifs | 2011-05-05 | 2011-05-06 |
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 = 159599
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