Recording odds with BA

Please post any questions regarding the program here.

Moderator: 2020vision

Postby nicc78 » Sun Jan 15, 2012 4:24 pm

I wand to record coupon market over -under and I used used file from 4shared.com/office/706M4cVE/RECORDING_SOCCER_ODDS.html
I can not record odds in file,very poor record!
nicc78
 
Posts: 2
Joined: Sun Jan 15, 2012 4:12 pm

Postby nicc78 » Sun Jan 15, 2012 4:28 pm

I search betfair odds database for soccer games
My email nicc78@gmail.com
nicc78
 
Posts: 2
Joined: Sun Jan 15, 2012 4:12 pm

Postby brumbie » Tue Jan 24, 2012 7:12 am

If you just want to record BA excel sheet while it logs the prices then there is a free cam recorder that records it for you here.

http://camstudio.org/
brumbie
 
Posts: 197
Joined: Tue Dec 28, 2010 2:00 am
Location: Brisbane,Australia

odds recording

Postby modelman » Tue Jan 31, 2012 1:25 am

I am interested in sports betting where two teams or two individuals are competing. I want to write trigger formulas to BACK a player or team only if previous LAY on that player or team was matched. How can the previous LAY match be stored and identified in order that my formula can refer to it.?
Thanks anyone who can help.
Life may not be the party we hoped for, but while we are here we might as well dance.
modelman
 
Posts: 3
Joined: Wed Dec 14, 2011 11:03 am
Location: Japan

Postby NewSignal » Fri Feb 01, 2013 6:35 pm

hey, can anyone put again the file online ?
NewSignal
 
Posts: 7
Joined: Wed Dec 26, 2012 10:12 pm

Postby alrodopial » Fri Feb 01, 2013 8:13 pm

alrodopial
 
Posts: 1353
Joined: Wed Dec 06, 2006 9:59 pm

Postby NewSignal » Fri Feb 01, 2013 11:05 pm

thks man
NewSignal
 
Posts: 7
Joined: Wed Dec 26, 2012 10:12 pm

Postby antalytics » Sat Jul 20, 2013 12:36 am

None of the links seem to work anymore in this thread, are there any links to a working example to help me record live Betfair odds or can a kind soul post a working link? Thank you
antalytics
 
Posts: 2
Joined: Sat Jul 20, 2013 12:25 am

Re: Recording odds with BA

Postby pie2251 » Mon Dec 11, 2017 10:52 pm

G'day Just Found This Handy Little Excel File Well Done.
Is There A Way To Modify The VBA To Collect
Back3 | Back2 | Back1 | SP | Lay1 |Lay2 |Lay3
Thanks In Advance :D
pie2251
 
Posts: 6
Joined: Sun Mar 22, 2015 11:24 pm

Re: Recording odds with BA

Postby pie2251 » Tue Dec 12, 2017 2:39 am

pie2251 wrote:G'day Just Found This Handy Little Excel File Well Done.
Is There A Way To Modify The VBA To Collect
Back3 | Back2 | Back1 | SP | Lay1 |Lay2 |Lay3
Thanks In Advance :D


Little Stuck Now Done Most Of The Work.
I Have Modified Sub IntialINFO2 & RecOddsBeforeStart2
Font Colour "RED" Changes
Not Sure How To Get Back3 | Back2 | Back1 | SP | Lay1 |Lay2 |Lay3
Across For Every Horse, Only Last Horse Shows All.

Sub InitialINFO2()

NoS = Sheets("Status " & MyVar).Range("D12")
If NoS = 0 Then Exit Sub
LRow = Sheets("Data " & MyVar).Range("G65536").End(xlUp).Row
'If LRow = 0 Then LRow = 1

'Sheets("Data " & MyVar).Range("G" & LRow + 1 & ":IV" & LRow + 2).NumberFormat = "@"

For x = 1 To NoS
Sheets("Data " & MyVar).Cells(LRow + 1, x * 4 + 3) = "B3"
Sheets("Data " & MyVar).Cells(LRow + 1, x * 4 + 4) = "B2"
Sheets("Data " & MyVar).Cells(LRow + 1, x * 4 + 5) = "B1"
Sheets("Data " & MyVar).Cells(LRow + 1, x * 4 + 6) = "SP"
Sheets("Data " & MyVar).Cells(LRow + 1, x * 4 + 7) = "L1"
Sheets("Data " & MyVar).Cells(LRow + 1, x * 4 + 8 ) = "L2"
Sheets("Data " & MyVar).Cells(LRow + 1, x * 4 + 9) = "L3"


