Login Page - Create Account

Support Board


Date/Time: Fri, 03 May 2024 23:06:40 +0000



Post From: Display As Main Price Graph option affects output to spreadsheet

[2013-11-26 05:11:54]
Sawtooth - Posts: 3993
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