Support Board

Date/Time: Fri, 26 Apr 2024 00:38:45 +0000

Post From: Help with Referencing A Range of Data

[2020-01-21 03:13:10] Link To Thread - Link To Post [Go To First Post]
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.