akda Posted January 28, 2022 Share Posted January 28, 2022 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% Link to comment Share on other sites More sharing options...
GrandPapillon Posted January 28, 2022 Share Posted January 28, 2022 (edited) build your own Excel file, and enter each trade manually in it, quite easy, and calculate your gains or losses there are some software for it, but they can be expensive, above all if you only do a few trades per month make sure to adjust with deposits/withdrawal to calculate the true gains/losses you can also the IRR method, Edited January 28, 2022 by GrandPapillon 1 Link to comment Share on other sites More sharing options...
GrandPapillon Posted January 28, 2022 Share Posted January 28, 2022 15 minutes ago, akda said: Invested Amount: 2000$ Average buying price: 28000$ Current Amount: 2200$ this doesn't add up, beginning cash (initial value) + market value - ending cash (initial value + realized gains/loss) Link to comment Share on other sites More sharing options...
akda Posted January 28, 2022 Author Share Posted January 28, 2022 2 minutes ago, GrandPapillon said: this doesn't add up, beginning cash (initial value) + market value - ending cash (initial value + realized gains/loss) As I do DCA, typically I use this for calculation https://percentagetools.com/dollar-cost-average-calculator/ But everything is manual ???? Link to comment Share on other sites More sharing options...
GrandPapillon Posted January 28, 2022 Share Posted January 28, 2022 (edited) 3 minutes ago, akda said: As I do DCA, typically I use this for calculation https://percentagetools.com/dollar-cost-average-calculator/ But everything is manual ???? DCA, FIFO or LIFO, same process for gains/loss, it's just a tax reporting issue you need to keep track of each trade, regardless, the final performance will be based on the average cost left from the different LIFO/FIFO/AVG actions Edited January 28, 2022 by GrandPapillon 1 Link to comment Share on other sites More sharing options...
Whale Posted January 28, 2022 Share Posted January 28, 2022 I used Cointracker to automatically track across wallets and exchanges but it had lots of bugs. Tried Koinly and it massively wrong reported from the getgo. Also Coinstats but that also does not report things like DeFi submissions correctly but is my current fav. 1 1 Link to comment Share on other sites More sharing options...
akda Posted January 28, 2022 Author Share Posted January 28, 2022 1 minute ago, Whale said: I used Cointracker to automatically track across wallets and exchanges but it had lots of bugs. Tried Koinly and it massively wrong reported from the getgo. Also Coinstats but that also does not report things like DeFi submissions correctly but is my current fav. will try these, was looking for something like this. doing manually in excel is pain in a**. Link to comment Share on other sites More sharing options...
GrandPapillon Posted January 29, 2022 Share Posted January 29, 2022 (edited) doing it manually is actually a good practice, brokers have a history of poor reporting for P/L, too complicated for them, too many rules etc... and also at the same time, they got to "hide" the poor performance of their customers actions so they don't feel bad about it so they can keep trading silly ???? always have a detailed log of all your trades with P/L, it's just common sense and that's not even negotiable, in case taxation comes into effect don't simply rely on third party buggy software or buggy platform like those crypto exchanges Edited January 29, 2022 by GrandPapillon Link to comment Share on other sites More sharing options...
The Hammer2021 Posted January 29, 2022 Share Posted January 29, 2022 I leave it to my TGF Link to comment Share on other sites More sharing options...
Whale Posted January 30, 2022 Share Posted January 30, 2022 Anyone know where to download a google sheet thats is reformatted for crypto tracking with current prices auto inserted?? Link to comment Share on other sites More sharing options...
GrandPapillon Posted January 30, 2022 Share Posted January 30, 2022 5 hours ago, Whale said: Anyone know where to download a google sheet thats is reformatted for crypto tracking with current prices auto inserted?? right ???? jesus, you guys are lazy, won't hurt you to work a bit to track your "amazing" gains ???? Link to comment Share on other sites More sharing options...
Whale Posted January 31, 2022 Share Posted January 31, 2022 17 hours ago, GrandPapillon said: jesus, you guys are lazy, won't hurt you to work a bit to track your "amazing" gains Thats rather trollish and juvenile. Whatever floats your boat though I suppose. 1 Link to comment Share on other sites More sharing options...
GrandPapillon Posted January 31, 2022 Share Posted January 31, 2022 (edited) 5 hours ago, Whale said: Thats rather trollish and juvenile. Whatever floats your boat though I suppose. trollish for calling out lazy crypto fans? listen, if you want to play like the big boys, it comes with responsibilities and discipline, otherwise it's just playing like spoiled little brats too lazy to count their chips after a game of poker Edited January 31, 2022 by GrandPapillon 1 Link to comment Share on other sites More sharing options...
Whale Posted January 31, 2022 Share Posted January 31, 2022 26 minutes ago, GrandPapillon said: trollish for calling out lazy crypto fans? listen, if you want to play like the big boys, it comes with responsibilities and discipline, otherwise it's just playing like spoiled little brats too lazy to count their chips after a game of poker I presume you are writing this from the crack clinic in Solihull. Still got you teeth? 1 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now