Custom watchlist columns not updating using RTD in Excel


Category:
0
0

When i export my watchlist to excel for live data all of the columns export correctly except for the moving average studies columns I added. The numbers are perfect on the TOS watchlist but when i open and paste into excel there is no data for these columns only N/A. Anyone know how to fix this? thanks.

Marked as spam
Posted by (Questions: 1, Answers: 1)
Asked on October 23, 2020 9:08 am
326 views
0
Private answer

I had to update the title of your question because the title you entered did not actually described the problem you are trying to solve. Why is this important? Because we have a very larger number of viewers how are very likely to be searching for this specific solution. Please consider this when posting new questions in the future.

I tested this on my own platform and everything appears to be working correctly. I tested this using a custom column with the following line of code:

plot data = Average(close, 21);

I then added this column to the MarketWatch --> Quotes screen and exported to Excel. I also added this column to a watchlist gadget on the side panel and exported to Excel. In each case the custom column came across as expected. However only the data I exported from MarketWatch --> Quotes displayed current live values. The values from the watchlist gadget were exported as a .CSV file and the values are static.

You did not provide the code you used in your custom watchlist column so I have no way to test your exact issue to see if it is isolated to your own Thinkorswim program or if the problem is systemic (occurs for all users).

Marked as spam
Posted by (Questions: 37, Answers: 4084)
Answered on October 23, 2020 10:19 am
0
Thank you for your quick responds, I will link the 2 files I was using. =RTD("tos.rtd", , "SimpleMovingAvg", "XLF") That is what the formula says in the sma for XLF
( at October 23, 2020 11:00 am)
0
Sorry but that is the "formula" in the Excel spreadsheet, not "...the code you used in your custom watchlist column...". The formula in the Excel spreadsheet is generated automatically and it is NOT the problem so long as you made no changes after pasting the data from Thinkorswim. In the description of your question you made the following statement: "...except for the moving average studies columns I added...". I need to see the code you used to build these "moving average studies columns". That is the only thing that can be broken and is the item I need to test on my side.
( at October 23, 2020 12:56 pm)