Support Board
Date/Time: Mon, 17 Mar 2025 17:32:58 +0000
Post From: Spreadsheet trading & Backtests
| [2022-08-11 00:35:06] |
| tuanluu20902 - Posts: 24 |
|
I have several question regarding spreadsheet trading & backtesting process: 1. Is it possible split exits (profit taking) into multiple targets? Each target is calculated as a function of multiples of ATRs from the entry level. Setting a target via the Trade Window is not an option because it is static. 2. How to backtest more accurately, it seems that when backtesting, entry is taken only at the candle's high/low/close and not a realistic entry that would be taken live as the data is forming a. For example, during live trading - let's say the entry is to buy when the candle hits the 20EMA, that would be where the live entry is. However, during backtest, the entry would be at the candle's high/low/close (depending on the setting) which would make the backtest result incorrect. So far the only solution I've found to this is to backtest via Live Replay but that takes a ton of computing power & time to run the live replay. |