Support Board
Date/Time: Sun, 29 Jun 2025 22:53:55 +0000
Post From: VWAP FORMULA FOR SPREADSHEET
| [2021-06-02 20:08:54] |
| Sawtooth - Posts: 4231 |
|
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 |