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:159628 |
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 | ||
1480344 | 1480344 | EQUITY | CHANGE | 464289164 | MSCI ACWI EX US FINLS ETF | L | A | 2010-01-22 | 2014-03-26 | 0 | no | no | yes | 2010-01-22 | 2014-03-26 | ? | 20140331.ifs | 2014-03-31 | 2014-04-01 | ||||||||||
1480345 | 1480344 | EQUITY | CHANGE | 464289164 | MSCI ACWI EX US FINLS ETF | L | A | 2010-01-22 | 2014-03-26 | 0 | no | no | yes | 2010-01-22 | 2014-03-31 | ? | 20140331.ifs | 2014-03-31 | 2014-04-01 | ||||||||||
1476488 | 1476488 | CORPACTION | ADD | 464289164 | 60 | L | 2014-03-26 | ? | 20140326.ifs | 2014-03-26 | 2014-03-27 | ||||||||||||||||||
1476489 | 1476489 | EQUITY | CHANGE | 464289164 | MSCI ACWI EX US FINLS ETF | 0 | A | 2010-01-22 | ? | 0 | no | no | yes | 2010-01-22 | 2013-07-01 | ? | 20140326.ifs | 2014-03-26 | 2014-03-27 | ||||||||||
1476490 | 1476489 | EQUITY | CHANGE | 464289164 | MSCI ACWI EX US FINLS ETF | L | A | 2010-01-22 | 2014-03-26 | 0 | no | no | yes | 2010-01-22 | 2014-03-26 | ? | 20140326.ifs | 2014-03-26 | 2014-03-27 | ||||||||||
1476000 | 1476000 | DIVIDEND | DELETE | 464289164 | 0 | 0 | 1 | 6 | 0 | 08 | 2014-12-29 | 2014-12-31 | 2015-01-05 | 2014-01-02 | 0 | 2014-01-02 | ? | 2 | 0004718148 | 20140325.ifs | 2014-03-25 | 2014-03-26 | |||||||
1476001 | 1476001 | DIVIDEND | DELETE | 464289164 | 0 | 0 | 1 | 6 | 0 | 08 | 2014-12-17 | 2014-12-19 | 2014-12-24 | 2014-01-02 | 0 | 2014-01-02 | ? | 1 | 0004718146 | 20140325.ifs | 2014-03-25 | 2014-03-26 | |||||||
1476002 | 1476002 | DIVIDEND | DELETE | 464289164 | 0 | 0 | 1 | 6 | 0 | 08 | 2014-06-25 | 2014-06-27 | 2014-07-02 | 2014-01-02 | 0 | 2014-01-02 | ? | 0 | 0004718144 | 20140325.ifs | 2014-03-25 | 2014-03-26 | |||||||
1413967 | 1413967 | DIVIDEND | ADD | 464289164 | 0 | 0 | 1 | 6 | 0 | 08 | 2014-12-29 | 2014-12-31 | 2015-01-05 | 2014-01-02 | 0 | 2014-01-02 | ? | 2 | 0004718148 | 20140102.ifs | 2014-01-02 | 2014-01-03 | |||||||
1413968 | 1413968 | DIVIDEND | ADD | 464289164 | 0 | 0 | 1 | 6 | 0 | 08 | 2014-12-17 | 2014-12-19 | 2014-12-24 | 2014-01-02 | 0 | 2014-01-02 | ? | 1 | 0004718146 | 20140102.ifs | 2014-01-02 | 2014-01-03 | |||||||
1413969 | 1413969 | DIVIDEND | ADD | 464289164 | 0 | 0 | 1 | 6 | 0 | 08 | 2014-06-25 | 2014-06-27 | 2014-07-02 | 2014-01-02 | 0 | 2014-01-02 | ? | 0 | 0004718144 | 20140102.ifs | 2014-01-02 | 2014-01-03 | |||||||
1396975 | 1396975 | DIVIDEND | DELETE | 464289164 | 0 | 0 | 1 | 6 | 0 | 08 | 2013-12-27 | 2013-12-31 | 2014-01-03 | 2013-01-09 | 1 | 2013-01-09 | 2013-12-17 | 1 | 0004513441 | 20131226.ifs | 2013-12-26 | 2013-12-27 | |||||||
1376916 | 1376916 | DIVIDEND | CHANGE | 464289164 | 0 | 0 | 1 | 6 | 0 | 08 | 2013-12-27 | 2013-12-31 | 2014-01-03 | 2013-01-09 | 0 | 2013-01-09 | ? | 2 | 0004513441 | 20131217.ifs | 2013-12-17 | 2013-12-18 | |||||||
1376917 | 1376916 | DIVIDEND | CHANGE | 464289164 | 0 | 0 | 1 | 6 | 0 | 08 | 2013-12-27 | 2013-12-31 | 2014-01-03 | 2013-01-09 | 1 | 2013-01-09 | 2013-12-17 | 1 | 0004513441 | 20131217.ifs | 2013-12-17 | 2013-12-18 | |||||||
1376918 | 1376918 | DIVIDEND | DELETE | 464289164 | 0 | 0 | 1 | 6 | 0 | 08 | 2013-12-18 | 2013-12-20 | 2013-12-30 | 2013-01-09 | 0 | 2013-01-09 | ? | 1 | 0004513440 | 20131217.ifs | 2013-12-17 | 2013-12-18 | |||||||
1376919 | 1376919 | DIVIDEND | ADD | 464289164 | 0 | 0 | 1 | 0 | .251945 | 00 | 2013-12-18 | 2013-12-20 | 2013-12-30 | 2013-12-17 | 1 | 2013-01-09 | 2013-12-17 | 0 | 0004513440 | 20131217.ifs | 2013-12-17 | 2013-12-18 | |||||||
1227591 | 1227591 | CORPACTION | ADD | 464289164 | 60 | # | 2013-07-01 | 464289164 | 60 | ? | 20130701.ifs | 2013-07-01 | 2013-07-02 | ||||||||||||||||
1227592 | 1227592 | CORPACTIONAUX | ADD | 464289164 | 60 | 2013-07-01 | AXFN | ISHARES TR | ISHARES MSCI AC | AXFN | ISHARES TR | ISHARES MSCI AC | 2013-07-01 | ? | 20130701.ifs | 2013-07-01 | 2013-07-02 | ||||||||||||
1227593 | 1227593 | EQUITY | CHANGE | 464289164 | MSCI ACWI EX US FINLS INDEX FD | 0 | A | 2010-01-22 | ? | 0 | no | no | yes | 2010-01-22 | 2010-01-22 | ? | 20130701.ifs | 2013-07-01 | 2013-07-02 | ||||||||||
1227594 | 1227593 | EQUITY | CHANGE | 464289164 | ISHARES MSCI ACWI EX US FINANCIALS ETF | 0 | A | 2010-01-22 | ? | 0 | no | no | yes | 2010-01-22 | 2013-07-01 | ? | 20130701.ifs | 2013-07-01 | 2013-07-02 | ||||||||||
1227975 | 1227975 | EQUITY | CHANGE | 464289164 | ISHARES MSCI ACWI EX US FINANCIALS ETF | 0 | A | 2010-01-22 | ? | 0 | no | no | yes | 2010-01-22 | 2013-07-01 | ? | 20130701.ifs | 2013-07-01 | 2013-07-02 | ||||||||||
1227976 | 1227975 | EQUITY | CHANGE | 464289164 | MSCI ACWI EX US FINLS ETF | 0 | A | 2010-01-22 | ? | 0 | no | no | yes | 2010-01-22 | 2013-07-01 | ? | 20130701.ifs | 2013-07-01 | 2013-07-02 | ||||||||||
1227978 | 1227977 | EQUITY | CHANGE | 464289164 | 60 | # | 2013-07-01 | 464289164 | 60 | ? | 20130701.ifs | 2013-07-01 | 2013-07-02 | ||||||||||||||||
1227979 | 1227978 | EQUITY | CHANGE | 464289164 | 60 | # | 2013-07-01 | 464289164 | 60 | 2013-07-01 | 20130701.ifs | 2013-07-01 | 2013-07-02 | ||||||||||||||||
1227981 | 1227980 | EQUITY | CHANGE | 464289164 | 60 | 2013-07-01 | AXFN | ISHARES TR | ISHARES MSCI AC | AXFN | ISHARES TR | ISHARES MSCI AC | 2013-07-01 | ? | 20130701.ifs | 2013-07-01 | 2013-07-02 | ||||||||||||
1227982 | 1227981 | EQUITY | CHANGE | 464289164 | 60 | 2013-07-01 | AXFN | ISHARES TR | ISHARES MSCI AC | AXFN | ISHARES TR | MSCI ACWI EX US | 2013-07-01 | 2013-07-01 | 20130701.ifs | 2013-07-01 | 2013-07-02 | ||||||||||||
1219006 | 1219006 | DIVIDEND | DELETE | 464289164 | 0 | 0 | 1 | 6 | 0 | 08 | 2013-06-27 | 2013-07-01 | 2013-07-05 | 2013-01-09 | 0 | 2013-01-09 | ? | 0 | 0004513438 | 20130626.ifs | 2013-06-26 | 2013-06-27 | |||||||
1219007 | 1219007 | DIVIDEND | ADD | 464289164 | 0 | 0 | 1 | 0 | .432473 | 00 | 2013-06-27 | 2013-07-01 | 2013-07-05 | 2013-06-26 | 1 | 2013-01-09 | 2013-06-26 | 0 | 0004513438 | 20130626.ifs | 2013-06-26 | 2013-06-27 | |||||||
1086986 | 1086986 | DIVIDEND | ADD | 464289164 | 0 | 0 | 1 | 6 | 0 | 08 | 2013-12-27 | 2013-12-31 | 2014-01-03 | 2013-01-09 | 0 | 2013-01-09 | ? | 2 | 0004513441 | 20130109.ifs | 2013-01-09 | 2013-01-10 | |||||||
1086987 | 1086987 | DIVIDEND | ADD | 464289164 | 0 | 0 | 1 | 6 | 0 | 08 | 2013-12-18 | 2013-12-20 | 2013-12-30 | 2013-01-09 | 0 | 2013-01-09 | ? | 1 | 0004513440 | 20130109.ifs | 2013-01-09 | 2013-01-10 | |||||||
1086988 | 1086988 | DIVIDEND | ADD | 464289164 | 0 | 0 | 1 | 6 | 0 | 08 | 2013-06-27 | 2013-07-01 | 2013-07-05 | 2013-01-09 | 0 | 2013-01-09 | ? | 0 | 0004513438 | 20130109.ifs | 2013-01-09 | 2013-01-10 | |||||||
1064364 | 1064364 | DIVIDEND | DELETE | 464289164 | 0 | 0 | 1 | 0 | .5568 | 00 | 2012-12-18 | 2012-12-20 | 2012-12-28 | 2012-12-17 | 1 | 2012-01-12 | 2012-12-17 | 1 | 0004320347 | 20121227.ifs | 2012-12-27 | 2012-12-28 | |||||||
1064365 | 1064365 | DIVIDEND | ADD | 464289164 | 0 | 0 | 1 | 0 | .5568 | 00 | 2012-12-18 | 2012-12-20 | 2012-12-27 | 2012-12-17 | 2 | 2012-01-12 | 2012-12-27 | 1 | 0004320347 | 20121227.ifs | 2012-12-27 | 2012-12-28 | |||||||
1060964 | 1060964 | DIVIDEND | DELETE | 464289164 | 0 | 0 | 1 | 6 | 0 | 08 | 2012-12-27 | 2012-12-31 | 2013-01-03 | 2012-01-12 | 0 | 2012-01-12 | ? | 2 | 0004320348 | 20121226.ifs | 2012-12-26 | 2012-12-27 | |||||||
1044733 | 1044733 | DIVIDEND | DELETE | 464289164 | 0 | 0 | 1 | 6 | 0 | 08 | 2012-12-18 | 2012-12-20 | 2012-12-28 | 2012-01-12 | 0 | 2012-01-12 | ? | 1 | 0004320347 | 20121217.ifs | 2012-12-17 | 2012-12-18 | |||||||
1044734 | 1044734 | DIVIDEND | ADD | 464289164 | 0 | 0 | 1 | 0 | .5568 | 00 | 2012-12-18 | 2012-12-20 | 2012-12-28 | 2012-12-17 | 1 | 2012-01-12 | 2012-12-17 | 1 | 0004320347 | 20121217.ifs | 2012-12-17 | 2012-12-18 | |||||||
889599 | 889599 | DIVIDEND | DELETE | 464289164 | 0 | 0 | 1 | 6 | 0 | 08 | 2012-06-21 | 2012-06-25 | 2012-06-28 | 2012-01-12 | 0 | 2012-01-12 | ? | 0 | 0004320346 | 20120620.ifs | 2012-06-20 | 2012-06-21 | |||||||
889600 | 889600 | DIVIDEND | ADD | 464289164 | 0 | 0 | 1 | 0 | .486021 | 00 | 2012-06-21 | 2012-06-25 | 2012-06-28 | 2012-06-20 | 1 | 2012-01-12 | 2012-06-20 | 0 | 0004320346 | 20120620.ifs | 2012-06-20 | 2012-06-21 | |||||||
755764 | 755764 | DIVIDEND | ADD | 464289164 | 0 | 0 | 1 | 6 | 0 | 08 | 2012-12-27 | 2012-12-31 | 2013-01-03 | 2012-01-12 | 0 | 2012-01-12 | ? | 2 | 0004320348 | 20120112.ifs | 2012-01-12 | 2012-01-13 | |||||||
755765 | 755765 | DIVIDEND | ADD | 464289164 | 0 | 0 | 1 | 6 | 0 | 08 | 2012-12-18 | 2012-12-20 | 2012-12-28 | 2012-01-12 | 0 | 2012-01-12 | ? | 1 | 0004320347 | 20120112.ifs | 2012-01-12 | 2012-01-13 | |||||||
755766 | 755766 | DIVIDEND | ADD | 464289164 | 0 | 0 | 1 | 6 | 0 | 08 | 2012-06-21 | 2012-06-25 | 2012-06-28 | 2012-01-12 | 0 | 2012-01-12 | ? | 0 | 0004320346 | 20120112.ifs | 2012-01-12 | 2012-01-13 | |||||||
739334 | 739334 | DIVIDEND | DELETE | 464289164 | 0 | 0 | 1 | 6 | 0 | 08 | 2011-12-28 | 2011-12-30 | 2012-01-05 | 2011-01-12 | 0 | 2011-01-12 | ? | 2 | 0004134455 | 20111227.ifs | 2011-12-27 | 2011-12-28 | |||||||
730882 | 730882 | DIVIDEND | DELETE | 464289164 | 0 | 0 | 1 | 6 | 0 | 08 | 2011-12-20 | 2011-12-22 | 2011-12-29 | 2011-01-12 | 0 | 2011-01-12 | ? | 1 | 0004134454 | 20111219.ifs | 2011-12-19 | 2011-12-20 | |||||||
730883 | 730883 | DIVIDEND | ADD | 464289164 | 0 | 0 | 1 | 0 | .29415 | 00 | 2011-12-20 | 2011-12-22 | 2011-12-29 | 2011-12-19 | 1 | 2011-01-12 | 2011-12-19 | 1 | 0004134454 | 20111219.ifs | 2011-12-19 | 2011-12-20 | |||||||
565879 | 565879 | DIVIDEND | DELETE | 464289164 | 0 | 0 | 1 | 6 | 0 | 08 | 2011-06-22 | 2011-06-24 | 2011-06-28 | 2011-01-12 | 0 | 2011-01-12 | ? | 0 | 0004134453 | 20110621.ifs | 2011-06-21 | 2011-06-22 | |||||||
565880 | 565880 | DIVIDEND | ADD | 464289164 | 0 | 0 | 1 | 0 | .420053 | 00 | 2011-06-22 | 2011-06-24 | 2011-06-28 | 2011-06-21 | 1 | 2011-01-12 | 2011-06-21 | 0 | 0004134453 | 20110621.ifs | 2011-06-21 | 2011-06-22 | |||||||
417733 | 417733 | DIVIDEND | ADD | 464289164 | 0 | 0 | 1 | 6 | 0 | 08 | 2011-12-28 | 2011-12-30 | 2012-01-05 | 2011-01-12 | 0 | 2011-01-12 | ? | 2 | 0004134455 | 20110112.ifs | 2011-01-12 | 2011-01-13 | |||||||
417734 | 417734 | DIVIDEND | ADD | 464289164 | 0 | 0 | 1 | 6 | 0 | 08 | 2011-12-20 | 2011-12-22 | 2011-12-29 | 2011-01-12 | 0 | 2011-01-12 | ? | 1 | 0004134454 | 20110112.ifs | 2011-01-12 | 2011-01-13 | |||||||
417735 | 417735 | DIVIDEND | ADD | 464289164 | 0 | 0 | 1 | 6 | 0 | 08 | 2011-06-22 | 2011-06-24 | 2011-06-28 | 2011-01-12 | 0 | 2011-01-12 | ? | 0 | 0004134453 | 20110112.ifs | 2011-01-12 | 2011-01-13 | |||||||
396700 | 396700 | DIVIDEND | DELETE | 464289164 | 0 | 0 | 1 | 4 | 0 | 08 | 2010-12-29 | 2010-12-31 | 2011-01-05 | 2010-01-27 | 0 | 2010-01-27 | ? | 2 | 0003956312 | 20101228.ifs | 2010-12-28 | 2010-12-29 | |||||||
386911 | 386911 | DIVIDEND | DELETE | 464289164 | 0 | 0 | 1 | 6 | 0 | 08 | 2010-12-21 | 2010-12-23 | 2010-12-30 | 2010-01-27 | 0 | 2010-01-27 | ? | 1 | 0003956310 | 20101220.ifs | 2010-12-20 | 2010-12-21 | |||||||
386912 | 386912 | DIVIDEND | ADD | 464289164 | 0 | 0 | 1 | 0 | .31912 | 00 | 2010-12-21 | 2010-12-23 | 2010-12-30 | 2010-01-27 | 1 | 2010-01-27 | 2010-12-20 | 0 | 0003956310 | 20101220.ifs | 2010-12-20 | 2010-12-21 | |||||||
225615 | 225615 | DIVIDEND | DELETE | 464289164 | 0 | 0 | 1 | 6 | 0 | 08 | 2010-06-23 | 2010-06-25 | 2010-06-29 | 2010-01-27 | 0 | 2010-01-27 | ? | 0 | 0003956308 | 20100622.ifs | 2010-06-22 | 2010-06-23 | |||||||
225616 | 225616 | DIVIDEND | ADD | 464289164 | 0 | 0 | 1 | 0 | .35687 | 00 | 2010-06-23 | 2010-06-25 | 2010-06-29 | 2010-01-27 | 1 | 2010-01-27 | 2010-06-22 | 0 | 0003956308 | 20100622.ifs | 2010-06-22 | 2010-06-23 | |||||||
95316 | 95316 | DIVIDEND | ADD | 464289164 | 0 | 0 | 1 | 4 | 0 | 08 | 2010-12-29 | 2010-12-31 | 2011-01-05 | 2010-01-27 | 0 | 2010-01-27 | ? | 2 | 0003956312 | 20100127.ifs | 2010-01-27 | 2010-04-07 | |||||||
95317 | 95317 | DIVIDEND | ADD | 464289164 | 0 | 0 | 1 | 6 | 0 | 08 | 2010-12-21 | 2010-12-23 | 2010-12-30 | 2010-01-27 | 0 | 2010-01-27 | ? | 1 | 0003956310 | 20100127.ifs | 2010-01-27 | 2010-04-07 | |||||||
95318 | 95318 | DIVIDEND | ADD | 464289164 | 0 | 0 | 1 | 6 | 0 | 08 | 2010-06-23 | 2010-06-25 | 2010-06-29 | 2010-01-27 | 0 | 2010-01-27 | ? | 0 | 0003956308 | 20100127.ifs | 2010-01-27 | 2010-04-07 | |||||||
92357 | 92357 | EQUITY | ADD | 464289164 | MSCI ACWI EX US FINLS INDEX FD | N | 7 | 2010-01-22 | ? | 0 | no | no | no | 2010-01-22 | ? | ? | 20100122.ifs | 2010-01-22 | 2010-04-07 | ||||||||||
92358 | 92358 | EQUITY | CHANGE | 464289164 | MSCI ACWI EX US FINLS INDEX FD | N | 7 | 2010-01-22 | ? | 0 | no | no | no | 2010-01-22 | ? | ? | 20100122.ifs | 2010-01-22 | 2010-04-07 | ||||||||||
92359 | 92358 | EQUITY | CHANGE | 464289164 | MSCI ACWI EX US FINLS INDEX FD | N | 7 | 2010-01-22 | ? | 0 | no | no | yes | 2010-01-22 | 2010-01-22 | ? | 20100122.ifs | 2010-01-22 | 2010-04-07 | ||||||||||
92360 | 92360 | EXCHANGE | ADD | 464289164 | 60 | 2010-01-22 | 2010-01-22 | AXFN | 0 | A | 2010-01-22 | ? | 20100122.ifs | 2010-01-22 | 2010-04-07 | ||||||||||||||
92559 | 92559 | EQUITY | CHANGE | 464289164 | MSCI ACWI EX US FINLS INDEX FD | N | 7 | 2010-01-22 | ? | 0 | no | no | yes | 2010-01-22 | 2010-01-22 | ? | 20100122.ifs | 2010-01-22 | 2010-04-07 | ||||||||||
92560 | 92559 | EQUITY | CHANGE | 464289164 | MSCI ACWI EX US FINLS INDEX FD | N | A | 2010-01-22 | ? | 0 | no | no | yes | 2010-01-22 | 2010-01-22 | ? | 20100122.ifs | 2010-01-22 | 2010-04-07 | ||||||||||
92606 | 92606 | EQUITY | CHANGE | 464289164 | MSCI ACWI EX US FINLS INDEX FD | N | A | 2010-01-22 | ? | 0 | no | no | yes | 2010-01-22 | 2010-01-22 | ? | 20100122.ifs | 2010-01-22 | 2010-04-07 | ||||||||||
92607 | 92606 | EQUITY | CHANGE | 464289164 | MSCI ACWI EX US FINLS INDEX FD | 0 | A | 2010-01-22 | ? | 0 | no | no | yes | 2010-01-22 | 2010-01-22 | ? | 20100122.ifs | 2010-01-22 | 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 = 159628
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