Support Board

Date/Time: Wed, 01 May 2024 23:14:57 +0000

Post From: Heikin-Ashi with Spreadsheet for Trading Studies.

[2018-12-08 21:00:19] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 3987
The formulas would be the same, regardless of the colors: Buy, cell K3: =AND(ID1.SG4@4<ID1.SG1@4,ID1.SG4@3>ID1.SG1@3) Sell, cell M3: =AND(ID1.SG4@4>ID1.SG1@4,ID1.SG4@3<ID1.SG1@3) But to avoid a missed signal at a doji, you'll need to use a variation of this in another Formula Column, e.g. in cell T3 : ... Spreadsheet Example Formulas and Usage: Formula that Matches the Coloring of Up and Down Price Bars =IF(OR(ID1.SG4@3>ID1.SG1@3,AND(ID1.SG1@3>ID1.SG4@4,ID1.SG1@3=ID1.SG4@3)),1,IF(OR(ID1.SG4@3<ID1.SG1@3,AND(ID1.SG1@3<ID1.SG4@4,ID1.SG1@3=ID1.SG4@3)),-1,T4)) ...then find the transitions: Buy, cell K3: =AND(T4=-1,T3=1) Sell, cell M3: =AND(T4=1,T3=-1)