Support Board
Date/Time: Tue, 26 Nov 2024 15:30:03 +0000
Post From: ACSIL - how to find many previous same y values to current price value
| [2023-11-20 21:39:34] |
| John - SC Support - Posts: 36294 |
|
You can do this using either ACSIL or the Spreadsheet Study. Within ACSIL there is not a single function to make this kind of comparison, you have to program the logic to look through the data. With the spreadsheet, it is as you state - you are trying to compare a value against a range of values. This is not easy to do, as spreadsheets do not loop, but you can put together multiple columns to pull off whatever you are trying to do, you just have to be a bit creative. In particular, not the VLOOKUP() function that you would probably use at the end of your process to find a particular item: https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#VLOOKUP_Function For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |