Spreadsheet To Calculate Liquidation Price And Risk On Binance

$ 80.00 — 120.00 USD

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.

Design, Media & ArchitectureExcelMetatraderBinance

Similar Freelance jobs:

Simple Data Entry Work For All

Data ProcessingData EntryExcelVideo UploadBPO Place Bid

Hello Freelancers, We need 30 people from any part of the world for simple data entry work. This project is very simple but little tougher than copy paste work. International members are allowed and typing speed should be minimum 12 words per minute.

Full Description of Simple Data Entry Work For All

Mobile App Developer - Android / Ios

Design, Media & ArchitectureJavaAndroidSoftware ArchitectureObjective C Place Bid

Role / requirements:\r\nMobile application developer wanted urgently for a simple mobile app project.\r\nLooking for freelance / contract arrangement at the moment with possibility of a full time role later.\r\nMust be familiar with Titanium and Phonegap\r\nMust be familiar with web application architectures (client - server setup)\r\nAble to develop and program independently based on technical user requirements provided.\r\nMulti platform dev experience would be very useful - I.e. trigger, phonegap, appcelerator.\r\nUI design experience is a plus.\r\nNo educational requirements needed as long as you…

Full Description of Mobile app developer - Android / iOS

Build A Simple Index Page..

Design, Media & ArchitectureWebsite DesignTemplatesHTMLjQuery / Prototype Place Bid

I need a simple Index page by HTML, CSS and JQuery/Java scripts.. Please don't bid if you don't have good knowledge on HTML, CSS and JQuery/Java scripts.. All details will be send in PMB, after that you need to send me a template.. After approved this template make a web page by help of HTML, CSS and JQuery/Java scripts.. I need a good work .. I will upload milestone, but payment after end of the work.. Thanks.

Full Description of Build a simple Index page..

Fatal Error

Design, Media & ArchitectureWebsite DesignGraphic DesignHTML Place Bid

when i'm installing oxyclassified i get this error Fatal error: Call to undefined function query() in /home/content/92/11470292/html/classes/config/settings_config.php on line 1343 can you help please thanks

Full Description of fatal error

Build A Website

Design, Media & ArchitectureWebsite DesignGraphic DesignHTML Place Bid

Hello, I am in need of a clean and natural-looking website as soon as possible. The project is for a raw food festival where I'm in need for a simple and clean site that resonates with its purpose. I need an about page, article/blog page, calendar/schedule page, information and registration about the festival, upcoming courses, and a slick front page that shows what the festival is about. Templates could of course be used, as long as it doesn't look cheap…

Full Description of Build a website

Write Some Software

Design, Media & ArchitectureJavaCSSSoftware ArchitectureMySQL Place Bid

* Create Master Port Module at Ship Management by Struts 1 framework on Java * Create journal entry for module PO and Invoice by Struts 2 framework on java

Full Description of Write some Software

Build A Website

Design, Media & ArchitectureWebsite DesignGraphic DesignHTMLOdoo Place Bid

jennyrealestate.com.vn

Full Description of Build a Website

Write Some Software

Design, Media & ArchitectureSales & MarketingPythonSoftware ArchitectureC++ Programming Place Bid

Full Description of Write some Software

Hardware Applications

Design, Media & ArchitecturePythonCSSHTMLArduino Place Bid

Full Description of Hardware applications

** Integração Prestashop / Cnova **

Design, Media & ArchitectureMagentoeCommercePrestashopWeb Services Place Bid

Este JOB tem como objetivo selecionar um webdeveloper para realizar a integração entre a nossa loja virtual PrestaShop e a CNOVA. Recentemente firmamos uma parceria com o Grupo Cnova e agora precisamos realizar a integração entre a nossa loja e os sites do Grupo CNova. As especificações da API estão descritas neste link: https://desenvolvedores.cnova.com/api-portal/ O Developers deverá desenvolver o sistema de integração em tempo real, como atualizações diárias de controle de estoque. Ao final do JOB o sistema deverá: -…

Full Description of ** INTEGRAÇÃO PRESTASHOP / CNOVA **

Correcciones Css Y Responsive Aplicación Web

Design, Media & ArchitectureMobile Phones & ComputingHTMLjQuery / Prototype Place Bid

Fix css and responsive webapp http://test.moogo.com.co see attach file with issues.Correcciones css y responsive aplicación web http://test.moogo.com.co ver archivo adjunto con los issues, por favor cuéntame en cuanto tiempo me lo entregas, te agradezco que este tiempo sea estimado lo más concienzudo posible.

Full Description of Correcciones css y responsive aplicación web

Assessoria E Consultoria Em Vba/excel/access E Banco De Dados

Visual BasicExcelMicrosoft AccessMaterials EngineeringDOS Place Bid

Necessito de consultoria/assessoramento para criação de projetos em VBA/Excel/ACCESS. a ideia é que eu faça alguns projetos e/ou acompanhe profissional com mais experiência para adquirir mais conhecimento prático.Valores serão negociados.

Full Description of Assessoria e Consultoria em VBA/EXCEL/ACCESS e Banco de…

Web Development

Design, Media & ArchitectureWebsite DesignGraphic Design Place Bid

I need a new website. I need you to design and build a landing page. I need people to either call immediately or fill out a short form and click send.

Full Description of Web development

Courier Online Platform

Design, Media & ArchitectureWebsite DesignWordPressHTML5HTML Place Bid

Need a platform that has a website , app, geolocation capability and algorithm to determine best routes and optimise for drivers and customers . Similar to uber

Full Description of Courier online platform

Skype Interviewer - Must Be English Fluent!

ExcelEnglish (US) Place Bid

I need a Skype interviewer who will call new hires based on appoints the new hires have set on a Google Calendar, after the interview, you will send each qualified technician the new hire paperwork. BONUS: 1. Skype phone number will be provided to you for FREE calling into the United States. PAYMENT: 1. Payment is based on each new hire you will call via Skype (everyone gets offered the chance to be hired) at $3.00 per new hired worker.…

Full Description of Skype Interviewer - MUST BE ENGLISH FLUENT!