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:159625 |
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 | ||
5372966 | 5372966 | CORPACTION | ADD | 00208J801 | 66 | D | 2023-09-14 | ? | 20230914.ifs | 2023-09-14 | 2023-09-15 | ||||||||||||||||||
5372967 | 5372967 | EQUITY | CHANGE | 00208J801 | PERP PFD CONV 8% SER B | 0 | G | 2011-06-16 | ? | 0 | no | no | no | 2011-06-16 | ? | ? | 20230914.ifs | 2023-09-14 | 2023-09-15 | ||||||||||
5372968 | 5372967 | EQUITY | CHANGE | 00208J801 | PERP PFD CONV 8% SER B | D | G | 2011-06-16 | 2023-09-14 | 0 | no | no | no | 2011-06-16 | 2023-09-14 | ? | 20230914.ifs | 2023-09-14 | 2023-09-15 | ||||||||||
1501237 | 1501237 | EXCHANGE | CHANGE | 00208J801 | 66 | 2011-06-16 | 2014-04-17 | ATPGQ | 0 | G | 2011-06-16 | 2012-08-21 | 20140424.ifs | 2014-04-24 | 2014-04-25 | ||||||||||||||
1501238 | 1501237 | EXCHANGE | CHANGE | 00208J801 | 66 | 2011-06-16 | 2014-04-17 | ATPGP | 0 | G | 2011-06-16 | 2014-04-24 | 20140424.ifs | 2014-04-24 | 2014-04-25 | ||||||||||||||
1501240 | 1501239 | EXCHANGE | CHANGE | 00208J801 | 66 | # | 2012-08-21 | 00208J801 | 66 | ? | 20140424.ifs | 2014-04-24 | 2014-04-25 | ||||||||||||||||
1501241 | 1501240 | EXCHANGE | CHANGE | 00208J801 | 66 | # | 2012-08-21 | 00208J801 | 66 | 2014-04-24 | 20140424.ifs | 2014-04-24 | 2014-04-25 | ||||||||||||||||
1501243 | 1501242 | EXCHANGE | CHANGE | 00208J801 | 66 | 2012-08-21 | ATPGQ | ATP OIL & GAS CORP | PERP PFD CONV 8 | ATPGQ | ATP OIL & GAS CORP | PERP PFD CONV 8 | 2012-08-21 | ? | 20140424.ifs | 2014-04-24 | 2014-04-25 | ||||||||||||
1501244 | 1501243 | EXCHANGE | CHANGE | 00208J801 | 66 | 2012-08-21 | ATPGP | ATP OIL & GAS CORP | PERP PFD CONV 8 | ATPGQ | ATP OIL & GAS CORP | PERP PFD CONV 8 | 2012-08-21 | 2014-04-24 | 20140424.ifs | 2014-04-24 | 2014-04-25 | ||||||||||||
1501245 | 1501245 | EXCHANGE | CHANGE | 00208J801 | 66 | 2011-06-16 | 2014-04-17 | ATPGP | 0 | G | 2011-06-16 | 2014-04-24 | 20140424.ifs | 2014-04-24 | 2014-04-25 | ||||||||||||||
1501246 | 1501245 | EXCHANGE | CHANGE | 00208J801 | 66 | 2011-06-16 | 2014-04-17 | ATPGQ | 0 | G | 2011-06-16 | 2014-04-24 | 20140424.ifs | 2014-04-24 | 2014-04-25 | ||||||||||||||
936222 | 936222 | CORPACTION | ADD | 00208J801 | 66 | # | 2012-08-21 | 00208J801 | 66 | ? | 20120821.ifs | 2012-08-21 | 2012-08-22 | ||||||||||||||||
936223 | 936223 | CORPACTIONAUX | ADD | 00208J801 | 66 | 2012-08-21 | ATPGQ | ATP OIL & GAS CORP | PERP PFD CONV 8 | ATPGQ | ATP OIL & GAS CORP | PERP PFD CONV 8 | 2012-08-21 | ? | 20120821.ifs | 2012-08-21 | 2012-08-22 | ||||||||||||
936224 | 936224 | EXCHANGE | CHANGE | 00208J801 | 66 | 2011-06-16 | 2012-08-20 | ATPGP | 0 | G | 2011-06-16 | ? | 20120821.ifs | 2012-08-21 | 2012-08-22 | ||||||||||||||
936225 | 936224 | EXCHANGE | CHANGE | 00208J801 | 66 | 2011-06-16 | 2012-08-20 | ATPGQ | 0 | G | 2011-06-16 | 2012-08-21 | 20120821.ifs | 2012-08-21 | 2012-08-22 | ||||||||||||||
936825 | 936825 | DIVIDEND | CHANGE | 00208J801 | 0 | 0 | 1 | 0 | 1.99 | 00 | 2012-06-26 | 2012-06-15 | 2012-07-02 | 2012-06-04 | 2 | 2012-06-05 | 2012-06-25 | 0 | 0004384612 | 20120821.ifs | 2012-08-21 | 2012-08-22 | |||||||
936826 | 936825 | DIVIDEND | CHANGE | 00208J801 | 0 | 0 | 1 | 0 | 1.99 | 00 | 2012-06-26 | 2012-06-15 | 2012-07-02 | 2012-06-04 | 3 | 2012-06-05 | 2012-08-21 | 0 | 0004384612 | 20120821.ifs | 2012-08-21 | 2012-08-22 | |||||||
893441 | 893441 | DIVIDEND | DELETE | 00208J801 | 0 | 0 | 1 | 0 | 1.99 | 00 | ? | 2012-06-15 | 2012-07-02 | 2012-06-04 | 1 | 2012-06-05 | 2012-06-12 | 0 | 0004384612 | 20120625.ifs | 2012-06-25 | 2012-06-26 | |||||||
893442 | 893442 | DIVIDEND | ADD | 00208J801 | 0 | 0 | 1 | 0 | 1.99 | 00 | 2012-06-26 | 2012-06-15 | 2012-07-02 | 2012-06-04 | 2 | 2012-06-05 | 2012-06-25 | 0 | 0004384612 | 20120625.ifs | 2012-06-25 | 2012-06-26 | |||||||
883995 | 883995 | DIVIDEND | DELETE | 00208J801 | 0 | 0 | 1 | 0 | 1.99 | 00 | 2012-06-13 | 2012-06-15 | 2012-07-02 | 2012-06-04 | 0 | 2012-06-05 | ? | 0 | 0004384612 | 20120612.ifs | 2012-06-12 | 2012-06-13 | |||||||
883996 | 883996 | DIVIDEND | ADD | 00208J801 | 0 | 0 | 1 | 0 | 1.99 | 00 | ? | 2012-06-15 | 2012-07-02 | 2012-06-04 | 1 | 2012-06-05 | 2012-06-12 | 0 | 0004384612 | 20120612.ifs | 2012-06-12 | 2012-06-13 | |||||||
880293 | 880293 | DIVIDEND | ADD | 00208J801 | 0 | 0 | 1 | 0 | 1.99 | 00 | 2012-06-13 | 2012-06-15 | 2012-07-02 | 2012-06-04 | 0 | 2012-06-05 | ? | 0 | 0004384612 | 20120605.ifs | 2012-06-05 | 2012-06-06 | |||||||
799445 | 799445 | DIVIDEND | ADD | 00208J801 | 0 | 0 | 1 | 0 | 1.99 | 00 | 2012-03-13 | 2012-03-15 | 2012-04-02 | 2012-03-08 | 0 | 2012-03-08 | ? | 0 | 0004344532 | 20120308.ifs | 2012-03-08 | 2012-03-09 | |||||||
711818 | 711818 | DIVIDEND | ADD | 00208J801 | 0 | 0 | 1 | 0 | 2.02 | 00 | 2011-12-13 | 2011-12-15 | 2012-01-03 | 2011-12-02 | 0 | 2011-12-02 | ? | 0 | 0004280781 | 20111202.ifs | 2011-12-02 | 2011-12-03 | |||||||
637518 | 637518 | DIVIDEND | ADD | 00208J801 | 0 | 0 | 1 | 4 | 2.26 | 00 | 2011-09-13 | 2011-09-15 | 2011-10-03 | 2011-09-05 | 0 | 2011-09-06 | ? | 0 | 0004240221 | 20110906.ifs | 2011-09-06 | 2011-09-07 | |||||||
561056 | 561056 | EQUITY | ADD | 00208J801 | PERP PFD CONV 8% SER B | N | G | 2011-06-16 | ? | 0 | no | no | no | 2011-06-16 | ? | ? | 20110616.ifs | 2011-06-16 | 2011-06-17 | ||||||||||
561057 | 561057 | EXCHANGE | ADD | 00208J801 | 66 | 2011-06-16 | 2011-06-16 | ATPGP | 0 | G | 2011-06-16 | ? | 20110616.ifs | 2011-06-16 | 2011-06-17 | ||||||||||||||
562407 | 562407 | EQUITY | CHANGE | 00208J801 | PERP PFD CONV 8% SER B | N | G | 2011-06-16 | ? | 0 | no | no | no | 2011-06-16 | ? | ? | 20110616.ifs | 2011-06-16 | 2011-06-17 | ||||||||||
562408 | 562407 | EQUITY | CHANGE | 00208J801 | PERP PFD CONV 8% SER B | 0 | G | 2011-06-16 | ? | 0 | no | no | no | 2011-06-16 | ? | ? | 20110616.ifs | 2011-06-16 | 2011-06-17 |
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 = 159625
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