Login Page - Create Account

Support Board


Date/Time: Sun, 28 Apr 2024 22:36:10 +0000



spreadsheet formula question

View Count: 568

[2017-06-29 14:28:59]
User498548 - Posts: 5
I would like to combine 2 formula on the spreadsheet but I dont know how it works.
my 1st indicator formula works
=(ID1.SG2@3>0) this is for Buy signal, Now I want to add Bollinger band to this formula: IF candlesticks passed the Bollinger band (upper band) then make an action.
bollinger band upper band is ID3.SG1
Thanks
[2017-06-29 17:34:58]
Sierra Chart Engineering - Posts: 104368
Use the AND Spreadsheet function for this:
http://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#AND_Function
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service:
Sierra Chart Teton Futures Order Routing

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account