Hello everyone!
This is a tutorial video on how to use Excel to backtest your strategies using technical indicators on Tradingview.
This provides the foundations for you to get creative and have the essential tools and knowledge required to begin back-testing your strategies using Excel.
There is much more than can be done using Excel for back-testing, so if you are interested in seeing more in-depth functionality for more advanced back-testing methods, let me know below!
The essential functions in this video are the conditional functions of Excel. These are the "If" "Then" statements.
The code used to identify conditions are:
Single condition:
=if(condition1,"Result1","Result2")
More than One Condition:
=if(and(condition1, condition2, condition3, etc.),"Result 1", "Result 2")
If you do not have Excel, you can use OpenOffice which is opensource and free to use!
As always, let me know your questions and comments below!
Safe trades everyone!
This is a tutorial video on how to use Excel to backtest your strategies using technical indicators on Tradingview.
This provides the foundations for you to get creative and have the essential tools and knowledge required to begin back-testing your strategies using Excel.
There is much more than can be done using Excel for back-testing, so if you are interested in seeing more in-depth functionality for more advanced back-testing methods, let me know below!
The essential functions in this video are the conditional functions of Excel. These are the "If" "Then" statements.
The code used to identify conditions are:
Single condition:
=if(condition1,"Result1","Result2")
More than One Condition:
=if(and(condition1, condition2, condition3, etc.),"Result 1", "Result 2")
If you do not have Excel, you can use OpenOffice which is opensource and free to use!
As always, let me know your questions and comments below!
Safe trades everyone!
Get:
- Live Updates,
- Discord access,
- Access to my Proprietary Merlin Software,
- Access to premium indicators,
patreon.com/steversteves
Now on X!
- Live Updates,
- Discord access,
- Access to my Proprietary Merlin Software,
- Access to premium indicators,
patreon.com/steversteves
Now on X!
Penafian
Maklumat dan penerbitan adalah tidak bertujuan, dan tidak membentuk, nasihat atau cadangan kewangan, pelaburan, dagangan atau jenis lain yang diberikan atau disahkan oleh TradingView. Baca lebih dalam Terma Penggunaan.
Get:
- Live Updates,
- Discord access,
- Access to my Proprietary Merlin Software,
- Access to premium indicators,
patreon.com/steversteves
Now on X!
- Live Updates,
- Discord access,
- Access to my Proprietary Merlin Software,
- Access to premium indicators,
patreon.com/steversteves
Now on X!
Penafian
Maklumat dan penerbitan adalah tidak bertujuan, dan tidak membentuk, nasihat atau cadangan kewangan, pelaburan, dagangan atau jenis lain yang diberikan atau disahkan oleh TradingView. Baca lebih dalam Terma Penggunaan.