INSITITUIONS | Dynamic | newInstitTable | Changed the Cusip/Sector/Shs Out? |
|
|||||||||||||
Total Insititutions : | 13 | 10 | Update Insititution By Cusips | ||||||||||||||
% Owned by Insititutions: | 0.64 % | 0.61 % | |||||||||||||||
pricingQuarterAdminPageOn:
|
2024-03-31 | New % | |||||||||||||||
|
|||||||||||||||||
the compid is:132435 |
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 | ||
5313871 | 5313871 | EQUITY | ADD | 29268T508 | NEW ISSUE | 0 | 0 | 2023-06-20 | ? | 0 | no | no | no | ? | ? | ? | 20230620.ifs | 2023-06-20 | 2023-06-21 | ||||||||||
5313872 | 5313872 | EQUITY | CHANGE | 29268T508 | NEW ISSUE | 0 | 0 | 2023-06-20 | ? | 0 | no | no | no | ? | ? | ? | 20230620.ifs | 2023-06-20 | 2023-06-21 | ||||||||||
5313873 | 5313872 | EQUITY | CHANGE | 29268T508 | COM PAR $0.0001 NEW | N | 0 | 2023-06-20 | ? | 0 | no | no | no | ? | 2023-06-20 | ? | 20230620.ifs | 2023-06-20 | 2023-06-21 | ||||||||||
5313874 | 5313874 | EXCHANGE | ADD | 29268T508 | 60 | 2023-06-20 | 2023-06-20 | EFOI | 0 | 0 | ? | 2023-06-20 | 20230620.ifs | 2023-06-20 | 2023-06-21 | ||||||||||||||
5313881 | 5313881 | SPLIT | ADD | 29268T508 | 7 | 2023-06-20 | 54 | 2023-06-16 | 2023-06-20 | 20230620.ifs | 2023-06-20 | 2023-06-21 | |||||||||||||||||
5313883 | 5313883 | DIVIDEND | ADD | 29268T508 | 0 | 0 | 6 | 0 | .142857 | 0 | 54 | 2023-06-20 | 2023-06-20 | 2023-06-20 | 2023-06-20 | 0 | ? | 2023-06-20 | 0 | 0006740068 | 20230620.ifs | 2023-06-20 | 2023-06-21 | ||||||
5314957 | 5314957 | EQUITY | CHANGE | 29268T508 | COM PAR $0.0001 NEW | N | 0 | 2023-06-20 | ? | 0 | no | no | no | ? | 2023-06-20 | ? | 20230620.ifs | 2023-06-20 | 2023-06-21 | ||||||||||
5314958 | 5314957 | EQUITY | CHANGE | 29268T508 | COM PAR $0.0001 NEW | 0 | 0 | 2023-06-20 | ? | 0 | no | no | no | ? | 2023-06-20 | ? | 20230620.ifs | 2023-06-20 | 2023-06-21 |
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 | ||
4390570 | 4390570 | DIVIDEND | ADD | 29268T300 | 0 | 0 | 6 | 0 | 1 | 54 | 2020-06-12 | 2020-06-12 | 2020-06-12 | 2020-06-12 | 0 | ? | 2020-06-12 | 0 | 20200612.ifs | 2020-06-12 | 2020-06-13 | ||||||||
4390571 | 4390571 | DIVIDEND | CHANGE | 29268T300 | 0 | 0 | 6 | 0 | 1 | 54 | 2020-06-12 | 2020-06-12 | 2020-06-12 | 2020-06-12 | 0 | ? | 2020-06-12 | 0 | 20200612.ifs | 2020-06-12 | 2020-06-13 | ||||||||
4390572 | 4390571 | DIVIDEND | CHANGE | 29268T300 | 0 | 0 | 6 | 0 | 1 | 0 | 54 | 2020-06-12 | 2020-06-12 | 2020-06-12 | 2020-06-12 | 0 | ? | 2020-06-12 | 0 | 000611 | 20200612.ifs | 2020-06-12 | 2020-06-13 | ||||||
4390573 | 4390573 | DIVIDEND | CHANGE | 29268T300 | 0 | 0 | 6 | 0 | 1 | 0 | 54 | 2020-06-12 | 2020-06-12 | 2020-06-12 | 2020-06-12 | 0 | ? | 2020-06-12 | 0 | 000611 | 20200612.ifs | 2020-06-12 | 2020-06-13 | ||||||
4390574 | 4390573 | DIVIDEND | CHANGE | 29268T300 | 0 | 0 | 6 | 0 | 1 | 0 | 54 | 2020-06-12 | 2020-06-12 | 2020-06-12 | 2020-06-12 | 0 | ? | 2020-06-12 | 0 | 0006110521 | 20200612.ifs | 2020-06-12 | 2020-06-13 | ||||||
4390575 | 4390575 | CORPACTION | ADD | 29268T300 | 60 | Q | 2020-06-12 | 29268T409 | 60 | 2020-06-12 | 20200612.ifs | 2020-06-12 | 2020-06-13 | ||||||||||||||||
4390576 | 4390576 | EQUITY | CHANGE | 29268T300 | COM NEW | 0 | 0 | 2014-07-18 | ? | 0 | no | no | no | ? | 2014-07-18 | ? | 20200612.ifs | 2020-06-12 | 2020-06-13 | ||||||||||
4390577 | 4390576 | EQUITY | CHANGE | 29268T300 | COM NEW | Q | 0 | 2014-07-18 | 2020-06-12 | 0 | no | no | 29268T409 | no | ? | 2020-06-12 | ? | 20200612.ifs | 2020-06-12 | 2020-06-13 | |||||||||
4390578 | 4390578 | SPLIT | DELETE | 29268T300 | 5 | 2020-06-12 | 54 | 2020-06-11 | ? | 20200612.ifs | 2020-06-12 | 2020-06-13 | |||||||||||||||||
4390580 | 4390580 | DIVIDEND | DELETE | 29268T300 | 0 | 0 | 6 | 0 | 1 | 0 | 54 | 2020-06-12 | 2020-06-12 | 2020-06-12 | 2020-06-12 | 0 | ? | 2020-06-12 | 0 | 0006110521 | 20200612.ifs | 2020-06-12 | 2020-06-13 | ||||||
4390358 | 4390358 | SPLIT | ADD | 29268T300 | 5 | 2020-06-12 | 54 | 2020-06-11 | ? | 20200611.ifs | 2020-06-11 | 2020-06-12 | |||||||||||||||||
1601046 | 1601046 | CORPACTION | ADD | 29268T300 | 66 | X | 2014-08-07 | 29268T300 | 60 | ? | 20140807.ifs | 2014-08-07 | 2014-08-08 | ||||||||||||||||
1601047 | 1601047 | EXCHANGE | ADD | 29268T300 | 60 | 2014-08-07 | 2014-08-07 | EFOI | 0 | 0 | 2014-08-07 | ? | 20140807.ifs | 2014-08-07 | 2014-08-08 | ||||||||||||||
1594487 | 1594487 | CORPACTION | ADD | 29268T300 | 66 | X | 2014-08-01 | 29268T300 | 60 | ? | 20140801.ifs | 2014-08-01 | 2014-08-02 | ||||||||||||||||
1594488 | 1594488 | EXCHANGE | ADD | 29268T300 | 60 | 2014-08-01 | ? | EFOI | 0 | 0 | 2014-08-01 | ? | 20140801.ifs | 2014-08-01 | 2014-08-02 | ||||||||||||||
1594762 | 1594762 | EXCHANGE | DELETE | 29268T300 | 60 | 2014-08-01 | ? | EFOI | 0 | 0 | 2014-08-01 | ? | 20140801.ifs | 2014-08-01 | 2014-08-02 | ||||||||||||||
1594763 | 1594763 | CORPACTION | DELETE | 29268T300 | 66 | X | 2014-08-01 | 29268T300 | 60 | ? | 20140801.ifs | 2014-08-01 | 2014-08-02 | ||||||||||||||||
1582382 | 1582382 | EQUITY | ADD | 29268T300 | NEW ISSUE | 0 | 0 | 2014-07-18 | ? | 0 | no | no | no | ? | ? | ? | 20140718.ifs | 2014-07-18 | 2014-07-19 | ||||||||||
1582383 | 1582383 | EQUITY | CHANGE | 29268T300 | NEW ISSUE | 0 | 0 | 2014-07-18 | ? | 0 | no | no | no | ? | ? | ? | 20140718.ifs | 2014-07-18 | 2014-07-19 | ||||||||||
1582384 | 1582383 | EQUITY | CHANGE | 29268T300 | COM NEW | N | 0 | 2014-07-18 | ? | 0 | no | no | no | ? | 2014-07-18 | ? | 20140718.ifs | 2014-07-18 | 2014-07-19 | ||||||||||
1582385 | 1582385 | EXCHANGE | ADD | 29268T300 | 66 | 2014-07-18 | 2014-07-18 | EFOID | 0 | 0 | ? | 2014-07-18 | 20140718.ifs | 2014-07-18 | 2014-07-19 | ||||||||||||||
1582390 | 1582390 | SPLIT | ADD | 29268T300 | 10 | 2014-07-18 | 54 | 2014-07-17 | 2014-07-18 | 20140718.ifs | 2014-07-18 | 2014-07-19 | |||||||||||||||||
1582392 | 1582392 | DIVIDEND | ADD | 29268T300 | 0 | 0 | 6 | 0 | .1 | 0 | 54 | 2014-07-18 | 2014-07-18 | 2014-07-18 | 2014-07-18 | 0 | ? | 2014-07-18 | 0 | 0004815600 | 20140718.ifs | 2014-07-18 | 2014-07-19 | ||||||
1582993 | 1582993 | EQUITY | CHANGE | 29268T300 | COM NEW | N | 0 | 2014-07-18 | ? | 0 | no | no | no | ? | 2014-07-18 | ? | 20140718.ifs | 2014-07-18 | 2014-07-19 | ||||||||||
1582994 | 1582993 | EQUITY | CHANGE | 29268T300 | COM NEW | 0 | 0 | 2014-07-18 | ? | 0 | no | no | no | ? | 2014-07-18 | ? | 20140718.ifs | 2014-07-18 | 2014-07-19 |
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 = 132435
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