Sheets("Data " & MyVar).Cells(LRow + 2, x * 4 + 3) = Sheets(MyVar).Range("A" & (x + 4))
Sheets("Data " & MyVar).Cells(LRow + 2, x * 4 + 4) = Sheets(MyVar).Range("A" & (x + 4))
Sheets("Data " & MyVar).Cells(LRow + 2, x * 4 + 5) = Sheets(MyVar).Range("A" & (x + 4))
Sheets("Data " & MyVar).Cells(LRow + 2, x * 4 + 6) = Sheets(MyVar).Range("A" & (x + 4))
Sheets("Data " & MyVar).Cells(LRow + 2, x * 4 + 7) = Sheets(MyVar).Range("A" & (x + 4))
Sheets("Data " & MyVar).Cells(LRow + 2, x * 4 + 8) = Sheets(MyVar).Range("A" & (x + 4))
Sheets("Data " & MyVar).Cells(LRow + 2, x * 4 + 9) = Sheets(MyVar).Range("A" & (x + 4))

Next x

Sheets("Data " & MyVar).Range("C" & LRow + 2) = "Date"
Sheets("Data " & MyVar).Range("D" & LRow + 2) = "Event"
Sheets("Data " & MyVar).Range("E" & LRow + 2) = "Time"
Sheets("Data " & MyVar).Range("F" & LRow + 2) = "Duration"

Sheets("Data " & MyVar).Range("C" & LRow + 3) = Sheets(MyVar).Range("B2")
Sheets("Data " & MyVar).Range("D" & LRow + 3) = Sheets(MyVar).Range("A1")

End Sub


Sub RecOddsBeforeStart2()

If Sheets("Status " & MyVar).Range("D22") = "" And Sheets("Status " & MyVar).Range("D31") = "NOT STARTED" Then
Call InitialINFO
Sheets("Status " & MyVar).Range("D22") = "RECORDING"
End If

' Using D31 (from macro)
If Sheets("Status " & MyVar).Range("D31") = "NOT STARTED" Then

LRow = Sheets("Data " & MyVar).Range("G65536").End(xlUp).Row + 1
' Copy time,duration
Sheets("Data " & MyVar).Range("E" & LRow) = Sheets("Status " & MyVar).Range("D14")
Sheets("Data " & MyVar).Range("F" & LRow) = Sheets("Status " & MyVar).Range("D40")
' Copy selection's data
NoS = Sheets("Status " & MyVar).Range("D12")

Dim array1 As Variant

For x = 1 To NoS
array1 = Array(Sheets(MyVar).Range("B" & x + 4), Sheets(MyVar).Range("D" & x + 4), Sheets(MyVar).Range("F" & x + 4), Sheets(MyVar).Range("Y" & x + 4), Sheets(MyVar).Range("H" & x + 4), Sheets(MyVar).Range("J" & x + 4), Sheets(MyVar).Range("L" & x + 4))
Sheets("Data " & MyVar).Range(Sheets("Data " & MyVar).Cells(LRow, x * 4 + 3), Sheets("Data " & MyVar).Cells(LRow, x * 4 + 9)).Value = array1
Next x

End If

End Sub

My VBA Knowledge Is Pretty Limited (Very Basic)
pie2251
 
Posts: 6
Joined: Sun Mar 22, 2015 11:24 pm

Previous

Return to Help

Who is online

Users browsing this forum: No registered users and 18 guests

Sports betting software from Gruss Software


The strength of Gruss Software is that it’s been designed by one of you, a frustrated sports punter, and then developed by listening to dozens of like-minded enthusiasts.

Gruss is owned and run by brothers Gary and Mark Russell. Gary discovered Betfair in 2004 and soon realised that using bespoke software to place bets was much more efficient than merely placing them through the website.

Gary built his own software and then enhanced its features after trialling it through other Betfair users and reacting to their improvement ideas, something that still happens today.

He started making a small monthly charge so he could work on it full-time and then recruited Mark to help develop the products and Gruss Software was born.

We think it’s the best of its kind and so do a lot of our customers. But you can never stand still in this game and we’ll continue to improve the software if any more great ideas emerge.