NexusFi: Find Your Edge


Home Menu

 





Exporting Data From ToS into Excel


Discussion in ThinkOrSwim

Updated
      Top Posters
    1. looks_one JTurner77 with 2 posts (0 thanks)
    2. looks_two fourtiwinks with 2 posts (0 thanks)
    3. looks_3 cory with 1 posts (0 thanks)
    4. looks_4 whats1thingnow with 1 posts (0 thanks)
    1. trending_up 22,882 views
    2. thumb_up 0 thanks given
    3. group 5 followers
    1. forum 6 posts
    2. attach_file 0 attachments




 
 

Exporting Data From ToS into Excel

 
JTurner77
Los Angeles, CA
 
Posts: 68 since Dec 2011
Thanks Given: 55
Thanks Received: 31

Hey Guys

I am looking to export futures price data into excel to do some basic examination/frequency distributions of various and relatively simply events.

I am not very technically inclined. Is there an easy way to export open/high/low/close data from ToS or somewhere else into Excel?

I would love to get intraday data as well, but I don't have the first clue as to where you folks on these forums are getting their data to backtest/examine.

Any help is appreciated. Thanks.


Can you help answer these questions
from other members on NexusFi?
MC PL editor upgrade
MultiCharts
REcommedations for programming help
Sierra Chart
About a successful futures trader who didnt know anythin …
Psychology and Money Management
NT7 Indicator Script Troubleshooting - Camarilla Pivots
NinjaTrader
How to apply profiles
Traders Hideout
 
 
 fourtiwinks 
Singapore
 
Experience: Beginner
Posts: 206 since Jun 2011
Thanks Given: 526
Thanks Received: 201

Thanks to @JTurner77 for the query, I would like to know how to import TOS data into Excel as well. Hope it is possible..

 
JTurner77
Los Angeles, CA
 
Posts: 68 since Dec 2011
Thanks Given: 55
Thanks Received: 31


ToS told me that it isn't possible to export historical data from their charts to Excel, just live streaming data.

 
 
cory's Avatar
 cory 
virginia
 
Experience: Intermediate
Platform: ninja
Trading: NQ
Posts: 6,098 since Jun 2009
Thanks Given: 877
Thanks Received: 8,090

time to check out ninjatrader.

 
 fourtiwinks 
Singapore
 
Experience: Beginner
Posts: 206 since Jun 2011
Thanks Given: 526
Thanks Received: 201

Do check out Sierra Chart too. SC has spreadsheet study and you can still stick with TD Ameritrade..

Supported Data and Trading Services - Sierra Chart

 
whats1thingnow
Whistler, BC
 
Posts: 34 since Dec 2015
Thanks Given: 25
Thanks Received: 9


JTurner77 View Post
ToS told me that it isn't possible to export historical data from their charts to Excel, just live streaming data.

wonder if this is still the case

i want to get VIX close price for everyday for last 12 months

 
 NLD1888 
SINGAPORE
 
Experience: Intermediate
Platform: TS, TOS, TW, IB
Broker: TOS, IB, TS, TW
Trading: Options, Stocks, ETFs, Futures
Posts: 30 since Jun 2012
Thanks Given: 13
Thanks Received: 16

Hi all,
Hope it's not too late to respond to this post.
I've found this article posted by someone who indicated it's possible to do so for TOS.
Please see the link.
https://usethinkscript.com/threads/exporting-historical-data-from-thinkorswim-for-external-analysis.507/
I've not verified the method so please do your own due diligence.

Daniel


 



Last Updated on February 10, 2022


© 2024 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 - Privacy Policy - Downloads - Top
no new posts