Support Board
Date/Time: Sat, 08 Feb 2025 17:41:15 +0000
[Programming Help] - Zig Zag Study Oscillator and Spreadsheet Trading
View Count: 1536
| [2020-04-17 18:43:08] |
| Unicorn_Catcher - Posts: 22 |
|
Hello. I am trying to set up spreadsheet trading using the zig zag study. Specifically, I would like to set orders based on correlation when the ZIG Zag Oscillator (SG9) has a negative and positive slope with other ZIgZag Oscillator slopes based on other studies. The spreadsheet column for this oscillator has a combination of blanks, zeros, and/or usually rotates between positive and negative, but sometimes always pos or neg (when using to study Open Interest for example). I have tried applying the Color Bar based on Slope Study to get consistent output (+1 or -1), but the color bar study output to the spreadsheet is Not a series of +-1s (despite selecting this in settings for false), but similar to the previous description of the outputs. The study value window shows +-1, but this is not what shows up in the spreadsheet column under this ID.SG. My question is, how do I translate this slope oscillator data into something I can use in the spreadsheet that reflects the slope calculations done by the study? All input is appreciated. |
| [2020-07-18 18:08:34] |
| User152906 - Posts: 8 |
|
I'm trying to do the same thing, but with the jdt MACD/Bollinger Bands/Heiken-Ashi Study
|
| [2020-07-18 19:21:36] |
| Sawtooth - Posts: 4173 |
|
If you only want a +1/-1 for the pos/neg slope of the ZZ Osc, try something like this in a Formula Column: =IF(ID1.SG9@3>0,1,IF(ID1.SG9@3<0,-1,0)) where the ZZ study is ID1. And there is this example that outputs +1/-1 of a subgraph line's upslope/downslope: Spreadsheet Example Formulas and Usage: Formula that Matches the Slope Coloring of a Study Subgraph Line |
To post a message in this thread, you need to log in with your Sierra Chart account: