Support Board
Date/Time: Wed, 19 Mar 2025 23:14:46 +0000
[User Discussion] - Spreadsheet and Heikin Ashi
View Count: 422
| [2022-10-27 21:20:28] |
| User97303 - Posts: 16 |
|
Thank you in advance. What is formula to put in a spreadsheet for autotrading for the Heikin Ashi switching from down to up. In other words switching colors. Also please give an example of formula for close higher than 3 days ago for spreadsheet. |
| [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. |
To post a message in this thread, you need to log in with your Sierra Chart account: