Options not updating

Discussion in 'Troubleshooting' started by audreyq, Mar 10, 2016.

Options not updating

  1. audreyq

    audreyq New Member

    Joined:
    Mar 10, 2016
    Messages:
    5
    Likes Received:
    0
    I have a multi-page spreadsheet with formulas that pull in last price for stocks, and option_bid, option_ask, and strike price, for various options. These were working yesterday. Today, all options for all stocks are showing up as '48'. I know that's not correct, and it's not a question of yesterday's prices, everything, bid and ask is showing as 48. Refresh all goes thru it's calculations, but doesn't give back any other info besides 48.
     
  2. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,123
    Likes Received:
    10
    Hi Audrey,

    Thanks for your question. Please can you post one example formula you are using with the symbol?

    Many Thanks
    Ankur
     
  3. audreyq

    audreyq New Member

    Joined:
    Mar 10, 2016
    Messages:
    5
    Likes Received:
    0
    Option_Bid(A17) where A17 is JBLU160318C00023000 (just one example)
    I get this periodically. Some stocks are fine, some calculate to 48
     
  4. jmalcolm001

    jmalcolm001 New Member

    Joined:
    Mar 7, 2016
    Messages:
    22
    Likes Received:
    0
    I see the same thing occasionally with all of my 6 option bid and ask quotes, but it usually corrects itself with another refresh.
     

Share This Page