Hi Nitsud,
The following may help.
=IF(ISTEXT(F4),INT(RIGHT(F4,5)*1*24)-1,INT(F4*60*24))+1
it counts down to and from the off in mins. In H4 you can see it's been 1 min since the off.
Your formula could go something along the lines of:
=IF(AND(H4>=1,H1="Suspended"),"Bet","")
as shown in J4.
When you enter the formula, change the format to general (excel usually auto formats as time, but that's no good).
By the way, how did you solve your previous problem?
Nigel.
BetAngel_Multiple HELP :S
Thank you for your response.
=IF(AND(H4>=1,H1="Suspended"),"Bet","") This could very well work. Is it going to wait 60 seconds after suspended to place the bet?
How could I combine the above code with my conditions that have to be met. Which is what works
=IF(OR(G13>=8,G13<=1.98),"GREEN_ALL","")
I then change the odds in the above code which various from selection to selection.
Which would be perfect but the odds drop to 1.2 or 1.1 when the market is suspended and ends up greened up in negative. It just needs to wait a while for odds to settle and then check the condtions are right before greening up.
Hope and understand what I am trying to say. Thanks for this help it will work perfectly with this tweak as I can't be at the pc when there are a few good games on (All hours of the night and day).
Hope to hear from you soon!
Many thanks
=IF(AND(H4>=1,H1="Suspended"),"Bet","") This could very well work. Is it going to wait 60 seconds after suspended to place the bet?
How could I combine the above code with my conditions that have to be met. Which is what works
=IF(OR(G13>=8,G13<=1.98),"GREEN_ALL","")
I then change the odds in the above code which various from selection to selection.
Which would be perfect but the odds drop to 1.2 or 1.1 when the market is suspended and ends up greened up in negative. It just needs to wait a while for odds to settle and then check the condtions are right before greening up.
Hope and understand what I am trying to say. Thanks for this help it will work perfectly with this tweak as I can't be at the pc when there are a few good games on (All hours of the night and day).
Hope to hear from you soon!
Many thanks
OK.
The "last updated" and "event start" won't give us an indication of what time the event started.
That leaves us with the countdown timer and the suspended and inplay indicators.
For UK and Irish racing the countdown timer starts off as a number, doing what it says, counting down the mins til the off.
After the official off time, it changes from a number to a text ie, -1, -2, etc, etc.
However, as soon as the race goes inplay, it changes back to a number, displaying how long the event has been inplay.
Therefore, we can use this to answer "how long has it been in-play"
In G3 you'll see the formula:
=IF(G1="In-play",INT($F$4*60*24),0)
which gives us the mins since the race started.
In H5 you'll see:
=IF(OR(AND(G13>=8,G13<=1.98),G3>=1),"GREEN_ALL",0)
which is your original formula plus the extra condition of greater than or equal to 1 min.
In G5 is your original formula, which has always been showing, and in H5 the 'new' formula, which only appeared after 1 min.
For "Foreign" racing (not sure about other sports) the "inplay" does not show, and the countdown timer remains text based, so the above formulas will not work.
There is a solution, but it will have to be done with code as well as formulas.
The "last updated" and "event start" won't give us an indication of what time the event started.
That leaves us with the countdown timer and the suspended and inplay indicators.
For UK and Irish racing the countdown timer starts off as a number, doing what it says, counting down the mins til the off.
After the official off time, it changes from a number to a text ie, -1, -2, etc, etc.
However, as soon as the race goes inplay, it changes back to a number, displaying how long the event has been inplay.
Therefore, we can use this to answer "how long has it been in-play"
In G3 you'll see the formula:
=IF(G1="In-play",INT($F$4*60*24),0)
which gives us the mins since the race started.
In H5 you'll see:
=IF(OR(AND(G13>=8,G13<=1.98),G3>=1),"GREEN_ALL",0)
which is your original formula plus the extra condition of greater than or equal to 1 min.
In G5 is your original formula, which has always been showing, and in H5 the 'new' formula, which only appeared after 1 min.
For "Foreign" racing (not sure about other sports) the "inplay" does not show, and the countdown timer remains text based, so the above formulas will not work.
There is a solution, but it will have to be done with code as well as formulas.
You do not have the required permissions to view the files attached to this post.
Thank you so much!
I have been trying to wrap my brain around this formula. It is nearly perfect but it doesn't work. As I am using this for football.
In football when ever a goal is scored the market is suspended. So what I need is for it to wait sixty seconds after suspended - which can happen anythime during inplay. The In-play indicator does show ones the football starts. But I am not sure what format the timer is.
I reall appreciate all your time and effort. I am just this one step away from havin it automated where I don't need to manually add a stop loss. Cause a manual stop loss in betangel cancels itself if the market is suspended as well as if you change markets to trade another game!
Would appreciate any help.
Thankyou!!!
I have been trying to wrap my brain around this formula. It is nearly perfect but it doesn't work. As I am using this for football.
In football when ever a goal is scored the market is suspended. So what I need is for it to wait sixty seconds after suspended - which can happen anythime during inplay. The In-play indicator does show ones the football starts. But I am not sure what format the timer is.
I reall appreciate all your time and effort. I am just this one step away from havin it automated where I don't need to manually add a stop loss. Cause a manual stop loss in betangel cancels itself if the market is suspended as well as if you change markets to trade another game!
Would appreciate any help.
Thankyou!!!
-
Martybhoy99
- Posts: 28
- Joined: Sat Feb 19, 2011 3:53 pm
Hi Nitsud - are you creating an automated spreadsheet to lay the draw?
I am working on similar..
I am working on similar..
Hi there,
Yeah I am. Just stuck on the waiting 1 minute to check the odds after suspension. As you know the market gets suspended when a goal or a card is issued! The odds then drop to +- 1.2 for a few seconds then settle again. So with my stop loss at say <2.2 - after suspension it greens up in the red. Where as if it just waits a minute it'll green up in the green and be a successful trade.
Any help would be greatly appreciated!!!
Yeah I am. Just stuck on the waiting 1 minute to check the odds after suspension. As you know the market gets suspended when a goal or a card is issued! The odds then drop to +- 1.2 for a few seconds then settle again. So with my stop loss at say <2.2 - after suspension it greens up in the red. Where as if it just waits a minute it'll green up in the green and be a successful trade.
Any help would be greatly appreciated!!!
I am trying to work out how to add a separate timer that will start counting down once the market goes inplay after any inplay suspension - not just at the start of the game. It will then count down 60 seconds and then check the conditions to green up.
Any help with regards this would be MUCHLY appreciated!!!
Any help with regards this would be MUCHLY appreciated!!!
Hi
Just my 2p worth..
Just be very careful using the Green and Green_all command in play...(If that is what you intend doing)..
If the market is a fast moving market, you are not guaranteed that it will work in your favour (Less so in slow moving markets)...
It is sometimes better to work out your own command based on the current odds and the profit on that individual selection..
regards
Peter
Just my 2p worth..
Just be very careful using the Green and Green_all command in play...(If that is what you intend doing)..
If the market is a fast moving market, you are not guaranteed that it will work in your favour (Less so in slow moving markets)...
It is sometimes better to work out your own command based on the current odds and the profit on that individual selection..
regards
Peter
Last edited by PeterLe on Sat Jun 11, 2011 7:24 pm, edited 1 time in total.
Thanks Peter. Its on FOOTBALL. So yeah the the odds only drastically change when something drastic happens. The idea is also only to play on games where you sure something drastic will happen.
My main concern at the moment is to green when it passes particular odds range. Which insures the stop loss.
My main concern at the moment is to green when it passes particular odds range. Which insures the stop loss.