| ♥ 0 |
I have used RTD frequently to fetch price data into my Excel Watchlist, Today I created a Scan in ToS and named the results as a Watchlist which I pasted into the Excel Symbol column, but the price column using =RTD(“tos.rtd”,,”MARK”,TEXT(UPPER(A73),)) is blank. Usually if a problem it would show N/A or NAME?, but here it’s blank. Other symbols not in that scan return list work fine. I shut down ToS and Excel and power cycled my PC but same result. Seems that the process of scanning then porting the Watchlist inside ToS renders those symbols invisible to RTD. Thanks to any with experience in this topic. TD Ameritrade staff and ToS staff have no insights into RTD so have no ideas.
Marked as spam
|
Posted by |
Private answer
I cannot reproduce the results you describe. When I try to apply your formula I get the error message: "#NAME?" and I get that same error regardless whether I apply it to a ticker symbol included in the watchlist or a new ticker symbol I add to the spreadsheet. Marked as spam
 Posted by Pete Hahn (Questions: 37, Answers: 4118) Answered on January 10, 2020 12:08 pm
|
|
|
Private answer
Look up the TEXT Function definition in Excel, I think you are missing the last parameter.
Marked as spam
 Posted by MrBruce (Questions: 0, Answers: 1) Answered on February 13, 2021 2:44 pm
|
