Track your cryptocurrency portfolio in an Excel Spreadsheet, with live pricing data
Visit the website and Download the workbook
******New**********
We have created a new and improved Cryptocurrency tracker and exit strategy/profit-taking worksheet. This one will allow for multiple purchases and sales and uses an average dollar cost.
In this video, you will learn to create this Excel Spreadsheet to track the value of your cryptocurrency holdings. This spreadsheet is perfect for holders and hodlers. For this example, I have used well-known coins such as Bitcoin, Litecoin & Cardano to name just a few, but with a few tweaks of the data connection and API call (to coingecko API) and you can get the pricing information for almost any coin or token.
Tracking your holding portfolio all in one place, one familiar spreadsheet make it easy to keep an eye on the important values, without having to log into different wallets or exchanges.
All the links can be found on the website. You can also download this workbook and amend it for your own portfolio. Instructions on how to amend the file can be found in the video.
****Global Blockchain, Cryptocurrency, and Trading Meetup Group******
Awesome vídeo and teaching!! Tks for dedicating your talent to educate the crypto community.
I’ll have to watch the vid a couple of times … cause I’m rusted in Excel.
Regards
Thanks for the video
At the bridge sipping some jo bags are packed looking to pick up the citizen. whatsdown for o/s passports
I’m very Hyped and In this Project: bitcoin Games and Dev Squad Community! I think They are gonna Rock!
I don’t know. Because I want to used $10,000 to start my trade with him
This is really helpful for my situation!! Thanks guys, I will try him but do you know how much is okay for a start let me know if I can do this.
I met Expert Adamos Nicktrader year for the first time at a Conference in London, I invented €75,000 and traded in one month making close to €200,000
Hi Paula, thanks for the great content. Just 1 question: what should I do if I want to connect to all coins’ data? I tried leaving the “ids” blank but it only resulted in top 100 coins
I have the same question! Thanks for asking. If anyone know it would be of a lot of help.
Thanks for the great video! One question @Paula, or anyone else… How is it possible to include older, backdated purchases/investments? Trying to create a tracker sheet of coins I have collected over a period of time (same coins, different purchase dates & prices). Do you have a video on this topic? Thanks in advance!! Would be very helpful ❤️
Let us know if u find anything you’re looking for. currently need something like that as well
Can’t wait for the daily trade spreadsheet. Love your work!
Great video. I reproduced everything following you step by step. Thank you very much and keep on doing this great work 🙂
Hi Paula, thanks for sharing this knowledge. Your Excel skills are very impressive. Unfortunately it seem there are are several broken links on the website. Would love to be able to download this spreadsheet
@Paula Guilfoyle Fantastic! I joined your crypto club too. Looking forward to being involved. Thanks again.
Yes, you are right. sorry, there is a problem with the blog post right now, please try https://theexcelclub.newzenler.com/f/crypto-tracker-for-holders
What a great video. Thanks very much to have the time to explain us how to do that.
Because I’ve added multiple times to my individual coin balances, having an amount purchased column doesn’t really do it for me. And so, since I also buy through multiple exchanges, I keep a separate table to track the overall money moved into each exchange and change the amounts held per coin within each exchange. I keep track of how much stable coin there is in each exchange as well so I can calculate my overall profits across all exchanges on one spreadsheet.
Have the same problem. Have you found any solutions?
Hey Paula! Love your video. I am new to trading and would love your take on tracking crypto trades in excel.
Thank you Paula for a perfect tracker! I am adding more entries for the same coin, but I would like to see all entries of the same coin accumulated under one bar (label) in the presented charts. Currently, the same coin appears separately in different bars. How could this be done please?
You can do it on this chart idk you need to create another sheet and on that new page set it up like so
Coin | Amount of coin | Invested Amount |
10 20$
-5 -25$
Btc =sum^ =sum^
Only put the btc ticker or what ever coin it is only at the bottom where it adds all the coins or invested amount or what ever coin ticker you are doing then on your main portfolio page under the amount purchased column put in the =vlookup command and select the ticker then the new sheet that you created and then select the column with the ticker and drag to to amount of coin tab to return that data you do the same thing for invested amount if your not sure of =vlookup look it up theres videos. on the new sheet to you can also put in other things such as ur purchased date and like the cost per coin when bought and what ever you want but the main things are Coin Amount of coin and invested amount. hopefully that makes sense!
@Rob Mugford do you have solution ?
@Eugene McIver do you have solution ?
@Jean P do you have solution ?
This is EPIC! Thank you oh so much for walking us through the steps for putting this together.
I just came across your wonderful video
and I really appreciate your kindness ❤️???
I am a beginner and even though I have been watching my favorite YouTube crypto investment teachers for the last 2 years I have never attempted to invest because I am so terribly busy with the chores of life and family so I have missed many opportunities
but I know that I DEFINITELY NEED TO LEARN HOW TO CREATE YOUR SPREADSHEET
in order to keep everything organized and to be able to pay my taxes ??❗️
Hey Paula, Great Tutorial thanks heaps. Would be amazing if you could add api (like from etherscan) functionality for importing all your erc20 coins. Ta Alex
Love this video! I would love love LOVE to see a video on tracking a trading journal; many of them are either so expensive or not feature-rich enough to be worth the time when frequently trading crypto.
Wow, I have a Mac and had to build this on my work computer using MS Excel for Windows. I am now using the file on Mac and it still refershes. Thank you so much, you are awesome. Great file. I would love to see the investor template as well. I now know exactly when I have to sell and stop Hodling. Many Thanks !!!
Excel has just released Power Query for Mac so that is great!
Was searching for something like this ..nicely explained , thank you.
So incredibly helpful, thank you very much for this great video
When adding in an addition new coin I think you left out the “C” as in “%2C” at 28:00. Otherwise, thank you for this great video!
Thank you !
Good call!
Very helpful, especially learning the API. I do hope you’ll follow up with a separate worksheet to track transactions and average cost basis which can feed into the main dashboard “Amount Purchased” and “Total Invested” columns, maybe with the most recent transaction date for that coin feeding into the “Date of Purchase” column. I’ll be working on that myself to make this work for a slow-growing portfolio. I’m using Excel 2013 but I installed Power Query and your instructions translated seamlessly. Using Index-Match in the absence of Xlookup.
@Ahmed Hanafy hello
Hi I am facing an issue creating this sheet because I don’t have Xlookup, could you please clarify how you have created it with the Index-Match