Price and change inaccuracies

Discussion in 'Troubleshooting' started by nathan464, May 25, 2017.

Price and change inaccuracies

  1. nathan464

    nathan464 New Member

    Joined:
    Mar 25, 2016
    Messages:
    14
    Likes Received:
    0
    I have been detecting problems with Fast_Last_Price returning inaccurate prices (after the close of trading.)
    Usually switching to Last or LastTrade_PriceOnly resolves the issue, but right now AMJ (ticker) is returning an inaccurate price & change.
     
  2. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,153
    Likes Received:
    11
    Hi Nathan,

    Please can you try this?
    =Last("AMJ")

    Seems to be showing right number. Let me know in detail, what you think it should be and what it is coming out to be. Thanks
     
  3. nathan464

    nathan464 New Member

    Joined:
    Mar 25, 2016
    Messages:
    14
    Likes Received:
    0
    LBAI closed yesterday @ 18.95. Last("LBAI") reports 19.00.
    BDGE also off: 33.15 vs. 33.10.
     
    #3 nathan464, Jul 12, 2017
    Last edited: Jul 12, 2017
  4. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,153
    Likes Received:
    11
    Hi Nathan,

    Yes, I am working on it, at the close of the market there is a bit of delay (about 1 minute) in our script, but we are fixing it. Will be sorted today or tomorrow.

    Kind regards
    Ankur
     
  5. nathan464

    nathan464 New Member

    Joined:
    Mar 25, 2016
    Messages:
    14
    Likes Received:
    0
    Thanks. The prices were still incorrect hours after the close.
     
  6. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,153
    Likes Received:
    11
    yes, because our script stopped at before the markets close. I am working on this. Will be sorted shortly
     
  7. nathan464

    nathan464 New Member

    Joined:
    Mar 25, 2016
    Messages:
    14
    Likes Received:
    0
    any update? Last night HSCZ closed at 28.76 per Google Finance and Yahoo Finance. MarketXLS reports 28.765 with Fast_Last_Price. Last() reports 28.58!
     
  8. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,153
    Likes Received:
    11
    Hi Nathan,

    Sorry for the delay, we could not get to this yet. I will see this tonight and update you.

    Kind regards
    Ankur
     
  9. nathan464

    nathan464 New Member

    Joined:
    Mar 25, 2016
    Messages:
    14
    Likes Received:
    0
    Neither prices nor changes seem accurate now for any tickers.
     
  10. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,153
    Likes Received:
    11
    Hi Nathan,

    There is an issue with Quotemedia data, we are working to fix the data n the backend. It will be fixed about 6PM EDT tomorrow.

    Thanks for your patience.

    Kind regards
    Ankur
     
  11. nathan464

    nathan464 New Member

    Joined:
    Mar 25, 2016
    Messages:
    14
    Likes Received:
    0
    This morning change("LGLV") reports +0.2414. Per Google and Yahoo should be -0.92. Fast_Last("LGLV") reports 86.6604. Should be 86.66.
     
  12. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,153
    Likes Received:
    11
    Hi Nathan,

    This could be due to default delay of 15 mins. Can you try =lastpricerealtime?
     
  13. nathan464

    nathan464 New Member

    Joined:
    Mar 25, 2016
    Messages:
    14
    Likes Received:
    0
    Hi.
    How is a 15 minute delay relevant 12 hours after the market closed?
    lastpricerealtime("LGLV") returns 86.660003662100, but this is resolvable by rounding. The real problem is with Change("LGLV").
     
  14. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,153
    Likes Received:
    11
    Ok, yes, thats a good point. Sorry, you are right. I think I know where it is coming from. It seems to be showing the price 15 mins before the markets closed in last session. I thought we fixed this issue. Anyhow, let me look into this and come back shortly.

    lastpricerealtime("LGLV") returns 86.660003662100, but this is resolvable by rounding. The real problem is with Change("LGLV").
     
  15. nathan464

    nathan464 New Member

    Joined:
    Mar 25, 2016
    Messages:
    14
    Likes Received:
    0
    Thanks. But what about Change("LGLV") which is not even close?
     
  16. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,153
    Likes Received:
    11
    Hi Nathan, Change("LGLV") gives me 19% which seems to be correct. What value are you expecting? Thanks
     
  17. nathan464

    nathan464 New Member

    Joined:
    Mar 25, 2016
    Messages:
    14
    Likes Received:
    0
    That's 19 cents which today looks correct.

    As I wrote earlier, for yesterday's close "...change("LGLV") reports +0.2414. Per Google and Yahoo should be -0.92. "
     
  18. nathan464

    nathan464 New Member

    Joined:
    Mar 25, 2016
    Messages:
    14
    Likes Received:
    0
    almost five hours after the close:

    lastrealtime("LGLV")+0 = 86.58499908. Actual is 86.58
    change("LGLV") = +0.1795959500. Actual is -0.08.

    fast_last_price("HSCZ") = 28.688800. Actual is 28.69.
    change(HSCZ") = 0.242000580. Actual is 0.25.
     
  19. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,153
    Likes Received:
    11
    Hi Nathan,

    I will check this today.

    Thanks
    Ankur
     
  20. Greg Resker

    Greg Resker New Member

    Joined:
    Aug 9, 2017
    Messages:
    20
    Likes Received:
    1
    It is 10am, 9/7/2017 and the market has been open 30min. LastPriceRealTime() has not changed from yesterday's close for any of the S&P 500 and Auto-Refresh isn't getting any changes. Thanks.
     

Share This Page