Login Page - Create Account

Support Board


Date/Time: Wed, 24 Apr 2024 17:46:39 +0000



Post From: Programming - Referencing different chart in spreadsheet

[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