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
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.
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.
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
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.
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
