NexusFi: Find Your Edge


Home Menu

 





ThinkorSwim Thinkback Excel


Discussion in ThinkOrSwim

Updated
    1. trending_up 5,249 views
    2. thumb_up 2 thanks given
    3. group 2 followers
    1. forum 1 posts
    2. attach_file 0 attachments




 
Search this Thread
  #1 (permalink)
 quantarb 
Wayne, NJ USA
 
Experience: Intermediate
Platform: Multicharts, Deltix DCS
Broker: Interactive Brokers/IQ Feed
Trading: ETF Options
Posts: 41 since Oct 2012
Thanks Given: 7
Thanks Received: 38

Hi, I found out that thinkorswim has historical options data and you can do manual backtesting for options strategies. I was thinking if I am able to pull historical options data from thinkorswim thinkback into Excel.

I want to convert some of my stock backtests into options backtests to see how they would have performed using options instead of stocks. Ideally, I would feed the thinkorswim the underlying option, expiration date, strike, and the date I made the trade and thinkorswim returns the closing data for that day. Anyone have any idea how to do this?


Started this thread Reply With Quote

Can you help answer these questions
from other members on NexusFi?
Pakistan Mediator in Tehran as Hormuz Normalization Coll …
Prediction Markets & Event Contracts
Iran Update May 8: Still Reviewing MOU, Demands Reparati …
Traders Hideout
Iran Airspace Collapses 18 Points to 15.5% While Hormuz …
Prediction Markets & Event Contracts
April 2026 Jobs Report: +115k vs +65k Expected
Traders Hideout
Wood Mackenzie Drops $200 Oil Forecast -- Airspace Expir …
Prediction Markets & Event Contracts
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
NexusFi site changelog and issues/problem reporting
15 thanks
Darmok and Jalad at Tanagra
3 thanks
Big Mike in Ecuador
1 thanks
30 Sessions
1 thanks
  #2 (permalink)
kosnarf
Long Beach CA
 
Posts: 4 since Mar 2014
Thanks Given: 0
Thanks Received: 1


quantarb View Post
Hi, I found out that thinkorswim has historical options data and you can do manual backtesting for options strategies. I was thinking if I am able to pull historical options data from thinkorswim thinkback into Excel.

I want to convert some of my stock backtests into options backtests to see how they would have performed using options instead of stocks. Ideally, I would feed the thinkorswim the underlying option, expiration date, strike, and the date I made the trade and thinkorswim returns the closing data for that day. Anyone have any idea how to do this?

RTD is supported. Check the link: https : / / tlc.thinkorswim.com / c enter / release / rel-04-26-2014.html

And scroll to the bottom, be sure to read the instructions, "To see all of the functions supported in exported data, click on the “Data Export Help” option on the Printer menu." Good luck

(I don't have the required 5 post to link URLs)


Reply With Quote
Thanked by:




Last Updated on November 3, 2014


© 2026 NexusFi®, s.a., All Rights Reserved.
Av Ricardo J. Alfaro, Century Tower, Panama City, Panama, Ph: +507 833-9432 (Panama and Intl), +1 888-312-3001 (USA and Canada)
All information is for educational use only and is not investment advice. There is a substantial risk of loss in trading commodity futures, stocks, options and foreign exchange products. Past performance is not indicative of future results.
About Us - Contact Us - Site Rules, Acceptable Use, and Terms and Conditions - Downloads - Top
no new posts