BitMEX fees and profits calculator in Excel spreadsheet.
Instruction explaining how to calculate leverage for Bitcoin and other cryptocurrencies
This Bitmex calculator in a spreadsheet to compute: fees, rebates, profits, losses, leverage, liquidation price, ROE and deposit on BitMEX exchange. Free to download and use.
MinistryOfMarginTrading explained how to calculate BitMEX fees and profits for Bitcoin and other cryptocurrencies. Before you download the calculator please to read instruction at the bottom.
MinistryOfMarginTrading prepared new 1.04 version for all BitMEX cryptocurrencies! Hours of hard work!
Last update 1Nov 2019
This file is safe 100% to download. Do not download this file from other websites!
30Aug 2018 we shared it on Reddit here:
Believe us or not, but we receive at least one fat "thank you" every day. It is for FREE.
To be 100% satisfied, it is recommended to read the instruction at the bottom or watch the video.
Video: How to use our Bitmex calculator
Explained: How to use our BitMEX profits fees and leverage excel calculator when you download a spreadsheet.
This instruction will learn how to calculate your possible fees, profits, and losses before you open a trade. This is important as you can realize that it is a better idea to open fewer amounts of contracts with different leverage to succeed on BitMEX.
This calculator will help you understand how BitMEX engines work.
You can easily check our performance in the calculator for 4 different scenarios:
1) You expect that Bitcoin price will increase and you are about to open buy long - check what happens in the first column if You are right
2) You expect that Bitcoin price will increase and you are about to open buy long - check what happens in the second column if You are wrong
3) You expect that Bitcoin price will drop and you are about to open sell short - check what happens in the 3rd column if You are right
4) You expect that Bitcoin price will drop and you are about to open sell short - check what happens in the 4th column if You are wrong
Tip: All these 4 columns (scenarios) in the BitMEX calculator are independent! So every time you want to check your position details fill blue cells in 1 and 2 or 3 and 4.
Using our BitMEX spreadsheet you have to fill blue cells with 4 figures:
1) Quantity - the number of contracts that you are going to open (this is the size of your position in USD). Increasing amount is a figure that enlarges required deposit.
2) Leverage level - high level here like X25-X100 make you liquidation price very close to entry price! Avoiding liquidation is our main task as it costs a lot. Why? - we explained here.
3) Entry price - insert here what price you what to jump into the market. Using limit orders BitMEX gives you extra profit from fess (rebate +0,025% * amount of contracts) and using market order you will pay commission (0,075% * amount of contracts). More about Bitmex fees you will find here.
4) Close price - simulate how your profits will look like if you close your trade at this price. Remember that in 1 and 4 scenarios close price have to be set above entry price and in 2 and 3 scenarios close price has to be inserted at a lower price than the entry price. To make sense.
The best idea here is that you can change these 4 figures plenty of times. At the beginning, you can first fill cells with entry and close price and then you can start manipulating with quantity and leverage.
It depends on whether you use this excel spreadsheet to learn how BitMEX computes or just to estimate how big will your profit be and at what price you would get liquidated.
Check our blog about BitMEX to find the correct way to set up correct Stop Loss to avoid liquidation. Avoiding liquidation is our main task because it costs a lot.
How to read received ROE/results/profits/fees in this excel sheet for BitMEX Bitcoin trades? What does it stand for me?
Deposit BTC or cost (line 5) the amount of your BTC that BitMEX will take from your TOTAL deposited Bitcoins. "Take" means here to freeze. You still can have AVAIL BTC to open another trade if you just use part of your deposit for this trade. We are not sure why Bitmex called this... cost.
Trade value in BTC (line 6) shows your total leveraged exposition in BTC for the market. The most important is here that BitMEX uses this value to compute rebates and fees.
You invested (line 7) the same as line 6 but displayed in USD at Entry Price. Keep in mind that you open trade at BitMEX and you still own deposited BTC and you still can lose or win extra money just by keeping owned BTC (especially important when you invest with small leverage).
BTC price changed (line 10) counted in %, Entry Price vs Close Price
Trade result in BTC (line 11) this is exactly what you see at BitMEX platform in Unrealised PNL before you close the trade (remember that BitMEX displays this value by Mark Price so you must move the mouse cursor over it to see this figure by Last Price - like it is counted in this excel spreadsheet).
The same result you will see in trade history if you click account --> trade history --> and look column BTC value. But in this case, you have to find matching order (entry and close order) and do the maths (Entry Price - Close Price).
It is much easier in this calculator because BitMEX platform displays orders separated into several lines with other quantity as you could get your order filled from several different traders. And you must do a lot of maths to get a result. What is more, you can analyze to open/close the trade with several different prices.
Trade result in BTC (line 12) this is Trade result in BTC multiplied by Close Price in USD.
Result on deposited USD (line 13) the result on remaining BTC if some left (for this trade).
Total trade profit in USD (line 14) this is what interests us the most (value in the moment of closing the trade)
ROE % (line 15) Return On Equity what means you invested 2000$ in this trade you earned 400$ so ROE is 20%.
Your new USD balance will be (line 16) doesn't have to be explained :)
Your new BTC balance will be (line 17) easy to understand :)
Estimated Liquidation Price (line 18) BitMEX formula here is very complicated and we did our best to explain as precisely as possible but remember to double check it on BitMEX when you place an order as well.
Recently we added new lines in the calculator showing how to calculate BitMEX fees as well:
This part of the calculator shows us and explains all possible BitMEX fees examples.
Fees1 - calculated fees 2x by Limit Order
Fees2 - calculated fees 1x by Limit Order and 1x by Market Order
Fees3 - calculated fees 1x by Limit Order and 1x by Market Order
Fees4 - calculated fees 2x by Market Order
Thank you for appreciating our work! We always do believe in win-win.
Fees followed by "a" include your referral discounts. Have a look at what is the difference and you can check on your existing BitMEX account because maybe your previous discounts have expired. Look at the bottom violet banner.
On the end, our BitMEX calculator explains (shows) total trade profit depending on the type of order you used (lines 31-34).
Good luck! Next ver 1.05 Ministry of Margin Trading will upload on 30th of June 2019 + the next calculator will be for Ethereum perpetual. Send us your feedback about the calculator here.