Login Page - Create Account

Support Board


Date/Time: Fri, 03 May 2024 14:52:11 +0000



Post From: VWAP FORMULA FOR SPREADSHEET

[2021-06-01 23:13:34]
Sawtooth - Posts: 3992
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