Spreadsheet to calculate liquidation price and risk on Binance

I want to create a spreadsheet (ideally on Google Spreadsheet) that will calculate the risk of a trade on Binance futures (isolated and cross margin), margin account and spot. The work would be done on an existing Spreadhshet that I've found. See attachment

Binance calculator doesn't work well and is not intuitive, so I want to create a spreadsheet that calculates the exact amount of coins to be purchased (and its equivalent in USDT) that I need to invest if I want to buy crypto futures or spot.

I want something straightforward. What will this calculator do?

Account size

Entry price

Stop-loss price

Risk %

Risk size in dollars

Position size calculated based on risk and account size


I want the calculator to use leverage on margin and futures. Futures allow us to buy up to 125x

- Select type of account and leverage.

a) Spot

b) Margin

c) Margin Isolated (3x, 5x, 10x)

d) Futures (margin X, isolated X). We should be able to select the amount of X (leverage).

* A field to specify the amount of leverage to be used in the futures account, from x1 to x125. The calculator will tell me how much money I will need to invest in planning a trade between price X and stopping loss Y.

Liquidation price and stop loss. I want to know the futures liquidation price based on the amount of money I want to buy in futures isolated.

I want something straightforward that Binance doesn't do.

I know where I want to buy and where I want my stop-loss. I want to know this... Based on entry and stop-loss prices with a predefined %/$ risk. How much money should I invest, and how much leverage should I use to enter a trad?.

Imagine this trade:

Entry price 10.00

Stop loss 9.00

Risk= 1

Account size: $1000

Risk size = $10

Position size = 10

I want to add leverage and liquidation price for Binance. I want to know the liquidation price, leverage and $ risk I should use based on entry and stop loss and have the spreadsheet display all these combinations, together with the target. Target should show risk size and profit based on the leverage used.

I have located an Excel spreadsheet that does almost everything except calculating the Liquidation price on Binance. You need to modify it to display Binance's liquidation price based on the leverage (cross or isolated) selected and the amount of $ risk and position size.

I want to enter ENTRY, STOP LOSS and RISK $ o %, and I want the spreadsheet to calculate liquidation price on Isolated or Margin (futures) based on different leverages... Together with profit target risk size and profit.

------------ I want the calculation to TELL me how much money and leverage I should invest to HAVE liquidation price below the stop-loss I want, it's that what I really want ------- If I want to risk from 10 to 9... i want my stop loss maybe at 8.90. How much money and leverage should I use to have the liquidation price below 9.80. That's the nitty-gritty.

Once the liquidation price is calculated, the spreadsheet should display a Stop Loss x% above/below (setting) the liquidation price to avoid liquidation fees.

See spreadsheet screenshot attached. I want to use this spreadsheet but add the liquidation price calculations I just described.

Beceriler: PHP, Excel, Binance, Metatrader

Daha fazlasını gör: javascript calculate house price, calculate total price real time javascript, php calculate total price order form using php, calculate website price, excel webmaster spreadsheet calculate hosting, javascript calculate order price, calculate booking price, html script calculate total price shopcart, javascript code calculate total price form, javascript calculate total price form, calculate project price, javascript calculate total price, joomla calculate post price, calculate selling price recipe, calculate banner price, javascript script calculate item price, oscommerce calculate options price, spreadsheet enter company price

İşveren Hakkında:
( 142 değerlendirme ) San Bartolome de Geneto, Spain

Proje NO: #31766324

Bu iş için 7 freelancer ortalamada $149 teklif veriyor


Hello, I'm a CA FInalist from the Institute of Chartered Accountants of India (the top recognized body in accounting and finance all over the world ). Apart from that, I have undergone 3 years of extensive training in Daha Fazla

$160 USD in 3 gün içinde
(10 Değerlendirme)

Hello, I can help you with Spreadsheet to calculate liquidation price and risk on Binance I have more than 5 years of experience in below listed skills: PHP Excel Metatrader Binance I have gone through your job pos Daha Fazla

$120 USD in 3 gün içinde
(5 Değerlendirme)

Hi sir, I will finish your project with all the description that you provided all clear and with source code. I am a professional programmer with 5 years of experience. I have worked on several similar projects , a Daha Fazla

$150 USD in 3 gün içinde
(7 Değerlendirme)

Hi I am good in this work as i have an experience about this so let me know the detail of your work Regards, Qurt

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(4 Değerlendirme)

Hi...I am an accounting professional from India, having 25 years of experience.... Lost my job due to pandemic situation. Looking for any type of job as I am jobless now. I am expert in Excel command, creating macros, Daha Fazla

$100 USD in 3 gün içinde
(0 Değerlendirme)

rvnefibn ebf inebnerie ie eif ei en rn rgn wgi grni wrgobigwi ngroi ngoi gwniobng nrgb nwroinboibgrinobngrsb nrgj rggbebnwubw

$110 USD in 7 gün içinde
(0 Değerlendirme)

Hello, my name is Harshal . I read all of your job related information you provided . According to your specification , I believe I am best candidate for your position. I have past expertise in data entry ,experience w Daha Fazla

$100 USD in 7 gün içinde
(0 Değerlendirme)