Support Board
Date/Time: Thu, 20 Mar 2025 00:19:29 +0000
Post From: Spreadsheet and Heikin Ashi
| [2022-10-28 03:51:27] |
| Sawtooth - Posts: 4186 |
|
What is formula to put in a spreadsheet for autotrading for the Heikin Ashi switching from down to up. In other words switching colors.
If the Heikin Ashi is set to Display as Main Price Graph, use this example:Spreadsheet Example Formulas and Usage: Formula that Matches the Coloring of Up and Down Price Bars If the Heikin Ashi is displayed in another Chart Region, use these substitutions: B3: ID1.SG1@3 E3: ID1.SG4@3 E4: ID1.SG4@4 where ID1 is the Heikin Ashi study. Also please give an example of formula for close higher than 3 days ago for spreadsheet.
It is possible to find the Close 3 days ago, but there is no one formula that does it.It would depend on the bar period of the chart, and you'd need to use more than one Formula Column. |