INSITITUIONS | Dynamic | newInstitTable | Changed the Cusip/Sector/Shs Out? |
|
|||||||
Total Insititutions : | 183 | 166 | Update Insititution By Cusips | ||||||||
% Owned by Insititutions: | 81.40 % | 86.08 % | |||||||||
pricingQuarterAdminPageOn:
|
2024-03-31 | New % | |||||||||
|
|||||||||||
the compid is:133691 |
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 | ||
5553373 | 5553373 | DIVIDEND | ADD | 825698103 | 0 | 0 | 1 | 0 | .05 | 00 | 2024-05-16 | 2024-05-17 | 2024-06-17 | 2024-05-03 | 0 | 2024-05-03 | ? | 0 | 0006917171 | 20240503.ifs | 2024-05-03 | 2024-05-04 | |||||||
5490262 | 5490262 | DIVIDEND | ADD | 825698103 | 0 | 0 | 1 | 0 | .05 | 00 | 2024-02-15 | 2024-02-16 | 2024-03-18 | 2024-02-01 | 0 | 2024-02-01 | ? | 0 | 0006872449 | 20240201.ifs | 2024-02-01 | 2024-02-02 | |||||||
5403610 | 5403610 | DIVIDEND | ADD | 825698103 | 0 | 0 | 1 | 0 | .05 | 00 | 2023-11-15 | 2023-11-16 | 2023-12-15 | 2023-10-31 | 0 | 2023-10-31 | ? | 0 | 0006803033 | 20231031.ifs | 2023-10-31 | 2023-11-01 | |||||||
5348947 | 5348947 | DIVIDEND | ADD | 825698103 | 0 | 0 | 1 | 0 | .05 | 00 | 2023-08-16 | 2023-08-17 | 2023-09-18 | 2023-08-02 | 0 | 2023-08-02 | ? | 0 | 0006767168 | 20230802.ifs | 2023-08-02 | 2023-08-03 | |||||||
5285655 | 5285655 | DIVIDEND | ADD | 825698103 | 0 | 0 | 1 | 0 | .05 | 00 | 2023-05-16 | 2023-05-17 | 2023-06-20 | 2023-05-02 | 0 | 2023-05-02 | ? | 0 | 0006722909 | 20230502.ifs | 2023-05-02 | 2023-05-03 | |||||||
5219460 | 5219460 | DIVIDEND | ADD | 825698103 | 0 | 0 | 1 | 0 | .05 | 00 | 2023-02-16 | 2023-02-17 | 2023-03-17 | 2023-01-31 | 0 | 2023-01-31 | ? | 0 | 0006674253 | 20230131.ifs | 2023-01-31 | 2023-02-01 | |||||||
5134391 | 5134391 | DIVIDEND | ADD | 825698103 | 0 | 0 | 1 | 0 | .05 | 00 | 2022-11-15 | 2022-11-16 | 2022-12-15 | 2022-11-01 | 0 | 2022-11-02 | ? | 0 | 0006610427 | 20221102.ifs | 2022-11-02 | 2022-11-03 | |||||||
5075350 | 5075350 | DIVIDEND | ADD | 825698103 | 0 | 0 | 1 | 0 | .05 | 00 | 2022-08-16 | 2022-08-17 | 2022-09-16 | 2022-08-05 | 0 | 2022-08-05 | ? | 0 | 0006568492 | 20220805.ifs | 2022-08-05 | 2022-08-06 | |||||||
5003257 | 5003257 | DIVIDEND | ADD | 825698103 | 0 | 0 | 1 | 0 | .05 | 00 | 2022-05-16 | 2022-05-17 | 2022-06-17 | 2022-05-02 | 0 | 2022-05-02 | ? | 0 | 0006517084 | 20220502.ifs | 2022-05-02 | 2022-05-03 | |||||||
4948251 | 4948251 | DIVIDEND | ADD | 825698103 | 0 | 0 | 1 | 0 | .05 | 00 | 2022-02-16 | 2022-02-17 | 2022-03-17 | 2022-02-03 | 0 | 2022-02-03 | ? | 0 | 0006477749 | 20220203.ifs | 2022-02-03 | 2022-02-04 | |||||||
4844660 | 4844660 | DIVIDEND | ADD | 825698103 | 0 | 0 | 1 | 0 | .025 | 00 | 2021-11-15 | 2021-11-16 | 2021-12-16 | 2021-11-05 | 0 | 2021-11-05 | ? | 0 | 0006395240 | 20211105.ifs | 2021-11-05 | 2021-11-06 | |||||||
4778445 | 4778445 | DIVIDEND | ADD | 825698103 | 0 | 0 | 1 | 0 | .025 | 00 | 2021-08-17 | 2021-08-18 | 2021-09-15 | 2021-08-06 | 0 | 2021-08-06 | ? | 0 | 0006352376 | 20210806.ifs | 2021-08-06 | 2021-08-07 | |||||||
4701803 | 4701803 | DIVIDEND | ADD | 825698103 | 0 | 0 | 1 | 0 | .025 | 00 | 2021-05-17 | 2021-05-18 | 2021-06-18 | 2021-05-07 | 0 | 2021-05-07 | ? | 0 | 0006306365 | 20210507.ifs | 2021-05-07 | 2021-05-08 | |||||||
4630098 | 4630098 | DIVIDEND | ADD | 825698103 | 0 | 0 | 1 | 0 | .025 | 00 | 2021-02-24 | 2021-02-25 | 2021-03-25 | 2021-02-15 | 0 | 2021-02-16 | ? | 0 | 0006264251 | 20210216.ifs | 2021-02-16 | 2021-02-17 | |||||||
4506224 | 4506224 | EQUITY | CHANGE | 825698103 | COM | 0 | 0 | 2013-02-28 | ? | 0 | no | no | yes | 2020-05-29 | 2020-05-29 | ? | 20201113.ifs | 2020-11-13 | 2020-11-14 | ||||||||||
4506225 | 4506224 | EQUITY | CHANGE | 825698103 | COM | 0 | 0 | 2013-02-28 | ? | 4 | no | no | yes | 2020-05-29 | 2020-11-13 | ? | 20201113.ifs | 2020-11-13 | 2020-11-14 | ||||||||||
4503706 | 4503706 | DIVIDEND | ADD | 825698103 | 0 | 0 | 1 | 0 | .025 | 00 | 2020-11-17 | 2020-11-18 | 2020-12-18 | 2020-11-06 | 0 | 2020-11-06 | ? | 0 | 0006187022 | 20201106.ifs | 2020-11-06 | 2020-11-07 | |||||||
4436913 | 4436913 | DIVIDEND | ADD | 825698103 | 0 | 0 | 1 | 0 | .025 | 00 | 2020-08-17 | 2020-08-18 | 2020-09-18 | 2020-08-06 | 0 | 2020-08-06 | ? | 0 | 0006142548 | 20200806.ifs | 2020-08-06 | 2020-08-07 | |||||||
4357404 | 4357404 | EXCHANGE | ADD | 825698103 | 60 | 2020-06-01 | 2020-06-01 | SHYF | 0 | 0 | 2020-06-01 | ? | 20200601.ifs | 2020-06-01 | 2020-06-02 | ||||||||||||||
4357510 | 4357510 | EQUITY | CHANGE | 825698103 | COM | N | 0 | 2013-02-28 | ? | 0 | no | no | yes | 2020-05-29 | 2020-05-29 | ? | 20200601.ifs | 2020-06-01 | 2020-06-02 | ||||||||||
4357511 | 4357510 | EQUITY | CHANGE | 825698103 | COM | 0 | 0 | 2013-02-28 | ? | 0 | no | no | yes | 2020-05-29 | 2020-05-29 | ? | 20200601.ifs | 2020-06-01 | 2020-06-02 | ||||||||||
4361798 | 4361798 | EXCHANGE | ADD | 825698103 | 60 | 2020-06-01 | 2020-06-01 | SHYF | 0 | 0 | 2020-06-01 | ? | 20200601.ifs | 2020-06-01 | 2020-06-02 | ||||||||||||||
4361904 | 4361904 | EQUITY | CHANGE | 825698103 | COM | N | 0 | 2013-02-28 | ? | 0 | no | no | yes | 2020-05-29 | 2020-05-29 | ? | 20200601.ifs | 2020-06-01 | 2020-06-02 | ||||||||||
4361905 | 4361904 | EQUITY | CHANGE | 825698103 | COM | 0 | 0 | 2013-02-28 | ? | 0 | no | no | yes | 2020-05-29 | 2020-05-29 | ? | 20200601.ifs | 2020-06-01 | 2020-06-02 | ||||||||||
4366192 | 4366192 | EXCHANGE | ADD | 825698103 | 60 | 2020-06-01 | 2020-06-01 | SHYF | 0 | 0 | 2020-06-01 | ? | 20200601.ifs | 2020-06-01 | 2020-06-02 | ||||||||||||||
4366298 | 4366298 | EQUITY | CHANGE | 825698103 | COM | N | 0 | 2013-02-28 | ? | 0 | no | no | yes | 2020-05-29 | 2020-05-29 | ? | 20200601.ifs | 2020-06-01 | 2020-06-02 | ||||||||||
4366299 | 4366298 | EQUITY | CHANGE | 825698103 | COM | 0 | 0 | 2013-02-28 | ? | 0 | no | no | yes | 2020-05-29 | 2020-05-29 | ? | 20200601.ifs | 2020-06-01 | 2020-06-02 | ||||||||||
4370586 | 4370586 | EXCHANGE | ADD | 825698103 | 60 | 2020-06-01 | 2020-06-01 | SHYF | 0 | 0 | 2020-06-01 | ? | 20200601.ifs | 2020-06-01 | 2020-06-02 | ||||||||||||||
4370692 | 4370692 | EQUITY | CHANGE | 825698103 | COM | N | 0 | 2013-02-28 | ? | 0 | no | no | yes | 2020-05-29 | 2020-05-29 | ? | 20200601.ifs | 2020-06-01 | 2020-06-02 | ||||||||||
4370693 | 4370692 | EQUITY | CHANGE | 825698103 | COM | 0 | 0 | 2013-02-28 | ? | 0 | no | no | yes | 2020-05-29 | 2020-05-29 | ? | 20200601.ifs | 2020-06-01 | 2020-06-02 | ||||||||||
4374980 | 4374980 | EXCHANGE | ADD | 825698103 | 60 | 2020-06-01 | 2020-06-01 | SHYF | 0 | 0 | 2020-06-01 | ? | 20200601.ifs | 2020-06-01 | 2020-06-02 | ||||||||||||||
4375086 | 4375086 | EQUITY | CHANGE | 825698103 | COM | N | 0 | 2013-02-28 | ? | 0 | no | no | yes | 2020-05-29 | 2020-05-29 | ? | 20200601.ifs | 2020-06-01 | 2020-06-02 | ||||||||||
4375087 | 4375086 | EQUITY | CHANGE | 825698103 | COM | 0 | 0 | 2013-02-28 | ? | 0 | no | no | yes | 2020-05-29 | 2020-05-29 | ? | 20200601.ifs | 2020-06-01 | 2020-06-02 | ||||||||||
4379374 | 4379374 | EXCHANGE | ADD | 825698103 | 60 | 2020-06-01 | 2020-06-01 | SHYF | 0 | 0 | 2020-06-01 | ? | 20200601.ifs | 2020-06-01 | 2020-06-02 | ||||||||||||||
4379480 | 4379480 | EQUITY | CHANGE | 825698103 | COM | N | 0 | 2013-02-28 | ? | 0 | no | no | yes | 2020-05-29 | 2020-05-29 | ? | 20200601.ifs | 2020-06-01 | 2020-06-02 | ||||||||||
4379481 | 4379480 | EQUITY | CHANGE | 825698103 | COM | 0 | 0 | 2013-02-28 | ? | 0 | no | no | yes | 2020-05-29 | 2020-05-29 | ? | 20200601.ifs | 2020-06-01 | 2020-06-02 | ||||||||||
4352811 | 4352811 | EQUITY | ADD | 825698103 | COM | N | 0 | 2013-02-28 | ? | 0 | no | no | no | 2020-05-29 | ? | ? | 20200529.ifs | 2020-05-29 | 2020-05-30 | ||||||||||
4352813 | 4352813 | EQUITY | CHANGE | 825698103 | COM | N | 0 | 2013-02-28 | ? | 0 | no | no | no | 2020-05-29 | ? | ? | 20200529.ifs | 2020-05-29 | 2020-05-30 | ||||||||||
4352815 | 4352814 | EQUITY | CHANGE | 825698103 | COM | N | 0 | 2013-02-28 | ? | 0 | no | no | yes | 2020-05-29 | 2020-05-29 | ? | 20200529.ifs | 2020-05-29 | 2020-05-30 | ||||||||||
4352888 | 4352888 | EQUITY | ADD | 825698103 | COM | N | 0 | 2013-02-28 | ? | 0 | no | no | no | 2020-05-29 | ? | ? | 20200529.ifs | 2020-05-29 | 2020-05-30 | ||||||||||
4352890 | 4352890 | EQUITY | CHANGE | 825698103 | COM | N | 0 | 2013-02-28 | ? | 0 | no | no | no | 2020-05-29 | ? | ? | 20200529.ifs | 2020-05-29 | 2020-05-30 | ||||||||||
4352891 | 4352890 | EQUITY | CHANGE | 825698103 | COM | N | 0 | 2013-02-28 | ? | 0 | no | no | yes | 2020-05-29 | 2020-05-29 | ? | 20200529.ifs | 2020-05-29 | 2020-05-30 |
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 = 133691
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