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:130599 |
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 | ||
3582673 | 3582673 | CORPACTION | ADD | 46261V306 | 60 | A | 2019-02-14 | 2019-02-14 | 20190214.ifs | 2019-02-14 | 2019-02-15 | ||||||||||||||||||
3582675 | 3582675 | EQUITY | CHANGE | 46261V306 | COM NEW | 0 | 0 | 2018-08-23 | ? | 0 | no | no | no | ? | 2018-08-23 | ? | 20190214.ifs | 2019-02-14 | 2019-02-15 | ||||||||||
3582677 | 3582676 | EQUITY | CHANGE | 46261V306 | COM NEW | A | 0 | 2018-08-23 | 2019-02-14 | 0 | no | no | no | ? | 2019-02-14 | ? | 20190214.ifs | 2019-02-14 | 2019-02-15 | ||||||||||
3582690 | 3582690 | CORPACTION | ADD | 46261V306 | 60 | A | 2019-02-14 | 2019-02-14 | 20190214.ifs | 2019-02-14 | 2019-02-15 | ||||||||||||||||||
3582692 | 3582692 | EQUITY | CHANGE | 46261V306 | COM NEW | 0 | 0 | 2018-08-23 | ? | 0 | no | no | no | ? | 2018-08-23 | ? | 20190214.ifs | 2019-02-14 | 2019-02-15 | ||||||||||
3582694 | 3582693 | EQUITY | CHANGE | 46261V306 | COM NEW | A | 0 | 2018-08-23 | 2019-02-14 | 0 | no | no | no | ? | 2019-02-14 | ? | 20190214.ifs | 2019-02-14 | 2019-02-15 | ||||||||||
3582759 | 3582759 | EQUITY | CHANGE | 46261V306 | COM NEW | A | 0 | 2018-08-23 | 2019-02-14 | 0 | no | no | no | ? | 2019-02-14 | ? | 20190214.ifs | 2019-02-14 | 2019-02-15 | ||||||||||
3582760 | 3582759 | EQUITY | CHANGE | 46261V306 | COM NEW | M | 0 | 2018-08-23 | 2019-02-14 | 0 | no | no | no | ? | 2019-02-14 | ? | 20190214.ifs | 2019-02-14 | 2019-02-15 | ||||||||||
3582777 | 3582777 | EQUITY | CHANGE | 46261V306 | COM NEW | A | 0 | 2018-08-23 | 2019-02-14 | 0 | no | no | no | ? | 2019-02-14 | ? | 20190214.ifs | 2019-02-14 | 2019-02-15 | ||||||||||
3582779 | 3582778 | EQUITY | CHANGE | 46261V306 | COM NEW | M | 0 | 2018-08-23 | 2019-02-14 | 0 | no | no | no | ? | 2019-02-14 | ? | 20190214.ifs | 2019-02-14 | 2019-02-15 | ||||||||||
3379223 | 3379223 | CORPACTION | ADD | 46261V306 | 66 | X | 2018-11-23 | 46261V306 | 60 | ? | 20181123.ifs | 2018-11-23 | 2018-11-24 | ||||||||||||||||
3379224 | 3379224 | CORPACTION | ADD | 46261V306 | 66 | X | 2018-11-23 | 46261V306 | 60 | ? | 20181123.ifs | 2018-11-23 | 2018-11-24 | ||||||||||||||||
3379225 | 3379225 | EXCHANGE | ADD | 46261V306 | 60 | 2018-11-23 | 2018-11-23 | IPAS | 0 | 0 | 2018-11-23 | ? | 20181123.ifs | 2018-11-23 | 2018-11-24 | ||||||||||||||
3379226 | 3379226 | EXCHANGE | ADD | 46261V306 | 60 | 2018-11-23 | 2018-11-23 | IPAS | 0 | 0 | 2018-11-23 | ? | 20181123.ifs | 2018-11-23 | 2018-11-24 | ||||||||||||||
3365282 | 3365282 | CORPACTION | ADD | 46261V306 | 60 | X | 2018-11-07 | 46261V306 | 66 | ? | 20181107.ifs | 2018-11-07 | 2018-11-08 | ||||||||||||||||
3365284 | 3365284 | EXCHANGE | ADD | 46261V306 | 66 | 2018-11-07 | 2018-11-07 | IPAS | 0 | 0 | 2018-11-07 | ? | 20181107.ifs | 2018-11-07 | 2018-11-08 | ||||||||||||||
3365287 | 3365287 | CORPACTION | ADD | 46261V306 | 60 | X | 2018-11-07 | 46261V306 | 66 | ? | 20181107.ifs | 2018-11-07 | 2018-11-08 | ||||||||||||||||
3365289 | 3365289 | EXCHANGE | ADD | 46261V306 | 66 | 2018-11-07 | 2018-11-07 | IPAS | 0 | 0 | 2018-11-07 | ? | 20181107.ifs | 2018-11-07 | 2018-11-08 | ||||||||||||||
3246503 | 3246503 | EQUITY | ADD | 46261V306 | NEW ISSUE | 0 | 0 | 2018-08-23 | ? | 0 | no | no | no | ? | ? | ? | 20180823.ifs | 2018-08-23 | 2018-08-24 | ||||||||||
3246504 | 3246504 | EQUITY | CHANGE | 46261V306 | NEW ISSUE | 0 | 0 | 2018-08-23 | ? | 0 | no | no | no | ? | ? | ? | 20180823.ifs | 2018-08-23 | 2018-08-24 | ||||||||||
3246505 | 3246504 | EQUITY | CHANGE | 46261V306 | COM NEW | N | 0 | 2018-08-23 | ? | 0 | no | no | no | ? | 2018-08-23 | ? | 20180823.ifs | 2018-08-23 | 2018-08-24 | ||||||||||
3246506 | 3246506 | EXCHANGE | ADD | 46261V306 | 60 | 2018-08-23 | 2018-08-23 | IPAS | 0 | 0 | ? | 2018-08-23 | 20180823.ifs | 2018-08-23 | 2018-08-24 | ||||||||||||||
3246511 | 3246511 | SPLIT | ADD | 46261V306 | 10 | 2018-08-23 | 54 | 2018-08-22 | 2018-08-23 | 20180823.ifs | 2018-08-23 | 2018-08-24 | |||||||||||||||||
3246513 | 3246513 | DIVIDEND | ADD | 46261V306 | 0 | 0 | 6 | 0 | .1 | 0 | 54 | 2018-08-23 | 2018-08-23 | 2018-08-23 | 2018-08-23 | 0 | ? | 2018-08-23 | 0 | 0005709646 | 20180823.ifs | 2018-08-23 | 2018-08-24 | ||||||
3246763 | 3246763 | EQUITY | ADD | 46261V306 | NEW ISSUE | 0 | 0 | 2018-08-23 | ? | 0 | no | no | no | ? | ? | ? | 20180823.ifs | 2018-08-23 | 2018-08-24 | ||||||||||
3246765 | 3246765 | EQUITY | CHANGE | 46261V306 | NEW ISSUE | 0 | 0 | 2018-08-23 | ? | 0 | no | no | no | ? | ? | ? | 20180823.ifs | 2018-08-23 | 2018-08-24 | ||||||||||
3246767 | 3246766 | EQUITY | CHANGE | 46261V306 | COM NEW | N | 0 | 2018-08-23 | ? | 0 | no | no | no | ? | 2018-08-23 | ? | 20180823.ifs | 2018-08-23 | 2018-08-24 | ||||||||||
3246769 | 3246769 | EXCHANGE | ADD | 46261V306 | 60 | 2018-08-23 | 2018-08-23 | IPAS | 0 | 0 | ? | 2018-08-23 | 20180823.ifs | 2018-08-23 | 2018-08-24 | ||||||||||||||
3246779 | 3246779 | SPLIT | ADD | 46261V306 | 10 | 2018-08-23 | 54 | 2018-08-22 | 2018-08-23 | 20180823.ifs | 2018-08-23 | 2018-08-24 | |||||||||||||||||
3246783 | 3246783 | DIVIDEND | ADD | 46261V306 | 0 | 0 | 6 | 0 | .1 | 0 | 54 | 2018-08-23 | 2018-08-23 | 2018-08-23 | 2018-08-23 | 0 | ? | 2018-08-23 | 0 | 0005709646 | 20180823.ifs | 2018-08-23 | 2018-08-24 | ||||||
3248691 | 3248691 | EQUITY | CHANGE | 46261V306 | COM NEW | N | 0 | 2018-08-23 | ? | 0 | no | no | no | ? | 2018-08-23 | ? | 20180823.ifs | 2018-08-23 | 2018-08-24 | ||||||||||
3248693 | 3248692 | EQUITY | CHANGE | 46261V306 | COM NEW | 0 | 0 | 2018-08-23 | ? | 0 | no | no | no | ? | 2018-08-23 | ? | 20180823.ifs | 2018-08-23 | 2018-08-24 | ||||||||||
3248909 | 3248909 | EQUITY | CHANGE | 46261V306 | COM NEW | N | 0 | 2018-08-23 | ? | 0 | no | no | no | ? | 2018-08-23 | ? | 20180823.ifs | 2018-08-23 | 2018-08-24 | ||||||||||
3248910 | 3248909 | EQUITY | CHANGE | 46261V306 | COM NEW | 0 | 0 | 2018-08-23 | ? | 0 | no | no | no | ? | 2018-08-23 | ? | 20180823.ifs | 2018-08-23 | 2018-08-24 |
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 = 130599
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