Support Board
Date/Time: Thu, 23 Jan 2025 21:29:36 +0000
Post From: Heikin-Ashi with Spreadsheet for Trading Studies.
| [2018-12-08 21:00:19] |
| Sawtooth - Posts: 4162 |
|
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) |