This Excel Template is a great way to track spot trades and total profits & losses.
You will just have to put your trading details i.e. Transaction Type (buy/sale), Maker/Taker transaction, Date & Time of Transaction, Quantity and sheet will automatically calculate all important data for every row.
You will see fixed Profit/Loss after every transaction on an average weighted basis, ROI, ROE, Cumulative Cost of Purchased coins, Cumulative Earning from sell, Total coins Purchased, Total coins Sold, Total Fair Value of Deposit Balance.
Template 1 based on the standard calculation of Transaction fee. Template 2 based on a model with using of special commission cryptocurrency.
You can use the template to calculate P&L for more complex trades. Just divide the complex trades into separate pairs and calculate the P&L for each pair.
Price $ 20. You will get the download link automatically after payment in:
Bitcoin https://gourl.io/gaxcx
Litecoin https://gourl.io/qxe7x
Dogecoin https://gourl.io/wf7v0
DASH https://gourl.io/xpng6
https://i111.fastpic.ru/big/2020/0320/ff/e73fb212ed92e258b3a57d34b19585ff.jpg
https://i111.fastpic.ru/big/2020/0320/20/debbb5387db377713ac2f4f2c1dd8e20.jpg
https://i111.fastpic.ru/big/2020/0320/14/f325b0bc600da339ca37a4b9662eae14.jpg
https://i111.fastpic.ru/big/2020/0320/45/2d88b3e49cd34c88491d0dd7071c9745.jpg
Topic: Spot Crypto Trading Analysis Excel Template (Read 146 times)
Jump to: