Support Board
Date/Time: Tue, 22 Apr 2025 06:17:45 +0000
Post From: Spreadsheet System for Trading
| [2025-02-06 21:25:37] |
| John - SC Support - Posts: 39395 |
|
In this case, since you can not overlay the "Numbers Bars Calculated Values" study, you would need to create the condition you want in the 1 minute chart first and then overlay that to the 15 minute chart. The simplest way to do this is to use the "Spreadsheet Formula" study, which, despite its name, uses the Alert syntax. Therefore, on the 1 minute chart, you would add the "Spreadsheet Formula" study and enter a formula like the following: =ID1.SG1 > 1000 Where ID1 is the "Numbers Bars Calculated Values" study ID and SG1 is the first subgraph of the Numbers Bars Calculated Values. This will then give you a value of 1 if the condition is true or a value of 0 if the condition is false. Then use the "Study/Price Overlay" to overlay the "Spreadsheet Formula" to the 15 minute chart and reference the "Study/Price Overlay" in your spreadsheet. Refer to the following: Spreadsheet Formula Study/Price Overlay Study For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |