Using Ameritrade's APIs with Google Scripts
Note: This tutorial was created with Google Scripts before v8 (the Rhino version). In the Google Scripts window, click Run | Disable new Apps Script runtime powered by Chrome v8, if you've somehow turned on v8.
Do you use Google Sheets to organise your financial and stock information and are you a member of Ameritrade or ThinkokSwim? If so, did you know that you can access your account info, get live quotes, or even execute trades automatically through Ameritrade? This step-by-step video walks you through the entire process of accessing Ameritrade's powerful APIs using Google Sheets and Google Scripts. It's a long video, created for you to work along on your computer. Here are the main 5 sections you can fast forward to as needed :
1. Overview of Ameritrade API Processes - 0:01:44
2. Authentication Process - 0:11:49
3. Bearer Token Process - 1:11:06
4. Example 1: Obtaining Stock Price - 1:26:26
5. Example 2: Obtaining Option Price - 1:35:52
The final code (includes some embellishments, so it's not exactly the same as the tutorial) is here in my github for your reference if required. https://github.com/kohjb/AmeritradeAP...
If you do have comments, suggestions for improvement, or better ways to create the various functions, please do leave them below.
If you'd like to support my work, I do thank you in advance! Do give me a thumbs up, subscribe, and do visit my Patreon page: / godivarisattic
Other useful resources: How to Use the TD Ameritrade API with Python ( • How to Use the TD Ameritrade API | Part 1 )
On this page of the site you can watch the video online Using Ameritrade's APIs with Google Scripts with a duration of hours minute second in good quality, which was uploaded by the user kohjb 25 February 2020, share the link with friends and acquaintances, this video has already been watched 3,212 times on youtube and it was liked by 68 viewers. Enjoy your viewing!
