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:136702 |
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 | ||
2688736 | 2688736 | CORPACTION | ADD | 868607102 | 02 | D | 2017-09-27 | 2017-09-27 | 20170927.ifs | 2017-09-27 | 2017-09-28 | ||||||||||||||||||
2688738 | 2688738 | EQUITY | CHANGE | 868607102 | CL A | 0 | 0 | 1993-07-02 | ? | 4 | yes | no | no | 1997-03-31 | 2016-07-07 | ? | 20170927.ifs | 2017-09-27 | 2017-09-28 | ||||||||||
2688740 | 2688739 | EQUITY | CHANGE | 868607102 | CL A | D | 0 | 1993-07-02 | 2017-09-27 | 4 | yes | no | no | 1997-03-31 | 2017-09-27 | ? | 20170927.ifs | 2017-09-27 | 2017-09-28 | ||||||||||
2689078 | 2689078 | DIVIDEND | CHANGE | 868607102 | 0 | 0 | 1 | 0 | .035 | 00 | 2017-08-24 | 2017-08-28 | 2017-09-05 | 2017-08-14 | 0 | 2017-08-14 | ? | 0 | 0005482811 | 20170927.ifs | 2017-09-27 | 2017-09-28 | |||||||
2689080 | 2689079 | DIVIDEND | CHANGE | 868607102 | 0 | 0 | 1 | 0 | .035 | 00 | 2017-08-24 | 2017-08-28 | 2017-09-05 | 2017-08-14 | 1 | 2017-08-14 | 2017-09-27 | 0 | 0005482811 | 20170927.ifs | 2017-09-27 | 2017-09-28 | |||||||
2689085 | 2689085 | CORPACTION | ADD | 868607102 | 02 | D | 2017-09-27 | 2017-09-27 | 20170927.ifs | 2017-09-27 | 2017-09-28 | ||||||||||||||||||
2689087 | 2689087 | EQUITY | CHANGE | 868607102 | CL A | 0 | 0 | 1993-07-02 | ? | 4 | yes | no | no | 1997-03-31 | 2016-07-07 | ? | 20170927.ifs | 2017-09-27 | 2017-09-28 | ||||||||||
2689088 | 2689087 | EQUITY | CHANGE | 868607102 | CL A | D | 0 | 1993-07-02 | 2017-09-27 | 4 | yes | no | no | 1997-03-31 | 2017-09-27 | ? | 20170927.ifs | 2017-09-27 | 2017-09-28 | ||||||||||
2689423 | 2689423 | DIVIDEND | CHANGE | 868607102 | 0 | 0 | 1 | 0 | .035 | 00 | 2017-08-24 | 2017-08-28 | 2017-09-05 | 2017-08-14 | 0 | 2017-08-14 | ? | 0 | 0005482811 | 20170927.ifs | 2017-09-27 | 2017-09-28 | |||||||
2689425 | 2689424 | DIVIDEND | CHANGE | 868607102 | 0 | 0 | 1 | 0 | .035 | 00 | 2017-08-24 | 2017-08-28 | 2017-09-05 | 2017-08-14 | 1 | 2017-08-14 | 2017-09-27 | 0 | 0005482811 | 20170927.ifs | 2017-09-27 | 2017-09-28 | |||||||
2649293 | 2649293 | DIVIDEND | ADD | 868607102 | 0 | 0 | 1 | 0 | .035 | 00 | 2017-08-24 | 2017-08-28 | 2017-09-05 | 2017-08-14 | 0 | 2017-08-14 | ? | 0 | 0005482811 | 20170814.ifs | 2017-08-14 | 2017-08-15 | |||||||
2647042 | 2647042 | DIVIDEND | CHANGE | 868607102 | 0 | 0 | 1 | 0 | .035 | 00 | 2017-06-12 | 2017-06-14 | 2017-06-21 | 2017-05-30 | 0 | 2017-05-30 | ? | 0 | 0005438664 | 20170810.ifs | 2017-08-10 | 2017-08-11 | |||||||
2647043 | 2647042 | DIVIDEND | CHANGE | 868607102 | 0 | 0 | 1 | 0 | .035 | 00 | 2017-06-12 | 2017-06-14 | 2017-06-21 | 2017-05-30 | 1 | 2017-05-30 | 2017-08-10 | 0 | 0005438664 | 20170810.ifs | 2017-08-10 | 2017-08-11 | |||||||
2575611 | 2575611 | DIVIDEND | ADD | 868607102 | 0 | 0 | 1 | 0 | .035 | 00 | 2017-06-12 | 2017-06-14 | 2017-06-21 | 2017-05-30 | 0 | 2017-05-30 | ? | 0 | 0005438664 | 20170530.ifs | 2017-05-30 | 2017-05-31 | |||||||
2509947 | 2509947 | DIVIDEND | ADD | 868607102 | 0 | 0 | 1 | 0 | .035 | 00 | 2017-03-21 | 2017-03-23 | 2017-03-30 | 2017-03-09 | 0 | 2017-03-09 | ? | 0 | 0005401123 | 20170309.ifs | 2017-03-09 | 2017-03-10 | |||||||
2344869 | 2344869 | DIVIDEND | ADD | 868607102 | 0 | 0 | 1 | 9 | .265 | 03 | 2016-12-08 | 2016-12-12 | 2017-01-03 | 2016-11-17 | 0 | 2016-11-17 | ? | 1 | 0005311933 | 20161117.ifs | 2016-11-17 | 2016-11-18 | |||||||
2344870 | 2344870 | DIVIDEND | ADD | 868607102 | 0 | 0 | 1 | 0 | .035 | 00 | 2016-12-08 | 2016-12-12 | 2017-01-03 | 2016-11-17 | 0 | 2016-11-17 | ? | 0 | 0005311932 | 20161117.ifs | 2016-11-17 | 2016-11-18 | |||||||
2268917 | 2268917 | DIVIDEND | ADD | 868607102 | 0 | 0 | 1 | 0 | .035 | 00 | 2016-08-22 | 2016-08-24 | 2016-08-31 | 2016-08-10 | 0 | 2016-08-10 | ? | 0 | 0005264910 | 20160810.ifs | 2016-08-10 | 2016-08-11 | |||||||
2247284 | 2247284 | EQUITY | CHANGE | 868607102 | CL A | 0 | 0 | 1993-07-02 | ? | 8 | yes | no | no | 1997-03-31 | ? | ? | 20160707.ifs | 2016-07-07 | 2016-07-08 | ||||||||||
2247285 | 2247284 | EQUITY | CHANGE | 868607102 | CL A | 0 | 0 | 1993-07-02 | ? | 4 | yes | no | no | 1997-03-31 | 2016-07-07 | ? | 20160707.ifs | 2016-07-07 | 2016-07-08 | ||||||||||
2203758 | 2203758 | DIVIDEND | ADD | 868607102 | 0 | 0 | 1 | 0 | .035 | 00 | 2016-06-07 | 2016-06-09 | 2016-06-16 | 2016-05-26 | 0 | 2016-05-26 | ? | 0 | 0005222358 | 20160526.ifs | 2016-05-26 | 2016-05-27 | |||||||
2129165 | 2129165 | DIVIDEND | ADD | 868607102 | 0 | 0 | 1 | 0 | .03 | 00 | 2016-03-14 | 2016-03-16 | 2016-03-23 | 2016-03-02 | 0 | 2016-03-02 | ? | 2 | 0005183944 | 20160302.ifs | 2016-03-02 | 2016-03-03 | |||||||
2129166 | 2129166 | DIVIDEND | DELETE | 868607102 | 0 | 0 | 1 | 9 | .27 | 03 | 2015-12-09 | 2015-12-11 | 2015-01-04 | 2015-11-19 | 0 | 2015-11-19 | ? | 1 | 0005094748 | 20160302.ifs | 2016-03-02 | 2016-03-03 | |||||||
2129167 | 2129167 | DIVIDEND | ADD | 868607102 | 0 | 0 | 1 | 9 | .27 | 03 | 2015-12-09 | 2015-12-11 | 2016-01-04 | 2015-11-19 | 1 | 2015-11-19 | 2016-03-02 | 1 | 0005094748 | 20160302.ifs | 2016-03-02 | 2016-03-03 | |||||||
2129168 | 2129168 | DIVIDEND | DELETE | 868607102 | 0 | 0 | 1 | 0 | .03 | 00 | 2015-12-09 | 2015-12-11 | 2015-01-04 | 2015-11-19 | 0 | 2015-11-19 | ? | 0 | 0005094731 | 20160302.ifs | 2016-03-02 | 2016-03-03 | |||||||
2129169 | 2129169 | DIVIDEND | ADD | 868607102 | 0 | 0 | 1 | 0 | .03 | 00 | 2015-12-09 | 2015-12-11 | 2016-01-04 | 2015-11-19 | 1 | 2015-11-19 | 2016-03-02 | 0 | 0005094731 | 20160302.ifs | 2016-03-02 | 2016-03-03 | |||||||
2011787 | 2011787 | DIVIDEND | ADD | 868607102 | 0 | 0 | 1 | 9 | .27 | 03 | 2015-12-09 | 2015-12-11 | 2015-01-04 | 2015-11-19 | 0 | 2015-11-19 | ? | 1 | 0005094748 | 20151119.ifs | 2015-11-19 | 2015-11-20 | |||||||
2011788 | 2011788 | DIVIDEND | ADD | 868607102 | 0 | 0 | 1 | 0 | .03 | 00 | 2015-12-09 | 2015-12-11 | 2015-01-04 | 2015-11-19 | 0 | 2015-11-19 | ? | 0 | 0005094731 | 20151119.ifs | 2015-11-19 | 2015-11-20 | |||||||
1940538 | 1940538 | DIVIDEND | ADD | 868607102 | 0 | 0 | 1 | 0 | .03 | 00 | 2015-08-20 | 2015-08-24 | 2015-08-31 | 2015-08-13 | 0 | 2015-08-13 | ? | 0 | 0005047059 | 20150813.ifs | 2015-08-13 | 2015-08-14 | |||||||
1861905 | 1861905 | DIVIDEND | ADD | 868607102 | 0 | 0 | 1 | 0 | .03 | 00 | 2015-05-22 | 2015-05-27 | 2015-06-03 | 2015-05-12 | 0 | 2015-05-12 | ? | 0 | 0004999757 | 20150512.ifs | 2015-05-12 | 2015-05-13 | |||||||
1803991 | 1803991 | DIVIDEND | ADD | 868607102 | 0 | 0 | 1 | 0 | .025 | 00 | 2015-03-13 | 2015-03-17 | 2015-03-24 | 2015-03-03 | 0 | 2015-03-03 | ? | 0 | 0004965676 | 20150303.ifs | 2015-03-03 | 2015-03-04 | |||||||
1679035 | 1679035 | DIVIDEND | ADD | 868607102 | 0 | 0 | 1 | 0 | .025 | 00 | 2014-12-10 | 2014-12-12 | 2015-01-02 | 2014-11-11 | 0 | 2014-11-11 | ? | 0 | 0004872109 | 20141111.ifs | 2014-11-11 | 2014-11-12 | |||||||
1619817 | 1619817 | DIVIDEND | ADD | 868607102 | 0 | 0 | 1 | 0 | .025 | 35 | 2014-09-12 | 2014-09-16 | 2014-09-23 | 2014-09-02 | 0 | 2014-09-02 | ? | 0 | 0004835888 | 20140902.ifs | 2014-09-02 | 2014-09-03 | |||||||
1182176 | 1182176 | DIVIDEND | ADD | 868607102 | 0 | 0 | 5 | 0 | .05 | 10 | 2013-05-16 | 2013-05-20 | 2013-06-03 | 2013-05-08 | 0 | 2013-05-08 | ? | 0 | 0004570140 | 20130508.ifs | 2013-05-08 | 2013-05-09 | |||||||
1182177 | 1182177 | SPLIT | ADD | 868607102 | .9523809524 | 2013-05-16 | 10 | 2013-05-08 | ? | 20130508.ifs | 2013-05-08 | 2013-05-09 |
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 = 136702
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