Support Board
Date/Time: Mon, 25 Nov 2024 16:30:13 +0000
Automated strategies using Flex Renko charts
View Count: 686
| [2024-02-22 19:33:27] |
| aswade3451 - Posts: 19 |
|
I am attempting to use spreadsheets for an automated strategy using flex renko bars. However, no matter how I define a bull bar the strategy formulas always seem to mark a bearish bar because of the way a Flex Renko chart behaves. How else can I define the color of a bar without using the high, low, close, and open?
|
| [2024-02-22 19:34:39] |
| John - SC Support - Posts: 36248 |
|
Refer to the information at the following link and be sure you are referencing the Open and Close using the appropriate values: Renko Bar Charts: Renko Open, High, Low, Close Values For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2024-02-22 23:01:51] |
| aswade3451 - Posts: 19 |
|
I do not see on the provided information any other way to reference the values in a spreadsheet other than the way I have. It says use ID0.SG2 for the high- which I have been doing. It is located in the same cell of the spreadsheet as if the high was on a regular chart.
|
| [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
|
To post a message in this thread, you need to log in with your Sierra Chart account: