Support Board
Date/Time: Sun, 23 Feb 2025 21:47:56 +0000
[Programming Help] - Simple Question - How to Highlight Once Single Candle 20 Periods In Past?
View Count: 448
| [2021-02-23 19:32:51] |
| absorrel4 - Posts: 97 |
|
I simply want to highlight the candle that is 20 bars in the past....and have this highlight continue to be the candle 20 periods in the past as the chart continuously updates. I tried a spreadsheet and it worked for an instant...then the highlight would disappear when a new bar was added to the chart. I put the following formula in the spreadsheet column o...it simply referenced the "bar numbering" study that was in column AA =if(AA3-$AA$22=0,1," ") It gave a blank for every row except row 22 (i.e., 20 bars in the past)...but, it then disappeared when a new bar was added to the chart. Must be a simple way to do this?
|
| [2021-02-23 23:47:18] |
| Sawtooth - Posts: 4174 |
|
Try this formula in row 3 of a spreadsheet Formula Column: =ROW()-22=0 |
| [2021-02-24 03:49:26] |
| absorrel4 - Posts: 97 |
|
Perfect...thanks...
|
To post a message in this thread, you need to log in with your Sierra Chart account: