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

Sierra Chart Official FAQ

Help/Frequently Asked Questions List - Sierra Chart

Chartbooks

Chartbooks (Workspaces)

Data Feed

Sierra Chart Exchange Data Feed

All Studies

Technical Studies Reference - Sierra Chart

Sierra Chart Advanced

Back Testing

Auto Trade System Back Testing

Spreadsheet Functions

Spreadsheet Functions

Sierra Chart Support Board

Support Board