52 Week High Information Incorrect

Discussion in 'General Questions' started by RobertF, May 11, 2018.

52 Week High Information Incorrect

  1. RobertF

    RobertF New Member

    Joined:
    Apr 30, 2018
    Messages:
    3
    Likes Received:
    0
    Hi,

    I'm using a built-in function to track the 52-week high for various ETFs in my portfolio. For example:

    =x_week_high(A3,"52")

    I've noticed that some of the resulting data is incorrect. For example, IGV shows a 52wh of 145.70. ITA shows a 52wh of 169.61. Is this to be expected? I should add that I have the Formula Mode in my Settings set to Individual Mode.

    Thanks in advance for your reply.
     
  2. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,052
    Likes Received:
    10
    Hi Rob,

    Ok, I am checking on this now

    Kind regards
    Ankur for MarketXLS
     
  3. RobertF

    RobertF New Member

    Joined:
    Apr 30, 2018
    Messages:
    3
    Likes Received:
    0
    Ankur, any news on why those two ETF tickers' 52-week highs aren't updating? MarketXLS won't meet my needs if it's unable to provide accurate daily prices. Thanks very much.
     
  4. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,052
    Likes Received:
    10
    Hi Rob,

    The individual mode is fine for this.
    Sorry for the delay in checking this. I will check it tonight and come back. Just to confirm do you mean iShares North American Tech-Software ETF? If yes than the number looks a bit low, i agree and I am checking on it.

    Thanks
    Ankur
     
  5. RobertF

    RobertF New Member

    Joined:
    Apr 30, 2018
    Messages:
    3
    Likes Received:
    0
    Hi Ankur,

    Yes, you're correct. IGV is the iShares N. American Tech Software Index ETF and ITA is the iShares Dow Jones U.S. Aerospace & Defense ETF. Thank you!
     

Share This Page