Need Help With Excel Triggered betting

[jmini123]

Hi guys,

I have been a silent member of this forum for ages. I have been using one of the basic betting bots for laying certain favs in certain races.

However a friend of mine said this can all be done with betting assistant in excel and can also be moved along to do so much more .

Now i am terrible at excel, I mean really bad and i've been reading up on the forums and watching the videos but i am still a bit lost to be honest.

What i am asking is, Is there an excel sheet that i can download that would allow me to bet on rank, ie fav, 2nd fav etc.... ? Basically, I just want to select my races in the day ( usually about 8 ) and set to automatically trigger a lay bet 60 secs before the off.

Also i want to run a sheet that just backs in the win and place markets, now i've been playing around with the place bets spreadsheet in the download area, this works well. The only thing i am not sure how to do is set it to bet in the place market aswell, If i am already running the win markets?

Do i need to have the same spreadsheet running twice with 2 tabs open on BA? One with the win markets in the quick list and the other tab with the place markets?

I am sorry if this all sounds pretty basic, but as i said i am terrible with this sort of stuff, Hence the expensive subscription to the commercial bots.

Thanks again guys and i hope someone can help?

james

[danjuma]

jmini123,

With reference to your statement

“What i am asking is, Is there an excel sheet that i can download that would allow me to bet on rank, ie fav, 2nd fav etc.... ?”

Gary provided a link to a spreadsheet (in a thread a while ago) that gives example on how to sort out the selections based on rank. Do a search to see if you can find it. If you can't, pm with your email and I shall send you the spreadsheet.

With reference to your statement

“Do i need to have the same spreadsheet running twice with 2 tabs open on BA? One with the win markets in the quick list and the other tab with the place markets?”

The win markets and place markets are two seperate markets. So you need each opened in seperate tabs and logged to seperate spreadsheets.

HTH.

Dan

[danjuma]

"...So you need each opened in seperate tabs and logged to seperate spreadsheets."



There's no reason why they can't be logged in seperate worksheets in the same spreadsheet (workbook).

Cheers

[osknows]

This is the excel formula to rank any selection

=IF(F5="","",(RANK(F5,$F$5:$F$55,1)+COUNTIF($F$5:F5,F5)-1))

The formula assumes you are ranking rows 5 - 55 in column F. Place the above into a cell in row 5 and drag down to copy to all cells. Replace F in the formula with the column you want to rank and replace 5 with the row you start from if not row 5.

Essentially, the formula ranks in ascending order and the COUNTIF statement doesn't allow duplicate ranking. Eg if two selections had the same odds of 2.0 then the first in the list would be ranked lower than the next. If you don't mind duplicate ranking use

=IF(F5="","",(RANK(F5,$F$5:$F$55,1))

[jmini123]

Thanks so much for your help guys!

I'm just back from work, so will have a look and a play about and see how I get on!! And I'll let you know if I can make it work?

Cheers

James

[jmini123]

Right I seem to be getting somewhere thanks to your help. I just have another question regarding the place bets spreadsheet?

I have input my horses names and set everything up to trigger the bet 60 secs before off. I have just seen that the bet was triggered, but in the (T) It just says cancelled? but when i checked betfair the bet had been placed ok??

Also the my bets sheet does not record the bet either?

any ideas?

cheers, james

[osknows]

Correct me if I'm wrong but I think there may be 2 possibilities

1. Your bet was placed but not matched and so was cancelled when the market went inplay. If you want to keep in play set Keep in play IP trigger to Y
or 2. The cancelled was from a previous race. In BA ensure you have the clear Refs checked for when the market updates

[jmini123]

No the bet placed 1 second after the trigger kicked in but shows cancelled in the bet ref? the bet was definatley placed as i checked through my betfair p+l?

[osknows]

I'm not sure then, best if someone else can help you. Although I do know the 'MyBets' tab in excel clears once the next market is selected. I must admit though when I log bet results in a seperate tab the results seem a bit tempremental but I haven't really examined in any detail yet

[jmini123]

ok, thanks

[danjuma]

This is the excel formula to rank any selection

=IF(F5="","",(RANK(F5,$F$5:$F$55,1)+COUNTIF($F$5:F5,F5)-1))...

Hi osknows,

Used your formula above for ranking/sorting the back odds which is great. Only problem though is that if there is a non runner and the back odds are 0.00, the sorting does not deal with this properly. Example below;

Rank
11
4
3

7
6
5
10
8

9
12
13
14

1 and 2 are missing because the cells they refer to contain odds of 0.00

Could you, or any one else, suggest how to get around this please.

Many thanks.

[osknows]

Hello,

The only thing I can think of for now is do rank the ranked column again. EG

1st rank in col A, seconf rank in col B

in A5 enter '=IF(OR(F5="",F5=0),"",(RANK(F5,$F$5:$F$55,1)+COUNTIF($F$5:F5,F5)-1))'

and in B5 enter '=IF(OR(A5="",A5=0),"",(RANK(A5,$A$5:$A$55,1)+COUNTIF($A$5:A5,A5)-1))'

There might be a better way but will have to have a think about it

[danjuma]

Hello,

The only thing I can think of for now is do rank the ranked column again. EG

1st rank in col A, seconf rank in col B

in A5 enter '=IF(OR(F5="",F5=0),"",(RANK(F5,$F$5:$F$55,1)+COUNTIF($F$5:F5,F5)-1))'

and in B5 enter '=IF(OR(A5="",A5=0),"",(RANK(A5,$A$5:$A$55,1)+COUNTIF($A$5:A5,A5)-1))'

There might be a better way but will have to have a think about it

That's worked fine osknows. Many thanks.