Support Board
Date/Time: Mon, 25 Nov 2024 15:03:37 +0000
Spreadsheet System for Trading - Locking the cell position
View Count: 173
| [2024-02-27 15:52:56] |
| User951086 - Posts: 23 |
|
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: 36244 |
|
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: