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:130999 |
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 | ||
2489037 | 2489037 | DIVIDEND | DELETE | 53261U304 | 0 | 0 | 6 | 0 | .003333 | 54 | 2017-02-13 | 2017-02-13 | 2017-02-13 | 2017-02-10 | 0 | 2017-02-10 | ? | 0 | 0005387558 | 20170213.ifs | 2017-02-13 | 2017-02-14 | |||||||
2489038 | 2489038 | DIVIDEND | ADD | 53261U304 | 0 | 0 | 6 | 0 | .003333 | 0 | 54 | 2017-02-13 | 2017-02-13 | 2017-02-13 | 2017-02-13 | 0 | ? | 2017-02-13 | 0 | 0005387558 | 20170213.ifs | 2017-02-13 | 2017-02-14 | ||||||
2489043 | 2489043 | CORPACTION | ADD | 53261U304 | 66 | Q | 2017-02-13 | 53261U403 | 66 | 2017-02-13 | 20170213.ifs | 2017-02-13 | 2017-02-14 | ||||||||||||||||
2489044 | 2489044 | EQUITY | CHANGE | 53261U304 | COM PAR $0.0001 | 0 | 0 | 2013-10-11 | ? | 0 | no | no | no | ? | 2013-10-14 | ? | 20170213.ifs | 2017-02-13 | 2017-02-14 | ||||||||||
2489045 | 2489044 | EQUITY | CHANGE | 53261U304 | COM PAR $0.0001 | Q | 0 | 2013-10-11 | 2017-02-13 | 0 | no | no | 53261U403 | no | ? | 2017-02-13 | ? | 20170213.ifs | 2017-02-13 | 2017-02-14 | |||||||||
2489046 | 2489046 | SPLIT | DELETE | 53261U304 | .0033333333 | 2017-02-13 | 11 | 2017-02-10 | ? | 20170213.ifs | 2017-02-13 | 2017-02-14 | |||||||||||||||||
2488722 | 2488722 | DIVIDEND | ADD | 53261U304 | 0 | 0 | 6 | 0 | 299 | 11 | 2017-02-13 | ? | ? | 2017-02-10 | 0 | 2017-02-10 | ? | 1 | 0005387559 | 20170210.ifs | 2017-02-10 | 2017-02-11 | |||||||
2488723 | 2488723 | SPLIT | ADD | 53261U304 | .0033333333 | 2017-02-13 | 11 | 2017-02-10 | ? | 20170210.ifs | 2017-02-10 | 2017-02-11 | |||||||||||||||||
2488724 | 2488724 | DIVIDEND | ADD | 53261U304 | 0 | 0 | 6 | 0 | .003333 | 54 | 2017-02-13 | 2017-02-13 | 2017-02-13 | 2017-02-10 | 0 | 2017-02-10 | ? | 0 | 0005387558 | 20170210.ifs | 2017-02-10 | 2017-02-11 | |||||||
2280320 | 2280320 | CORPACTION | ADD | 53261U304 | 60 | X | 2016-08-31 | 53261U304 | 66 | ? | 20160831.ifs | 2016-08-31 | 2016-09-01 | ||||||||||||||||
2280321 | 2280321 | EXCHANGE | ADD | 53261U304 | 66 | 2016-08-31 | 2016-08-31 | LIME | 0 | 0 | 2016-08-31 | ? | 20160831.ifs | 2016-08-31 | 2016-09-01 | ||||||||||||||
1315414 | 1315414 | EQUITY | CHANGE | 53261U304 | COM PAR $0.0001 | N | 0 | 2013-10-11 | ? | 0 | no | no | no | ? | 2013-10-11 | ? | 20131014.ifs | 2013-10-14 | 2013-10-15 | ||||||||||
1315415 | 1315414 | EQUITY | CHANGE | 53261U304 | COM PAR $0.0001 | 0 | 0 | 2013-10-11 | ? | 0 | no | no | no | ? | 2013-10-14 | ? | 20131014.ifs | 2013-10-14 | 2013-10-15 | ||||||||||
1314903 | 1314903 | EQUITY | ADD | 53261U304 | NEW ISSUE | 0 | 0 | 2013-10-11 | ? | 0 | no | no | no | ? | ? | ? | 20131011.ifs | 2013-10-11 | 2013-10-12 | ||||||||||
1314904 | 1314904 | EQUITY | CHANGE | 53261U304 | NEW ISSUE | 0 | 0 | 2013-10-11 | ? | 0 | no | no | no | ? | ? | ? | 20131011.ifs | 2013-10-11 | 2013-10-12 | ||||||||||
1314905 | 1314904 | EQUITY | CHANGE | 53261U304 | COM PAR $0.0001 | N | 0 | 2013-10-11 | ? | 0 | no | no | no | ? | 2013-10-11 | ? | 20131011.ifs | 2013-10-11 | 2013-10-12 | ||||||||||
1314908 | 1314908 | EXCHANGE | ADD | 53261U304 | 60 | 2013-10-11 | 2013-10-11 | LIME | 0 | 0 | ? | 2013-10-11 | 20131011.ifs | 2013-10-11 | 2013-10-12 | ||||||||||||||
1314913 | 1314913 | SPLIT | ADD | 53261U304 | 7 | 2013-10-11 | 54 | 2013-10-10 | 2013-10-11 | 20131011.ifs | 2013-10-11 | 2013-10-12 | |||||||||||||||||
1314915 | 1314915 | DIVIDEND | ADD | 53261U304 | 0 | 0 | 6 | 0 | .142857 | 0 | 54 | 2013-10-11 | 2013-10-11 | 2013-10-11 | 2013-10-11 | 0 | ? | 2013-10-11 | 0 | 0004644938 | 20131011.ifs | 2013-10-11 | 2013-10-12 |
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 = 130999
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