Spreadsheet help

Discuss anything related to using the program (eg. triggered betting tactics)

Moderator: 2020vision

Spreadsheet help

Postby SAUSDOG » Thu Sep 28, 2006 9:57 pm

Hello hope someone can help im looking for a spreadsheet that will log prices of horses in running is this possible.if so can someone help me out.Many thanks.
SAUSDOG
 
Posts: 7
Joined: Sat Mar 18, 2006 9:59 pm
Location: saffron walden

Postby Mitch » Thu Sep 28, 2006 11:03 pm

Can you explain a little more about exactly what you want?

Betting Assistant will log an individual horses information.
User avatar
Mitch
 
Posts: 365
Joined: Sat Nov 19, 2005 12:28 am
Location: Leicester

Postby SAUSDOG » Thu Sep 28, 2006 11:04 pm

hello mate i would like it to run during a race and record the prices
SAUSDOG
 
Posts: 7
Joined: Sat Mar 18, 2006 9:59 pm
Location: saffron walden

Logging in running

Postby JohnMeyer9999 » Fri Sep 29, 2006 2:51 pm

As far as I am aware If you use the log individual price it will logg all the way throught from the tiem you start it till the end of the race including any in-running, then just use some form of filtering to see what the prices were after the race started sio you only have in running prices

i think this right, corrcet me if im wrong anyone
JohnMeyer9999
 
Posts: 6
Joined: Wed Sep 27, 2006 1:06 pm

Postby Mitch » Sat Sep 30, 2006 3:58 pm

Sounds good to me.
User avatar
Mitch
 
Posts: 365
Joined: Sat Nov 19, 2005 12:28 am
Location: Leicester

Postby SAUSDOG » Sat Sep 30, 2006 5:35 pm

Thanks for that mate ive got no idea about spreadsheets would what your saying be fairly easy to do i may be able to get someone at work to help me otherwise im buggered
SAUSDOG
 
Posts: 7
Joined: Sat Mar 18, 2006 9:59 pm
Location: saffron walden

Postby Mitch » Sat Sep 30, 2006 10:28 pm

You don't have to do anything with Excel apart from open it.

From Betting Assistant choose Excel, then log individual price and choose the sheet to put it in when you want to record an individual runners price.
User avatar
Mitch
 
Posts: 365
Joined: Sat Nov 19, 2005 12:28 am
Location: Leicester

Postby SAUSDOG » Sat Sep 30, 2006 10:59 pm

ok cheers mitch i want to record all the runners can it do that
SAUSDOG
 
Posts: 7
Joined: Sat Mar 18, 2006 9:59 pm
Location: saffron walden

Postby GeorgeUK » Sat Sep 30, 2006 11:36 pm

I'll have a bash at this.

Open Excel
Rename "Sheet2" to DATA CAPTURE
press ALT + F11
(this will open the VB Editor)
press ALT + I
then ALT + M
(this will open the insert menu and select "module")
paste the folowing code
Code: Select all
Sub odds()
If ActiveSheet.Name <> "Sheet1" Then GoTo 1
Application.OnTime Now() + TimeValue("00:00:01"), "odds"
lastrow = Sheets("DATA CAPTURE").Range("A65536").End(xlUp).Row + 1
ActiveWorkbook.ActiveSheet.UsedRange.Copy Destination:=Sheets("DATA CAPTURE").Range("A" & lastrow)
1
End Sub


This will record the data from sheet1 to the Data Capture sheet. To stop the recording, select a sheet other than sheet1

With Excel open, open the betting Assistant and select "excel" from the menu
select log current prices
select a race that you want to record

when the data appears in excel
press ALT+ F8
select the "odds" macro and run it.

that should do it.
previously known as Gaseous (on the betfair forum)
User avatar
GeorgeUK
 
Posts: 315
Joined: Sat Nov 19, 2005 10:18 pm
Location: Scotland

Postby SAUSDOG » Sun Oct 01, 2006 1:50 pm

Great stuff mate i will give it a go many thanks
SAUSDOG
 
Posts: 7
Joined: Sat Mar 18, 2006 9:59 pm
Location: saffron walden


Return to Discussion

Who is online

Users browsing this forum: No registered users and 22 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.