Login Page - Create Account

Support Board


Date/Time: Fri, 27 Dec 2024 17:09:21 +0000



Post From: #SYNTAX error on Spreadsheet for trading system study

[2015-12-21 13:08:43]
User740483 - Posts: 6
Hey there, Maybe someone can help me with my code. I have looked it up and down and cannot see the problem for some reason.

It works for my "color bar based on alert condition" studies. The only thing I changed was the O,H,L,C in my code to the ID2.SG1,ID2.SG2..etc, that it shows in the spreadsheet for the OHLC values of the chart. There is only one set of parenthesis. just brainstorming, but does the spreadsheet function still have the ability to do the 1 bar back [-1] or forward [1]? I figure it can, but I really dont know what else the problem could be.

Screenshot:https://dl.dropboxusercontent.com/u/2255790/Untitled22.png
Buy Entry
=AND(ID3.SG12<=-4,ID3.SG12[-1]<=-4,ID3.SG12[1]>=-4,ID1.SG1<ID2.SG4,ID23.SG3<ID2.SG4,ID23.SG2<ID2.SG4)
Sell Entry
=AND(ID3.SG7>=4,ID3.SG7[-1]>=4,ID3.SG7[1]<=4,ID1.SG1>ID2.SG4,ID23.SG3>ID2.SG4,ID23.SG2>ID2.SG4)

If anyone could help that would be amazing! thanks!
Date Time Of Last Edit: 2015-12-21 13:08:52