Login Page - Create Account

Support Board


Date/Time: Sat, 20 Apr 2024 12:41:10 +0000



Display As Main Price Graph option affects output to spreadsheet

View Count: 1393

[2013-11-24 23:41:31]
Sawtooth - Posts: 3976
1) If Display As Main Price Graph is checked on any non-price bar study, the output of that study appears in column A and higher, overwriting the Date Time, Open, High, Low, Last, etc.

2) If Display As Main Price Graph is checked on any price bar study (e.g. Renko, Renko Enhanced, Heikin-Ashi, Heikin Ashi Smoothed), there is no problem, but if the study is removed, any other study's output moves to column A and higher, overwriting the Date Time, Open, High, Low, Last, etc.

3) Once this happens, the chartbook is corrupted, with no way to revert to the correct spreadsheet column outputs.

4) If the corrupted chartbook and spreadsheet file is emailed to another user, the recipient will not see the problem. If it is emailed back to the sender, the sender no longer sees the problem.


Date Time Of Last Edit: 2013-11-25 00:52:08
imageoutput to spreadsheet.png / V - Attached On 2013-11-24 23:45:55 UTC - Size: 39.82 KB - 397 views
[2013-11-26 03:57:20]
Sierra Chart Engineering - Posts: 104368
1. Yes, this is correct. This is by design.

2. Yes, this does make sense.

3. In this case you need to uncheck Display As Main Price Graph.

4. We do not understand this. I guess we would have to go through the particular scenario you are describing to get an understanding of what you mean.

Do you have a suggested solution to this? When you are making a study as the Main Price Graph, then it becomes the Main Price Graph. So all of this is by design.
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
[2013-11-26 05:11:54]
Sawtooth - Posts: 3976
Regarding #1: This is normal behavior.

Regarding #2: If the Display As Main Price Graph is unchecked on a study, or the study is removed, the outputs of all other studies on the chart move to column A and above. This doesn't make sense to me.

For example:
-A Moving Averages study, a Bollinger Bands study, a Daily OHLC study, and a Spreadsheet Study study are added to a chart, in this order in the Studies to Graph list.
-The MA study's output is in columns AA,AB,AC. The BB study is in columns AE,AF,AG. The Daily OHLC is in columns AI-AO.
-The Display As Main Price Graph is checked in the MA study. The MA's output moves to columns A,B,C, and the other studies move over to columns AA and above.
So far, so good. Now the problem:
-The Display As Main Price Graph is unchecked in the MA study. The MA's output remains in column A,B,C. The other studies move to columns E-O.
-Remove the MA study, and the other studies move to columns A-K.

Regarding #3: Unchecking Display As Main Price Graph makes matters worse, and the problem cannot be corrected, except by doing what I did in #4.

Regarding #4:
This issue caused a big problem for a client of mine who went from the Renko Enhanced study to the native Renko Bar bar period. When the Renko Enhanced study was removed, all formula references were wrong. The messed up chartbook and spreadsheet file were emailed to me, and I saw no problem. I emailed the same chartbook and spreadsheet back, and the problem disappeared.

My suggested solutions:
-When the Display As Main Price Graph is unchecked, return all study outputs to a column AA and above (assuming 16 Formula Columns) in the order they appear in the Studies to Graph list.
-If the study is removed that had the Display As Main Price Graph checked, retain the remaining study outputs in the columns they populate.


Date Time Of Last Edit: 2013-11-26 18:00:03
[2013-11-27 04:16:44]
Sierra Chart Engineering - Posts: 104368
We have tested this. The underlying problem is there was a bug. It has been fixed. And we are going to be releasing a new version now.
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