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

the compid is:159781
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
5448858 5448858 DIVIDEND ADD 921932844 0 0 1 0 1.3294 35 2023-12-20 2023-12-21 2023-12-26 2023-12-18 0 2023-12-19 ? 0 0006838161 20231219.ifs 2023-12-19 2023-12-20
5235283 5235283 DIVIDEND ADD 921932844 0 0 6 0 1 11 2023-03-14 2023-03-10 2023-03-13 2023-02-23 0 2023-02-27 ? 0 0006685718 20230227.ifs 2023-02-27 2023-02-28
5235284 5235284 SPLIT ADD 921932844 .5 2023-03-14 11 2023-02-27 ? 20230227.ifs 2023-02-27 2023-02-28
5172736 5172736 DIVIDEND ADD 921932844 0 0 1 0 3.0187 00 2022-12-20 2022-12-21 2022-12-23 2022-12-16 0 2022-12-16 ? 0 0006640773 20221216.ifs 2022-12-16 2022-12-17
4897482 4897482 DIVIDEND ADD 921932844 0 0 1 0 3.0051 00 2021-12-21 2021-12-22 2021-12-27 2021-12-17 0 2021-12-17 ? 0 0006435697 20211217.ifs 2021-12-17 2021-12-18
4554278 4554278 DIVIDEND ADD 921932844 0 0 1 0 3.1834 00 2020-12-22 2020-12-23 2020-12-28 2020-12-18 0 2020-12-18 ? 0 0006225007 20201218.ifs 2020-12-18 2020-12-19
4064917 4064917 DIVIDEND ADD 921932844 0 0 1 0 2.2747 00 2019-12-16 2019-12-17 2019-12-19 2019-12-12 0 2019-12-13 ? 0 0005997875 20191213.ifs 2019-12-13 2019-12-14
4065112 4065112 DIVIDEND ADD 921932844 0 0 1 0 2.2747 00 2019-12-16 2019-12-17 2019-12-19 2019-12-12 0 2019-12-13 ? 0 0005997875 20191213.ifs 2019-12-13 2019-12-14
3419717 3419717 DIVIDEND ADD 921932844 0 0 1 0 1.962 00 2018-12-13 2018-12-14 2018-12-18 2018-12-11 0 2018-12-11 ? 0 0005772923 20181211.ifs 2018-12-11 2018-12-12
3419718 3419718 DIVIDEND ADD 921932844 0 0 1 0 1.962 00 2018-12-13 2018-12-14 2018-12-18 2018-12-11 0 2018-12-11 ? 0 0005772923 20181211.ifs 2018-12-11 2018-12-12
2841716 2841716 DIVIDEND ADD 921932844 0 0 1 0 1.888 00 2017-12-21 2017-12-22 2017-12-27 2017-12-19 0 2017-12-19 ? 0 0005567402 20171219.ifs 2017-12-19 2017-12-20
2841836 2841836 DIVIDEND ADD 921932844 0 0 1 0 1.888 00 2017-12-21 2017-12-22 2017-12-27 2017-12-19 0 2017-12-19 ? 0 0005567402 20171219.ifs 2017-12-19 2017-12-20
2379032 2379032 DIVIDEND ADD 921932844 0 0 1 0 1.501 00 2016-12-20 2016-12-22 2016-12-27 2016-12-16 0 2016-12-16 ? 0 0005340888 20161216.ifs 2016-12-16 2016-12-17
2039165 2039165 DIVIDEND ADD 921932844 0 0 1 0 1.471 00 2015-12-17 2015-12-21 2015-12-23 2015-12-15 0 2015-12-15 ? 0 0005118861 20151215.ifs 2015-12-15 2015-12-16
1730669 1730669 DIVIDEND ADD 921932844 0 0 1 0 1.417 00 2014-12-22 2014-12-24 2014-12-29 2014-12-18 0 2014-12-19 ? 0 0004910297 20141219.ifs 2014-12-19 2014-12-20
1392091 1392091 DIVIDEND CHANGE 921932844 0 0 1 0 .744 00 2013-12-20 2013-12-24 2013-12-27 2013-12-18 0 2013-12-18 ? 0 0004692394 20131223.ifs 2013-12-23 2013-12-24
1392092 1392091 DIVIDEND CHANGE 921932844 0 0 1 0 .744 00 2013-12-20 2013-12-24 2013-12-27 2013-12-18 1 2013-12-18 2013-12-23 0 0004692394 20131223.ifs 2013-12-23 2013-12-24
1379149 1379149 DIVIDEND ADD 921932844 0 0 1 0 .744 00 2013-12-20 2013-12-24 2013-12-27 2013-12-18 0 2013-12-18 ? 0 0004692394 20131218.ifs 2013-12-18 2013-12-19
1060339 1060339 DIVIDEND CHANGE 921932844 0 0 1 0 1.079 00 2012-12-24 2012-12-27 2012-12-31 2012-12-20 0 2012-12-20 ? 0 0004490687 20121226.ifs 2012-12-26 2012-12-27
1060340 1060339 DIVIDEND CHANGE 921932844 0 0 1 0 1.079 00 2012-12-24 2012-12-27 2012-12-31 2012-12-20 1 2012-12-20 2012-12-26 0 0004490687 20121226.ifs 2012-12-26 2012-12-27
1051943 1051943 DIVIDEND ADD 921932844 0 0 1 0 1.079 00 2012-12-24 2012-12-27 2012-12-31 2012-12-20 0 2012-12-20 ? 0 0004490687 20121220.ifs 2012-12-20 2012-12-21
738530 738530 DIVIDEND CHANGE 921932844 0 0 1 0 .795 00 2011-12-23 2011-12-28 2011-12-30 2011-12-21 0 2011-12-21 ? 0 0004299166 20111227.ifs 2011-12-27 2011-12-28
738531 738530 DIVIDEND CHANGE 921932844 0 0 1 0 .795 00 2011-12-23 2011-12-28 2011-12-30 2011-12-21 1 2011-12-21 2011-12-27 0 0004299166 20111227.ifs 2011-12-27 2011-12-28
735131 735131 DIVIDEND ADD 921932844 0 0 1 0 .795 00 2011-12-23 2011-12-28 2011-12-30 2011-12-21 0 2011-12-21 ? 0 0004299166 20111221.ifs 2011-12-21 2011-12-22
505052 505052 EQUITY CHANGE 921932844 S&P MIDCAP 400 VALUE FD ETF SHS 0 A 2010-09-09 ? 0 no no no ? 2010-09-09 ? 20110420.ifs 2011-04-20 2011-04-21
505053 505052 EQUITY CHANGE 921932844 S&P MIDCAP 400 VALUE FD ETF SHS 0 A 2010-09-09 ? 1 no no no ? 2011-04-20 ? 20110420.ifs 2011-04-20 2011-04-21
393259 393259 DIVIDEND ADD 921932844 0 0 1 4 .256 00 2010-12-27 2010-12-29 2010-12-31 2010-12-22 0 2010-12-23 ? 0 0004117125 20101223.ifs 2010-12-23 2010-12-24
304266 304266 EQUITY ADD 921932844 NEW ISSUE 0 0 2010-09-09 ? 0 no no no ? ? ? 20100909.ifs 2010-09-09 2010-09-10
304267 304267 EQUITY CHANGE 921932844 NEW ISSUE 0 0 2010-09-09 ? 0 no no no ? ? ? 20100909.ifs 2010-09-09 2010-09-10
304268 304267 EQUITY CHANGE 921932844 S&P MIDCAP 400 VALUE FD ETF SHS N A 2010-09-09 ? 0 no no no ? 2010-09-09 ? 20100909.ifs 2010-09-09 2010-09-10
304269 304269 EXCHANGE ADD 921932844 04 2010-09-09 2010-09-09 IVOV 0 A ? 2010-09-09 20100909.ifs 2010-09-09 2010-09-10
304322 304322 EQUITY CHANGE 921932844 S&P MIDCAP 400 VALUE FD ETF SHS N A 2010-09-09 ? 0 no no no ? 2010-09-09 ? 20100909.ifs 2010-09-09 2010-09-10
304323 304322 EQUITY CHANGE 921932844 S&P MIDCAP 400 VALUE FD ETF SHS 0 A 2010-09-09 ? 0 no no no ? 2010-09-09 ? 20100909.ifs 2010-09-09 2010-09-10


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