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:139846 |
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 | ||
2259832 | 2259832 | EQUITY | CHANGE | 928856400 | ADR B | D | 0 | 1985-01-21 | 2016-01-08 | 8 | yes | yes | no | 2000-02-24 | 2016-01-08 | ? | 20160729.ifs | 2016-07-29 | 2016-07-30 | ||||||||||
2259833 | 2259832 | EQUITY | CHANGE | 928856400 | ADR B | D | 0 | 1985-01-21 | 2016-07-29 | 8 | yes | yes | no | 2000-02-24 | 2016-07-29 | ? | 20160729.ifs | 2016-07-29 | 2016-07-30 | ||||||||||
2089980 | 2089980 | CORPACTION | ADD | 928856400 | 66 | D | 2016-01-08 | ? | 20160108.ifs | 2016-01-08 | 2016-01-09 | ||||||||||||||||||
2089981 | 2089981 | EQUITY | CHANGE | 928856400 | ADR B | 0 | 0 | 1985-01-21 | ? | 8 | yes | yes | no | 2000-02-24 | 2007-12-13 | ? | 20160108.ifs | 2016-01-08 | 2016-01-09 | ||||||||||
2089982 | 2089981 | EQUITY | CHANGE | 928856400 | ADR B | D | 0 | 1985-01-21 | 2016-01-08 | 8 | yes | yes | no | 2000-02-24 | 2016-01-08 | ? | 20160108.ifs | 2016-01-08 | 2016-01-09 | ||||||||||
1841129 | 1841129 | DIVIDEND | CHANGE | 928856400 | 0 | 0 | 1 | 0 | .34033 | 0 | 00 | 2015-04-02 | 2015-04-07 | 2015-04-22 | 2015-03-02 | 0 | ? | 2015-04-15 | 0 | 0004964052 | 20150416.ifs | 2015-04-16 | 2015-04-17 | ||||||
1841130 | 1841129 | DIVIDEND | CHANGE | 928856400 | Ex-date corresponds with foreign ex-date. | 0 | 0 | 1 | 0 | .34033 | 0 | 00 | 2015-04-02 | 2015-04-07 | 2015-04-22 | 2015-03-02 | 0 | ? | 2015-04-16 | 0 | 0004964052 | 20150416.ifs | 2015-04-16 | 2015-04-17 | |||||
1840557 | 1840557 | DIVIDEND | DELETE | 928856400 | Ex-date corresponds with foreign ex-date. | 0 | 0 | 1 | 5 | .359625 | 0 | 19 | 2015-04-02 | 2015-04-07 | 2015-04-22 | 2015-03-02 | 0 | ? | 2015-04-14 | 0 | 0004964052 | 20150415.ifs | 2015-04-15 | 2015-04-16 | |||||
1840558 | 1840558 | DIVIDEND | ADD | 928856400 | 0 | 0 | 1 | 0 | .34033 | 0 | 00 | 2015-04-02 | 2015-04-07 | 2015-04-22 | 2015-03-02 | 0 | ? | 2015-04-15 | 0 | 0004964052 | 20150415.ifs | 2015-04-15 | 2015-04-16 | ||||||
1839527 | 1839527 | DIVIDEND | CHANGE | 928856400 | 0 | 0 | 1 | 5 | .359625 | 0 | 19 | 2015-04-02 | 2015-04-07 | 2015-04-22 | 2015-03-02 | 0 | ? | 2015-04-13 | 0 | 0004964052 | 20150414.ifs | 2015-04-14 | 2015-04-15 | ||||||
1839528 | 1839527 | DIVIDEND | CHANGE | 928856400 | Ex-date corresponds with foreign ex-date. | 0 | 0 | 1 | 5 | .359625 | 0 | 19 | 2015-04-02 | 2015-04-07 | 2015-04-22 | 2015-03-02 | 0 | ? | 2015-04-14 | 0 | 0004964052 | 20150414.ifs | 2015-04-14 | 2015-04-15 | |||||
1839231 | 1839231 | DIVIDEND | DELETE | 928856400 | 0 | 0 | 1 | 5 | .359625 | 0 | 19 | 2015-04-02 | 2015-04-07 | 2015-04-17 | 2015-03-02 | 0 | ? | 2015-03-03 | 0 | 0004964052 | 20150413.ifs | 2015-04-13 | 2015-04-14 | ||||||
1839232 | 1839232 | DIVIDEND | ADD | 928856400 | 0 | 0 | 1 | 5 | .359625 | 0 | 19 | 2015-04-02 | 2015-04-07 | 2015-04-22 | 2015-03-02 | 0 | ? | 2015-04-13 | 0 | 0004964052 | 20150413.ifs | 2015-04-13 | 2015-04-14 | ||||||
1803717 | 1803717 | DIVIDEND | DELETE | 928856400 | 0 | 0 | 1 | 5 | .359625 | 19 | ? | 2015-04-07 | 2015-04-17 | 2015-03-02 | 0 | 2015-03-02 | ? | 0 | 0004964052 | 20150303.ifs | 2015-03-03 | 2015-03-04 | |||||||
1803718 | 1803718 | DIVIDEND | ADD | 928856400 | 0 | 0 | 1 | 5 | .359625 | 0 | 19 | 2015-04-02 | 2015-04-07 | 2015-04-17 | 2015-03-02 | 0 | ? | 2015-03-03 | 0 | 0004964052 | 20150303.ifs | 2015-03-03 | 2015-03-04 | ||||||
1803719 | 1803719 | DIVIDEND | CHANGE | 928856400 | 0 | 0 | 1 | 5 | .359625 | 0 | 19 | 2015-04-02 | 2015-04-07 | 2015-04-17 | 2015-03-02 | 0 | ? | 2015-03-03 | 0 | 0004964052 | 20150303.ifs | 2015-03-03 | 2015-03-04 | ||||||
1803720 | 1803719 | DIVIDEND | CHANGE | 928856400 | Ex-date corresponds with foreign ex-date. | 0 | 0 | 1 | 5 | .359625 | 0 | 19 | 2015-04-02 | 2015-04-07 | 2015-04-17 | 2015-03-02 | 0 | ? | 2015-03-03 | 0 | 0004964052 | 20150303.ifs | 2015-03-03 | 2015-03-04 | |||||
1803953 | 1803953 | DIVIDEND | CHANGE | 928856400 | Ex-date corresponds with foreign ex-date. | 0 | 0 | 1 | 5 | .359625 | 0 | 19 | 2015-04-02 | 2015-04-07 | 2015-04-17 | 2015-03-02 | 0 | ? | 2015-03-03 | 0 | 0004964052 | 20150303.ifs | 2015-03-03 | 2015-03-04 | |||||
1803954 | 1803953 | DIVIDEND | CHANGE | 928856400 | 0 | 0 | 1 | 5 | .359625 | 0 | 19 | 2015-04-02 | 2015-04-07 | 2015-04-17 | 2015-03-02 | 0 | ? | 2015-03-03 | 0 | 0004964052 | 20150303.ifs | 2015-03-03 | 2015-03-04 | ||||||
1800545 | 1800545 | DIVIDEND | ADD | 928856400 | 0 | 0 | 1 | 5 | .359625 | 19 | ? | 2015-04-07 | 2015-04-17 | 2015-03-02 | 0 | 2015-03-02 | ? | 0 | 0004964052 | 20150302.ifs | 2015-03-02 | 2015-03-03 | |||||||
1494584 | 1494584 | DIVIDEND | CHANGE | 928856400 | 0 | 0 | 1 | 0 | .459031 | 00 | 2014-04-03 | 2014-04-07 | 2014-04-17 | 2014-02-20 | 2 | 2014-02-20 | 2014-04-10 | 0 | 0004738298 | 20140411.ifs | 2014-04-11 | 2014-04-12 | |||||||
1494585 | 1494584 | DIVIDEND | CHANGE | 928856400 | Ex-date corresponds with foreign ex-date. | 0 | 0 | 1 | 0 | .459031 | 0 | 00 | 2014-04-03 | 2014-04-07 | 2014-04-17 | 2014-02-20 | 2 | 2014-02-20 | 2014-04-11 | 0 | 0004738298 | 20140411.ifs | 2014-04-11 | 2014-04-12 | |||||
1494304 | 1494304 | DIVIDEND | DELETE | 928856400 | 0 | 0 | 1 | 5 | .458036 | 19 | 2014-04-03 | 2014-04-07 | ? | 2014-02-20 | 1 | 2014-02-20 | 2014-02-21 | 0 | 0004738298 | 20140410.ifs | 2014-04-10 | 2014-04-11 | |||||||
1494305 | 1494305 | DIVIDEND | ADD | 928856400 | 0 | 0 | 1 | 0 | .459031 | 00 | 2014-04-03 | 2014-04-07 | 2014-04-17 | 2014-02-20 | 2 | 2014-02-20 | 2014-04-10 | 0 | 0004738298 | 20140410.ifs | 2014-04-10 | 2014-04-11 | |||||||
1447698 | 1447698 | DIVIDEND | DELETE | 928856400 | 0 | 0 | 1 | 5 | .458036 | 19 | ? | 2014-04-07 | ? | 2014-02-20 | 0 | 2014-02-20 | ? | 0 | 0004738298 | 20140221.ifs | 2014-02-21 | 2014-02-22 | |||||||
1447699 | 1447699 | DIVIDEND | ADD | 928856400 | 0 | 0 | 1 | 5 | .458036 | 19 | 2014-04-03 | 2014-04-07 | ? | 2014-02-20 | 1 | 2014-02-20 | 2014-02-21 | 0 | 0004738298 | 20140221.ifs | 2014-02-21 | 2014-02-22 | |||||||
1446777 | 1446777 | DIVIDEND | ADD | 928856400 | 0 | 0 | 1 | 5 | .458036 | 19 | ? | 2014-04-07 | ? | 2014-02-20 | 0 | 2014-02-20 | ? | 0 | 0004738298 | 20140220.ifs | 2014-02-20 | 2014-02-21 | |||||||
1159093 | 1159093 | DIVIDEND | DELETE | 928856400 | 0 | 0 | 1 | 5 | .47224 | 19 | 2013-04-05 | 2013-04-09 | ? | 2013-02-06 | 1 | 2013-02-06 | 2013-02-07 | 0 | 0004526510 | 20130412.ifs | 2013-04-12 | 2013-04-13 | |||||||
1159094 | 1159094 | DIVIDEND | ADD | 928856400 | 0 | 0 | 1 | 0 | .46963 | 00 | 2013-04-05 | 2013-04-09 | 2013-04-19 | 2013-02-06 | 2 | 2013-02-06 | 2013-04-12 | 0 | 0004526510 | 20130412.ifs | 2013-04-12 | 2013-04-13 | |||||||
1109502 | 1109502 | DIVIDEND | DELETE | 928856400 | 0 | 0 | 1 | 5 | .47224 | 19 | ? | 2013-04-09 | ? | 2013-02-06 | 0 | 2013-02-06 | ? | 0 | 0004526510 | 20130207.ifs | 2013-02-07 | 2013-02-08 | |||||||
1109503 | 1109503 | DIVIDEND | ADD | 928856400 | 0 | 0 | 1 | 5 | .47224 | 19 | 2013-04-05 | 2013-04-09 | ? | 2013-02-06 | 1 | 2013-02-06 | 2013-02-07 | 0 | 0004526510 | 20130207.ifs | 2013-02-07 | 2013-02-08 | |||||||
1108898 | 1108898 | DIVIDEND | ADD | 928856400 | 0 | 0 | 1 | 5 | .47224 | 19 | ? | 2013-04-09 | ? | 2013-02-06 | 0 | 2013-02-06 | ? | 0 | 0004526510 | 20130206.ifs | 2013-02-06 | 2013-02-07 | |||||||
878223 | 878223 | DIVIDEND | CHANGE | 928856400 | 0 | 0 | 1 | 0 | .444095 | 00 | 2012-04-09 | 2012-04-11 | 2012-04-26 | 2012-03-22 | 1 | 2012-03-22 | 2012-04-19 | 0 | 0004348510 | 20120604.ifs | 2012-06-04 | 2012-06-05 | |||||||
878224 | 878223 | DIVIDEND | CHANGE | 928856400 | 0 | 0 | 1 | 0 | .444095 | 00 | 2012-04-09 | 2012-04-11 | 2012-04-26 | 2012-03-22 | 1 | 2012-03-22 | 2012-04-19 | 0 | 0004348510 | 20120604.ifs | 2012-06-04 | 2012-06-05 | |||||||
838666 | 838666 | DIVIDEND | DELETE | 928856400 | 0 | 0 | 1 | 5 | .444952 | 19 | 2012-04-09 | 2012-04-11 | ? | 2012-03-22 | 0 | 2012-03-22 | ? | 0 | 0004348510 | 20120419.ifs | 2012-04-19 | 2012-04-20 | |||||||
838667 | 838667 | DIVIDEND | ADD | 928856400 | 0 | 0 | 1 | 0 | .444095 | 00 | 2012-04-09 | 2012-04-11 | 2012-04-26 | 2012-03-22 | 1 | 2012-03-22 | 2012-04-19 | 0 | 0004348510 | 20120419.ifs | 2012-04-19 | 2012-04-20 | |||||||
807833 | 807833 | DIVIDEND | ADD | 928856400 | 0 | 0 | 1 | 5 | .444952 | 19 | 2012-04-09 | 2012-04-11 | ? | 2012-03-22 | 0 | 2012-03-22 | ? | 0 | 0004348510 | 20120322.ifs | 2012-03-22 | 2012-03-23 | |||||||
511236 | 511236 | DIVIDEND | CHANGE | 928856400 | 0 | 0 | 1 | 0 | .414449 | 00 | 2011-04-07 | 2011-04-11 | 2011-05-05 | 2011-02-28 | 2 | 2011-02-28 | 2011-04-28 | 0 | 0004150454 | 20110429.ifs | 2011-04-29 | 2011-04-30 | |||||||
511237 | 511236 | DIVIDEND | CHANGE | 928856400 | Ex-date corresponds with foreign ex-date. | 0 | 0 | 1 | 0 | .414449 | 0 | 00 | 2011-04-07 | 2011-04-11 | 2011-05-05 | 2011-02-28 | 2 | 2011-02-28 | 2011-04-29 | 0 | 0004150454 | 20110429.ifs | 2011-04-29 | 2011-04-30 | |||||
510575 | 510575 | DIVIDEND | DELETE | 928856400 | 0 | 0 | 1 | 5 | .396366 | 19 | 2011-04-07 | 2011-04-11 | ? | 2011-02-28 | 1 | 2011-02-28 | 2011-03-01 | 0 | 0004150454 | 20110428.ifs | 2011-04-28 | 2011-04-29 | |||||||
510576 | 510576 | DIVIDEND | ADD | 928856400 | 0 | 0 | 1 | 0 | .414449 | 00 | 2011-04-07 | 2011-04-11 | 2011-05-05 | 2011-02-28 | 2 | 2011-02-28 | 2011-04-28 | 0 | 0004150454 | 20110428.ifs | 2011-04-28 | 2011-04-29 | |||||||
458128 | 458128 | DIVIDEND | DELETE | 928856400 | 0 | 0 | 1 | 5 | .396366 | 19 | ? | 2011-04-11 | ? | 2011-02-28 | 0 | 2011-02-28 | ? | 0 | 0004150454 | 20110301.ifs | 2011-03-01 | 2011-03-02 | |||||||
458129 | 458129 | DIVIDEND | ADD | 928856400 | 0 | 0 | 1 | 5 | .396366 | 19 | 2011-04-07 | 2011-04-11 | ? | 2011-02-28 | 1 | 2011-02-28 | 2011-03-01 | 0 | 0004150454 | 20110301.ifs | 2011-03-01 | 2011-03-02 | |||||||
454175 | 454175 | DIVIDEND | ADD | 928856400 | 0 | 0 | 1 | 5 | .396366 | 19 | ? | 2011-04-11 | ? | 2011-02-28 | 0 | 2011-02-28 | ? | 0 | 0004150454 | 20110228.ifs | 2011-02-28 | 2011-03-01 | |||||||
331420 | 331420 | DIVIDEND | ADD | 928856400 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2010-04-23 | 2010-10-07 | 0 | 2010-10-07 | ? | 0 | 0004074138 | 20101007.ifs | 2010-10-07 | 2010-10-08 |
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 = 139846
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