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 EFAV Charts Yahoo EFAV Profile
  Run EFAV Institutional Summary Yahoo EFAV Key Statisics
  J3 Open EFAV Pricing Yahoo EFAV Pricing
  J3 EFAV Insider   J3 EFAV Insitutions Yahoo EFAV Holders
     
  Open up Sector/Exchange Map Fidelity EFAV Lookup
  Open up sec.gov For Market Ca MSN EFAV 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
46429B689 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 : 496 463   Update Insititution By Cusips
% Owned by Insititutions: 53.82 % 59.57 %
pricingQuarterAdminPageOn:
2024-03-31 New %
Delete Company From Institution Summary
Change Institution Stuff 'ZERO' for Cusip

the compid is:160362
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
5573818 5573818 DIVIDEND ADD 46429B689 0 0 1 0 1.425169 00 2024-06-11 2024-06-11 2024-06-17 2024-06-10 0 2024-06-10 ? 0 0006931196 20240610.ifs 2024-06-10 2024-06-11
5450328 5450328 DIVIDEND ADD 46429B689 0 0 1 0 .821393 00 2023-12-20 2023-12-21 2023-12-27 2023-12-19 0 2023-12-19 ? 0 0006840873 20231219.ifs 2023-12-19 2023-12-20
5307560 5307560 DIVIDEND ADD 46429B689 0 0 1 0 1.311269 00 2023-06-07 2023-06-08 2023-06-13 2023-06-06 0 2023-06-06 ? 0 0006737154 20230606.ifs 2023-06-06 2023-06-07
5162394 5162394 DIVIDEND ADD 46429B689 0 0 1 0 .496935 00 2022-12-13 2022-12-14 2022-12-19 2022-12-12 0 2022-12-12 ? 0 0006629638 20221212.ifs 2022-12-12 2022-12-13
5030112 5030112 DIVIDEND ADD 46429B689 0 0 1 0 1.109262 00 2022-06-09 2022-06-10 2022-06-15 2022-06-08 0 2022-06-08 ? 0 0006536709 20220608.ifs 2022-06-08 2022-06-09
4877063 4877063 DIVIDEND ADD 46429B689 0 0 1 0 .634112 00 2021-12-13 2021-12-14 2021-12-17 2021-12-10 0 2021-12-10 ? 0 0006417501 20211210.ifs 2021-12-10 2021-12-11
4725890 4725890 DIVIDEND ADD 46429B689 0 0 1 0 1.265077 00 2021-06-10 2021-06-11 2021-06-16 2021-06-09 0 2021-06-09 ? 0 0006320528 20210609.ifs 2021-06-09 2021-06-10
4539111 4539111 DIVIDEND ADD 46429B689 0 0 E 0 0 58 ? ? 2020-12-18 2020-12-11 0 2020-12-11 ? 0 0006209364 20201211.ifs 2020-12-11 2020-12-12
4441476 4441476 EQUITY CHANGE 46429B689 ISHARES EDGE MSCI MIN VOL EAFE ETF 0 A 2011-10-20 ? 2 no no no 2011-10-20 2016-05-12 ? 20200818.ifs 2020-08-18 2020-08-19
4441477 4441476 EQUITY CHANGE 46429B689 MSCI EAFE MINIMUM VOLATILITY FACTOR ETF 0 A 2011-10-20 ? 2 no no no 2011-10-20 2020-08-18 ? 20200818.ifs 2020-08-18 2020-08-19
4390991 4390991 DIVIDEND ADD 46429B689 0 0 1 0 .9773 00 2020-06-15 2020-06-16 2020-06-19 2020-06-12 0 2020-06-12 ? 0 0006112208 20200612.ifs 2020-06-12 2020-06-13
4067891 4067891 DIVIDEND ADD 46429B689 0 0 1 0 1.73438 00 2019-12-16 2019-12-17 2019-12-20 2019-12-13 0 2019-12-13 ? 0 0006000216 20191213.ifs 2019-12-13 2019-12-14
4067970 4067970 DIVIDEND ADD 46429B689 0 0 1 0 1.73438 00 2019-12-16 2019-12-17 2019-12-20 2019-12-13 0 2019-12-13 ? 0 0006000216 20191213.ifs 2019-12-13 2019-12-14
3780913 3780913 DIVIDEND ADD 46429B689 0 0 1 0 1.385553 00 2019-06-17 2019-06-18 2019-06-21 2019-06-14 0 2019-06-14 ? 0 0005898860 20190614.ifs 2019-06-14 2019-06-15
3780936 3780936 DIVIDEND ADD 46429B689 0 0 1 0 1.385553 00 2019-06-17 2019-06-18 2019-06-21 2019-06-14 0 2019-06-14 ? 0 0005898860 20190614.ifs 2019-06-14 2019-06-15
3452310 3452310 DIVIDEND ADD 46429B689 0 0 1 0 .771266 00 2018-12-18 2018-12-19 2018-12-24 2018-12-17 0 2018-12-17 ? 0 0005785741 20181217.ifs 2018-12-17 2018-12-18
3452469 3452469 DIVIDEND ADD 46429B689 0 0 1 0 .771266 00 2018-12-18 2018-12-19 2018-12-24 2018-12-17 0 2018-12-17 ? 0 0005785741 20181217.ifs 2018-12-17 2018-12-18
3144026 3144026 DIVIDEND ADD 46429B689 0 0 1 0 1.452978 00 2018-06-19 2018-06-20 2018-06-25 2018-06-18 0 2018-06-18 ? 0 0005676530 20180618.ifs 2018-06-18 2018-06-19
3144027 3144027 DIVIDEND ADD 46429B689 0 0 1 0 1.452978 00 2018-06-19 2018-06-20 2018-06-25 2018-06-18 0 2018-06-18 ? 0 0005676530 20180618.ifs 2018-06-18 2018-06-19
2839533 2839533 DIVIDEND ADD 46429B689 0 0 1 0 .393831 00 2017-12-19 2017-12-20 2017-12-26 2017-12-18 0 2017-12-18 ? 0 0005564359 20171218.ifs 2017-12-18 2017-12-19
2642219 2642219 CORPACTION ADD 46429B689 04 X 2017-08-02 46429B689 12 2017-08-02 20170802.ifs 2017-08-02 2017-08-03
2595038 2595038 DIVIDEND ADD 46429B689 0 0 1 0 1.397018 00 2017-06-20 2017-06-22 2017-06-26 2017-06-19 0 2017-06-19 ? 0 0005451164 20170619.ifs 2017-06-19 2017-06-20
2451288 2451288 EQUITY CHANGE 46429B689 ISHARES EDGE MSCI MIN VOL EAFE ETF 0 A 2011-10-20 ? 0 no no no 2011-10-20 2016-05-12 ? 20170124.ifs 2017-01-24 2017-01-25
2451289 2451288 EQUITY CHANGE 46429B689 ISHARES EDGE MSCI MIN VOL EAFE ETF 0 A 2011-10-20 ? 2 no no no 2011-10-20 2016-05-12 ? 20170124.ifs 2017-01-24 2017-01-25
2388178 2388178 DIVIDEND ADD 46429B689 0 0 1 0 1.410869 00 2016-12-21 2016-12-23 2016-12-28 2016-12-20 0 2016-12-20 ? 0 0005346363 20161220.ifs 2016-12-20 2016-12-21
2226634 2226634 DIVIDEND ADD 46429B689 0 0 1 0 1.00308 00 2016-06-22 2016-06-24 2016-06-28 2016-06-21 0 2016-06-21 ? 0 0005236470 20160621.ifs 2016-06-21 2016-06-22
2194957 2194957 CORPACTION ADD 46429B689 04 # 2016-05-12 46429B689 04 ? 20160512.ifs 2016-05-12 2016-05-13
2194958 2194958 CORPACTIONAUX ADD 46429B689 04 2016-05-12 EFAV ISHARES TR ISHARES TRUST - EFAV ISHARES TR ISHARES EDGE MS 2016-05-12 ? 20160512.ifs 2016-05-12 2016-05-13
2194959 2194959 EQUITY CHANGE 46429B689 ISHARES MSCI EAFE MINIMUM VOLATILITY ETF 0 A 2011-10-20 ? 0 no no no 2011-10-20 2013-07-01 ? 20160512.ifs 2016-05-12 2016-05-13
2194960 2194959 EQUITY CHANGE 46429B689 ISHARES EDGE MSCI MIN VOL EAFE ETF 0 A 2011-10-20 ? 0 no no no 2011-10-20 2016-05-12 ? 20160512.ifs 2016-05-12 2016-05-13
2052946 2052946 DIVIDEND ADD 46429B689 0 0 1 0 .669539 00 2015-12-21 2015-12-23 2015-12-28 2015-12-18 0 2015-12-18 ? 0 0005130255 20151218.ifs 2015-12-18 2015-12-19
1719521 1719521 DIVIDEND ADD 46429B689 0 0 1 0 .828224 00 2014-12-17 2014-12-19 2014-12-24 2014-12-16 0 2014-12-16 ? 0 0004901998 20141216.ifs 2014-12-16 2014-12-17
1558910 1558910 DIVIDEND ADD 46429B689 0 0 1 0 1.371699 00 2014-06-25 2014-06-27 2014-07-02 2014-06-24 0 2014-06-24 ? 0 0004801504 20140624.ifs 2014-06-24 2014-06-25
1376861 1376861 DIVIDEND ADD 46429B689 0 0 1 0 .77417 00 2013-12-18 2013-12-20 2013-12-30 2013-12-17 0 2013-12-17 ? 0 0004688616 20131217.ifs 2013-12-17 2013-12-18
1227536 1227536 CORPACTION ADD 46429B689 04 # 2013-07-01 46429B689 04 ? 20130701.ifs 2013-07-01 2013-07-02
1227537 1227537 CORPACTIONAUX ADD 46429B689 04 2013-07-01 EFAV ISHARES TR MSCI EAFE MINIM EFAV ISHARES TR ISHARES MSCI EA 2013-07-01 ? 20130701.ifs 2013-07-01 2013-07-02
1227538 1227538 EQUITY CHANGE 46429B689 MSCI EAFE MINIMUM VOLATILITY INDEX FD 0 A 2011-10-20 ? 0 no no no 2011-10-20 2011-10-20 ? 20130701.ifs 2013-07-01 2013-07-02
1227539 1227538 EQUITY CHANGE 46429B689 ISHARES MSCI EAFE MINIMUM VOLATILITY ETF 0 A 2011-10-20 ? 0 no no no 2011-10-20 2013-07-01 ? 20130701.ifs 2013-07-01 2013-07-02
1218974 1218974 DIVIDEND ADD 46429B689 0 0 1 0 .785648 00 2013-06-27 2013-07-01 2013-07-05 2013-06-26 0 2013-06-26 ? 0 0004590000 20130626.ifs 2013-06-26 2013-06-27
1044695 1044695 DIVIDEND ADD 46429B689 0 0 1 0 .500392 00 2012-12-18 2012-12-20 2012-12-27 2012-12-17 0 2012-12-17 ? 0 0004483117 20121217.ifs 2012-12-17 2012-12-18
895515 895515 DIVIDEND CHANGE 46429B689 0 0 1 0 .5786 00 2012-06-21 2012-06-25 2012-06-28 2012-06-20 0 2012-06-20 ? 0 0004389167 20120627.ifs 2012-06-27 2012-06-28
895516 895515 DIVIDEND CHANGE 46429B689 0 0 1 0 .578626 00 2012-06-21 2012-06-25 2012-06-28 2012-06-20 1 2012-06-20 2012-06-27 0 0004389167 20120627.ifs 2012-06-27 2012-06-28
889568 889568 DIVIDEND ADD 46429B689 0 0 1 0 .5786 00 2012-06-21 2012-06-25 2012-06-28 2012-06-20 0 2012-06-20 ? 0 0004389167 20120620.ifs 2012-06-20 2012-06-21
730858 730858 DIVIDEND ADD 46429B689 0 0 1 4 .23267 00 2011-12-20 2011-12-22 2011-12-29 2011-12-19 0 2011-12-19 ? 0 0004295306 20111219.ifs 2011-12-19 2011-12-20
675675 675675 EQUITY ADD 46429B689 MSCI EAFE MINIMUM VOLATILITY INDEX FD N 7 2011-10-20 ? 0 no no no 2011-10-20 ? ? 20111020.ifs 2011-10-20 2011-10-21
675676 675676 EXCHANGE ADD 46429B689 04 2011-10-20 2011-10-20 EFAV 0 A 2011-10-20 ? 20111020.ifs 2011-10-20 2011-10-21
675773 675773 EQUITY CHANGE 46429B689 MSCI EAFE MINIMUM VOLATILITY INDEX FD N 7 2011-10-20 ? 0 no no no 2011-10-20 ? ? 20111020.ifs 2011-10-20 2011-10-21
675774 675773 EQUITY CHANGE 46429B689 MSCI EAFE MINIMUM VOLATILITY INDEX FD N A 2011-10-20 ? 0 no no no 2011-10-20 2011-10-20 ? 20111020.ifs 2011-10-20 2011-10-21
676476 676476 EQUITY CHANGE 46429B689 MSCI EAFE MINIMUM VOLATILITY INDEX FD N A 2011-10-20 ? 0 no no no 2011-10-20 2011-10-20 ? 20111020.ifs 2011-10-20 2011-10-21
676477 676476 EQUITY CHANGE 46429B689 MSCI EAFE MINIMUM VOLATILITY INDEX FD 0 A 2011-10-20 ? 0 no no no 2011-10-20 2011-10-20 ? 20111020.ifs 2011-10-20 2011-10-21


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