I'm hoping someone can help with a simple study that I use in ThinkOrSwim and can be coded for Sierra Chart.

The premise is very simple - the study paints a continuous line on the price chart when the RSI is above 51 (entry or long threshold) or below 48 (exit or short threshold.) The user defines the length of RSI, in this case 34 and 55. Obviously two copies of the study would be loaded

Below screenshot is from today 9-12 on a one (1) minute chart /CL chart

Cyan (light blue) is RSI 34 (long/ entry)
Blue is RSI 55 (long/ entry)
Orange is RSI 34 (short/ exit) showing brief failure
Red is is RSI 55 (short/ exit) showing brief failure



Any help would be much appreciated. (I'm more of a hacker than a coder.)

Thank you

-William

This can easily be done with the Spreadsheet Study study.

If you want the details, post again.

Yes sir, thank you

I use Infinity Futures Sierra Chart which has:

Spreadsheet Study
Spreadsheet System for Trading
Spreadsheet System/Alert

Build Custom Studies DLL
New/Open Custom Studies File

I'm fairly proficient/ pretty good in Excel, Open Office etc

Thank you

-William

Add the Spreadsheet Study study:
-Set the Chart Region to 1.
-Give it a name in the Spreadsheet Name field.
-On the Subgraphs tab, set the Draw Styles of SG1-SG4 to Dash. Set Line Styles and colors.
On the spreadsheet, put these formulas in cells K3-N3, respectively:
=IF(ID1.SG1@3<51,0,IF(AND(ID1.SG1@4<51,ID1.SG1@3>51),E3,K4))
=IF(ID2.SG1@3<51,0,IF(AND(ID2.SG1@4<51,ID2.SG1@3>51),E3,L4))
=IF(ID1.SG1@3>48,0,IF(AND(ID1.SG1@4>48,ID1.SG1@3<48),E3,M4))
=IF(ID2.SG1@3>48,0,IF(AND(ID2.SG1@4>48,ID2.SG1@3<48),E3,N4))
where ID1 is the RSI 34, and ID2 is the RSI 55; edit as necessary.

You could substitute the 51 and 48 with absolute references to user variables in H1 and H2:
$H$1
$H$2

Or you could substitute the 51 and 48 with references to the respective RSI's Line1 and Line2, assuming you set these to 51 and 48 in the RSI study:
ID1.SG2@3
ID1.SG3@3
ID2.SG2@3
ID2.SG3@3

You may want to edit cells K2-N2 with titles:
RSI 34 long
RSI 55 long
RSI 34 short
RSI 55 short

@tomgilb

Thank you very, very much for helping with this

I made a slight modification to the above code, syntax

For long entry (support) I changed E3, K4 and E3, L4 to D3 respectively

For short entry (resistance) I changed E3, M4 and E3, N4 to C3 respectively

-William