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:151512 |
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 | ||
1016825 | 1016825 | CORPACTION | ADD | 30225W204 | 66 | D | 2012-11-28 | ? | 20121128.ifs | 2012-11-28 | 2012-11-29 | ||||||||||||||||||
1016826 | 1016826 | EQUITY | CHANGE | 30225W204 | COM NEW | 0 | 0 | 2009-05-07 | ? | 0 | no | no | no | ? | 2009-05-07 | ? | 20121128.ifs | 2012-11-28 | 2012-11-29 | ||||||||||
1016827 | 1016826 | EQUITY | CHANGE | 30225W204 | COM NEW | D | 0 | 2009-05-07 | 2012-11-28 | 0 | no | no | no | ? | 2012-11-28 | ? | 20121128.ifs | 2012-11-28 | 2012-11-29 | ||||||||||
1016883 | 1016883 | EXCHANGE | CHANGE | 30225W204 | 66 | 2011-10-18 | 2012-11-20 | EENIQ | 0 | 0 | 2011-10-18 | 2012-01-31 | 20121128.ifs | 2012-11-28 | 2012-11-29 | ||||||||||||||
1016884 | 1016883 | EXCHANGE | CHANGE | 30225W204 | 66 | 2011-10-18 | 2012-11-27 | EENIQ | 0 | 0 | 2011-10-18 | 2012-11-28 | 20121128.ifs | 2012-11-28 | 2012-11-29 | ||||||||||||||
765376 | 765376 | CORPACTION | ADD | 30225W204 | 66 | # | 2012-01-31 | 30225W204 | 66 | ? | 20120131.ifs | 2012-01-31 | 2012-02-01 | ||||||||||||||||
765377 | 765377 | CORPACTIONAUX | ADD | 30225W204 | 66 | 2012-01-31 | EENI | EXTERRA ENERGY INC | COM NEW | EENIQ | EXTERRA ENERGY INC | COM NEW | 2012-01-31 | ? | 20120131.ifs | 2012-01-31 | 2012-02-01 | ||||||||||||
765378 | 765378 | EXCHANGE | CHANGE | 30225W204 | 66 | 2011-10-18 | 2012-01-30 | EENI | 0 | 0 | 2011-10-18 | ? | 20120131.ifs | 2012-01-31 | 2012-02-01 | ||||||||||||||
765379 | 765378 | EXCHANGE | CHANGE | 30225W204 | 66 | 2011-10-18 | 2012-01-30 | EENIQ | 0 | 0 | 2011-10-18 | 2012-01-31 | 20120131.ifs | 2012-01-31 | 2012-02-01 | ||||||||||||||
674246 | 674246 | CORPACTION | ADD | 30225W204 | 65 | X | 2011-10-18 | 30225W204 | 66 | ? | 20111018.ifs | 2011-10-18 | 2011-10-19 | ||||||||||||||||
674247 | 674247 | EXCHANGE | ADD | 30225W204 | 66 | 2011-10-18 | 2011-10-18 | EENI | 0 | 0 | 2011-10-18 | ? | 20111018.ifs | 2011-10-18 | 2011-10-19 | ||||||||||||||
674306 | 674306 | EXCHANGE | CHANGE | 30225W204 | 65 | 2009-05-07 | 2011-10-14 | EENIE | 0 | 0 | ? | 2011-09-16 | 20111018.ifs | 2011-10-18 | 2011-10-19 | ||||||||||||||
674307 | 674306 | EXCHANGE | CHANGE | 30225W204 | 65 | 2009-05-07 | 2011-10-17 | EENIE | 0 | 0 | ? | 2011-10-18 | 20111018.ifs | 2011-10-18 | 2011-10-19 | ||||||||||||||
645086 | 645086 | CORPACTION | ADD | 30225W204 | 65 | # | 2011-09-16 | 30225W204 | 65 | ? | 20110916.ifs | 2011-09-16 | 2011-09-17 | ||||||||||||||||
645087 | 645087 | CORPACTIONAUX | ADD | 30225W204 | 65 | 2011-09-16 | EENI | EXTERRA ENERGY INC | COM NEW | EENIE | EXTERRA ENERGY INC | COM NEW | 2011-09-16 | ? | 20110916.ifs | 2011-09-16 | 2011-09-17 | ||||||||||||
645088 | 645088 | EXCHANGE | CHANGE | 30225W204 | 65 | 2009-05-07 | 2011-09-15 | EENI | 0 | 0 | ? | 2010-09-20 | 20110916.ifs | 2011-09-16 | 2011-09-17 | ||||||||||||||
645089 | 645088 | EXCHANGE | CHANGE | 30225W204 | 65 | 2009-05-07 | 2011-09-15 | EENIE | 0 | 0 | ? | 2011-09-16 | 20110916.ifs | 2011-09-16 | 2011-09-17 | ||||||||||||||
310407 | 310407 | CORPACTION | ADD | 30225W204 | 65 | # | 2010-09-20 | 30225W204 | 65 | ? | 20100920.ifs | 2010-09-20 | 2010-09-21 | ||||||||||||||||
310408 | 310408 | CORPACTIONAUX | ADD | 30225W204 | 65 | 2010-09-20 | EENIE | EXTERRA ENERGY INC | COM NEW | EENI | EXTERRA ENERGY INC | COM NEW | 2010-09-20 | ? | 20100920.ifs | 2010-09-20 | 2010-09-21 | ||||||||||||
310409 | 310409 | EXCHANGE | CHANGE | 30225W204 | 65 | 2009-05-07 | 2010-09-17 | EENIE | 0 | 0 | ? | 2010-09-03 | 20100920.ifs | 2010-09-20 | 2010-09-21 | ||||||||||||||
310410 | 310409 | EXCHANGE | CHANGE | 30225W204 | 65 | 2009-05-07 | 2010-09-17 | EENI | 0 | 0 | ? | 2010-09-20 | 20100920.ifs | 2010-09-20 | 2010-09-21 | ||||||||||||||
301259 | 301259 | CORPACTION | ADD | 30225W204 | 65 | # | 2010-09-03 | 30225W204 | 65 | ? | 20100903.ifs | 2010-09-03 | 2010-09-04 | ||||||||||||||||
301260 | 301260 | CORPACTIONAUX | ADD | 30225W204 | 65 | 2010-09-03 | EENI | EXTERRA ENERGY INC | COM NEW | EENIE | EXTERRA ENERGY INC | COM NEW | 2010-09-03 | ? | 20100903.ifs | 2010-09-03 | 2010-09-04 | ||||||||||||
301261 | 301261 | EXCHANGE | CHANGE | 30225W204 | 65 | 2009-05-07 | 2010-09-02 | EENI | 0 | 0 | ? | 2009-10-26 | 20100903.ifs | 2010-09-03 | 2010-09-04 | ||||||||||||||
301262 | 301261 | EXCHANGE | CHANGE | 30225W204 | 65 | 2009-05-07 | 2010-09-02 | EENIE | 0 | 0 | ? | 2010-09-03 | 20100903.ifs | 2010-09-03 | 2010-09-04 |
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 = 151512
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