Support Board
Date/Time: Mon, 13 Jan 2025 18:16:11 +0000
NON-ZERO MEDIAN
View Count: 901
| [2017-05-03 18:51:52] |
| User98657 - Posts: 329 |
|
I'd like to know if there's some way to get a median value for a zig zag study on a spreadsheet. There isn't a "MEDIAN_IGNORZEROS" function, so I'm wondering if there's a work around. The "MEDIAN" function applied to the entire column of ZigZag study values includes more zeros than any other number so you're median value is zero unless there's a way to avoid including the zeros. |
| [2017-05-04 01:10:23] |
| |
|
Refer to: Zig Zag: Displaying the Zig Zag Mid-Point Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
| [2017-05-04 12:45:54] |
| User98657 - Posts: 329 |
|
Thanks, but i'm not sure the midpoint will solve for the median value of rotations up and down. if, perhaps, we had one point for a midpoint, instead of a midpoint displayed for each chart column we might be able to work out something close. But the other values would need to be null. But playing with the formula i see i can convert entries to null. perhaps that will work.
|
To post a message in this thread, you need to log in with your Sierra Chart account: