Login Page - Create Account

Support Board


Date/Time: Thu, 20 Jun 2024 17:52:47 +0000



ACSIL - how to find many previous same y values to current price value

View Count: 196

[2023-11-19 09:06:34]
User951358 - Posts: 8
Hello Support team,

I have tried many times to find the simple function:
I have an EMA current close price, which I want to compare with the previous swing high/lows on the chart to put out an alert when they are crossing. I have the studies and just need to know how to compare them according to me needs:

I know you are not responsible for the support I want here, but I want you please to just give me a hint, if you already found a solution for the comparison of a current price with many previous y values on the chart of a different study - I mean not just compare the current price with the last swing high (this works), but all swing highs on the visible chart to find the y crossings.

The study formulas cannot compare a y value on the chart with many same y values before
I didnt find ACSIL formulas for this too
I think it is only possible with spreadsheet study, where I have all the values within a column which I want to compare with one value in e.g. $F$3 box. Can you please tell me how?

Please give me a hint, as it has cost me much time and program support posts without any help. Thank you
[2023-11-20 21:39:34]
John - SC Support - Posts: 32495
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

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

Login

Login Page - Create Account