- Top Functions for Spreadsheet
- Sierra Chart Basics
- Sierra Chart Advanced
- Support
- ◀️Previous Module: @Trade Metrics Guide
- ▶️Next Module: @Options Analytics: Gexbot
- Check Out: LucidTrading
- Check out: Gexbot
Top Functions for Spreadsheet
OR function
The first formula will turn the cell to 1 (TRUE) if ID5 or ID6 =1. The second example shows a more complex variation that combines a SUM function, where 3 studies need to be True OR ID5:
#Formula 1
=OR(ID5.SG1=1,ID6.SG1=1)
#Formula 2
=OR(ID5.SG1=1,SUM(ID6.SG1,ID7.SG1,ID8.SG1)>=3)
AND function
=AND(ID5.SG1>=ID6.SG1,ID6.SG1<ID5.SG1)
Sierra Chart Basics
Getting Started
Getting Started, Opening Charts and Basic Trading
Welcome to Sierra Chart. Sierra Chart is an advanced financial market charting and trading application. It is a full-featured and complete application to meet your requirements. This page contains important step-by-step instructions for getting started with Sierra Chart, opening charts and introducing you to Trading from Sierra Chart.
www.sierrachart.com
Sierra Chart Official FAQ
Help/Frequently Asked Questions List - Sierra Chart
This page lists the descriptive titles to pages that contain answers to questions and issues you may have. If you are having a problem, then be sure to update to the Current version of Sierra Chart. To update, simply select on the Sierra Chart menu.
www.sierrachart.com
Chartbooks
Chartbooks (Workspaces)
All chart windows, Time and Sales windows, Market Depth windows, Trade windows for charts, Trade DOM windows, and Spreadsheets used by the Spreadsheet studies are contained within Chartbooks. A Chartbook is not a window. It is a collection of multiple windows. A Chartbook is like a desktop/layout/workspace for Sierra Chart.
www.sierrachart.com
Data Feed
Sierra Chart Exchange Data Feed
Sierra Chart is a professional Trading platform for the financial markets. Supporting Manual, Automated and Simulated Trading.
www.sierrachart.com
All Studies
Technical Studies Reference - Sierra Chart
Sierra Chart is a professional Trading platform for the financial markets. Supporting Manual, Automated and Simulated Trading.
www.sierrachart.com
Sierra Chart Advanced
Back Testing
Auto Trade System Back Testing
When you are using the Spreadsheet System for Trading study or you have created an ACSIL (Advanced Custom Study and Interface Language) trading system study that uses the ACSIL Trading functions, then you can perform Back Testing by using Trade Simulation Mode and replaying the chart, or by performing a Bar Based Back Test.
www.sierrachart.com
Spreadsheet Functions
Spreadsheet Functions
Related Documentation On This Page This documentation page documents all of the available Spreadsheet functions. Spreadsheet functions are entered into cells. They take parameters and data, make calculations on the parameters and data, then return the result to the same cell they are entered in.
www.sierrachart.com
Sierra Chart Support Board
Support Board
Sierra Chart is a professional Trading platform for the financial markets. Supporting Manual, Automated and Simulated Trading.
www.sierrachart.com
Support
Support Board
Support Board
Sierra Chart is a professional Trading platform for the financial markets. Supporting Manual, Automated and Simulated Trading.
www.sierrachart.com
FAQ & Basic Troubleshooting
Help/Frequently Asked Questions List - Sierra Chart
This page lists the descriptive titles to pages that contain answers to questions and issues you may have. If you are having a problem, then be sure to update to the Current version of Sierra Chart. To update, simply select on the Sierra Chart menu.
www.sierrachart.com
◀️Previous Module: Trade Metrics Guide
▶️Next Module: Options Analytics: Gexbot
Back To Handbook Home
Sierra Chart Master Handbook - Unofficial
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.