Lukket

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

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.

Evner: PHP, Excel, Binance, Metahandel

Se mere: 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

Om arbejdsgiveren:
( 142 bedømmelser ) San Bartolome de Geneto, Spain

Projekt ID: #31766324

7 freelancere byder i gennemsnit $149 timen for dette job

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 Flere

$160 USD in 3 dage
(10 bedømmelser)
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 Flere

$120 USD in 3 dage
(5 bedømmelser)
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 Flere

$150 USD in 3 dage
(7 bedømmelser)
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 på 1 dag
(4 bedømmelser)
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, Flere

$100 USD in 3 dage
(0 bedømmelser)
0.0
sujeetgupta8118

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

$110 USD in 7 dage
(0 bedømmelser)
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 Flere

$100 USD in 7 dage
(0 bedømmelser)
0.0