Real Time Data (RTD) Exported Live to Excel Spreadsheet
Thinkorswim RTD Excel
Have you ever wondered how to include real time live data from Thinkorswim platform into a spreadsheet? Once you learn this simple technique, you will be able to use your spreadsheet skills to build a fully customized live snapshot of the market in real time. Even if you don’t know how to use spreadsheets, this tutorial shows how truly simple it is. With even a rudimentary understanding of spreadsheet formulas you can create a spreadsheet which displays your open positions in a way not possible on the Thinkorswim platform alone.
DISCLAIMER: I AM NOT A CERTIFIED FINANCIAL ADVISOR AND NOTHING IN THIS VIDEO OR TEXT IS AN ADVERTISEMENT OR RECOMMENDATION TO BUY OR SELL ANY FINANCIAL INSTRUMENT. NOR IS THIS VIDEO OR TEXT INTENDED TO INSTRUCT YOU ON HOW TO MAKE BUY OR SELL DECISIONS USING ANY OF THESE INDICATORS.
*Thinkorswim is a chart analysis platform offered by TD Ameritrade: www.tdameritrade.com
TD Ameritrade provides financial services including the trading of Stocks, Futures, Options and Forex.
Please be sure to share this page with your friends and colleagues. Leaving comments below is the best way to help make the content of this site even better.
any idea how to show regular trading hour low or high of ES ?
=RTD(“tos.rtd”, , “LOW”, “/ES:XCME”)
is for whole day low, not regular trading hour low
It may be possible to do this with a custom column in a watchlist. The custom column would need to be set to intraday time frame and the code would need to use recursion to capture the high and low between the open and close of the regular session. Too complex to address this here in the comments. Post a request in the Q&A forum where we can provide a more complete solution.
where can I download this excel?
We did not publish the spreadsheet for this video.
Problem solved. I was using a computer at work, so I did not have the administrator password. To begin, right click on the TOS desktop icon and run as administrator. Enter your account # and admin. password, as you normally do. When the TOS program starts, open the trade screen and export your data into an excel spreadsheet. It should work fine.
Fantastic. Thanks so much for taking the time to get back to us with the cause and solution.
Likewise Mr. Hahn. BTW- the data feed does appear to remain active, for the futures market, as well as for regular trading hours.
I’m using windows now, and able to copy and paste data directly into an excel spread sheet. The cells appear as “name” only, and are static. If I create a file, then copy and paste it into excel, the data appears, but remains static. My TOS platform is running.
Try running this while markets are open.
There futures markets are open and my TOS trading platform is running. Does this only work during regular trading hours for equities?
1. Make sure you are using the current version of MS Excel or Apache Open Office. 2. Check for warnings messages requiring you to “enable content” on the spreadsheet. 3. Wait to see if this all starts working when markets open. 4. Contact TDA support for assistance if none of these fix the issue as this is as far as I can take you.