INSITITUIONS | Dynamic | newInstitTable | Changed the Cusip/Sector/Shs Out? |
|
|||||||
Total Insititutions : | 52 | 41 | Update Insititution By Cusips | ||||||||
% Owned by Insititutions: | 34.85 % | 34.79 % | |||||||||
pricingQuarterAdminPageOn:
|
2024-03-31 | New % | |||||||||
|
|||||||||||
the compid is:130762 |
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 | ||
2965043 | 2965043 | DIVIDEND | ADD | 402307102 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2018-02-26 | 2018-02-26 | 0 | 2018-02-26 | ? | 0 | 0005618568 | 20180226.ifs | 2018-02-26 | 2018-02-27 | |||||||
2965044 | 2965044 | DIVIDEND | ADD | 402307102 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2018-02-26 | 2018-02-26 | 0 | 2018-02-26 | ? | 0 | 0005618568 | 20180226.ifs | 2018-02-26 | 2018-02-27 | |||||||
2736843 | 2736843 | DIVIDEND | ADD | 402307102 | 0 | 0 | 1 | 0 | .01 | 00 | 2017-11-09 | 2017-11-10 | 2017-11-24 | 2017-10-26 | 0 | 2017-10-26 | ? | 0 | 0005518766 | 20171026.ifs | 2017-10-26 | 2017-10-27 | |||||||
2736857 | 2736857 | DIVIDEND | ADD | 402307102 | 0 | 0 | 1 | 0 | .01 | 00 | 2017-11-09 | 2017-11-10 | 2017-11-24 | 2017-10-26 | 0 | 2017-10-26 | ? | 0 | 0005518766 | 20171026.ifs | 2017-10-26 | 2017-10-27 | |||||||
2632421 | 2632421 | DIVIDEND | ADD | 402307102 | 0 | 0 | 1 | 0 | .01 | 00 | 2017-08-08 | 2017-08-10 | 2017-08-24 | 2017-07-27 | 0 | 2017-07-27 | ? | 0 | 0005472164 | 20170727.ifs | 2017-07-27 | 2017-07-28 | |||||||
2548436 | 2548436 | DIVIDEND | ADD | 402307102 | 0 | 0 | 1 | 0 | .01 | 00 | 2017-05-09 | 2017-05-11 | 2017-05-25 | 2017-04-26 | 0 | 2017-04-26 | ? | 0 | 0005424376 | 20170426.ifs | 2017-04-26 | 2017-04-27 | |||||||
2494686 | 2494686 | DIVIDEND | ADD | 402307102 | 0 | 0 | 1 | 0 | .01 | 00 | 2017-03-08 | 2017-03-10 | 2017-03-24 | 2017-02-23 | 0 | 2017-02-23 | ? | 0 | 0005390956 | 20170223.ifs | 2017-02-23 | 2017-02-24 | |||||||
2439120 | 2439120 | EQUITY | CHANGE | 402307102 | COM | 0 | 0 | 1997-04-04 | ? | 8 | yes | no | yes | 1997-10-06 | 2001-01-19 | ? | 20170123.ifs | 2017-01-23 | 2017-01-24 | ||||||||||
2439121 | 2439120 | EQUITY | CHANGE | 402307102 | COM | 0 | 0 | 1997-04-04 | ? | 4 | yes | no | yes | 1997-10-06 | 2001-01-19 | ? | 20170123.ifs | 2017-01-23 | 2017-01-24 | ||||||||||
2327993 | 2327993 | DIVIDEND | ADD | 402307102 | 0 | 0 | 1 | 0 | .01 | 00 | 2016-11-08 | 2016-11-10 | 2016-11-23 | 2016-10-27 | 0 | 2016-10-27 | ? | 0 | 0005301798 | 20161027.ifs | 2016-10-27 | 2016-10-28 | |||||||
2259246 | 2259246 | DIVIDEND | ADD | 402307102 | 0 | 0 | 1 | 0 | .01 | 00 | 2016-08-09 | 2016-08-11 | 2016-08-25 | 2016-07-28 | 0 | 2016-07-28 | ? | 0 | 0005255686 | 20160728.ifs | 2016-07-28 | 2016-07-29 | |||||||
2181309 | 2181309 | DIVIDEND | ADD | 402307102 | 0 | 0 | 1 | 0 | .01 | 00 | 2016-05-10 | 2016-05-12 | 2016-05-26 | 2016-04-28 | 0 | 2016-04-28 | ? | 0 | 0005209443 | 20160428.ifs | 2016-04-28 | 2016-04-29 | |||||||
2119264 | 2119264 | DIVIDEND | ADD | 402307102 | 0 | 0 | 1 | 0 | .01 | 00 | 2016-03-08 | 2016-03-10 | 2016-03-24 | 2016-02-25 | 0 | 2016-02-25 | ? | 0 | 0005175926 | 20160225.ifs | 2016-02-25 | 2016-02-26 | |||||||
1999277 | 1999277 | DIVIDEND | ADD | 402307102 | 0 | 0 | 1 | 0 | .1 | 00 | 2015-11-10 | 2015-11-13 | 2015-11-27 | 2015-10-29 | 0 | 2015-10-29 | ? | 0 | 0005083289 | 20151029.ifs | 2015-10-29 | 2015-10-30 | |||||||
1928966 | 1928966 | DIVIDEND | ADD | 402307102 | 0 | 0 | 1 | 0 | .1 | 00 | 2015-08-12 | 2015-08-14 | 2015-08-28 | 2015-07-30 | 0 | 2015-07-31 | ? | 0 | 0005037704 | 20150731.ifs | 2015-07-31 | 2015-08-01 | |||||||
1846148 | 1846148 | DIVIDEND | ADD | 402307102 | 0 | 0 | 1 | 0 | .1 | 00 | 2015-05-13 | 2015-05-15 | 2015-05-29 | 2015-04-23 | 0 | 2015-04-23 | ? | 0 | 0004988844 | 20150423.ifs | 2015-04-23 | 2015-04-24 | |||||||
1802519 | 1802519 | DIVIDEND | ADD | 402307102 | 0 | 0 | 1 | 0 | .1 | 00 | 2015-03-11 | 2015-03-13 | 2015-03-27 | 2015-02-26 | 0 | 2015-03-02 | ? | 0 | 0004963096 | 20150302.ifs | 2015-03-02 | 2015-03-03 | |||||||
1662875 | 1662875 | DIVIDEND | ADD | 402307102 | 0 | 0 | 1 | 0 | .1 | 00 | 2014-11-06 | 2014-11-10 | 2014-11-24 | 2014-10-23 | 0 | 2014-10-24 | ? | 0 | 0004861956 | 20141024.ifs | 2014-10-24 | 2014-10-25 | |||||||
1586881 | 1586881 | DIVIDEND | ADD | 402307102 | 0 | 0 | 1 | 0 | .1 | 00 | 2014-08-07 | 2014-08-11 | 2014-08-25 | 2014-07-24 | 0 | 2014-07-25 | ? | 0 | 0004817532 | 20140725.ifs | 2014-07-25 | 2014-07-26 | |||||||
1502387 | 1502387 | DIVIDEND | ADD | 402307102 | 0 | 0 | 1 | 0 | .1 | 00 | 2014-05-09 | 2014-05-13 | 2014-05-30 | 2014-04-24 | 0 | 2014-04-25 | ? | 0 | 0004770984 | 20140425.ifs | 2014-04-25 | 2014-04-26 | |||||||
1453713 | 1453713 | DIVIDEND | ADD | 402307102 | 0 | 0 | 1 | 0 | .1 | 00 | 2014-03-12 | 2014-03-14 | 2014-03-24 | 2014-02-27 | 0 | 2014-02-28 | ? | 0 | 0004740606 | 20140228.ifs | 2014-02-28 | 2014-03-01 | |||||||
1323340 | 1323340 | DIVIDEND | ADD | 402307102 | 0 | 0 | 1 | 0 | .1 | 00 | 2013-11-07 | 2013-11-12 | 2013-11-27 | 2013-10-25 | 0 | 2013-10-25 | ? | 0 | 0004647943 | 20131025.ifs | 2013-10-25 | 2013-10-26 | |||||||
1246835 | 1246835 | DIVIDEND | ADD | 402307102 | 0 | 0 | 1 | 0 | .1 | 00 | 2013-08-07 | 2013-08-10 | 2013-08-28 | 2013-07-25 | 0 | 2013-07-25 | ? | 0 | 0004604633 | 20130725.ifs | 2013-07-25 | 2013-07-26 | |||||||
1167355 | 1167355 | DIVIDEND | ADD | 402307102 | 0 | 0 | 1 | 0 | .1 | 00 | 2013-05-10 | 2013-05-14 | 2013-05-31 | 2013-04-25 | 0 | 2013-04-25 | ? | 0 | 0004560896 | 20130425.ifs | 2013-04-25 | 2013-04-26 | |||||||
1131582 | 1131582 | DIVIDEND | ADD | 402307102 | 0 | 0 | 1 | 0 | .1 | 00 | 2013-03-14 | 2013-03-18 | 2013-04-01 | 2013-03-06 | 0 | 2013-03-12 | ? | 0 | 0004540224 | 20130312.ifs | 2013-03-12 | 2013-03-13 | |||||||
993515 | 993515 | DIVIDEND | ADD | 402307102 | 0 | 0 | 1 | 0 | .1 | 00 | 2012-11-07 | 2012-11-12 | 2012-11-27 | 2012-10-25 | 0 | 2012-10-26 | ? | 0 | 0004448203 | 20121026.ifs | 2012-10-26 | 2012-10-27 | |||||||
843902 | 843902 | DIVIDEND | ADD | 402307102 | 0 | 0 | 1 | 0 | .1 | 00 | 2012-05-10 | 2012-05-14 | 2012-05-31 | 2012-04-26 | 0 | 2012-04-26 | ? | 0 | 0004364638 | 20120426.ifs | 2012-04-26 | 2012-04-27 | |||||||
785983 | 785983 | DIVIDEND | ADD | 402307102 | 0 | 0 | 1 | 0 | .1 | 00 | 2012-03-08 | 2012-03-12 | 2012-03-26 | 2012-02-24 | 0 | 2012-02-27 | ? | 0 | 0004335744 | 20120227.ifs | 2012-02-27 | 2012-02-28 | |||||||
679383 | 679383 | DIVIDEND | ADD | 402307102 | 0 | 0 | 1 | 0 | .06 | 00 | 2011-11-09 | 2011-11-14 | 2011-11-29 | 2011-10-27 | 0 | 2011-10-27 | ? | 0 | 0004260878 | 20111027.ifs | 2011-10-27 | 2011-10-28 | |||||||
598102 | 598102 | DIVIDEND | ADD | 402307102 | 0 | 0 | 1 | 0 | .06 | 00 | 2011-08-10 | 2011-08-12 | 2011-08-29 | 2011-07-28 | 0 | 2011-07-29 | ? | 0 | 0004220541 | 20110729.ifs | 2011-07-29 | 2011-07-30 | |||||||
510877 | 510877 | DIVIDEND | ADD | 402307102 | 0 | 0 | 1 | 0 | .06 | 00 | 2011-05-11 | 2011-05-13 | 2011-05-30 | 2011-04-28 | 0 | 2011-04-28 | ? | 0 | 0004179125 | 20110428.ifs | 2011-04-28 | 2011-04-29 | |||||||
451265 | 451265 | DIVIDEND | ADD | 402307102 | 0 | 0 | 1 | 0 | .06 | 00 | 2011-03-10 | 2011-03-14 | 2011-03-28 | 2011-02-24 | 0 | 2011-02-24 | ? | 0 | 0004149757 | 20110224.ifs | 2011-02-24 | 2011-02-25 | |||||||
344060 | 344060 | DIVIDEND | ADD | 402307102 | 0 | 0 | 1 | 0 | .01 | 00 | 2010-11-10 | 2010-11-15 | 2010-12-01 | 2010-10-28 | 0 | 2010-10-28 | ? | 0 | 0004078325 | 20101028.ifs | 2010-10-28 | 2010-10-29 | |||||||
269053 | 269053 | DIVIDEND | ADD | 402307102 | 0 | 0 | 1 | 0 | .01 | 00 | 2010-08-12 | 2010-08-16 | 2010-09-02 | 2010-07-30 | 0 | 2010-08-02 | ? | 0 | 0004042861 | 20100802.ifs | 2010-08-02 | 2010-08-03 | |||||||
164816 | 164816 | DIVIDEND | ADD | 402307102 | 0 | 0 | 1 | 0 | .01 | 00 | 2010-05-05 | 2010-05-07 | 2010-05-24 | 2010-04-22 | 0 | 2010-04-22 | ? | 0 | 0003995324 | 20100422.ifs | 2010-04-22 | 2010-04-23 | |||||||
122858 | 122858 | DIVIDEND | ADD | 402307102 | 0 | 0 | 1 | 0 | .01 | 00 | 2010-03-11 | 2010-03-15 | 2010-03-29 | 2010-02-26 | 0 | 2010-03-01 | ? | 0 | 0003972615 | 20100301.ifs | 2010-03-01 | 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 = 130762
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