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/AmeritradeAPIwGoogleScripts

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: https://www.patreon.com/Godivarisattic

Other useful resources: How to Use the TD Ameritrade API with Python (https://www.youtube.com/watch?v=qJ94sSyPGBw)

Видео Using Ameritrade's APIs with Google Scripts канала kohjb