Support Board
Date/Time: Tue, 26 Nov 2024 02:44:22 +0000
Post From: Calculating Price Change Since Last Alert
| [2024-01-17 05:22:11] |
| pjk0225 - Posts: 34 |
|
So the formula works if I enter it manually into the spreadsheet, but it disappears if I recalculate the chart. Also, when I enter it into the "Spreadsheet Formula" study, it still outputs "0" instead of the open. The formula I'm using: =GetCorrespondingMatch(AB3:AB200000, 1, 0, 0, 0, B3:B200000, 0) EDIT: For clarification, is this study supposed to output only the most recent matching value, or should each row display its own corresponding value? Date Time Of Last Edit: 2024-01-17 05:26:48
|