Support Board
Date/Time: Mon, 25 Nov 2024 16:26:00 +0000
Post From: Automated strategies using Flex Renko charts
| [2024-02-23 14:52:42] |
| Sawtooth - Posts: 4120 |
|
This is what I do: - Add the Renko Visual Open/Close Values study. - In the spreadsheet study's setting, set the Number of Formula Columns to 21 or greater. - Use columns AB-AE for the renko OHLC, (This makes it easy to reference, instead of columns B-E.) - Use formulas like this: AB3: =IF(ROW()=3,B3,ID1.SG1@3) AC3: =C3 AD3: =D3 AE3: =IF(ROW()=3,E3,ID1.SG2@3) where the Renko Visual Open/Close Values study is ID1. Spreadsheet Example Formulas and Usage: Spreadsheet Study Equivalents of Simple Alerts and Main Price Graph Identifiers (Renko bars use B3,E3 for the Open/Close when forming, then their visual Open/Close Values when complete. The Visual Open/Close Values in the current bar are the predictive values.) Then find the up bars and down bars using this formula in another Formula Column, e.g. T3: =IF(OR(AE3>AB3,AND(AB3>AE4,AB3=AE3)),1, IF(OR(AE3<AB3,AND(AB3<AE4,AB3=AE3)),-1,T4)) This is edited from this example: Spreadsheet Example Formulas and Usage: Formula that Matches the Coloring of Up and Down Price Bars Reference Up bars as 1 and down bars as -1. Date Time Of Last Edit: 2024-03-07 17:58:55
|