Author

Topic: Google spreadsheet for keep track of crypto (Read 254 times)

newbie
Activity: 11
Merit: 1
October 21, 2019, 09:16:09 AM
#11
After few months of research I ended up using this spreadsheet meanwhile I'm compiling mine (have lots of work in it), will share once is finished. Meanwhile this work good for me Account Tracker v1.10- Public

Did you share the spreadsheet?
jr. member
Activity: 35
Merit: 1
After few months of research I ended up using this spreadsheet meanwhile I'm compiling mine (have lots of work in it), will share once is finished. Meanwhile this work good for me Account Tracker v1.10- Public
full member
Activity: 168
Merit: 100
January 21, 2018, 07:26:30 AM
#9
Cool. Lovely that you ask. As such a tool can be great value I will check this site to see if any other users come up with handy tools to use, which are rich in analysis functions etc. 

Where can I find a good google spreadsheet where I can keep track of few cryptos?
Online I found few but all of them miss something that I need and have the other things.

I'd like to have a "portfolio" section, if possible with pie chart. Here to see the gain and losses of my investments.
An history sheet where I can add the trades with the price I bought/sold so it can be used to show gain and losses in the main page.
A sheet or column with the actual value of each coin.
Value of each coin shown in BTC, USD, EUR.


I tried:

All of them are great but while trying to modify to my need, they all gave me some sort of error.
Any input is really appreciated. If you could share your (empty) spreadsheet that would be a good way to improve and personalize ours.

PS. I'm already using blockfolio, I need a google spreadsheet.

update: added links to the spreadsheets
newbie
Activity: 52
Merit: 0
January 21, 2018, 07:11:03 AM
#8
3commas seems to be a nice application but I'm not sure that their copytrade function is useful someday.
If you were a super trader, would you like your trades to be copied?
jr. member
Activity: 35
Merit: 1
January 21, 2018, 06:11:41 AM
#7

Might not be a bad idea to create your own spreadsheet from scratch.
We all have our own preferences which make it almost impossible to have a one size fit all template for everyone!

True. But starting from scratch is a bit hard for me. I'd like to start with something and the personalize it.

There is a wonderful site https://3commas.io/ There you can add your MEW purses and track the status of most tokens.

This is nice. But I need a spreadsheet, and I need to keep track of other coins that are not ERC20.

I have noticed that you are facing the issue in the Google spread sheet on having the data. Personally I did not used the Google spreadsheet not even single time at all bro. Why you do not have the onedrive spreadsheet instead of Google's.
Even you can do all the editing option you can find the Google spreadsheet as well buddy.
More than Microsoft excel sheets can provide more option than any spreadsheet provider give the service.

I don't like Microsoft. At all.

Make a copy of the table that most suits you and add the things you need or remove unnecessary. Add a chart to tables easily. Read the documentation.

This is what I was trying to do, but every time I change something in the spreadsheet, it is not working. I'm trying to follow the documentation but somehow not able to get it working.
full member
Activity: 448
Merit: 100
Diagon
January 19, 2018, 12:37:33 PM
#6
Make a copy of the table that most suits you and add the things you need or remove unnecessary. Add a chart to tables easily. Read the documentation.
sr. member
Activity: 826
Merit: 263
January 19, 2018, 12:37:27 PM
#5
I have noticed that you are facing the issue in the Google spread sheet on having the data. Personally I did not used the Google spreadsheet not even single time at all bro. Why you do not have the onedrive spreadsheet instead of Google's.
Even you can do all the editing option you can find the Google spreadsheet as well buddy.
More than Microsoft excel sheets can provide more option than any spreadsheet provider give the service.
newbie
Activity: 5
Merit: 0
January 19, 2018, 12:23:09 PM
#4
There is a wonderful site https://3commas.io/ There you can add your MEW purses and track the status of most tokens.

Nice sharing
member
Activity: 579
Merit: 10
January 19, 2018, 10:21:50 AM
#3
There is a wonderful site https://3commas.io/ There you can add your MEW purses and track the status of most tokens.
member
Activity: 224
Merit: 28
January 19, 2018, 08:10:31 AM
#2
Where can I find a good google spreadsheet where I can keep track of few cryptos?
Online I found few but all of them miss something that I need and have the other things.

I'd like to have a "portfolio" section, if possible with pie chart. Here to see the gain and losses of my investments.
An history sheet where I can add the trades with the price I bought/sold so it can be used to show gain and losses in the main page.
A sheet or column with the actual value of each coin.
Value of each coin shown in BTC, USD, EUR.


I tried:

All of them are great but while trying to modify to my need, they all gave me some sort of error.
Any input is really appreciated. If you could share your (empty) spreadsheet that would be a good way to improve and personalize ours.

PS. I'm already using blockfolio, I need a google spreadsheet.

update: added links to the spreadsheets

Might not be a bad idea to create your own spreadsheet from scratch.
We all have our own preferences which make it almost impossible to have a one size fit all template for everyone!
jr. member
Activity: 35
Merit: 1
January 19, 2018, 05:26:57 AM
#1
Where can I find a good google spreadsheet where I can keep track of few cryptos?
Online I found few but all of them miss something that I need and have the other things.

I'd like to have a "portfolio" section, if possible with pie chart. Here to see the gain and losses of my investments.
An history sheet where I can add the trades with the price I bought/sold so it can be used to show gain and losses in the main page.
A sheet or column with the actual value of each coin.
Value of each coin shown in BTC, USD, EUR.


I tried:

All of them are great but while trying to modify to my need, they all gave me some sort of error.
Any input is really appreciated. If you could share your (empty) spreadsheet that would be a good way to improve and personalize ours.

PS. I'm already using blockfolio, I need a google spreadsheet.

update: added links to the spreadsheets
update II: added link to another spreadsheet for account tracking. Is not 100% what I wanted but I'm using it for my trading account and it works great.
Jump to: