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:142477 |
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 | ||
2625082 | 2625082 | CORPACTION | ADD | 009606104 | 66 | D | 2017-07-18 | ? | 20170718.ifs | 2017-07-18 | 2017-07-19 | ||||||||||||||||||
2625083 | 2625083 | EQUITY | CHANGE | 009606104 | SPONSORED ADR REPSTG ORD SHS | 0 | 0 | 2004-10-13 | ? | 0 | no | no | yes | ? | 2017-01-23 | ? | 20170718.ifs | 2017-07-18 | 2017-07-19 | ||||||||||
2625084 | 2625083 | EQUITY | CHANGE | 009606104 | SPONSORED ADR REPSTG ORD SHS | D | 0 | 2004-10-13 | 2017-07-18 | 0 | no | no | yes | ? | 2017-07-18 | ? | 20170718.ifs | 2017-07-18 | 2017-07-19 | ||||||||||
2448411 | 2448411 | CORPACTION | DELETE | 009606104 | 60 | D | 2017-01-03 | ? | 20170123.ifs | 2017-01-23 | 2017-01-24 | ||||||||||||||||||
2448412 | 2448412 | CORPACTION | ADD | 009606104 | 60 | X | 2017-01-18 | 009606104 | 66 | 2017-01-23 | 20170123.ifs | 2017-01-23 | 2017-01-24 | ||||||||||||||||
2448413 | 2448413 | EQUITY | CHANGE | 009606104 | SPONSORED ADR REPSTG ORD SHS | D | 0 | 2004-10-13 | 2017-01-18 | 0 | no | no | yes | ? | 2017-01-18 | ? | 20170123.ifs | 2017-01-23 | 2017-01-24 | ||||||||||
2448414 | 2448413 | EQUITY | CHANGE | 009606104 | SPONSORED ADR REPSTG ORD SHS | 0 | 0 | 2004-10-13 | ? | 0 | no | no | yes | ? | 2017-01-23 | ? | 20170123.ifs | 2017-01-23 | 2017-01-24 | ||||||||||
2427412 | 2427412 | EXCHANGE | ADD | 009606104 | 66 | 2017-01-18 | ? | AIXNY | 0 | 0 | 2017-01-18 | ? | 20170118.ifs | 2017-01-18 | 2017-01-19 | ||||||||||||||
2427413 | 2427413 | EQUITY | CHANGE | 009606104 | SPONSORED ADR REPSTG ORD SHS | D | 0 | 2004-10-13 | 2017-01-03 | 0 | no | no | yes | ? | 2017-01-03 | ? | 20170118.ifs | 2017-01-18 | 2017-01-19 | ||||||||||
2427414 | 2427413 | EQUITY | CHANGE | 009606104 | SPONSORED ADR REPSTG ORD SHS | D | 0 | 2004-10-13 | 2017-01-18 | 0 | no | no | yes | ? | 2017-01-18 | ? | 20170118.ifs | 2017-01-18 | 2017-01-19 | ||||||||||
2414149 | 2414149 | CORPACTION | ADD | 009606104 | 60 | D | 2017-01-03 | ? | 20170103.ifs | 2017-01-03 | 2017-01-04 | ||||||||||||||||||
2414150 | 2414150 | EQUITY | CHANGE | 009606104 | SPONSORED ADR REPSTG ORD SHS | 0 | 0 | 2004-10-13 | ? | 0 | no | no | yes | ? | 2011-01-12 | ? | 20170103.ifs | 2017-01-03 | 2017-01-04 | ||||||||||
2414151 | 2414150 | EQUITY | CHANGE | 009606104 | SPONSORED ADR REPSTG ORD SHS | D | 0 | 2004-10-13 | 2017-01-03 | 0 | no | no | yes | ? | 2017-01-03 | ? | 20170103.ifs | 2017-01-03 | 2017-01-04 | ||||||||||
866055 | 866055 | DIVIDEND | DELETE | 009606104 | B | 0 | 1 | 5 | .220551 | 0 | 39 | 2012-05-17 | 2012-05-16 | 2012-05-29 | 2012-04-05 | 0 | ? | 2012-05-17 | 0 | 0004360339 | 20120522.ifs | 2012-05-22 | 2012-05-23 | ||||||
866056 | 866056 | DIVIDEND | ADD | 009606104 | B | 0 | 1 | 0 | .214569 | 0 | 02 | 2012-05-17 | 2012-05-16 | 2012-05-29 | 2012-04-05 | 0 | ? | 2012-05-22 | 0 | 0004360339 | 20120522.ifs | 2012-05-22 | 2012-05-23 | ||||||
862707 | 862707 | DIVIDEND | DELETE | 009606104 | B | 1 | 5 | .220551 | 39 | 2012-05-17 | 2012-05-16 | 2012-05-29 | ? | 0 | 2012-05-16 | ? | 0 | 0004360339 | 20120517.ifs | 2012-05-17 | 2012-05-18 | ||||||||
862708 | 862708 | DIVIDEND | ADD | 009606104 | B | 0 | 1 | 5 | .220551 | 0 | 39 | 2012-05-17 | 2012-05-16 | 2012-05-29 | 2012-04-05 | 0 | ? | 2012-05-17 | 0 | 0004360339 | 20120517.ifs | 2012-05-17 | 2012-05-18 | ||||||
862635 | 862635 | DIVIDEND | ADD | 009606104 | B | 1 | 5 | .220551 | 39 | 2012-05-17 | 2012-05-16 | 2012-05-29 | ? | 0 | 2012-05-16 | ? | 0 | 0004360339 | 20120516.ifs | 2012-05-16 | 2012-05-17 | ||||||||
834382 | 834382 | DIVIDEND | DELETE | 009606104 | B | 0 | 1 | 5 | .220551 | 39 | 2012-05-14 | 2012-05-16 | 2012-05-29 | 2012-04-05 | 1 | 2012-04-05 | 2012-04-09 | 0 | 0004360339 | 20120412.ifs | 2012-04-12 | 2012-04-13 | |||||||
832534 | 832534 | DIVIDEND | DELETE | 009606104 | B | 0 | 1 | 5 | .220551 | 39 | ? | 2012-05-16 | 2012-05-29 | 2012-04-05 | 0 | 2012-04-05 | ? | 0 | 0004360339 | 20120409.ifs | 2012-04-09 | 2012-04-10 | |||||||
832535 | 832535 | DIVIDEND | ADD | 009606104 | B | 0 | 1 | 5 | .220551 | 39 | 2012-05-14 | 2012-05-16 | 2012-05-29 | 2012-04-05 | 1 | 2012-04-05 | 2012-04-09 | 0 | 0004360339 | 20120409.ifs | 2012-04-09 | 2012-04-10 | |||||||
831896 | 831896 | DIVIDEND | ADD | 009606104 | B | 0 | 1 | 5 | .220551 | 39 | ? | 2012-05-16 | 2012-05-29 | 2012-04-05 | 0 | 2012-04-05 | ? | 0 | 0004360339 | 20120405.ifs | 2012-04-05 | 2012-04-06 | |||||||
532894 | 532894 | DIVIDEND | DELETE | 009606104 | B | 1 | 0 | .597124 | 02 | 2011-05-24 | 2011-05-19 | 2011-05-31 | ? | 0 | 2011-05-23 | ? | 0 | 0004177789 | 20110524.ifs | 2011-05-24 | 2011-05-25 | ||||||||
532895 | 532895 | DIVIDEND | ADD | 009606104 | B | 0 | 1 | 0 | .597124 | 0 | 02 | 2011-05-24 | 2011-05-19 | 2011-05-31 | 2011-04-26 | 0 | ? | 2011-05-24 | 0 | 0004177789 | 20110524.ifs | 2011-05-24 | 2011-05-25 | ||||||
532831 | 532831 | DIVIDEND | ADD | 009606104 | B | 1 | 0 | .597124 | 02 | 2011-05-24 | 2011-05-19 | 2011-05-31 | ? | 0 | 2011-05-23 | ? | 0 | 0004177789 | 20110523.ifs | 2011-05-23 | 2011-05-24 | ||||||||
509301 | 509301 | DIVIDEND | DELETE | 009606104 | B | 0 | 1 | 5 | .625926 | 39 | 2011-05-17 | 2011-05-19 | 2011-05-31 | 2011-04-26 | 0 | 2011-04-26 | ? | 0 | 0004177789 | 20110427.ifs | 2011-04-27 | 2011-04-28 | |||||||
509278 | 509278 | DIVIDEND | ADD | 009606104 | B | 0 | 1 | 5 | .625926 | 39 | 2011-05-17 | 2011-05-19 | 2011-05-31 | 2011-04-26 | 0 | 2011-04-26 | ? | 0 | 0004177789 | 20110426.ifs | 2011-04-26 | 2011-04-27 | |||||||
417575 | 417575 | EQUITY | CHANGE | 009606104 | SPN ADR REP ORD | 0 | 0 | 2004-10-13 | ? | 0 | no | no | yes | ? | 2007-08-01 | ? | 20110112.ifs | 2011-01-12 | 2011-01-13 | ||||||||||
417576 | 417575 | EQUITY | CHANGE | 009606104 | SPONSORED ADR REPSTG ORD SHS | 0 | 0 | 2004-10-13 | ? | 0 | no | no | yes | ? | 2011-01-12 | ? | 20110112.ifs | 2011-01-12 | 2011-01-13 | ||||||||||
417579 | 417579 | CORPACTION | ADD | 009606104 | 60 | # | 2011-01-12 | 009606104 | 60 | 2011-01-12 | 20110112.ifs | 2011-01-12 | 2011-01-13 | ||||||||||||||||
417580 | 417580 | CORPACTIONAUX | ADD | 009606104 | 60 | 2011-01-12 | AIXG | AIXTRON AKTIENGESELLSCHAFT | SPN ADR REP ORD | AIXG | AIXTRON SE | SPONSORED ADR R | ? | 2011-01-12 | 20110112.ifs | 2011-01-12 | 2011-01-13 | ||||||||||||
417581 | 417581 | EXCHANGE | CHANGE | 009606104 | 60 | 2005-03-11 | 2011-01-11 | AIXG | 0 | 0 | 2005-03-15 | 2005-03-15 | 20110112.ifs | 2011-01-12 | 2011-01-13 | ||||||||||||||
417582 | 417581 | EXCHANGE | CHANGE | 009606104 | 60 | 2005-03-11 | 2011-01-11 | AIXG | 0 | 0 | 2005-03-15 | 2011-01-12 | 20110112.ifs | 2011-01-12 | 2011-01-13 | ||||||||||||||
195414 | 195414 | DIVIDEND | DELETE | 009606104 | B | 0 | 1 | 5 | .15036 | 39 | 2010-05-14 | 2010-05-18 | 2010-05-26 | 2010-03-19 | 1 | 2010-03-19 | 2010-03-22 | 0 | 0003979804 | 20100519.ifs | 2010-05-19 | 2010-05-20 | |||||||
195415 | 195415 | DIVIDEND | ADD | 009606104 | B | 0 | 1 | 0 | .13486 | 02 | 2010-05-14 | 2010-05-18 | 2010-05-26 | 2010-03-19 | 2 | 2010-03-19 | 2010-05-19 | 0 | 0003979804 | 20100519.ifs | 2010-05-19 | 2010-05-20 | |||||||
137436 | 137436 | DIVIDEND | DELETE | 009606104 | B | 0 | 1 | 5 | .15036 | 39 | ? | 2010-05-18 | 2010-05-26 | 2010-03-19 | 0 | 2010-03-19 | ? | 0 | 0003979804 | 20100322.ifs | 2010-03-22 | 2010-04-07 | |||||||
137437 | 137437 | DIVIDEND | ADD | 009606104 | B | 0 | 1 | 5 | .15036 | 39 | 2010-05-14 | 2010-05-18 | 2010-05-26 | 2010-03-19 | 1 | 2010-03-19 | 2010-03-22 | 0 | 0003979804 | 20100322.ifs | 2010-03-22 | 2010-04-07 | |||||||
136161 | 136161 | DIVIDEND | ADD | 009606104 | B | 0 | 1 | 5 | .15036 | 39 | ? | 2010-05-18 | 2010-05-26 | 2010-03-19 | 0 | 2010-03-19 | ? | 0 | 0003979804 | 20100319.ifs | 2010-03-19 | 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 = 142477
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