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:130531 |
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 | ||
2350208 | 2350208 | CORPACTION | ADD | 529771107 | 01 | A | 2016-11-29 | ? | 20161129.ifs | 2016-11-29 | 2016-11-30 | ||||||||||||||||||
2350209 | 2350209 | EQUITY | CHANGE | 529771107 | CL A | 0 | 0 | 1995-11-15 | ? | 4 | yes | no | no | 1997-03-07 | 2016-11-28 | ? | 20161129.ifs | 2016-11-29 | 2016-11-30 | ||||||||||
2350210 | 2350209 | EQUITY | CHANGE | 529771107 | CL A | A | 0 | 1995-11-15 | 2016-11-29 | 4 | yes | no | no | 1997-03-07 | 2016-11-29 | ? | 20161129.ifs | 2016-11-29 | 2016-11-30 | ||||||||||
2350639 | 2350639 | DIVIDEND | DELETE | 529771107 | 0 | 0 | 1 | 0 | .36 | 00 | 2016-11-30 | 2016-12-02 | 2016-12-16 | 2016-10-28 | 2 | 2016-10-28 | 2016-11-25 | 0 | 0005302320 | 20161129.ifs | 2016-11-29 | 2016-11-30 | |||||||
2349194 | 2349194 | CORPACTION | ADD | 529771107 | 01 | A | 2016-11-28 | ? | 20161128.ifs | 2016-11-28 | 2016-11-29 | ||||||||||||||||||
2349195 | 2349195 | EQUITY | CHANGE | 529771107 | CL A | 0 | 0 | 1995-11-15 | ? | 4 | yes | no | no | 1997-03-07 | 2016-07-07 | ? | 20161128.ifs | 2016-11-28 | 2016-11-29 | ||||||||||
2349196 | 2349195 | EQUITY | CHANGE | 529771107 | CL A | A | 0 | 1995-11-15 | 2016-11-28 | 4 | yes | no | no | 1997-03-07 | 2016-11-28 | ? | 20161128.ifs | 2016-11-28 | 2016-11-29 | ||||||||||
2349259 | 2349259 | CORPACTION | DELETE | 529771107 | 01 | A | 2016-11-28 | ? | 20161128.ifs | 2016-11-28 | 2016-11-29 | ||||||||||||||||||
2349260 | 2349260 | EQUITY | CHANGE | 529771107 | CL A | A | 0 | 1995-11-15 | 2016-11-28 | 4 | yes | no | no | 1997-03-07 | 2016-11-28 | ? | 20161128.ifs | 2016-11-28 | 2016-11-29 | ||||||||||
2349261 | 2349260 | EQUITY | CHANGE | 529771107 | CL A | 0 | 0 | 1995-11-15 | ? | 4 | yes | no | no | 1997-03-07 | 2016-11-28 | ? | 20161128.ifs | 2016-11-28 | 2016-11-29 | ||||||||||
2348932 | 2348932 | DIVIDEND | CHANGE | 529771107 | 0 | 0 | 1 | 0 | .36 | 00 | 2016-11-30 | 2016-12-02 | 2016-12-16 | 2016-10-28 | 1 | 2016-10-28 | 2016-11-23 | 0 | 0005302320 | 20161125.ifs | 2016-11-25 | 2016-11-26 | |||||||
2348933 | 2348932 | DIVIDEND | CHANGE | 529771107 | 0 | 0 | 1 | 0 | .36 | 00 | 2016-11-30 | 2016-12-02 | 2016-12-16 | 2016-10-28 | 2 | 2016-10-28 | 2016-11-25 | 0 | 0005302320 | 20161125.ifs | 2016-11-25 | 2016-11-26 | |||||||
2348473 | 2348473 | DIVIDEND | CHANGE | 529771107 | 0 | 0 | 1 | 0 | .36 | 00 | 2016-11-30 | 2016-12-02 | 2016-12-16 | 2016-10-28 | 0 | 2016-10-28 | ? | 0 | 0005302320 | 20161123.ifs | 2016-11-23 | 2016-11-24 | |||||||
2348474 | 2348473 | DIVIDEND | CHANGE | 529771107 | 0 | 0 | 1 | 0 | .36 | 00 | 2016-11-30 | 2016-12-02 | 2016-12-16 | 2016-10-28 | 1 | 2016-10-28 | 2016-11-23 | 0 | 0005302320 | 20161123.ifs | 2016-11-23 | 2016-11-24 | |||||||
2329062 | 2329062 | DIVIDEND | ADD | 529771107 | 0 | 0 | 1 | 0 | .36 | 00 | 2016-11-30 | 2016-12-02 | 2016-12-16 | 2016-10-28 | 0 | 2016-10-28 | ? | 0 | 0005302320 | 20161028.ifs | 2016-10-28 | 2016-10-29 | |||||||
2261340 | 2261340 | DIVIDEND | ADD | 529771107 | 0 | 0 | 1 | 0 | .36 | 00 | 2016-08-31 | 2016-09-02 | 2016-09-16 | 2016-07-29 | 0 | 2016-07-29 | ? | 0 | 0005255910 | 20160729.ifs | 2016-07-29 | 2016-07-30 | |||||||
2247320 | 2247320 | EQUITY | CHANGE | 529771107 | CL A | 0 | 0 | 1995-11-15 | ? | 8 | yes | yes | no | 1997-03-07 | 2014-03-10 | ? | 20160707.ifs | 2016-07-07 | 2016-07-08 | ||||||||||
2247321 | 2247320 | EQUITY | CHANGE | 529771107 | CL A | 0 | 0 | 1995-11-15 | ? | 4 | yes | no | no | 1997-03-07 | 2016-07-07 | ? | 20160707.ifs | 2016-07-07 | 2016-07-08 | ||||||||||
2168693 | 2168693 | DIVIDEND | CHANGE | 529771107 | 0 | 0 | 1 | 0 | .36 | 00 | 2016-06-01 | 2016-06-03 | 2016-06-17 | 2016-04-20 | 0 | 2016-04-20 | ? | 0 | 0005206502 | 20160421.ifs | 2016-04-21 | 2016-04-22 | |||||||
2168694 | 2168693 | DIVIDEND | CHANGE | 529771107 | 0 | 0 | 1 | 0 | .36 | 00 | 2016-06-01 | 2016-06-03 | 2016-06-17 | 2016-04-20 | 1 | 2016-04-20 | 2016-04-21 | 0 | 0005206502 | 20160421.ifs | 2016-04-21 | 2016-04-22 | |||||||
2167716 | 2167716 | DIVIDEND | ADD | 529771107 | 0 | 0 | 1 | 0 | .36 | 00 | 2016-06-01 | 2016-06-03 | 2016-06-17 | 2016-04-20 | 0 | 2016-04-20 | ? | 0 | 0005206502 | 20160420.ifs | 2016-04-20 | 2016-04-21 | |||||||
2114942 | 2114942 | DIVIDEND | ADD | 529771107 | 0 | 0 | 1 | 0 | .36 | 00 | 2016-02-25 | 2016-02-29 | 2016-03-11 | 2016-02-18 | 0 | 2016-02-18 | ? | 0 | 0005173702 | 20160218.ifs | 2016-02-18 | 2016-02-19 | |||||||
1995063 | 1995063 | DIVIDEND | ADD | 529771107 | 0 | 0 | 1 | 0 | .36 | 00 | 2015-11-24 | 2015-11-27 | 2015-12-11 | 2015-10-22 | 0 | 2015-10-22 | ? | 0 | 0005081539 | 20151022.ifs | 2015-10-22 | 2015-10-23 | |||||||
1921832 | 1921832 | DIVIDEND | ADD | 529771107 | 0 | 0 | 1 | 0 | .36 | 00 | 2015-08-26 | 2015-08-28 | 2015-09-11 | 2015-07-23 | 0 | 2015-07-23 | ? | 0 | 0005035213 | 20150723.ifs | 2015-07-23 | 2015-07-24 | |||||||
1844256 | 1844256 | DIVIDEND | ADD | 529771107 | 0 | 0 | 1 | 0 | .36 | 00 | 2015-05-27 | 2015-05-29 | 2015-06-12 | 2015-04-21 | 0 | 2015-04-21 | ? | 0 | 0004987902 | 20150421.ifs | 2015-04-21 | 2015-04-22 | |||||||
1662019 | 1662019 | DIVIDEND | ADD | 529771107 | 0 | 0 | 1 | 0 | .36 | 00 | 2014-11-25 | 2014-11-28 | 2014-12-12 | 2014-10-23 | 0 | 2014-10-23 | ? | 0 | 0004861741 | 20141023.ifs | 2014-10-23 | 2014-10-24 | |||||||
1586847 | 1586847 | DIVIDEND | DELETE | 529771107 | 0 | 0 | 1 | 0 | .36 | 00 | 2014-08-27 | 2014-08-29 | 2014-09-13 | 2014-07-24 | 0 | 2014-07-24 | ? | 0 | 0004817440 | 20140725.ifs | 2014-07-25 | 2014-07-26 | |||||||
1586848 | 1586848 | DIVIDEND | ADD | 529771107 | 0 | 0 | 1 | 0 | .36 | 00 | 2014-08-27 | 2014-08-29 | 2014-09-12 | 2014-07-24 | 1 | 2014-07-24 | 2014-07-25 | 0 | 0004817440 | 20140725.ifs | 2014-07-25 | 2014-07-26 | |||||||
1586084 | 1586084 | DIVIDEND | ADD | 529771107 | 0 | 0 | 1 | 0 | .36 | 00 | 2014-08-27 | 2014-08-29 | 2014-09-13 | 2014-07-24 | 0 | 2014-07-24 | ? | 0 | 0004817440 | 20140724.ifs | 2014-07-24 | 2014-07-25 | |||||||
1501555 | 1501555 | DIVIDEND | ADD | 529771107 | 0 | 0 | 1 | 0 | .36 | 00 | 2014-05-28 | 2014-05-30 | 2014-06-13 | 2014-04-24 | 0 | 2014-04-24 | ? | 0 | 0004770868 | 20140424.ifs | 2014-04-24 | 2014-04-25 | |||||||
1463525 | 1463525 | EQUITY | CHANGE | 529771107 | CL A | 0 | 0 | 1995-11-15 | ? | 8 | yes | yes | no | 1997-03-07 | 2000-08-01 | ? | 20140310.ifs | 2014-03-10 | 2014-03-11 | ||||||||||
1463526 | 1463525 | EQUITY | CHANGE | 529771107 | CL A | 0 | 0 | 1995-11-15 | ? | 8 | yes | yes | no | 1997-03-07 | 2014-03-10 | ? | 20140310.ifs | 2014-03-10 | 2014-03-11 | ||||||||||
1463528 | 1463527 | EQUITY | CHANGE | 529771107 | 01 | # | 2000-04-27 | 529771107 | 01 | 2000-07-31 | 20140310.ifs | 2014-03-10 | 2014-03-11 | ||||||||||||||||
1463529 | 1463528 | EQUITY | CHANGE | 529771107 | 01 | # | 2000-04-27 | 529771107 | 01 | 2014-03-10 | 20140310.ifs | 2014-03-10 | 2014-03-11 | ||||||||||||||||
1463531 | 1463530 | EQUITY | CHANGE | 529771107 | 01 | 2000-04-27 | LXK | LEXMARK INTL GROUP INC | CL A | LXK | LEXMARK INTL INC NEW | CL A | ? | 2000-07-31 | 20140310.ifs | 2014-03-10 | 2014-03-11 | ||||||||||||
1463532 | 1463531 | EQUITY | CHANGE | 529771107 | 01 | 2000-04-27 | LXK | LEXMARK INTL GROUP INC | CL A | LXK | LEXMARK INTL INC NEW | CL A | ? | 2014-03-10 | 20140310.ifs | 2014-03-10 | 2014-03-11 | ||||||||||||
1463533 | 1463533 | EXCHANGE | CHANGE | 529771107 | 01 | 1995-11-15 | 2014-03-07 | LXK | 0 | 0 | 2001-01-29 | 2000-08-01 | 20140310.ifs | 2014-03-10 | 2014-03-11 | ||||||||||||||
1463534 | 1463533 | EXCHANGE | CHANGE | 529771107 | 01 | 1995-11-15 | 2014-03-07 | LXK | 0 | 0 | 2001-01-29 | 2014-03-10 | 20140310.ifs | 2014-03-10 | 2014-03-11 | ||||||||||||||
1463535 | 1463535 | SPLIT | CHANGE | 529771107 | .5 | 1999-06-11 | 11 | 1999-05-05 | 2000-08-08 | 20140310.ifs | 2014-03-10 | 2014-03-11 | |||||||||||||||||
1463536 | 1463535 | SPLIT | CHANGE | 529771107 | .5 | 1999-06-11 | 11 | 1999-05-05 | 2014-03-10 | 20140310.ifs | 2014-03-10 | 2014-03-11 | |||||||||||||||||
1446955 | 1446955 | DIVIDEND | ADD | 529771107 | 0 | 0 | 1 | 0 | .3 | 00 | 2014-02-27 | 2014-03-03 | 2014-03-14 | 2014-02-20 | 0 | 2014-02-20 | ? | 0 | 0004738209 | 20140220.ifs | 2014-02-20 | 2014-02-21 | |||||||
1322446 | 1322446 | DIVIDEND | ADD | 529771107 | 0 | 0 | 1 | 0 | .3 | 00 | 2013-11-26 | 2013-11-29 | 2013-12-13 | 2013-10-24 | 0 | 2013-10-24 | ? | 0 | 0004647619 | 20131024.ifs | 2013-10-24 | 2013-10-25 | |||||||
1246761 | 1246761 | DIVIDEND | ADD | 529771107 | 0 | 0 | 1 | 0 | .3 | 00 | 2013-08-28 | 2013-08-30 | 2013-09-13 | 2013-07-25 | 0 | 2013-07-25 | ? | 0 | 0004604599 | 20130725.ifs | 2013-07-25 | 2013-07-26 | |||||||
1167313 | 1167313 | DIVIDEND | ADD | 529771107 | 0 | 0 | 1 | 0 | .3 | 00 | 2013-05-29 | 2013-05-31 | 2013-06-14 | 2013-04-25 | 0 | 2013-04-25 | ? | 0 | 0004560779 | 20130425.ifs | 2013-04-25 | 2013-04-26 | |||||||
1115651 | 1115651 | DIVIDEND | ADD | 529771107 | 0 | 0 | 1 | 0 | .3 | 00 | 2013-02-28 | 2013-03-04 | 2013-03-15 | 2013-02-21 | 0 | 2013-02-21 | ? | 0 | 0004529850 | 20130221.ifs | 2013-02-21 | 2013-02-22 | |||||||
992714 | 992714 | DIVIDEND | ADD | 529771107 | 0 | 0 | 1 | 0 | .3 | 00 | 2012-11-28 | 2012-11-30 | 2012-12-14 | 2012-10-25 | 0 | 2012-10-25 | ? | 0 | 0004448129 | 20121025.ifs | 2012-10-25 | 2012-10-26 | |||||||
921964 | 921964 | DIVIDEND | ADD | 529771107 | 0 | 0 | 1 | 0 | .3 | 00 | 2012-08-29 | 2012-08-31 | 2012-09-14 | 2012-07-26 | 0 | 2012-07-26 | ? | 0 | 0004405640 | 20120726.ifs | 2012-07-26 | 2012-07-27 | |||||||
843859 | 843859 | DIVIDEND | ADD | 529771107 | 0 | 0 | 1 | 0 | .3 | 00 | 2012-05-30 | 2012-06-01 | 2012-06-15 | 2012-04-26 | 0 | 2012-04-26 | ? | 0 | 0004364338 | 20120426.ifs | 2012-04-26 | 2012-04-27 | |||||||
784034 | 784034 | DIVIDEND | ADD | 529771107 | 0 | 0 | 1 | 0 | .25 | 00 | 2012-03-01 | 2012-03-05 | 2012-03-16 | 2012-02-23 | 0 | 2012-02-23 | ? | 0 | 0004335164 | 20120223.ifs | 2012-02-23 | 2012-02-24 | |||||||
679323 | 679323 | DIVIDEND | ADD | 529771107 | 0 | 0 | 1 | 1 | .25 | 06 | 2011-11-10 | 2011-11-15 | 2011-11-30 | 2011-10-27 | 0 | 2011-10-27 | ? | 0 | 0004260849 | 20111027.ifs | 2011-10-27 | 2011-10-28 |
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 = 130531
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