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 2 1 2 >
 
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 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
  #8  
Old 16th January 2013, 12:18 PM
beton beton is offline
Member
  
Join Date: Jan 1970
Posts: 589
Default
Quote:
Originally Posted by stugots
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.

Thanks again stugots, I will look at it tonight. beton
Reply With Quote
  #9  
Old 16th January 2013, 02:47 PM
stugots stugots is offline
Banned
  
Join Date: Jan 1970
Posts: 879
Default
few changes to also delete jockey/specials/antepost entries
Attached Files
File Type: xlsm beton bf file V3.xlsm (2.07 MB, 453 views)
Reply With Quote
  #10  
Old 16th January 2013, 03:14 PM
beton beton is offline
Member
  
Join Date: Jan 1970
Posts: 589
Default
Thanks stugots. Off to the bookstore
Reply With Quote
Reply
Page 1 of 2 1 2 >

« Previous Thread | Next Thread »

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Hybrid Mode Hybrid 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 04:57 AM.

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