Prices not Appearing

Discussion in 'Troubleshooting' started by franap, Jan 20, 2017.

Prices not Appearing

  1. franap

    franap New Member

    Joined:
    Jan 20, 2017
    Messages:
    1
    Likes Received:
    0
    Hello,

    I just opened my spreadsheet and my mutual fund prices are not appearing. This is the formula entered =LastTrade_PriceOnly(C2) with C2 referring to the fund symbol. The cell just returns #VALUE.

     
     
  2. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,157
    Likes Received:
    11
    Hi Fran,

    Please use the =Last function to get the last price of the stock.

    Kind regards
    Ankur
     

Share This Page