Home >> Support Board

Support Board

Date/Time: Thu, 25 Apr 2024 00:54:18 +0000

How to Post a Message for Support

[Programming Help] - Sttudy / Price overlay

View Count: 745

[2019-12-02 03:37:02] #1 [Go To First Post]
User38606 - Posts: 80
Re Study / Price overlay I have 2 Charts in a “Chartbook” with spreadsheet studies in (sheet 1 and 2). Chart 1 is “Daily” and Chart 2 is “240min”. There is a calculation done in Row 18 (Sheet 1) and note it is a Daily value. Now, I want to overlay this daily value to sheet 2 (or 240min sheet). So let’s say value for 02 Dec is 1.90. I thus want this value to be plugged in / populated for each of those rows (sheet 2 – 240min) for 2nd Dec. (there are 6 of the 240min rows for 2 Dec or 24h / 4 h = 6) I noticed that this can be done if you first put it as part of studies on Chart 1 and then u can overlay it to Chart 2. But I however, do not want this study to be displayed on Chart 2…just need those values in sheet 2. Can this be done?

[2019-12-02 15:00:40] #2 [Go To First Post]
Sawtooth - Posts: 3976
Can this be done? Simply hide the Study/Price Overlay study. The values will be retained on the spreadsheet.

[2019-12-07 10:29:12] #3 [Go To First Post]
User38606 - Posts: 80
What if there are 2 studies being generated from Sheet 1 and overlaid to Sheet 2, and I wanna keep one of them, yet hide another. Is that possible? Because, when I click Hide Study -->> both studies are hidden.

[2019-12-07 11:05:08] #4 [Go To First Post]
User38606 - Posts: 80
What I also did > if you have 2 studies in sheet 1, you can click Study Settings, SubGraphs > Draw Style > choose Hidden. So u can choose not to display one of the studies.So Chart 1 is fine. But when I overlay these studies from Chart 1 to Chart 2, Chart 2 gets distorted its a strange display...just a line.... See attached. Can that be fixed somehow?


Chart 1 Fine.PNG / V - Attached On 2019-12-07 11:04:51 UTC - Size: 85.83 KB - 265 views Chart 2.PNG / V - Attached On 2019-12-07 11:04:56 UTC - Size: 86.84 KB - 262 views

[2019-12-07 14:24:52] #5 [Go To First Post]
Sawtooth - Posts: 3976
Try this workaround that I use: Add the Moving Average - Simple study to chart 1 and set the Based On to the spreadsheet subgraph you want to overlay. Set the Length to 1. Then overlay this SMA instead of the spreadsheet study. Repeat for the other spreadsheet subgraph you want to overlay.

[2019-12-21 02:14:56] #6 [Go To First Post]
User38606 - Posts: 80
I can't do that. I don't understand how to do this. When I go to BASED ON, I can see studies which are already applied to Chart 1. When I choose the relevant study, I cannot set the required subgraph I want to overlay. These steps need to be applied in Moving Average Simple Settings? correct


Capture.PNG / V - Attached On 2019-12-21 02:14:39 UTC - Size: 12.33 KB - 245 views

[2019-12-21 13:12:46] #7 [Go To First Post]
Sawtooth - Posts: 3976
I don't understand how to do this. In the workaround I suggested, the SMA becomes an intermediate study on Chart 1. In this SMA, you set the Based On to the spreadsheet study, and set the Input Data to the spreadsheet column/subgraph that you want to overlay on Chart 2. Then on Chart 2, you use the Study/Price Overlay study to overlay the SMA from Chart 1. This allows you to avoid overlaying all of the subgraphs of the spreadsheet study, and give you the flexibility to select which spreadsheet column/subgraph to overlay.

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