Create Excel averaging down trade calculator BTC Spot & Inverse on ByBit
Budget: $30 – $250 USD
I need two Google Sheets calculators for Bitcoin (BTC) trading to aid in strategizing BTC Spot and Inverse Perpetual trades by providing necessary entry prices and quantities to result in an average price.
Scope of Work:
1. BTC Spot Averaging Down Calculator (I can provide my current examples of this, I built one and found one online):
- Development of a calculator for inputting current BTC price, total budget, current average price, the amount of BTC currently owned, drawdown percentage, and drawdown price based on the percentage.
- The calculator will determine the desired average price as a ratio of the drawdown percentage.
- Creation of a table showing incremental additional purchases by price point, BTC quantity, and additional amount required to achieve the target average within the available budget.
- Example: For a total budget of $10,000 and a current BTC price of $40,000, the calculator will determine how much to buy at $40,000 and at subsequent price points down to $10,000 (a 75% price drawdown) to achieve an average purchase price of $15,000.
2. BTC Inverse Perpetual Calculator:
- Construction of a second calculator for Bitcoin Inverse Perpetual trading, incorporating necessary calculations and formulas.
- Integration of functions such as Profit/Loss, Target Price, Liquidation Price, and Entry Price from the Bybit Inverse BTCUSD calculator into a unified table output
- incorporating all the functions of their calculator shown here: https://www.bybit.com/trade/inverse/BTCUSD ((look for the calculator button on the upper right side just below the trade button and immediately next to the margin multiplier) - see more information here: https://www.bybit.com/tr-TR/help-center/article/How-to-use-Bybit-calculator
- Inverse Example: The user inputs a similar scenario as above with a starting position, target profit, and stop-loss parameters. The calculator will provide the necessary additional order quantities at various price levels to achieve the same via averaging down but considering 1x-10x leverage (even 1x has a liquidation point on Inverse), consider the desired profit ROI % and required price point for that, determine the target and liquidation prices, and adjust the entry prices to meet the desired outcomes, and display all this information in a table based on necessary input variables.
Deliverables:
- Two comprehensive Google Sheets calculators:
1. BTC Spot Averaging Down Calculator.
2. BTC Inverse Perpetual Calculator.
- User-friendly data entry fields, output table thoroughly tested for accuracy that aligns.
- Detailed documentation explaining the usage, input fields, and output interpretation for both calculators.
- All necessary iterations to get it to work as needed
I would like for it also to work in Google Sheets if possible.
Scope of Work:
1. BTC Spot Averaging Down Calculator (I can provide my current examples of this, I built one and found one online):
- Development of a calculator for inputting current BTC price, total budget, current average price, the amount of BTC currently owned, drawdown percentage, and drawdown price based on the percentage.
- The calculator will determine the desired average price as a ratio of the drawdown percentage.
- Creation of a table showing incremental additional purchases by price point, BTC quantity, and additional amount required to achieve the target average within the available budget.
- Example: For a total budget of $10,000 and a current BTC price of $40,000, the calculator will determine how much to buy at $40,000 and at subsequent price points down to $10,000 (a 75% price drawdown) to achieve an average purchase price of $15,000.
2. BTC Inverse Perpetual Calculator:
- Construction of a second calculator for Bitcoin Inverse Perpetual trading, incorporating necessary calculations and formulas.
- Integration of functions such as Profit/Loss, Target Price, Liquidation Price, and Entry Price from the Bybit Inverse BTCUSD calculator into a unified table output
- incorporating all the functions of their calculator shown here: https://www.bybit.com/trade/inverse/BTCUSD ((look for the calculator button on the upper right side just below the trade button and immediately next to the margin multiplier) - see more information here: https://www.bybit.com/tr-TR/help-center/article/How-to-use-Bybit-calculator
- Inverse Example: The user inputs a similar scenario as above with a starting position, target profit, and stop-loss parameters. The calculator will provide the necessary additional order quantities at various price levels to achieve the same via averaging down but considering 1x-10x leverage (even 1x has a liquidation point on Inverse), consider the desired profit ROI % and required price point for that, determine the target and liquidation prices, and adjust the entry prices to meet the desired outcomes, and display all this information in a table based on necessary input variables.
Deliverables:
- Two comprehensive Google Sheets calculators:
1. BTC Spot Averaging Down Calculator.
2. BTC Inverse Perpetual Calculator.
- User-friendly data entry fields, output table thoroughly tested for accuracy that aligns.
- Detailed documentation explaining the usage, input fields, and output interpretation for both calculators.
- All necessary iterations to get it to work as needed
I would like for it also to work in Google Sheets if possible.