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

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 : 130 119   Update Insititution By Cusips
% Owned by Insititutions: 15.33 % 33.43 %
pricingQuarterAdminPageOn:
2024-03-31 New %
Delete Company From Institution Summary
Change Institution Stuff 'ZERO' for Cusip

the compid is:160359
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
5580408 5580408 DIVIDEND ADD 46138E297 0 0 1 0 .299 00 2024-06-24 2024-06-24 2024-06-28 2024-06-21 0 2024-06-21 ? 0 0006936138 20240621.ifs 2024-06-21 2024-06-22
5517452 5517452 DIVIDEND ADD 46138E297 0 0 1 0 .15473 00 2024-03-18 2024-03-19 2024-03-22 2024-03-15 0 2024-03-15 ? 0 0006890649 20240315.ifs 2024-03-15 2024-03-16
5444687 5444687 DIVIDEND ADD 46138E297 0 0 1 0 .31698 00 2023-12-18 2023-12-19 2023-12-22 2023-12-15 0 2023-12-15 ? 0 0006835591 20231215.ifs 2023-12-15 2023-12-16
5374275 5374275 DIVIDEND ADD 46138E297 0 0 1 0 .29369 00 2023-09-18 2023-09-19 2023-09-22 2023-09-15 0 2023-09-15 ? 0 0006783646 20230915.ifs 2023-09-15 2023-09-16
5313417 5313417 DIVIDEND ADD 46138E297 0 0 1 0 .20406 00 2023-06-20 2023-06-21 2023-06-23 2023-06-16 0 2023-06-16 ? 0 0006740408 20230616.ifs 2023-06-16 2023-06-17
5250543 5250543 DIVIDEND ADD 46138E297 0 0 1 0 .14659 00 2023-03-20 2023-03-21 2023-03-24 2023-03-17 0 2023-03-17 ? 0 0006697025 20230317.ifs 2023-03-17 2023-03-18
5174347 5174347 DIVIDEND ADD 46138E297 0 0 1 0 .09604 00 2022-12-19 2022-12-20 2022-12-23 2022-12-16 0 2022-12-16 ? 0 0006640914 20221216.ifs 2022-12-16 2022-12-17
5099061 5099061 DIVIDEND ADD 46138E297 0 0 1 0 .31356 00 2022-09-19 2022-09-20 2022-09-23 2022-09-16 0 2022-09-16 ? 0 0006584483 20220916.ifs 2022-09-16 2022-09-17
5036168 5036168 DIVIDEND ADD 46138E297 0 0 1 0 .22768 00 2022-06-21 2022-06-22 2022-06-30 2022-06-17 0 2022-06-17 ? 0 0006540355 20220617.ifs 2022-06-17 2022-06-18
4973791 4973791 DIVIDEND ADD 46138E297 0 0 1 0 .15765 00 2022-03-21 2022-03-22 2022-03-31 2022-03-18 0 2022-03-18 ? 0 0006496086 20220318.ifs 2022-03-18 2022-03-19
4900308 4900308 DIVIDEND ADD 46138E297 0 0 1 0 .47078 00 2021-12-20 2021-12-21 2021-12-31 2021-12-17 0 2021-12-17 ? 0 0006435335 20211217.ifs 2021-12-17 2021-12-18
4804640 4804640 DIVIDEND ADD 46138E297 0 0 1 0 .24606 00 2021-09-20 2021-09-21 2021-09-30 2021-09-17 0 2021-09-17 ? 0 0006369141 20210917.ifs 2021-09-17 2021-09-18
4733109 4733109 DIVIDEND ADD 46138E297 0 0 1 0 .19949 00 2021-06-21 2021-06-22 2021-06-30 2021-06-18 0 2021-06-18 ? 0 0006324322 20210618.ifs 2021-06-18 2021-06-19
4657416 4657416 DIVIDEND ADD 46138E297 0 0 1 0 .16108 00 2021-03-22 2021-03-23 2021-03-31 2021-03-19 0 2021-03-19 ? 0 0006279354 20210319.ifs 2021-03-19 2021-03-20
4558720 4558720 DIVIDEND ADD 46138E297 0 0 1 0 .06703 00 2020-12-21 2020-12-22 2020-12-31 2020-12-18 0 2020-12-18 ? 0 0006224238 20201218.ifs 2020-12-18 2020-12-19
4465545 4465545 DIVIDEND ADD 46138E297 0 0 1 0 .20516 00 2020-09-21 2020-09-22 2020-09-30 2020-09-18 0 2020-09-18 ? 0 0006160570 20200918.ifs 2020-09-18 2020-09-19
4395878 4395878 DIVIDEND ADD 46138E297 0 0 1 0 .14611 00 2020-06-22 2020-06-23 2020-06-30 2020-06-19 0 2020-06-19 ? 0 0006115533 20200619.ifs 2020-06-19 2020-06-20
4246389 4246389 DIVIDEND ADD 46138E297 0 0 1 0 .21124 00 2020-03-23 2020-03-24 2020-03-31 2020-03-20 0 2020-03-20 ? 0 0006071543 20200320.ifs 2020-03-20 2020-03-21
4246437 4246437 DIVIDEND ADD 46138E297 0 0 1 0 .21124 00 2020-03-23 2020-03-24 2020-03-31 2020-03-20 0 2020-03-20 ? 0 0006071543 20200320.ifs 2020-03-20 2020-03-21
4106981 4106981 DIVIDEND ADD 46138E297 0 0 1 0 .15449 00 2019-12-23 2019-12-24 2019-12-31 2019-12-20 0 2019-12-20 ? 0 0006019032 20191220.ifs 2019-12-20 2019-12-21
4107848 4107848 DIVIDEND ADD 46138E297 0 0 1 0 .15449 00 2019-12-23 2019-12-24 2019-12-31 2019-12-20 0 2019-12-20 ? 0 0006019032 20191220.ifs 2019-12-20 2019-12-21
4027503 4027503 EQUITY CHANGE 46138E297 S&P EMERGING MKTS LOW VOLATILITY ETF 0 0 2018-06-04 ? 4 no no no 2018-06-04 ? ? 20191126.ifs 2019-11-26 2019-11-27
4027505 4027504 EQUITY CHANGE 46138E297 S&P EMERGING MKTS LOW VOLATILITY ETF 0 A 2018-06-04 ? 4 no no no 2018-06-04 2019-11-26 ? 20191126.ifs 2019-11-26 2019-11-27
4027506 4027506 EQUITY CHANGE 46138E297 S&P EMERGING MKTS LOW VOLATILITY ETF 0 0 2018-06-04 ? 4 no no no 2018-06-04 ? ? 20191126.ifs 2019-11-26 2019-11-27
4027508 4027507 EQUITY CHANGE 46138E297 S&P EMERGING MKTS LOW VOLATILITY ETF 0 A 2018-06-04 ? 4 no no no 2018-06-04 2019-11-26 ? 20191126.ifs 2019-11-26 2019-11-27
3931245 3931245 DIVIDEND ADD 46138E297 0 0 1 0 .33143 00 2019-09-23 2019-09-24 2019-09-30 2019-09-20 0 2019-09-20 ? 0 0005948207 20190920.ifs 2019-09-20 2019-09-21
3931413 3931413 DIVIDEND ADD 46138E297 0 0 1 0 .33143 00 2019-09-23 2019-09-24 2019-09-30 2019-09-20 0 2019-09-20 ? 0 0005948207 20190920.ifs 2019-09-20 2019-09-21
3793215 3793215 DIVIDEND ADD 46138E297 0 0 1 0 .22353 00 2019-06-24 2019-06-25 2019-06-28 2019-06-21 0 2019-06-21 ? 0 0005902316 20190621.ifs 2019-06-21 2019-06-22
3793218 3793218 DIVIDEND ADD 46138E297 0 0 1 0 .22353 00 2019-06-24 2019-06-25 2019-06-28 2019-06-21 0 2019-06-21 ? 0 0005902316 20190621.ifs 2019-06-21 2019-06-22
3629806 3629806 EQUITY CHANGE 46138E297 S&P EMERGING MKTS LOW VOLATILITY ETF 0 0 2018-06-04 ? 0 no no no 2018-06-04 ? ? 20190315.ifs 2019-03-15 2019-03-16
3629808 3629807 EQUITY CHANGE 46138E297 S&P EMERGING MKTS LOW VOLATILITY ETF 0 0 2018-06-04 ? 4 no no no 2018-06-04 ? ? 20190315.ifs 2019-03-15 2019-03-16
3629811 3629811 EQUITY CHANGE 46138E297 S&P EMERGING MKTS LOW VOLATILITY ETF 0 0 2018-06-04 ? 0 no no no 2018-06-04 ? ? 20190315.ifs 2019-03-15 2019-03-16
3629813 3629812 EQUITY CHANGE 46138E297 S&P EMERGING MKTS LOW VOLATILITY ETF 0 0 2018-06-04 ? 4 no no no 2018-06-04 ? ? 20190315.ifs 2019-03-15 2019-03-16
3633453 3633453 DIVIDEND ADD 46138E297 0 0 1 0 .04489 00 2019-03-18 2019-03-19 2019-03-29 2019-03-15 0 2019-03-15 ? 0 0005853375 20190315.ifs 2019-03-15 2019-03-16
3633468 3633468 DIVIDEND ADD 46138E297 0 0 1 0 .04489 00 2019-03-18 2019-03-19 2019-03-29 2019-03-15 0 2019-03-15 ? 0 0005853375 20190315.ifs 2019-03-15 2019-03-16
3489702 3489702 DIVIDEND ADD 46138E297 0 0 1 0 .51516 00 2018-12-24 2018-12-26 2018-12-31 2018-12-21 0 2018-12-21 ? 0 0005803459 20181221.ifs 2018-12-21 2018-12-22
3489705 3489705 DIVIDEND ADD 46138E297 0 0 1 0 .51516 00 2018-12-24 2018-12-26 2018-12-31 2018-12-21 0 2018-12-21 ? 0 0005803459 20181221.ifs 2018-12-21 2018-12-22
3297026 3297026 DIVIDEND CHANGE 46138E297 0 0 1 0 .95319 00 2018-09-24 2018-09-25 2018-09-28 2018-09-21 0 2018-09-21 ? 0 0005727206 20180924.ifs 2018-09-24 2018-09-25
3297027 3297026 DIVIDEND CHANGE 46138E297 0 0 1 0 .56401 00 2018-09-24 2018-09-25 2018-09-28 2018-09-21 1 2018-09-21 2018-09-24 0 0005727206 20180924.ifs 2018-09-24 2018-09-25
3297028 3297028 DIVIDEND CHANGE 46138E297 0 0 1 0 .95319 00 2018-09-24 2018-09-25 2018-09-28 2018-09-21 0 2018-09-21 ? 0 0005727206 20180924.ifs 2018-09-24 2018-09-25
3297030 3297029 DIVIDEND CHANGE 46138E297 0 0 1 0 .56401 00 2018-09-24 2018-09-25 2018-09-28 2018-09-21 1 2018-09-21 2018-09-24 0 0005727206 20180924.ifs 2018-09-24 2018-09-25
3294373 3294373 DIVIDEND ADD 46138E297 0 0 1 0 .95319 00 2018-09-24 2018-09-25 2018-09-28 2018-09-21 0 2018-09-21 ? 0 0005727206 20180921.ifs 2018-09-21 2018-09-22
3294380 3294380 DIVIDEND ADD 46138E297 0 0 1 0 .95319 00 2018-09-24 2018-09-25 2018-09-28 2018-09-21 0 2018-09-21 ? 0 0005727206 20180921.ifs 2018-09-21 2018-09-22
3141854 3141854 DIVIDEND ADD 46138E297 0 0 1 0 .15032 00 2018-06-18 2018-06-19 2018-06-29 2018-06-15 0 2018-06-15 ? 0 0005676097 20180615.ifs 2018-06-15 2018-06-16
3141891 3141891 DIVIDEND ADD 46138E297 0 0 1 0 .15032 00 2018-06-18 2018-06-19 2018-06-29 2018-06-15 0 2018-06-15 ? 0 0005676097 20180615.ifs 2018-06-15 2018-06-16
3125917 3125917 EQUITY ADD 46138E297 S&P EMERGING MKTS LOW VOLATILITY ETF N 0 2018-06-04 ? 0 no no no 2018-06-04 ? ? 20180604.ifs 2018-06-04 2018-06-05
3125923 3125923 EXCHANGE ADD 46138E297 04 2018-06-04 2018-06-04 EELV 0 0 2018-06-04 ? 20180604.ifs 2018-06-04 2018-06-05
3125926 3125926 EQUITY ADD 46138E297 S&P EMERGING MKTS LOW VOLATILITY ETF N 0 2018-06-04 ? 0 no no no 2018-06-04 ? ? 20180604.ifs 2018-06-04 2018-06-05
3125932 3125932 EXCHANGE ADD 46138E297 04 2018-06-04 2018-06-04 EELV 0 0 2018-06-04 ? 20180604.ifs 2018-06-04 2018-06-05
3128168 3128168 EQUITY CHANGE 46138E297 S&P EMERGING MKTS LOW VOLATILITY ETF N 0 2018-06-04 ? 0 no no no 2018-06-04 ? ? 20180604.ifs 2018-06-04 2018-06-05
3128170 3128169 EQUITY CHANGE 46138E297 S&P EMERGING MKTS LOW VOLATILITY ETF 0 0 2018-06-04 ? 0 no no no 2018-06-04 ? ? 20180604.ifs 2018-06-04 2018-06-05
3128256 3128256 EQUITY CHANGE 46138E297 S&P EMERGING MKTS LOW VOLATILITY ETF N 0 2018-06-04 ? 0 no no no 2018-06-04 ? ? 20180604.ifs 2018-06-04 2018-06-05
3128257 3128256 EQUITY CHANGE 46138E297 S&P EMERGING MKTS LOW VOLATILITY ETF 0 0 2018-06-04 ? 0 no no no 2018-06-04 ? ? 20180604.ifs 2018-06-04 2018-06-05


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