Support Board
Date/Time: Mon, 10 Mar 2025 10:23:13 +0000
Post From: Spreadsheet, nth most recent nonzero value?
| [2022-03-17 00:45:25] |
| j4ytr4der_ - Posts: 946 |
|
I have a study which returns nonzero numbers roughly every 5-10 bars. I would like to know what the 10 most recent nonzero values were. We have EARLIESTNONZEROVALUE and MOSTRECENTNONZEROVALUE which are great, but neither is quite what I need )other than getting just the first value present). I know of ways to do this in Excel, but it requires formulas SC doesn't support. Any of you clever folks have any ideas on how to get more than just the first or last nonzero values in a column? |