Support Board
Date/Time: Wed, 12 Feb 2025 09:03:24 +0000
Post From: How to look back x number of bars
| [2020-10-13 20:55:02] |
| User561641 - Posts: 4 |
|
Thanks for the response, what you suggested, did indeed work. I created several similar formulas in the Formula Columns. But, when I create an "color background on alert condition" and reference these formulas via spreadsheet columns (K3, L3, M3, etc), the alert doesn't trigger (meaning it doesn't decorate the price bar) even though the values evaluate to true. I do something super simple like an alert on "=AND(K3 > L3, L3 > M3)" for example, and even though the values in those columns on record 3 do result in a true return, the chart doesn't decorate because the alert doesn't return true. I literally have to add a constant like this for the alert to decorate: "3 > 1". I don't get it... is there caching going on or something?
|