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:159658 |
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 | ||
2098785 | 2098785 | EQUITY | CHANGE | 19238V105 | COM | Q | 0 | 1993-11-04 | 2016-01-26 | 4 | yes | no | 19239C106 | no | 1994-10-25 | 2016-01-26 | ? | 20160127.ifs | 2016-01-27 | 2016-01-28 | |||||||||
2098786 | 2098785 | EQUITY | CHANGE | 19238V105 | COM | Q | 0 | 1993-11-04 | 2016-01-27 | 4 | yes | no | 19239C106 | no | 1994-10-25 | 2016-01-27 | ? | 20160127.ifs | 2016-01-27 | 2016-01-28 | |||||||||
2098787 | 2098787 | CORPACTION | ADD | 19238V105 | 66 | Q | 2016-01-27 | 19239C106 | 66 | ? | 20160127.ifs | 2016-01-27 | 2016-01-28 | ||||||||||||||||
2098915 | 2098915 | EXCHANGE | CHANGE | 19238V105 | 66 | 2004-04-23 | 2016-01-20 | CGEAF | 0 | 0 | 2005-08-04 | 2005-02-16 | 20160127.ifs | 2016-01-27 | 2016-01-28 | ||||||||||||||
2098916 | 2098915 | EXCHANGE | CHANGE | 19238V105 | 66 | 2004-04-23 | 2016-01-26 | CGEAF | 0 | 0 | 2005-08-04 | 2016-01-27 | 20160127.ifs | 2016-01-27 | 2016-01-28 | ||||||||||||||
2098145 | 2098145 | EQUITY | CHANGE | 19238V105 | COM | 0 | 0 | 1993-11-04 | ? | 4 | yes | no | no | 1994-10-25 | 2004-10-12 | ? | 20160126.ifs | 2016-01-26 | 2016-01-27 | ||||||||||
2098146 | 2098145 | EQUITY | CHANGE | 19238V105 | COM | Q | 0 | 1993-11-04 | 2016-01-26 | 4 | yes | no | 19239C106 | no | 1994-10-25 | 2016-01-26 | ? | 20160126.ifs | 2016-01-26 | 2016-01-27 | |||||||||
2097823 | 2097823 | DIVIDEND | CHANGE | 19238V105 | A | 0 | 2 | 0 | .39 | 15 | 2016-01-22 | 2016-01-26 | 2016-02-09 | 2016-01-14 | 0 | 2016-01-15 | ? | 0 | 0005160268 | 20160125.ifs | 2016-01-25 | 2016-01-26 | |||||||
2097824 | 2097823 | DIVIDEND | CHANGE | 19238V105 | A | 0 | 2 | 0 | .39 | 15 | 2016-01-22 | 2016-01-26 | 2016-02-09 | 2016-01-14 | 1 | 2016-01-15 | 2016-01-25 | 0 | 0005160268 | 20160125.ifs | 2016-01-25 | 2016-01-26 | |||||||
2094041 | 2094041 | DIVIDEND | ADD | 19238V105 | A | 0 | 2 | 0 | .39 | 15 | 2016-01-22 | 2016-01-26 | 2016-02-09 | 2016-01-14 | 0 | 2016-01-15 | ? | 0 | 0005160268 | 20160115.ifs | 2016-01-15 | 2016-01-16 | |||||||
1999441 | 1999441 | DIVIDEND | ADD | 19238V105 | A | 0 | 2 | 0 | .39 | 15 | 2015-11-06 | 2015-11-11 | 2015-11-25 | 2015-10-29 | 0 | 2015-10-29 | ? | 0 | 0005083786 | 20151029.ifs | 2015-10-29 | 2015-10-30 | |||||||
1917317 | 1917317 | DIVIDEND | ADD | 19238V105 | A | 0 | 2 | 0 | .35 | 15 | 2015-07-24 | 2015-07-28 | 2015-08-11 | 2015-07-15 | 0 | 2015-07-15 | ? | 0 | 0005033253 | 20150715.ifs | 2015-07-15 | 2015-07-16 | |||||||
1838005 | 1838005 | DIVIDEND | ADD | 19238V105 | A | 0 | 2 | 0 | .35 | 15 | 2015-04-20 | 2015-04-22 | 2015-05-06 | 2015-04-08 | 0 | 2015-04-09 | ? | 0 | 0004985130 | 20150409.ifs | 2015-04-09 | 2015-04-10 | |||||||
1769498 | 1769498 | DIVIDEND | ADD | 19238V105 | A | 0 | 2 | 0 | .35 | 15 | 2015-01-23 | 2015-01-27 | 2015-02-10 | 2015-01-14 | 0 | 2015-01-15 | ? | 0 | 0004941667 | 20150115.ifs | 2015-01-15 | 2015-01-16 | |||||||
1673556 | 1673556 | DIVIDEND | ADD | 19238V105 | A | 0 | 2 | 0 | .35 | 15 | 2014-11-12 | 2014-11-14 | 2014-11-28 | 2014-11-03 | 0 | 2014-11-03 | ? | 0 | 0004870087 | 20141103.ifs | 2014-11-03 | 2014-11-04 | |||||||
1578082 | 1578082 | DIVIDEND | ADD | 19238V105 | A | 0 | 2 | 0 | .3 | 15 | 2014-07-21 | 2014-07-23 | 2014-08-06 | 2014-07-09 | 0 | 2014-07-10 | ? | 0 | 0004814309 | 20140710.ifs | 2014-07-10 | 2014-07-11 | |||||||
1494472 | 1494472 | DIVIDEND | ADD | 19238V105 | A | 0 | 2 | 0 | .3 | 15 | 2014-04-21 | 2014-04-23 | 2014-05-07 | 2014-04-09 | 0 | 2014-04-10 | ? | 0 | 0004767571 | 20140410.ifs | 2014-04-10 | 2014-04-11 | |||||||
1422328 | 1422328 | DIVIDEND | ADD | 19238V105 | A | 0 | 2 | 0 | .3 | 15 | 2014-01-23 | 2014-01-27 | 2014-02-10 | 2014-01-13 | 0 | 2014-01-14 | ? | 0 | 0004723904 | 20140114.ifs | 2014-01-14 | 2014-01-15 | |||||||
1328973 | 1328973 | DIVIDEND | ADD | 19238V105 | A | 0 | 2 | 0 | .3 | 15 | 2013-11-08 | 2013-11-13 | 2013-11-27 | 2013-10-31 | 0 | 2013-10-31 | ? | 0 | 0004650495 | 20131031.ifs | 2013-10-31 | 2013-11-01 | |||||||
1238928 | 1238928 | DIVIDEND | ADD | 19238V105 | A | 0 | 2 | 0 | .26 | 15 | 2013-07-22 | 2013-07-24 | 2013-08-07 | 2013-07-10 | 0 | 2013-07-11 | ? | 0 | 0004601080 | 20130711.ifs | 2013-07-11 | 2013-07-12 | |||||||
1090678 | 1090678 | DIVIDEND | ADD | 19238V105 | A | 0 | 2 | 0 | .26 | 15 | 2013-01-24 | 2013-01-28 | 2013-02-11 | 2013-01-14 | 0 | 2013-01-15 | ? | 0 | 0004514988 | 20130115.ifs | 2013-01-15 | 2013-01-16 | |||||||
1004385 | 1004385 | DIVIDEND | ADD | 19238V105 | A | 0 | 2 | 0 | .26 | 15 | 2012-11-14 | 2012-11-16 | 2012-11-29 | 2012-11-02 | 0 | 2012-11-02 | ? | 0 | 0004455955 | 20121102.ifs | 2012-11-02 | 2012-11-03 | |||||||
911841 | 911841 | DIVIDEND | ADD | 19238V105 | A | 0 | 2 | 0 | .25 | 15 | 2012-07-23 | 2012-07-25 | 2012-08-08 | 2012-07-11 | 0 | 2012-07-12 | ? | 0 | 0004402255 | 20120712.ifs | 2012-07-12 | 2012-07-13 | |||||||
834352 | 834352 | DIVIDEND | ADD | 19238V105 | A | 0 | 2 | 0 | .25 | 15 | 2012-04-23 | 2012-04-25 | 2012-05-09 | 2012-04-11 | 0 | 2012-04-12 | ? | 0 | 0004361063 | 20120412.ifs | 2012-04-12 | 2012-04-13 | |||||||
763344 | 763344 | DIVIDEND | ADD | 19238V105 | A | 0 | 2 | 0 | .25 | 15 | 2012-02-06 | 2012-02-08 | 2012-02-22 | 2012-01-25 | 0 | 2012-01-26 | ? | 0 | 0004323202 | 20120126.ifs | 2012-01-26 | 2012-01-27 | |||||||
679483 | 679483 | DIVIDEND | ADD | 19238V105 | A | 0 | 2 | 0 | .25 | 15 | 2011-11-07 | 2011-11-09 | 2011-11-23 | 2011-10-26 | 0 | 2011-10-27 | ? | 0 | 0004260583 | 20111027.ifs | 2011-10-27 | 2011-10-28 | |||||||
499490 | 499490 | DIVIDEND | ADD | 19238V105 | A | 0 | 2 | 0 | .17 | 15 | 2011-04-19 | 2011-04-21 | 2011-05-05 | 2011-04-07 | 0 | 2011-04-08 | ? | 0 | 0004174572 | 20110408.ifs | 2011-04-08 | 2011-04-09 | |||||||
418472 | 418472 | DIVIDEND | ADD | 19238V105 | A | 0 | 2 | 0 | .17 | 15 | 2011-01-24 | 2011-01-26 | 2011-02-09 | 2011-01-12 | 0 | 2011-01-13 | ? | 0 | 0004134621 | 20110113.ifs | 2011-01-13 | 2011-01-14 | |||||||
343024 | 343024 | DIVIDEND | ADD | 19238V105 | A | 0 | 2 | 0 | .17 | 15 | 2010-11-08 | 2010-11-10 | 2010-11-24 | 2010-10-27 | 0 | 2010-10-27 | ? | 0 | 0004077862 | 20101027.ifs | 2010-10-27 | 2010-10-28 | |||||||
245991 | 245991 | DIVIDEND | ADD | 19238V105 | A | 0 | 2 | 0 | .14 | 15 | 2010-07-19 | 2010-07-21 | 2010-08-04 | 2010-07-07 | 0 | 2010-07-09 | ? | 0 | 0004032715 | 20100709.ifs | 2010-07-09 | 2010-07-10 | |||||||
156403 | 156403 | DIVIDEND | ADD | 19238V105 | A | 0 | 2 | 0 | .14 | 15 | 2010-04-19 | 2010-04-21 | 2010-05-05 | 2010-04-07 | 0 | 2010-04-08 | ? | 0 | 0003992203 | 20100408.ifs | 2010-04-08 | 2010-04-09 | |||||||
87659 | 87659 | DIVIDEND | ADD | 19238V105 | A | 0 | 2 | 0 | .14 | 15 | 2010-01-22 | 2010-01-26 | 2010-02-09 | 2010-01-13 | 0 | 2010-01-13 | ? | 0 | 0003953493 | 20100113.ifs | 2010-01-13 | 2010-04-07 | |||||||
10076 | 10076 | DIVIDEND | ADD | 19238V105 | A | 0 | 2 | 0 | .14 | 15 | 2009-11-09 | 2009-11-12 | 2009-11-26 | 2009-10-29 | 0 | 2009-10-29 | ? | 0 | 0003900114 | 20091029.ifs | 2009-10-29 | 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 = 159658
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