INSITITUIONS | Dynamic | newInstitTable | Changed the Cusip/Sector/Shs Out? |
|
|||||||
Total Insititutions : | 1 | 1 | Update Insititution By Cusips | ||||||||
% Owned by Insititutions: | 0.00 % | 0 % | |||||||||
pricingQuarterAdminPageOn:
|
2024-03-31 | New % | |||||||||
|
|||||||||||
the compid is:130703 |
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 | ||
2958727 | 2958727 | CORPACTION | DELETE | 247850100 | 01 | M | 2018-02-20 | 737630103 | 60 | 2018-02-20 | 20180221.ifs | 2018-02-21 | 2018-02-22 | ||||||||||||||||
2958728 | 2958728 | EQUITY | CHANGE | 247850100 | COM | M | 0 | 1996-11-12 | 2018-02-20 | 4 | yes | no | 737630103 | no | 1997-01-22 | 2018-02-20 | ? | 20180221.ifs | 2018-02-21 | 2018-02-22 | |||||||||
2958729 | 2958728 | EQUITY | CHANGE | 247850100 | COM | 0 | 0 | 1996-11-12 | ? | 4 | yes | no | no | 1997-01-22 | 2018-02-20 | ? | 20180221.ifs | 2018-02-21 | 2018-02-22 | ||||||||||
2958733 | 2958733 | CORPACTION | DELETE | 247850100 | 01 | M | 2018-02-20 | 737630103 | 60 | 2018-02-20 | 20180221.ifs | 2018-02-21 | 2018-02-22 | ||||||||||||||||
2958735 | 2958735 | EQUITY | CHANGE | 247850100 | COM | M | 0 | 1996-11-12 | 2018-02-20 | 4 | yes | no | 737630103 | no | 1997-01-22 | 2018-02-20 | ? | 20180221.ifs | 2018-02-21 | 2018-02-22 | |||||||||
2958737 | 2958736 | EQUITY | CHANGE | 247850100 | COM | 0 | 0 | 1996-11-12 | ? | 4 | yes | no | no | 1997-01-22 | 2018-02-20 | ? | 20180221.ifs | 2018-02-21 | 2018-02-22 | ||||||||||
2959116 | 2959116 | CORPACTION | ADD | 247850100 | 01 | M | 2018-02-21 | 737630103 | 60 | 2018-02-21 | 20180221.ifs | 2018-02-21 | 2018-02-22 | ||||||||||||||||
2959118 | 2959118 | EQUITY | CHANGE | 247850100 | COM | 0 | 0 | 1996-11-12 | ? | 4 | yes | no | no | 1997-01-22 | 2018-02-20 | ? | 20180221.ifs | 2018-02-21 | 2018-02-22 | ||||||||||
2959120 | 2959119 | EQUITY | CHANGE | 247850100 | COM | M | 0 | 1996-11-12 | 2018-02-21 | 4 | yes | no | 737630103 | no | 1997-01-22 | 2018-02-21 | ? | 20180221.ifs | 2018-02-21 | 2018-02-22 | |||||||||
2959143 | 2959143 | CORPACTION | ADD | 247850100 | 01 | M | 2018-02-21 | 737630103 | 60 | 2018-02-21 | 20180221.ifs | 2018-02-21 | 2018-02-22 | ||||||||||||||||
2959144 | 2959144 | EQUITY | CHANGE | 247850100 | COM | 0 | 0 | 1996-11-12 | ? | 4 | yes | no | no | 1997-01-22 | 2018-02-20 | ? | 20180221.ifs | 2018-02-21 | 2018-02-22 | ||||||||||
2959146 | 2959145 | EQUITY | CHANGE | 247850100 | COM | M | 0 | 1996-11-12 | 2018-02-21 | 4 | yes | no | 737630103 | no | 1997-01-22 | 2018-02-21 | ? | 20180221.ifs | 2018-02-21 | 2018-02-22 | |||||||||
2957784 | 2957784 | CORPACTION | ADD | 247850100 | 01 | M | 2018-02-20 | 737630103 | 60 | ? | 20180220.ifs | 2018-02-20 | 2018-02-21 | ||||||||||||||||
2957786 | 2957786 | EQUITY | CHANGE | 247850100 | COM | 0 | 0 | 1996-11-12 | ? | 4 | yes | no | no | 1997-01-22 | 2001-01-19 | ? | 20180220.ifs | 2018-02-20 | 2018-02-21 | ||||||||||
2957788 | 2957787 | EQUITY | CHANGE | 247850100 | COM | M | 0 | 1996-11-12 | 2018-02-20 | 4 | yes | no | 737630103 | no | 1997-01-22 | 2018-02-20 | ? | 20180220.ifs | 2018-02-20 | 2018-02-21 | |||||||||
2957807 | 2957807 | CORPACTION | ADD | 247850100 | 01 | M | 2018-02-20 | 737630103 | 60 | ? | 20180220.ifs | 2018-02-20 | 2018-02-21 | ||||||||||||||||
2957809 | 2957809 | EQUITY | CHANGE | 247850100 | COM | 0 | 0 | 1996-11-12 | ? | 4 | yes | no | no | 1997-01-22 | 2001-01-19 | ? | 20180220.ifs | 2018-02-20 | 2018-02-21 | ||||||||||
2957810 | 2957809 | EQUITY | CHANGE | 247850100 | COM | M | 0 | 1996-11-12 | 2018-02-20 | 4 | yes | no | 737630103 | no | 1997-01-22 | 2018-02-20 | ? | 20180220.ifs | 2018-02-20 | 2018-02-21 | |||||||||
2957839 | 2957839 | CORPACTION | DELETE | 247850100 | 01 | M | 2018-02-20 | 737630103 | 60 | ? | 20180220.ifs | 2018-02-20 | 2018-02-21 | ||||||||||||||||
2957843 | 2957843 | CORPACTION | ADD | 247850100 | 01 | M | 2018-02-20 | 737630103 | 60 | 2018-02-20 | 20180220.ifs | 2018-02-20 | 2018-02-21 | ||||||||||||||||
2957859 | 2957859 | CORPACTION | DELETE | 247850100 | 01 | M | 2018-02-20 | 737630103 | 60 | ? | 20180220.ifs | 2018-02-20 | 2018-02-21 | ||||||||||||||||
2957863 | 2957863 | CORPACTION | ADD | 247850100 | 01 | M | 2018-02-20 | 737630103 | 60 | 2018-02-20 | 20180220.ifs | 2018-02-20 | 2018-02-21 | ||||||||||||||||
2952291 | 2952291 | DIVIDEND | CHANGE | 247850100 | 0 | 0 | 1 | 0 | .1 | 00 | 2017-12-01 | 2017-12-04 | 2017-12-18 | 2017-10-05 | 0 | 2017-10-05 | ? | 0 | 0005513191 | 20180213.ifs | 2018-02-13 | 2018-02-14 | |||||||
2952292 | 2952292 | DIVIDEND | CHANGE | 247850100 | 0 | 0 | 1 | 0 | .1 | 00 | 2017-12-01 | 2017-12-04 | 2017-12-18 | 2017-10-05 | 0 | 2017-10-05 | ? | 0 | 0005513191 | 20180213.ifs | 2018-02-13 | 2018-02-14 | |||||||
2952293 | 2952292 | DIVIDEND | CHANGE | 247850100 | 0 | 0 | 1 | 0 | .1 | 00 | 2017-12-01 | 2017-12-04 | 2017-12-18 | 2017-10-05 | 1 | 2017-10-05 | 2018-02-13 | 0 | 0005513191 | 20180213.ifs | 2018-02-13 | 2018-02-14 | |||||||
2952294 | 2952293 | DIVIDEND | CHANGE | 247850100 | 0 | 0 | 1 | 0 | .1 | 00 | 2017-12-01 | 2017-12-04 | 2017-12-18 | 2017-10-05 | 1 | 2017-10-05 | 2018-02-13 | 0 | 0005513191 | 20180213.ifs | 2018-02-13 | 2018-02-14 | |||||||
2716784 | 2716784 | DIVIDEND | ADD | 247850100 | 0 | 0 | 1 | 0 | .1 | 00 | 2017-12-01 | 2017-12-04 | 2017-12-18 | 2017-10-05 | 0 | 2017-10-05 | ? | 0 | 0005513191 | 20171005.ifs | 2017-10-05 | 2017-10-06 | |||||||
2592567 | 2592567 | DIVIDEND | ADD | 247850100 | 0 | 0 | 1 | 0 | .1 | 00 | 2017-08-31 | 2017-09-05 | 2017-09-19 | 2017-06-15 | 0 | 2017-06-15 | ? | 0 | 0005449792 | 20170615.ifs | 2017-06-15 | 2017-06-16 | |||||||
2549641 | 2549641 | DIVIDEND | ADD | 247850100 | 0 | 0 | 1 | 0 | .1 | 00 | 2017-06-01 | 2017-06-05 | 2017-06-19 | 2017-04-27 | 0 | 2017-04-27 | ? | 0 | 0005424999 | 20170427.ifs | 2017-04-27 | 2017-04-28 | |||||||
2491591 | 2491591 | DIVIDEND | ADD | 247850100 | 0 | 0 | 1 | 0 | .1 | 00 | 2017-03-02 | 2017-03-06 | 2017-03-20 | 2017-02-16 | 0 | 2017-02-16 | ? | 0 | 0005389030 | 20170216.ifs | 2017-02-16 | 2017-02-17 | |||||||
2299928 | 2299928 | DIVIDEND | ADD | 247850100 | 0 | 0 | 1 | 0 | .1 | 00 | 2016-11-29 | 2016-12-01 | 2016-12-15 | 2016-09-22 | 0 | 2016-09-22 | ? | 0 | 0005283913 | 20160922.ifs | 2016-09-22 | 2016-09-23 | |||||||
2223061 | 2223061 | DIVIDEND | ADD | 247850100 | 0 | 0 | 1 | 0 | .1 | 00 | 2016-08-30 | 2016-09-01 | 2016-09-15 | 2016-06-16 | 0 | 2016-06-16 | ? | 0 | 0005233135 | 20160616.ifs | 2016-06-16 | 2016-06-17 | |||||||
2181468 | 2181468 | DIVIDEND | ADD | 247850100 | 0 | 0 | 1 | 0 | .1 | 00 | 2016-05-27 | 2016-06-01 | 2016-06-15 | 2016-04-28 | 0 | 2016-04-28 | ? | 0 | 0005209144 | 20160428.ifs | 2016-04-28 | 2016-04-29 | |||||||
2115094 | 2115094 | DIVIDEND | ADD | 247850100 | 0 | 0 | 1 | 0 | .1 | 00 | 2016-03-03 | 2016-03-07 | 2016-03-21 | 2016-02-18 | 0 | 2016-02-18 | ? | 0 | 0005173505 | 20160218.ifs | 2016-02-18 | 2016-02-19 | |||||||
1889836 | 1889836 | DIVIDEND | ADD | 247850100 | 0 | 0 | 1 | 0 | .1 | 00 | 2015-08-28 | 2015-09-01 | 2015-09-15 | 2015-06-18 | 0 | 2015-06-18 | ? | 0 | 0005014968 | 20150618.ifs | 2015-06-18 | 2015-06-19 | |||||||
1846221 | 1846221 | DIVIDEND | ADD | 247850100 | 0 | 0 | 1 | 0 | .1 | 00 | 2015-05-28 | 2015-06-01 | 2015-06-15 | 2015-04-23 | 0 | 2015-04-23 | ? | 0 | 0004988563 | 20150423.ifs | 2015-04-23 | 2015-04-24 | |||||||
1638901 | 1638901 | DIVIDEND | ADD | 247850100 | 0 | 0 | 1 | 0 | .1 | 00 | 2014-11-26 | 2014-12-01 | 2014-12-15 | 2014-09-25 | 0 | 2014-09-25 | ? | 0 | 0004847482 | 20140925.ifs | 2014-09-25 | 2014-09-26 | |||||||
1554015 | 1554015 | DIVIDEND | ADD | 247850100 | 0 | 0 | 1 | 0 | .1 | 00 | 2014-08-28 | 2014-09-02 | 2014-09-16 | 2014-06-19 | 0 | 2014-06-19 | ? | 0 | 0004798279 | 20140619.ifs | 2014-06-19 | 2014-06-20 | |||||||
1501663 | 1501663 | DIVIDEND | ADD | 247850100 | 0 | 0 | 1 | 0 | .1 | 00 | 2014-05-29 | 2014-06-02 | 2014-06-16 | 2014-04-24 | 0 | 2014-04-24 | ? | 0 | 0004770700 | 20140424.ifs | 2014-04-24 | 2014-04-25 | |||||||
1447082 | 1447082 | DIVIDEND | ADD | 247850100 | 0 | 0 | 1 | 0 | .1 | 00 | 2014-02-27 | 2014-03-03 | 2014-03-17 | 2014-02-20 | 0 | 2014-02-20 | ? | 0 | 0004738048 | 20140220.ifs | 2014-02-20 | 2014-02-21 | |||||||
1291708 | 1291708 | DIVIDEND | ADD | 247850100 | 0 | 0 | 1 | 0 | .1 | 00 | 2013-11-27 | 2013-12-02 | 2013-12-16 | 2013-09-19 | 0 | 2013-09-19 | ? | 0 | 0004630419 | 20130919.ifs | 2013-09-19 | 2013-09-20 | |||||||
1213830 | 1213830 | DIVIDEND | ADD | 247850100 | 0 | 0 | 1 | 0 | .1 | 00 | 2013-08-29 | 2013-09-03 | 2013-09-17 | 2013-06-20 | 0 | 2013-06-20 | ? | 0 | 0004585817 | 20130620.ifs | 2013-06-20 | 2013-06-21 | |||||||
1167433 | 1167433 | DIVIDEND | ADD | 247850100 | 0 | 0 | 1 | 0 | .1 | 00 | 2013-05-30 | 2013-06-03 | 2013-06-17 | 2013-04-25 | 0 | 2013-04-25 | ? | 0 | 0004560562 | 20130425.ifs | 2013-04-25 | 2013-04-26 | |||||||
1115758 | 1115758 | DIVIDEND | ADD | 247850100 | 0 | 0 | 1 | 0 | .1 | 00 | 2013-02-28 | 2013-03-04 | 2013-03-15 | 2013-02-21 | 0 | 2013-02-21 | ? | 0 | 0004529631 | 20130221.ifs | 2013-02-21 | 2013-02-22 | |||||||
961000 | 961000 | DIVIDEND | ADD | 247850100 | 0 | 0 | 1 | 0 | .075 | 00 | 2012-11-29 | 2012-12-03 | 2012-12-17 | 2012-09-20 | 0 | 2012-09-20 | ? | 0 | 0004431173 | 20120920.ifs | 2012-09-20 | 2012-09-21 | |||||||
891264 | 891264 | DIVIDEND | ADD | 247850100 | 0 | 0 | 1 | 0 | .075 | 00 | 2012-08-30 | 2012-09-04 | 2012-09-18 | 2012-06-21 | 0 | 2012-06-21 | ? | 0 | 0004389715 | 20120621.ifs | 2012-06-21 | 2012-06-22 | |||||||
843992 | 843992 | DIVIDEND | ADD | 247850100 | 0 | 0 | 1 | 0 | .075 | 00 | 2012-05-30 | 2012-06-01 | 2012-06-15 | 2012-04-26 | 0 | 2012-04-26 | ? | 0 | 0004364471 | 20120426.ifs | 2012-04-26 | 2012-04-27 | |||||||
780759 | 780759 | DIVIDEND | ADD | 247850100 | 0 | 0 | 1 | 0 | .075 | 00 | 2012-02-28 | 2012-03-01 | 2012-03-15 | 2011-02-16 | 0 | 2012-02-16 | ? | 0 | 0004333317 | 20120216.ifs | 2012-02-16 | 2012-02-17 | |||||||
644440 | 644440 | DIVIDEND | ADD | 247850100 | 0 | 0 | 1 | 0 | .075 | 00 | 2011-11-29 | 2011-12-01 | 2011-12-15 | 2011-09-15 | 0 | 2011-09-15 | ? | 0 | 0004242344 | 20110915.ifs | 2011-09-15 | 2011-09-16 | |||||||
562117 | 562117 | DIVIDEND | ADD | 247850100 | 0 | 0 | 1 | 0 | .075 | 00 | 2011-08-30 | 2011-09-01 | 2011-09-15 | 2011-06-16 | 0 | 2011-06-16 | ? | 0 | 0004201287 | 20110616.ifs | 2011-06-16 | 2011-06-17 | |||||||
511030 | 511030 | DIVIDEND | ADD | 247850100 | 0 | 0 | 1 | 0 | .075 | 00 | 2011-05-27 | 2011-06-01 | 2011-06-15 | 2011-04-28 | 0 | 2011-04-28 | ? | 0 | 0004178737 | 20110428.ifs | 2011-04-28 | 2011-04-29 | |||||||
444894 | 444894 | DIVIDEND | ADD | 247850100 | 0 | 0 | 1 | 0 | .075 | 00 | 2011-02-25 | 2011-03-01 | 2011-03-15 | 2011-02-17 | 0 | 2011-02-17 | ? | 0 | 0004147619 | 20110217.ifs | 2011-02-17 | 2011-02-18 | |||||||
308819 | 308819 | DIVIDEND | ADD | 247850100 | 0 | 0 | 1 | 0 | .075 | 00 | 2010-11-29 | 2010-12-01 | 2010-12-15 | 2010-09-16 | 0 | 2010-09-16 | ? | 0 | 0004060239 | 20100916.ifs | 2010-09-16 | 2010-09-17 | |||||||
221477 | 221477 | DIVIDEND | ADD | 247850100 | 0 | 0 | 1 | 0 | .075 | 00 | 2010-08-30 | 2010-09-01 | 2010-09-15 | 2010-06-17 | 0 | 2010-06-17 | ? | 0 | 0004019020 | 20100617.ifs | 2010-06-17 | 2010-06-18 | |||||||
166072 | 166072 | DIVIDEND | ADD | 247850100 | 0 | 0 | 1 | 4 | .075 | 00 | 2010-05-27 | 2010-06-01 | 2010-06-15 | 2010-04-22 | 0 | ? | 2010-04-26 | 0 | 0003995160 | 20100426.ifs | 2010-04-26 | 2010-04-27 | |||||||
112521 | 112521 | DIVIDEND | ADD | 247850100 | 0 | 0 | 1 | 0 | .075 | 00 | 2010-02-25 | 2010-03-01 | 2010-03-15 | 2010-02-18 | 0 | 2010-02-18 | ? | 0 | 0003966126 | 20100218.ifs | 2010-02-18 | 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 = 130703
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