Option_Ask function suddenly returning N/A for some quotes

Discussion in 'Troubleshooting' started by QuietLion, Jun 16, 2016.

Option_Ask function suddenly returning N/A for some quotes

  1. QuietLion

    QuietLion New Member

    Joined:
    Jun 16, 2016
    Messages:
    1
    Likes Received:
    0
    Cells that have returned valid values for weeks are suddenly returning N/A. One example is:

    =Option_Ask("EXPD160819C00049000")

     
     
  2. Parkd2

    Parkd2 New Member

    Joined:
    Feb 11, 2016
    Messages:
    10
    Likes Received:
    0
    It seams that all option pricing is N/A after hours.  This is real frustrating 2 days before expiration when I'm trying to decide which options to roll and which to let expire!  I see this happening a lot - perhaps it is a YAHOO thing- but this wasn't nearly the problem before the last major upgrade that "pushed" a subscription service.

    It MUST be fixed if this is to be a useful product.  I have had to go back to my old method of looking at individual options and option charts on my broker's site.  :-(
     
  3. Parkd2

    Parkd2 New Member

    Joined:
    Feb 11, 2016
    Messages:
    10
    Likes Received:
    0
    I want to say that this is an AWESOME product that I would recommend to anyone so if my last post sounded negative  I hope this clears that up.  However, it could be much better for us option traders if the data was available on a more consistent basis.   I don't need real time,  I'd just like closing prices after hours when I do most of my trading.
     
  4. marketxls

    marketxls Administrator
    Staff Member

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

    We are working on this and will suggest a resolution in upcoming version.

    Kind regards

    Ankur for MarketXLS
     

Share This Page