Login Password
Forgot?
Free Trial

You are here : Home - Help & Information - Excel User Tips

Microsoft Excel User Tips

A member contacted us to request that instead of the Starting Price Odds being included in the System Builder Qualifiers download area, the Betfair Estimated Odds Calculation was used instead.

The code to actually offer this as an option would significantly slow down the excel download, therefore if you do wish to do this it is best to use an Excel formula to create the estimated Betfair Odds.

This can be done by adapting the following formula in Excel to suit your requirements. Note in this example the numerical odds are in column D (which is why the formula refers to cell D2). The percentages should be changed to reflect what you believe is the realistic mark up in terms of the price available on Betfair compared to Official Starting Price in each odds range. If you are having trouble, please contact us.

Excel Formula to Create Estimated Betfair Odds
=ROUND(IF(D2<1,D2*108%,IF(D2<3,D2*109%,IF(D2<6,D2*110%,IF(D2<11,D2*111%,IF(D2<17,D2*112%,IF(D2<34,D2*114%,D2*116%)))))),2)

Advice for Layout in Excel (From Mike)

Here is a bit of techno advice that WILL help your subscribers. After you download your daily report onto Excel. You then go to the numbers margin on the left of the grids. You then highlight no. 2 line by clicking on the number. This then highlights the row. Then click on the windows tab at the top of the screen, and then click freeze panes in the drop down menu. By doing this, you then freeze the top header line, so keeping the description of the columns always showing when scrolling down. Hope this helps - Mike



This page loaded in 0 seconds.

Coming together is a beginning, Keeping together is progress, Working together is success.
Henry Ford
HorseRaceBAse on Twitter