Spoop (OP)
Newbie
Offline
Activity: 101
Merit: 0
|
![](https://bitcointalk.org/Themes/custom1/images/post/question.gif) |
July 17, 2017, 03:38:03 PM Last edit: July 17, 2017, 05:19:52 PM by Spoop |
|
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?
|
|
|
|
Robot1987
Newbie
Offline
Activity: 12
Merit: 0
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
July 17, 2017, 03:50:54 PM |
|
Myself, I have great experience with plain excel worksheet. Easy to set up, with plenty of templates at users disposal. Easy to update and check for anything missing. Does the math for you. Mortrages, family budget planner, personal monthly budget planner, income statement, bitcoins... Look for yourself http://www.makeuseof.com/tag/10-helpful-spreadsheet-templates-help-manage-finances/
|
|
|
|
Kemarit
Legendary
Offline
Activity: 3206
Merit: 1384
Fully Regulated Crypto Casino
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
July 17, 2017, 07:03:41 PM |
|
We are both old school mate. LOL. I also find Excel spreadsheet very simple and easy to used specially in tracking my investment portfolio. You just have to understand some basic and of course the formula. I'm pretty sure some members will bash us saying that Excel is not safe etc. etc. ( I was bashed once for using Excel to put my passwords and seeds and private keys saying its not good. But to each its own). I also used Excel to track my offline business profits and other info as well.
|
|
|
|
HabBear
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
July 17, 2017, 08:06:26 PM |
|
Yeah, spreadsheets work best. The allow you to maintain full control of your numbers...keeps it all in the spirit of Bitcoin, no?
I've been buys, gain/loss value, gain/loss %, average cost, current value and this works across all crypto currencies. I also include a single cell for the Bitcoin price, I can update that and see my numbers update dynamically. It's fairly useful as Bitcoin's price to fiat can change so much from hour to hour and day to day.
|
|
|
|
Velkro
Legendary
Offline
Activity: 2296
Merit: 1014
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
July 17, 2017, 08:11:46 PM |
|
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.
I know your pain, i have no idea what i have left in old wallets and where are they... I lost track long ago, one day i will search to find them all like pokemon's ![Wink](https://bitcointalk.org/Smileys/default/wink.gif)
|
|
|
|
Graed
Newbie
Offline
Activity: 19
Merit: 0
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
July 17, 2017, 09:44:43 PM |
|
We are both old school mate. LOL. I also find Excel spreadsheet very simple and easy to used specially in tracking my investment portfolio. You just have to understand some basic and of course the formula. I'm pretty sure some members will bash us saying that Excel is not safe etc. etc. ( I was bashed once for using Excel to put my passwords and seeds and private keys saying its not good. But to each its own). I also used Excel to track my offline business profits and other info as well. - 2017
- Not using crop circles to organize your crypto
|
|
|
|
Zicadis
Legendary
Offline
Activity: 1372
Merit: 1027
Dump it!!!
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
July 17, 2017, 10:24:25 PM |
|
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.
I know your pain, i have no idea what i have left in old wallets and where are they... I lost track long ago, one day i will search to find them all like pokemon's ![Wink](https://bitcointalk.org/Smileys/default/wink.gif) For starters use a desktop pc and not a smart phone to help organise your stuff easily and if it helps you can tabulate everything to serve as a reminder using word or excel
|
|
|
|
aeternus
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
July 17, 2017, 11:04:39 PM |
|
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?
Use excel dude, it may seem hard at first but the time you invest in it is well worth your time, you can keep track of anything that requires basic math and that needs to be done fast, that is the way you can keep track of your investment in the easiest way since you can make any calculation that you can imagine there instead of being limited by an app.
|
|
|
|
SunofGold
Member
![*](https://bitcointalk.org/Themes/custom1/images/star.gif)
Offline
Activity: 113
Merit: 12
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
July 18, 2017, 01:53:24 AM |
|
I'm lazy and just watching the charts inside blockfolio. Its easy to add new transation, fine for me.
|
|
|
|
iluvpie60
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
July 18, 2017, 03:09:25 PM |
|
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 can easily make a new Google Spreadsheet and keep track of everything on there. It is pretty much a free version of Excel spreadsheet, it is online and can be accessed from any device. It is linked to your gmail account. Just put how much you buy it for, where from, the quantity and the date and what crypto it was and the fee. Once you make some calcultions and drag it down you can go on forever with it and add to it as you go.
|
|
|
|
fluturash
Newbie
Offline
Activity: 46
Merit: 0
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
July 18, 2017, 06:29:09 PM |
|
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 can easily make a new Google Spreadsheet and keep track of everything on there. It is pretty much a free version of Excel spreadsheet, it is online and can be accessed from any device. It is linked to your gmail account. Just put how much you buy it for, where from, the quantity and the date and what crypto it was and the fee. Once you make some calcultions and drag it down you can go on forever with it and add to it as you go. I need to check this up .Thanks !
|
|
|
|
WannaCry
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
July 19, 2017, 07:13:20 AM |
|
I use blockfolio app. I just put search there the crypto that i have and put the number of my holdings then i can monitor its price anytime i want. I can see how my holdings increases and decreases with the use of that app.
|
|
|
|
Commie
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
July 19, 2017, 10:41:38 AM |
|
I use blockfolio app. I just put search there the crypto that i have and put the number of my holdings then i can monitor its price anytime i want. I can see how my holdings increases and decreases with the use of that app.
Blockfolio has one disadvantage - when you sell any altcoins the btc value doesn't automatically add to your btc balance and you have to do it manually. Also I find it hard to keep notes regarding what wallet has what in it.
|
|
|
|
Spoop (OP)
Newbie
Offline
Activity: 101
Merit: 0
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
July 19, 2017, 05:03:43 PM |
|
I use blockfolio app. I just put search there the crypto that i have and put the number of my holdings then i can monitor its price anytime i want. I can see how my holdings increases and decreases with the use of that app.
Blockfolio has one disadvantage - when you sell any altcoins the btc value doesn't automatically add to your btc balance and you have to do it manually. Also I find it hard to keep notes regarding what wallet has what in it. Yeah, I've got the same problem with Blockofolio. They should add that option in the future.
|
|
|
|
Spoop (OP)
Newbie
Offline
Activity: 101
Merit: 0
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
July 19, 2017, 05:58:40 PM |
|
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?
Use excel dude, it may seem hard at first but the time you invest in it is well worth your time, you can keep track of anything that requires basic math and that needs to be done fast, that is the way you can keep track of your investment in the easiest way since you can make any calculation that you can imagine there instead of being limited by an app. But the thing is, using excel doesn't seem to have any advantages for me over using blockofolio right now. Are there any tutorials on how to implement a live tracker of cryptocurrency in Excel?
|
|
|
|
Commie
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
July 19, 2017, 06:12:04 PM |
|
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?
Use excel dude, it may seem hard at first but the time you invest in it is well worth your time, you can keep track of anything that requires basic math and that needs to be done fast, that is the way you can keep track of your investment in the easiest way since you can make any calculation that you can imagine there instead of being limited by an app. But the thing is, using excel doesn't seem to have any advantages for me over using blockofolio right now. Are there any tutorials on how to implement a live tracker of cryptocurrency in Excel? Man you're basically asking for a crash course in Excel programming
|
|
|
|
TryNinja
Legendary
Offline
Activity: 2954
Merit: 7378
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
July 19, 2017, 06:23:08 PM |
|
How about https://altpocket.io ? I like it because they allow you to import your whole buy and sell history from Poloniex and Bittrex (via API) to see how much you profited with each trade. You will see in "active investments" all the coins you only bought and at sold investments your profit/loss for every buy-sell trade you do. e.g: I bought 50 LTC at 0.01798 and sold the next day at 0.0185; I will see at "Sold Investments" that I made a profit of 0.026 BTC or x% with this trade + my all time profit/loss and net worth.
|
|
|
|
newsilike
Sr. Member
![*](https://bitcointalk.org/Themes/custom1/images/star.gif) ![*](https://bitcointalk.org/Themes/custom1/images/star.gif) ![*](https://bitcointalk.org/Themes/custom1/images/star.gif)
Offline
Activity: 630
Merit: 262
This account was hacked. just recently got it back
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
July 21, 2017, 08:18:18 PM |
|
also looking for a Portfolio Tracker I need one where u don't have to put in the BUY in price of the cryptocurrencies
the gain I made is not interesting for me - only what the Portfolio is worth now
|
|
|
|
TryNinja
Legendary
Offline
Activity: 2954
Merit: 7378
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
July 21, 2017, 10:42:06 PM |
|
also looking for a Portfolio Tracker I need one where u don't have to put in the BUY in price of the cryptocurrencies
the gain I made is not interesting for me - only what the Portfolio is worth now
In this case I suggest you to use https://coin.fyi/Clean interface, easy to use and mostly focused on your portfolio overall. It's the better website if you are more of a holder than a trader.
|
|
|
|
HabBear
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
July 22, 2017, 05:10:57 AM |
|
This is a great share! Thank you! But aren't you worried about a third party site knowing the details of your holdings? They could also know where you keep your stash. I'm not against technology or anything but for something that's meant to provide you with more control and privacy this seems like a challenging compromise. How about https://altpocket.io ? I like it because they allow you to import your whole buy and sell history from Poloniex and Bittrex (via API) to see how much you profited with each trade. You will see in "active investments" all the coins you only bought and at sold investments your profit/loss for every buy-sell trade you do. e.g: I bought 50 LTC at 0.01798 and sold the next day at 0.0185; I will see at "Sold Investments" that I made a profit of 0.026 BTC or x% with this trade + my all time profit/loss and net worth.
|
|
|
|
|