I looked at the TOS interface for a friend and found out that there is a way to get live data to Excel via DDE, but I do not see a way (ThinkScript?) to write historical data from thinkBack out to a .csv file for analysis. Anyone know if it can be done?
Do you have IQFeed? I get historical "last" data for active options in Ninja Trader via IQFeed. Below a chart showing EFA and and the EFA June 58 Call. You can export any data you can chart in Ninja to csv using some of the tools here.
Historical Bid/Ask or full depth for options is something I've seen for sale, but not for free.
Options are not technically supported in Ninja Trader but you can set them up in Instrument Manager if you know the symbol and have a bit of patience.
I have TOS and I never tried to pull any historical data out of it as I didn't think it was supported.
Please register on futures.io to view futures trading content such as post attachment(s), image(s), and screenshot(s).
The following user says Thank You to MXASJ for this post:
Platform: NinjaTrader, MultiCharts, SierraCharts, Ensign, ProphetX and about 50 other commercial apps.
Favorite Futures: Stocks
Posts: 14 since Feb 2010
Thanks: 4 given,
Just to follow up... IQFeed has the same history for options (for currently trading contracts) as it does for other symbols. 120 days of trades which includes Trade price, size, bid and ask price at the time of the trade, and trade time. Intraday n-minute bars include OHLCV going back several years. IQFeed's built in DDE server allows access to the stream, but you will need a 3rd party app or our API to get the historical data. For 3rd party apps, take a look at QCollector, QuoteCore, XLQ or QuoteIN.
The following user says Thank You to DTN IQFeed for this post:
You can't really do it with Thinkscript. But you can save historical options data from Thinkback by clicking through each day for each symbol you need. You can also automate the whole process by downloading some kind of an Autoclicker freeware (there are lots of them) which would click the buttons for you. I did get 2 years' worth of data for RUT this way. But then you have go through your data and find invalid or empty bid/ask prices and fix them. Luckily Thinkorswim's data is pretty neat - there are almost no invalid prices.
The following user says Thank You to GorSvet for this post:
I use a ToS proprietary options calculation (Probability of Touching) and settled on this method of collecting historical data. I process the data with a PHP program to gather my statistics, monitor my trading and do back testing.
For real time data, I attempted to obtain an API (application programmers interface) account but they stopped providing them with the merger with TD Ameritrade. I was further advised that the program would likely be discontinued for retail accounts.
If it is to be, it is up to me.
All I Know About Trading Options I Learned in Flight School