LastPriceRealTime() returns text, not a numerical value

Discussion in 'General Questions' started by Greg Resker, Oct 5, 2017.

LastPriceRealTime() returns text, not a numerical value

  1. Greg Resker

    Greg Resker New Member

    Joined:
    Aug 9, 2017
    Messages:
    20
    Likes Received:
    1
    I have had all sorts of trouble working with this function as I have posted before: does not return today's value until market has been open 30 minutes; value can be as much as 15 minutes delayed; etc. I just discovered that this function does not return a value but rather text. This was confirmed by using the Excel function =isnumber() which returns FALSE for every cell I use LastPriceRealTime() in. It is also returning 9 to 10 decimal places almost all the time which makes no sense. Please correct.
     
  2. marketxls

    marketxls Administrator
    Staff Member

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

    Please can you try this?

    =Roundup(Value(LastPriceRealTime("MSFT")),2)

    Thanks
     

Share This Page