I've been investing in cryptocurrency since the end of may and I find it hard to keep track of all the cryptocurrency I'm investing in. Right now, I'm using blockofolio, an application for on your smartphone, but I'm looking for a computer programme in which I can also see how much net earnings I make, which is something I can't see in blockofolio. I don't really know how to make this in excel myself, so what do you guys use to keep track of it all?
You do not have to be an expert in excel to make use of it, it just depends on how often you wan to make an evaluation of your portfolio, I write everything that I buy the price on bitcoin and the price of dollars and then once a month or two I just check all my holdings and see if I have won money, obviously I check the price more frequently but I only update my spreadsheet once a month or even less than that. 
Topic: How do you guys keep track of all your cryptocurrency investments? (Read 2725 times)
January 18, 2018, 04:08:36 PM
January 18, 2018, 01:22:50 PM
i manually do it with spreadsheets
January 18, 2018, 01:03:17 PM
To track your investments you better use any stock market tracking software or apps where you just need to change the stocks name with the cryptocurrency name and believe me you can do this way because it's just for your personal use and even i try to follow this method and i use Jstock software, which is an Indian stock market investment tracking software where each and every investment can be tracked which we input over there for once. And other than this you can also track using Microsoft Excel or google online spreadsheets which has to be maintained manually, but this one is also a great option if you are tracking some big portfolio and even i follow this as a backup option.
January 18, 2018, 11:58:54 AM
I am marking all my investments on Blockfolio, a great free app which tells me in every moment what I have and how much it is worth. Even though in day like yesterday it can turn out quite traumatizing..
January 18, 2018, 11:08:50 AM
I'm looking for a google spreadsheet to keep track of my coins. I found few online that are quite good but each one is missing something that I want to use.
I need to have multiple currencies (eg. USD and GBP, USD and EUR, etc), the price of the coins updated (using API or something), my transaction with the actual price I paid + gain and loss column. A very good surplus would be some pie chart with % of the coins owned, etc.
I fund at least 3 good google spreadsheet that I could use, but each of them is missing one of my needed features while having the others. I'm not so skilled to do a new one by myself nor mix and match the existing.
Can anyone link to some spreadsheet?
I need to have multiple currencies (eg. USD and GBP, USD and EUR, etc), the price of the coins updated (using API or something), my transaction with the actual price I paid + gain and loss column. A very good surplus would be some pie chart with % of the coins owned, etc.
I fund at least 3 good google spreadsheet that I could use, but each of them is missing one of my needed features while having the others. I'm not so skilled to do a new one by myself nor mix and match the existing.
Can anyone link to some spreadsheet?
December 31, 2017, 08:23:57 PM
I also use spreadsheets because it is convinient to use and i am know it well . I am more comfortable on using it on a desktop and i recommend it to newbies also. I never tried using any other options either.
December 31, 2017, 02:52:16 PM
Are there programs where you could put in your wallet history such as buy/sell and similar and then it automatically tracks your capital gains or losses etc?
When you people mention google spreadsheet, you mean there is one out there that has what price you bought it and how much etc? Or you mean just create one yourself?
When you people mention google spreadsheet, you mean there is one out there that has what price you bought it and how much etc? Or you mean just create one yourself?
December 31, 2017, 01:36:24 PM
I wrote my own fiat/crypto/precious metals tracker in PHP/mysql. I made it for my own purpose.
I preffer to write something once, and don't waste time later on to update rates in Excel, everytime.
When it was ready, I placed it on the server for everybody: https://assetbalance.info. You are welcome to use it.
I preffer to write something once, and don't waste time later on to update rates in Excel, everytime.
When it was ready, I placed it on the server for everybody: https://assetbalance.info. You are welcome to use it.
October 24, 2017, 06:53:25 PM
Here's the excel file I made a few weeks ago, it's an improvement on one someone else had made... Each time I make a transaction I just enter the data into the yellow highlighted areas and I update current price in the summary tab. I have a tab for each of the 3 currencies I own. It has some random data in there right now, you can delete it and enter your own.
https://www.dropbox.com/s/nqj5t5chac0a70o/Crypto%20Tracker2.xlsx?dl=0
https://www.dropbox.com/s/nqj5t5chac0a70o/Crypto%20Tracker2.xlsx?dl=0
October 24, 2017, 06:06:38 PM
When I started off trading, I was faced with this same issue of keeping tabs with investments.
There's an app called Blockfolio It helps you track your portfolio and see the current details of any of your token/coin.
It offers a very nice design and functionality.
There's an app called Blockfolio It helps you track your portfolio and see the current details of any of your token/coin.
It offers a very nice design and functionality.
October 24, 2017, 04:10:43 PM
im using blockfolio app to track my porfolio so i can see if i gain or loss this app really help me to manage my porfolio thanks yo the creator of this its helps alot i already rate it to 5star
This is what im using after all this time on which i do make track of my altcoin holdings thru blockfolio app which i can anytime see or actively check the prices of it on where it do help me to decide if its time to sell or buy but the downside is not all coins is being listed too fast on blockfolio on which you would really need to list it up either on a notepad or an excel (depending on the things that suits you). October 24, 2017, 03:29:59 PM
If you really want buying a lot of different coins use only exel because it is the best program for this
But i propose you focus only on few coins because it give you more reliable control
But i propose you focus only on few coins because it give you more reliable control
October 24, 2017, 03:09:06 PM
I'm not sure if working with so many coins, tokens and assets that you would need any tracking help is really good idea. If you focus on only 3-4 coins, it's easy to calculate the profits yourself, if you buy blindly 100 tokens, I doubt that without any research you can even expect any profit, so yeah, maybe in that case it is better to find yourself a tool to keep track of all these losses.
October 24, 2017, 06:10:29 AM
im using blockfolio app to track my porfolio so i can see if i gain or loss this app really help me to manage my porfolio thanks yo the creator of this its helps alot i already rate it to 5star
October 24, 2017, 05:59:56 AM
I let my bots keep track of things and move my positions if needed. It's quite tedious to keep track of pricing manually.
October 24, 2017, 05:58:14 AM
I'm always on pc so I just look on coinmarketcap if one of my coins is already pumping. I think I don't need to check my portfolio everytime if they aren' t pumping.
But you need to look at the chart of your respective coins continuously to figure out in which phase they are currently residing. It is mandatory to keep a good check on the prices and fluctuations exhibited by your coin for trading them at right time and enjoying profit with them. All coins are not meant for long term investment such as most of the altcoins, so you cannot leave them in wallets without paying attention to their market prices. October 22, 2017, 10:11:04 PM
I'm always on pc so I just look on coinmarketcap if one of my coins is already pumping. I think I don't need to check my portfolio everytime if they aren' t pumping.
October 22, 2017, 08:11:09 PM
Blockfolio usere here as well. was thinking about running excel sheet but not if I can update prices every 2 min with the current state of the altcoin world.
There is def plan to use excel in the future and I do like to keep all the charges from the coinbase and exchanges in check so I know the bottom line of my investment
There is def plan to use excel in the future and I do like to keep all the charges from the coinbase and exchanges in check so I know the bottom line of my investment
October 22, 2017, 07:11:06 PM
Excel is your friend. Noting down which investment, which wallet or exchange and so on.
Honestly I am as an escrow are often highly astonished when people get back to me a year after a coin died and I initiated a refund. It feels like they do not care about their coins at all.
Honestly I am as an escrow are often highly astonished when people get back to me a year after a coin died and I initiated a refund. It feels like they do not care about their coins at all.
October 22, 2017, 06:29:43 PM
There are different apps and sites that allow you to keep track of your portfolio. CoinCap is a great app and allows you to track most altcoins and forkcoins on a list.
Jump to: