Support Board
Date/Time: Tue, 26 Aug 2025 16:26:41 +0000
[Programming Help] - Questions for experts on Spreadsheet System for Trading.
View Count: 342
| [2025-05-14 16:41:52] |
| 2garin - Posts: 188 |
|
Good afternoon. I often check a certain range of values in formulas: 0.0011 < X < 0.0013. How can I define (write) constants in the Spreadsheet System for Trading table and refer to them, or create (define) a range and check its occurrences? |
| [2025-05-14 19:26:07] |
| 2garin - Posts: 188 |
|
Let me clarify the question: is it acceptable to use cells in the range O1 - Z1 for writing constants?
|
| [2025-05-14 20:59:30] |
| John - SC Support - Posts: 41476 |
|
is it acceptable to use cells in the range O1 - Z1 for writing constants?
Yes and No. What you need to consider is that the Spreadsheet studies do two things in particular: - Any "Formula" column (as defined by the Input for "Number of Formula Columns") is going to take an entry and replicate it down the column. This is to fill in the information for each bar in the chart. - Any study added to the chart will have its data displayed starting at the end of the Formula Columns and extra columns as defined by the Input for "Blank Columns Before First Study". Therefore, whether you can use O to Z columns for constants depends on the way you have your spreadsheet setup. Here are the options: - Use the I or J columns far enough down to ensure that the data that is written into those columns will not overwrite your constants. - Add some columns using the "Blank Columns Before First Study" and then use those columns for the constants. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2025-05-14 21:32:31] |
| Sawtooth - Posts: 4261 |
|
Here are 3 more options: - Column H is a free and open column. (Columns I & J could at sometime in the future have new outputs in cells that are open today.) - Row 1 is open in all Formula Columns K-Z...BR, depending on the Number of Formula Column setting 16-60. - You can add a blank sheet that is not associated with a chart# (Spreadsheet >> Add Sheet), and reference its cells like this: =Constants!A1 (It is best practice to give it a name, and not accept the default name.) Working with Spreadsheets: References to Other Sheets within a Spreadsheet Note: Columns K-Z are Formula Columns, which auto-populate, so IMO it's best practice to not use them for constants. Date Time Of Last Edit: 2025-05-14 21:36:52
|
| [2025-05-14 21:33:53] |
| 2garin - Posts: 188 |
|
if I understood your answer correctly. constants should be written in columns I and J in rows below 114, right? while waiting for an answer, I conducted an experiment: I wrote constants in cells O1-Z1, selected the number of decimal places, wrote a formula in cell R3, I refer to the cell with the constant using $ symbols from the formula, the formula works correctly. question: is it acceptable to use this method, won't the table use (rewrite) the cells in the first row? |
01.png| [2025-06-12 13:20:43] |
| Sawtooth - Posts: 4261 |
|
is it acceptable to use this method, won't the table use (rewrite) the cells in the first row?
Row 1 of Formula Columns are free and open cells; they won't get overwritten.IOW, only Rows 3 and below will auto-populate. |
To post a message in this thread, you need to log in with your Sierra Chart account: