Bitcoin Forum

Alternate cryptocurrencies => Altcoin Discussion => Topic started by: grazeppelin on September 26, 2019, 05:00:10 AM



Title: Track your crypto portfolio using excel easy!
Post by: grazeppelin on September 26, 2019, 05:00:10 AM
Hello everyone, today I will share with you my newest creation , a cryptocurrency tracking excel sheet to track your investments that draws prices from coinmarketcap.com

Google Drive:

https://drive.google.com/file/d/1XNaJ-Ouizb24cHMNjAym9byyjeEynync/view

pass: crypto123

How to use:

Download and open the excel sheet , accept the notifications , input your portfolio , click update

I hope you will enjoy this , consider donating if you like it , have a nice day!

EDIT: Download the XLS from the google drive link then run it so the script to update prices works!


Title: Re: Track your crypto portfolio using excel easy!
Post by: Davian144 on September 26, 2019, 05:15:41 AM
Incredibly, this can help those who like to invest in crypto, and because I rarely invest in crypto, but I'm also interested in trying it out, although it's not very important for me personally, because basically I'm not an investor in crypto.


Title: Re: Track your crypto portfolio using excel easy!
Post by: JeffBrad12 on September 26, 2019, 06:35:31 AM
It's easy to use it and i appreciated. But, im willing to ask you about have you ever tried to use a mobile portfolios app? It's the easiest way to track our portfolios anytime consider about the fact that when we wanna access excel and that needs a personal computer (maybe you can access it through your phone but it's complicated)
But it's good enough and good job.


Title: Re: Track your crypto portfolio using excel easy!
Post by: jessyj48 on September 26, 2019, 07:02:54 AM
Hello everyone, today I will share with you my newest creation , a cryptocurrency tracking excel sheet to track your investments that draws prices from coinmarketcap.com

Google Drive:

https://drive.google.com/file/d/1XNaJ-Ouizb24cHMNjAym9byyjeEynync/view?usp=sharing

pass: crypto123

How to use:

Download and open the excel sheet , accept the notifications , input your portfolio , click update

I hope you will enjoy this , consider donating if you like it , have a nice day!
Nice but still very new,you should consider getting that on playstore and ios market for better awareness, i am better off with blockfolio app because apart from price monitoring you will always get news and updates that are base on the coins and token you are tracking


Title: Re: Track your crypto portfolio using excel easy!
Post by: 1982dre on September 26, 2019, 07:05:40 AM
Hello everyone, today I will share with you my newest creation , a cryptocurrency tracking excel sheet to track your investments that draws prices from coinmarketcap.com

Google Drive:

https://drive.google.com/file/d/1XNaJ-Ouizb24cHMNjAym9byyjeEynync/view?usp=sharing

pass: crypto123

How to use:

Download and open the excel sheet , accept the notifications , input your portfolio , click update

I hope you will enjoy this , consider donating if you like it , have a nice day!
Nice but still very new,you should consider getting that on playstore and ios market for better awareness, i am better off with blockfolio app because apart from price monitoring you will always get news and updates that are base on the coins and token you are tracking

the excel looks nice but as you say blockfolio is way more easier. Used it for a few years now and still happy with it.

But for some users this worksheet could be very helpful


Title: Re: Track your crypto portfolio using excel easy!
Post by: Godstrength on September 26, 2019, 07:08:28 AM
Great share though and integration. Maybe what it lacks now or what the users will long for is a beautiful UI. But still, amazing things like this should be rewarded similar to what other projects do, rewarding crypto (https://www.coincurb.com/news/apm-coin-rewards-and-payment-platform/?utm_source=lx) to their loyal shoppers. You can anyways receive tips and crypto if someone is super generous here, lol.

What I use now is the new CMC app for portfolio tracking, same thing with blockfolio where it shows news/updates basing on the variety of coins that you own. But I just like CMC's more since that's what I've been used to for a while now.


Title: Re: Track your crypto portfolio using excel easy!
Post by: Bitbtc8 on September 26, 2019, 07:12:30 AM
Blockfolio is the best to me and comparing blockfolio with this app i will still choose blockfolio because its still very new and i don't trust new apps easily and secondly blockfolio has better popularity, news updates too, your tracking app still needs lot of work and fixes


Title: Re: Track your crypto portfolio using excel easy!
Post by: knuckey on September 26, 2019, 08:43:47 AM
Blockfolio is the best to me and comparing blockfolio with this app i will still choose blockfolio because its still very new and i don't trust new apps easily and secondly blockfolio has better popularity, news updates too, your tracking app still needs lot of work and fixes
this is not an application for smart phones, but this is a creation of OP that uses excel to track a portfolio and OP creations are only used on computers. do you know excel? from microsoft?


Title: Re: Track your crypto portfolio using excel easy!
Post by: Crypt0BHunter on September 26, 2019, 08:46:42 AM
There are a lot of portfolio trackers apps on iOS Android and PC, me personally using Delta, it has a backup function and PC/Android version using it both.


Title: Re: Track your crypto portfolio using excel easy!
Post by: Onuohakk on September 26, 2019, 09:13:20 AM
Hello everyone, today I will share with you my newest creation , a cryptocurrency tracking excel sheet to track your investments that draws prices from coinmarketcap.com

Google Drive:

https://drive.google.com/file/d/1XNaJ-Ouizb24cHMNjAym9byyjeEynync/view?usp=sharing

pass: crypto123

How to use:

Download and open the excel sheet , accept the notifications , input your portfolio , click update

I hope you will enjoy this , consider donating if you like it , have a nice day!
Nice but still very new,you should consider getting that on playstore and ios market for better awareness, i am better off with blockfolio app because apart from price monitoring you will always get news and updates that are base on the coins and token you are tracking

the excel looks nice but as you say blockfolio is way more easier. Used it for a few years now and still happy with it.

But for some users this worksheet could be very helpful
He just created his own excel newly, we should all try and support him by downloading it, to see how it works than comparing it with another existing one. You never can tell, it might be more easier and better than other excel


Title: Re: Track your crypto portfolio using excel easy!
Post by: goto22 on September 26, 2019, 09:41:24 AM
Hello everyone, today I will share with you my newest creation , a cryptocurrency tracking excel sheet to track your investments that draws prices from coinmarketcap.com

Google Drive:

https://drive.google.com/file/d/1XNaJ-Ouizb24cHMNjAym9byyjeEynync/view?usp=sharing

pass: crypto123

How to use:

Download and open the excel sheet , accept the notifications , input your portfolio , click update

I hope you will enjoy this , consider donating if you like it , have a nice day!

It looks great, it could definitely be useful for someone new in crypto. Thanks for sharing.


Title: Re: Track your crypto portfolio using excel easy!
Post by: mendra_2009 on September 26, 2019, 10:21:46 AM
Ok, this is good I really appreciate the OP for making this. But, since it is crypto portfolio tracker and seems is works offline, Looks like we should update the actual price of each token/coin we hold manually.
I think that's quite troublesome for me because it takes time to update the sheet. Would be awesome (but seems is too difficult ;D) if you can make this works online and then can update the price automatically.


Title: Re: Track your crypto portfolio using excel easy!
Post by: vanya.pronin.1983 on September 26, 2019, 10:33:49 AM
Why not to use Blackfolio or any other application that tracks your investment in real time? It works great, is accessible on mobile devices and is much easier to interact with. I do not see any point in using excel instead of a regular app.


Title: Re: Track your crypto portfolio using excel easy!
Post by: grazeppelin on September 26, 2019, 12:40:55 PM
Posted an edit with some instructions


Title: Re: Track your crypto portfolio using excel easy!
Post by: Decksperiment on September 26, 2019, 01:15:46 PM
Why not to use Blackfolio or any other application that tracks your investment in real time? It works great, is accessible on mobile devices and is much easier to interact with. I do not see any point in using excel instead of a regular app.

Blockfolio is indeed a great app to track your crypto portfolio but I would like  to mention also the Delta app as an alternative which I personally prefer because it has its own unique features which I find attractive - https://play.google.com/store/apps/details?id=io.getdelta.android&hl=en  . These two apps should suffice our own crypto portfolio tracking needs and its up to us what we will choose.


Title: Re: Track your crypto portfolio using excel easy!
Post by: grazeppelin on September 26, 2019, 01:17:40 PM
Why not to use Blackfolio or any other application that tracks your investment in real time? It works great, is accessible on mobile devices and is much easier to interact with. I do not see any point in using excel instead of a regular app.

Blockfolio is indeed a great app to track your crypto portfolio but I would like  to mention also the Delta app as an alternative which I personally prefer because it has its own unique features which I find attractive - https://play.google.com/store/apps/details?id=io.getdelta.android&hl=en  . These two apps should suffice our own crypto portfolio tracking needs and its up to us what we will choose.

I personally do not use phone apps, I like the concrete view of an excel sheet that I can update and also modify using my own code !


Title: Re: Track your crypto portfolio using excel easy!
Post by: dark08 on September 26, 2019, 01:19:23 PM
Hello everyone, today I will share with you my newest creation , a cryptocurrency tracking excel sheet to track your investments that draws prices from coinmarketcap.com

Google Drive:

https://drive.google.com/file/d/1XNaJ-Ouizb24cHMNjAym9byyjeEynync/view

pass: crypto123

How to use:

Download and open the excel sheet , accept the notifications , input your portfolio , click update

I hope you will enjoy this , consider donating if you like it , have a nice day!

EDIT: Download the XLS from the google drive link then run it so the script to update prices works!

I appreciated your excel work its easy to understand and use now I can track my altcoin porftfolio I'm switching with your excel.
Thank youso much for your hardwork to provide this kind of excel.


Title: Re: Track your crypto portfolio using excel easy!
Post by: grazeppelin on September 26, 2019, 03:56:25 PM
Hello everyone, today I will share with you my newest creation , a cryptocurrency tracking excel sheet to track your investments that draws prices from coinmarketcap.com

Google Drive:

https://drive.google.com/file/d/1XNaJ-Ouizb24cHMNjAym9byyjeEynync/view

pass: crypto123

How to use:

Download and open the excel sheet , accept the notifications , input your portfolio , click update

I hope you will enjoy this , consider donating if you like it , have a nice day!

EDIT: Download the XLS from the google drive link then run it so the script to update prices works!

I appreciated your excel work its easy to understand and use now I can track my altcoin porftfolio I'm switching with your excel.
Thank youso much for your hardwork to provide this kind of excel.



Glad you enjoyed it!


Title: Re: Track your crypto portfolio using excel easy!
Post by: xOdiumNostrumx on September 26, 2019, 06:14:48 PM
Definitely an useful thingy, good job, but that being said, there is a ton of portfolio tracking apps out there with visually attractive UIs and additional functionalities, so I think I will stick with those ones.


Title: Re: Track your crypto portfolio using excel easy!
Post by: beliomir on September 26, 2019, 08:26:53 PM
Thanks, a very good table for a beginner. I use other tools to track my crypto assets. I like programs that work on api