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:159609 |
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 | ||
2340710 | 2340710 | DIVIDEND | DELETE | G68603508 | 0 | 0 | 1 | 6 | 0 | 08 | ? | ? | 2016-11-01 | 2016-09-30 | 0 | 2016-09-30 | ? | 0 | 0005288582 | 20161108.ifs | 2016-11-08 | 2016-11-09 | |||||||
2340711 | 2340711 | DIVIDEND | ADD | G68603508 | 6 | 0 | 1 | 0 | .307118 | 05 | ? | ? | 2016-11-01 | 2016-09-30 | 1 | 2016-09-30 | 2016-11-08 | 0 | 0005288582 | 20161108.ifs | 2016-11-08 | 2016-11-09 | |||||||
2332953 | 2332953 | CORPACTION | ADD | G68603508 | 01 | C | 2016-11-01 | ? | 20161101.ifs | 2016-11-01 | 2016-11-02 | ||||||||||||||||||
2332954 | 2332954 | EQUITY | CHANGE | G68603508 | 7.25% PFD SER E | 0 | 1 | 2011-06-10 | ? | 0 | no | no | no | 2011-06-10 | 2011-06-10 | ? | 20161101.ifs | 2016-11-01 | 2016-11-02 | ||||||||||
2332955 | 2332954 | EQUITY | CHANGE | G68603508 | 7.25% PFD SER E | C | 1 | 2011-06-10 | 2016-11-01 | 0 | no | no | no | 2011-06-10 | 2016-11-01 | ? | 20161101.ifs | 2016-11-01 | 2016-11-02 | ||||||||||
2311371 | 2311371 | DIVIDEND | ADD | G68603508 | 0 | 0 | C | 0 | 25 | 12 | ? | ? | 2016-11-01 | 2016-09-30 | 0 | ? | 2016-10-03 | 0 | 20161003.ifs | 2016-10-03 | 2016-10-04 | ||||||||
2306887 | 2306887 | DIVIDEND | ADD | G68603508 | 0 | 0 | 1 | 6 | 0 | 08 | ? | ? | 2016-11-01 | 2016-09-30 | 0 | 2016-09-30 | ? | 0 | 0005288582 | 20160930.ifs | 2016-09-30 | 2016-10-01 | |||||||
2266217 | 2266217 | DIVIDEND | ADD | G68603508 | 6 | 0 | 1 | 0 | .453125 | 05 | 2016-08-17 | 2016-08-19 | 2016-09-01 | 2016-08-04 | 0 | 2016-08-04 | ? | 0 | 0005263905 | 20160804.ifs | 2016-08-04 | 2016-08-05 | |||||||
2191559 | 2191559 | DIVIDEND | ADD | G68603508 | 6 | 0 | 1 | 0 | .453125 | 05 | 2016-05-18 | 2016-05-20 | 2016-06-01 | 2016-05-05 | 0 | 2016-05-05 | ? | 0 | 0005217115 | 20160505.ifs | 2016-05-05 | 2016-05-06 | |||||||
2138175 | 2138175 | DIVIDEND | ADD | G68603508 | 6 | 1 | 9 | 1.25 | 25 | 2016-03-21 | 2016-03-17 | 2016-03-18 | 2016-02-29 | 0 | 2016-03-18 | ? | 0 | 0005177743 | 20160318.ifs | 2016-03-18 | 2016-03-19 | ||||||||
2112163 | 2112163 | DIVIDEND | ADD | G68603508 | 6 | 0 | 1 | 0 | .453125 | 05 | 2016-02-17 | 2016-02-19 | 2016-03-01 | 2016-02-11 | 0 | 2016-02-11 | ? | 0 | 0005171958 | 20160211.ifs | 2016-02-11 | 2016-02-12 | |||||||
2006153 | 2006153 | DIVIDEND | ADD | G68603508 | 6 | 0 | 1 | 0 | .453125 | 05 | 2015-11-18 | 2015-11-20 | 2015-12-01 | 2015-11-09 | 0 | 2015-11-09 | ? | 0 | 0005092048 | 20151109.ifs | 2015-11-09 | 2015-11-10 | |||||||
1939061 | 1939061 | DIVIDEND | ADD | G68603508 | 6 | 0 | 1 | 0 | .453125 | 05 | 2015-08-19 | 2015-08-21 | 2015-09-01 | 2015-08-10 | 0 | 2015-08-10 | ? | 0 | 0005046382 | 20150810.ifs | 2015-08-10 | 2015-08-11 | |||||||
1860137 | 1860137 | DIVIDEND | ADD | G68603508 | 6 | 0 | 1 | 0 | .453125 | 05 | 2015-05-19 | 2015-05-21 | 2015-06-01 | 2015-05-08 | 0 | 2015-05-08 | ? | 0 | 0004999389 | 20150508.ifs | 2015-05-08 | 2015-05-09 | |||||||
1787562 | 1787562 | DIVIDEND | ADD | G68603508 | 6 | 0 | 1 | 0 | .453125 | 05 | 2015-02-17 | 2015-02-19 | 2015-03-02 | 2015-02-06 | 0 | 2015-02-06 | ? | 0 | 0004953234 | 20150206.ifs | 2015-02-06 | 2015-02-07 | |||||||
1677684 | 1677684 | DIVIDEND | ADD | G68603508 | 6 | 0 | 1 | 0 | .453125 | 05 | 2014-11-18 | 2014-11-20 | 2014-12-01 | 2014-11-07 | 0 | 2014-11-07 | ? | 0 | 0004871602 | 20141107.ifs | 2014-11-07 | 2014-11-08 | |||||||
1602050 | 1602050 | DIVIDEND | ADD | G68603508 | 6 | 0 | 1 | 0 | .453125 | 05 | 2014-08-20 | 2014-08-22 | 2014-09-02 | 2014-08-08 | 0 | 2014-08-08 | ? | 0 | 0004827741 | 20140808.ifs | 2014-08-08 | 2014-08-09 | |||||||
1522027 | 1522027 | DIVIDEND | ADD | G68603508 | 6 | 0 | 1 | 0 | .453125 | 05 | 2014-05-20 | 2014-05-22 | 2014-06-02 | 2014-05-09 | 0 | 2014-05-09 | ? | 0 | 0004781509 | 20140509.ifs | 2014-05-09 | 2014-05-10 | |||||||
1440730 | 1440730 | DIVIDEND | ADD | G68603508 | 6 | 0 | 1 | 0 | .453125 | 05 | 2014-02-18 | 2014-02-20 | 2014-03-03 | 2014-02-07 | 0 | 2014-02-07 | ? | 0 | 0004735257 | 20140207.ifs | 2014-02-07 | 2014-02-08 | |||||||
1334523 | 1334523 | DIVIDEND | ADD | G68603508 | 6 | 0 | 1 | 0 | .453125 | 05 | 2013-11-19 | 2013-11-21 | 2013-12-02 | 2013-11-04 | 0 | 2013-11-04 | ? | 0 | 0004655646 | 20131104.ifs | 2013-11-04 | 2013-11-05 | |||||||
1262198 | 1262198 | DIVIDEND | ADD | G68603508 | 6 | 0 | 1 | 0 | .453125 | 05 | 2013-08-21 | 2013-08-23 | 2013-09-03 | 2013-08-09 | 0 | 2013-08-09 | ? | 0 | 0004614807 | 20130809.ifs | 2013-08-09 | 2013-08-10 | |||||||
1183621 | 1183621 | DIVIDEND | ADD | G68603508 | 6 | 0 | 1 | 0 | .453125 | 05 | 2013-05-21 | 2013-05-23 | 2013-06-03 | 2013-05-10 | 0 | 2013-05-10 | ? | 0 | 0004570606 | 20130510.ifs | 2013-05-10 | 2013-05-11 | |||||||
1108262 | 1108262 | DIVIDEND | ADD | G68603508 | 6 | 0 | 1 | 0 | .453125 | 05 | 2013-02-13 | 2013-02-15 | 2013-03-01 | 2013-02-05 | 0 | 2013-02-05 | ? | 0 | 0004526172 | 20130205.ifs | 2013-02-05 | 2013-02-06 | |||||||
1008208 | 1008208 | DIVIDEND | ADD | G68603508 | 6 | 0 | 1 | 0 | .453125 | 05 | 2012-11-19 | 2012-11-21 | 2012-12-03 | 2012-11-09 | 0 | 2012-11-09 | ? | 0 | 0004457253 | 20121109.ifs | 2012-11-09 | 2012-11-10 | |||||||
932077 | 932077 | DIVIDEND | ADD | G68603508 | 6 | 0 | 1 | 0 | .453125 | 05 | 2012-08-22 | 2012-08-24 | 2012-09-04 | 2012-08-13 | 0 | 2012-08-13 | ? | 0 | 0004415515 | 20120813.ifs | 2012-08-13 | 2012-08-14 | |||||||
859037 | 859037 | DIVIDEND | ADD | G68603508 | 6 | 0 | 1 | 0 | .453125 | 05 | 2012-05-17 | 2012-05-21 | 2012-06-01 | 2012-05-10 | 0 | 2012-05-10 | ? | 0 | 0004373393 | 20120510.ifs | 2012-05-10 | 2012-05-11 | |||||||
774957 | 774957 | DIVIDEND | ADD | G68603508 | 6 | 0 | 1 | 0 | .453125 | 05 | 2012-02-15 | 2012-02-17 | 2012-03-01 | 2012-02-06 | 0 | 2012-02-06 | ? | 0 | 0004331227 | 20120206.ifs | 2012-02-06 | 2012-02-07 | |||||||
690979 | 690979 | DIVIDEND | ADD | G68603508 | 6 | 0 | 1 | 0 | .453125 | 05 | 2011-11-16 | 2011-11-18 | 2011-12-01 | 2011-11-07 | 0 | 2011-11-07 | ? | 0 | 0004268543 | 20111107.ifs | 2011-11-07 | 2011-11-08 | |||||||
607756 | 607756 | DIVIDEND | ADD | G68603508 | 6 | 0 | 1 | 4 | .38264 | 05 | 2011-08-17 | 2011-08-19 | 2011-09-01 | 2011-08-08 | 0 | 2011-08-08 | ? | 0 | 0004228144 | 20110808.ifs | 2011-08-08 | 2011-08-09 | |||||||
561095 | 561095 | CORPACTION | ADD | G68603508 | 66 | X | 2011-06-16 | G68603508 | 01 | ? | 20110616.ifs | 2011-06-16 | 2011-06-17 | ||||||||||||||||
561096 | 561096 | EXCHANGE | ADD | G68603508 | 01 | 2011-06-16 | 2011-06-16 | PRE_PE | 0 | 1 | 2011-06-16 | ? | 20110616.ifs | 2011-06-16 | 2011-06-17 | ||||||||||||||
556657 | 556657 | EQUITY | ADD | G68603508 | ORD | N | 0 | 2011-06-10 | ? | 0 | no | no | no | 2011-06-10 | ? | ? | 20110610.ifs | 2011-06-10 | 2011-06-11 | ||||||||||
556658 | 556658 | EXCHANGE | ADD | G68603508 | 66 | 2011-06-10 | 2011-06-10 | PRQTF | 0 | 1 | 2011-06-10 | ? | 20110610.ifs | 2011-06-10 | 2011-06-11 | ||||||||||||||
556814 | 556814 | EQUITY | CHANGE | G68603508 | ORD | N | 0 | 2011-06-10 | ? | 0 | no | no | no | 2011-06-10 | ? | ? | 20110610.ifs | 2011-06-10 | 2011-06-11 | ||||||||||
556815 | 556814 | EQUITY | CHANGE | G68603508 | 7.25% PFD SER E | N | 0 | 2011-06-10 | ? | 0 | no | no | no | 2011-06-10 | 2011-06-10 | ? | 20110610.ifs | 2011-06-10 | 2011-06-11 | ||||||||||
556816 | 556816 | EQUITY | CHANGE | G68603508 | 7.25% PFD SER E | N | 0 | 2011-06-10 | ? | 0 | no | no | no | 2011-06-10 | 2011-06-10 | ? | 20110610.ifs | 2011-06-10 | 2011-06-11 | ||||||||||
556817 | 556816 | EQUITY | CHANGE | G68603508 | 7.25% PFD SER E | N | 1 | 2011-06-10 | ? | 0 | no | no | no | 2011-06-10 | 2011-06-10 | ? | 20110610.ifs | 2011-06-10 | 2011-06-11 | ||||||||||
557589 | 557589 | EQUITY | CHANGE | G68603508 | 7.25% PFD SER E | N | 1 | 2011-06-10 | ? | 0 | no | no | no | 2011-06-10 | 2011-06-10 | ? | 20110610.ifs | 2011-06-10 | 2011-06-11 | ||||||||||
557590 | 557589 | EQUITY | CHANGE | G68603508 | 7.25% PFD SER E | 0 | 1 | 2011-06-10 | ? | 0 | no | no | no | 2011-06-10 | 2011-06-10 | ? | 20110610.ifs | 2011-06-10 | 2011-06-11 |
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 = 159609
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