Excel Spreadsheet Troubleshooting
I am getting the error message "{"error" : "invalid_grant"}"
You have entered invalid Access and/or Refresh Tokens. You will need to carefully go through the steps again and obtain new tokens. Also make sure that you have a valid Trading Account and Customer Key listed on your Settings tab.
The Get Quotes button is working but nothing else is.
TD Ameritrade does not require the API for stock quotes. Try to buy/sell a stock to see if you have your access tokens configured correctly. If you get an error message, see the steps above.
Can you provide a list of all the fields that are available via the API?