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.
I can add studies to a table on TOS, but when I export to RTD, the cells are blank. Do you know if there is a way to get this info?
Thanks for this great video.
Hmmm…Upon a closer look, in TOS I have the “custom expression subscription limit exceeded” in the thinkscript columns. I only have one column with 10 stocks, so I don’t know why I have that error. I don’t know if my RTD function would show numbers in Excel if that error were not present.
Only thing that occurs to me is you might have another watchlist open somewhere on the platform that is using all your available custom quote resources.
Hi great video, super simple to understand. What I am having trouble is how to execute a trade once the excel criteria are met? Then of course how to manage said trade. Any thoughts? Thanks in advance good trading to you!
That would require a data connection from Excel to the TD Ameritrade API. Which is not an item we cover at this time.
what is the frequency of Open interest data in hinkorswim or any platform during live market?
You will need to contact TD Ameritrade for that information.
I just spoke with someone at Think or Swim and they had no idea what RTD even was. Is there a list of Field definitions available and can you save that Excel Spreadsheet and have it link back to Think or Swim every time you open it or do you need to do the download to excel every time?
This feature was released in April 2014, according to the release notes for Thinkorswim: https://tlc.thinkorswim.com/center/release/rel-04-26-2014#section_5
Which anyone at TDA support should have been able to locate in less than 30 seconds. (took me about 45 seconds)
The full list of available fields is included right there within the Thinkorswim platform (as explained in the link I just provided). The menu item is Export –>> Help on data export
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.