"RANK" FUNCTION

[BERTRAND]

I have been ordering the BFSP with the said function. If there is a late scratch then I believe I will get a "0" in the SP cell and this will then become RANK 1. I have tried changing the "IF" statement to:-
IF(AND(X<>"",X<>0),RANK
but this loses RANK 1 and starts RANKING at 2. Help!

[GaryRussell]

Use a formula to create another SP column and then rank this.

eg. SP in column Y
Column Z: =if(Y5=0,1001,Y5)

You can then rank column Z and the non runners will be complete outsiders.

[BERTRAND]

Thanks Gary
Great! I can now get on with designing my first trigger.

[todger]

Apologies all but have just bought Gruss based on the excel facility and about to dash for train so have not had time to scour the forums to find answers to this question. Very much a newbie to the excel side of things so the question is: Can I put a trigger for in play only to fire in a bet at 1.01 when the in-play price on a horse is between two soecified values eg 2.0 - 3.0 ? Can this be applied to specific named horses, or even the field? Sorry if this is inappropriate in this topic.

[Captain Sensible]

Apologies all but have just bought Gruss based on the excel facility and about to dash for train so have not had time to scour the forums to find answers to this question. Very much a newbie to the excel side of things so the question is: Can I put a trigger for in play only to fire in a bet at 1.01 when the in-play price on a horse is between two soecified values eg 2.0 - 3.0 ? Can this be applied to specific named horses, or even the field? Sorry if this is inappropriate in this topic.

Yes just use the AND statement in your trigger to cover all criteria and fill the stake and odds cells with whatever odds you want

=IF(AND(F5>=2,F5<=3,$E$2="In Play"),"LAY","")

You can use LAYFIELD instead of lay if you want to lay the field

[todger]

Thank you my captain. That's a foreign language right now but I am sure it will make sense once I have properly got my head round excel which so far I have only used for very simple spreadsheets. Not sure if it delivers what I mean though from looking at it.

To clarify I want to fire in a back bet when a named (or several named) horse(s) come in to a specified range. So when it comes to between 2 and 3 in play for example, I want to trigger a back bet of say £5 at 1.01 (so that I will get matched at whatever price is in the market when the bet is fired). Is this possible, and is that what your excel coding does? (it is the word "LAY" in your code which is confusing me). Is there an area of this forum which is good for excel newbies like me? Cheers.

[Captain Sensible]

Thank you my captain. That's a foreign language right now but I am sure it will make sense once I have properly got my head round excel which so far I have only used for very simple spreadsheets. Not sure if it delivers what I mean though from looking at it.

To clarify I want to fire in a back bet when a named (or several named) horse(s) come in to a specified range. So when it comes to between 2 and 3 in play for example, I want to trigger a back bet of say £5 at 1.01 (so that I will get matched at whatever price is in the market when the bet is fired). Is this possible, and is that what your excel coding does? (it is the word "LAY" in your code which is confusing me). Is there an area of this forum which is good for excel newbies like me? Cheers.

If you to back instead you'd just use the BACK trigger - the excel triggers are available here http://www.gruss-software.co.uk/Betting ... p/help.htm look at the USING EXCEL section.

There isn't a dedicated excel section on the forum but you'll find everyone on here is willing to help if you get stuck with anything, just post in this help section if you get stuck.

Something like

=IF(AND(F5>=2,F5<=3,$E$2="In Play"),"BACK","")

would break down into

=IF( "if" just check's if something is true or false

so if this condition is true
AND(F5>=2,F5<=3,$E$2="In Play"),

do this

"BACK" enter BACK in the cell

if false do this


,"" enter "" i.e. nothing in the cell

)



AND(F5>=2,F5<=3,$E$2="In Play")

The AND condition will only return true if all the conditions are met i.e. F5 (the cell holding the current back odds)is greater or equal to 2, F5 is less than or equal to 3, cell E2 contains In Play i.e. the market is in running.

[todger]

Cheers Cap'n. Two posts in and already feels like a exceptionally civilised forum/community. I have just watched the demo video re excel which is brilliant and has helped a lot, and your settings are beginning to make sense. One (and I think last) outstanding question for now. I want the bet to be at 1.01 to take advantage of the betfair best execution policy, when my price range conditions are reached in play. Is that instruction in your code and is it even possible? My fear is that the bet will fire in at the current price and get missed by the in play delay and the market dropping past it. Appreciate the help, and sure I will pick this up rapidly with the help of this forum to a point where I might be able to contribute rather than take away.

[Captain Sensible]

Gruss uses separate columns

Column Q for the trigger i.e. back lay etc
Column R for the odds i'e stick in 1.01 etc or even using an excel formula so they can change relative to other things going on
Column S for stake, again you can either set the figure by entering a number or use a formula to do it.

Easiest way to get started is link a sheet to excel but don't have trigger betting enabled so you won't have to worry about firing off unwanted bets whilst you're tinkering around to get a feel of things.

That way your trigger conditions will still show as BACK LAY etc so you can see if your sheet is ok but it won't actually sending bets until you're happy you know what you're doing and are confident enough to let it play.

[todger]

Big thanks - will take your advice and look forward to playing around with this tomorrow in some down time.

I rewatched the demo video and picked up on the odds column, so thought I had it cracked, but still a bit confused (I think because in that example it references the contents of the cell F5, rather than a fixed figure).

I might have now worked it out with your help but will have a better idea after tomorrow's experiments. Will let you know for sure then. Thanks once again. Either way, the excel conditional triggers are a fantastic facility.

[todger]

Tried out excel yesterday - good news is that I got my head round it thanks to your script and I now understand the principles though I realise that I am only scratching the surface and it is one hell of a tool.
Bad news is a system that looked great on paper and was working well
when applied manually fell apart when I semi-automated it with excel. "Who'd've thought it?!" The good bit is that I can fool around with setting to my heart's content until I get something that works (ever the optimist) - onwards and upwards and thanks for all the help.