Support Board

Date/Time: Fri, 03 May 2024 14:31:35 +0000

Post From: VWAP FORMULA FOR SPREADSHEET

[2021-06-02 20:08:54] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 3992
If the result of the formula is TRUE/FALSE, or 1/0, you don't need to use the IF function. You only need to use the IF function when the result is a value. =AND(CROSSFROMBELOW(E3:E4,ID4.SG1@3:ID4.SG1@4),AE1=AA) is the same as =IF(AND(CROSSFROMBELOW(E3:E4,ID4.SG1@3:ID4.SG1@4),AE1=AA),1,0) Both formulas would return 1 or 0 when the Last price crosses the VWAP, and AE1 is already equal to AA, compared to the previous bar. You can get an idea of spreadsheet syntax from looking at the available functions: Spreadsheet Functions