Login Page - Create Account

Support Board


Date/Time: Fri, 01 Mar 2024 23:47:34 +0000



Post From: Automated Trading System AND logic

[2019-07-17 19:22:51]
Sawtooth - Posts: 3933
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))