BitMEX calculator for profits and fees (in Excel spreadsheets)
Explained how to calculate everything on Bitmex exchange!
This BitMEX calculator is for fees, rebates, profits, losses, leverage, liquidation price, ROE and deposits on BitMEX exchange. Free to download but please read the instruction below or watch the tutorial first.
Last update 24/01/ 2020
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 allows you to understand 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). The increasing amount is a figure that enlarges the required deposit.
2) Leverage level - high level here like X25-X100 makes 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 is to change these 4 figures plenty of times. In the beginning, you can first fill cells with entry and close price and then you can start manipulating with quantity and leverage.
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 the Last Price - like it is counted in this excel spreadsheet).
The same result you should 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).
Send us your feedback about the calculator here.
Keep in mind to use our BitMEX calculator at your own risk and the main purpose is to help investors understand how to count everything and help you to save tons of money.