Update Company
Name Pricing Date  2024-03-31(LQAP)    
CompId   Stop Date volume LQStart
Ticker Price avevol LQEnd
Cusip Last Trade open LQAve
Sector Country high
   
MktCap CompNum low
yearlylow
Shares Out Type1 prevClose
yearlyhigh
Last_ShsOut    Exchange  
     
  09-30 12-25 sic Code      
Description cik  Updated
  Notes PAGE RESET
  Run EMFN Charts Yahoo EMFN Profile
  Run EMFN Institutional Summary Yahoo EMFN Key Statisics
  J3 Open EMFN Pricing Yahoo EMFN Pricing
  J3 EMFN Insider   J3 EMFN Insitutions Yahoo EMFN Holders
     
  Open up Sector/Exchange Map Fidelity EMFN Lookup
  Open up sec.gov For Market Ca MSN EMFN Lookup
     
  2001-01-01 shsout made up date to make % good  
  0009-09-09 sdate Dead Company  
  2010-12-25 shsout Took From Yahoo  
  9000010176 Next Fake CIK to use
   


INSITITUIONS Dynamic newInstitTable Changed the Cusip/Sector/Shs Out?
Old Cusips
464289172 DELETE RUN
 

Fix Cusip issue where all new and deleted Instittuional Holdings
Current Quarter Date: ie: 2012-06-30
Should We Update The database:
BackUp query is below under BACK UP Institutions before committing.

Total Insititutions : N/A 0   Update Insititution By Cusips
% Owned by Insititutions: N/A % 0 %
pricingQuarterAdminPageOn:
2024-03-31 New %
Delete Company From Institution Summary
Change Institution Stuff 'ZERO' for Cusip

the compid is:159702
New Old Cusip
 

Splits :
 reportDate : 
  ratio : 
  endQuaterAffected : 
  dayFrom  :
  dayTo  :
 

reportDate ratio endQuaterAffected dayFrom dayTo

To Upper  



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


Old 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


Your Name Click here to open the child window


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