Support Board
Date/Time: Sat, 23 Nov 2024 22:26:16 +0000
Post From: user2user question regarding excel formula - not a technical SC issue.
| [2013-08-13 20:16:18] |
| namlem - Posts: 94 |
|
Hello traders, many times I write alert formulas in a worksheet, assume in cell O3. For example, if price above moving average E3>AA3 then draw an arrow at the price and automatically trigger an alert: =IF(E3>AA3,E3,FALSE) (I know I can write it without IF, but this is just a simplified example, in reality it is more complex). now I want to show only one (first) arrow per 20 (next) bars (sometimes i need to show only one arrow/signal per day), what I do is: =IF(and(E3>AA3,sum(O4:O24)=0),E3,FALSE) the problem is, I noticed that this "sum(O4:O24)" is very CPU demanding operation, especially when I do calculations for 30k or more bars and/or in SUM use more than 100 bars... my question: are there any cheaper ways how to show only one signal per X bars? Thanks |