Login Page - Create Account

Support Board


Date/Time: Sat, 10 May 2025 07:14:16 +0000



Post From: Basic Examples of How You Use INDEX, MATCH / Spreadsheet Performance Improvements Now Available

[2015-12-27 18:53:03]
Sierra Chart Engineering - Posts: 104368

=AVERAGE(GETCORRESPONDINGMATCH(...):GETCORRESPONDINGMATCH(...))
This will be supported.


Will GETCORRESPONDINGMATCH be able to use TRUE as a SearchNumber?
Yes.

What will GETCORRESPONDINGMATCH return if there is a duplicate SearchNumber in the SearchColumn?
The first corresponding match with the lowest numbered index in the range.


Will there be row range parameters within SearchColumn and ReturnResultColumn?
Rows will also be supported as well. We used the term "Column" since this is normally what is being searched.

MATCH will be optimized as well.
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
Date Time Of Last Edit: 2015-12-27 21:55:36