INSITITUIONS | Dynamic | newInstitTable | Changed the Cusip/Sector/Shs Out? |
|
||||||||||
Total Insititutions : | 1 | 2 | Update Insititution By Cusips | |||||||||||
% Owned by Insititutions: | 0.22 % | 13.7 % | ||||||||||||
pricingQuarterAdminPageOn:
|
2024-03-31 | New % | ||||||||||||
|
||||||||||||||
the compid is:140132 |
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 | ||
5142589 | 5142589 | EQUITY | CHANGE | G63907102 | ORD | S | 0 | 2003-12-31 | 2022-11-18 | 4 | no | no | no | 2014-04-16 | 2022-11-18 | ? | 20221122.ifs | 2022-11-22 | 2022-11-23 | ||||||||||
5142590 | 5142589 | EQUITY | CHANGE | G63907102 | ORD | 0 | 0 | 2003-12-31 | ? | 4 | no | no | no | 2014-04-16 | 2022-11-22 | ? | 20221122.ifs | 2022-11-22 | 2022-11-23 | ||||||||||
5141118 | 5141118 | EQUITY | CHANGE | G63907102 | ORD | S | 0 | 2003-12-31 | 2022-11-17 | 4 | no | no | no | 2014-04-16 | 2022-11-17 | ? | 20221118.ifs | 2022-11-18 | 2022-11-19 | ||||||||||
5141119 | 5141118 | EQUITY | CHANGE | G63907102 | ORD | S | 0 | 2003-12-31 | 2022-11-18 | 4 | no | no | no | 2014-04-16 | 2022-11-18 | ? | 20221118.ifs | 2022-11-18 | 2022-11-19 | ||||||||||
5141120 | 5141120 | CORPACTION | ADD | G63907102 | 01 | X | 2022-11-18 | G63907102 | 66 | ? | 20221118.ifs | 2022-11-18 | 2022-11-19 | ||||||||||||||||
5141121 | 5141121 | EXCHANGE | ADD | G63907102 | 66 | 2022-11-18 | ? | NTPIF | 0 | 0 | 2022-11-18 | ? | 20221118.ifs | 2022-11-18 | 2022-11-19 | ||||||||||||||
5140504 | 5140504 | CORPACTION | ADD | G63907102 | 01 | S | 2022-11-17 | 2022-11-17 | 20221117.ifs | 2022-11-17 | 2022-11-18 | ||||||||||||||||||
5140505 | 5140505 | EQUITY | CHANGE | G63907102 | ORD | N | 0 | 2003-12-31 | ? | 4 | no | no | no | 2014-04-16 | ? | ? | 20221117.ifs | 2022-11-17 | 2022-11-18 | ||||||||||
5140506 | 5140505 | EQUITY | CHANGE | G63907102 | ORD | S | 0 | 2003-12-31 | 2022-11-17 | 4 | no | no | no | 2014-04-16 | 2022-11-17 | ? | 20221117.ifs | 2022-11-17 | 2022-11-18 | ||||||||||
2837990 | 2837990 | DIVIDEND | ADD | G63907102 | 0 | 0 | 1 | 0 | .07 | 00 | 2018-09-27 | 2018-09-30 | 2018-10-19 | 2017-10-30 | 0 | 2017-12-18 | ? | 3 | 0005562366 | 20171218.ifs | 2017-12-18 | 2017-12-19 | |||||||
2837991 | 2837991 | DIVIDEND | ADD | G63907102 | 0 | 0 | 1 | 0 | .07 | 00 | 2018-06-28 | 2018-06-30 | 2018-07-20 | 2017-10-30 | 0 | 2017-12-18 | ? | 2 | 0005562365 | 20171218.ifs | 2017-12-18 | 2017-12-19 | |||||||
2837992 | 2837992 | DIVIDEND | ADD | G63907102 | 0 | 0 | 1 | 0 | .07 | 00 | 2018-03-28 | 2018-03-31 | 2018-04-20 | 2017-10-30 | 0 | 2017-12-18 | ? | 1 | 0005562362 | 20171218.ifs | 2017-12-18 | 2017-12-19 | |||||||
2837993 | 2837993 | DIVIDEND | ADD | G63907102 | 0 | 0 | 1 | 0 | .07 | 00 | 2017-12-28 | 2017-12-31 | 2018-01-19 | 2017-12-18 | 0 | 2017-12-18 | ? | 0 | 0005561915 | 20171218.ifs | 2017-12-18 | 2017-12-19 | |||||||
2530818 | 2530818 | DIVIDEND | DELETE | G63907102 | 0 | 0 | 1 | 0 | .07 | 00 | 2017-09-27 | 2017-09-30 | 2017-10-20 | 2016-10-31 | 0 | 2016-11-28 | ? | 3 | 0005314346 | 20170403.ifs | 2017-04-03 | 2017-04-04 | |||||||
2530819 | 2530819 | DIVIDEND | ADD | G63907102 | 0 | 0 | 1 | 0 | .07 | 00 | 2017-09-28 | 2017-09-30 | 2017-10-20 | 2016-10-31 | 1 | 2016-11-28 | 2017-04-03 | 3 | 0005314346 | 20170403.ifs | 2017-04-03 | 2017-04-04 | |||||||
2448130 | 2448130 | EQUITY | CHANGE | G63907102 | ORD | N | 0 | 2003-12-31 | ? | 0 | no | no | no | 2014-04-16 | ? | ? | 20170123.ifs | 2017-01-23 | 2017-01-24 | ||||||||||
2448131 | 2448130 | EQUITY | CHANGE | G63907102 | ORD | N | 0 | 2003-12-31 | ? | 4 | no | no | no | 2014-04-16 | ? | ? | 20170123.ifs | 2017-01-23 | 2017-01-24 | ||||||||||
2349292 | 2349292 | DIVIDEND | ADD | G63907102 | 0 | 0 | 1 | 0 | .07 | 00 | 2017-09-27 | 2017-09-30 | 2017-10-20 | 2016-10-31 | 0 | 2016-11-28 | ? | 3 | 0005314346 | 20161128.ifs | 2016-11-28 | 2016-11-29 | |||||||
2349293 | 2349293 | DIVIDEND | ADD | G63907102 | 0 | 0 | 1 | 0 | .07 | 00 | 2017-06-28 | 2017-06-30 | 2017-07-20 | 2016-10-31 | 0 | 2016-11-28 | ? | 2 | 0005314345 | 20161128.ifs | 2016-11-28 | 2016-11-29 | |||||||
2349294 | 2349294 | DIVIDEND | ADD | G63907102 | 0 | 0 | 1 | 0 | .07 | 00 | 2017-03-29 | 2017-03-31 | 2017-04-20 | 2016-10-31 | 0 | 2016-11-28 | ? | 1 | 0005314344 | 20161128.ifs | 2016-11-28 | 2016-11-29 | |||||||
2349295 | 2349295 | DIVIDEND | ADD | G63907102 | 0 | 0 | 1 | 0 | .07 | 00 | 2016-12-28 | 2016-12-31 | 2017-01-20 | 2016-10-31 | 0 | 2016-11-28 | ? | 0 | 0005314343 | 20161128.ifs | 2016-11-28 | 2016-11-29 | |||||||
2323703 | 2323703 | DIVIDEND | DELETE | G63907102 | 0 | 0 | 1 | 0 | .02 | 00 | 2016-09-28 | 2016-09-30 | 2016-10-31 | 2016-04-25 | 1 | 2016-04-25 | 2016-07-22 | 1 | 0005207597 | 20161020.ifs | 2016-10-20 | 2016-10-21 | |||||||
2323704 | 2323704 | DIVIDEND | ADD | G63907102 | 0 | 0 | 1 | 0 | .02 | 00 | 2016-09-28 | 2016-09-30 | 2016-10-20 | 2016-04-25 | 2 | 2016-04-25 | 2016-10-20 | 1 | 0005207597 | 20161020.ifs | 2016-10-20 | 2016-10-21 | |||||||
2255630 | 2255630 | DIVIDEND | CHANGE | G63907102 | 0 | 0 | 1 | 0 | .02 | 00 | 2016-09-28 | 2016-09-30 | 2016-10-31 | 2016-04-25 | 0 | 2016-04-25 | ? | 0 | 0005207597 | 20160722.ifs | 2016-07-22 | 2016-07-23 | |||||||
2255631 | 2255630 | DIVIDEND | CHANGE | G63907102 | 0 | 0 | 1 | 0 | .02 | 00 | 2016-09-28 | 2016-09-30 | 2016-10-31 | 2016-04-25 | 1 | 2016-04-25 | 2016-07-22 | 1 | 0005207597 | 20160722.ifs | 2016-07-22 | 2016-07-23 | |||||||
2254711 | 2254711 | DIVIDEND | DELETE | G63907102 | 0 | 0 | 1 | 0 | .02 | 00 | 2016-06-28 | 2016-06-30 | 2016-07-31 | 2015-11-02 | 1 | 2015-12-10 | 2015-12-23 | 3 | 0005109590 | 20160721.ifs | 2016-07-21 | 2016-07-22 | |||||||
2254712 | 2254712 | DIVIDEND | ADD | G63907102 | 0 | 0 | 1 | 0 | .02 | 00 | 2016-06-28 | 2016-06-30 | 2016-07-20 | 2015-11-02 | 2 | 2015-12-10 | 2016-07-21 | 2 | 0005109590 | 20160721.ifs | 2016-07-21 | 2016-07-22 | |||||||
2182062 | 2182062 | DIVIDEND | DELETE | G63907102 | 0 | 0 | 1 | 0 | .02 | 00 | 2016-03-29 | 2016-03-31 | 2016-04-30 | 2015-11-02 | 1 | 2015-12-10 | 2015-12-23 | 2 | 0005109586 | 20160429.ifs | 2016-04-29 | 2016-04-30 | |||||||
2182063 | 2182063 | DIVIDEND | ADD | G63907102 | 0 | 0 | 1 | 0 | .02 | 00 | 2016-03-29 | 2016-03-31 | 2016-04-15 | 2015-11-02 | 2 | 2015-12-10 | 2016-04-29 | 0 | 0005109586 | 20160429.ifs | 2016-04-29 | 2016-04-30 | |||||||
2172427 | 2172427 | DIVIDEND | ADD | G63907102 | 0 | 0 | 1 | 0 | .02 | 00 | 2016-09-28 | 2016-09-30 | 2016-10-31 | 2016-04-25 | 0 | 2016-04-25 | ? | 0 | 0005207597 | 20160425.ifs | 2016-04-25 | 2016-04-26 | |||||||
2061893 | 2061893 | DIVIDEND | CHANGE | G63907102 | 0 | 0 | 1 | 0 | .02 | 00 | 2016-06-28 | 2016-06-30 | 2016-07-31 | 2015-11-02 | 0 | 2015-12-10 | ? | 2 | 0005109590 | 20151223.ifs | 2015-12-23 | 2015-12-24 | |||||||
2061894 | 2061893 | DIVIDEND | CHANGE | G63907102 | 0 | 0 | 1 | 0 | .02 | 00 | 2016-06-28 | 2016-06-30 | 2016-07-31 | 2015-11-02 | 1 | 2015-12-10 | 2015-12-23 | 3 | 0005109590 | 20151223.ifs | 2015-12-23 | 2015-12-24 | |||||||
2061895 | 2061895 | DIVIDEND | CHANGE | G63907102 | 0 | 0 | 1 | 0 | .02 | 00 | 2016-03-29 | 2016-03-31 | 2016-04-30 | 2015-11-02 | 0 | 2015-12-10 | ? | 1 | 0005109586 | 20151223.ifs | 2015-12-23 | 2015-12-24 | |||||||
2061896 | 2061895 | DIVIDEND | CHANGE | G63907102 | 0 | 0 | 1 | 0 | .02 | 00 | 2016-03-29 | 2016-03-31 | 2016-04-30 | 2015-11-02 | 1 | 2015-12-10 | 2015-12-23 | 2 | 0005109586 | 20151223.ifs | 2015-12-23 | 2015-12-24 | |||||||
2061897 | 2061897 | DIVIDEND | DELETE | G63907102 | 0 | 0 | 1 | 0 | .02 | 00 | 2015-12-29 | 2015-12-31 | 2016-01-31 | 2015-11-02 | 0 | 2015-12-10 | ? | 0 | 0005109406 | 20151223.ifs | 2015-12-23 | 2015-12-24 | |||||||
2061898 | 2061898 | DIVIDEND | ADD | G63907102 | 0 | 0 | 1 | 0 | .02 | 00 | 2015-12-29 | 2015-12-31 | 2016-01-20 | 2015-11-02 | 1 | 2015-12-10 | 2015-12-23 | 0 | 0005109406 | 20151223.ifs | 2015-12-23 | 2015-12-24 | |||||||
2030343 | 2030343 | DIVIDEND | ADD | G63907102 | 0 | 0 | 1 | 0 | .02 | 00 | 2016-06-28 | 2016-06-30 | 2016-07-31 | 2015-11-02 | 0 | 2015-12-10 | ? | 2 | 0005109590 | 20151210.ifs | 2015-12-10 | 2015-12-11 | |||||||
2030344 | 2030344 | DIVIDEND | ADD | G63907102 | 0 | 0 | 1 | 0 | .02 | 00 | 2016-03-29 | 2016-03-31 | 2016-04-30 | 2015-11-02 | 0 | 2015-12-10 | ? | 1 | 0005109586 | 20151210.ifs | 2015-12-10 | 2015-12-11 | |||||||
2030345 | 2030345 | DIVIDEND | ADD | G63907102 | 0 | 0 | 1 | 0 | .02 | 00 | 2015-12-29 | 2015-12-31 | 2016-01-31 | 2015-11-02 | 0 | 2015-12-10 | ? | 0 | 0005109406 | 20151210.ifs | 2015-12-10 | 2015-12-11 | |||||||
1989476 | 1989476 | DIVIDEND | DELETE | G63907102 | 0 | 0 | 1 | 0 | .02 | 00 | 2015-09-28 | 2015-09-30 | 2015-10-30 | 2015-04-27 | 0 | 2015-06-19 | ? | 1 | 0005016401 | 20151012.ifs | 2015-10-12 | 2015-10-13 | |||||||
1989477 | 1989477 | DIVIDEND | ADD | G63907102 | 0 | 0 | 1 | 0 | .02 | 00 | 2015-09-28 | 2015-09-30 | 2015-10-19 | 2015-04-27 | 1 | 2015-06-19 | 2015-10-12 | 1 | 0005016401 | 20151012.ifs | 2015-10-12 | 2015-10-13 | |||||||
1894246 | 1894246 | DIVIDEND | DELETE | G63907102 | 0 | 0 | 1 | 0 | .02 | 00 | 2015-06-26 | 2015-06-30 | 2015-07-31 | 2015-04-27 | 0 | 2015-06-19 | ? | 0 | 0005016400 | 20150624.ifs | 2015-06-24 | 2015-06-25 | |||||||
1894247 | 1894247 | DIVIDEND | ADD | G63907102 | 0 | 0 | 1 | 0 | .02 | 00 | 2015-06-26 | 2015-06-30 | 2015-07-20 | 2015-04-27 | 1 | 2015-06-19 | 2015-06-24 | 0 | 0005016400 | 20150624.ifs | 2015-06-24 | 2015-06-25 | |||||||
1890840 | 1890840 | DIVIDEND | ADD | G63907102 | 0 | 0 | 1 | 0 | .02 | 00 | 2015-09-28 | 2015-09-30 | 2015-10-30 | 2015-04-27 | 0 | 2015-06-19 | ? | 1 | 0005016401 | 20150619.ifs | 2015-06-19 | 2015-06-20 | |||||||
1890841 | 1890841 | DIVIDEND | ADD | G63907102 | 0 | 0 | 1 | 0 | .02 | 00 | 2015-06-26 | 2015-06-30 | 2015-07-31 | 2015-04-27 | 0 | 2015-06-19 | ? | 0 | 0005016400 | 20150619.ifs | 2015-06-19 | 2015-06-20 | |||||||
1814832 | 1814832 | DIVIDEND | ADD | G63907102 | 0 | 0 | 1 | 0 | .02 | 00 | 2015-03-27 | 2015-03-31 | 2015-04-20 | 2015-03-18 | 0 | 2015-03-18 | ? | 0 | 0004969558 | 20150318.ifs | 2015-03-18 | 2015-03-19 | |||||||
1730228 | 1730228 | DIVIDEND | DELETE | G63907102 | 0 | 0 | 1 | 0 | .02 | 00 | 2014-12-29 | 2014-12-31 | 2015-01-30 | 2014-11-03 | 0 | 2014-12-08 | ? | 0 | 0004886990 | 20141219.ifs | 2014-12-19 | 2014-12-20 | |||||||
1730229 | 1730229 | DIVIDEND | ADD | G63907102 | 0 | 0 | 1 | 0 | .02 | 00 | 2014-12-29 | 2014-12-31 | 2015-01-20 | 2014-11-03 | 1 | 2014-12-08 | 2014-12-19 | 0 | 0004886990 | 20141219.ifs | 2014-12-19 | 2014-12-20 | |||||||
1702831 | 1702831 | DIVIDEND | ADD | G63907102 | 0 | 0 | 1 | 0 | .02 | 00 | 2014-12-29 | 2014-12-31 | 2015-01-30 | 2014-11-03 | 0 | 2014-12-08 | ? | 0 | 0004886990 | 20141208.ifs | 2014-12-08 | 2014-12-09 | |||||||
1635213 | 1635213 | DIVIDEND | DELETE | G63907102 | 0 | 0 | 1 | 0 | .02 | 00 | 2014-09-26 | 2014-09-30 | 2014-10-30 | 2014-08-04 | 0 | 2014-08-04 | ? | 0 | 0004826032 | 20140922.ifs | 2014-09-22 | 2014-09-23 | |||||||
1635214 | 1635214 | DIVIDEND | ADD | G63907102 | 0 | 0 | 1 | 0 | .02 | 00 | 2014-09-26 | 2014-09-30 | 2014-10-20 | 2014-08-04 | 1 | 2014-08-04 | 2014-09-22 | 0 | 0004826032 | 20140922.ifs | 2014-09-22 | 2014-09-23 | |||||||
1598479 | 1598479 | DIVIDEND | ADD | G63907102 | 0 | 0 | 1 | 0 | .02 | 00 | 2014-09-26 | 2014-09-30 | 2014-10-30 | 2014-08-04 | 0 | 2014-08-04 | ? | 0 | 0004826032 | 20140804.ifs | 2014-08-04 | 2014-08-05 | |||||||
1550112 | 1550112 | DIVIDEND | ADD | G63907102 | 0 | 0 | 1 | 0 | .02 | 00 | 2014-06-26 | 2014-06-30 | 2014-07-18 | 2014-06-16 | 0 | 2014-06-16 | ? | 0 | 0004796456 | 20140616.ifs | 2014-06-16 | 2014-06-17 | |||||||
1499364 | 1499364 | EXCHANGE | ADD | G63907102 | 01 | 2014-04-22 | 2014-04-22 | NTP | 0 | 0 | 2014-04-22 | ? | 20140422.ifs | 2014-04-22 | 2014-04-23 | ||||||||||||||
1496667 | 1496667 | EQUITY | ADD | G63907102 | ORD | N | 0 | 2003-12-31 | ? | 0 | no | no | no | 2014-04-16 | ? | ? | 20140416.ifs | 2014-04-16 | 2014-04-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 = 140132
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