Selecting Race

[Shaun]

I am trying out a different betting tactic that requires me to know the most likely fav in the next race at the same venue.

Wondering if anyone has ideas on how to show the current race in excel and also load up the next race in the same venue.

I know we can't select individual races with excel but maybe if i had a list of races i maybe be able to do a calculation on how far to move forward.

[Captain Sensible]

You can select a market thru excel using GO:marketId in the Q2 trigger cell.

the marketId is sent to N3 iirc so you could always loop thru the markets on startup and store the market id and time/meeting somewhere either in an array or on the sheet to use for later. Depending on how accurate you need the data to be ,,bearing in mind a fav can easily flip flop in those 30 mins between races, you could even store the forecast price , current price or reduction factor in the same list as to a guide to what will be fav


There are plenty of other special triggers to use in Q2 that'll let you move forwards and backwards thru markets you just need to decide what the best way to suit what you're trying to do.

[Captain Sensible]

If you're using two separate sheets there is a thread somewhere about matching up win and place markets. That would take much tinkering to have it strip out the venue and line up the next market in a new tab.

[Captain Sensible]

wouldn't take*

[Shaun]

Oh, i didn't know i could select the exact market as long as i had the ID, that makes it much simpler.

I understand that the fav can change but at this moment i am relaying on a bookie site and lowest odds from the TAB and the fav 30 minutes out has had some major changes when the money comes in, not saying betfair will be better but i would at least like the opportunity to test it.

[Shaun]

Can you explain reduction factor and how i could use it, forcast price is not displayed for me after checking it in BA and may not be available on Aus races.

I tested the market ID feature and that will work fine.

[Captain Sensible]

The reduction factor is basically the same as their forecast odds just a probability of the horse winning and used to reduce the other runners odds if it were to be withdrawn , just betfairs version of rule 4 non runner deductions.

To convert it into odds it's as simple as dividing 100 by the reduction factor, the reductions always add up to 100% and Betfair are supposed to amend these on the fly in line with likely odds. Doubt they do that for the Aussie stuff though.

[Shaun]

Thanks i will have a look in to that.

[Shaun]

Created a new sheet and used this simple code on "Races" sheet

Code: Select all

Private Sub Worksheet_Calculate()
Static MyMarket As Variant
Application.EnableEvents = False
Application.Calculation = xlCalculationManual
With ThisWorkbook
If .Sheets("Races").Range("A1").Value = MyMarket Then
GoTo Xit
Else
MyMarket = .Sheets("Races").Range("a1").Value
.Sheets("Races").Range("AC" & Rows.Count).End(xlUp).Offset(1, 0).Resize(1, 6).Value = .Sheets("Races").Range("v1:aa1").Value
.Sheets("Races").Range("Q2").Value = "-1"
End If
Xit:
Application.EnableEvents = True
Application.Calculation = xlCalculationAutomatic
End With
End Sub


I just linked A1 to V1 and linked N3 to AA1 then it copies both these to row AC and scrolls through the races and copies to next line down.