Author

Topic: need portfolio-tracker or trading sheet (Read 122 times)

full member
Activity: 2128
Merit: 180
April 24, 2021, 05:48:14 PM
#14
First of all, Excel is the most friendly sheet to monitor your trading transactions so its not stupid if you have one because I’m using this one too and I’m very effective on logging my trading and see if I made a good progress or not. You can use Blockfolio to monitor your holdings, this is also a big help if you’re far away from your laptop.
stupid because its manual and simple
ive see lots of very advanced file which ask 50$ per month,
im woking on a sheet to only calculate how coin i have and just check total $ but lots of time need
I’d rather use the free excel than to pay $50 a month since those sheet will matter through our own discipline so no matter what you’re using, if you don’t have discipline then it could be useless. I’m also using excel for quiet sometime now and its good for a medium to long term trader since you don’t nee to update it most of the time.
hero member
Activity: 3024
Merit: 680
★Bitvest.io★ Play Plinko or Invest!
April 24, 2021, 05:08:30 PM
#13
I don't record it and I don't have any sheet that I use for recording most of my trades.

But maybe this would help you, I just found it as I search. --> https://mindup.medium.com/free-crypto-portfolio-tracker-based-on-google-sheets-ef76070ec325

mm so how you know when you buy crypto the exact value of that crypto? your loses if you sell them now and growing percent Huh?
You lose if you sell them under the price you've bought it.

There's no rocket science of determining how much you've lost or gain upon selling, you have to put that in record how much you've bought it.

And knowing if the crypto you've bought has the exact value, there are price tickers that you can follow but prices of varies from exchange to exchange.
legendary
Activity: 2310
Merit: 4085
Farewell o_e_l_e_o
April 24, 2021, 08:23:16 AM
#12
I know some more.

Warning!
  • If you use applications, make sure the device you use to install those applications don't have any of your cryptocurrency, wallets, etc.
  • Just in case and just a secondary preventive solution for your device and crypto.
member
Activity: 868
Merit: 63
April 24, 2021, 07:27:05 AM
#11
You already used an Excel, I think it is enough in my opinion because you really don't need that much in terms of portfolio, it's just a record of your investment, I too use it myself and I don't find it that complicated.
newbie
Activity: 56
Merit: 0
April 24, 2021, 04:56:21 AM
#10
First of all, Excel is the most friendly sheet to monitor your trading transactions so its not stupid if you have one because I’m using this one too and I’m very effective on logging my trading and see if I made a good progress or not. You can use Blockfolio to monitor your holdings, this is also a big help if you’re far away from your laptop.
stupid because its manual and simple
ive see lots of very advanced file which ask 50$ per month,
im woking on a sheet to only calculate how coin i have and just check total $ but lots of time need
full member
Activity: 2086
Merit: 193
April 23, 2021, 07:40:46 PM
#9
First of all, Excel is the most friendly sheet to monitor your trading transactions so its not stupid if you have one because I’m using this one too and I’m very effective on logging my trading and see if I made a good progress or not. You can use Blockfolio to monitor your holdings, this is also a big help if you’re far away from your laptop.
copper member
Activity: 2086
Merit: 1759
Top Crypto Casino
April 23, 2021, 06:38:25 PM
#8
Why suffer setting up spreadsheets, yet portfolio management apps can ease up things for you?

You just import your exchange API keys into the app and the rest will be sorted. Most of the apps do offer free tracking for limited accounts
A. Delta portfolio app
B. Bituniverse
C. coinstats.app
D. 3commas app
hero member
Activity: 2996
Merit: 609
April 23, 2021, 06:18:55 PM
#7
Hello
i have my own stupid excel file which is very simple, several column (date cur-name amount and ....) to track my total amount of coin and it will calculate some data,

first of all how you trade? write your investing on paper or use a excel ?
any free portfolio tracker google sheet ?
ive search this on google and find 2 online sheet but in general how you track your investing ?
Use Blockfolio. Ive been using this app for how many years on tracking out my investment or portfolio.It can alert you out on specific price that you are trying to aim for neither to sell or buy.

When it comes to convenience and accessibility then this one do fit out my needs and i dont really tend too hassle myself when it comes to those excels.

You can also make use with other apps which does have the same concept: https://alternativeto.net/software/blockfolio/
legendary
Activity: 2226
Merit: 1086
Free Bitcoins Every Hour!
April 23, 2021, 05:54:06 PM
#6
~snip~
Same with me, I am also commonly in making some excel sheets on my computer so that I can check the portfolio of mine. However, it is not online and I cannot track my portfolio directly due to the high volatility of the market price. SO, I want to try also the recommendation from @BitMaxz.. Thanks
newbie
Activity: 56
Merit: 0
April 23, 2021, 04:04:20 PM
#5
I don't record it and I don't have any sheet that I use for recording most of my trades.

But maybe this would help you, I just found it as I search. --> https://mindup.medium.com/free-crypto-portfolio-tracker-based-on-google-sheets-ef76070ec325

mm so how you know when you buy crypto the exact value of that crypto? your loses if you sell them now and growing percent Huh?
legendary
Activity: 3374
Merit: 3095
BTC price road to $80k
April 23, 2021, 01:26:23 PM
#4
I actually use some apps and a free web portfolio tracker.


Here's the one that I used for Android
- Crypto Market Cap - Crypto tracker, Alerts, News = it's free and it also has news alert and portfolio
- Blockfolio = Never used them but it's also a good app for tracking portfolio.


For web portfolio and sheets
- https://cointracking.info/ = This is the best tool you can also download the sheet in a CSV file that you can open through a Google spreadsheet or any similar software.
                                        Or manually make own data sheet by following their guide from here "Cointracking.info data in Excel & Googlesheets using Cryptosheets"

- Coingecko Portfolio = Its free but you must be registered. They don't have a sheet but it's also good for tracking portfolios. They also support Android.
- Coinmarketcap Portfolio tracker = same as Coingecko but it has better UI.



All free crypto portfolio tracker templates can be found here https://cryptosheets.com/templates They also have paid templates but the free is enough to start tracking your crypto.
member
Activity: 1078
Merit: 15
April 23, 2021, 12:40:34 PM
#3
For traders and investors who have good management and are resilient in managing their investments, this can be done by recording them on several papers and evaluating the average results that can be obtained based on the specified timeframe.

but rarely do we do this, we pay more attention to the transaction history in the portfolio and calculate the amount of income there. the rest I do not have notes like the one you reviewed above.
hero member
Activity: 3024
Merit: 680
★Bitvest.io★ Play Plinko or Invest!
April 23, 2021, 12:26:29 PM
#2
I don't record it and I don't have any sheet that I use for recording most of my trades.

But maybe this would help you, I just found it as I search. --> https://mindup.medium.com/free-crypto-portfolio-tracker-based-on-google-sheets-ef76070ec325
newbie
Activity: 56
Merit: 0
April 23, 2021, 12:11:48 PM
#1
Hello
i have my own stupid excel file which is very simple, several column (date cur-name amount and ....) to track my total amount of coin and it will calculate some data,

first of all how you trade? write your investing on paper or use a excel ?
any free portfolio tracker google sheet ?
ive search this on google and find 2 online sheet but in general how you track your investing ?
Jump to: