Real Time Data (RTD) Exported Live to Excel Spreadsheet
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.
Would you like to learn how to master the chart settings on Thinkorswim? Click here for our 3 part series: Thinkorswim Chart Settings Tutorial
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.
IN the RTD function bar, their are inputs labled ‘topic1’, ‘topic2’, etc. This is where you place the data you are trying to retrieve (‘last price’, ‘Mark’, etc.). Is there a list of topic codes for this function that will work with thinkorswim?
Not sure I follow. But on Thinkorswim, in the same location you export the live feed to Microsoft Excel, you will find another menu option “Help on data export”. This would be the only source of additional information available.
That’s exactly what I was looking for (help on data export). That is the list of topic codes I wanted to reference. thanks.
Thank you for the information. The location of “Help on data export” is on the Trade / All Products tab. then go to far right click on the 3 bars and highlight “Export”. You will see it there.
My question is what is “NAME” for? It certainly doesn’t work for Tickers. I have to use “DESCRIPTION”.
I have no idea. You will have to contact TD Ameritrade support to answer that question.
If you explore the following web page especially “constants” and “operators” I think that you will find what you are looking for: https://tlc.thinkorswim.com/center/reference/thinkScript
Also when you are doing that select three or four uncommon words and goggle that combination for different presentations.
I don’t think that is what DW is looking for. He is asking about the formulas in the Excel spreadsheet. He is wondering if there is any documentation on which codes are available when building custom formulas in the Excel spreadsheet when using the RTD() function for reading live market data directly from Thinkorswim. The link you provided has to do with writing custom chart studies and indicators. Totally different tool.
Hi Pete! I am using WPS Office Excel Spreadsheet to download RTD from Thinkorswim. Everything works fine except, when the live data begins the following morning, all of my RTD data is static until I refresh each entry on my spreadsheet by retyping one of the letters in the cell. Is this normal? I was hoping it would just start up again automatically each morning.
It’s been a very long time since I have used this feature so I am not certain if anything has changed. I can only tell you that at the time I published this video the saved spreadsheet worked just fine on startup. No need to jump through extra hoops. FYI, I have never heard of “WPS Office Excel”. Is that a knock-off version of Microsoft Excel? If so, I would suspect that to be a problem.
I need some help, I have thinkorswim connected but I can’t get the formula correct to produce what I need in the excel spreadsheet, any help would be greatly appreciated.
I suggest you check our Q&A Forum by searching for the term “RTD”. You will find most of the solutions for this posted to the Chart Studies topic.
Thank You, I have searched feverishly and found nothging that can help me so far
Then you should consider posting a new request to the Q&A Forum.
Thx, is there away to attach an excel spreadsheet that I am working on as an example, when I do so?
Sorry but Excel file types are not supported at this time. The forum on this site is geared solely towards trading platforms and Excel spreadsheets are not a direct component of any trading platform.
Hi. I am getting the live data – thanks for the help!
And do you know if there a way using RTD to read, lets say Volume for an equity every 30 minutes during regular trading hours? So basically I would like to have a cell for each 30 minute increment so I can save it.
I do not know of anyway this can be accomplished using the standard tools available for Thinkorswim and Excel.