Create an Excel Crypto Portfolio Tracker
In the video above you will learn how to create this Excel Cryptocurrency Portfolio tracker. This tracker is ideal for holders and hodlers and it will allow you to track all of your coin holdings in one place. With live pricing information collected from Coingecko API, this spreadsheet is easy to keep up to date.
If you don't want to create this tracker yourself, you will find a link below to download the file I have created. You will have to update the data request to include the coins you hold in your portfolio. This is also covered in the video above.
Don't forget, Like Subscribe and Share
Don't forget, Like Subscribe and Share
Excel Crypto Portfolio Tracker Resources
Global Blockchain, Cryptocurrency and Trading Group On Meetups.com.YouTube Video on connecting to Coingecko API Connect Excel to CoinGecko API for Historical OHLC cryptocurrency data
CoinGecko API Coingecko API Documentation.
URL used in the video to get data from Coingecko.
https://api.coingecko.com/api/v3/coins/markets?vs_currency=usd&ids=bitcoin%2Cethereum%2Cbitcoin-cash%2Cbinancecoin%2Clitecoin%2Cpolkadot%2Cchainlink&order=market_cap_desc&per_page=100&page=1&sparkline=false
If you are downloading this Excel Crypto Portfolio Tracker, you will need to update this URL with the coins that you have. Please watch the video for more details.
The part of the URL that needs replacing is
bitcoin%2Cethereum%2Cbitcoin-cash%2Cbinancecoin%2Clitecoin%2Cpolkadot%2Cchainlink
Note how the coin IDs are separated with %2C
Have questions? Please use the Hive-powered comments section below and we will do our best to help you.
Have questions? Please use the Hive-powered comments section below and we will do our best to help you.
Liked this video and resource, then leave a comment and let us know
I would suggest that you sign up directly for your own hive wallet and use this to sign into the comments below. This way all rewards will be paid directly to your wallet within 7 days. You can use this link to sign up now for your Hive wallet
>> GET HIVE WALLET NOW<<
Do you want to start collecting rewards quickly for learning Excel? Then you should try:
