INSITITUIONS | Dynamic | newInstitTable | Changed the Cusip/Sector/Shs Out? |
|
||||||||||
Total Insititutions : | 125 | 114 | Update Insititution By Cusips | |||||||||||
% Owned by Insititutions: | 8.44 % | 10.42 % | ||||||||||||
pricingQuarterAdminPageOn:
|
2024-03-31 | New % | ||||||||||||
|
||||||||||||||
the compid is:159697 |
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 | ||
5573966 | 5573966 | DIVIDEND | ADD | 464286475 | 0 | 0 | 1 | 0 | .253652 | 00 | 2024-06-11 | 2024-06-11 | 2024-06-17 | 2024-06-10 | 0 | 2024-06-10 | ? | 0 | 0006931098 | 20240610.ifs | 2024-06-10 | 2024-06-11 | |||||||
5450477 | 5450477 | DIVIDEND | ADD | 464286475 | 0 | 0 | 1 | 0 | 1.225183 | 00 | 2023-12-20 | 2023-12-21 | 2023-12-27 | 2023-12-19 | 0 | 2023-12-19 | ? | 0 | 0006840666 | 20231219.ifs | 2023-12-19 | 2023-12-20 | |||||||
5307712 | 5307712 | DIVIDEND | ADD | 464286475 | 0 | 0 | 1 | 0 | .331089 | 00 | 2023-06-07 | 2023-06-08 | 2023-06-13 | 2023-06-06 | 0 | 2023-06-06 | ? | 0 | 0006737065 | 20230606.ifs | 2023-06-06 | 2023-06-07 | |||||||
5162543 | 5162543 | DIVIDEND | ADD | 464286475 | 0 | 0 | 1 | 0 | .397405 | 00 | 2022-12-13 | 2022-12-14 | 2022-12-19 | 2022-12-12 | 0 | 2022-12-12 | ? | 0 | 0006629556 | 20221212.ifs | 2022-12-12 | 2022-12-13 | |||||||
5030262 | 5030262 | DIVIDEND | ADD | 464286475 | 0 | 0 | 1 | 0 | .034148 | 00 | 2022-06-09 | 2022-06-10 | 2022-06-15 | 2022-06-08 | 0 | 2022-06-08 | ? | 0 | 0006536818 | 20220608.ifs | 2022-06-08 | 2022-06-09 | |||||||
4919527 | 4919527 | DIVIDEND | ADD | 464286475 | 0 | 0 | 1 | 0 | .050342 | 00 | 2021-12-30 | 2021-12-31 | 2022-01-05 | 2021-12-29 | 0 | 2021-12-29 | ? | 0 | 0006454880 | 20211229.ifs | 2021-12-29 | 2021-12-30 | |||||||
4877210 | 4877210 | DIVIDEND | ADD | 464286475 | 0 | 0 | 1 | 0 | 1.708788 | 00 | 2021-12-13 | 2021-12-14 | 2021-12-17 | 2021-12-10 | 0 | 2021-12-10 | ? | 0 | 0006417619 | 20211210.ifs | 2021-12-10 | 2021-12-11 | |||||||
4726036 | 4726036 | DIVIDEND | ADD | 464286475 | 0 | 0 | 1 | 0 | .383615 | 00 | 2021-06-10 | 2021-06-11 | 2021-06-16 | 2021-06-09 | 0 | 2021-06-09 | ? | 0 | 0006320347 | 20210609.ifs | 2021-06-09 | 2021-06-10 | |||||||
4580144 | 4580144 | DIVIDEND | ADD | 464286475 | 0 | 0 | 1 | 0 | .046977 | 00 | 2020-12-30 | 2020-12-31 | 2021-01-06 | 2020-12-29 | 0 | 2020-12-29 | ? | 0 | 0006237386 | 20201229.ifs | 2020-12-29 | 2020-12-30 | |||||||
4539260 | 4539260 | DIVIDEND | ADD | 464286475 | 0 | 0 | 1 | 0 | .795754 | 00 | 2020-12-14 | 2020-12-15 | 2020-12-18 | 2020-12-11 | 0 | 2020-12-11 | ? | 0 | 0006209179 | 20201211.ifs | 2020-12-11 | 2020-12-12 | |||||||
4391138 | 4391138 | DIVIDEND | ADD | 464286475 | 0 | 0 | 1 | 0 | .285305 | 00 | 2020-06-15 | 2020-06-16 | 2020-06-19 | 2020-06-12 | 0 | 2020-06-12 | ? | 0 | 0006112151 | 20200612.ifs | 2020-06-12 | 2020-06-13 | |||||||
4068217 | 4068217 | DIVIDEND | ADD | 464286475 | 0 | 0 | 1 | 0 | .851492 | 00 | 2019-12-16 | 2019-12-17 | 2019-12-20 | 2019-12-13 | 0 | 2019-12-13 | ? | 0 | 0005999983 | 20191213.ifs | 2019-12-13 | 2019-12-14 | |||||||
4068293 | 4068293 | DIVIDEND | ADD | 464286475 | 0 | 0 | 1 | 0 | .851492 | 00 | 2019-12-16 | 2019-12-17 | 2019-12-20 | 2019-12-13 | 0 | 2019-12-13 | ? | 0 | 0005999983 | 20191213.ifs | 2019-12-13 | 2019-12-14 | |||||||
3781207 | 3781207 | DIVIDEND | ADD | 464286475 | 0 | 0 | 1 | 0 | .34482 | 00 | 2019-06-17 | 2019-06-18 | 2019-06-21 | 2019-06-14 | 0 | 2019-06-14 | ? | 0 | 0005898659 | 20190614.ifs | 2019-06-14 | 2019-06-15 | |||||||
3781230 | 3781230 | DIVIDEND | ADD | 464286475 | 0 | 0 | 1 | 0 | .34482 | 00 | 2019-06-17 | 2019-06-18 | 2019-06-21 | 2019-06-14 | 0 | 2019-06-14 | ? | 0 | 0005898659 | 20190614.ifs | 2019-06-14 | 2019-06-15 | |||||||
3452526 | 3452526 | DIVIDEND | ADD | 464286475 | 0 | 0 | 1 | 0 | .792218 | 00 | 2018-12-18 | 2018-12-19 | 2018-12-24 | 2018-12-17 | 0 | 2018-12-17 | ? | 0 | 0005785577 | 20181217.ifs | 2018-12-17 | 2018-12-18 | |||||||
3452688 | 3452688 | DIVIDEND | ADD | 464286475 | 0 | 0 | 1 | 0 | .792218 | 00 | 2018-12-18 | 2018-12-19 | 2018-12-24 | 2018-12-17 | 0 | 2018-12-17 | ? | 0 | 0005785577 | 20181217.ifs | 2018-12-17 | 2018-12-18 | |||||||
3144172 | 3144172 | DIVIDEND | ADD | 464286475 | 0 | 0 | 1 | 0 | .489022 | 00 | 2018-06-19 | 2018-06-20 | 2018-06-25 | 2018-06-18 | 0 | 2018-06-18 | ? | 0 | 0005676469 | 20180618.ifs | 2018-06-18 | 2018-06-19 | |||||||
3144173 | 3144173 | DIVIDEND | ADD | 464286475 | 0 | 0 | 1 | 0 | .489022 | 00 | 2018-06-19 | 2018-06-20 | 2018-06-25 | 2018-06-18 | 0 | 2018-06-18 | ? | 0 | 0005676469 | 20180618.ifs | 2018-06-18 | 2018-06-19 | |||||||
2839649 | 2839649 | DIVIDEND | ADD | 464286475 | 0 | 0 | 1 | 0 | .983475 | 00 | 2017-12-19 | 2017-12-20 | 2017-12-26 | 2017-12-18 | 0 | 2017-12-18 | ? | 0 | 0005564296 | 20171218.ifs | 2017-12-18 | 2017-12-19 | |||||||
2595110 | 2595110 | DIVIDEND | ADD | 464286475 | 0 | 0 | 1 | 0 | .3308 | 00 | 2017-06-20 | 2017-06-22 | 2017-06-26 | 2017-06-19 | 0 | 2017-06-19 | ? | 0 | 0005451206 | 20170619.ifs | 2017-06-19 | 2017-06-20 | |||||||
2451168 | 2451168 | EQUITY | CHANGE | 464286475 | MSCI EMERGING MKTS SMALL CAP ETF | 0 | A | 2011-08-18 | ? | 0 | no | no | no | 2011-08-18 | 2013-07-01 | ? | 20170124.ifs | 2017-01-24 | 2017-01-25 | ||||||||||
2451169 | 2451168 | EQUITY | CHANGE | 464286475 | MSCI EMERGING MKTS SMALL CAP ETF | 0 | A | 2011-08-18 | ? | 2 | no | no | no | 2011-08-18 | 2013-07-01 | ? | 20170124.ifs | 2017-01-24 | 2017-01-25 | ||||||||||
2388282 | 2388282 | DIVIDEND | ADD | 464286475 | 0 | 0 | 1 | 0 | .554248 | 00 | 2016-12-21 | 2016-12-23 | 2016-12-28 | 2016-12-20 | 0 | 2016-12-20 | ? | 0 | 0005346321 | 20161220.ifs | 2016-12-20 | 2016-12-21 | |||||||
2226689 | 2226689 | DIVIDEND | ADD | 464286475 | 0 | 0 | 1 | 0 | .461937 | 00 | 2016-06-22 | 2016-06-24 | 2016-06-28 | 2016-06-21 | 0 | 2016-06-21 | ? | 0 | 0005236501 | 20160621.ifs | 2016-06-21 | 2016-06-22 | |||||||
2053027 | 2053027 | DIVIDEND | ADD | 464286475 | 0 | 0 | 1 | 0 | .584261 | 00 | 2015-12-21 | 2015-12-23 | 2015-12-28 | 2015-12-18 | 0 | 2015-12-18 | ? | 0 | 0005130263 | 20151218.ifs | 2015-12-18 | 2015-12-19 | |||||||
1719604 | 1719604 | DIVIDEND | ADD | 464286475 | 0 | 0 | 1 | 0 | .925273 | 00 | 2014-12-17 | 2014-12-19 | 2014-12-24 | 2014-12-16 | 0 | 2014-12-16 | ? | 0 | 0004901999 | 20141216.ifs | 2014-12-16 | 2014-12-17 | |||||||
1559006 | 1559006 | DIVIDEND | ADD | 464286475 | 0 | 0 | 1 | 0 | .275627 | 00 | 2014-06-25 | 2014-06-27 | 2014-07-02 | 2014-06-24 | 0 | 2014-06-24 | ? | 0 | 0004801501 | 20140624.ifs | 2014-06-24 | 2014-06-25 | |||||||
1376968 | 1376968 | DIVIDEND | ADD | 464286475 | 0 | 0 | 1 | 0 | .736964 | 00 | 2013-12-18 | 2013-12-20 | 2013-12-30 | 2013-12-17 | 0 | 2013-12-17 | ? | 0 | 0004688622 | 20131217.ifs | 2013-12-17 | 2013-12-18 | |||||||
1227410 | 1227410 | CORPACTION | ADD | 464286475 | 04 | # | 2013-07-01 | 464286475 | 04 | ? | 20130701.ifs | 2013-07-01 | 2013-07-02 | ||||||||||||||||
1227411 | 1227411 | CORPACTIONAUX | ADD | 464286475 | 04 | 2013-07-01 | EEMS | ISHARES INC | ISHARES TRUST - | EEMS | ISHARES INC | MSCI EMERGING M | 2013-07-01 | ? | 20130701.ifs | 2013-07-01 | 2013-07-02 | ||||||||||||
1227412 | 1227412 | EQUITY | CHANGE | 464286475 | MSCI EMERGING MARKETS SMALL CAP INDEX FD | 0 | A | 2011-08-18 | ? | 0 | no | no | no | 2011-08-18 | 2011-08-18 | ? | 20130701.ifs | 2013-07-01 | 2013-07-02 | ||||||||||
1227413 | 1227412 | EQUITY | CHANGE | 464286475 | MSCI EMERGING MKTS SMALL CAP ETF | 0 | A | 2011-08-18 | ? | 0 | no | no | no | 2011-08-18 | 2013-07-01 | ? | 20130701.ifs | 2013-07-01 | 2013-07-02 | ||||||||||
1219056 | 1219056 | DIVIDEND | ADD | 464286475 | 0 | 0 | 1 | 0 | .286788 | 00 | 2013-06-27 | 2013-07-01 | 2013-07-05 | 2013-06-26 | 0 | 2013-06-26 | ? | 0 | 0004589997 | 20130626.ifs | 2013-06-26 | 2013-06-27 | |||||||
1044777 | 1044777 | DIVIDEND | ADD | 464286475 | 0 | 0 | 1 | 0 | 1.569045 | 00 | 2012-12-18 | 2012-12-20 | 2012-12-27 | 2012-12-17 | 0 | 2012-12-17 | ? | 0 | 0004483123 | 20121217.ifs | 2012-12-17 | 2012-12-18 | |||||||
895621 | 895621 | DIVIDEND | CHANGE | 464286475 | 0 | 0 | 1 | 0 | .6895 | 00 | 2012-06-21 | 2012-06-25 | 2012-06-28 | 2012-06-20 | 0 | 2012-06-20 | ? | 0 | 0004389173 | 20120627.ifs | 2012-06-27 | 2012-06-28 | |||||||
895622 | 895621 | DIVIDEND | CHANGE | 464286475 | 0 | 0 | 1 | 0 | .689519 | 00 | 2012-06-21 | 2012-06-25 | 2012-06-28 | 2012-06-20 | 1 | 2012-06-20 | 2012-06-27 | 0 | 0004389173 | 20120627.ifs | 2012-06-27 | 2012-06-28 | |||||||
889643 | 889643 | DIVIDEND | ADD | 464286475 | 0 | 0 | 1 | 0 | .6895 | 00 | 2012-06-21 | 2012-06-25 | 2012-06-28 | 2012-06-20 | 0 | 2012-06-20 | ? | 0 | 0004389173 | 20120620.ifs | 2012-06-20 | 2012-06-21 | |||||||
730926 | 730926 | DIVIDEND | ADD | 464286475 | 0 | 0 | 1 | 4 | .45275 | 00 | 2011-12-20 | 2011-12-22 | 2011-12-29 | 2011-12-19 | 0 | 2011-12-19 | ? | 0 | 0004295290 | 20111219.ifs | 2011-12-19 | 2011-12-20 | |||||||
621550 | 621550 | EQUITY | ADD | 464286475 | MSCI EMERGING MARKETS SMALL CAP INDEX FD | N | 7 | 2011-08-18 | ? | 0 | no | no | no | 2011-08-18 | ? | ? | 20110818.ifs | 2011-08-18 | 2011-08-19 | ||||||||||
621551 | 621551 | EXCHANGE | ADD | 464286475 | 04 | 2011-08-18 | 2011-08-18 | EEMS | 0 | A | 2011-08-18 | ? | 20110818.ifs | 2011-08-18 | 2011-08-19 | ||||||||||||||
621578 | 621578 | EQUITY | CHANGE | 464286475 | MSCI EMERGING MARKETS SMALL CAP INDEX FD | N | 7 | 2011-08-18 | ? | 0 | no | no | no | 2011-08-18 | ? | ? | 20110818.ifs | 2011-08-18 | 2011-08-19 | ||||||||||
621579 | 621578 | EQUITY | CHANGE | 464286475 | MSCI EMERGING MARKETS SMALL CAP INDEX FD | N | A | 2011-08-18 | ? | 0 | no | no | no | 2011-08-18 | 2011-08-18 | ? | 20110818.ifs | 2011-08-18 | 2011-08-19 | ||||||||||
622076 | 622076 | EQUITY | CHANGE | 464286475 | MSCI EMERGING MARKETS SMALL CAP INDEX FD | N | A | 2011-08-18 | ? | 0 | no | no | no | 2011-08-18 | 2011-08-18 | ? | 20110818.ifs | 2011-08-18 | 2011-08-19 | ||||||||||
622077 | 622076 | EQUITY | CHANGE | 464286475 | MSCI EMERGING MARKETS SMALL CAP INDEX FD | 0 | A | 2011-08-18 | ? | 0 | no | no | no | 2011-08-18 | 2011-08-18 | ? | 20110818.ifs | 2011-08-18 | 2011-08-19 |
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 = 159697
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