Binance Futures PNL Computation (Tutorial)

[conviction]

Sa mga gusto lang magmanual compute ng PNL kung walang kuryente at low bat
-bago magtrade pag nagkailaw or charge na

FORMULA
a. SHORT/SELL

PNL=(entry price-exit price)*volume​

b. LONG/BUY

PNL=(exit price-entry price)*volume​

c. Volume
($available fund x leverage)/coin price

Sample Computation:
Investment: $10
Leverage: 20x
total: $200 na pwede pantrade

SHORT Position (SELL)
BTC Entry $46,910
BTC Exit $46,850
60 (difference)

Volume
-kung ilan mabibili ng pera mo (3 decimals only)
$200/$46,910=0.00426348 BTC (volume)

PNL
=0.004 x 60
$0.24 (Gross Profit)
-depende kung may BNB ka, dun makakaltas fees
-pag wala sa USDT kaltas
-at pag lampas kayo 4hrs to 8HRS may funding fees pa

countercheck sa calcu

try nyo din magcompute sa LONG position para masanay

Kung di ako tinamad try ko gawan sa excel pero kung kaya nyo naman gawin, congrats!

Happy trading sa mahilig mag trade sana manalo kayo

EXCEL FILE sa mga may gusto​

You do not have permission to view the full content of this post. Log in or register now.

Formula sa Excel sa mga gagawa
-check nyo na lan kung anong row at column yung mga cell, palitan nyo nalang mga letra sa baba
-reverse nyo nalang sa short/sell yung formula baliktarin sa entry minus exit

Buy Power
=IF(ISERROR(D7*E7),"",(D7*E7))

Volume
=IF(ISERROR(H7/F7),"",ROUND((H7/F7),3))

PNL
=IF(G7="","",IF(F7="","",ROUND(((G7-F7)*I7),3)))

remarks
=IF(J7="","",IF(J7<0,"OLATS!","PANALO!"))

LIQUIDATION PRICE (Approximate hindi kasama Maintenance Margin)​

-manual computation guestimate para may idea

BUY/LONG
LP=Entry Price - [(100/Leverage)/100 * (Entry Price)]

SHORT/SELL
LP=Entry Price + [(100/Leverage)/100 * (Entry Price)]

Sample: Buy/Long
Capital: $10
Leverage: 20x
Enrty Price: 46,910
LP=46,910-[(5/100) * 46,910]
=44,564.50

Vs Binance calcu may mark up dahil sa MM, unrealized PNL etc

EXCEL with PNL & LP(approx) margin maintenance not included

 

[Deleted member 1774449]

pabookmark

 

[G O Z A R U]

bm ko muna to

 

[KLever Man]

salamat Sa Idea lods

 

[Khamote05]

Bookmark muna lods..

 

[conviction]

pabookmark

bm ko muna to

salamat Sa Idea lods

Bookmark muna lods..

sige lang mga boss, kayo na bahala magexplore check nyo nalang excel file kung gusto nyo gamitin or gawa ng sarili

 

[rexph]

Thanks lods.

 

[conviction]

Thanks lods.

walang anuman happy trading

 

[Charybdis]

Thank you

 

[conviction]

Thank you

welcome

 

[Six8Nine]

Marka din. Salamat

 

[conviction]

Marka din. Salamat

welcome

 

[PHC-Sync]

baka meron ka para sa liquidition price lods

 

[conviction]

baka meron ka para sa liquidition price lods

check ko kung masundan ko yung formula nila since may mga factors involve like maintenance amount table unlike sa isang exchange dati mas madali masundan at compute LP, pero pwede padin use sa Binance calcu meron din dun Liqui computation

 

[I - Love - U]

Bm

 

[Virgo258]

Grabe nahilo ako hahahaa

 

[conviction]

Grabe nahilo ako hahahaa

plus minus multiply lang yan paps

 

[C R 3 3 P 3 R Z]

Thank you

 

[Pandacoco]

Salamat dito boss

 

[tedz17]

salamat boss