Prescott AZ USA
Experience: Advanced
Platform: SierraChart
Broker: Stage5, FCM:Dorman, Data:Denali, Routing:Teton
Trading: YM ES NQ
Posts: 474 since Nov 2009
Thanks Given: 219
Thanks Received: 603
|
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
|