Bitcoin Forum

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!

Even though, you haven't shown any previews, I can guarantee that there is no excel document one could make that will look better then an actual application such as Blockfolio etc. There will always be a lack of features and limitations while working with excel.

To make portfolio by using excel is not so easy task I hope. But if it’s can be done successfully that should be a great achievement.

For better convenience and time relieving
You can simply look up Blockfolio apps of various brands and fixate your tokens there

Excel is probably convenient. Too but long process and time taken too

There are other apps for this purpose available. Also excel will have some limitations too so it will be better to go for the app.

Well, Excel is known to be best. But blockfolio is far more better to track the crypto portfolio. Because there might be some lack of features in Excel while working. It is block folio that will make the document look better.

Well blockfolio seems to be the best and most convenient way to keep track of crypto in my opinion.

That being said i haven't really opened it since the last week, and by the look of thing i dont think i will be opening it any time soon.

There is a lot of applications in mobile for thracking your portfolio. I use Coin Stats on iPhone, using api from exchanges and show profit and losses also all stats like on coinmarketcap 👍

there is a lot of portofolio tracker applications,, and for me its easier
for exapmle blockfolio : because, we just add our crypto there, and its depends on exchange price not on coinmarketcap,
so, use an app like blockfolio is better and much eaiser my friend

For me, its time consuming if we use the excel type of monitoring, blockfolio offers the simplest way to tract your investments, so why not focus on the easiest ways, well i could not argue your method but ive find it very redundant to monitor and update everyday your excel file. Meanwhile, excel is the safest form of monitoring, compared to digital ways, but its up to you how you can access your portfolio in your best possible ways.

Have a great day

Having excel to do this work is a good advice. However, there are apps available for the people without having the hassle of updating the spared sheet again and again.

"
Wow that’s a great work. I will definitely try this. Hope this will help all of us to track our work and also do our work easily"

I prefer blockfolio mostly but when i went home i will check this.

Maybe it is more easy to use. Anyways, thanks for your work.

I've always preferred excel documents to flashy web portfolio.
Excel sheets are flexible and you can customize it as you like it and of all you can view and edit it online (though you don't get the latest price stats).
I've a working custom sheet but I'll too try yours for any inspiration for mine one.

I appreciate your work, but it might be better if you can make it an application. That can be used at any time anywhere for everyone.

excel has very limited functionality. It does not have automatic price loading.

Therefore, you are right 100% better to use Blockfolio and similar applications for smartphones

It's personal preference but as web based portfolio tracker are cross platform and they provide almost all features available for having in an excel sheet for free.
So, it's not worth handling excel sheets where a simple mistake can leave your data broken. Flexibility of customization comes with manual accidents.

That's an interesting post. With this Excel portfolio, it will be easier to track my investments in the market. This is going to keep my calculations easier. Thanks for posting this.

I think using apps is better than doing it in excel. Though, it is a good idea to do such sort of work. It will help a lot. I also bookmarked it with saving the password as well.

It’s will be helpful if it will really work. That’s very helpful creation I hope but there should be some limitation. If it will able to avoid these limitation then it will be more effective.

I just downloaded it and it's pretty simple and well managed I must say. But, to be honest other online portfolio managers not only offer good interface but they are also easy to use through the portable devices like tablets and smartphones whereas excel is not very friendly for using in smartphones. Thanks for sharing though!

This is really good news and it will help the people to do their work very easily. If this excel works as per the plan then it will really help the people and the familiarity of the crypto currency will increase even more.

Actually, there is a lot of applications in mobile for thracking your portfolio. I use Coin Stats, using api from exchanges and show profit and losses also all stats like on coinmarketcap. Any thought?

I personally think that this is interesting that you makes this crypto tracker.
This should be easy to use, we just simply bring the files with us in flashdisk or any other storage, and we can access it everywhere as long as there is ms excel available.

Excel will have some limitations. It will be better to go for something that is more upgraded and will have less hassle. There are apps for this purpose though.

Using this type of excel monitoring will take time, blockfolio offers the simplest way to channel your investment, so why not focus on the easiest way? ive I think it's too much to monitor and update your excel file every day. Meanwhile, excel is the safest form of monitoring, compared to digital methods, but it's up to you how you can access your portfolio in the best possible way.

Maybe this is really a very convenient portfolio, but I would not risk and open a file with the extension * .xlsm on my computer. Inside there may be dangerous macros. Be careful!

Sorry, but it seems to me that nobody will use your table. What for? If the market has a huge number of more convenient applications, for example, Blockfolio, Ethos etc.

should giving us a preview of how the excel works and what's the benefit for using them

Thank you for sharing that but I have seen few days ago something like this to track your stack price and it was a virus fishing programme that will try to steal your money from you ultimately, so be careful.

That’s possible to make a well furnished portfolio by excel but here will be some limitation must. No one can avoid these limitation by excel.

I still prefer to use some exchanger, every single token or coin that I want to trade I can put it in there and it automatically gives me the changes in value that it experiences over time.

Although you haven not exposed any previews. I be able to assurance that there is no excel file one could make that will look better than an actual application as like as Blockfolio etc.

It might work well although it has a good possibilities in your creation. I am appreciating your work. By using this easy excel invention we can track our portfolio. This is a good creation.

Not the best one..
I´ve created another one, together with internet help, that works a bit better.

Will share in next few days, might be will help someone.  ::)