Smartgambler
Pro-Punter

Go Back   OZmium Sports Betting and Horse Racing Forums > Public Forums > General Topics
Reload this Page Betfair Data formulae
User Name
Password
Register FAQ Search Today's Posts Mark all topics as read

To advertise on these
forums, e-mail us.

Reply
Page 1 of 3 1 2 3 >
 
Thread Tools Search this Thread Display Modes
  #1  
Old 15th January 2013, 11:58 AM
beton beton is offline
Member
  
Join Date: Jan 1970
Posts: 589
Default Betfair Data formulae
I Need help.
I want to check the Betfair data sheets from http://data.betfair.com.au/hr_files_finaldata.php
I want to know how to automatically work out the profit /loss of laying each race to various scenarios.
So firstly laying the field to SP liability say $100.
Secondly laying to the runners to a set SP ie $20 max.
Thirdly laying the favourite only
Fourthly laying the first few favourites only (1st and 2nd or 1,2,&3)
Conditional highlight fav and winner
I know it can be done but completely outside my capability at present.
Thanks in advance Beton
Reply With Quote
  #2  
Old 15th January 2013, 02:01 PM
stugots stugots is offline
Banned
  
Join Date: Jan 1970
Posts: 879
Default
Something like this beton?

As I had to use array formulas to calculate the favourite returns, the calculations are demanding on most pc's so I have limited the worksheet size to 2000 records, which should suffice for you average day.

Dont think I have made any errors, but I did make a mistake once, so buyer beware
Attached Files
File Type: xlsm beton bf file.xlsm (1.45 MB, 1339 views)
Reply With Quote
  #3  
Old 15th January 2013, 02:25 PM
beton beton is offline
Member
  
Join Date: Jan 1970
Posts: 589
Default
Quote:
Originally Posted by stugots
Something like this beton?

As I had to use array formulas to calculate the favourite returns, the calculations are demanding on most pc's so I have limited the worksheet size to 2000 records, which should suffice for you average day.

Dont think I have made any errors, but I did make a mistake once, so buyer beware

Thanks stugots
exactly what I need.
I will have a glass or two of red for you tonight.
beton
Reply With Quote
  #4  
Old 15th January 2013, 03:16 PM
stugots stugots is offline
Banned
  
Join Date: Jan 1970
Posts: 879
Default
benton, it may make things easier allround to delete out all the place records prior to using bf's data

The code below does the job, let me know if you need instructions on use

Code:
Sub delete_place_records()

Dim lst As Long
Dim i As Long


lst = Range("E" & Rows.Count).End(xlUp).Row


For i = lst To 1 Step -1


    If Range("E" & i).Value Like "TO BE PLACED" Then
        
        Range("E" & i).EntireRow.Delete
        
    End If


Next i
End Sub
Reply With Quote
  #5  
Old 15th January 2013, 06:07 PM
beton beton is offline
Member
  
Join Date: Jan 1970
Posts: 589
Default
Quote:
Originally Posted by stugots
benton, it may make things easier allround to delete out all the place records prior to using bf's data

The code below does the job, let me know if you need instructions on use

Code:
Sub delete_place_records()

Dim lst As Long
Dim i As Long


lst = Range("E" & Rows.Count).End(xlUp).Row


For i = lst To 1 Step -1


    If Range("E" & i).Value Like "TO BE PLACED" Then
        
        Range("E" & i).EntireRow.Delete
        
    End If


Next i
End Sub

stugots
Thanks again.
I have absolutely no idea where and how to put the code in. But I would like to. My New Years resolution "Learn Excel"
I am bringing a 2000 Glenowen Shiraz down to table To have a drink for you. Organic from 100yr old rootstock.
beton
Reply With Quote
  #6  
Old 15th January 2013, 06:10 PM
Lord Greystoke Lord Greystoke is offline
Member
  
Join Date: Mar 2012
Posts: 1,237
Default
Blimey... perhaps send the man a bottle??

Cheers LG
__________________
The trick isn't finding profitable angles, it's finding ones you will bet through the ups and downs - UB
Reply With Quote
  #7  
Old 15th January 2013, 06:51 PM
beton beton is offline
Member
  
Join Date: Jan 1970
Posts: 589
Default
Quote:
Originally Posted by Lord Greystoke
Blimey... perhaps send the man a bottle??

Cheers LG

Next case.
Reply With Quote
  #8  
Old 15th January 2013, 07:29 PM
stugots stugots is offline
Banned
  
Join Date: Jan 1970
Posts: 879
Default
No problem benton, when I get a bit of time tomorrow I will upload a new workbook with an option to delete the place bets - do you also want to get rid of the trot & pace races as well?

Looking back it wasn't that long ago I knew naff all about Excel & got a great deal of help from the Excel For Dummies book which I can highly recommend to get you going. Once that's under your belt then Excel VBA For Dummies is also a must read.
Reply With Quote
  #9  
Old 15th January 2013, 08:56 PM
beton beton is offline
Member
  
Join Date: Jan 1970
Posts: 589
Default
Quote:
Originally Posted by stugots
No problem benton, when I get a bit of time tomorrow I will upload a new workbook with an option to delete the place bets - do you also want to get rid of the trot & pace races as well?

Looking back it wasn't that long ago I knew naff all about Excel & got a great deal of help from the Excel For Dummies book which I can highly recommend to get you going. Once that's under your belt then Excel VBA For Dummies is also a must read.

Thanks stugots
I will buy them tomorrow.
What you have done is great. I have just gone thru and highlighted the races that I am interested in testing against other data. (starting in DEC) It was only Saturday and Sunday 42 races. I deleted all other races manually. It worked a treat.
If you can delete the placed and the trots and pacers that will be great.

My initial aim is to check laying against data we have collected since Sept. However if we can get the excess removed I will go back as far as I can against BF data, and send you the summary. Beton
Reply With Quote
  #10  
Old 16th January 2013, 11:59 AM
stugots stugots is offline
Banned
  
Join Date: Jan 1970
Posts: 879
Default
new version attached beton

As the number of records is greatly reduced after removing place/trots/pace records each betfair file will comfortably fit on one excel worksheet, anyway see how you go with it, any questions let me know.
Attached Files
File Type: xlsm beton bf file V2.xlsm (2.35 MB, 575 views)
Reply With Quote
Reply
Page 1 of 3 1 2 3 >

« Previous Thread | Next Thread »

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is On
Forum Jump



All times are GMT +10. The time now is 09:21 PM.

Contact Us - OZmium Pty Ltd - Archive - Terms of Use - Privacy Statement - Top

Powered by: vBulletin Version 3.0.3
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
©2008 OZmium Pty. Ltd. All rights reserved . ACN 091184655