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:135274 |
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 | ||
2511268 | 2511268 | CORPACTION | ADD | 413086109 | 01 | A | 2017-03-10 | Y74718100 | 66 | ? | 20170313.ifs | 2017-03-13 | 2017-03-14 | ||||||||||||||||
2511269 | 2511269 | EQUITY | CHANGE | 413086109 | COM | 0 | 0 | 1986-11-14 | ? | 4 | yes | yes | no | 1994-09-19 | 2006-02-02 | ? | 20170313.ifs | 2017-03-13 | 2017-03-14 | ||||||||||
2511270 | 2511269 | EQUITY | CHANGE | 413086109 | COM | A | 0 | 1986-11-14 | 2017-03-10 | 4 | yes | yes | Y74718100 | no | 1994-09-19 | 2017-03-13 | ? | 20170313.ifs | 2017-03-13 | 2017-03-14 | |||||||||
2510901 | 2510901 | DIVIDEND | CHANGE | 413086109 | 0 | 0 | 1 | 0 | .35 | 00 | 2017-02-02 | 2017-02-06 | 2017-02-22 | 2017-01-26 | 0 | 2017-01-26 | ? | 0 | 0005377901 | 20170310.ifs | 2017-03-10 | 2017-03-11 | |||||||
2510902 | 2510901 | DIVIDEND | CHANGE | 413086109 | 0 | 0 | 1 | 0 | .35 | 00 | 2017-02-02 | 2017-02-06 | 2017-02-22 | 2017-01-26 | 1 | 2017-01-26 | 2017-03-10 | 0 | 0005377901 | 20170310.ifs | 2017-03-10 | 2017-03-11 | |||||||
2473657 | 2473657 | DIVIDEND | ADD | 413086109 | 0 | 0 | 1 | 0 | .35 | 00 | 2017-02-02 | 2017-02-06 | 2017-02-22 | 2017-01-26 | 0 | 2017-01-26 | ? | 0 | 0005377901 | 20170126.ifs | 2017-01-26 | 2017-01-27 | |||||||
2343703 | 2343703 | DIVIDEND | CHANGE | 413086109 | 0 | 0 | 1 | 0 | .35 | 00 | 2016-11-09 | 2016-11-14 | 2016-11-30 | 2016-11-03 | 0 | 2016-11-03 | ? | 0 | 0005309553 | 20161115.ifs | 2016-11-15 | 2016-11-16 | |||||||
2343704 | 2343703 | DIVIDEND | CHANGE | 413086109 | 0 | 0 | 1 | 0 | .35 | 00 | 2016-11-09 | 2016-11-14 | 2016-11-30 | 2016-11-03 | 1 | 2016-11-03 | 2016-11-15 | 0 | 0005309553 | 20161115.ifs | 2016-11-15 | 2016-11-16 | |||||||
2338695 | 2338695 | DIVIDEND | ADD | 413086109 | 0 | 0 | 1 | 0 | .35 | 00 | 2016-11-09 | 2016-11-14 | 2016-11-30 | 2016-11-03 | 0 | 2016-11-03 | ? | 0 | 0005309553 | 20161103.ifs | 2016-11-03 | 2016-11-04 | |||||||
2266801 | 2266801 | DIVIDEND | ADD | 413086109 | 0 | 0 | 1 | 0 | .35 | 00 | 2016-08-11 | 2016-08-15 | 2016-08-29 | 2016-08-04 | 0 | 2016-08-04 | ? | 0 | 0005263413 | 20160804.ifs | 2016-08-04 | 2016-08-05 | |||||||
2181298 | 2181298 | DIVIDEND | ADD | 413086109 | 0 | 0 | 1 | 0 | .35 | 00 | 2016-05-05 | 2016-05-09 | 2016-05-23 | 2016-04-28 | 0 | 2016-04-28 | ? | 0 | 0005208926 | 20160428.ifs | 2016-04-28 | 2016-04-29 | |||||||
2100231 | 2100231 | DIVIDEND | ADD | 413086109 | 0 | 0 | 1 | 0 | .35 | 00 | 2016-02-04 | 2016-02-08 | 2016-02-23 | 2016-01-28 | 0 | 2016-01-28 | ? | 0 | 0005162896 | 20160128.ifs | 2016-01-28 | 2016-01-29 | |||||||
1999264 | 1999264 | DIVIDEND | ADD | 413086109 | 0 | 0 | 1 | 0 | .35 | 00 | 2015-11-05 | 2015-11-09 | 2015-11-24 | 2015-10-29 | 0 | 2015-10-29 | ? | 0 | 0005083042 | 20151029.ifs | 2015-10-29 | 2015-10-30 | |||||||
1937181 | 1937181 | DIVIDEND | CHANGE | 413086109 | 0 | 0 | 1 | 0 | .33 | 00 | 2015-08-12 | 2015-08-14 | 2015-08-28 | 2015-08-04 | 0 | 2015-08-04 | ? | 0 | 0005043818 | 20150805.ifs | 2015-08-05 | 2015-08-06 | |||||||
1937182 | 1937181 | DIVIDEND | CHANGE | 413086109 | 0 | 0 | 1 | 0 | .35 | 00 | 2015-08-12 | 2015-08-14 | 2015-08-28 | 2015-08-04 | 1 | 2015-08-04 | 2015-08-05 | 0 | 0005043818 | 20150805.ifs | 2015-08-05 | 2015-08-06 | |||||||
1935930 | 1935930 | DIVIDEND | ADD | 413086109 | 0 | 0 | 1 | 0 | .33 | 00 | 2015-08-12 | 2015-08-14 | 2015-08-28 | 2015-08-04 | 0 | 2015-08-04 | ? | 0 | 0005043818 | 20150804.ifs | 2015-08-04 | 2015-08-05 | |||||||
1852370 | 1852370 | DIVIDEND | ADD | 413086109 | 0 | 0 | 1 | 0 | .33 | 00 | 2015-05-07 | 2015-05-11 | 2015-05-26 | 2015-04-30 | 0 | 2015-04-30 | ? | 0 | 0004991071 | 20150430.ifs | 2015-04-30 | 2015-05-01 | |||||||
1777388 | 1777388 | DIVIDEND | ADD | 413086109 | 0 | 0 | 1 | 0 | .33 | 00 | 2015-02-05 | 2015-02-09 | 2015-02-24 | 2015-01-29 | 0 | 2015-01-29 | ? | 0 | 0004944847 | 20150129.ifs | 2015-01-29 | 2015-01-30 | |||||||
1666096 | 1666096 | DIVIDEND | ADD | 413086109 | 0 | 0 | 1 | 0 | .33 | 00 | 2014-11-06 | 2014-11-10 | 2014-11-24 | 2014-10-30 | 0 | 2014-10-30 | ? | 0 | 0004863317 | 20141030.ifs | 2014-10-30 | 2014-10-31 | |||||||
1601413 | 1601413 | DIVIDEND | ADD | 413086109 | 0 | 0 | 1 | 0 | .33 | 00 | 2014-08-14 | 2014-08-18 | 2014-09-02 | 2014-08-07 | 0 | 2014-08-07 | ? | 0 | 0004827307 | 20140807.ifs | 2014-08-07 | 2014-08-08 | |||||||
1513670 | 1513670 | DIVIDEND | ADD | 413086109 | 0 | 0 | 1 | 0 | .3 | 00 | 2014-05-08 | 2014-05-12 | 2014-05-27 | 2014-05-01 | 0 | 2014-05-01 | ? | 0 | 0004776117 | 20140501.ifs | 2014-05-01 | 2014-05-02 | |||||||
1430555 | 1430555 | DIVIDEND | ADD | 413086109 | 0 | 0 | 1 | 0 | .3 | 00 | 2014-02-06 | 2014-02-10 | 2014-02-25 | 2014-01-30 | 0 | 2014-01-30 | ? | 0 | 0004726981 | 20140130.ifs | 2014-01-30 | 2014-01-31 | |||||||
1328205 | 1328205 | DIVIDEND | ADD | 413086109 | 0 | 0 | 1 | 0 | .3 | 00 | 2013-11-06 | 2013-11-11 | 2013-11-25 | 2013-10-31 | 0 | 2013-10-31 | ? | 0 | 0004649192 | 20131031.ifs | 2013-10-31 | 2013-11-01 | |||||||
1260430 | 1260430 | DIVIDEND | ADD | 413086109 | 0 | 0 | 1 | 0 | .3 | 00 | 2013-08-14 | 2013-08-16 | 2013-08-30 | 2013-08-06 | 0 | 2013-08-06 | ? | 0 | 0004613514 | 20130806.ifs | 2013-08-06 | 2013-08-07 | |||||||
1178986 | 1178986 | DIVIDEND | ADD | 413086109 | 0 | 0 | 1 | 0 | .15 | 00 | 2013-05-09 | 2013-05-13 | 2013-05-28 | 2013-05-02 | 0 | 2013-05-02 | ? | 0 | 0004568492 | 20130502.ifs | 2013-05-02 | 2013-05-03 | |||||||
1101265 | 1101265 | DIVIDEND | ADD | 413086109 | 0 | 0 | 1 | 0 | .15 | 00 | 2013-02-07 | 2013-02-11 | 2013-02-26 | 2013-01-31 | 0 | 2013-01-31 | ? | 0 | 0004519129 | 20130131.ifs | 2013-01-31 | 2013-02-01 | |||||||
1004195 | 1004195 | DIVIDEND | ADD | 413086109 | 0 | 0 | 1 | 0 | .15 | 00 | 2012-11-07 | 2012-11-12 | 2012-11-28 | 2012-11-02 | 0 | 2012-11-02 | ? | 0 | 0004455012 | 20121102.ifs | 2012-11-02 | 2012-11-03 | |||||||
931677 | 931677 | DIVIDEND | ADD | 413086109 | 0 | 0 | 1 | 0 | .15 | 00 | 2012-08-16 | 2012-08-20 | 2012-09-04 | 2012-08-10 | 0 | 2012-08-10 | ? | 0 | 0004415177 | 20120810.ifs | 2012-08-10 | 2012-08-11 | |||||||
847482 | 847482 | DIVIDEND | ADD | 413086109 | 0 | 0 | 1 | 0 | .075 | 00 | 2012-05-08 | 2012-05-10 | 2012-05-24 | 2012-04-30 | 0 | 2012-04-30 | ? | 0 | 0004365229 | 20120430.ifs | 2012-04-30 | 2012-05-01 | |||||||
775601 | 775601 | DIVIDEND | ADD | 413086109 | 0 | 0 | 1 | 0 | .075 | 00 | 2012-02-15 | 2012-02-17 | 2012-03-05 | 2012-02-07 | 0 | 2012-02-07 | ? | 0 | 0004331345 | 20120207.ifs | 2012-02-07 | 2012-02-08 | |||||||
612489 | 612489 | DIVIDEND | ADD | 413086109 | 0 | 0 | 1 | 0 | .075 | 00 | 2011-08-18 | 2011-08-22 | 2011-09-06 | 2011-08-10 | 0 | 2011-08-10 | ? | 0 | 0004228721 | 20110810.ifs | 2011-08-10 | 2011-08-11 | |||||||
519043 | 519043 | DIVIDEND | ADD | 413086109 | 0 | 0 | 1 | 0 | .025 | 00 | 2011-05-05 | 2011-05-09 | 2011-05-23 | 2011-04-28 | 0 | 2011-05-03 | ? | 0 | 0004185885 | 20110503.ifs | 2011-05-03 | 2011-05-04 | |||||||
444211 | 444211 | DIVIDEND | ADD | 413086109 | 0 | 0 | 1 | 0 | .025 | 00 | 2011-02-24 | 2011-02-28 | 2011-03-14 | 2011-02-16 | 0 | 2011-02-16 | ? | 0 | 0004147465 | 20110216.ifs | 2011-02-16 | 2011-02-17 |
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 = 135274
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