Support Board
Date/Time: Tue, 04 Feb 2025 14:47:02 +0000
Post From: Help with Referencing A Range of Data
| [2020-01-21 03:13:10] |
| sourdubber - Posts: 52 |
|
I have a question about "Referencing A Range of Data" Study/Chart Alerts And Scanning: Referencing A Range of Data In the spreadsheet, I created a custom formula using a moving average crossover and placed it in Column P3. Whenever there is a MA crossover WITHIN THE LAST 3 days and the close is below the open, I want to BUY. Here is the formula I wrote for this, to be placed in K3: =AND(SUM(P[3:5]>0,E3<B3) But I get a Syntax error. What am I doing wrong? Thanks in advance. |