1/2 way there

[womble]

G'day All,

I'm well and truely an amature when it comes to this triggered betting stuff so am hoping someone can help me out.

I have got most of what i want worked out but i have two major problems

Basically, the system i've 1/2 created checks each horse against the criteria i've set in an IF formula and the bet would go on like i want it to (testing whilst logged out). Problem one is that after the bet is made and before the market closes, the horse that meets the criteria can change and another bet gets placed on the new qualifier. I only want to play one horse even if the market changes and another horse becomes the qualifier so need a way of stopping anymore bets being placed once the first one is made.

Problem two is, and this has probably been dealt with somwhere but i couldn't find it, how do you allow for different field sizes. The IF formula thing i use goes against each horse in the trigger column and within it i compare the prices for all the horses eg - if there are 10 horses i get it to look at F5:F14 if there are 8 - F5:F12 ETC.

Is there an easy way to automatically substitute the right number of runners into the IF formula ???

I hope this makes sense - i should probably be using macros and stuff but that's WAYYYYYY to complicated

Thanking you in advance,

[Captain Sensible]

Problem 1 - The way I usually sort this is by including an AND statement in the code looking at the max value in the bet ref column. If the betref is over 1 it means a bet has been placed and the code wont kick off again.

Obviously if two runners match your criteria before a bet is placed it will kick off on both, also the in running delay may need to be taken into account. without knowing the criteria you're using it's hard to say what you need to add but adding extra criteria within your code would be needed to stop multiple bets.

Problem 2 - again without knowing what you're trying to do it's a bit hard to second guess, but you've formulas like COUNT if you want to see how many runners or RANK if if you need to know the position in the betting. Most of my formulas account for say 40 runners but if the there's no data for for say horse 20 my formulas use an the IF statement and just replace the value with nothing ("") then any MAX(F5:F45) or such wont include any #DIV problems.

i'e. in my O column

=IF(AND(A21<>"", F21<0.01), 1.01,IF(OR(F21="",F21=0),"",F21))

just checks that there's a runner in A21 if there is it'll fill in the F column with the odds if not it'll show as nothing

[womble]

Thanx Captain - will plug them in once i get home from my day job