hi

I cant get a handle on how to do a function to call up the zigzag cumulative volume in the Sierra indicator by that name.

I attached a picture of the cells in the spreadsheet.

I would like to capture the abrupt change in cumulative volume as it changes from long to short.
I highlighted a row where the change takes place.

Not sure how to use the > in this case.

Any ideas to capture this particular change in data coming into the spreadsheet ?

The highlighted row corresponds to around 8:30 am when the direction changed to long

thanks
Shane

On the Zigzag study, set the 'Additional Output For Spreadsheets' to Yes. This will display more columns that will have values <>0 at the ZZ turn.

thank you

shane