Is there any reason why you want to use excel rather than guardian? excel is more flexible when it comes to wanting bespoke commands but its not as fast as guardian's automation
For what your requiring there's no reason or advantage to wanting to use excel unless its part of a larger strategy that requires it be done in excel?
=LAY OFFSET:1 FILL_KILL:TRUE KILL_DELAY:60 STOP:3 TRAILING_S
Hi amberleith
When Betangel does an offset with stop it first calculates the offset stake and then sets the stop stake to be the same.
Without greening both the offset stake and the stop stake will be equal to the original lay (or back) stake.
With greening you can end up with the strange outcome you are seeing...
If you are laying about £10 at around 10 with an offset of 100 ticks then the offset odds will be somewhere around 600
so the correct offset stake to green up at those odds will be roughly 9 pence.
Betangel then just sets the stop stake to be the same. This will happen in Excel and in Guardian.
Instead of using a stop loss you might be able to achieve what you want by greening up when the loss exceeds a predefined amount.
When Betangel does an offset with stop it first calculates the offset stake and then sets the stop stake to be the same.
Without greening both the offset stake and the stop stake will be equal to the original lay (or back) stake.
With greening you can end up with the strange outcome you are seeing...
If you are laying about £10 at around 10 with an offset of 100 ticks then the offset odds will be somewhere around 600
so the correct offset stake to green up at those odds will be roughly 9 pence.
Betangel then just sets the stop stake to be the same. This will happen in Excel and in Guardian.
Instead of using a stop loss you might be able to achieve what you want by greening up when the loss exceeds a predefined amount.
-
amberleith
- Posts: 35
- Joined: Sat Apr 09, 2016 11:50 am
Excel is important for selecting the runners I want to Lay, I'm doing a whole bunch of calculations with dozens of =if statements that couldnt be reproduced in guardian.
I think I've figured out a way to do it, its not pretty but it will work.
When AC10 equals nothing, one command is sent to L9 if triggered and when it does have a value, the GREEN command is sent when some other conditions are met. Its giving me a massive headache, for some reason I just feel like I've missed something entirely, surely theres a simple command to add to the report cell that automatically greens a matched bet after so many ticks?
If I was looking to trade the matched bet for an all green profit, for example lay at 4.0 and back at 4.5, rather than having a straight lay on a drifting price, then the corresponding stop loss bet is easy peasy.
I think I've figured out a way to do it, its not pretty but it will work.
When AC10 equals nothing, one command is sent to L9 if triggered and when it does have a value, the GREEN command is sent when some other conditions are met. Its giving me a massive headache, for some reason I just feel like I've missed something entirely, surely theres a simple command to add to the report cell that automatically greens a matched bet after so many ticks?
If I was looking to trade the matched bet for an all green profit, for example lay at 4.0 and back at 4.5, rather than having a straight lay on a drifting price, then the corresponding stop loss bet is easy peasy.
-
amberleith
- Posts: 35
- Joined: Sat Apr 09, 2016 11:50 am
Tanden wrote:Hi amberleith
When Betangel does an offset with stop it first calculates the offset stake and then sets the stop stake to be the same.
Without greening both the offset stake and the stop stake will be equal to the original lay (or back) stake.
With greening you can end up with the strange outcome you are seeing...
If you are laying about £10 at around 10 with an offset of 100 ticks then the offset odds will be somewhere around 600
so the correct offset stake to green up at those odds will be roughly 9 pence.
Betangel then just sets the stop stake to be the same. This will happen in Excel and in Guardian.
Instead of using a stop loss you might be able to achieve what you want by greening up when the loss exceeds a predefined amount.
Yeah I guessed that was ther case when I tried changing the offset tick value down a bit.
Thank you for the replies people, I'm sorryu for cluttering your forum by talking to myself!