Login Page - Create Account

Support Board


Date/Time: Fri, 29 Mar 2024 16:00:49 +0000



Accessing Corresponding Prices on Overlay Charts

View Count: 1262

[2014-03-11 21:29:52]
User32628 - Posts: 15
Is there a way to collect in the Sierra Chart spreadsheet the price data, via the new axis, of an overlayed security with an independent scale setting? For example, I like to overlay the "legs" of a commodity spread in my commodity spread charts. For a leg trading at $100, I can not use that scale (nor do I want to for this purpose) on my spread chart which is trading at perhaps $1. So I overlay it with an independent scale in the cases where I am already using the left hand scale for some other indicator. This is fine, because what I am most interested in is the pattern of the leg, not the actual price. What I would like to do though is some analysis on the difference in patterns between the spread and the leg. For what I am looking to do, all I would need is the equivalent spread prices that the leg is being artificially overlayed on the chart via Sierra Chart. I want to do more than just a visual look and if I had the corresponding data stream available in a spreadsheet, I could analyze it more thoroughly. Is there an easy way to get that data?
[2014-03-12 00:18:53]
Sierra Chart Engineering - Posts: 104368
Yes. All of this is very basic. Use the Spreadsheet study and the Overlay (Bar) study to overlay the other charts you want. The overlays will be outputted to the spreadsheet beginning at column AA, by default.
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
[2014-03-12 00:51:13]
User32628 - Posts: 15
Sorry, I wasn't clear at all. I am not looking for the actual price of the leg, but the price points at which it is overlayed on the spread chart. So for example, April Hogs (leg) are trading at $82 and the April - June Hog Spread is trading at -$8, with the scale showing from -$10 to -$3 If I overlay the April leg on the Spread Chart on a 5 minute chart (could be any time frame), I do not want them to share the same scale, less the chart scale is too wide. Instead I overlay with an independent scale so that I retain the $-10 to $-3 scale needed to effectively show the Spread, while also showing the pattern of the Leg move, but not the actual prices. So the Leg now overlays somewhere between $-10 and $-3 over time.

What I am looking for is the actual data points to be outputted to the spreadsheet as to where exactly the leg is overlaying over time on the spread scale. I am aware, as you say, that the actual leg prices will output to the spreadsheet, but I want the prices at which it overlays on the spread scale (see attached file).

Date Time Of Last Edit: 2014-03-12 00:54:50
imageOverlay Price.png / V - Attached On 2014-03-12 00:50:40 UTC - Size: 142.26 KB - 392 views
[2014-03-13 08:45:21]
Sierra Chart Engineering - Posts: 104368
OK, clearly you understand what you require. We would think what the Spreadsheet functionality offers should be clear. So if you are able to accomplish what you need, good. If not, not sure really what we could do to help with this.

Maybe some custom programming using ACSIL would help:
https://www.sierrachart.com/index.php?l=doc/doc_CreatingDLLs.html
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

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

Login

Login Page - Create Account