Options returning N/A

Discussion in 'Troubleshooting' started by twent2t, Apr 26, 2017.

Options returning N/A

Tags:
  1. twent2t

    twent2t Member

    Joined:
    Feb 14, 2016
    Messages:
    30
    Likes Received:
    4
    All of my options quotes are returning N/A. I have checked the license and it is in place. Any thoughts on how to correct the situation?
     
    marketxls and ajcolejr like this.
  2. ajcolejr

    ajcolejr New Member

    Joined:
    Jul 13, 2016
    Messages:
    9
    Likes Received:
    2
    I have the same problem.
     
    marketxls likes this.
  3. tsphillis

    tsphillis New Member

    Joined:
    Aug 20, 2016
    Messages:
    9
    Likes Received:
    1
    Same here.
     
    marketxls likes this.
  4. dpcooper

    dpcooper New Member

    Joined:
    Mar 16, 2016
    Messages:
    16
    Likes Received:
    8
    Options prices are still not being updated as of 10:04 AM EST 4/26/2017
     
    marketxls likes this.
  5. kam791

    kam791 New Member

    Joined:
    Feb 10, 2016
    Messages:
    9
    Likes Received:
    2
    Ditto. No option info.
     
    marketxls likes this.
  6. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,153
    Likes Received:
    11
    All, this problem is fixed on the development release, it will be released tomorrow morning or later today.

    Thanks for understanding
     
  7. ajcolejr

    ajcolejr New Member

    Joined:
    Jul 13, 2016
    Messages:
    9
    Likes Received:
    2
    I have not updated the version that came out on 3-31-17. I am still using 8.0.0.0 So why would it stop in the middle of the day yesterday?
     
  8. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,153
    Likes Received:
    11
    There was some issue with the data source. We have fixed it now. This new version also has caching built in for performance improvements.
     
  9. dfraser

    dfraser New Member

    Joined:
    May 10, 2016
    Messages:
    20
    Likes Received:
    2
    Same problem for me...
     
  10. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,153
    Likes Received:
    11
    This is now fixed. I will send an email shortly.
     
  11. dfraser

    dfraser New Member

    Joined:
    May 10, 2016
    Messages:
    20
    Likes Received:
    2
    Many thanks. For info the =Option_Bid() function is working but not the =Option_Last_Price() function.
    Cheers Don
     
  12. tsphillis

    tsphillis New Member

    Joined:
    Aug 20, 2016
    Messages:
    9
    Likes Received:
    1
    Still nothing for me.
     
  13. marketxls

    marketxls Administrator
    Staff Member

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

    I have fixed this issue in Version 8.0.0.2, this version is now in controlled limited release. You can download and install it from the link below.

    Can you please give this a go and let me know if this resolves the Bid/Ask issue you were having?



    Many thanks
     
    #13 marketxls, Apr 27, 2017
    Last edited: May 1, 2017
  14. tsphillis

    tsphillis New Member

    Joined:
    Aug 20, 2016
    Messages:
    9
    Likes Received:
    1
    Installed the update.

    Still no bid/ask, last, volume or open interest for options. I did get a popup message as the add-in was loading:

    "Object reference not set to an instance of an object."
     
  15. pranilb

    pranilb New Member

    Joined:
    Feb 2, 2017
    Messages:
    6
    Likes Received:
    0
    I have the same problem no, NA for option prices via the following functions:
    =Option_Bid
    =Option_Last_Price
     
  16. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,153
    Likes Received:
    11
    Please can you give me the option symbol?
     
  17. dfraser

    dfraser New Member

    Joined:
    May 10, 2016
    Messages:
    20
    Likes Received:
    2
    All symbols returning "0" instead of price.
     
  18. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,153
    Likes Received:
    11
  19. dfraser

    dfraser New Member

    Joined:
    May 10, 2016
    Messages:
    20
    Likes Received:
    2
    NA for =Option_Last_Price( )
     
  20. dfraser

    dfraser New Member

    Joined:
    May 10, 2016
    Messages:
    20
    Likes Received:
    2
    =Option_Bid( ) returns 0.00
     

Share This Page