Support Board
Date/Time: Wed, 29 Oct 2025 02:25:08 +0000
[Programming Help] - Color Bar Alert Condition PAST bar (using future criteria)
View Count: 639
| [2024-01-01 17:37:16] |
| TopGunTrader - Posts: 231 |
|
Hi, There are some instances where I'd like to mark up bars that are CONFIRMED by future bars. Easiest example is a pullback where L[-2]<L[-1] and L[-1]>=L so basically the 2 bar ago low is lowest low the next two bars couldn't take that low out. I'd like to put an arrow under the L[-2] bar! Can this be done and if not can you add just like how you have offset a Past Bar Offset which would normally be 0 for current bar 1 one back 2 in this case two back? |
| [2024-01-02 15:10:02] |
| John - SC Support - Posts: 42625 |
|
You would have to use the Spreadsheet Study to do this. In Column K enter the formula you want to return a 1 or 0 (true/false), the in Column L you would use a formula like the following to shift the result back (in this case it is shifting by 1 row), you would then use that result to draw the arrow on the previous bar: =IF(ROW() = 3, 0, IF(K2, 1, 0)) For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2024-01-02 20:33:30] |
| TopGunTrader - Posts: 231 |
|
Thank you so much this is wonderful and will help me put in some signals that will keep me OUT of trouble!
|
| [2024-01-04 14:17:32] |
| TopGunTrader - Posts: 231 |
|
One last question I've modified the spreadsheet but it never saves. I've saved the chart and workspace but spreadsheet stays the same, can't figure this out.
|
| [2024-01-04 17:56:00] |
| John - SC Support - Posts: 42625 |
|
Refer to Step #5 at the following link: Using the Spreadsheet Study: Step By Step Instructions to use the Spreadsheet Study 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: