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:139545 |
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 | ||
5353930 | 5353930 | CORPACTION | ADD | 878520204 | 66 | D | 2023-08-15 | ? | 20230815.ifs | 2023-08-15 | 2023-08-16 | ||||||||||||||||||
5353931 | 5353931 | EQUITY | CHANGE | 878520204 | SPONSORED ADR NEW | 0 | 0 | 2010-07-15 | ? | 7 | no | no | no | ? | 2010-07-15 | ? | 20230815.ifs | 2023-08-15 | 2023-08-16 | ||||||||||
5353932 | 5353931 | EQUITY | CHANGE | 878520204 | SPONSORED ADR NEW | D | 0 | 2010-07-15 | 2023-08-15 | 7 | no | no | no | ? | 2023-08-15 | ? | 20230815.ifs | 2023-08-15 | 2023-08-16 | ||||||||||
5121443 | 5121443 | DIVIDEND | ADD | 878520204 | 6 | 0 | 1 | 9 | .053669 | 25 | 2022-11-01 | 2022-10-27 | 2022-10-31 | 2022-10-17 | 0 | 2022-10-17 | ? | 0 | 0006600156 | 20221017.ifs | 2022-10-17 | 2022-10-18 | |||||||
5121444 | 5121444 | EQUITY | CHANGE | 878520204 | SPONSORED ADR NEW | 0 | 0 | 2010-07-15 | ? | 1 | no | no | no | ? | 2010-07-15 | ? | 20221017.ifs | 2022-10-17 | 2022-10-18 | ||||||||||
5121445 | 5121444 | EQUITY | CHANGE | 878520204 | SPONSORED ADR NEW | 0 | 0 | 2010-07-15 | ? | 7 | no | no | no | ? | 2010-07-15 | ? | 20221017.ifs | 2022-10-17 | 2022-10-18 | ||||||||||
4487170 | 4487170 | DIVIDEND | ADD | 878520204 | 6 | 0 | 1 | 9 | .002543 | 25 | 2020-10-26 | 2020-10-27 | 2020-11-03 | 2020-10-16 | 0 | 2020-10-16 | ? | 0 | 0006175838 | 20201016.ifs | 2020-10-16 | 2020-10-17 | |||||||
4444186 | 4444186 | DIVIDEND | ADD | 878520204 | 6 | 0 | 1 | 9 | .002736 | 25 | 2020-08-28 | 2020-08-31 | 2020-09-08 | 2020-08-21 | 0 | 2020-08-21 | ? | 0 | 0006146034 | 20200821.ifs | 2020-08-21 | 2020-08-22 | |||||||
2618668 | 2618668 | DIVIDEND | DELETE | 878520204 | 0 | 0 | 1 | 5 | .063168 | 19 | 2017-06-16 | 2017-06-20 | ? | 2017-03-03 | 2 | 2017-03-03 | 2017-07-06 | 0 | 0005400131 | 20170710.ifs | 2017-07-10 | 2017-07-11 | |||||||
2618669 | 2618669 | DIVIDEND | ADD | 878520204 | 0 | 0 | 1 | 0 | .067112 | 00 | 2017-06-16 | 2017-06-20 | 2017-07-14 | 2017-03-03 | 3 | 2017-03-03 | 2017-07-10 | 0 | 0005400131 | 20170710.ifs | 2017-07-10 | 2017-07-11 | |||||||
2616523 | 2616523 | DIVIDEND | DELETE | 878520204 | 0 | 0 | 1 | 5 | .063168 | 19 | 2017-06-16 | 2017-06-20 | 2017-07-10 | 2017-03-03 | 1 | 2017-03-03 | 2017-03-06 | 0 | 0005400131 | 20170706.ifs | 2017-07-06 | 2017-07-07 | |||||||
2616524 | 2616524 | DIVIDEND | ADD | 878520204 | 0 | 0 | 1 | 5 | .063168 | 19 | 2017-06-16 | 2017-06-20 | ? | 2017-03-03 | 2 | 2017-03-03 | 2017-07-06 | 0 | 0005400131 | 20170706.ifs | 2017-07-06 | 2017-07-07 | |||||||
2508170 | 2508170 | DIVIDEND | DELETE | 878520204 | 0 | 0 | 1 | 5 | .063168 | 19 | ? | 2017-06-20 | 2017-07-10 | 2017-03-03 | 0 | 2017-03-03 | ? | 0 | 0005400131 | 20170306.ifs | 2017-03-06 | 2017-03-07 | |||||||
2508171 | 2508171 | DIVIDEND | ADD | 878520204 | 0 | 0 | 1 | 5 | .063168 | 19 | 2017-06-16 | 2017-06-20 | 2017-07-10 | 2017-03-03 | 1 | 2017-03-03 | 2017-03-06 | 0 | 0005400131 | 20170306.ifs | 2017-03-06 | 2017-03-07 | |||||||
2507320 | 2507320 | DIVIDEND | ADD | 878520204 | 0 | 0 | 1 | 5 | .063168 | 19 | ? | 2017-06-20 | 2017-07-10 | 2017-03-03 | 0 | 2017-03-03 | ? | 0 | 0005400131 | 20170303.ifs | 2017-03-03 | 2017-03-04 | |||||||
2216188 | 2216188 | DIVIDEND | DELETE | 878520204 | 0 | 0 | 1 | 5 | .065922 | 19 | 2016-05-19 | 2016-05-23 | 2016-06-16 | 2016-02-26 | 0 | 2016-02-26 | ? | 0 | 0005176252 | 20160607.ifs | 2016-06-07 | 2016-06-08 | |||||||
2216189 | 2216189 | DIVIDEND | ADD | 878520204 | 0 | 0 | 1 | 0 | .067034 | 00 | 2016-05-19 | 2016-05-23 | 2016-06-16 | 2016-02-26 | 1 | 2016-02-26 | 2016-06-07 | 0 | 0005176252 | 20160607.ifs | 2016-06-07 | 2016-06-08 | |||||||
2120045 | 2120045 | DIVIDEND | ADD | 878520204 | 0 | 0 | 1 | 5 | .065922 | 19 | 2016-05-19 | 2016-05-23 | 2016-06-16 | 2016-02-26 | 0 | 2016-02-26 | ? | 0 | 0005176252 | 20160226.ifs | 2016-02-26 | 2016-02-27 | |||||||
2003707 | 2003707 | DIVIDEND | CHANGE | 878520204 | 6 | 0 | 1 | 9 | .254632 | 25 | 2015-11-10 | 2015-11-13 | 2015-11-23 | 2015-11-03 | 0 | 2015-11-03 | ? | 0 | 0005090247 | 20151104.ifs | 2015-11-04 | 2015-11-05 | |||||||
2003708 | 2003707 | DIVIDEND | CHANGE | 878520204 | 6 | 0 | 1 | 9 | .254632 | 25 | 2015-11-10 | 2015-11-13 | 2015-11-23 | 2015-11-03 | 1 | 2015-11-03 | 2015-11-04 | 0 | 0005090247 | 20151104.ifs | 2015-11-04 | 2015-11-05 | |||||||
1876265 | 1876265 | DIVIDEND | DELETE | 878520204 | 0 | 0 | 1 | 5 | .05429 | 0 | 19 | 2015-05-15 | 2015-05-19 | 2015-06-12 | 2015-04-27 | 0 | ? | 2015-04-28 | 0 | 0004989515 | 20150601.ifs | 2015-06-01 | 2015-06-02 | ||||||
1876266 | 1876266 | DIVIDEND | ADD | 878520204 | 0 | 0 | 1 | 0 | .055284 | 0 | 00 | 2015-05-15 | 2015-05-19 | 2015-06-12 | 2015-04-27 | 0 | ? | 2015-06-01 | 0 | 0004989515 | 20150601.ifs | 2015-06-01 | 2015-06-02 | ||||||
1848417 | 1848417 | DIVIDEND | DELETE | 878520204 | 0 | 0 | 1 | 5 | .05429 | 19 | ? | 2015-05-19 | 2015-06-12 | 2015-04-27 | 0 | 2015-04-27 | ? | 0 | 0004989515 | 20150428.ifs | 2015-04-28 | 2015-04-29 | |||||||
1848418 | 1848418 | DIVIDEND | ADD | 878520204 | 0 | 0 | 1 | 5 | .05429 | 0 | 19 | 2015-05-15 | 2015-05-19 | 2015-06-12 | 2015-04-27 | 0 | ? | 2015-04-28 | 0 | 0004989515 | 20150428.ifs | 2015-04-28 | 2015-04-29 | ||||||
1848737 | 1848737 | DIVIDEND | CHANGE | 878520204 | 0 | 0 | 1 | 5 | .05429 | 0 | 19 | 2015-05-15 | 2015-05-19 | 2015-06-12 | 2015-04-27 | 0 | ? | 2015-04-28 | 0 | 0004989515 | 20150428.ifs | 2015-04-28 | 2015-04-29 | ||||||
1848738 | 1848737 | DIVIDEND | CHANGE | 878520204 | 0 | 0 | 1 | 5 | .05429 | 0 | 19 | 2015-05-15 | 2015-05-19 | 2015-06-12 | 2015-04-27 | 0 | ? | 2015-04-28 | 0 | 0004989515 | 20150428.ifs | 2015-04-28 | 2015-04-29 | ||||||
1847968 | 1847968 | DIVIDEND | ADD | 878520204 | 0 | 0 | 1 | 5 | .05429 | 19 | ? | 2015-05-19 | 2015-06-12 | 2015-04-27 | 0 | 2015-04-27 | ? | 0 | 0004989515 | 20150427.ifs | 2015-04-27 | 2015-04-28 | |||||||
922682 | 922682 | DIVIDEND | DELETE | 878520204 | 6 | 0 | 1 | 9 | .037264 | 25 | ? | 2012-08-06 | 2012-08-16 | 2012-07-27 | 0 | 2012-07-27 | ? | 0 | 0004405939 | 20120730.ifs | 2012-07-30 | 2012-07-31 | |||||||
922683 | 922683 | DIVIDEND | ADD | 878520204 | 6 | 0 | 1 | 9 | .037264 | 25 | 2012-08-02 | 2012-08-06 | 2012-08-16 | 2012-07-27 | 1 | 2012-07-27 | 2012-07-30 | 0 | 0004405939 | 20120730.ifs | 2012-07-30 | 2012-07-31 | |||||||
476776 | 476776 | CORPACTION | ADD | 878520204 | 01 | X | 2011-03-22 | 878520204 | 66 | ? | 20110322.ifs | 2011-03-22 | 2011-03-23 | ||||||||||||||||
476777 | 476777 | EXCHANGE | ADD | 878520204 | 66 | 2011-03-22 | 2011-03-22 | TCLRY | 0 | 0 | 2011-03-22 | ? | 20110322.ifs | 2011-03-22 | 2011-03-23 | ||||||||||||||
250594 | 250594 | EQUITY | ADD | 878520204 | NEW ISSUE | 0 | 0 | 2010-07-15 | ? | 0 | no | no | no | ? | ? | ? | 20100715.ifs | 2010-07-15 | 2010-07-16 | ||||||||||
250595 | 250595 | EQUITY | CHANGE | 878520204 | NEW ISSUE | 0 | 0 | 2010-07-15 | ? | 0 | no | no | no | ? | ? | ? | 20100715.ifs | 2010-07-15 | 2010-07-16 | ||||||||||
250596 | 250595 | EQUITY | CHANGE | 878520204 | SPONSORED ADR NEW | N | 0 | 2010-07-15 | ? | 0 | no | no | no | ? | 2010-07-15 | ? | 20100715.ifs | 2010-07-15 | 2010-07-16 | ||||||||||
250597 | 250597 | EXCHANGE | ADD | 878520204 | 01 | 2010-07-15 | 2010-07-15 | TCH | 0 | 0 | ? | 2010-07-15 | 20100715.ifs | 2010-07-15 | 2010-07-16 | ||||||||||||||
250602 | 250602 | SPLIT | ADD | 878520204 | 10 | 2010-07-15 | 54 | ? | 2010-07-15 | 20100715.ifs | 2010-07-15 | 2010-07-16 | |||||||||||||||||
250604 | 250604 | DIVIDEND | ADD | 878520204 | 0 | 0 | 6 | 0 | .1 | 0 | 54 | 2010-07-15 | 2010-07-15 | 2010-07-15 | 2010-07-15 | 0 | ? | 2010-07-15 | 0 | 0004032723 | 20100715.ifs | 2010-07-15 | 2010-07-16 | ||||||
252209 | 252209 | EQUITY | CHANGE | 878520204 | SPONSORED ADR NEW | N | 0 | 2010-07-15 | ? | 0 | no | no | no | ? | 2010-07-15 | ? | 20100715.ifs | 2010-07-15 | 2010-07-16 | ||||||||||
252210 | 252209 | EQUITY | CHANGE | 878520204 | SPONSORED ADR NEW | 0 | 0 | 2010-07-15 | ? | 0 | no | no | no | ? | 2010-07-15 | ? | 20100715.ifs | 2010-07-15 | 2010-07-16 |
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 = 139545
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