Preferred stock prices incorrect for the past two days.

Discussion in 'Troubleshooting' started by James Meyer, Feb 6, 2020.

Preferred stock prices incorrect for the past two days.

  1. James Meyer

    James Meyer Member

    Joined:
    May 3, 2017
    Messages:
    70
    Likes Received:
    4
    ARR, WFC and TFC have been reporting incorrect prices for the past two days.
     
  2. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,134
    Likes Received:
    10
    Hi James,

    I have checked these and they seem to be okay. Let me know if you see this again. I will check this out.

    Kind Regards
    Ankur for MarketXLS
     
  3. James Meyer

    James Meyer Member

    Joined:
    May 3, 2017
    Messages:
    70
    Likes Received:
    4
    They were correct this AM EST. Interestingly, =Change() values were correct both days, but not the =LastTrade_PriceOnly().
     
  4. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,134
    Likes Received:
    10
    Hi James,

    Please use the =Last function instead.

    Kind Regards
    Ankur for MarketXLS
     

Share This Page