Support Board

• Support Board |
• Search Board |
• Control Panel |
• View My Posts / Threads |
• Direct Messages

Date/Time: Tue, 30 Apr 2024 08:04:33 +0000

Question - Spreadsheet Formulas

View Count: 1364

[Page 1 of 1] First Page -- 1 -- Last Page

[2013-07-16 15:36:53] #1 [Go To First Post]
Richard Reyes - Posts: 98
Regarding a spreadsheet formula like (AA3:AA5,AB3:AB5), I understand the "AA" and "AB" as relating to my 2 moving averages crossing, but what does the "3" and the "5" refer to and how do they work with the chart and the spreadsheet formula. Chart is based on 1 hour bars. Many Thanks
0x Thank you

[2013-07-16 16:15:35] #2 [Go To First Post]
Sierra Chart - Max - Posts: 5597
=MAX(AA3:AA5), will return the Maximum value found between cells AA3, AA4 and AA5. These cells would be referring to values for the last 3 bars. Please refer to the Overview of Spreadsheet Studies: http://www.sierrachart.com/index.php?l=doc/doc_WorksheetStudy.html Sierra Chart Support
0x Thank you

[Page 1 of 1] First Page -- 1 -- Last Page