Login Page - Create Account

Support Board


Date/Time: Sat, 18 May 2024 12:40:03 +0000



Post From: Zig Zag Study Oscillator and Spreadsheet Trading

[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.