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:159582 |
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 | ||
2216585 | 2216585 | CORPACTION | ADD | 427825302 | 01 | C | 2016-06-08 | ? | 20160608.ifs | 2016-06-08 | 2016-06-09 | ||||||||||||||||||
2216586 | 2216586 | EQUITY | CHANGE | 427825302 | PFD SER B | 0 | 1 | 2011-05-13 | ? | 0 | no | no | no | 2011-05-13 | ? | ? | 20160608.ifs | 2016-06-08 | 2016-06-09 | ||||||||||
2216587 | 2216586 | EQUITY | CHANGE | 427825302 | PFD SER B | C | 1 | 2011-05-13 | 2016-06-08 | 0 | no | no | no | 2011-05-13 | 2016-06-08 | ? | 20160608.ifs | 2016-06-08 | 2016-06-09 | ||||||||||
2193359 | 2193359 | DIVIDEND | ADD | 427825302 | 0 | 0 | C | 0 | 25 | 12 | ? | ? | 2016-06-08 | 2016-05-10 | 0 | ? | 2016-05-10 | 0 | 20160510.ifs | 2016-05-10 | 2016-05-11 | ||||||||
2193145 | 2193145 | DIVIDEND | ADD | 427825302 | 0 | 0 | 1 | 0 | .3722 | 00 | ? | ? | 2016-06-08 | 2016-05-09 | 0 | 2016-05-09 | ? | 0 | 0005217771 | 20160509.ifs | 2016-05-09 | 2016-05-10 | |||||||
2137461 | 2137461 | DIVIDEND | ADD | 427825302 | 0 | 0 | 1 | 0 | .5 | 00 | 2016-03-30 | 2016-04-01 | 2016-04-15 | 2016-03-17 | 0 | 2016-03-17 | ? | 0 | 0005188052 | 20160317.ifs | 2016-03-17 | 2016-03-18 | |||||||
2048906 | 2048906 | DIVIDEND | ADD | 427825302 | 0 | 0 | 1 | 0 | .5 | 00 | 2015-12-29 | 2016-01-01 | 2016-01-15 | 2015-12-17 | 0 | 2015-12-17 | ? | 0 | 0005122880 | 20151217.ifs | 2015-12-17 | 2015-12-18 | |||||||
1972332 | 1972332 | DIVIDEND | ADD | 427825302 | 0 | 0 | 1 | 0 | .5 | 00 | 2015-09-29 | 2015-10-01 | 2015-10-15 | 2015-09-24 | 0 | 2015-09-24 | ? | 0 | 0005066930 | 20150924.ifs | 2015-09-24 | 2015-09-25 | |||||||
1868227 | 1868227 | DIVIDEND | ADD | 427825302 | 0 | 0 | 1 | 0 | .5 | 00 | 2015-06-29 | 2015-07-01 | 2015-07-15 | 2015-05-21 | 0 | 2015-05-21 | ? | 0 | 0005002223 | 20150521.ifs | 2015-05-21 | 2015-05-22 | |||||||
1815914 | 1815914 | DIVIDEND | ADD | 427825302 | 0 | 0 | 1 | 0 | .5 | 00 | 2015-03-30 | 2015-04-01 | 2015-04-15 | 2015-03-19 | 0 | 2015-03-19 | ? | 0 | 0004970399 | 20150319.ifs | 2015-03-19 | 2015-03-20 | |||||||
1709465 | 1709465 | DIVIDEND | ADD | 427825302 | 0 | 0 | 1 | 0 | .5 | 00 | 2014-12-29 | 2015-01-01 | 2015-01-15 | 2014-12-11 | 0 | 2014-12-11 | ? | 0 | 0004891338 | 20141211.ifs | 2014-12-11 | 2014-12-12 | |||||||
1635473 | 1635473 | DIVIDEND | ADD | 427825302 | 0 | 0 | 1 | 0 | .5 | 00 | 2014-09-29 | 2014-10-01 | 2014-10-15 | 2014-09-22 | 0 | 2014-09-22 | ? | 0 | 0004845824 | 20140922.ifs | 2014-09-22 | 2014-09-23 | |||||||
1528623 | 1528623 | DIVIDEND | ADD | 427825302 | 0 | 0 | 1 | 0 | .5 | 00 | 2014-06-27 | 2014-07-01 | 2014-07-15 | 2014-05-22 | 0 | 2014-05-22 | ? | 0 | 0004784444 | 20140522.ifs | 2014-05-22 | 2014-05-23 | |||||||
1465872 | 1465872 | DIVIDEND | ADD | 427825302 | 0 | 0 | 1 | 0 | .5 | 00 | 2014-03-28 | 2014-04-01 | 2014-04-15 | 2014-03-13 | 0 | 2014-03-13 | ? | 0 | 0004750107 | 20140313.ifs | 2014-03-13 | 2014-03-14 | |||||||
1369815 | 1369815 | DIVIDEND | ADD | 427825302 | 0 | 0 | 1 | 0 | .5 | 00 | 2013-12-27 | 2013-12-31 | 2014-01-15 | 2013-12-13 | 0 | 2013-12-13 | ? | 0 | 0004681906 | 20131213.ifs | 2013-12-13 | 2013-12-14 | |||||||
1289342 | 1289342 | DIVIDEND | ADD | 427825302 | 0 | 0 | 1 | 0 | .5 | 00 | 2013-09-27 | 2013-10-01 | 2013-10-15 | 2013-09-17 | 0 | 2013-09-17 | ? | 0 | 0004629916 | 20130917.ifs | 2013-09-17 | 2013-09-18 | |||||||
1191885 | 1191885 | DIVIDEND | ADD | 427825302 | 0 | 0 | 1 | 0 | .5 | 00 | 2013-06-27 | 2013-07-01 | 2013-07-15 | 2013-05-23 | 0 | 2013-05-23 | ? | 0 | 0004573241 | 20130523.ifs | 2013-05-23 | 2013-05-24 | |||||||
1133329 | 1133329 | DIVIDEND | ADD | 427825302 | 0 | 0 | 1 | 0 | .5 | 00 | 2013-03-27 | 2013-04-01 | 2013-04-15 | 2013-03-14 | 0 | 2013-03-14 | ? | 0 | 0004541166 | 20130314.ifs | 2013-03-14 | 2013-03-15 | |||||||
1031856 | 1031856 | DIVIDEND | ADD | 427825302 | 0 | 0 | 1 | 0 | .5 | 00 | 2012-12-27 | 2013-01-01 | 2013-01-15 | 2012-12-07 | 0 | 2012-12-07 | ? | 0 | 0004471728 | 20121207.ifs | 2012-12-07 | 2012-12-08 | |||||||
956054 | 956054 | DIVIDEND | ADD | 427825302 | 0 | 0 | 1 | 0 | .5 | 00 | 2012-09-27 | 2012-10-01 | 2012-10-15 | 2012-09-13 | 0 | 2012-09-13 | ? | 0 | 0004428992 | 20120913.ifs | 2012-09-13 | 2012-09-14 | |||||||
803252 | 803252 | DIVIDEND | ADD | 427825302 | 0 | 0 | 1 | 0 | .5 | 00 | 2012-03-28 | 2012-04-01 | 2012-04-16 | 2012-03-15 | 0 | 2012-03-15 | ? | 0 | 0004345590 | 20120315.ifs | 2012-03-15 | 2012-03-16 | |||||||
717295 | 717295 | DIVIDEND | ADD | 427825302 | 0 | 0 | 1 | 0 | .5 | 00 | 2011-12-28 | 2012-01-01 | 2012-01-17 | 2011-12-09 | 0 | 2011-12-09 | ? | 0 | 0004284554 | 20111209.ifs | 2011-12-09 | 2011-12-10 | |||||||
644316 | 644316 | DIVIDEND | ADD | 427825302 | 0 | 0 | 1 | 0 | .5 | 00 | 2011-09-28 | 2011-10-01 | 2011-10-17 | 2011-09-15 | 0 | 2011-09-15 | ? | 1 | 0004242619 | 20110915.ifs | 2011-09-15 | 2011-09-16 | |||||||
644317 | 644317 | DIVIDEND | CHANGE | 427825302 | 0 | 0 | 1 | 4 | .2389 | 00 | 2011-06-29 | 2011-07-01 | 2011-07-15 | 2011-06-01 | 0 | 2011-06-01 | ? | 0 | 0004194994 | 20110915.ifs | 2011-09-15 | 2011-09-16 | |||||||
644318 | 644317 | DIVIDEND | CHANGE | 427825302 | 0 | 0 | 1 | 0 | .2389 | 00 | 2011-06-29 | 2011-07-01 | 2011-07-15 | 2011-06-01 | 1 | 2011-06-01 | 2011-09-15 | 0 | 0004194994 | 20110915.ifs | 2011-09-15 | 2011-09-16 | |||||||
543982 | 543982 | DIVIDEND | ADD | 427825302 | 0 | 0 | 1 | 4 | .2389 | 00 | 2011-06-29 | 2011-07-01 | 2011-07-15 | 2011-06-01 | 0 | 2011-06-01 | ? | 0 | 0004194994 | 20110601.ifs | 2011-06-01 | 2011-06-02 | |||||||
530564 | 530564 | CORPACTION | ADD | 427825302 | 66 | X | 2011-05-20 | 427825302 | 01 | ? | 20110520.ifs | 2011-05-20 | 2011-05-21 | ||||||||||||||||
530565 | 530565 | EXCHANGE | ADD | 427825302 | 01 | 2011-05-20 | 2011-05-20 | HT__PB | 0 | 1 | 2011-05-20 | ? | 20110520.ifs | 2011-05-20 | 2011-05-21 | ||||||||||||||
526252 | 526252 | EQUITY | CHANGE | 427825302 | PFD SER B | N | 1 | 2011-05-13 | ? | 0 | no | no | no | 2011-05-13 | ? | ? | 20110516.ifs | 2011-05-16 | 2011-05-17 | ||||||||||
526253 | 526252 | EQUITY | CHANGE | 427825302 | PFD SER B | 0 | 1 | 2011-05-13 | ? | 0 | no | no | no | 2011-05-13 | ? | ? | 20110516.ifs | 2011-05-16 | 2011-05-17 | ||||||||||
525574 | 525574 | EQUITY | ADD | 427825302 | PFD SER B | N | 1 | 2011-05-13 | ? | 0 | no | no | no | 2011-05-13 | ? | ? | 20110513.ifs | 2011-05-13 | 2011-05-14 | ||||||||||
525575 | 525575 | EXCHANGE | ADD | 427825302 | 66 | 2011-05-13 | 2011-05-13 | HTTRP | 0 | 1 | 2011-05-13 | ? | 20110513.ifs | 2011-05-13 | 2011-05-14 |
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 = 159582
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