# 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

Leverage

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?.

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.

Kĩ năng: PHP, Excel, Binance, Metatrader

Về Bên Thuê:
( 142 nhận xét ) San Bartolome de Geneto, Spain

ID dự án: #31766324

## 7 freelancer chào giá trung bình\$149 cho công việc này

hritikdanng

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 Thêm

\$160 USD trong 3 ngày
(10 Nhận xét)
3.7
globalseo614

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 Thêm

\$120 USD trong 3 ngày
(5 Nhận xét)
3.4
ashkannikrou2017

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 Thêm

\$150 USD trong 3 ngày
(7 Nhận xét)
2.9
qurratkhan

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

\$300 USD trong 1 ngày
(4 Nhận xét)
2.4
ravi7003

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, Thêm

\$100 USD trong 3 ngày
(0 Nhận xét)
0.0
sujeetgupta8118

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

\$110 USD trong 7 ngày
(0 Nhận xét)
0.0
harshalpk2003

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 Thêm

\$100 USD trong 7 ngày
(0 Nhận xét)
0.0