Support Board
Date/Time: Sat, 30 Nov 2024 04:38:09 +0000
Help with chart overlays
View Count: 942
| [2022-12-17 08:58:27] |
| rwilliams1 - Posts: 346 |
|
Hello I am spread trading and would like to simply add an additional symbol on top of the current chart symbol I'm viewing so that I can see them both graphed together so I can judge the relative distance between the two. I used the Add Additional Symbol study, but many times the two symbols are so far away in price that I cannot view their relative movements. I tried using the Overlay study but the Overlay price moves/adjusts whenever the chart is scrolled. Is there a way to combine two static (unmoving) charts within the same chart window and adjust the scaling somehow so that they are in the same price range? Thank you. |
| [2022-12-19 15:40:36] |
| John - SC Support - Posts: 36350 |
|
The easiest way to do this is to use the Left Side Scale. To do this, add the Add Additional Symbol study and put it in Region 1. Then set the Scale to Independent and enable the option for Use Left Side Scale. You can turn on the actual left-side scale under Chart >> Chart Settings >> Scale >> Use Left Side Scale. Then you can view both charts together even with the different scales. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2022-12-19 23:30:19] |
| rwilliams1 - Posts: 346 |
|
Thank you so much. I've followed your instructions and it seems to work. I'd just like to know how can I get the price data to be centered around a Zero line using the Study Subgraphs Difference so it can be more easily viewed? In the attached screenshot you can see places where the two prices cross each other, but it is not reflected properly in the Subgraphs Difference indicator. It should be crossing above and below a zero line. Any help is appreciated.
Date Time Of Last Edit: 2022-12-23 20:50:44
|
Private File |
| [2022-12-20 15:19:17] |
| John - SC Support - Posts: 36350 |
|
You would have to adjust the prices to be within same range. Right now, the prices are still the prices of the two instruments without modification. It might be easiest to use the Spreadsheet Study to do this so you can pick a specific point where you want to tie the two prices together.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2022-12-20 21:08:32] |
| rwilliams1 - Posts: 346 |
|
Yes it was suggested to me by a wonderful programmer to use the Spreadsheet study and it solved the initial problem. But for some reason the Subgraphs Difference Indicator doesn't seem to be charting properly. You can see in my screenshot that the prices are in the same range and cross each other numberous times (see arrows), but the Subgraphs Difference indicator is not corresponding correctly?
|
| [2022-12-20 21:20:27] |
| John - SC Support - Posts: 36350 |
|
It sounds like you are using the Subgraph Difference study on the original data and not on the adjusted data. But really, you should just do everything you need within the Spreadsheet Study and then display the output from the Spreadsheet Study as your difference. Columns K, L, M, and N are set to display by default, so you would need to turn off those columns you do not want and turn on the ones you do. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2022-12-20 21:48:59] |
| rwilliams1 - Posts: 346 |
|
I'm actually using the Spreadsheet Formula (Bar) study and not the actual spreadsheets. Can you let me know what I would need to do to configure this study so that zero line crosses are reflected properly? I've double checked the Subgraphs Difference study and I have it configured properly for the two correct data streams.
|
| [2022-12-20 21:53:16] |
| John - SC Support - Posts: 36350 |
|
Please tell us how you are using the Spreadsheet Formula and post one of your formulas into this thread so we can take a look. We are not understanding how you are tying the two graphs together to get them to the same level such that a zero point can be established. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2022-12-20 22:37:05] |
| rwilliams1 - Posts: 346 |
|
Sure below is the Spreadsheet Formula (Bar) I'm using. With this formula I can adjust the price by changing the number +7.81 in this example to increase the price and I replace the + sign with a - when I want to decrease the price. The resulting chart I set to the same chart number as the main price chart and I set the scaling to Independent and add a left side scale as well. Open Formula: ID1.SG1+7.81 High Formula: ID1.SG2+7.81 Low Formula: ID1.SG3+7.81 Close Formula: ID1.SG4+7.81 |
| [2022-12-21 17:26:25] |
| John - SC Support - Posts: 36350 |
|
Then are you using the Spreadsheet Formula (Bar) for the 2nd graph in the Difference - Bar study?
For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2022-12-21 22:43:41] |
| rwilliams1 - Posts: 346 |
|
Yes I have the second graph set to the spreadsheet study and I'm using the Study Subgraphs Difference. It seems like the only time I can get the Zero line subgraphs difference to work properly is when I use the Add Additional Symbol study and use the multiplier to line up the charts.
Date Time Of Last Edit: 2022-12-22 04:01:54
|
| [2022-12-22 14:37:08] |
| John - SC Support - Posts: 36350 |
|
Please attach a chartbook with the chart in it so we can take a look. It should be working just fine from what you are stating. Refer to the following instructions to attach a single chart: Support Board Posting Information: Providing Chartbook with Only a Single Chart For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2022-12-22 22:00:04] |
| rwilliams1 - Posts: 346 |
|
Attached is the Chartbook file. Thanks.
|
Private File Attachment Deleted. |
| [2022-12-22 22:22:08] |
| John - SC Support - Posts: 36350 |
|
The only issue we see is that your formulas in the Spreadsheet Formula (Bar) are all the same. This means that you are only looking at the Open for the CL data, which in turn means that you are not comparing the Last versus the Last in your Study Subgraph Difference. Therefore, it is not a fair comparison. You should use SG1, SG2, SG3, and SG4 for each of the entries in the Spreadsheet Formula (Bar) to get the Open/High/Low/Close lined up appropriately.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2022-12-22 23:03:06] |
| rwilliams1 - Posts: 346 |
|
My apologies. When I created this new chartbook example I forgot to change the SG values. But even when the SG values are set correctly you will still see that the problems persists. There are no zero line crossings created in the Difference Subgraph?
Date Time Of Last Edit: 2022-12-22 23:06:01
|
Private File |
| [2022-12-22 23:11:29] |
| rwilliams1 - Posts: 346 |
|
One thing I noticed is that the value in the Subgraphs Difference study is incorrect as well and may be a clue as to what is going on. The difference between the two symbols should be approximately -2.57. That value is reflected in the info line of the study, but it is not being reflected in the actual difference graph. For some reason the graph and scale range is reading up into the 80's instead of a lower value around 2 or 3.
Date Time Of Last Edit: 2022-12-23 00:06:40
|
| [2022-12-23 15:16:01] |
| John - SC Support - Posts: 36350 |
|
There seems to be a timing issue with the Spreadsheet Formula and the Study Subgraphs Difference. It looks like the Study Subgraphs Difference is a lower priority than the Study Subgraphs Difference and therefore the data fed into the Study Subgraphs Difference is zeros, even though the information shows correctly on the screen. Typically the fix for this is to make sure the Study Subgraphs Difference is the last item in the list of studies, but in this case it is not making a difference. This can happen. Refer to the following: Chart Studies: Study Calculation Precedence And Related Issues Given the above, we recommend using the Spreadsheet Study instead of the the combination of Spreadsheet Formula and Study Subgraphs Reference. You can then do the calculations in a single cell, and you can put your adjustment amount in a column and then reference that number so it becomes easier to update from time to time. Refer to the information for the Spreadsheet Study here: Using the Spreadsheet Study For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2022-12-23 16:06:34] |
| rwilliams1 - Posts: 346 |
|
Given the above, we recommend using the Spreadsheet Study instead of the the combination of Spreadsheet Formula and Study Subgraphs Reference. I am using the Study Subgraph Subtract/Difference not the Study Subgraph Reference.I am not familiar with working with spreadsheets inside SC and prefer working with one simple visual study. Would it be possible for your engineers to simply fix the timing issue with Subgraphs Difference study rather than creating a cumbersome workaround? Date Time Of Last Edit: 2022-12-23 16:20:30
|
| [2022-12-23 18:16:17] |
| John - SC Support - Posts: 36350 |
|
Sorry, that was a mistake in what we typed regarding the Study Subgraph Reference. It is not possible to "fix" the timing issue, as some studies are simply set to a specific precedence and you just happen to have a combination that is causing a problem. This is fairly rare. Given that you are just dealing with the Last price, we recommend using the Study Subgraph Add to add the amount you need to the Last of the Add Additional Symbol. Then use the Study Subgraphs Difference to find the difference between the Main Price Graph Last and the result from the Study Subgraph Add. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2022-12-23 23:04:41] |
| rwilliams1 - Posts: 346 |
|
Fyi, a heads up that apparently this zero line cross problem is a larger issue than just the Spreadsheet Formula study. I tried using both the 1/P and the Multiply Bars by -1 to invert a symbol and the same Zero Line problem persists.
Date Time Of Last Edit: 2022-12-24 05:06:56
|
| [2022-12-28 06:56:44] |
| rwilliams1 - Posts: 346 |
|
Would you be able to tell me why the attached setup is now not working with the Study Subgraphs Difference indicator? This is the most simple setup of just the Add Additional Symbol & the Study Subgraphs Difference indicators. It's comparing the main chart symbol with the symbol in the Add Additional Symbol study. It usually charts the difference above/below a zero line with no problem, but now as you can see it does not? I can't figure out why.
|
Private File Private File |
| [2022-12-28 16:19:11] |
| John - SC Support - Posts: 36350 |
|
It is showing you the correct information. Keep in mind that you have the Add Additional Symbol set to display as "Independent", which means that the location on the screen is completely independent from the other graphs. The USD-X symbol is traded at a price of about 1092.00 and the CHF is at about 1.0848. Therefore, your price differences are not going to center around 0, but rather will be around 1091.00. You would need to use the Price Multiplier within the "Add Additional Symbol" to get the USD-X price down to the level of the CHF. 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: