Contents:
- Color Bar When Condition is True
- Spreadsheet Formula Study
- Create a Custom Oscillator
- Create Market Depth Graphs
- Create Volume Footprint Charts
- Automated Trading
- TPO Configuration
- Add TPO to a chart
- ◀️Previous Module: @Studies Guide
- ▶️Next Module: @ACSIL
In this module, multiple general examples will be used to demonstrate more advanced concepts. Only proceed to this module after finishing the Studies Guide. This guide is written assuming an intermediate level understanding of Sierra Chart.
To view the mini-guide on individual studies CLICK HERE
Color Bar When Condition is True
Example: Color the bar when the high of a bar goes above the top band of a bollinger deviation band.
- Open a chart
- Studies
- Add Bollinger Bands study
- Add Color Bar Based on Alert Condition study
- Alternatively, can use Color Background Based on Alert Condition for coloring the background
- Open Study Settings for the Color Bar Based on Alert Condition study
The steps to set this up
- Settings and Inputs tab:
- Number of bars to calculate: As needed
- Change additional settings as needed
- Subgraphs tab:
- Choose the color for coloring
- Set the Draw style as needed. Default colors the bar but easily change this to a different draw style. Example: Diamond.
- Alerts tab
- Type a formula into the alert condition cell:
=ID0.SG2>=ID2.SG1
//ID0.SG2 IS THE HIGH OF BAR
//ID2.SG1 IS THE TOP BOLLINGER BAND
//LOGIC IS: HIGH OF BAR IS GREATER OR EQUAL TO TOP BOLLINGER BAND TRUE, OTHERWISE 0
Spreadsheet Formula Study
The Spreadsheet Formula study is great for writing a formula to calculate and to return a drawing. Example: Condition 1 = True then make draw a star on the chart
- Open a chart
- Studies
- Add the Spreadsheet Formula study
- Open Study Settings
- Write out any formula in the Input Value field for Formula
- Switch to the Subgraphs tab
- Adjust the Draw Style as desired
- OK
Create a Custom Oscillator
Example: Instead of drawing cumulative delta as a bar or line it’s drawn an oscillator.
- Open a chart
- Studies
- Add the Cumulative Delta Bars - Volume study
- Add the Ask/Bid Volume Difference Bars study (or Zig Zag study, both work)
- Study Settings
- Change the ‘Based On’ to Cumulative Delta Bars study
- OK
Create Market Depth Graphs
Depth Graphs are great for visualizing resting orders. The coloring method can be either based on actual values or percentage based.
Going over multiple depth design examples.
Classic Map Style Depths with Bid/Ask Lines
Only Show Large Orders
Blue Bid Red Ask Vista
Market Depth Graph Settings to be aware of:
- Use Percent or Actual Values: Choose between percentage based or value based
- Actual Color Thresholds: Choose 3 numbers separated by comma. Example: 100,200,300
- Extend Last Known Depth: This uses the last data point available for depths further out
- Show Quantity Numbers: Able to see actual values of depths at each level
- Display Market Depth Quantities After Last Bar: Extends depths to right margin area
- Maximum Levels to Display: 0 for all or set a custom number of levels of depth to display
Create Volume Footprint Charts
Tip: To access the template Footprint chart CLICK HERE
Volume footprint charts show volumes and deltas of bid and ask prices. There are many combinations and ways to visualize the data. From simple text, to text with volumes profile, to text volume profile and candlestick.
The following examples all share the same setup:
- Open a new chart
- SC Menu: Chart > Chart Settings > Bar Period > set Bar Period and Setting to desired
- SC Menu: Analysis > Studies (Or click Studies on the control bar)
- Numbers Bars study add
- Select by clicking the Numbers Bars study
- Settings
Next, here are settings for 5 different footprint styles:
Bid Ask Delta Profile with Candlestick Outline
Bid Ask Volume with Candlestick inside
Only Show Significant Sized Volume or Delta Prices
Footprint with Text Values in Table Below
Footprint Numbers on Left - Profile on Right
Automated Trading
Trading can be fully automated in Sierra Chart. Optional to begin building from scratch or follow along using the provided chartbook and spreadsheet HERE. There are many combinations of trade order management possible. This example creates a BUY and SELL signal and the stop loss and target are pre-configured in the Trade Window.
This is NOT financial advice. For entertainment only. Just an example. Not a strategy. Creator of this handbook assumes no liability for automated trading results.
Here is an example of setting up automated trading:
- Open a new chart
- SC Menu: Trade > Auto Trading Enabled - Global is checked
- Or, Auto Trading Enabled - Chart is checked
- SC Menu: Trade > Attach Trade Window to Chart
- SimpleBracket is selected under the order configuration
- Setup Targets from the Targets tab:
- SC Menu: Analysis > Studies (Or click Studies on Control Bar)
- add any studies required for the logic of buying and selling
- In this Example adding two studies:
- Moving Average - Simple (Set to 5)
- Moving Average - Simple (Set to 21)
- add Spreadsheet System for Trading
- Settings
- Spreadsheet Name:
- Type in any name (Example: auto_trade_spreadsheet - included HERE)
- Changing Input Values of the Input Name options:
- Number of Formula Columns: Increase if needing many extra columns for logic
- Signal Only Once Per Bar: Yes
- Allow Entry With Working Orders: Yes
- Maximum Position Allowed: 12
- Send Orders To Trade Service: ONLY WHEN READY TO GO LIVE
- Allow Opposite Entry with Opposing Position or Orders: No
- Cancel All Working Orders on Exit: Yes
- Minimum Chart Bars Required for Entry Excel Cell…….. : 1
- OK on Study Settings window
- OK on Chart Studies window
- A new spreadsheet should pop-up, it may be hidden behind other charts
Now, it’s time to create the signal for buy/sell.
- Always understand the desired signal to trigger a buy or sell. In this case:
- Buy when 5 moving avg cross from below 21 moving average, expressed in Cell K3 of spreadsheet
- Sell when 5 moving average cross from above the 21 moving average, expressed in Cell M3 of spreadsheet
- Open the newly created spreadsheet (Example file is ‘auto_trade_spreadsheet)
Tip: It’s recommended to read the official documentation for spreadsheets written by Sierra Chart:
- In cell K3 (Buy Cell) paste the following formula:
=CROSSFROMBELOW(AA3:AA5,AC3:AC5)
AA is Simple Moving Average 5
AC is Simple Moving Average 21
The recent bars are including in comparison to
detect crossover
- In cell M3 (Sell Cell) paste the following formula:
=CROSSFROMABOVE(AA3:AA5,AC3:AC5)
Final Checklist to Ensure Auto Trader takes Trades:
Ready to go. With these studies setup as described, trades will be taken when the signal is True. It is possible to back test these signals using the Replay feature.
To switch to live trading:
- SC Menu: Trade > Trade Simulation is un-checked
- Trading is un-locked
- SC Menu: Anaylsis > Studies
- Click to highlight the Spreadsheet auto trading study
- Settings
- Send Orders to Trade Service: Yes
Official Automated Trading Documentation from Sierra Chart:
TPO Configuration
TPO or Time Price Opportunity is used by market profile traders to analyze price and time of different time frames. There are many technical and visual settings available to highly customize the values.
Add TPO to a chart
- Open a chart
- SC Menu: Analysis > Studies (Or Studies on the task bar)
- Add>> the TPO Profile Chart study and press OK
Tip: Ensure enough days are loaded, and the rollover settings support a longer term chart
Basic TPO Customizations
TPO + Volume Profile
Custom TPO Session Times
Official Sierra Chart TPO Documentation:
◀️Previous Module: Studies Guide
▶️Next Module: ACSIL
Back To Handbook Home
Sierra Chart Master Handbook - UnofficialPlease 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.