Support Board
Date/Time: Fri, 27 Dec 2024 17:23:33 +0000
Post From: #SYNTAX error on Spreadsheet for trading system study
| [2015-12-21 17:08:15] |
| User740483 - Posts: 6 |
|
I ended up doing something like that, but i basically used @4 instead of @3 so that i could have the 1 previous bar and 1 future bar. So technically @4 is the signal but doesn't show up until @3. If anyone knows a way around this that would be cool to. Im deffinitly open to suggestion/new ideas. Buy Signal updated: =AND(ID3.SG12@5<=-4,ID3.SG12@4<=-4,ID3.SG12@3>=-4,ID1.SG1@4<ID2.SG4@4,ID23.SG3@4<ID2.SG4@4,ID23.SG2@4<ID2.SG4@4) I tried what you said about the IF(ROW()=3,False, but it didnt work for me. My signals actually disappeared when i tried adding and tweaking with that. Visually that does look better the other way, but I want to keep it in terms that i can know and remember easier, and having the ID.SG. type thing is just easier for me even though it does look atrocious. Thanks for your help! And if anyone has any other input on maybe a way that i dont have to be lagging a bar to get my signal that would be great |