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:159702 |
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 | ||
1924668 | 1924668 | EQUITY | CHANGE | 464289172 | MSCI EMERGING MKTS FINL ETF | L | A | 2010-01-22 | 2014-10-15 | 0 | no | no | yes | 2010-01-22 | 2014-10-15 | ? | 20150729.ifs | 2015-07-29 | 2015-07-30 | ||||||||||
1924669 | 1924668 | EQUITY | CHANGE | 464289172 | MSCI EMERGING MKTS FINL ETF | L | A | 2010-01-22 | 2015-07-29 | 0 | no | no | yes | 2010-01-22 | 2015-07-29 | ? | 20150729.ifs | 2015-07-29 | 2015-07-30 | ||||||||||
1925230 | 1925230 | DIVIDEND | DELETE | 464289172 | 0 | 0 | 1 | 6 | 0 | 08 | 2014-12-29 | 2014-12-31 | 2015-01-05 | 2014-01-02 | 0 | 2014-01-02 | ? | 2 | 0004718189 | 20150729.ifs | 2015-07-29 | 2015-07-30 | |||||||
1925231 | 1925231 | DIVIDEND | DELETE | 464289172 | 0 | 0 | 1 | 6 | 0 | 08 | 2014-12-17 | 2014-12-19 | 2014-12-24 | 2014-01-02 | 0 | 2014-01-02 | ? | 1 | 0004718188 | 20150729.ifs | 2015-07-29 | 2015-07-30 | |||||||
1657383 | 1657383 | CORPACTION | ADD | 464289172 | 60 | L | 2014-10-15 | ? | 20141015.ifs | 2014-10-15 | 2014-10-16 | ||||||||||||||||||
1657384 | 1657384 | EQUITY | CHANGE | 464289172 | MSCI EMERGING MKTS FINL ETF | 0 | A | 2010-01-22 | ? | 0 | no | no | yes | 2010-01-22 | 2013-07-01 | ? | 20141015.ifs | 2014-10-15 | 2014-10-16 | ||||||||||
1657385 | 1657384 | EQUITY | CHANGE | 464289172 | MSCI EMERGING MKTS FINL ETF | L | A | 2010-01-22 | 2014-10-15 | 0 | no | no | yes | 2010-01-22 | 2014-10-15 | ? | 20141015.ifs | 2014-10-15 | 2014-10-16 | ||||||||||
1558944 | 1558944 | DIVIDEND | DELETE | 464289172 | 0 | 0 | 1 | 6 | 0 | 08 | 2014-06-25 | 2014-06-27 | 2014-07-02 | 2014-01-02 | 0 | 2014-01-02 | ? | 0 | 0004718187 | 20140624.ifs | 2014-06-24 | 2014-06-25 | |||||||
1558945 | 1558945 | DIVIDEND | ADD | 464289172 | 0 | 0 | 1 | 0 | .363476 | 00 | 2014-06-25 | 2014-06-27 | 2014-07-02 | 2014-06-24 | 1 | 2014-01-02 | 2014-06-24 | 0 | 0004718187 | 20140624.ifs | 2014-06-24 | 2014-06-25 | |||||||
1413964 | 1413964 | DIVIDEND | ADD | 464289172 | 0 | 0 | 1 | 6 | 0 | 08 | 2014-12-29 | 2014-12-31 | 2015-01-05 | 2014-01-02 | 0 | 2014-01-02 | ? | 2 | 0004718189 | 20140102.ifs | 2014-01-02 | 2014-01-03 | |||||||
1413965 | 1413965 | DIVIDEND | ADD | 464289172 | 0 | 0 | 1 | 6 | 0 | 08 | 2014-12-17 | 2014-12-19 | 2014-12-24 | 2014-01-02 | 0 | 2014-01-02 | ? | 1 | 0004718188 | 20140102.ifs | 2014-01-02 | 2014-01-03 | |||||||
1413966 | 1413966 | DIVIDEND | ADD | 464289172 | 0 | 0 | 1 | 6 | 0 | 08 | 2014-06-25 | 2014-06-27 | 2014-07-02 | 2014-01-02 | 0 | 2014-01-02 | ? | 0 | 0004718187 | 20140102.ifs | 2014-01-02 | 2014-01-03 | |||||||
1396974 | 1396974 | DIVIDEND | DELETE | 464289172 | 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 | 0004513388 | 20131226.ifs | 2013-12-26 | 2013-12-27 | |||||||
1376912 | 1376912 | DIVIDEND | CHANGE | 464289172 | 0 | 0 | 1 | 6 | 0 | 08 | 2013-12-27 | 2013-12-31 | 2014-01-03 | 2013-01-09 | 0 | 2013-01-09 | ? | 2 | 0004513388 | 20131217.ifs | 2013-12-17 | 2013-12-18 | |||||||
1376913 | 1376912 | DIVIDEND | CHANGE | 464289172 | 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 | 0004513388 | 20131217.ifs | 2013-12-17 | 2013-12-18 | |||||||
1376914 | 1376914 | DIVIDEND | DELETE | 464289172 | 0 | 0 | 1 | 6 | 0 | 08 | 2013-12-18 | 2013-12-20 | 2013-12-30 | 2013-01-09 | 0 | 2013-01-09 | ? | 1 | 0004513384 | 20131217.ifs | 2013-12-17 | 2013-12-18 | |||||||
1376915 | 1376915 | DIVIDEND | ADD | 464289172 | 0 | 0 | 1 | 0 | .131476 | 00 | 2013-12-18 | 2013-12-20 | 2013-12-30 | 2013-12-17 | 1 | 2013-01-09 | 2013-12-17 | 0 | 0004513384 | 20131217.ifs | 2013-12-17 | 2013-12-18 | |||||||
1227654 | 1227654 | CORPACTION | ADD | 464289172 | 60 | # | 2013-07-01 | 464289172 | 60 | ? | 20130701.ifs | 2013-07-01 | 2013-07-02 | ||||||||||||||||
1227655 | 1227655 | CORPACTIONAUX | ADD | 464289172 | 60 | 2013-07-01 | EMFN | ISHARES TR | ISHARES MSCI EM | EMFN | ISHARES TR | ISHARES MSCI EM | 2013-07-01 | ? | 20130701.ifs | 2013-07-01 | 2013-07-02 | ||||||||||||
1227656 | 1227656 | EQUITY | CHANGE | 464289172 | MSCI EMERGING MKTS FINL SECTOR 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 | ||||||||||
1227657 | 1227656 | EQUITY | CHANGE | 464289172 | ISHARES MSCI EMERGING MARKETS 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 | ||||||||||
1227983 | 1227983 | EQUITY | CHANGE | 464289172 | ISHARES MSCI EMERGING MARKETS 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 | ||||||||||
1227984 | 1227983 | EQUITY | CHANGE | 464289172 | MSCI EMERGING MKTS FINL ETF | 0 | A | 2010-01-22 | ? | 0 | no | no | yes | 2010-01-22 | 2013-07-01 | ? | 20130701.ifs | 2013-07-01 | 2013-07-02 | ||||||||||
1227986 | 1227985 | EQUITY | CHANGE | 464289172 | 60 | # | 2013-07-01 | 464289172 | 60 | ? | 20130701.ifs | 2013-07-01 | 2013-07-02 | ||||||||||||||||
1227987 | 1227986 | EQUITY | CHANGE | 464289172 | 60 | # | 2013-07-01 | 464289172 | 60 | 2013-07-01 | 20130701.ifs | 2013-07-01 | 2013-07-02 | ||||||||||||||||
1227989 | 1227988 | EQUITY | CHANGE | 464289172 | 60 | 2013-07-01 | EMFN | ISHARES TR | ISHARES MSCI EM | EMFN | ISHARES TR | ISHARES MSCI EM | 2013-07-01 | ? | 20130701.ifs | 2013-07-01 | 2013-07-02 | ||||||||||||
1227990 | 1227989 | EQUITY | CHANGE | 464289172 | 60 | 2013-07-01 | EMFN | ISHARES TR | ISHARES MSCI EM | EMFN | ISHARES TR | MSCI EMERGING M | 2013-07-01 | 2013-07-01 | 20130701.ifs | 2013-07-01 | 2013-07-02 | ||||||||||||
1219004 | 1219004 | DIVIDEND | DELETE | 464289172 | 0 | 0 | 1 | 6 | 0 | 08 | 2013-06-27 | 2013-07-01 | 2013-07-05 | 2013-01-09 | 0 | 2013-01-09 | ? | 0 | 0004513378 | 20130626.ifs | 2013-06-26 | 2013-06-27 | |||||||
1219005 | 1219005 | DIVIDEND | ADD | 464289172 | 0 | 0 | 1 | 0 | .450748 | 00 | 2013-06-27 | 2013-07-01 | 2013-07-05 | 2013-06-26 | 1 | 2013-01-09 | 2013-06-26 | 0 | 0004513378 | 20130626.ifs | 2013-06-26 | 2013-06-27 | |||||||
1086983 | 1086983 | DIVIDEND | ADD | 464289172 | 0 | 0 | 1 | 6 | 0 | 08 | 2013-12-27 | 2013-12-31 | 2014-01-03 | 2013-01-09 | 0 | 2013-01-09 | ? | 2 | 0004513388 | 20130109.ifs | 2013-01-09 | 2013-01-10 | |||||||
1086984 | 1086984 | DIVIDEND | ADD | 464289172 | 0 | 0 | 1 | 6 | 0 | 08 | 2013-12-18 | 2013-12-20 | 2013-12-30 | 2013-01-09 | 0 | 2013-01-09 | ? | 1 | 0004513384 | 20130109.ifs | 2013-01-09 | 2013-01-10 | |||||||
1086985 | 1086985 | DIVIDEND | ADD | 464289172 | 0 | 0 | 1 | 6 | 0 | 08 | 2013-06-27 | 2013-07-01 | 2013-07-05 | 2013-01-09 | 0 | 2013-01-09 | ? | 0 | 0004513378 | 20130109.ifs | 2013-01-09 | 2013-01-10 | |||||||
1064362 | 1064362 | DIVIDEND | DELETE | 464289172 | 0 | 0 | 1 | 0 | .055667 | 00 | 2012-12-18 | 2012-12-20 | 2012-12-28 | 2012-12-17 | 1 | 2012-01-12 | 2012-12-17 | 1 | 0004320359 | 20121227.ifs | 2012-12-27 | 2012-12-28 | |||||||
1064363 | 1064363 | DIVIDEND | ADD | 464289172 | 0 | 0 | 1 | 0 | .055667 | 00 | 2012-12-18 | 2012-12-20 | 2012-12-27 | 2012-12-17 | 2 | 2012-01-12 | 2012-12-27 | 1 | 0004320359 | 20121227.ifs | 2012-12-27 | 2012-12-28 | |||||||
1060963 | 1060963 | DIVIDEND | DELETE | 464289172 | 0 | 0 | 1 | 6 | .375923 | 08 | 2012-12-27 | 2012-12-31 | 2013-01-03 | 2012-01-12 | 1 | 2012-01-12 | 2012-06-27 | 2 | 0004320360 | 20121226.ifs | 2012-12-26 | 2012-12-27 | |||||||
1044731 | 1044731 | DIVIDEND | DELETE | 464289172 | 0 | 0 | 1 | 6 | 0 | 08 | 2012-12-18 | 2012-12-20 | 2012-12-28 | 2012-01-12 | 0 | 2012-01-12 | ? | 1 | 0004320359 | 20121217.ifs | 2012-12-17 | 2012-12-18 | |||||||
1044732 | 1044732 | DIVIDEND | ADD | 464289172 | 0 | 0 | 1 | 0 | .055667 | 00 | 2012-12-18 | 2012-12-20 | 2012-12-28 | 2012-12-17 | 1 | 2012-01-12 | 2012-12-17 | 1 | 0004320359 | 20121217.ifs | 2012-12-17 | 2012-12-18 | |||||||
895551 | 895551 | DIVIDEND | CHANGE | 464289172 | 0 | 0 | 1 | 6 | 0 | 08 | 2012-12-27 | 2012-12-31 | 2013-01-03 | 2012-01-12 | 0 | 2012-01-12 | ? | 2 | 0004320360 | 20120627.ifs | 2012-06-27 | 2012-06-28 | |||||||
895552 | 895551 | DIVIDEND | CHANGE | 464289172 | 0 | 0 | 1 | 6 | .375923 | 08 | 2012-12-27 | 2012-12-31 | 2013-01-03 | 2012-01-12 | 1 | 2012-01-12 | 2012-06-27 | 2 | 0004320360 | 20120627.ifs | 2012-06-27 | 2012-06-28 | |||||||
889597 | 889597 | DIVIDEND | DELETE | 464289172 | 0 | 0 | 1 | 6 | 0 | 08 | 2012-06-21 | 2012-06-25 | 2012-06-28 | 2012-01-12 | 0 | 2012-01-12 | ? | 0 | 0004320358 | 20120620.ifs | 2012-06-20 | 2012-06-21 | |||||||
889598 | 889598 | DIVIDEND | ADD | 464289172 | 0 | 0 | 1 | 0 | .375923 | 00 | 2012-06-21 | 2012-06-25 | 2012-06-28 | 2012-06-20 | 1 | 2012-01-12 | 2012-06-20 | 0 | 0004320358 | 20120620.ifs | 2012-06-20 | 2012-06-21 | |||||||
755761 | 755761 | DIVIDEND | ADD | 464289172 | 0 | 0 | 1 | 6 | 0 | 08 | 2012-12-27 | 2012-12-31 | 2013-01-03 | 2012-01-12 | 0 | 2012-01-12 | ? | 2 | 0004320360 | 20120112.ifs | 2012-01-12 | 2012-01-13 | |||||||
755762 | 755762 | DIVIDEND | ADD | 464289172 | 0 | 0 | 1 | 6 | 0 | 08 | 2012-12-18 | 2012-12-20 | 2012-12-28 | 2012-01-12 | 0 | 2012-01-12 | ? | 1 | 0004320359 | 20120112.ifs | 2012-01-12 | 2012-01-13 | |||||||
755763 | 755763 | DIVIDEND | ADD | 464289172 | 0 | 0 | 1 | 6 | 0 | 08 | 2012-06-21 | 2012-06-25 | 2012-06-28 | 2012-01-12 | 0 | 2012-01-12 | ? | 0 | 0004320358 | 20120112.ifs | 2012-01-12 | 2012-01-13 | |||||||
739333 | 739333 | DIVIDEND | DELETE | 464289172 | 0 | 0 | 1 | 6 | 0 | 08 | 2011-12-28 | 2011-12-30 | 2012-01-05 | 2011-01-12 | 0 | 2011-01-12 | ? | 2 | 0004134467 | 20111227.ifs | 2011-12-27 | 2011-12-28 | |||||||
730880 | 730880 | DIVIDEND | DELETE | 464289172 | 0 | 0 | 1 | 6 | 0 | 08 | 2011-12-20 | 2011-12-22 | 2011-12-29 | 2011-01-12 | 0 | 2011-01-12 | ? | 1 | 0004134466 | 20111219.ifs | 2011-12-19 | 2011-12-20 | |||||||
730881 | 730881 | DIVIDEND | ADD | 464289172 | 0 | 0 | 1 | 0 | 1.155067 | 00 | 2011-12-20 | 2011-12-22 | 2011-12-29 | 2011-12-19 | 1 | 2011-01-12 | 2011-12-19 | 1 | 0004134466 | 20111219.ifs | 2011-12-19 | 2011-12-20 | |||||||
565877 | 565877 | DIVIDEND | DELETE | 464289172 | 0 | 0 | 1 | 6 | 0 | 08 | 2011-06-22 | 2011-06-24 | 2011-06-28 | 2011-01-12 | 0 | 2011-01-12 | ? | 0 | 0004134465 | 20110621.ifs | 2011-06-21 | 2011-06-22 | |||||||
565878 | 565878 | DIVIDEND | ADD | 464289172 | 0 | 0 | 1 | 0 | .336658 | 00 | 2011-06-22 | 2011-06-24 | 2011-06-28 | 2011-06-21 | 1 | 2011-01-12 | 2011-06-21 | 0 | 0004134465 | 20110621.ifs | 2011-06-21 | 2011-06-22 | |||||||
417730 | 417730 | DIVIDEND | ADD | 464289172 | 0 | 0 | 1 | 6 | 0 | 08 | 2011-12-28 | 2011-12-30 | 2012-01-05 | 2011-01-12 | 0 | 2011-01-12 | ? | 2 | 0004134467 | 20110112.ifs | 2011-01-12 | 2011-01-13 | |||||||
417731 | 417731 | DIVIDEND | ADD | 464289172 | 0 | 0 | 1 | 6 | 0 | 08 | 2011-12-20 | 2011-12-22 | 2011-12-29 | 2011-01-12 | 0 | 2011-01-12 | ? | 1 | 0004134466 | 20110112.ifs | 2011-01-12 | 2011-01-13 | |||||||
417732 | 417732 | DIVIDEND | ADD | 464289172 | 0 | 0 | 1 | 6 | 0 | 08 | 2011-06-22 | 2011-06-24 | 2011-06-28 | 2011-01-12 | 0 | 2011-01-12 | ? | 0 | 0004134465 | 20110112.ifs | 2011-01-12 | 2011-01-13 | |||||||
396699 | 396699 | DIVIDEND | DELETE | 464289172 | 0 | 0 | 1 | 4 | 0 | 08 | 2010-12-29 | 2010-12-31 | 2011-01-05 | 2010-01-27 | 0 | 2010-01-27 | ? | 2 | 0003956316 | 20101228.ifs | 2010-12-28 | 2010-12-29 | |||||||
386909 | 386909 | DIVIDEND | DELETE | 464289172 | 0 | 0 | 1 | 6 | 0 | 08 | 2010-12-21 | 2010-12-23 | 2010-12-30 | 2010-01-27 | 0 | 2010-01-27 | ? | 1 | 0003956315 | 20101220.ifs | 2010-12-20 | 2010-12-21 | |||||||
386910 | 386910 | DIVIDEND | ADD | 464289172 | 0 | 0 | 1 | 0 | .077338 | 00 | 2010-12-21 | 2010-12-23 | 2010-12-30 | 2010-01-27 | 1 | 2010-01-27 | 2010-12-20 | 0 | 0003956315 | 20101220.ifs | 2010-12-20 | 2010-12-21 | |||||||
225613 | 225613 | DIVIDEND | DELETE | 464289172 | 0 | 0 | 1 | 6 | 0 | 08 | 2010-06-23 | 2010-06-25 | 2010-06-29 | 2010-01-27 | 0 | 2010-01-27 | ? | 0 | 0003956314 | 20100622.ifs | 2010-06-22 | 2010-06-23 | |||||||
225614 | 225614 | DIVIDEND | ADD | 464289172 | 0 | 0 | 1 | 0 | .21538 | 00 | 2010-06-23 | 2010-06-25 | 2010-06-29 | 2010-01-27 | 1 | 2010-01-27 | 2010-06-22 | 0 | 0003956314 | 20100622.ifs | 2010-06-22 | 2010-06-23 | |||||||
95313 | 95313 | DIVIDEND | ADD | 464289172 | 0 | 0 | 1 | 4 | 0 | 08 | 2010-12-29 | 2010-12-31 | 2011-01-05 | 2010-01-27 | 0 | 2010-01-27 | ? | 2 | 0003956316 | 20100127.ifs | 2010-01-27 | 2010-04-07 | |||||||
95314 | 95314 | DIVIDEND | ADD | 464289172 | 0 | 0 | 1 | 6 | 0 | 08 | 2010-12-21 | 2010-12-23 | 2010-12-30 | 2010-01-27 | 0 | 2010-01-27 | ? | 1 | 0003956315 | 20100127.ifs | 2010-01-27 | 2010-04-07 | |||||||
95315 | 95315 | DIVIDEND | ADD | 464289172 | 0 | 0 | 1 | 6 | 0 | 08 | 2010-06-23 | 2010-06-25 | 2010-06-29 | 2010-01-27 | 0 | 2010-01-27 | ? | 0 | 0003956314 | 20100127.ifs | 2010-01-27 | 2010-04-07 | |||||||
92331 | 92331 | EQUITY | ADD | 464289172 | MSCI EMERGING MKTS FINL SECTOR | N | 0 | 2010-01-22 | ? | 0 | no | no | no | 2010-01-22 | ? | ? | 20100122.ifs | 2010-01-22 | 2010-04-07 | ||||||||||
92332 | 92332 | EQUITY | CHANGE | 464289172 | MSCI EMERGING MKTS FINL SECTOR | N | 0 | 2010-01-22 | ? | 0 | no | no | no | 2010-01-22 | ? | ? | 20100122.ifs | 2010-01-22 | 2010-04-07 | ||||||||||
92333 | 92332 | EQUITY | CHANGE | 464289172 | MSCI EMERGING MKTS FINL SECTOR | N | 0 | 2010-01-22 | ? | 0 | no | no | yes | 2010-01-22 | 2010-01-22 | ? | 20100122.ifs | 2010-01-22 | 2010-04-07 | ||||||||||
92334 | 92334 | EXCHANGE | ADD | 464289172 | 60 | 2010-01-22 | 2010-01-22 | EMFN | 0 | A | 2010-01-22 | ? | 20100122.ifs | 2010-01-22 | 2010-04-07 | ||||||||||||||
92555 | 92555 | EQUITY | CHANGE | 464289172 | MSCI EMERGING MKTS FINL SECTOR | N | 0 | 2010-01-22 | ? | 0 | no | no | yes | 2010-01-22 | 2010-01-22 | ? | 20100122.ifs | 2010-01-22 | 2010-04-07 | ||||||||||
92556 | 92555 | EQUITY | CHANGE | 464289172 | MSCI EMERGING MKTS FINL SECTOR 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 | ||||||||||
92618 | 92618 | EQUITY | CHANGE | 464289172 | MSCI EMERGING MKTS FINL SECTOR 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 | ||||||||||
92619 | 92618 | EQUITY | CHANGE | 464289172 | MSCI EMERGING MKTS FINL SECTOR 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 = 159702
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