Support Board
Date/Time: Tue, 26 Nov 2024 19:55:40 +0000
Post From: Spreadsheet formula cross Daily OHLC
| [2023-10-24 20:17:32] |
| John - SC Support - Posts: 36306 |
|
If you want to have the previous highest high data available instead of the current one, then you can add a Spreadsheet Study and enter the following in cell K3: =IF(ID1.SG1@3 <> ID1.SG2@4, ID1.SG2@4, K4) Where ID1 is the ID of the Daily OHLC study. This will shift the data such that the previous value is available at the current bar and so on going backwards in time. This also assumes that you have the Input for the Daily OHLC of "Graph High and Low Historically" is set to "Yes". You can then use this to determine your breakout. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |