Support Board
Date/Time: Tue, 04 Nov 2025 03:03:10 +0000
Spreadsheet System for Trading - Locking the cell position
View Count: 315
| [2024-02-27 15:52:56] |
| User951086 - Posts: 26 |
|
I have started using the "SpreadSheet System for Trading" study, whenever I type in the number or text in the formula columns, it automatically keeps moving my data in the subsequent rows as more price bars form. I want to dedicate 2 COLUMNS for my one-time calculations that I don't want to apply on any other rows, so necessarily, I want to lock in a cell position. Can someone please guide how to achieve this? |
| [2024-02-27 17:21:18] |
| John - SC Support - Posts: 42737 |
|
You would need to create a new sheet and put your one-time calculations in that other sheet, then reference those cells in the sheet for the Spreadsheet System for Trading. Refer to the following: Working with Spreadsheets: References to Other Sheets within a Spreadsheet For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
To post a message in this thread, you need to log in with your Sierra Chart account: