Bitcoin Forum
November 01, 2024, 09:19:46 AM *
News: Latest Bitcoin Core release: 28.0 [Torrent]
 
   Home   Help Search Login Register More  
Pages: [1]
  Print  
Author Topic: Spot Crypto Trading Analysis Excel Template  (Read 143 times)
Web Quests (OP)
Newbie
*
Offline Offline

Activity: 4
Merit: 0


View Profile
March 19, 2020, 11:55:26 PM
 #1

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
Pages: [1]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!