Stock Options Chain

Discussion in 'Pre-Sale Questions' started by Bob, May 20, 2017.

Stock Options Chain

  1. Bob

    Bob New Member

    Joined:
    May 20, 2017
    Messages:
    4
    Likes Received:
    0
    Hi:
    I would like to know that the Stock options chain are live data.
    How many expiration days the tool retrieves into excel for the stock Option chains? For example for AAPL I want to get the option chains for the first 6 expiration days in one shot, is it possible?

    Thanks
     
  2. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,087
    Likes Received:
    10
    Hi Bob,

    You get all option chains in one shot

    Kind regards
    Ankur
     
  3. Bob

    Bob New Member

    Joined:
    May 20, 2017
    Messages:
    4
    Likes Received:
    0
    Hi Ankur, Thanks for your answer, I have another question,
    Stocks Options data are EOF (end of day) or streaming data (live data), please let me know,
    Thanks.
     
  4. Bob

    Bob New Member

    Joined:
    May 20, 2017
    Messages:
    4
    Likes Received:
    0
    Hi:

    Hi Ankur:
    Too bad you don't have answer to my question I posted May,20, I am interested in the product.
    I am interested in getting the bundle of the OPTIONS CHAIN of a stock but in REAL TIME,
    for example I will retrieve the complete option chain of AAPL, into Excel and and then the prices
    MUST BE IN REAL TIME (for example the option prices in Excel will change every minute )
    Can your product do that?

    Thanks.
     
  5. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,087
    Likes Received:
    10
    Hi Bob,

    Option chain feature will download for you all the open valid options for a stock with most of the details.

    There are other functions that are available like =Option_Last_Price("OptionSymbol") which will get you the last price of that option. Also there are other functions for options like Bid, Ask etc. The pricing is delayed by 15 mins or so not real time.

    Let me know if this clarifies.

    Kind regards
    Ankur
     
  6. Bob

    Bob New Member

    Joined:
    May 20, 2017
    Messages:
    4
    Likes Received:
    0
    Hi:
    I am looking for real time options price in Excel, The Delayed 15 min options price I can get from Yahoo,
    or any Financial site.

    Thanks.
     
  7. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,087
    Likes Received:
    10
    Hi Bob,

    Real time options are now available in MarketXLS using Barchart's additional addon. Please see the link below...
    Barchart Advanced Option Functions - Optional Addon

    This will get you the Option History, Real time option price, and all the Greeks. It will require a direction subscription from Barchart.

    Kind regards
    Ankur
     

Share This Page