Option Bid should not be identical to stock Bid

Discussion in 'Troubleshooting' started by feiren, Sep 16, 2017.

Option Bid should not be identical to stock Bid

  1. feiren

    feiren New Member

    Sep 15, 2017
    Likes Received:
    First of all, there is no such thing as Option Bid or Ask. There are options call bid/ask and put bid/ask on particular strike price or contract that's in which should not be identical to stock bid/ask.

  2. marketxls

    marketxls Administrator
    Staff Member

    Dec 21, 2015
    Likes Received:
    Hi, Yes,

    That's correct, =Bid will be different if you use a stock symbol or an option symbol. =Option_bid was made just to identify it as a function to get Bid price of an option at a strike price (and to put it in the different section for option pricing). Sometimes, we need to use different code to get the option Bid/Ask to that of Stock Bid/Ask so they are kept separate.

    Please use Option chain feature, in Utilities to get all options for a stock with various strike prices. You should then be able to use =Option_Bid, or just =Bid by referring to Option symbol.

    Let me know if it clarifies.

    Kind regards

Share This Page