Support Board
Date/Time: Sun, 24 Nov 2024 03:56:09 +0000
Post From: OHLC data lowertime chart into spreadsheet main chart
| [2024-07-03 17:24:07] |
| John - SC Support - Posts: 36238 |
|
You have to get the data for the previous bar forward in time first, so that it is seen by the system as the current bar and therefore copied to the 5 minute chart as you want. To do this for a single item (i.e. the Close of the previous bar) use the "Study Subgraph Reference" on the 1 minute chart and set it to reference the Close of the Main Price Graph for that chart. Then set the Displacement for the subgraph to be 1. This will then display the data for the Open for the main price graph shifted forward by 1 bar. Then you can use the "Study/Price Overlay" to over the "Study Subgraph Reference" to the 5 minute chart and the current bar Close will be the previous bar from the 1 minute chart. Make sure that on the "Study/Price Overlay" that the Input for "Data Copy Mode" is set to "Use Latest Value from Corresponding Timeframe in Source Chart" and that "Bar Time Matching Method" is set to "Containing Match". If you want to overlay multiple items, such as the entire bar (OHLC), then you could either use multiple copies of the "Study Subgraph Reference", or you could use the "Spreadsheet Formula (Bar)". Just make sure to set the displacement as noted above. Refer to the following: Study Subgraph Reference Study/Price Overlay Study Chart Studies: Subgraphs Tab >> Displacement Spreadsheet Formula For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |