In this video I show you the best way to track your Coinbase trades using the Coinbase Advanced Trade API, the google sheets API, and AWS and Google Cloud automations.

This is the most robust spreadsheet I've seen on the internet for tracking your cryptocurrency purchases, cost basis, and profit & loss. Not only because it gives you live price data, but also because of how it automatically pulls in your transaction data every time you buy or sell cryptocurrency on Coinbase, Gemini, and Kraken.

If you want to help building it out for Binance / Binance US dm me on Twitter @rhettre.

🐦 Follow me on Twitter: https://x.com/rhettre
📝 Companion Blog Post: https://www.rhett.blog/track-crypto-2...
🎥 Original sheet video:    • Automatically Track Your Cryptocurren...  
🎥 Learn more about AWS:    • I Built a Crypto Trading Bot with AWS  
👨🏻‍💻 Link to the GitHub gist: https://gist.github.com/rhettre/891f3...
📈 Link to base spreadsheet: https://docs.google.com/spreadsheets/...
☁️ Get Started on Google Cloud: https://console.cloud.google.com
☁️ Get Started on AWS: https://console.aws.amazon.com

Download the Spreadsheet 0:00
Google Cloud Sheets 2:19
Script on AWS 5:20
Connect to Coinbase 8:18
Testing the Script 9:29