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:147484 |
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 | ||
3238328 | 3238328 | CORPACTION | DELETE | 928662303 | 66 | D | 2018-08-13 | ? | 20180814.ifs | 2018-08-14 | 2018-08-15 | ||||||||||||||||||
3238329 | 3238329 | CORPACTION | ADD | 928662303 | 66 | D | 2018-08-14 | 2018-08-14 | 20180814.ifs | 2018-08-14 | 2018-08-15 | ||||||||||||||||||
3238330 | 3238330 | EQUITY | CHANGE | 928662303 | SPONSORED ADR | D | 0 | 1996-08-30 | 2018-08-13 | 1 | no | no | no | 2000-02-24 | 2018-08-13 | ? | 20180814.ifs | 2018-08-14 | 2018-08-15 | ||||||||||
3238331 | 3238330 | EQUITY | CHANGE | 928662303 | SPONSORED ADR | D | 0 | 1996-08-30 | 2018-08-14 | 1 | no | no | no | 2000-02-24 | 2018-08-14 | ? | 20180814.ifs | 2018-08-14 | 2018-08-15 | ||||||||||
3238418 | 3238418 | EQUITY | CHANGE | 928662303 | SPONSORED ADR | D | 0 | 1996-08-30 | 2018-08-14 | 1 | no | no | no | 2000-02-24 | 2018-08-14 | ? | 20180814.ifs | 2018-08-14 | 2018-08-15 | ||||||||||
3238419 | 3238418 | EQUITY | CHANGE | 928662303 | SPONSORED ADR | V | 0 | 1996-08-30 | 2018-08-14 | 1 | no | no | no | 2000-02-24 | 2018-08-14 | ? | 20180814.ifs | 2018-08-14 | 2018-08-15 | ||||||||||
3238643 | 3238643 | CORPACTION | DELETE | 928662303 | 66 | D | 2018-08-13 | ? | 20180814.ifs | 2018-08-14 | 2018-08-15 | ||||||||||||||||||
3238645 | 3238645 | CORPACTION | ADD | 928662303 | 66 | D | 2018-08-14 | 2018-08-14 | 20180814.ifs | 2018-08-14 | 2018-08-15 | ||||||||||||||||||
3238647 | 3238647 | EQUITY | CHANGE | 928662303 | SPONSORED ADR | D | 0 | 1996-08-30 | 2018-08-13 | 1 | no | no | no | 2000-02-24 | 2018-08-13 | ? | 20180814.ifs | 2018-08-14 | 2018-08-15 | ||||||||||
3238649 | 3238648 | EQUITY | CHANGE | 928662303 | SPONSORED ADR | D | 0 | 1996-08-30 | 2018-08-14 | 1 | no | no | no | 2000-02-24 | 2018-08-14 | ? | 20180814.ifs | 2018-08-14 | 2018-08-15 | ||||||||||
3238815 | 3238815 | EQUITY | CHANGE | 928662303 | SPONSORED ADR | D | 0 | 1996-08-30 | 2018-08-14 | 1 | no | no | no | 2000-02-24 | 2018-08-14 | ? | 20180814.ifs | 2018-08-14 | 2018-08-15 | ||||||||||
3238817 | 3238816 | EQUITY | CHANGE | 928662303 | SPONSORED ADR | V | 0 | 1996-08-30 | 2018-08-14 | 1 | no | no | no | 2000-02-24 | 2018-08-14 | ? | 20180814.ifs | 2018-08-14 | 2018-08-15 | ||||||||||
3237345 | 3237345 | CORPACTION | ADD | 928662303 | 66 | D | 2018-08-13 | ? | 20180813.ifs | 2018-08-13 | 2018-08-14 | ||||||||||||||||||
3237346 | 3237346 | EQUITY | CHANGE | 928662303 | SPONSORED ADR | 0 | 0 | 1996-08-30 | ? | 1 | no | no | no | 2000-02-24 | 2000-04-11 | ? | 20180813.ifs | 2018-08-13 | 2018-08-14 | ||||||||||
3237347 | 3237346 | EQUITY | CHANGE | 928662303 | SPONSORED ADR | D | 0 | 1996-08-30 | 2018-08-13 | 1 | no | no | no | 2000-02-24 | 2018-08-13 | ? | 20180813.ifs | 2018-08-13 | 2018-08-14 | ||||||||||
3237938 | 3237938 | CORPACTION | ADD | 928662303 | 66 | D | 2018-08-13 | ? | 20180813.ifs | 2018-08-13 | 2018-08-14 | ||||||||||||||||||
3237939 | 3237939 | EQUITY | CHANGE | 928662303 | SPONSORED ADR | 0 | 0 | 1996-08-30 | ? | 1 | no | no | no | 2000-02-24 | 2000-04-11 | ? | 20180813.ifs | 2018-08-13 | 2018-08-14 | ||||||||||
3237940 | 3237939 | EQUITY | CHANGE | 928662303 | SPONSORED ADR | D | 0 | 1996-08-30 | 2018-08-13 | 1 | no | no | no | 2000-02-24 | 2018-08-13 | ? | 20180813.ifs | 2018-08-13 | 2018-08-14 | ||||||||||
3194006 | 3194006 | DIVIDEND | CHANGE | 928662303 | B | 0 | 1 | 0 | .679827 | 02 | 2018-05-04 | 2018-05-07 | 2018-05-15 | 2018-03-19 | 1 | 2018-03-19 | 2018-05-08 | 0 | 0005630868 | 20180713.ifs | 2018-07-13 | 2018-07-14 | |||||||
3194007 | 3194007 | DIVIDEND | CHANGE | 928662303 | B | 0 | 1 | 0 | .679827 | 02 | 2018-05-04 | 2018-05-07 | 2018-05-15 | 2018-03-19 | 1 | 2018-03-19 | 2018-05-08 | 0 | 0005630868 | 20180713.ifs | 2018-07-13 | 2018-07-14 | |||||||
3194008 | 3194007 | DIVIDEND | CHANGE | 928662303 | B | 0 | 1 | 0 | .679827 | 02 | 2018-05-04 | 2018-05-07 | 2018-05-15 | 2018-03-19 | 2 | 2018-03-19 | 2018-07-13 | 0 | 0005630868 | 20180713.ifs | 2018-07-13 | 2018-07-14 | |||||||
3194009 | 3194008 | DIVIDEND | CHANGE | 928662303 | B | 0 | 1 | 0 | .679827 | 02 | 2018-05-04 | 2018-05-07 | 2018-05-15 | 2018-03-19 | 2 | 2018-03-19 | 2018-07-13 | 0 | 0005630868 | 20180713.ifs | 2018-07-13 | 2018-07-14 | |||||||
3083394 | 3083394 | DIVIDEND | DELETE | 928662303 | B | 0 | 1 | 5 | .708541 | 39 | 2018-05-04 | 2018-05-07 | 2018-05-15 | 2018-03-19 | 0 | 2018-03-19 | ? | 0 | 0005630868 | 20180508.ifs | 2018-05-08 | 2018-05-09 | |||||||
3083396 | 3083396 | DIVIDEND | ADD | 928662303 | B | 0 | 1 | 0 | .679827 | 02 | 2018-05-04 | 2018-05-07 | 2018-05-15 | 2018-03-19 | 1 | 2018-03-19 | 2018-05-08 | 0 | 0005630868 | 20180508.ifs | 2018-05-08 | 2018-05-09 | |||||||
3083665 | 3083665 | DIVIDEND | DELETE | 928662303 | B | 0 | 1 | 5 | .708541 | 39 | 2018-05-04 | 2018-05-07 | 2018-05-15 | 2018-03-19 | 0 | 2018-03-19 | ? | 0 | 0005630868 | 20180508.ifs | 2018-05-08 | 2018-05-09 | |||||||
3083667 | 3083667 | DIVIDEND | ADD | 928662303 | B | 0 | 1 | 0 | .679827 | 02 | 2018-05-04 | 2018-05-07 | 2018-05-15 | 2018-03-19 | 1 | 2018-03-19 | 2018-05-08 | 0 | 0005630868 | 20180508.ifs | 2018-05-08 | 2018-05-09 | |||||||
2996546 | 2996546 | DIVIDEND | ADD | 928662303 | B | 0 | 1 | 5 | .708541 | 39 | 2018-05-04 | 2018-05-07 | 2018-05-15 | 2018-03-19 | 0 | 2018-03-19 | ? | 0 | 0005630868 | 20180319.ifs | 2018-03-19 | 2018-03-20 | |||||||
2996553 | 2996553 | DIVIDEND | ADD | 928662303 | B | 0 | 1 | 5 | .708541 | 39 | 2018-05-04 | 2018-05-07 | 2018-05-15 | 2018-03-19 | 0 | 2018-03-19 | ? | 0 | 0005630868 | 20180319.ifs | 2018-03-19 | 2018-03-20 | |||||||
2568133 | 2568133 | DIVIDEND | DELETE | 928662303 | B | 0 | 1 | 5 | .309167 | 39 | 2017-05-10 | 2017-05-12 | 2017-05-22 | 2017-03-02 | 0 | 2017-03-02 | ? | 0 | 0005399683 | 20170516.ifs | 2017-05-16 | 2017-05-17 | |||||||
2568134 | 2568134 | DIVIDEND | ADD | 928662303 | B | 0 | 1 | 0 | .322949 | 02 | 2017-05-10 | 2017-05-12 | 2017-05-22 | 2017-03-02 | 1 | 2017-03-02 | 2017-05-16 | 0 | 0005399683 | 20170516.ifs | 2017-05-16 | 2017-05-17 | |||||||
2506000 | 2506000 | DIVIDEND | ADD | 928662303 | B | 0 | 1 | 5 | .309167 | 39 | 2017-05-10 | 2017-05-12 | 2017-05-22 | 2017-03-02 | 0 | 2017-03-02 | ? | 0 | 0005399683 | 20170302.ifs | 2017-03-02 | 2017-03-03 | |||||||
2470965 | 2470965 | EQUITY | CHANGE | 928662303 | SPONSORED ADR | 0 | 0 | 1996-08-30 | ? | 8 | no | no | no | 2000-02-24 | 2000-04-11 | ? | 20170126.ifs | 2017-01-26 | 2017-01-27 | ||||||||||
2470966 | 2470965 | EQUITY | CHANGE | 928662303 | SPONSORED ADR | 0 | 0 | 1996-08-30 | ? | 1 | no | no | no | 2000-02-24 | 2000-04-11 | ? | 20170126.ifs | 2017-01-26 | 2017-01-27 | ||||||||||
2228739 | 2228739 | DIVIDEND | DELETE | 928662303 | B | 0 | 1 | 5 | .018174 | 39 | 2016-06-20 | 2016-06-22 | 2016-06-30 | 2016-05-23 | 0 | 2016-05-23 | ? | 0 | 0005221179 | 20160623.ifs | 2016-06-23 | 2016-06-24 | |||||||
2228740 | 2228740 | DIVIDEND | ADD | 928662303 | B | 0 | 1 | 0 | .01837 | 02 | 2016-06-20 | 2016-06-22 | 2016-06-30 | 2016-05-23 | 1 | 2016-05-23 | 2016-06-23 | 0 | 0005221179 | 20160623.ifs | 2016-06-23 | 2016-06-24 | |||||||
2201491 | 2201491 | DIVIDEND | ADD | 928662303 | B | 0 | 1 | 5 | .018174 | 39 | 2016-06-20 | 2016-06-22 | 2016-06-30 | 2016-05-23 | 0 | 2016-05-23 | ? | 0 | 0005221179 | 20160523.ifs | 2016-05-23 | 2016-05-24 | |||||||
1859257 | 1859257 | DIVIDEND | DELETE | 928662303 | B | 1 | 0 | .800876 | 02 | 2015-05-01 | 2015-05-05 | 2015-05-13 | ? | 0 | 2015-05-06 | ? | 0 | 0004969510 | 20150507.ifs | 2015-05-07 | 2015-05-08 | ||||||||
1859258 | 1859258 | DIVIDEND | ADD | 928662303 | B | 0 | 1 | 0 | .800876 | 0 | 02 | 2015-05-01 | 2015-05-05 | 2015-05-13 | 2015-03-17 | 0 | ? | 2015-05-07 | 0 | 0004969510 | 20150507.ifs | 2015-05-07 | 2015-05-08 | ||||||
1858732 | 1858732 | DIVIDEND | ADD | 928662303 | B | 1 | 0 | .800876 | 02 | 2015-05-01 | 2015-05-05 | 2015-05-13 | ? | 0 | 2015-05-06 | ? | 0 | 0004969510 | 20150506.ifs | 2015-05-06 | 2015-05-07 | ||||||||
1814643 | 1814643 | DIVIDEND | DELETE | 928662303 | B | 0 | 1 | 5 | .748925 | 39 | ? | 2015-05-05 | 2015-05-13 | 2015-03-17 | 0 | 2015-03-17 | ? | 0 | 0004969510 | 20150318.ifs | 2015-03-18 | 2015-03-19 | |||||||
1814644 | 1814644 | DIVIDEND | ADD | 928662303 | B | 0 | 1 | 5 | .748925 | 0 | 39 | 2015-05-01 | 2015-05-05 | 2015-05-13 | 2015-03-17 | 0 | ? | 2015-03-18 | 0 | 0004969510 | 20150318.ifs | 2015-03-18 | 2015-03-19 | ||||||
1814855 | 1814855 | DIVIDEND | DELETE | 928662303 | B | 0 | 1 | 5 | .748925 | 0 | 39 | 2015-05-01 | 2015-05-05 | 2015-05-13 | 2015-03-17 | 0 | ? | 2015-03-18 | 0 | 0004969510 | 20150318.ifs | 2015-03-18 | 2015-03-19 | ||||||
1814004 | 1814004 | DIVIDEND | ADD | 928662303 | B | 0 | 1 | 5 | .748925 | 39 | ? | 2015-05-05 | 2015-05-13 | 2015-03-17 | 0 | 2015-03-17 | ? | 0 | 0004969510 | 20150317.ifs | 2015-03-17 | 2015-03-18 | |||||||
1462278 | 1462278 | DIVIDEND | ADD | 928662303 | B | 0 | 1 | 5 | .817238 | 39 | ? | 2014-05-13 | 2014-05-21 | 2014-03-07 | 0 | 2014-03-07 | ? | 0 | 0004748797 | 20140307.ifs | 2014-03-07 | 2014-03-08 | |||||||
1168361 | 1168361 | DIVIDEND | DELETE | 928662303 | B | 0 | 1 | 5 | .67174 | 39 | 2013-04-23 | 2013-04-25 | 2013-05-03 | 2013-03-06 | 1 | 2013-03-06 | 2013-03-07 | 0 | 0004539313 | 20130426.ifs | 2013-04-26 | 2013-04-27 | |||||||
1168362 | 1168362 | DIVIDEND | ADD | 928662303 | B | 0 | 1 | 0 | .669781 | 02 | 2013-04-23 | 2013-04-25 | 2013-05-03 | 2013-03-06 | 2 | 2013-03-06 | 2013-04-26 | 0 | 0004539313 | 20130426.ifs | 2013-04-26 | 2013-04-27 | |||||||
1129491 | 1129491 | DIVIDEND | ADD | 928662303 | B | 0 | 1 | 5 | .67174 | 39 | ? | 2013-04-25 | 2013-05-03 | 2013-03-06 | 0 | 2013-03-06 | ? | 0 | 0004539313 | 20130306.ifs | 2013-03-06 | 2013-03-07 | |||||||
839718 | 839718 | DIVIDEND | DELETE | 928662303 | B | 0 | 1 | 5 | .582933 | 39 | 2012-04-17 | 2012-04-19 | 2012-04-27 | 2012-03-22 | 0 | 2012-03-22 | ? | 0 | 0004348505 | 20120420.ifs | 2012-04-20 | 2012-04-21 | |||||||
839719 | 839719 | DIVIDEND | ADD | 928662303 | B | 0 | 1 | 0 | .582756 | 02 | 2012-04-17 | 2012-04-19 | 2012-04-27 | 2012-03-22 | 1 | 2012-03-22 | 2012-04-20 | 0 | 0004348505 | 20120420.ifs | 2012-04-20 | 2012-04-21 | |||||||
807836 | 807836 | DIVIDEND | ADD | 928662303 | B | 0 | 1 | 5 | .582933 | 39 | 2012-04-17 | 2012-04-19 | 2012-04-27 | 2012-03-22 | 0 | 2012-03-22 | ? | 0 | 0004348505 | 20120322.ifs | 2012-03-22 | 2012-03-23 | |||||||
527772 | 527772 | DIVIDEND | DELETE | 928662303 | B | 0 | 1 | 5 | .448055 | 39 | 2011-04-29 | 2011-05-03 | 2011-05-11 | 2011-03-07 | 1 | 2011-03-07 | 2011-03-08 | 0 | 0004157993 | 20110517.ifs | 2011-05-17 | 2011-05-18 | |||||||
527773 | 527773 | DIVIDEND | ADD | 928662303 | B | 0 | 1 | 0 | .480968 | 02 | 2011-04-29 | 2011-05-03 | 2011-05-11 | 2011-03-07 | 2 | 2011-03-07 | 2011-05-17 | 0 | 0004157993 | 20110517.ifs | 2011-05-17 | 2011-05-18 | |||||||
467619 | 467619 | DIVIDEND | DELETE | 928662303 | B | 0 | 1 | 5 | .448055 | 39 | ? | 2011-05-03 | 2011-05-11 | 2011-03-07 | 0 | 2011-03-07 | ? | 0 | 0004157993 | 20110308.ifs | 2011-03-08 | 2011-03-09 | |||||||
467620 | 467620 | DIVIDEND | ADD | 928662303 | B | 0 | 1 | 5 | .448055 | 39 | 2011-04-29 | 2011-05-03 | 2011-05-11 | 2011-03-07 | 1 | 2011-03-07 | 2011-03-08 | 0 | 0004157993 | 20110308.ifs | 2011-03-08 | 2011-03-09 | |||||||
466578 | 466578 | DIVIDEND | ADD | 928662303 | B | 0 | 1 | 5 | .448055 | 39 | ? | 2011-05-03 | 2011-05-11 | 2011-03-07 | 0 | 2011-03-07 | ? | 0 | 0004157993 | 20110307.ifs | 2011-03-07 | 2011-03-08 | |||||||
165626 | 165626 | DIVIDEND | DELETE | 928662303 | B | 0 | 1 | 5 | .32042 | 39 | 2010-04-20 | 2010-04-22 | 2010-04-30 | 2010-03-10 | 1 | 2010-03-10 | 2010-03-12 | 0 | 0003977091 | 20100423.ifs | 2010-04-23 | 2010-04-24 | |||||||
165627 | 165627 | DIVIDEND | ADD | 928662303 | B | 0 | 1 | 0 | .31316 | 02 | 2010-04-20 | 2010-04-22 | 2010-04-30 | 2010-03-10 | 2 | 2010-03-10 | 2010-04-23 | 0 | 0003977091 | 20100423.ifs | 2010-04-23 | 2010-04-24 | |||||||
163127 | 163127 | DIVIDEND | DELETE | 928662303 | 6 | 0 | 1 | 9 | .21209 | 25 | ? | 2010-04-30 | 2010-05-07 | 2010-04-20 | 0 | 2010-04-20 | ? | 0 | 0003994219 | 20100421.ifs | 2010-04-21 | 2010-04-22 | |||||||
163128 | 163128 | DIVIDEND | ADD | 928662303 | 6 | 0 | 1 | 9 | .21209 | 25 | 2010-04-28 | 2010-04-30 | 2010-05-07 | 2010-04-20 | 1 | 2010-04-20 | 2010-04-21 | 0 | 0003994219 | 20100421.ifs | 2010-04-21 | 2010-04-22 | |||||||
131896 | 131896 | DIVIDEND | DELETE | 928662303 | B | 0 | 1 | 5 | .32042 | 39 | ? | 2010-04-22 | 2010-04-30 | 2010-03-10 | 0 | 2010-03-10 | ? | 0 | 0003977091 | 20100312.ifs | 2010-03-12 | 2010-04-07 | |||||||
131897 | 131897 | DIVIDEND | ADD | 928662303 | B | 0 | 1 | 5 | .32042 | 39 | 2010-04-20 | 2010-04-22 | 2010-04-30 | 2010-03-10 | 1 | 2010-03-10 | 2010-03-12 | 0 | 0003977091 | 20100312.ifs | 2010-03-12 | 2010-04-07 | |||||||
129979 | 129979 | DIVIDEND | ADD | 928662303 | B | 0 | 1 | 5 | .32042 | 39 | ? | 2010-04-22 | 2010-04-30 | 2010-03-10 | 0 | 2010-03-10 | ? | 0 | 0003977091 | 20100310.ifs | 2010-03-10 | 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 = 147484
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