Note: There are many possible ways to manage trades and orders for backtests. For the purpose of the demonstration, the Buy and Sell signals will be formula based, and the management of those orders will be done through a pre-configured Order Window.
Backtest Guide covers the following:
- Back test signals and trades using Sierra spreadsheet
- Export data for back testing bar and study data
Backtesting Cheat Sheet:
- Prepare chart(s) and study settings for back testing
- Formulas in the Buy/Sell cells (K3, M3) of spreadsheet
- Disconnect data feed then run Autotrade Replay Backtest
- Title Bar: Trade > Auto Trading Enabled - Global
- Chart> Chart Settings > Trading menu: Always Simulative Bid and Ask Prices During Replay: Yes
- Disconnect from Data feed prior to running backtest
A signal backtest uses bar data and study data functions to generate signals. This is done while Disconnected to data feed, and in the following examples using the Spreadsheet System for Trading study.
The spreadsheet contains bar and study data, with row 3 being the current forming bar. There are columns for Buy Entry and Sell Entry which is how signal logic is created. These signals when true (value of 1) will paint markers on the charts (or take trades if Autotrader is enabled).
It is possible to both forward test live trades when signals are true, or backtest those signals which can be fully traded, and results exported for analysis.
While there may not be an abundance of videos around this, Youtube does have some how-to videos for back testing which can be helpful.
Tip: By default, a Sierra Chart spreadsheet will come with 16 blank columns for traders to utilize. To increase this simply open the Settings and Inputs window for the spreadsheet and adjust ‘Number of Formula Columns’ to the desired figure.
Back To Handbook Home
Please be aware that the information contained in this handbook is not intended to be and should not be taken as financial advice. The creator is not a financial advisor and the materials provided should not be relied upon in making any financial decisions. Any actions taken based on the information contained in this handbook are taken at the reader's own risk and the creator will not be held liable for any losses or damages resulting from such actions.
In addition, the creator is not a registered broker or financial advisor in the United States and the materials contained in this handbook do not constitute financial advice or a recommendation to buy or sell any financial instrument. The creator does not endorse or recommend any particular investment strategy and the reader should not rely on any information contained in this handbook as the basis for making any investment decisions.
Furthermore, past performance is not indicative of future results and the reader should be aware that trading futures, crypto, stocks, and NFTs carries a high degree of risk and the possibility of significant losses. The reader should carefully consider their financial situation and seek independent financial advice before making any investment decisions.
The creator of this handbook is not an expert and the materials contained within are provided for educational and entertainment purposes only. No material contained in this handbook suggests a specific method or strategy for investing or trading, and under no circumstances should anything contained in this handbook or any related materials be considered as financial advice.
Please also be aware that some pages within this handbook may contain affiliate links that pay the creator a small commission at no additional cost to the reader. The inclusion of these links does not constitute a recommendation or endorsement of the products or services being advertised and the reader should carefully evaluate the suitability of any product or service before making a purchase.
By accessing and using the materials contained in this handbook, the reader acknowledges and agrees to the terms of this disclaimer and releases the creator from any liability for financial losses or damages resulting from the reader's use of the materials contained within. It is possible to lose more than the value of a trading account. Nothing within this handbook is advice or a recommendation to the reader. Any damages or losses following changes the reader makes to Sierra Chart after reading material within this handbook the creator should not be held liable. This handbook is NOT created by Sierra Chart and is not an official handbook to Sierra Chart. Each purchase only grants the user associated with the email provided on checkout for lifetime access. Trading is risky.