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 AXFN Charts Yahoo AXFN Profile
  Run AXFN Institutional Summary Yahoo AXFN Key Statisics
  J3 Open AXFN Pricing Yahoo AXFN Pricing
  J3 AXFN Insider   J3 AXFN Insitutions Yahoo AXFN Holders
     
  Open up Sector/Exchange Map Fidelity AXFN Lookup
  Open up sec.gov For Market Ca MSN AXFN 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
464289164 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:159628
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
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


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 = 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