Monday, June 17, 2024

Tag Archives: cryptocurrency portfolio

Track Your Cryptocurrency Portfolio Automatically! [Live Price Data]

In this video I show you how to set up a FREE automated cryptocurrency portfolio tracker using Python Scripts, the google sheets API, the Coinbase Pro API, the Gemini API, and AWS Lambda Functions and EventBridge 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 […]

Read more

Integrate CoinGecko Live Cryptocurrency Prices with Microsoft Excel | Excel Crypto

In this video you will learn how you can integrate live cryptocurrency prices with Microsoft Excel from CoinGecko.com.. The technics and skills will allow you integrate any website data for your any purpose. After watching this video, you will be able to do following: 1) Automatically fetch live prices from Coingecko 2) How to Identify the crypto coins? 3) How to apply conditional formatting? 4) How to use vlookup formula? 5) How to run web query? 6) […]

Read more