Login Page - Create Account

Support Board


Date/Time: Sat, 28 Dec 2024 01:44:16 +0000



Post From: No backtesting results

[2015-11-10 20:55:40]
Sawtooth - Posts: 4143
I use the Spreadsheet System for Trading. Can you please explain me how I get Prices in the row 3 when I use the swing high and low as a Trigger. When the last swing high or low is a few candles away then there not Prices in the newest row. For example, the Daily OHLC wrote the same Price in each row and i can use it as a Trigger.

This will bring the most recent non-zero to row 3 of column K:
=IF(AA3>0,AA3,K4)
where AA is the Swing High and Low study.

See attached for an example
attachmentSwing HL extended.cht - Attached On 2015-11-10 20:54:50 UTC - Size: 38.33 KB - 413 views
attachmentSwing HL extended.scss - Attached On 2015-11-10 20:55:05 UTC - Size: 104.77 KB - 359 views