#excel

Create an Excel Crypto Portfolio Tracker

The Excel Club@theexcelclub (67)1999d

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

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.

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:

10+ Excel Learn and Earn Activities YOU can do Today

SIGN UP FOR OUR NEWSLETTER TODAY – GET EXCEL TIPS TRICKS AND LEARN AND EARN ACTIVITIES TO YOUR INBOX

Comments · 12

@hivebuzz(74)· 1988d
Congratulations @theexcelclub! You have completed the following achievement on the Hive blockchain and have been rewarded with new badge(s) :

You distributed more than 41000 upvotes.
Your next target is to reach 42000 upvotes.

_{You can view your badges on your board and compare yourself to others in the Ranking} _{If you no longer want to receive notifications, reply to this comment with the word STOP}
@leoplaw(72)· 1991d
What great timing this is Paula! I was recently looking for something like this.

I'm looking forward to the video / article on tracking trades. I have a project that this would be very useful for.

Posted Using LeoFinance ^Beta
@dswigle(78)· 1996d
Thanks! I will take a look in a bit. :))
@gimmetricks1(56)· 1997d
Thanks Paula, its a wonderful tutorial. I am really happy to have stopped by your account. Its really good to see your videos on excel.
@dbooster(79)· 1998d
Very cool. Unfortunately your file is somewhat butchered when imported into Numbers (Mac's spreadsheet app). Numbers doesn't support much outside of basic functions, so I suppose I shouldn't be surprised. Oh well. It's good to watch your video for ideas at any rate, so thanks for posting!
@arrliinn(74)· 1998d
This is neat! Thanks for sharing. Will try this out.
@poshbot(59)· 1998d
https://twitter.com/ProfTAcademy/status/1367779842398240773
@gillianpearce(67)· 1998d
Thanks for this. I've made a note to take a look later. 😊

Posted Using LeoFinance ^Beta
@abh12345(80)· 1998d
Still kicking ass on referrals to Hive @paulag, do you need some help delegating them HP?
@abh12345.leo(54)· 1998d
This looks handy!

Posted Using LeoFinance ^Beta
@abh12345.stem(48)· 1998d
Thanks Paula!
@hivecoffee(64)· 1999d
This is exactly what I was hoping to create for @HiveCoffee, I was imagining something like this yesterday, so that I don't have to manually look up all the prices. I am going to bookmark this to study later. Thank you!!

Posted Using LeoFinance ^Beta