Home >> Support Board

Support Board

Date/Time: Mon, 25 Nov 2024 22:45:33 +0000

How to Post a Message for Support

[Programming Help] - Spreadsheet - Min of non-zero values

View Count: 306

[2024-01-31 13:18:17] #1 [Go To First Post]
User347921 - Posts: 39
Hello, I'm using a spreadsheet with 10 columns containing numbers >=0. I'd like to have the minimum of non-zero values. If I put =MIN(K3:S10), the it will return 0 (being the minimum). How can I have the MIN of non zero values only please? Thanks

[2024-01-31 15:08:18] #2 [Go To First Post]
User43 - Posts: 101
Well it is a spreadsheet just add another set of columns where you reference all values from the original area except of 0 values. Kind of in T3 =if(k3>0, K3, "") and then get your min value from the new region.

[2024-01-31 15:09:36] #3 [Go To First Post]
Sawtooth - Posts: 4120
How can I have the MIN of non zero values only please? Use the MINZ function. https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#MINZ_Function

[2024-01-31 18:29:25] #4 [Go To First Post]
User347921 - Posts: 39
Thank you! I gave an example of 10 columns, but I've much more. So MINZ is the solution. Can I please ask another question. I want to reference all untouched Stacked Imbalances which are IDxx.SG60 under "Volumes at Price Threshold Alert 2", but SG60 doesn't return anything on the spreadsheet. Any clue how to get these fresh Imbalances into a Spreadsheet? Thanks


2024-01-31 stacked imbalances.png / V - Attached On 2024-01-31 18:27:27 UTC - Size: 61.16 KB - 49 views

[2024-01-31 18:58:20] #5 [Go To First Post]
User43 - Posts: 101
Looks like this subgraph is normally set to "Subgraph Name And Value Labels Only" which is not plotting any values. Chart Studies: Subgraph Name and Value Labels Only (ACSIL: DRAWSTYLE_SUBGRAPH_NAME_AND_VALUE_LABELS_ONLY) I don't fully understand what you try to do, but maybe setting this to a Line will give you it's value.

[2024-01-31 19:10:59] #6 [Go To First Post]
User347921 - Posts: 39
Usually, these imbalances zones are revisited, so they can serve as either Support/Resistance or Profit Target/Stop Loss, etc. What I'm trying to do is to get these levels on a spreadsheet.

[2024-01-31 19:56:23] #7 [Go To First Post]
User43 - Posts: 101
Ohh, I understand the part about the revisit, but I'm not too familiar with using SC Spreadsheets. But when looking up the default setting for SG60 on the "Volumes at Price Threshold Alert V2" I found that its default draw type is not set to a type which gives a value. Did you try setting it to "Line"? Did that give you a value on your Spreadsheet?

[2024-01-31 21:02:48] #8 [Go To First Post]
User347921 - Posts: 39
It is by default set to line and it doesn't show price levels in the spreadsheet. Thank you anyway.

[2024-02-01 01:45:23] #9 [Go To First Post]
Sawtooth - Posts: 4120
I want to reference all untouched Stacked Imbalances which are IDxx.SG60 under "Volumes at Price Threshold Alert 2 Prices of line extensions within a bar are not available in a spreadsheet. Volume at price within a bar is available when (ln:53) is set to Yes, in the spreadsheet study settings. However, volume at price is listed horizontally, beginning in column BA and to the right. This setting disallows any other study's output in columns BA and to the right. This might not be useful because it would be difficult to access it with a formula.

To post a message in this thread, you need to log in with your Sierra Chart account: