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:159751 |
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 | ||
3974554 | 3974554 | CORPACTION | ADD | 36863N208 | 66 | D | 2019-10-16 | ? | 20191016.ifs | 2019-10-16 | 2019-10-17 | ||||||||||||||||||
3974555 | 3974555 | CORPACTION | ADD | 36863N208 | 66 | D | 2019-10-16 | ? | 20191016.ifs | 2019-10-16 | 2019-10-17 | ||||||||||||||||||
3974556 | 3974556 | EQUITY | CHANGE | 36863N208 | SPONSORED ADR | 0 | 0 | 2009-11-19 | ? | 1 | no | no | no | ? | 2011-03-14 | ? | 20191016.ifs | 2019-10-16 | 2019-10-17 | ||||||||||
3974557 | 3974557 | EQUITY | CHANGE | 36863N208 | SPONSORED ADR | 0 | 0 | 2009-11-19 | ? | 1 | no | no | no | ? | 2011-03-14 | ? | 20191016.ifs | 2019-10-16 | 2019-10-17 | ||||||||||
3974558 | 3974557 | EQUITY | CHANGE | 36863N208 | SPONSORED ADR | D | 0 | 2009-11-19 | 2019-10-16 | 1 | no | no | no | ? | 2019-10-16 | ? | 20191016.ifs | 2019-10-16 | 2019-10-17 | ||||||||||
3974559 | 3974558 | EQUITY | CHANGE | 36863N208 | SPONSORED ADR | D | 0 | 2009-11-19 | 2019-10-16 | 1 | no | no | no | ? | 2019-10-16 | ? | 20191016.ifs | 2019-10-16 | 2019-10-17 | ||||||||||
3781373 | 3781373 | DIVIDEND | CHANGE | 36863N208 | B | 0 | 1 | 0 | .217859 | 02 | 2017-05-19 | 2017-05-23 | 2017-06-01 | 2017-05-12 | 1 | 2017-05-12 | 2017-05-26 | 0 | 0005434848 | 20190614.ifs | 2019-06-14 | 2019-06-15 | |||||||
3781374 | 3781373 | DIVIDEND | CHANGE | 36863N208 | B | 0 | 1 | 0 | .217859 | 02 | 2017-05-19 | 2017-05-23 | 2017-06-01 | 2017-05-12 | 2 | 2017-05-12 | 2019-06-14 | 0 | 0005434848 | 20190614.ifs | 2019-06-14 | 2019-06-15 | |||||||
3781389 | 3781389 | DIVIDEND | CHANGE | 36863N208 | B | 0 | 1 | 0 | .217859 | 02 | 2017-05-19 | 2017-05-23 | 2017-06-01 | 2017-05-12 | 1 | 2017-05-12 | 2017-05-26 | 0 | 0005434848 | 20190614.ifs | 2019-06-14 | 2019-06-15 | |||||||
3781390 | 3781389 | DIVIDEND | CHANGE | 36863N208 | B | 0 | 1 | 0 | .217859 | 02 | 2017-05-19 | 2017-05-23 | 2017-06-01 | 2017-05-12 | 2 | 2017-05-12 | 2019-06-14 | 0 | 0005434848 | 20190614.ifs | 2019-06-14 | 2019-06-15 | |||||||
2574986 | 2574986 | DIVIDEND | DELETE | 36863N208 | B | 0 | 1 | 5 | .211625 | 39 | 2017-05-19 | 2017-05-23 | 2017-06-01 | 2017-05-12 | 0 | 2017-05-12 | ? | 0 | 0005434848 | 20170526.ifs | 2017-05-26 | 2017-05-27 | |||||||
2574987 | 2574987 | DIVIDEND | ADD | 36863N208 | B | 0 | 1 | 0 | .217859 | 02 | 2017-05-19 | 2017-05-23 | 2017-06-01 | 2017-05-12 | 1 | 2017-05-12 | 2017-05-26 | 0 | 0005434848 | 20170526.ifs | 2017-05-26 | 2017-05-27 | |||||||
2566610 | 2566610 | DIVIDEND | ADD | 36863N208 | B | 0 | 1 | 5 | .211625 | 39 | 2017-05-19 | 2017-05-23 | 2017-06-01 | 2017-05-12 | 0 | 2017-05-12 | ? | 0 | 0005434848 | 20170512.ifs | 2017-05-12 | 2017-05-13 | |||||||
2204931 | 2204931 | DIVIDEND | DELETE | 36863N208 | B | 0 | 1 | 5 | .199375 | 39 | 2016-05-23 | 2016-05-25 | ? | 2016-03-08 | 0 | 2016-03-08 | ? | 0 | 0005185230 | 20160527.ifs | 2016-05-27 | 2016-05-28 | |||||||
2204932 | 2204932 | DIVIDEND | ADD | 36863N208 | B | 0 | 1 | 0 | .203372 | 02 | 2016-05-23 | 2016-05-25 | 2016-06-03 | 2016-03-08 | 1 | 2016-03-08 | 2016-05-27 | 0 | 0005185230 | 20160527.ifs | 2016-05-27 | 2016-05-28 | |||||||
2131857 | 2131857 | DIVIDEND | ADD | 36863N208 | B | 0 | 1 | 5 | .199375 | 39 | 2016-05-23 | 2016-05-25 | ? | 2016-03-08 | 0 | 2016-03-08 | ? | 0 | 0005185230 | 20160308.ifs | 2016-03-08 | 2016-03-09 | |||||||
1882170 | 1882170 | DIVIDEND | DELETE | 36863N208 | B | 0 | 1 | 5 | .1703 | 39 | 2015-05-22 | 2015-05-27 | ? | 2015-03-17 | 0 | 2015-03-17 | ? | 0 | 0004969206 | 20150604.ifs | 2015-06-04 | 2015-06-05 | |||||||
1882171 | 1882171 | DIVIDEND | ADD | 36863N208 | B | 0 | 1 | 0 | .1856 | 02 | 2015-05-22 | 2015-05-27 | 2015-06-08 | 2015-03-17 | 1 | 2015-03-17 | 2015-06-04 | 0 | 0004969206 | 20150604.ifs | 2015-06-04 | 2015-06-05 | |||||||
1814245 | 1814245 | DIVIDEND | ADD | 36863N208 | B | 0 | 1 | 5 | .1703 | 39 | 2015-05-22 | 2015-05-27 | ? | 2015-03-17 | 0 | 2015-03-17 | ? | 0 | 0004969206 | 20150317.ifs | 2015-03-17 | 2015-03-18 | |||||||
1536560 | 1536560 | DIVIDEND | DELETE | 36863N208 | B | 1 | 0 | .2027 | 02 | 2014-05-22 | 2014-05-27 | 2014-06-05 | ? | 0 | 2014-05-30 | ? | 0 | 0004749547 | 20140602.ifs | 2014-06-02 | 2014-06-03 | ||||||||
1536561 | 1536561 | DIVIDEND | ADD | 36863N208 | B | 0 | 1 | 0 | .2027 | 0 | 02 | 2014-05-22 | 2014-05-27 | 2014-06-05 | 2014-03-11 | 0 | ? | 2014-06-02 | 0 | 0004749547 | 20140602.ifs | 2014-06-02 | 2014-06-03 | ||||||
1535273 | 1535273 | DIVIDEND | ADD | 36863N208 | B | 1 | 0 | .2027 | 02 | 2014-05-22 | 2014-05-27 | 2014-06-05 | ? | 0 | 2014-05-30 | ? | 0 | 0004749547 | 20140530.ifs | 2014-05-30 | 2014-05-31 | ||||||||
1199647 | 1199647 | DIVIDEND | DELETE | 36863N208 | B | 1 | 0 | .1734 | 02 | 2013-05-24 | 2013-05-29 | 2013-06-06 | ? | 0 | 2013-05-31 | ? | 0 | 0004557145 | 20130603.ifs | 2013-06-03 | 2013-06-04 | ||||||||
1199648 | 1199648 | DIVIDEND | ADD | 36863N208 | B | 0 | 1 | 0 | .1734 | 0 | 02 | 2013-05-24 | 2013-05-29 | 2013-06-06 | 2013-04-10 | 0 | ? | 2013-06-03 | 0 | 0004557145 | 20130603.ifs | 2013-06-03 | 2013-06-04 | ||||||
1198131 | 1198131 | DIVIDEND | ADD | 36863N208 | B | 1 | 0 | .1734 | 02 | 2013-05-24 | 2013-05-29 | 2013-06-06 | ? | 0 | 2013-05-31 | ? | 0 | 0004557145 | 20130531.ifs | 2013-05-31 | 2013-06-01 | ||||||||
880353 | 880353 | DIVIDEND | DELETE | 36863N208 | B | 1 | 0 | .1481 | 02 | 2012-05-25 | 2012-05-30 | 2012-06-07 | ? | 0 | 2012-06-05 | ? | 0 | 0004361740 | 20120606.ifs | 2012-06-06 | 2012-06-07 | ||||||||
880354 | 880354 | DIVIDEND | ADD | 36863N208 | B | 0 | 1 | 0 | .1481 | 0 | 02 | 2012-05-25 | 2012-05-30 | 2012-06-07 | 2012-04-16 | 0 | ? | 2012-06-06 | 0 | 0004361740 | 20120606.ifs | 2012-06-06 | 2012-06-07 | ||||||
880217 | 880217 | DIVIDEND | ADD | 36863N208 | B | 1 | 0 | .1481 | 02 | 2012-05-25 | 2012-05-30 | 2012-06-07 | ? | 0 | 2012-06-05 | ? | 0 | 0004361740 | 20120605.ifs | 2012-06-05 | 2012-06-06 | ||||||||
544114 | 544114 | DIVIDEND | DELETE | 36863N208 | B | 0 | 1 | 5 | .1499 | 0 | 39 | 2011-05-20 | 2011-05-24 | ? | 2011-03-11 | 0 | ? | 2011-05-19 | 0 | 0004159077 | 20110601.ifs | 2011-06-01 | 2011-06-02 | ||||||
544115 | 544115 | DIVIDEND | ADD | 36863N208 | B | 0 | 1 | 0 | .1527 | 0 | 02 | 2011-05-20 | 2011-05-24 | 2011-06-03 | 2011-03-11 | 0 | ? | 2011-06-01 | 0 | 0004159077 | 20110601.ifs | 2011-06-01 | 2011-06-02 | ||||||
529174 | 529174 | DIVIDEND | DELETE | 36863N208 | B | 1 | 5 | .1499 | 39 | 2011-05-20 | 2011-05-24 | ? | ? | 0 | 2011-05-18 | ? | 0 | 0004159077 | 20110519.ifs | 2011-05-19 | 2011-05-20 | ||||||||
529175 | 529175 | DIVIDEND | ADD | 36863N208 | B | 0 | 1 | 5 | .1499 | 0 | 39 | 2011-05-20 | 2011-05-24 | ? | 2011-03-11 | 0 | ? | 2011-05-19 | 0 | 0004159077 | 20110519.ifs | 2011-05-19 | 2011-05-20 | ||||||
528687 | 528687 | DIVIDEND | ADD | 36863N208 | B | 1 | 5 | .1499 | 39 | 2011-05-20 | 2011-05-24 | ? | ? | 0 | 2011-05-18 | ? | 0 | 0004159077 | 20110518.ifs | 2011-05-18 | 2011-05-19 | ||||||||
470490 | 470490 | EQUITY | CHANGE | 36863N208 | SPONSORED ADR | 0 | 0 | 2009-11-19 | ? | 0 | no | no | no | ? | 2010-06-03 | ? | 20110314.ifs | 2011-03-14 | 2011-03-15 | ||||||||||
470491 | 470490 | EQUITY | CHANGE | 36863N208 | SPONSORED ADR | 0 | 0 | 2009-11-19 | ? | 1 | no | no | no | ? | 2011-03-14 | ? | 20110314.ifs | 2011-03-14 | 2011-03-15 | ||||||||||
470492 | 470492 | DIVIDEND | DELETE | 36863N208 | B | 0 | 1 | 5 | .1499 | 39 | ? | 2011-05-24 | ? | 2011-03-11 | 0 | 2011-03-11 | ? | 0 | 0004159077 | 20110314.ifs | 2011-03-14 | 2011-03-15 | |||||||
470355 | 470355 | DIVIDEND | ADD | 36863N208 | B | 0 | 1 | 5 | .1499 | 39 | ? | 2011-05-24 | ? | 2011-03-11 | 0 | 2011-03-11 | ? | 0 | 0004159077 | 20110311.ifs | 2011-03-11 | 2011-03-12 | |||||||
212253 | 212253 | EQUITY | CHANGE | 36863N208 | SPONSORED ADR | N | 0 | 2009-11-19 | ? | 0 | no | no | no | ? | 2009-11-19 | ? | 20100603.ifs | 2010-06-03 | 2010-06-04 | ||||||||||
212254 | 212253 | EQUITY | CHANGE | 36863N208 | SPONSORED ADR | 0 | 0 | 2009-11-19 | ? | 0 | no | no | no | ? | 2010-06-03 | ? | 20100603.ifs | 2010-06-03 | 2010-06-04 | ||||||||||
212260 | 212260 | DIVIDEND | DELETE | 36863N208 | B | 1 | 4 | .1033 | 02 | 2010-05-25 | 2010-05-25 | 2010-06-08 | ? | 0 | 2010-06-01 | ? | 0 | 0003981137 | 20100603.ifs | 2010-06-03 | 2010-06-04 | ||||||||
212261 | 212261 | DIVIDEND | ADD | 36863N208 | B | 0 | 1 | 4 | .1187 | 0 | 02 | 2010-05-25 | 2010-05-25 | 2010-06-08 | 2010-03-23 | 0 | ? | 2010-06-03 | 0 | 0003981137 | 20100603.ifs | 2010-06-03 | 2010-06-04 | ||||||
208806 | 208806 | DIVIDEND | ADD | 36863N208 | B | 1 | 4 | .1033 | 02 | 2010-05-25 | 2010-05-25 | 2010-06-08 | ? | 0 | 2010-06-01 | ? | 0 | 0003981137 | 20100601.ifs | 2010-06-01 | 2010-06-02 | ||||||||
138933 | 138933 | DIVIDEND | DELETE | 36863N208 | B | 0 | 1 | 4 | .1331 | 39 | ? | 2010-05-25 | ? | 2010-03-23 | 0 | 2010-03-23 | ? | 0 | 0003981137 | 20100324.ifs | 2010-03-24 | 2010-04-07 | |||||||
138584 | 138584 | DIVIDEND | ADD | 36863N208 | B | 0 | 1 | 4 | .1331 | 39 | ? | 2010-05-25 | ? | 2010-03-23 | 0 | 2010-03-23 | ? | 0 | 0003981137 | 20100323.ifs | 2010-03-23 | 2010-04-07 | |||||||
26299 | 26299 | EQUITY | ADD | 36863N208 | NEW ISSUE | 0 | 0 | 2009-11-19 | ? | 0 | no | no | no | ? | ? | ? | 20091119.ifs | 2009-11-19 | 2010-04-07 | ||||||||||
26300 | 26300 | EQUITY | CHANGE | 36863N208 | NEW ISSUE | 0 | 0 | 2009-11-19 | ? | 0 | no | no | no | ? | ? | ? | 20091119.ifs | 2009-11-19 | 2010-04-07 | ||||||||||
26301 | 26300 | EQUITY | CHANGE | 36863N208 | SPONSORED ADR | N | 0 | 2009-11-19 | ? | 0 | no | no | no | ? | 2009-11-19 | ? | 20091119.ifs | 2009-11-19 | 2010-04-07 | ||||||||||
26302 | 26302 | EXCHANGE | ADD | 36863N208 | 66 | 2009-11-19 | ? | GTOMY | 0 | 0 | ? | 2009-11-19 | 20091119.ifs | 2009-11-19 | 2010-04-07 |
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 = 159751
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