Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Mon, 29 Apr 2024 13:24:50 +0000

How to Post a Message for Support

Post From: Automated Trading System AND logic

[2019-07-17 19:22:51]
[Go To First Post]
Sawtooth - Posts: 3983
The Volatility Trend Indicator study appears to be similar to the Parabolic study, in that if price crosses the previous value, it switches sides.

The formulas in post#4 could be used to find the transitions (direction change):
Color Background Based on Alert Condition and the Parabolic SAR (PSAR)

To convert them for a spreadsheet study:
VTI moves below price bar (transition to upslope):
=AND(ID2.SG1@4>=C4,D3>=ID2.SG1@3)
VTI moves above price bar (transition to downslope):
=AND(ID2.SG1@4<=D4,C3<=ID2.SG1@3)

If you want a +1/-1 persistent output in the same column, e.g. cell P3:
=IF(AND(ID2.SG1@4>=C4,D3>=ID2.SG1@3),1,IF(AND(ID2.SG1@4<=D4,C3<=ID2.SG1@3),-1,P4))