HOW TO AUTOMATICALLY CALCULATE YOUR COST AVERAGE ON BINANCE


Binance doesn’t calculate your cost average. This sucks!

In this video, I show you how you can automatically calculate your cost average.

Should take you less than 5min to set up in Excel or Googlesheet.

STEP 1: Export your spot orders history list from Binance.

STEP 2: Make a few adjustments t o your downloaded transaction history list by either copying/pasting the formulas from this Googlesheet:
https://docs.google.com/spreadsheets/d/1DU-BcGojC2Fei2OSJXJXWZSmdnbaDQ-ivp-kBkCM-Ro/edit?usp=sharing

Or enter the following formulas yourself in column “I” and “J”:

I2 =subtotal(9,I3:I700)
J2 =subtotal(109,J3:J700)

And drag these formulas all the way at the bottom of your transaction list:
I14 =if(C14=”BUY”,E14,0)
J14 =I14*D14

Happy trading!

Leave a Reply

Your email address will not be published.