Login Page - Create Account

Support Board


Date/Time: Thu, 27 Feb 2025 12:56:13 +0000



Post From: VWAP FORMULA FOR SPREADSHEET

[2021-06-01 23:13:34]
Sawtooth - Posts: 4176
Try this:

Cell K3:
=CROSSFROMBELOW(E3:E4,ID1.SG1@3:ID1.SG1@4)
Cell M3:
=CROSSFROMABOVE(E3:E4,ID1.SG1@3:ID1.SG1@4)
where the VWAP study is ID1; edit as needed.

https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#CROSSFROMABOVE_Function