how can i keep track of my principal amount and PNL

[jessiahiya]

Hey Crypto Folks,

 

I use Binance and Zipmex.

 

But it is very hard to keep track principal investment and PNL. Especially when you are doing DCA.

 

I know we can check Order Summary and Wallet History.  But it is very hard to track your actual invested value and PNL.

Even the data provided in excel sheet is cluttered.

 

How do you keep track of it? Any suggestion?

 

For example am looking for something which shows invested amount and PNL like this for each coin

Coin: BTC

Invested Amount: 2000$ 

Average buying price: 28000$

Current Amount: 2200$

PNL : + 10% 

[GrandPapillon]

didn't you posted that exact same post a few months ago? or was it on another forum, can't remember ????

 

[Lemsta69]

14 minutes ago, GrandPapillon said:

didn't you posted that exact same post a few months ago? or was it on another forum, can't remember ????

 

so in other words, you don't know!

Edited May 25, 2022 by Lemsta69

[GrandPapillon]

11 hours ago, Lemsta69 said:

so in other words, you don't know!

I think you were given a lot of good answers, not sure why you would ask the exact same question ????

 

anyway, you can do it in Excel, but you need to know Excel and use the right methodology, you can find some examples in most financial education websites

 

it will also depend a lot on the number of trades that you have,

 

if you had a lot of trades, it should have been the first thing to do before buying another batch of BTC so you could track your real costs with entry and exit points

Edited May 25, 2022 by GrandPapillon

[jessiahiya]

21 hours ago, GrandPapillon said:

didn't you posted that exact same post a few months ago? or was it on another forum, can't remember ????

 

What are you talking about mate?????? I have just joined here yesterday!????

[GrandPapillon]

2 hours ago, jessiahiya said:

What are you talking about mate?????? I have just joined here yesterday!????

 must have been on another Thai related forum,

 

anyway, Excel is not a bad thing to track your trades, as long as you have the right computation methodology, which honestly is not hard

[FritsSikkink]

On 5/25/2022 at 2:07 PM, Lemsta69 said:

so in other words, you don't know!

So where is your solution?

 

Create an excel like here:   Michael Saylor (MicroStrategy) Portfolio Tracker (saylortracker.com)

[GrandPapillon]

19 hours ago, FritsSikkink said:

So where is your solution?

 

Create an excel like here:   Michael Saylor (MicroStrategy) Portfolio Tracker (saylortracker.com)

not a bad idea actually, even though I don't trade or like cryptos, I have to admit his website for tracking his holdings is quite nicely done

[jessiahiya]

On 5/26/2022 at 12:23 AM, GrandPapillon said:

I think you were given a lot of good answers, not sure why you would ask the exact same question ????

 

anyway, you can do it in Excel, but you need to know Excel and use the right methodology, you can find some examples in most financial education websites

 

it will also depend a lot on the number of trades that you have,

 

if you had a lot of trades, it should have been the first thing to do before buying another batch of BTC so you could track your real costs with entry and exit points

https://omegle.website/

https://ome-tv.org/

 

Seems Like i am not well welcome here!????

[piewarmer]

I use coingecko portfolio tracker, entry is manual but it's useful to monitor my funds overall. It's free too.