Support Board
Date/Time: Tue, 26 Aug 2025 16:29:00 +0000
Post From: Questions for experts on Spreadsheet System for Trading.
| [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 |