Support Board
Date/Time: Tue, 26 Nov 2024 02:43:25 +0000
Post From: Calculating Price Change Since Last Alert
| [2024-01-17 16:23:12] |
| John - SC Support - Posts: 36286 |
|
What do you mean it disappears when you recalculate the chart. Are you entering the formula in cell K3? You can not use the "Spreadsheet Formula" with the GETCORRESPONDINGMATCH() function. The Spreadsheet Formula, despite its name, uses the Alert syntax, not the spreadsheet syntax. The function only returns the first corresponding match. The parameters determine which one. We see that you are searching column AB, which is fine if that is where the data you are reviewing exists. But you then request the data be returned in column B, which is not a valid column - you would need this to be set to the column where you have entered the formula. Also, you would need to use the absolute reference for the rows, such as K$3:K$200000. And finally, if you do not add the ROW() function around the GETCORRESPONDINGMATCH(), you will not see anything. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |