Support Board

Date/Time: Tue, 04 Nov 2025 08:56:27 +0000

[Programming Help] - spreadsheet index match

[2022-02-12 08:22:27] #1 [Go To First Post]
Ferenc Reischig - Posts: 11
When closing a candle, I want to find the value of the nearest pivot level. Candle close: E3 Pivot levels: ID8.SG1@3:ID8.SG14@3 I tried this formula, but it doesn't work: =INDEX(ID8.SG1@3:ID8.SG14@3,MATCH(MIN(ABS(ID8.SG1@3:ID8.SG14@3-E3)),ABS(ID8.SG1@3:ID8.SG14@3-E3),1)) Can you help me with what I'm getting wrong? thanks

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