IS IT POSSIBLE

[jsn9999]

i am looking to lay all horses in the middle collumn on the left hand side.

eg.

back lay

2.02 2.04 2.06 2.08 2.1 2.12

4.1 4.2 4.3 4.4 4.5 4.6

6.0 6.2 6.4 6.6 6.8 7.0

i would like to lay all the field at the price 2.04, 4.2, 6.2 etc

at the moment i have to click lay all (on the standard betfair interface) and click each price 2 or three times to get me back to the left hand collumn.

[Ian]

Very easy to do using triggered betting in Excel.

[jsn9999]

not too computer litterate

how do i do that ian?

or anybody?

[Ian]

Have you got Excel 2003 on your computer ?

[jsn9999]

hi ian,

thanks for your assistance.

have got excel. (not sure if it is excel 2003)

[jsn9999]

think it is excel 2003.

how do i do it?

ta

[jsn9999]

anyone know?

[treehead]

hello

You can get excel video trainng for free from microsoft's excel site.
I learned the basics in a few hours

[Captain Sensible]

In your odds column R you just need to enter something like

=+IF(OR(D5="",D5=0),"",D5) and copy it down the cells from R5 to how many runners they'll be in market - copying down to R50 should cover most markets unless you're laying golf markets etc.

That will populate the Odds column with the back odds from the middle "to back" column where odds appear.

In the stakes column enter something like

=+IF(OR(R15="",R15=0),"",ROUNDDOWN(stake/R15,2)) where stake is whatever liability you wish the market to be laid to i.e. £100 or whatever.

Just copy that down the stakes column from S5 to S50.

In the trigger column Q5 to Q50 just enter "LAY" and it'll lay the bets to a set liability (stake) . It's generally best to have some other conditions to fill in the trigger column as just leaving it on LAY will kick off everytime you go to that market so play with small stakes until you know what you're doing.