PreviousClose and Last functions returning NA

Discussion in 'Troubleshooting' started by Greg Lubushkin, Feb 23, 2018.

PreviousClose and Last functions returning NA

  1. sdm

    sdm New Member

    Joined:
    Nov 6, 2017
    Messages:
    20
    Likes Received:
    2
    Yesterday LastTrade_PriceOnly("PHYZX") was working intermittently, but now it's back to returning NA. This is really frustrating.
     
  2. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,119
    Likes Received:
    10
    Hi, Just made a fix for this

    Kind regards
    Ankur for MarketXLS
     
  3. sdm

    sdm New Member

    Joined:
    Nov 6, 2017
    Messages:
    20
    Likes Received:
    2
    Works for me now, thanks. Let's hope it keeps working.
     
  4. Tim Irvin

    Tim Irvin New Member

    Joined:
    Nov 13, 2017
    Messages:
    8
    Likes Received:
    0
    The mutual fund pricing is getting to the point that the software is unusable. Over half of the tickers return either NA or the wrong price. Having to go through and double check each one defeats the purpose of having the software. When will this be fixed?
     
  5. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,119
    Likes Received:
    10
    Hi Tim,

    We are working with QM for a better solution for this. However, meanwhile, we will push a release over the weekend to resolve this from Monday. Would you mind sending me your list of tickers? And also, the function you are using? You are using =MF_ ones right?

    Thanks
    Ankur
     
  6. Tim Irvin

    Tim Irvin New Member

    Joined:
    Nov 13, 2017
    Messages:
    8
    Likes Received:
    0
    using FUNCTION =MF_Price(Symbol)
    TRBCX Returns $102.90 actual $100.69
    OAKMX Returns $83.79 actual $81.96
    POAGX returns $50.39 actual $49.37
    PCKDX returns $10.30 actual $10.08
    OBIOX returns $26.38 actual $25.94
    FOCPX returns $115.87 actual $113.08
    BUFTX returns $24.73 actual $24.24
    FHKCX returns $37.09 actual $36.47
    FAGIX returns $10.18 actual $10.12
    TPINX returns $11.84 actual $11.80
    PONDX returns $12.16 actual $12.15
    SWPPX returns $40.91 actual $40.05
     
  7. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,119
    Likes Received:
    10
    Ok, Thanks.
     
  8. amboisvert

    amboisvert New Member

    Joined:
    Jan 19, 2017
    Messages:
    9
    Likes Received:
    0
    This is my current (frustrating) experience. As a former software engineer, I do not understand how
    some symbols work fine and other don't. Any idea on when this will finally and permanently be
    resolved?

    =last(xBDJx) = N/A
    =last(xRFIx) = 11.88 (this is correct)
    =last(xBXMXx) = N/A
    =last(xCIIx) = N/A
    =last(xDIAXx) = N/A
    =last(xEOIx) = N/A
    =last(xEOSx) = N/A
    =last(xETBx) = N/A
    =last(xETVx) = 14.19 (this is correct)
    =last(xETWx) = 10.95 (this is correct)
    =last(xETYx) = N/A
    =last(xEXGx) = N/A
    =last(xJCEx) = N/A
    =last(xQQQXx) = 22.18 (this is correct)
    =last(xUTGx) = 29.95 (this is correct)
    =last(xSTKx) = N/A
    =last(xHEQx) = N/A
    =last(xBUIx) = N/A
     
  9. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,119
    Likes Received:
    10
    This will be fixed tonight. Thanks for your patience.

    Kind regards
    Ankur for MarketXLS
     
  10. amboisvert

    amboisvert New Member

    Joined:
    Jan 19, 2017
    Messages:
    9
    Likes Received:
    0
    It seems good now Ankur, thank you !!!!
     
  11. amboisvert

    amboisvert New Member

    Joined:
    Jan 19, 2017
    Messages:
    9
    Likes Received:
    0
    This N/A problem is back, just noticed this morning. Makes my spreadsheet useless.
    One example of many:
    =Last("xbdjx") is returning N/A
     
  12. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,119
    Likes Received:
    10
    Hi, I am checking on it. Please can you message me the symbols for me to investigate?

    Thanks
     
  13. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,119
    Likes Received:
    10
    Ok, I think I have them. I am checking.
     
  14. amboisvert

    amboisvert New Member

    Joined:
    Jan 19, 2017
    Messages:
    9
    Likes Received:
    0
    Symbols known to fail with N/A:

    xBDJx
    xBXMXx
    xCIIx
    xDIAXx
    xEOIx
    xEOSx
    xETBx
    xETYx
    xEXGx
    xJCEx
    xSTKx
    xHEQx
    xBUIx
     
  15. sdm

    sdm New Member

    Joined:
    Nov 6, 2017
    Messages:
    20
    Likes Received:
    2
    And once again we're back to LastTrade_PriceOnly for PIMIX, PHYZX, and VTSAX returning NA...
     
  16. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,119
    Likes Received:
    10
    Hi SDM,

    We will need to use =qm_last for Mutual funds. This will be much more consistent and better data. Please contact me on the support email and I will get the account created.

    Thank You
    Ankur for MarketXLS
     

Share This Page