Home >> Support Board

Support Board

Date/Time: Sun, 08 Sep 2024 00:26:27 +0000

How to Post a Message for Support

OHLC data lowertime chart into spreadsheet main chart

View Count: 113

[2024-07-03 15:58:22] #1 [Go To First Post]
sabbers - Posts: 21
Hi all, I have a question regarding spreadsheet system for trading and studies overlay OHLC / price overlay. For example Main chart is 5 minute, so each line for each candle in the spreadsheet is 5 min. I want to use OHLC values for 1 minute chart. For example the close of the previous candle. But the last price of the previous candle is the same as the 5 min candle in overlay OHLC / price overlay spreadsheet columns How can i get the OHLC values of the previous 1 min candle in the spreadsheet of the 5 min chart? Regards, Sabbers Date Time Of Last Edit: 2024-07-03 16:28:40

[2024-07-03 17:24:07] #2 [Go To First Post]
John - SC Support - Posts: 34254
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

To post a message in this thread, you need to log in with your Sierra Chart account: