Support Board
Date/Time: Wed, 07 May 2025 19:48:54 +0000
Question - Spreadsheet Formulas
View Count: 1522
| [2013-07-16 15:36:53] |
| 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
|
| [2013-07-16 16:15:35] |
| |
|
=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 |
To post a message in this thread, you need to log in with your Sierra Chart account: