excel newbie

[anthony]

Hi
Is this possible to do ..... in different races i will want to lay a particular horse
and each horse will have a minimum price and a maximum price and if it goes off between these 2 prices ,the bet should be layed at betfair sp

and is it difficult to set up !

thanks

[eclipse]

This is definitely possible as I have an Excel sheet that does almost exactly the same as that. Writing it from scratch if you're new to Excel might be a challenge though, if you need someone to write one then you might try the Excel Developer section.

[osknows]

Hi Anthony,

This should get you started with what you need http://www.mediafire.com/?zdzdymgduzwnirz

[anthony]

Thankyou very much ...will have a good look at spreadsheet later thanks

[anthony]

the problem ,I think is insurmountable as it is impossible to know exactly when the race is going to go off and I want certain price parameters about 10 secs before or right at the actual off . The bet ,if it reached the price parameters eg between 2.5 and 4.5 would then be layed at betfair sp.

maybe it could be done immediately the race goes in play ?

any ideas ?

[mak]

Hi Anthony
in order to get appropriate help, i think it would be better to be more specific for what you exactly you need

[anthony]

hi Mak,
. I want to lay a horse that comes within certain price parameters just before the actual off...not the official starting time . Either to lay in real time [eg as they are loading the stalls] or if the price parameters are met to lay the horse at betfair sp.

[mak]

So, you would be fine if you just lay some horses at BFSP?
If that is the case you could have an if statement

When you log the sheet to excel tick SP only (from additional Columns)

SP will be in column Y
for example in cell AA5 place this =if(and(y5<=X,y5>=Z),"BET","NoBET")
X=your maximum odds
Z=your minimum odds

in the trigger column (Q) you can place something like
=IF(AND($E$2="In Play",$F$2<>"Suspended",AA5="BET"),"LAY","wait")

With this (haven't test - please be careful) when the market turns in play and SP is at your desired range will fire a LAY bet

Hope that helps


** don't forget to "drag" down the formulas at AA & Q columns
** if you have problem with the formulas replace , with ;

[anthony]

thanks mak