Ameritrade's API department has been non-responsive for the last few months. *Thinkorswim is a chart analysis platform offered by TD Ameritrade: www.tdameritrade.com. We utilize a standardized OAuth 2.0 token-based authentication flow on our API … This combination of the Finance Add-in for Excel plus live data from TD Ameritrade provides a powerful analysis platform for traders. Make cells B2 … Step 3: To keep it all straight in our head, let’s create some headers. No guarantees for any other operating system or any other spreadsheet program.) The new App is now listed under My Apps. Step 12 Press send and get the token code will be in the response tab at the bottom "access_token": " Your token code is here "Copy all info on a note pad. This guide will help you with questions about Authentication and OAuth. (We use Excel 2016 for Windows but this works in Excel 2007, too. Step 13 Go to the TD developer quotes API and paste the Token Code in Authorization on tab 4 Making account-access API requests requires you to grant access to this app. Step 2: After ThinkOrSwim is running, run Excel. Leaving comments below is the best way to help make the content of this site even better. This demo video shows how to download historical data, option chains, balances, orders/ transactions and positions reports in TraderXL for TD Ameritrade Then download Excel-DDE-V2.xls from this Elite Traderâ s "Trading Software" thread: Dynamic Excel DDE link to TOS (ThinkOrSwim) Excel-DDE-V2.xls is near the end of the thread and is an attachment to a Post. The only change for Phase 1 will be the log in request for our existing XML API users. TD Ameritrade is an American online broker based in Omaha, Nebraska, that has grown rapidly through acquisition to become the 746th-largest U.S. firm in 2008. client_id = your td dev app user id. Your credentials are saved for the session only. The spreadsheet will get data from the Thinkorswim Trading Software and put live real-time stock and option quotes into Excel. Any applications on the XML based API not using this system will no longer have access into our API. Please be sure to share this page with your friends and colleagues. Make sure to wait until the new app has been approved before continuing. Here, the app name is td-api-tester, the OAuth 2.0 user ID is ferdinand1 and the callback URL is https://localhost:8443. TD Ameritrade for API developers – Add App form to create new app. You can use the power of Excel with the Hoadley Finance Add-in to look behind market data to gain a much deeper understanding of option … You will be directed to account-access to approve the use of your credentials and then returned to this page. Authentication FAQ. redirect_uri = you local host. TD Ameritrade provides financial services including the trading of Stocks, Futures, Options and Forex. You can revoke these permissions at any time. PS I've tried pretty near everything, including removing the slash, escaping/encoding it, using the "long" CBOE names -- there's no point in guessing here unless you've actually done it. This authentication process must be completed and implemented into your application by January 1, 2020.