Importing ODDS to Spreadsheet

Find a developer for your Excel triggered betting needs and advertise your development service here.

Moderator: 2020vision

Importing ODDS to Spreadsheet

Postby 00dyel » Sun Oct 23, 2011 1:23 pm

Dear All,

I am looking for a developer who can make the odds of the races import to cells allocated by myself which will change as close to real time as possible.

I would then like the BFSP to be imported to a separate cell for each of the horses.

If you feel you can help, please contact me.

Liam
00dyel
 
Posts: 8
Joined: Sat Apr 24, 2010 9:31 am

Re: Importing ODDS to Spreadsheet

Postby Captain Sensible » Sun Oct 23, 2011 5:54 pm

00dyel wrote:Dear All,

I am looking for a developer who can make the odds of the races import to cells allocated by myself which will change as close to real time as possible.

I would then like the BFSP to be imported to a separate cell for each of the horses.

If you feel you can help, please contact me.

Liam


Probably need to be a bit more specific as BA can already do those things for you almost by default.

You can specify your starting cell by changing the top left hand cell from A1 to something else and import the BFSP to the sheet just ticking it in the additional cells. For as close to real time just amend the refresh rate to the max 5 per second when needed
User avatar
Captain Sensible
 
Posts: 2883
Joined: Sat Nov 19, 2005 2:29 pm

Postby 00dyel » Sun Oct 23, 2011 6:47 pm

Thanks for the reply.

I would like the prices to be imported in a page i have all created where the names of the horses will already be.

I have each race set up one on one page so i can view each race and would like it so if i move on to the next race in gruss the odds of the previous race are kept on my spreadsheet. I then want the next race odds to go into the relevant cells in line with the correct horse.

Hope this makes more sense
00dyel
 
Posts: 8
Joined: Sat Apr 24, 2010 9:31 am

Postby Ian » Sun Oct 23, 2011 7:18 pm

Why not put all the races into one sheet and link to a BA tab which has all the races from the pick list in it ? No need to move from race to race ... just scroll up and down the sheet.
Ian
 
Posts: 834
Joined: Sat Nov 19, 2005 8:35 am
Location: Birmingham

Postby neeeel » Wed Nov 02, 2011 3:23 pm

Hi, I can do this for you, contact me on neeeel@hotmail.com and we can discuss it further
thanks
neeeel
 
Posts: 111
Joined: Sun Jun 27, 2010 1:14 pm

Postby 00dyel » Thu Nov 03, 2011 10:52 pm

this is something i am looking for:


I currently have created a spreadsheet which is set up something similar to below. The --- between horse name and betfair odds represents data.

----------------------------------------------------------------------------------------------------------------------------
TITLE OF RACE
Horse 1 Name ----------------------------------------------------Betfair Odds
Horse 2 Name ----------------------------------------------------Betfair Odds
Horse 3 Name ----------------------------------------------------Betfair Odds
Horse 4 Name -----------------------------------------------------Betfair Odds

TITLE OF RACE
Horse 1 Name ----------------------------------------------------Betfair Odds
Horse 2 Name ----------------------------------------------------Betfair Odds
Horse 3 Name ----------------------------------------------------Betfair Odds
Horse 4 Name -----------------------------------------------------Betfair Odds

TITLE OF RACE
Horse 1 Name ----------------------------------------------------Betfair Odds
Horse 2 Name ----------------------------------------------------Betfair Odds
Horse 3 Name ----------------------------------------------------Betfair Odds
Horse 4 Name -----------------------------------------------------Betfair Odds

TITLE OF RACE
Horse 1 Name ----------------------------------------------------Betfair Odds
Horse 2 Name ----------------------------------------------------Betfair Odds
Horse 3 Name ----------------------------------------------------Betfair Odds
Horse 4 Name -----------------------------------------------------Betfair Odds

TITLE OF RACE
Horse 1 Name ----------------------------------------------------Betfair Odds
Horse 2 Name ----------------------------------------------------Betfair Odds
Horse 3 Name ----------------------------------------------------Betfair Odds
Horse 4 Name -----------------------------------------------------Betfair Odds

TITLE OF RACE
Horse 1 Name ----------------------------------------------------Betfair Odds
Horse 2 Name ----------------------------------------------------Betfair Odds
Horse 3 Name ----------------------------------------------------Betfair Odds
Horse 4 Name -----------------------------------------------------Betfair Odds

Hope this makes sense.
00dyel
 
Posts: 8
Joined: Sat Apr 24, 2010 9:31 am

Postby Ian » Fri Nov 04, 2011 6:28 pm

Just put all the races into one tab in BA and link to a sheet in your workbook. Then use Vlookup from your main sheet to the other one.
Ian
 
Posts: 834
Joined: Sat Nov 19, 2005 8:35 am
Location: Birmingham

Postby Golg Addict » Sun Nov 06, 2011 5:30 pm

I log the prices into excel from betting assistant then link cells from the work sheet i want to populate.

Open excel then go to the excel tab in betting assistant and log current prices linking to a blank sheet.

In your work sheet highlight the cell where you want information and press = then switch sheets and highlight the cell with the price you want, press enter and the two will be linked.
Hope this helps I'm new to this myself
Golg Addict
 
Posts: 1
Joined: Sun Nov 06, 2011 5:11 pm
Location: Manchester UK


Return to Find an Excel developer

Who is online

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