Support Board
Date/Time: Wed, 19 Mar 2025 07:45:55 +0000
[Programming Help] - Spreadsheet programming question
View Count: 507
| [2022-10-12 16:33:37] |
| User183724 - Posts: 194 |
|
hope this makes sense... I want to prevent row 4 and below from changing after the sheet scrolls and row 3 becomes row 4. any formula in row 3 should change as it normally would but after it becomes row 4 and below, it can no longer be updated. hope that makes sense. thanks |
| [2022-10-12 20:01:44] |
| Sawtooth - Posts: 4186 |
|
Use an absolute reference to row 3 in your formulas, by preceding the row# with $. Working with Spreadsheets: Relative and Absolute References |
| [2022-10-12 23:49:11] |
| User183724 - Posts: 194 |
|
thx that makes all the rows below 3 equal to row 3. what im looking to do is allow row 3 to work normally but freeze row 4 and below with whatever their last 'row 3' value was. I'm thinkin its time to learn ACSIL. I havent programmed in cpp in over 30 years and was kind of hopin that door was closed but here we are trying to do something in the most restrictive spreadsheet ever devised that cpp would do in 4 or 5 lines.
|
| [2022-10-13 00:18:29] |
| Sawtooth - Posts: 4186 |
|
It's not possible to make an intrabar value persistent in a spreadsheet study. Only close-of-bar values can be made persistent. Here are some examples: Spreadsheet Example Formulas and Usage: Persistent and Incrementing Variables Spreadsheet Example Formulas and Usage: Return Last Two Zig Zag Reversal Values You can only make an intrabar TRUE (not a value) persistent, using this method: Spreadsheet Studies Special Tasks: Locking the State of a One Time Condition https://www.sawtoothtrade.com/example-9.html |
| [2022-10-13 01:25:26] |
| User183724 - Posts: 194 |
|
thanks man. I've already gave up on that one and moved on ... thanks again
|
To post a message in this thread, you need to log in with your Sierra Chart account: