Support Board

Date/Time: Fri, 26 Apr 2024 22:30:07 +0000

Post From: user2user question regarding excel formula - not a technical SC issue.

[2013-08-13 20:16:18] Link To Thread - Link To Post [Go To First Post]
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