Support Board
Date/Time: Sat, 25 Jan 2025 01:10:18 +0000
[User Discussion] - Spreadsheet function to memorize values
View Count: 1095
| [2019-02-09 09:24:00] |
| jenda3 - Posts: 21 |
|
Hi, I should have a question about the Spreadsheet. I'm using a study that is in the AA column. When a study did a signal then in AA column line 3 is shown price otherwise ther is a 0. Is there a function that remembers this price and i can use this function in line J98 (this is static column and line)? So in line J98 is last price from AA3 and the 0 price is ignored. And when AA3 shows a new price, the value in j98 will be replaced with a new value. Thanks for reply Date Time Of Last Edit: 2019-02-09 09:48:46
|
| [2019-02-09 15:13:29] |
| Sawtooth - Posts: 4162 |
|
J98 is read only; you can't write to it. If you want to 'remember' a value in column AA, you'll need to use a Formula Column to create a persistent variable. Try this: Cell P3: =IF(AA3>0,AA3,P4) Here are some other examples: Spreadsheet Example Formulas and Usage: Persistent and Incrementing Variables Spreadsheet Example Formulas and Usage: Other Examples Date Time Of Last Edit: 2019-02-09 15:49:33
|
| [2019-02-09 17:32:30] |
| jenda3 - Posts: 21 |
|
tomgilb tahnks for reply. J98 is static, but is read/write this works partially. I have set spreadshit only fort 200 bars (this equals 200 rows in spreadsheet). When i put =IF(AA3>0,AA3,P4) to cell P3 and 200 bars are passed then the value of P3 is also deleted and P3 is empty. I need remember value from AA unitl new value is shown Date Time Of Last Edit: 2019-02-09 17:33:52
|
| [2019-02-09 17:39:52] |
| jenda3 - Posts: 21 |
|
I have it To cell P3 i put this: =IF(AA3>0,AA3,P4) and then to cell j98 i put this =IF(P3>0,P3,J98) and it works |
To post a message in this thread, you need to log in with your Sierra Chart account: