Support Board
Date/Time: Thu, 28 Nov 2024 23:51:09 +0000
Post From: Adding a filter to color background based on alert condition study
| [2023-03-27 16:15:04] |
| ForgivingComputers.com - Posts: 960 |
|
Have you worked with Sierra Chart spreadsheets before? They are similar but not the same as Excel spreadsheets. The major difference is the rows, columns, and specific cells have unique features. Rows 1 and 2 are Header Rows, the most important being row 2. Rows 3 and higher have one chart bar per row, with the base data in columns A-G. (Date/Time, Open, High, Low, Close, Volume and Number of trades). User Formulas begin in Column K, with a default of 16. Up to 60 formulas can be used. Study data starts in Column AA (or the first column after the user formulas. Other trading-related variables are available in columns H and J. When you create a user formula, you enter it in Row 3, and it will be propagated down with any cell references automatically being adjusted. For example, if Cell K3 has the formula for the range of a bar (High-Low). The formula in K3 would be =(C3-D3) The spreadsheet will automatically refresh the rows below, so cell K4 would have: =(C4-D4)
It is a best practice to use the "IDxSGy@z" notation for study data cell references, instead of the column name ("AA3"). This will prevent issues that will arise if studies are moved or added to the chart before the last study. The direct cell reference will not be updated if the columns are rearranged by changing the study list, as the ID/SG is less likely to change. If the Sierra Chart documentation is too much to digest at once, you can get a lot of useful information from Tom Gilb's website https://www.sawtoothtrade.com/ Tom is active on the board and answer most spreadsheet questions. |