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:159828 |
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 | ||
4667050 | 4667050 | CORPACTION | ADD | G72436127 | 66 | E | 2021-03-31 | ? | 20210331.ifs | 2021-03-31 | 2021-04-01 | ||||||||||||||||||
4667051 | 4667051 | EQUITY | CHANGE | G72436127 | WTS ON SHS | 0 | 2 | 2011-05-25 | ? | 0 | no | no | no | 2011-05-25 | 2016-02-17 | ? | 20210331.ifs | 2021-03-31 | 2021-04-01 | ||||||||||
4667052 | 4667051 | EQUITY | CHANGE | G72436127 | WTS ON SHS | E | 2 | 2011-05-25 | 2021-03-31 | 0 | no | no | no | 2011-05-25 | 2021-03-31 | ? | 20210331.ifs | 2021-03-31 | 2021-04-01 | ||||||||||
3595242 | 3595242 | EXCHANGE | CHANGE | G72436127 | 60 | 2011-05-25 | 2019-02-26 | PACQX | 0 | 2 | 2011-05-25 | 2011-05-25 | 20190227.ifs | 2019-02-27 | 2019-02-28 | ||||||||||||||
3595243 | 3595243 | EXCHANGE | CHANGE | G72436127 | 60 | 2011-05-25 | 2019-02-26 | PACQX | 0 | 2 | 2011-05-25 | 2011-05-25 | 20190227.ifs | 2019-02-27 | 2019-02-28 | ||||||||||||||
3595244 | 3595243 | EXCHANGE | CHANGE | G72436127 | 60 | 2011-05-25 | 2013-10-10 | PACQX | 0 | 2 | 2011-05-25 | 2019-02-27 | 20190227.ifs | 2019-02-27 | 2019-02-28 | ||||||||||||||
3595245 | 3595244 | EXCHANGE | CHANGE | G72436127 | 60 | 2011-05-25 | 2013-10-10 | PACQX | 0 | 2 | 2011-05-25 | 2019-02-27 | 20190227.ifs | 2019-02-27 | 2019-02-28 | ||||||||||||||
2113702 | 2113702 | CORPACTION | DELETE | G72436127 | 66 | E | 2016-02-05 | 2016-02-05 | 20160217.ifs | 2016-02-17 | 2016-02-18 | ||||||||||||||||||
2113703 | 2113703 | EQUITY | CHANGE | G72436127 | WTS ON SHS | E | 2 | 2011-05-25 | 2016-02-05 | 0 | no | no | no | 2011-05-25 | 2016-02-05 | ? | 20160217.ifs | 2016-02-17 | 2016-02-18 | ||||||||||
2113704 | 2113703 | EQUITY | CHANGE | G72436127 | WTS ON SHS | 0 | 2 | 2011-05-25 | ? | 0 | no | no | no | 2011-05-25 | 2016-02-17 | ? | 20160217.ifs | 2016-02-17 | 2016-02-18 | ||||||||||
2109656 | 2109656 | CORPACTION | DELETE | G72436127 | 66 | E | 2016-02-03 | ? | 20160205.ifs | 2016-02-05 | 2016-02-06 | ||||||||||||||||||
2109657 | 2109657 | CORPACTION | ADD | G72436127 | 66 | E | 2016-02-05 | 2016-02-05 | 20160205.ifs | 2016-02-05 | 2016-02-06 | ||||||||||||||||||
2109658 | 2109658 | EQUITY | CHANGE | G72436127 | WTS ON SHS | E | 2 | 2011-05-25 | 2016-02-03 | 0 | no | no | no | 2011-05-25 | 2016-02-03 | ? | 20160205.ifs | 2016-02-05 | 2016-02-06 | ||||||||||
2109659 | 2109658 | EQUITY | CHANGE | G72436127 | WTS ON SHS | E | 2 | 2011-05-25 | 2016-02-05 | 0 | no | no | no | 2011-05-25 | 2016-02-05 | ? | 20160205.ifs | 2016-02-05 | 2016-02-06 | ||||||||||
2108787 | 2108787 | CORPACTION | ADD | G72436127 | 66 | E | 2016-02-03 | ? | 20160203.ifs | 2016-02-03 | 2016-02-04 | ||||||||||||||||||
2108788 | 2108788 | EQUITY | CHANGE | G72436127 | WTS ON SHS | 0 | 2 | 2011-05-25 | ? | 0 | no | no | no | 2011-05-25 | 2011-05-26 | ? | 20160203.ifs | 2016-02-03 | 2016-02-04 | ||||||||||
2108789 | 2108788 | EQUITY | CHANGE | G72436127 | WTS ON SHS | E | 2 | 2011-05-25 | 2016-02-03 | 0 | no | no | no | 2011-05-25 | 2016-02-03 | ? | 20160203.ifs | 2016-02-03 | 2016-02-04 | ||||||||||
2108902 | 2108902 | EXCHANGE | CHANGE | G72436127 | 66 | 2013-10-11 | 2016-01-28 | PAQWF | 0 | 2 | 2013-10-11 | ? | 20160203.ifs | 2016-02-03 | 2016-02-04 | ||||||||||||||
2108903 | 2108902 | EXCHANGE | CHANGE | G72436127 | 66 | 2013-10-11 | 2016-02-02 | PAQWF | 0 | 2 | 2013-10-11 | 2016-02-03 | 20160203.ifs | 2016-02-03 | 2016-02-04 | ||||||||||||||
1315108 | 1315108 | CORPACTION | ADD | G72436127 | 60 | X | 2013-10-11 | G72436127 | 66 | ? | 20131011.ifs | 2013-10-11 | 2013-10-12 | ||||||||||||||||
1315109 | 1315109 | EXCHANGE | ADD | G72436127 | 66 | 2013-10-11 | 2013-10-11 | PAQWF | 0 | 2 | 2013-10-11 | ? | 20131011.ifs | 2013-10-11 | 2013-10-12 | ||||||||||||||
1315135 | 1315134 | ISSUER | CHANGE | G72436127 | 60 | X | 2013-10-11 | G72436127 | 66 | ? | 20131011.ifs | 2013-10-11 | 2013-10-12 | ||||||||||||||||
1315136 | 1315135 | ISSUER | CHANGE | G72436127 | 60 | X | 2013-10-11 | G72436127 | 66 | 2013-10-11 | 20131011.ifs | 2013-10-11 | 2013-10-12 | ||||||||||||||||
535752 | 535752 | EQUITY | CHANGE | G72436127 | WTS ON SHS | N | 2 | 2011-05-25 | ? | 0 | no | no | no | 2011-05-25 | 2011-05-25 | ? | 20110526.ifs | 2011-05-26 | 2011-05-27 | ||||||||||
535753 | 535752 | EQUITY | CHANGE | G72436127 | WTS ON SHS | 0 | 2 | 2011-05-25 | ? | 0 | no | no | no | 2011-05-25 | 2011-05-26 | ? | 20110526.ifs | 2011-05-26 | 2011-05-27 | ||||||||||
534197 | 534197 | EQUITY | ADD | G72436127 | ORD | N | 0 | 2011-05-25 | ? | 0 | no | no | no | 2011-05-25 | ? | ? | 20110525.ifs | 2011-05-25 | 2011-05-26 | ||||||||||
534198 | 534198 | EXCHANGE | ADD | G72436127 | 60 | 2011-05-25 | ? | PACQW | 0 | 2 | 2011-05-25 | ? | 20110525.ifs | 2011-05-25 | 2011-05-26 | ||||||||||||||
534373 | 534373 | EQUITY | CHANGE | G72436127 | ORD | N | 0 | 2011-05-25 | ? | 0 | no | no | no | 2011-05-25 | ? | ? | 20110525.ifs | 2011-05-25 | 2011-05-26 | ||||||||||
534374 | 534373 | EQUITY | CHANGE | G72436127 | WTS ON SHS | N | 0 | 2011-05-25 | ? | 0 | no | no | no | 2011-05-25 | 2011-05-25 | ? | 20110525.ifs | 2011-05-25 | 2011-05-26 | ||||||||||
534375 | 534375 | EQUITY | CHANGE | G72436127 | WTS ON SHS | N | 0 | 2011-05-25 | ? | 0 | no | no | no | 2011-05-25 | 2011-05-25 | ? | 20110525.ifs | 2011-05-25 | 2011-05-26 | ||||||||||
534376 | 534375 | EQUITY | CHANGE | G72436127 | WTS ON SHS | N | 2 | 2011-05-25 | ? | 0 | no | no | no | 2011-05-25 | 2011-05-25 | ? | 20110525.ifs | 2011-05-25 | 2011-05-26 | ||||||||||
534377 | 534377 | EXCHANGE | CHANGE | G72436127 | 60 | 2011-05-25 | ? | PACQW | 0 | 2 | 2011-05-25 | ? | 20110525.ifs | 2011-05-25 | 2011-05-26 | ||||||||||||||
534378 | 534377 | EXCHANGE | CHANGE | G72436127 | 60 | 2011-05-25 | ? | PACQX | 0 | 2 | 2011-05-25 | 2011-05-25 | 20110525.ifs | 2011-05-25 | 2011-05-26 |
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 = 159828
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