Login Page - Create Account

Support Board


Date/Time: Fri, 29 Mar 2024 14:10:01 +0000



[Programming Help] - Programming - Referencing different chart in spreadsheet

View Count: 307

[2022-09-30 19:19:58]
GG - Posts: 20
Hello,

I am trying to only enter Buy/Sell when crossing 1SD on VWAP and VIX is below 20, so I have added it to the chart I'm trading via Study/Price overlay.

Buy Entry:
=AND(ID1.SG4@3<20,CROSSFROMBELOW(ID0.SG4@3:ID0.SG4@4, ID5.SG5@3:ID5.SG5@4))


When I run it, the formula resets to what it was before I changed it.
=CROSSFROMBELOW(ID0.SG4@3:ID0.SG4@4, ID5.SG5@3:ID5.SG5@4)

I've tried saving it as a new spreadsheet before it resets then selecting the new spreadsheet within the Analysis Study settings.

Can anyone help me?
TIA, Grace
[2022-10-01 00:16:52]
Sawtooth - Posts: 3952
the formula resets to what it was before I changed it.
You are probably editing a Sheet# that is set to get its formula from the assigned Formula Source Sheet Number setting.
Verify the Formula Source Sheet Number setting. You will only be able to edit the formula on that Sheet.

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

Login

Login Page - Create Account