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:145415 |
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 | ||
1914320 | 1914320 | CORPACTION | ADD | 04248B109 | 66 | Q | 2015-07-10 | 90214M104 | 66 | ? | 20150710.ifs | 2015-07-10 | 2015-07-11 | ||||||||||||||||
1914321 | 1914321 | EQUITY | CHANGE | 04248B109 | COM | 0 | 0 | 2011-01-04 | ? | 0 | no | no | no | 2011-01-04 | 2015-06-03 | ? | 20150710.ifs | 2015-07-10 | 2015-07-11 | ||||||||||
1914322 | 1914321 | EQUITY | CHANGE | 04248B109 | COM | Q | 0 | 2011-01-04 | 2015-07-10 | 0 | no | no | 90214M104 | no | 2011-01-04 | 2015-07-10 | ? | 20150710.ifs | 2015-07-10 | 2015-07-11 | |||||||||
1914440 | 1914440 | EXCHANGE | CHANGE | 04248B109 | 66 | 2011-01-04 | 2015-06-19 | AIIFF | 0 | 0 | 2011-01-04 | 2011-01-07 | 20150710.ifs | 2015-07-10 | 2015-07-11 | ||||||||||||||
1914441 | 1914440 | EXCHANGE | CHANGE | 04248B109 | 66 | 2011-01-04 | 2015-07-09 | AIIFF | 0 | 0 | 2011-01-04 | 2015-07-10 | 20150710.ifs | 2015-07-10 | 2015-07-11 | ||||||||||||||
1881036 | 1881036 | CORPACTION | DELETE | 04248B109 | 66 | D | 2015-05-29 | ? | 20150603.ifs | 2015-06-03 | 2015-06-04 | ||||||||||||||||||
1881037 | 1881037 | EQUITY | CHANGE | 04248B109 | COM | D | 0 | 2011-01-04 | 2015-05-29 | 0 | no | no | no | 2011-01-04 | 2015-06-01 | ? | 20150603.ifs | 2015-06-03 | 2015-06-04 | ||||||||||
1881038 | 1881037 | EQUITY | CHANGE | 04248B109 | COM | 0 | 0 | 2011-01-04 | ? | 0 | no | no | no | 2011-01-04 | 2015-06-03 | ? | 20150603.ifs | 2015-06-03 | 2015-06-04 | ||||||||||
1875598 | 1875598 | CORPACTION | ADD | 04248B109 | 66 | D | 2015-05-29 | ? | 20150601.ifs | 2015-06-01 | 2015-06-02 | ||||||||||||||||||
1875599 | 1875599 | EQUITY | CHANGE | 04248B109 | COM | 0 | 0 | 2011-01-04 | ? | 0 | no | no | no | 2011-01-04 | 2011-01-07 | ? | 20150601.ifs | 2015-06-01 | 2015-06-02 | ||||||||||
1875600 | 1875599 | EQUITY | CHANGE | 04248B109 | COM | D | 0 | 2011-01-04 | 2015-05-29 | 0 | no | no | no | 2011-01-04 | 2015-06-01 | ? | 20150601.ifs | 2015-06-01 | 2015-06-02 | ||||||||||
554801 | 554801 | DIVIDEND | ADD | 04248B109 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2011-07-15 | 2011-06-09 | 0 | 2011-06-09 | ? | 0 | 0004199943 | 20110609.ifs | 2011-06-09 | 2011-06-10 | |||||||
471194 | 471194 | DIVIDEND | ADD | 04248B109 | A | 0 | 2 | 0 | .4 | 15 | 2011-03-29 | 2011-03-31 | 2011-04-15 | 2011-03-14 | 0 | 2011-03-14 | ? | 0 | 0004159248 | 20110314.ifs | 2011-03-14 | 2011-03-15 | |||||||
415060 | 415060 | EQUITY | CHANGE | 04248B109 | COM | 0 | 0 | 2011-01-04 | ? | 0 | no | no | no | 2011-01-04 | 2011-01-07 | ? | 20110107.ifs | 2011-01-07 | 2011-01-08 | ||||||||||
415061 | 415060 | EQUITY | CHANGE | 04248B109 | COM | 0 | 0 | 2011-01-04 | ? | 0 | no | no | no | 2011-01-04 | 2011-01-07 | ? | 20110107.ifs | 2011-01-07 | 2011-01-08 | ||||||||||
415062 | 415062 | EXCHANGE | CHANGE | 04248B109 | 66 | 2011-01-04 | 2011-01-06 | AIIFF | 0 | 0 | 2011-01-04 | 2011-01-07 | 20110107.ifs | 2011-01-07 | 2011-01-08 | ||||||||||||||
415063 | 415062 | EXCHANGE | CHANGE | 04248B109 | 66 | 2011-01-04 | 2011-01-06 | AIIFF | 0 | 0 | 2011-01-04 | 2011-01-07 | 20110107.ifs | 2011-01-07 | 2011-01-08 | ||||||||||||||
411778 | 411778 | EQUITY | ADD | 04248B109 | COM | N | 0 | 2011-01-04 | ? | 0 | no | no | no | 2011-01-04 | ? | ? | 20110104.ifs | 2011-01-04 | 2011-01-05 | ||||||||||
411782 | 411782 | EXCHANGE | ADD | 04248B109 | 66 | 2011-01-04 | ? | AIIFF | 0 | 0 | 2011-01-04 | ? | 20110104.ifs | 2011-01-04 | 2011-01-05 | ||||||||||||||
413115 | 413115 | EQUITY | CHANGE | 04248B109 | COM | N | 0 | 2011-01-04 | ? | 0 | no | no | no | 2011-01-04 | ? | ? | 20110104.ifs | 2011-01-04 | 2011-01-05 | ||||||||||
413116 | 413115 | EQUITY | CHANGE | 04248B109 | COM | 0 | 0 | 2011-01-04 | ? | 0 | no | no | no | 2011-01-04 | ? | ? | 20110104.ifs | 2011-01-04 | 2011-01-05 |
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 = 145415
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