Скачать или смотреть Optimize the Parameters of Trading Strategies in Excel - No Coding Required!

📟 BacktestXL Pro, the first Backtesting Framework for Excel!
🚩 www.qmr.ai/backtestxl


📈 Article with Files: https://www.qmr.ai/optimize-a-trading...

📗 Download Starting Excel File: https://quantmateresearch.com/wp-cont...

▶️ Strategy Construction in Excel (previous tutorial):    • Backtest a Trading Strategy in Excel - Int...  

✔️In this video, we will find the optimal parameters of a simple trading strategy. We will do so by using the powerful "What-If Analysis" Datatable feature that is included in Excel.

✔️ By automatically testing thousands of combinations, we will find the one that yields the highest returns (at least during the backtesting period).

❌ You should always go ahead and validate the parameters on a test set that was excluded from the parameter tuning process. Without doing so, parameter optimization will most probably lead to overfitting.