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:147094 |
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 | ||
5555839 | 5555839 | DIVIDEND | ADD | F82059100 | A | 0 | 3 | 0 | 2.62 | 53 | ? | 2024-06-04 | 2024-06-05 | 2024-05-09 | 0 | 2024-05-09 | ? | 0 | 0006918336 | 20240509.ifs | 2024-05-09 | 2024-05-10 | |||||||
5289279 | 5289279 | DIVIDEND | ADD | F82059100 | A | 0 | 3 | 0 | 2.45 | 53 | ? | 2023-06-01 | 2023-06-02 | 2023-05-10 | 0 | 2023-05-10 | ? | 0 | 0006724714 | 20230510.ifs | 2023-05-10 | 2023-05-11 | |||||||
5013099 | 5013099 | DIVIDEND | ADD | F82059100 | A | 0 | 3 | 0 | 2.45 | 53 | ? | 2022-06-01 | 2022-06-02 | 2022-05-17 | 0 | 2022-05-17 | ? | 0 | 0006524806 | 20220517.ifs | 2022-05-17 | 2022-05-18 | |||||||
4705292 | 4705292 | DIVIDEND | CHANGE | F82059100 | A | 0 | 3 | 0 | 2.14 | 44 | ? | 2021-05-26 | 2021-05-27 | 2021-05-13 | 0 | 2021-05-13 | ? | 0 | 0006307773 | 20210514.ifs | 2021-05-14 | 2021-05-15 | |||||||
4705293 | 4705292 | DIVIDEND | CHANGE | F82059100 | A | 0 | 3 | 1 | 2.14 | 0 | 44 | ? | 2021-05-26 | 2021-05-27 | 2021-05-13 | 0 | 2021-05-13 | 2021-05-14 | 0 | 0006307773 | 20210514.ifs | 2021-05-14 | 2021-05-15 | ||||||
4704780 | 4704780 | DIVIDEND | ADD | F82059100 | A | 0 | 3 | 0 | 2.14 | 44 | ? | 2021-05-26 | 2021-05-27 | 2021-05-13 | 0 | 2021-05-13 | ? | 0 | 0006307773 | 20210513.ifs | 2021-05-13 | 2021-05-14 | |||||||
4653912 | 4653912 | DIVIDEND | DELETE | F82059100 | 0 | 0 | 5 | 0 | .1 | 10 | ? | 2021-03-02 | ? | 2021-03-01 | 0 | 2021-03-01 | ? | 0 | 0006272686 | 20210316.ifs | 2021-03-16 | 2021-03-17 | |||||||
4653913 | 4653913 | DIVIDEND | ADD | F82059100 | 0 | 0 | 5 | 0 | .1 | 10 | ? | 2021-03-02 | 2021-03-12 | 2021-03-01 | 1 | 2021-03-01 | 2021-03-16 | 0 | 0006272686 | 20210316.ifs | 2021-03-16 | 2021-03-17 | |||||||
4641282 | 4641282 | DIVIDEND | ADD | F82059100 | 0 | 0 | 5 | 0 | .1 | 10 | ? | 2021-03-02 | ? | 2021-03-01 | 0 | 2021-03-01 | ? | 0 | 0006272686 | 20210301.ifs | 2021-03-01 | 2021-03-02 | |||||||
4641283 | 4641283 | EQUITY | CHANGE | F82059100 | ORD | 0 | 0 | 2001-10-02 | ? | 0 | no | no | no | 2003-05-19 | 2001-10-03 | ? | 20210301.ifs | 2021-03-01 | 2021-03-02 | ||||||||||
4641284 | 4641283 | EQUITY | CHANGE | F82059100 | ORD | 0 | 0 | 2001-10-02 | ? | 1 | no | no | no | 2003-05-19 | 2001-10-03 | ? | 20210301.ifs | 2021-03-01 | 2021-03-02 | ||||||||||
4349269 | 4349269 | DIVIDEND | CHANGE | F82059100 | A | 0 | 3 | 0 | 1.43 | 53 | ? | 2020-05-25 | 2020-05-26 | 2020-05-06 | 0 | 2020-05-06 | ? | 0 | 0006097046 | 20200527.ifs | 2020-05-27 | 2020-05-28 | |||||||
4349271 | 4349270 | DIVIDEND | CHANGE | F82059100 | A | 0 | 3 | 0 | 1.43 | 53 | ? | 2020-05-25 | 2020-05-26 | 2020-05-06 | 1 | 2020-05-06 | 2020-05-27 | 0 | 0006097046 | 20200527.ifs | 2020-05-27 | 2020-05-28 | |||||||
4349313 | 4349313 | DIVIDEND | CHANGE | F82059100 | A | 0 | 3 | 0 | 1.43 | 53 | ? | 2020-05-25 | 2020-05-26 | 2020-05-06 | 0 | 2020-05-06 | ? | 0 | 0006097046 | 20200527.ifs | 2020-05-27 | 2020-05-28 | |||||||
4349315 | 4349314 | DIVIDEND | CHANGE | F82059100 | A | 0 | 3 | 0 | 1.43 | 53 | ? | 2020-05-25 | 2020-05-26 | 2020-05-06 | 1 | 2020-05-06 | 2020-05-27 | 0 | 0006097046 | 20200527.ifs | 2020-05-27 | 2020-05-28 | |||||||
4325310 | 4325310 | DIVIDEND | ADD | F82059100 | A | 0 | 3 | 0 | 1.43 | 53 | ? | 2020-05-25 | 2020-05-26 | 2020-05-06 | 0 | 2020-05-06 | ? | 0 | 0006097046 | 20200506.ifs | 2020-05-06 | 2020-05-07 | |||||||
4325313 | 4325313 | DIVIDEND | ADD | F82059100 | A | 0 | 3 | 0 | 1.43 | 53 | ? | 2020-05-25 | 2020-05-26 | 2020-05-06 | 0 | 2020-05-06 | ? | 0 | 0006097046 | 20200506.ifs | 2020-05-06 | 2020-05-07 | |||||||
3756039 | 3756039 | DIVIDEND | CHANGE | F82059100 | A | 0 | 3 | 0 | 2.14 | 53 | ? | 2019-05-28 | 2019-05-29 | 2019-05-13 | 1 | 2019-05-13 | 2019-05-28 | 0 | 0005883806 | 20190603.ifs | 2019-06-03 | 2019-06-04 | |||||||
3756041 | 3756040 | DIVIDEND | CHANGE | F82059100 | A | 0 | 3 | 0 | 2.14 | 53 | ? | 2019-05-28 | 2019-05-29 | 2019-05-13 | 2 | 2019-05-13 | 2019-06-03 | 0 | 0005883806 | 20190603.ifs | 2019-06-03 | 2019-06-04 | |||||||
3756290 | 3756290 | DIVIDEND | CHANGE | F82059100 | A | 0 | 3 | 0 | 2.14 | 53 | ? | 2019-05-28 | 2019-05-29 | 2019-05-13 | 1 | 2019-05-13 | 2019-05-28 | 0 | 0005883806 | 20190603.ifs | 2019-06-03 | 2019-06-04 | |||||||
3756292 | 3756291 | DIVIDEND | CHANGE | F82059100 | A | 0 | 3 | 0 | 2.14 | 53 | ? | 2019-05-28 | 2019-05-29 | 2019-05-13 | 2 | 2019-05-13 | 2019-06-03 | 0 | 0005883806 | 20190603.ifs | 2019-06-03 | 2019-06-04 | |||||||
3739912 | 3739912 | DIVIDEND | CHANGE | F82059100 | A | 0 | 3 | 0 | 2.14 | 53 | ? | 2019-05-28 | 2019-05-29 | 2019-05-13 | 0 | 2019-05-13 | ? | 0 | 0005883806 | 20190528.ifs | 2019-05-28 | 2019-05-29 | |||||||
3739914 | 3739913 | DIVIDEND | CHANGE | F82059100 | A | 0 | 3 | 0 | 2.14 | 53 | ? | 2019-05-28 | 2019-05-29 | 2019-05-13 | 1 | 2019-05-13 | 2019-05-28 | 0 | 0005883806 | 20190528.ifs | 2019-05-28 | 2019-05-29 | |||||||
3739937 | 3739937 | DIVIDEND | CHANGE | F82059100 | A | 0 | 3 | 0 | 2.14 | 53 | ? | 2019-05-28 | 2019-05-29 | 2019-05-13 | 0 | 2019-05-13 | ? | 0 | 0005883806 | 20190528.ifs | 2019-05-28 | 2019-05-29 | |||||||
3739938 | 3739937 | DIVIDEND | CHANGE | F82059100 | A | 0 | 3 | 0 | 2.14 | 53 | ? | 2019-05-28 | 2019-05-29 | 2019-05-13 | 1 | 2019-05-13 | 2019-05-28 | 0 | 0005883806 | 20190528.ifs | 2019-05-28 | 2019-05-29 | |||||||
3725689 | 3725689 | DIVIDEND | ADD | F82059100 | A | 0 | 3 | 0 | 2.14 | 53 | ? | 2019-05-28 | 2019-05-29 | 2019-05-13 | 0 | 2019-05-13 | ? | 0 | 0005883806 | 20190513.ifs | 2019-05-13 | 2019-05-14 | |||||||
3725708 | 3725708 | DIVIDEND | ADD | F82059100 | A | 0 | 3 | 0 | 2.14 | 53 | ? | 2019-05-28 | 2019-05-29 | 2019-05-13 | 0 | 2019-05-13 | ? | 0 | 0005883806 | 20190513.ifs | 2019-05-13 | 2019-05-14 | |||||||
3099129 | 3099129 | DIVIDEND | CHANGE | F82059100 | A | 0 | 3 | 4 | 2 | 53 | ? | 2018-05-22 | 2018-05-23 | 2018-04-17 | 0 | 2018-04-17 | ? | 0 | 0005647761 | 20180523.ifs | 2018-05-23 | 2018-05-24 | |||||||
3099130 | 3099130 | DIVIDEND | CHANGE | F82059100 | A | 0 | 3 | 4 | 2 | 53 | ? | 2018-05-22 | 2018-05-23 | 2018-04-17 | 0 | 2018-04-17 | ? | 0 | 0005647761 | 20180523.ifs | 2018-05-23 | 2018-05-24 | |||||||
3099131 | 3099130 | DIVIDEND | CHANGE | F82059100 | A | 0 | 3 | 4 | 2 | 53 | ? | 2018-05-22 | 2018-05-23 | 2018-04-17 | 1 | 2018-04-17 | 2018-05-23 | 0 | 0005647761 | 20180523.ifs | 2018-05-23 | 2018-05-24 | |||||||
3099132 | 3099131 | DIVIDEND | CHANGE | F82059100 | A | 0 | 3 | 4 | 2 | 53 | ? | 2018-05-22 | 2018-05-23 | 2018-04-17 | 1 | 2018-04-17 | 2018-05-23 | 0 | 0005647761 | 20180523.ifs | 2018-05-23 | 2018-05-24 | |||||||
3040561 | 3040561 | DIVIDEND | ADD | F82059100 | A | 0 | 3 | 4 | 2 | 53 | ? | 2018-05-22 | 2018-05-23 | 2018-04-17 | 0 | 2018-04-17 | ? | 0 | 0005647761 | 20180417.ifs | 2018-04-17 | 2018-04-18 | |||||||
3040588 | 3040588 | DIVIDEND | ADD | F82059100 | A | 0 | 3 | 4 | 2 | 53 | ? | 2018-05-22 | 2018-05-23 | 2018-04-17 | 0 | 2018-04-17 | ? | 0 | 0005647761 | 20180417.ifs | 2018-04-17 | 2018-04-18 |
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 = 147094
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