Recording of Betfair Data

[AndrewP]

I know it's probably covered elsewhere on the forum but can anyone tell me the legal position with regard to recording Betfair market data for personal use. Is this permitted?

Also, is it possible using VBA and BA/Excel to create a csv file having the same name as the event being monitored and write data from certain cells to it as triggers fire? A sort of 'test' trading record if you like where not all data is recorded, only that relating to the triggered bets.

If it is possible can anyone help me with setting this up?

regards,

Andrew

[AndrewP]

Mmmmm.

Can anyone recommend a good web site then where I might find help on saving ranges from Excel to text files. Failing that, a pointer to saving ranges to a separate worksheet (and incrementing the rows) will do.

Thanks,

Andrew

[GaryRussell]

I don't think there is a problem recording data for personal use, but we are certainly not allowed to provide software to allow you to do this unfortunately.

[AndrewP]

Thanks Gary, the legal position is as I thought.

Now I just need to learn enough VBA to enable me to record data as bets are triggered. It's not just the betfair data such as price (I can get this from Betfair by placing very small bets) but I also need the data from my spreadsheet calculations that trigger the bets so I can analyse it. In this case it's an 'extent of value' that is calculated dynamically as prices fluctuate.

I'll get the books out.

Many thanks

Andrew

[alrodopial]

Sample sheet for recording odds:
http://gruss-software.co.uk/forum/viewt ... sc&start=0

Extra excel help:
http://www.mrexcel.com/forum/index.php

[AndrewP]

Alrodopial

Many thanks for the links. I've now managed to achieve what I set out to do and I've found lots of useful stuff on the MrExcel message board.

I'm not sure I've fully worked out the code in your 'soccer odds' sheet though. Is there any chance you (or anyone else for that matter) could put comments against each line or section of code to explain what it is doing?

Regards,

Andrew

[alrodopial]

Code: Select all

Private Sub Worksheet_Change(ByVal Target As Range)
    ' Run the below code  only if there is a full update from BA (16 columns chance)
    If Target.Columns.Count = 16 Then
       
        Application.EnableEvents = False
        ' HT = extract the name of home team
        HT = Trim(Left(Range("A1"), InStr(Range("A1"), "v") - 1))
        ' If there is a new game (home team diff than previous games' home team) clear old data
        If HT <> Range("C21").Value Then Range("A21:IV65536").ClearContents
        'Find last row with data at column A
        LR = Range("A65536").End(xlUp).Row
        ' AT = extract the name of away team
        AT = Trim(Mid(Range("A1"), InStr(Range("A1"), "v") + 1, InStr(Range("A1"), "-") - InStr(Range("A1"), "v") - 1))
        ' ST = extract the starting time of game
        ST = Trim(Mid(Range("A1"), InStr(Range("A1"), ":") - 2, 5))
        ' CT = place current time
        CT = Time

        ' AM_H = Amount matched for home win
        ' AM_A = Amount matched for away win
        ' AM_D = Amount matched for draw

        If LR = 20 Then
            ""
            AM_A = ""
            AM_D = ""
        Else
            AM_H = Range("P5").Value - Range("R" & LR).Value
            AM_A = Range("P6").Value - Range("AJ" & LR).Value
            AM_D = Range("P7").Value - Range("BB" & LR).Value
        End If
        ' Create an array (range) with the below info and copy it at range A?:S?
        MyArray = Array(CT, ST, HT, "", Range("B5"), Range("C5"), Range("D5"), Range("E5"), Range("F5"), Range("G5"), Range("H5"), Range("I5"), Range("J5"), Range("K5"), Range("L5"), Range("M5"), Range("O5"), Range("P5"), AM_H)
        Range("A" & (LR + 1) & ":S" & (LR + 1)).Value = MyArray
        ' Create an array (range) with the below info and copy it at range U?:AK?
        MyArray = Array(AT, "", Range("B6"), Range("C6"), Range("D6"), Range("E6"), Range("F6"), Range("G6"), Range("H6"), Range("I6"), Range("J6"), Range("K6"), Range("L6"), Range("M6"), Range("O6"), Range("P6"), AM_A)
        Range("U" & (LR + 1) & ":AK" & (LR + 1)).Value = MyArray
        ' Create an array (range) with the below info and copy it at range AM?:BC?
        MyArray = Array("Draw", "", Range("B7"), Range("C7"), Range("D7"), Range("E7"), Range("F7"), Range("G7"), Range("H7"), Range("I7"), Range("J7"), Range("K7"), Range("L7"), Range("M7"), Range("O7"), Range("P7"), AM_D)
        Range("AM" & (LR + 1) & ":BC" & (LR + 1)).Value = MyArray
       
        Application.EnableEvents = True
       
    End If
   
End Sub


[AndrewP]

That's excellent, it will help my learning considerably.

Many thanks,

Andrew

[thunderfoot]

I don't think there is a problem recording data for personal use, but we are certainly not allowed to provide software to allow you to do this unfortunately.

Ummmm!! I use BA/BT and EXCEL to record data, so is using BA/BT as a tool linked to EXCEL breaking the rules!!??

[GaryRussell]

I don't think there is a problem recording data for personal use, but we are certainly not allowed to provide software to allow you to do this unfortunately.

Ummmm!! I use BA/BT and EXCEL to record data, so is using BA/BT as a tool linked to EXCEL breaking the rules!!??

Not for the purpose of triggering bets based on current odds. Betfair are ok with this. What else you do with this capability is up to you

[Lynx pardina]

Please, could anyone help me step by step in the use of the excel file for recording match odds?
I can't record, it did nothing when i log the market.
Thank you.