Support Board
Date/Time: Tue, 26 Nov 2024 03:32:53 +0000
[Programming Help] - Maximum If Value is Greater than 0 (Spreadsheet System for Trading)
View Count: 305
| [2024-01-06 17:24:19] |
| User827002 - Posts: 36 |
|
In column Q in the screenshot I've attached, I'm trying to develop a formula to find the maximum of column P, only until the next 0. In other words, the maximum of each sequence of consecutive numbers in between zeros. So Q3 should show 4738.5, Q4 should show 4738.5, Q5 should show 4737.5. Q6:Q8 should show 0, Q9 should show 4730.5, Q10:Q15 should show 4728.5. Do you have any recommendations?
|
 Maxofsegment.PNG / V - Attached On 2024-01-06 07:25:42 UTC - Size: 14.63 KB - 53 views Attachment Deleted. |
| [2024-01-06 18:53:46] |
| Sawtooth - Posts: 4120 |
|
I'm trying to develop a formula to find the maximum of column P, only until the next 0
Use a formula like this in Q3:=IF(P3>0,MAX(P3,Q4),0) |
| [2024-01-06 22:24:00] |
| User827002 - Posts: 36 |
|
That worked, thank you! I thought I'd be able to easily create another column to find the MIN of P column, but because the min of the column is always 0 that's all it prints. Do you know what formula I can use to find the min of a sequence?
|
| [2024-01-06 23:28:05] |
| Sawtooth - Posts: 4120 |
|
Do you know what formula I can use to find the min of a sequence?
Use the MINZ function, in R3:=IF(P3>0,MINZ(P3,R4),0) https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#MINZ_Function Date Time Of Last Edit: 2024-01-06 23:28:42
|
To post a message in this thread, you need to log in with your Sierra Chart account: