Crypto Currency Balance Template

BEGINNERS & HELP
#1

Good evening everybody,
in case you are interested in an automated spreadsheet that helps you to keep track of your crypto currency portfolio you can download it for free at:

I created it since my portfolio is spread across multiple wallets and I hope it will be helpful for you to.

I’ve just uploaded Version 1.1.1 which will allow you to add exchange trades between crypto currencies to your history and will work with Excel 2010.

Let me know if you have any problems.
Have a nice evening!
Peter

5 Likes
#2

wow wonderful. im checking it out right now

i was working on a portfolio with a friend for a while now myself…

#3

I’m happy to hear that =)
Thanks for the feedback!
Let me know if youre missing something.

#4

Thanks! That is literally the best spreadsheet I have ever seen.

1 Like
#5

Well done @GermanEngineering. I was looking for a macro that gets currency historical/ current price which you seem to have done. However, I ran into trouble in first line of updateExchangeRates. Please help if you get time.

image
image2286×774 159 KB
Screen Shot 2017-10-27 at 22.14.06

Great instructional videos as well. Thank you for the share!

#6

Hey,
Unfortunately, I couldn’t test it on a non german computer or on mac.
I guess he might have trouble comparing the german datetime value in the cell with the current system datetime.
Could you try replacing the whole first line of the method with:

If (DateDiff(“n”, CDate(Worksheets(“Dashboard”).Cells(7, 3)), Now) > 60) Then ’ only update when last update was more than one hour ago

This should explicitly convert the string value from the cell to datetime.

If it still doesn’t work you could try selecting cell C7 on the Dashboard worksheet and press “Ctrl” + “.” to insert the current date and then try to run the macro again.

I would really appreciate if you could let me know if any of this worked!
Have a nice evening
Peter

#7

@GermanEngineering this is a great job, however am struggling to add to history it gives me the Run-time error 13. could it be because am using excel 2007? anyhow I can still enter the history manually and the update exchange works well after ctrl ; thanks for the good work.

#8

@GermanEngineering Recently received your email but the download link does not seem to work. Please advise.

Screenshot_20171028-162954
Screenshot_20171028-162954720×1280 178 KB

#9

Good evening everybody and thank you so much for your feedback!

@traveliando:
It seems like a lot of people are getting the runtime error 13.
I don’t think its a problem of Excel 20xx but probably because he can’t compare the german time string in the cell with a non-german datetime.
I have just uploaded Version 1.1.4 in which i just deleted the if statement.
So long story short this should work now with the new version.

Which brings me to…
@David_Wyness:
I think this is because I update the link in the E-Mail for every new Version of the file that I uploaded.
For now you can just go to my website again and request the latest version again.
But I will try to maybe upload the file to GitHub or something similar next week.
I will also try to make it easier to switch to USD.

1 Like
#11

This version works well now. honestly this is the best free balance sheet i have seen so far.

1 Like
#12

Good morning everybody,
I have just uploaded Version 1.2 of the spreadsheet where you can now easily change your reference currency from EUR to USD/JPY or one of 32 other fiat currencies.

I uploaded a short 3-minute video to YouTube explaining the new feature.

You can download the new Version on my website.
(I also managed to fix the problem @David_Wyness reported. So from now on the download link should always point to the latest Version)

Thank you very much for all of your feedback and have a nice day!
Peter

1 Like
#13

@GermanEngineering Hi Peter. I am still struggling to get a copy of this. I followed the link above and entered my email. This time I did not receive and email with the link (checked spam folder). It could be because I have already entered my email once?

My email is: [email protected] if you can help?

#14

Hey @David_Wyness,
sorry for the struggle!
I’ve sent you an email with the link to the latest version.

1 Like
#15

Good evening everybody =)

Since coinmarketcap has changed their API, I adapted the code of the crypto balance spreadsheet.
You can download the latest version here.

If you missed the last updates, you can find a short explanations of the new features in the following videos:
Version 1.0.0
(Basic instruction on how to use the spreadsheet)

Verion 1.1.0
(Enabled exchange entries between different crypto currencies)

Version 1.2.0
(Allows to change the reference currency from EUR to any of 32 other currencies with only one click)

I wish you good luck with your investing!
Have a nice evening.
Peter

1 Like