Login Page - Create Account

Support Board


Date/Time: Wed, 27 Nov 2024 17:40:12 +0000



Post From: Missing Open to Close(Last) Range in "High/Low for Time Period" study

[2023-07-20 14:36:10]
Sawtooth - Posts: 4120
If I wanted to create only 2 or 3 Std Dev levels (instead of 20), would you recommend any other study that's better for this?
You could use multiple instances of the Spreadsheet Formula study.
(Note: Despite its name, this is not a spreadsheet study. It uses Alert syntax.)

However, it's not 'better' than the Spreadsheet Study, in that the formula will the same, but using a different syntax.

You could use the Spreadsheet Formula study for a portion of the formula, then use the Standard Deviation study Based On the Spreadsheet Formula study. But now you have two more studies per line, when the Spreadsheet Study does it all, because it has up to 60 subgraphs.

You may also need to dynamically limit the Length, in which case you might be limited to using the Spreadsheet Study study.
And you'll only want to display the line when the IDR is <> 0.
Since I don't know the all of the conditions, I can't offer much more.