INSITITUIONS | Dynamic | newInstitTable | Changed the Cusip/Sector/Shs Out? |
|
|||||||
Total Insititutions : | N/A | 1 | Update Insititution By Cusips | ||||||||
% Owned by Insititutions: | N/A % | 0 % | |||||||||
pricingQuarterAdminPageOn:
|
2024-03-31 | New % | |||||||||
|
|||||||||||
the compid is:130710 |
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 | ||
1499102 | 1499102 | EXCHANGE | CHANGE | 48020T101 | 01 | 2010-10-18 | 2014-04-17 | JNY | 0 | 0 | 2010-10-18 | ? | 20140422.ifs | 2014-04-22 | 2014-04-23 | ||||||||||||||
1499103 | 1499102 | EXCHANGE | CHANGE | 48020T101 | 01 | 2010-10-18 | 2014-04-08 | JNY | 0 | 0 | 2010-10-18 | 2014-04-22 | 20140422.ifs | 2014-04-22 | 2014-04-23 | ||||||||||||||
1499104 | 1499104 | CORPACTION | ADD | 48020T101 | 01 | A | 2014-04-09 | 2014-04-22 | 20140422.ifs | 2014-04-22 | 2014-04-23 | ||||||||||||||||||
1499105 | 1499105 | EQUITY | CHANGE | 48020T101 | COM | 0 | 0 | 2010-07-29 | ? | 0 | no | no | no | 2010-10-14 | 2014-04-08 | ? | 20140422.ifs | 2014-04-22 | 2014-04-23 | ||||||||||
1499106 | 1499105 | EQUITY | CHANGE | 48020T101 | COM | A | 0 | 2010-07-29 | 2014-04-09 | 0 | no | no | no | 2010-10-14 | 2014-04-22 | ? | 20140422.ifs | 2014-04-22 | 2014-04-23 | ||||||||||
1492942 | 1492942 | CORPACTION | ADD | 48020T101 | 01 | A | 2014-04-08 | ? | 20140408.ifs | 2014-04-08 | 2014-04-09 | ||||||||||||||||||
1492943 | 1492943 | EQUITY | CHANGE | 48020T101 | COM | 0 | 0 | 2010-07-29 | ? | 0 | no | no | no | 2010-10-14 | ? | ? | 20140408.ifs | 2014-04-08 | 2014-04-09 | ||||||||||
1492944 | 1492943 | EQUITY | CHANGE | 48020T101 | COM | A | 0 | 2010-07-29 | 2014-04-08 | 0 | no | no | no | 2010-10-14 | 2014-04-08 | ? | 20140408.ifs | 2014-04-08 | 2014-04-09 | ||||||||||
1493031 | 1493031 | CORPACTION | DELETE | 48020T101 | 01 | A | 2014-04-08 | ? | 20140408.ifs | 2014-04-08 | 2014-04-09 | ||||||||||||||||||
1493032 | 1493032 | EQUITY | CHANGE | 48020T101 | COM | A | 0 | 2010-07-29 | 2014-04-08 | 0 | no | no | no | 2010-10-14 | 2014-04-08 | ? | 20140408.ifs | 2014-04-08 | 2014-04-09 | ||||||||||
1493033 | 1493032 | EQUITY | CHANGE | 48020T101 | COM | 0 | 0 | 2010-07-29 | ? | 0 | no | no | no | 2010-10-14 | 2014-04-08 | ? | 20140408.ifs | 2014-04-08 | 2014-04-09 | ||||||||||
1493326 | 1493326 | DIVIDEND | CHANGE | 48020T101 | 0 | 0 | 1 | 0 | .05 | 00 | 2013-11-13 | 2013-11-15 | 2013-11-29 | 2013-10-30 | 2 | 2013-10-30 | 2014-03-20 | 0 | 0004648639 | 20140408.ifs | 2014-04-08 | 2014-04-09 | |||||||
1493327 | 1493326 | DIVIDEND | CHANGE | 48020T101 | 0 | 0 | 1 | 0 | .05 | 00 | 2013-11-13 | 2013-11-15 | 2013-11-29 | 2013-10-30 | 3 | 2013-10-30 | 2014-04-08 | 0 | 0004648639 | 20140408.ifs | 2014-04-08 | 2014-04-09 | |||||||
1472112 | 1472112 | DIVIDEND | CHANGE | 48020T101 | 0 | 0 | 1 | 0 | .05 | 00 | 2013-11-13 | 2013-11-15 | 2013-11-29 | 2013-10-30 | 1 | 2013-10-30 | 2013-12-23 | 0 | 0004648639 | 20140320.ifs | 2014-03-20 | 2014-03-21 | |||||||
1472113 | 1472112 | DIVIDEND | CHANGE | 48020T101 | 0 | 0 | 1 | 0 | .05 | 00 | 2013-11-13 | 2013-11-15 | 2013-11-29 | 2013-10-30 | 2 | 2013-10-30 | 2014-03-20 | 0 | 0004648639 | 20140320.ifs | 2014-03-20 | 2014-03-21 | |||||||
1393219 | 1393219 | DIVIDEND | CHANGE | 48020T101 | 0 | 0 | 1 | 0 | .05 | 00 | 2013-11-13 | 2013-11-15 | 2013-11-29 | 2013-10-30 | 0 | 2013-10-30 | ? | 0 | 0004648639 | 20131223.ifs | 2013-12-23 | 2013-12-24 | |||||||
1393220 | 1393219 | DIVIDEND | CHANGE | 48020T101 | 0 | 0 | 1 | 0 | .05 | 00 | 2013-11-13 | 2013-11-15 | 2013-11-29 | 2013-10-30 | 1 | 2013-10-30 | 2013-12-23 | 0 | 0004648639 | 20131223.ifs | 2013-12-23 | 2013-12-24 | |||||||
1325790 | 1325790 | DIVIDEND | ADD | 48020T101 | 0 | 0 | 1 | 0 | .05 | 00 | 2013-11-13 | 2013-11-15 | 2013-11-29 | 2013-10-30 | 0 | 2013-10-30 | ? | 0 | 0004648639 | 20131030.ifs | 2013-10-30 | 2013-10-31 | |||||||
1251878 | 1251878 | DIVIDEND | ADD | 48020T101 | 0 | 0 | 1 | 0 | .05 | 00 | 2013-08-14 | 2013-08-16 | 2013-08-30 | 2013-07-31 | 0 | 2013-07-31 | ? | 0 | 0004605871 | 20130731.ifs | 2013-07-31 | 2013-08-01 | |||||||
1176325 | 1176325 | DIVIDEND | ADD | 48020T101 | 0 | 0 | 1 | 0 | .05 | 00 | 2013-05-15 | 2013-05-17 | 2013-05-31 | 2013-05-01 | 0 | 2013-05-01 | ? | 0 | 0004565223 | 20130501.ifs | 2013-05-01 | 2013-05-02 | |||||||
1111941 | 1111941 | DIVIDEND | ADD | 48020T101 | 0 | 0 | 1 | 0 | .05 | 00 | 2013-02-27 | 2013-03-01 | 2013-03-15 | 2013-02-13 | 0 | 2013-02-13 | ? | 0 | 0004527820 | 20130213.ifs | 2013-02-13 | 2013-02-14 | |||||||
991906 | 991906 | DIVIDEND | ADD | 48020T101 | 0 | 0 | 1 | 0 | .05 | 00 | 2012-11-07 | 2012-11-09 | 2012-11-23 | 2012-10-24 | 0 | 2012-10-24 | ? | 0 | 0004447770 | 20121024.ifs | 2012-10-24 | 2012-10-25 | |||||||
921243 | 921243 | DIVIDEND | ADD | 48020T101 | 0 | 0 | 1 | 0 | .05 | 00 | 2012-08-08 | 2012-08-10 | 2012-08-24 | 2012-07-25 | 0 | 2012-07-25 | ? | 0 | 0004405025 | 20120725.ifs | 2012-07-25 | 2012-07-26 | |||||||
842702 | 842702 | DIVIDEND | ADD | 48020T101 | 0 | 0 | 1 | 0 | .05 | 00 | 2012-05-09 | 2012-05-11 | 2012-05-25 | 2012-04-25 | 0 | 2012-04-25 | ? | 0 | 0004363932 | 20120425.ifs | 2012-04-25 | 2012-04-26 | |||||||
776393 | 776393 | DIVIDEND | ADD | 48020T101 | 0 | 0 | 1 | 0 | .05 | 00 | 2012-02-22 | 2012-02-24 | 2012-03-09 | 2012-02-08 | 0 | 2012-02-08 | ? | 0 | 0004331591 | 20120208.ifs | 2012-02-08 | 2012-02-09 | |||||||
594129 | 594129 | DIVIDEND | ADD | 48020T101 | 0 | 0 | 1 | 0 | .05 | 00 | 2011-08-10 | 2011-08-12 | 2011-08-26 | 2011-07-27 | 0 | 2011-07-27 | ? | 0 | 0004219704 | 20110727.ifs | 2011-07-27 | 2011-07-28 | |||||||
509834 | 509834 | DIVIDEND | ADD | 48020T101 | 0 | 0 | 1 | 0 | .05 | 00 | 2011-05-11 | 2011-05-13 | 2011-05-27 | 2011-04-27 | 0 | 2011-04-27 | ? | 0 | 0004178119 | 20110427.ifs | 2011-04-27 | 2011-04-28 | |||||||
440164 | 440164 | DIVIDEND | ADD | 48020T101 | 0 | 0 | 1 | 0 | .05 | 00 | 2011-02-23 | 2011-02-25 | 2011-03-11 | 2011-02-09 | 0 | 2011-02-09 | ? | 0 | 0004145755 | 20110209.ifs | 2011-02-09 | 2011-02-10 | |||||||
342855 | 342855 | DIVIDEND | ADD | 48020T101 | 0 | 0 | 1 | 0 | .05 | 00 | 2010-11-09 | 2010-11-12 | 2010-11-26 | 2010-10-27 | 0 | 2010-10-27 | ? | 0 | 0004077502 | 20101027.ifs | 2010-10-27 | 2010-10-28 | |||||||
336347 | 336347 | EXCHANGE | ADD | 48020T101 | 01 | 2010-10-18 | 2010-10-18 | JNY | 0 | 0 | 2010-10-18 | ? | 20101018.ifs | 2010-10-18 | 2010-10-19 | ||||||||||||||
336985 | 336985 | EQUITY | CHANGE | 48020T101 | COM | N | 0 | 2010-07-29 | ? | 0 | no | no | no | 2010-10-14 | ? | ? | 20101018.ifs | 2010-10-18 | 2010-10-19 | ||||||||||
336986 | 336985 | EQUITY | CHANGE | 48020T101 | COM | 0 | 0 | 2010-07-29 | ? | 0 | no | no | no | 2010-10-14 | ? | ? | 20101018.ifs | 2010-10-18 | 2010-10-19 | ||||||||||
334904 | 334904 | EQUITY | ADD | 48020T101 | COM | N | 0 | 2010-07-29 | ? | 0 | no | no | no | 2010-10-14 | ? | ? | 20101014.ifs | 2010-10-14 | 2010-10-15 |
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 = 130710
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