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

Sierra Chart Advanced

Back Testing

Auto Trade System Back Testing

Spreadsheet Functions

Spreadsheet Functions

Sierra Chart Support Board

Support Board

Support