football-tips


Contents
Home
Bookshop
Football
Newsletter
Issue 6
Issue 2
Issue 3
Issue 5
Issue 1
Issue 15
Issue 17
Issue 12
Issue 19
Issue 8
Issue 10
Issue 9
Issue 7
Best of the Web: Betting Advice
Form Reading for Dummies
Odds Or Evens?
EPL 2005-6: A broadside
Paradise Questionnaire - Jamdog
Recording Betfair Prices for Dummies
Richard Hills is God interview
Singles or doubles?
A Horse to Follow – Strangely Brown
Issue 4
Issue 11
Issue 16
Issue 18
Issue 13
Issue 14
Horse Racing
Other Sports
Tools
Poker
Betting Theory

Recent Forum Posts
Anyone know of this free horse racing comp Fantasy Punter?
- I wanna know peoples views on ...

Place Betting
- Afternoon After looking at t...

I wish the tote would change their placepot rules
- I had a nice longshot run goin...

Royal Ascot Super Yankee!
- I`ve been inspired to delve in...

Queen Ann
- Looks to be a two horse race t...

Warringah
- This looks a handiacap blot to...

If anybody's interested...
- Hey guys, yes this is my first...


 

online-betting Recording Betfair Prices for Dummies

Power-crazed administrator and founder of Paradise v1.00 OddsAgainst breaks advanced Excel interactivity down to a level even a monkey could understand.

Here at Punters’ Paradise, we recognise that not everyone is an expert gambler or has years of experience with computers. The explosion in online gambling, fuelled by tax regime changes, cheap computers and the birth of betting exchanges has attracted punters of all ages and experience. It is those gamblers who perhaps have limited experience with computers that we aim this article at.

"Gary is to be applauded...for the quality of his work which puts many similar but expensive commercial offerings to shame"

To record Betfair prices we need two tools, Microsoft Excel and the Betfair Trader from Gary Russell. The latter is a free tool and can be downloaded from: http://www.gruss.pwp.blueyonder.co.uk/.

Gary is to be applauded for both his generosity in making the tool available free of charge and for the quality of his work which puts many similar but expensive commercial offerings to shame.

In addition to allow us to record prices in real time, Gary’s software also offers the following features:

  • One click betting on all 3 back and lay prices
  • Continually updated display of potential profit
  • Option to take profit (or minimise loss) with one click (stake will be auto calculated)
  • Dutching stakes automatically calculated (just enter profit required)
  • Real time update of prices in Excel spreadsheet
  • Triggered betting from Excel (future release)

If you have not installed the Betfair Trader before please read the instructions on the site. Ok, so now you have the Betfair Trader installed and running alongside Excel and are ready to start.

Let’s say we want to record prices and volumes for a football match, Rangers v Celtic. First we will prepare the spreadsheet that we intend to store the recorded data in.

Open a new spreadsheet and save it as, e.g. Rangers-Celtic-Prices.xls. Now rename each tab (right-click over the default name Sheet 1,2 ,3-) to -Rangers-, -Celtic- and -Draw-. Note t
hat Excel needs to be running with an open workbook before the Betting Assistant can connect to it.

Now select your required market in the Betting Assistant and set an appropriate refresh rate. Excel will allow just over 65,000 samples to be recorded so the refresh rate chosen should ensure that this limit will not be exceeded before the event starts. Refreshing ever second will consume 60 rows per minute and will give about 18 hours of recording time.

"The selection box allows you to select the runner and should be displaying the first entry in the market. "

From the Betting Assistant menu select Excel and then - Log Individual Price- A window will open with three drop-down lists. The selection box allows you to select the runner and should be displaying the first entry in the market. In this example that would be Rangers. The Workbook name box should be displaying the name of the workbook you prepared.

If not, open the list and select that workbook. This will only be necessary if you have more than one workbook open. Finally select the correct sheet from the worksheet name box. Again this should already display Rangers (if that is the first sheet in your prepared workbook. Click Ok.

The window is dismissed and it would appear that nothing has happened but if you go to your workbook you will see the market data appear. If you have set a longer refresh rate, e.g. one minute then it will be approximately one minute before the first row of data appears.

And there we have it. Simply repeat for the other selections in the market as required.

With the application of a bit of formatting, your sheet could look like this.

football-betting Got a question or comment about Recording Betfair Prices for Dummies? Why not post it in our forum?

Latest Web News
BBC
Advocaat eyeing £20m for Arshavin
- Zenit St Petersburg coach Dick...

Yobo brother kidnapped in Nigeria
- Gunmen in Nigeria kidnap the b...

US firm confirms link to Magpies
- American investor InterMedia P...

Lazio secure Zarate in loan deal
- Former Birmingham striker Maur...

Poland plans contingency for 2012
- Poland say they can provide si...

Geovanni wraps up switch to Hull
- Premier League new boys Hull C...

Kewell completes Galatasaray move
- Australian winger Harry Kewell...

Round named new Everton assistant
- Everton confirm Steve Round as...

Aragones named Fenerbahce coach
- Spain's Euro 2008-winning coac...

Euro winner Torres hails Benitez
- Spain striker Fernando Torres ...


Links Relevant to this Topic

The Theory of Optimal Betting Spreads
The theory of optimal betting spreads for the game of Blackjack has a sound mathematical basis

Theory of Gambling
Gambling book reviews

The Layman's Guide to Probability
An in-depth but easily readable guide on probability theory

Betting Traders
Education for the betting revolution

Betfair scripts
Gary Russell's scripts site

 

© Punters Paradise. Material may not be used without express permission.