Help With Not Laying Favourite

[kejay1979]

Hi, I hope this will be a simple question for those of you on here.
Tonight I played around with the excel sheet to enable me to do triggered laying whilst at work.
I do not want to lay if the horse is favourite just before the off.
I produced a formula which I thought would solve this by not laying my horse from the selection sheet if it was in cell A5 on the market sheet, and by setting BA to list horses in price order.
I felt very pleased with myself until it didn't work LOL.
It was then that I noticed that although BA was listing the USA horses in price order they were still being listed in betfair order on my market sheet. This meant that although the USA fav was listed top on the BA programme it was not listed at the top (cell A5) on the market sheet of the excel place bet sheets.
Is there any way the horses can be listed in price order on the market sheet rather than in betfair order.
THANKS

[alrodopial]

Use the "rank" and link your formulas to it
http://www.gruss-software.co.uk/forum/v ... light=rank

[kejay1979]

Thanks for that reply.

Unfortunately I believe (and I'm an excel novice) that requires that I need to know in what cell on the market sheet my horse will be.

I will be listing up to 20 horses on the selection sheet before going to work and although I understand the RANK principle I need to compare each horse on my selection sheet with all other horses in its race to ensure it's not ranked 1, without knowing what cell on the market sheet my horse will appear.

As far as I can see (and I am a novice lol) that formula and any I come up with requires knowing where my horse is listed and so cannot be left to trigger while I'm at work.

Or am I wrong ????

[alrodopial]

If you place the rank in cells AA5 and down try this in cells Q5 and down:

Code: Select all

=IF(ISNUMBER(MATCH(A5,'SelectionSheet'!$A$1:$A$20;0)),IF(AA5<>1,"BACK",""),"")

In cells A1 to A20 in "SelectionSheet" your picks.

It can be done with the "lookup" formula instead of the "match" but I never managed to make the lookup formula to work

[kejay1979]

Hi alrodopial

Thanks for your help.

I tried putting your latest formula on my excel sheet but i kept getting an "error in formula" message.

I copied and pasted so I know i entered the formula correctly.

Could you check the formula you posted please.

Many thanks

[alrodopial]

Try this

Code: Select all

=IF(ISNUMBER(MATCH(A5,'SelectionSheet'!$A$1:$A$20,0)),IF(AA5<>1,"LAY",""),"")

[kejay1979]

Hi All.

Firstly let me say I am not an excel expert unfortunately

However, I've been using the excel sheet successfully to lay horses a few seconds before the race starts provided they are not the favourite.

I've done this by adding a ranking column to the market sheet and inserting an extra condition into the trigger column so that the bet is not layed if my horse is ranked 1 at the time of triggering.

I would now like to add an extra condition but am having no luck with my efforts.

I would like to add the conditon that :- my horse should be a minimum price above the favourite such as 0.5 (half a point). So if the favourite at triggering time is 3.2 then my horse must be a minimum of 3.7

Any ideas from those excel experts on the forum.

Thanks in advance.