Hi all..
I have wrote this in the cell L9:
=LAY OFFSET : 10 FILL_KILL : TRUE KILL_DELAY : 10 STOP : 30 TRAILING_STOP : TRUE WITH_GREENING : TRUE
Exscel reports mistake.Could someone tell me where i am wrong?
Regards
Problem with EXSCEL formula
-
beepbeep20
- Posts: 27
- Joined: Wed Feb 09, 2011 10:05 pm
If you wrote exactly how you posted in your message then it's because the = sign in excel means you're either entering a function or some kind of calculation.
You need to either not put the = sign (and just type that directly into the cell without the =)
or if you do want/need to keep it there then do it like this ="LAY OFFSET : 10 FILL_KILL : TRUE KILL_DELAY : 10 STOP : 30 TRAILING_STOP : TRUE WITH_GREENING : TRUE" (using the " double quotes)
You need to either not put the = sign (and just type that directly into the cell without the =)
or if you do want/need to keep it there then do it like this ="LAY OFFSET : 10 FILL_KILL : TRUE KILL_DELAY : 10 STOP : 30 TRAILING_STOP : TRUE WITH_GREENING : TRUE" (using the " double quotes)
I did it as you said, bat now in the status cell O9 when i trigger a bet i get an Error.
Cell O9 reports error!
In the cell L9 i paste exactly this:
="LAY OFFSET : 10 FILL_KILL : TRUE KILL_DELAY : 10 STOP : 30 TRAILING_STOP : TRUE WITH_GREENING : TRUE"
Also my stake is more than 2euro.
Cell O9 reports error!
In the cell L9 i paste exactly this:
="LAY OFFSET : 10 FILL_KILL : TRUE KILL_DELAY : 10 STOP : 30 TRAILING_STOP : TRUE WITH_GREENING : TRUE"
Also my stake is more than 2euro.
