Sep 19, 2020 RTD function in Excel. I use the RTD function in Excel and the cell that is being imported from the Stock Broker website (Think or Swim; TD Ameritrade) is bringing in a cell that shows an expected move of a stock. The Execl spreadsheet cell is importing a “+/-” signs in front of a number which is imported using the RTD function. Sep 06, 2009 In regards to your inquiry about DDE, we now support the Microsoft Excel function RTD(Real Time Data) which works in the same way. I could not attach the PDF file. I copied and pasted it. Contact TOS support for a copy. Thinkorswim RTD on thinkorswim thinkorswim has the ability to use the Mircosoft Excel function RTD (Real Time Data.).
Finviz
Hi there,
I am having trouble with the Excel RTD (Real Time Data) function and hope one of you experts can help. With the Think or Swim (TOS) platform running in the background, I open Excel and in cell A1, I enter a stock symbol, say IBM. In B1, I have =RTD('tos.rtd','BID',$A$1) which returns the proper Bid value for IBM stock. Here's the problem: if I change A1 to some other symbol, say MSFT, it will give me the correct MSFT bid, but then if I put IBM back in to A1 it just returns an empty cell. No error message or anything else, just an empty cell. So any symbol will work 1 time only. I have Excel 2010 on a PC. Any advice will be much appreciated.
Thank you!
I am having trouble with the Excel RTD (Real Time Data) function and hope one of you experts can help. With the Think or Swim (TOS) platform running in the background, I open Excel and in cell A1, I enter a stock symbol, say IBM. In B1, I have =RTD('tos.rtd','BID',$A$1) which returns the proper Bid value for IBM stock. Here's the problem: if I change A1 to some other symbol, say MSFT, it will give me the correct MSFT bid, but then if I put IBM back in to A1 it just returns an empty cell. No error message or anything else, just an empty cell. So any symbol will work 1 time only. I have Excel 2010 on a PC. Any advice will be much appreciated.
Thank you!