Support Board
Date/Time: Wed, 12 Aug 2026 02:20:29 +0000
Combining 5min and 15min bars
View Count: 1180
| [2020-04-24 07:50:55] |
| bnsmth - Posts: 5 |
|
When I use a spreadsheet study to overlay 15min data on original 5min data, the 15min data is repeated across 3 rows. Is it possible to get the 15min data snapped at 5min intervals? ie the close of the 10:00 5min bar lines up with a snap of the 10:00 15min bar at 10:05? Thanks |
| [2020-04-24 08:30:31] |
| |
|
You will want to use the Study/Price Overlay study: Study/Price Overlay Study Not sure how you are accomplishing what you want with the Spreadsheet study. Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
| [2020-04-24 08:46:31] |
| bnsmth - Posts: 5 |
|
Thanks, that is what i am using. I have a graph with 5 min data. I have then used a study/price overlay with 15min data. Then when i open a spreadsheet study, the 15min data is repeated over 3 rows since a 15min bar covers 3 * 5min bars. So the 8:30, 8:35 and 8:40 rows all have the same 15min data from the 8:30 15min bar. What i would prefer to happen is the 15min bar is snapped every 5 mins so each row has the bar value when the respective 5min bar closes. Is that possible? Thanks |
| [2020-04-24 08:53:58] |
| Ackin - Posts: 1865 |
|
I have a graph with 5 min data. I have then used a study/price overlay with 15min data.
Then when i open a spreadsheet study, the 15min data is repeated over 3 rows since a 15min bar covers 3 * 5min bars. So the 8:30, 8:35 and 8:40 rows all have the same 15min data from the 8:30 15min bar. What i would prefer to happen is the 15min bar is snapped every 5 mins so each row has the bar value when the respective 5min bar closes. Is that possible? if you look at the result when the graph is stopped (not replay, not connected ... or immediately after loading the values of the whole chart) then you will always see such a result because the OHLC structure is transmitted, ie the result of a closed bar is always transmitted. What do you see with a "running graph"? |
| [2020-04-24 09:19:16] |
| bnsmth - Posts: 5 |
|
When the graph is running live, all 3 rows are ticking at the same time.
|
| [2026-07-20 11:23:24] |
| J DIDDY - Posts: 154 |
|
HI support I have the same issue I would like resolved. I use a 5min Numbers bar with the 'Ask/bid delta text' on top of the bar. Then I'm bringing over the 'Ask/bid delta text' from a 15Min chart (with Study/Price Overlay study) but it give me 3 instances, and starts to look messy when my 5M bars are the same height as the 15M study spreads over 3 x 5min bars. Is there any way to just have 1 instance from the 15MIN chart? This is a much needed feature, because if my main chart was a 1 minute I would have 15 instances from my 15 min chart which would be super messy and impossible to use! See pic aattached as it might make more sense to see it visually... Thx |
Private File |
| [2026-07-20 14:48:01] |
| John - SC Support - Posts: 47509 |
|
Set the Input for "Fill Blanks with Last Value" to "No". Refer to the following: Study/Price Overlay Study: Fill Blanks with Last Value For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2026-07-20 19:48:58] |
| J DIDDY - Posts: 154 |
|
Awesome thx
|
To post a message in this thread, you need to log in with your Sierra Chart account: