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