Forum Discussion
adriangray
Apr 04, 2020Copper Contributor
RTD
I'm using RTD with TD Ameritrade. I do a daily P/L sheet. When I send my sheet to someone, it reads #NAME?. How do I fix this problem so that they can view the data?
tgo2002a
Feb 23, 2022Copper Contributor
TD Ameritrade RTD requires that the user be logged into the Think or Swim platform and have it running in the background. The RTD formula will return #N/A if there is no Think or Swim connection. If they really need to see this spreadsheet, I think anyone can open an account with $50, or maybe even $0. They would need to download the Think or Swim platform, and I believe they also would need the tos.rtd active application add-in installed in Excel and active.
=RTD("tos.rtd",,Fieldname,Symbol)