simple tennis data

Post Reply
User avatar
AndyIsHere
Posts: 29
Joined: Thu Feb 11, 2021 8:07 pm

Hey,

I can't seem to find any videos or written info on how to extract data, I see there are some example spreadsheets but nothing new, just really old ones, have things changed?

What I'm wanted to do is load a list of tennis matches into guardian/watch list and for each one I am trying to get it to monitor the match and then at the end extract to a spreadsheet:
  • The market name
  • both players BSP
  • The lowest the player hit in play
  • the highest the player hit in play
  • the total volume traded
I don't need minute by minute price movements just the top and bottom they got to, so hopefully it won't be a massive data set to extract.

Also, is there a way to do this without the market being loaded into the main ladder interface? a lot of matches clash, can it be done in the background from guardian or the watch list, whilst I'm trading other markets?

I cant find any tutorials or anything on how to go about this, does anyone have any advice or have done something similar?

Many Thanks
Andy
User avatar
MemphisFlash
Posts: 1847
Joined: Fri May 16, 2014 10:12 pm
Location: Leicester

the lowest will be 1.01, the highest will be 1000 on every match, one wins one dosn't.
not exactly rocket science
User avatar
ODPaul82
Posts: 471
Joined: Sun May 08, 2011 6:32 am
Location: Digswell Herts

I guess you haven't read the section in the manual about stored values.....
eightbo
Posts: 2125
Joined: Sun May 17, 2015 8:19 pm
Location: Malta/Germany

Hi Andy, yes this would be stored values, and excel intergration :)

Start with the Bet Angel User Guide
You can try the BA youtube channel, too.

I would suggest aiming for a graph which plots the price data of the players over time instead, as this would be more useful to you than IP low/high.

Best of luck with it
User avatar
ShaunWhite
Posts: 7698
Joined: Sat Sep 03, 2016 3:42 am

MemphisFlash wrote:
Sat May 21, 2022 9:06 am
the lowest will be 1.01, the highest will be 1000 on every match, one wins one dosn't.
not exactly rocket science
And the highest price for the winner and the lowest price for the loser was...?
User avatar
AndyIsHere
Posts: 29
Joined: Thu Feb 11, 2021 8:07 pm

MemphisFlash wrote:
Sat May 21, 2022 9:06 am
the lowest will be 1.01, the highest will be 1000 on every match, one wins one dosn't.
not exactly rocket science
really!! u can't be serious
User avatar
AndyIsHere
Posts: 29
Joined: Thu Feb 11, 2021 8:07 pm

ODPaul82 wrote:
Sat May 21, 2022 10:19 am
I guess you haven't read the section in the manual about stored values.....
another sarcastic reply!! funny, the stored value section doesn't mention excel
User avatar
AndyIsHere
Posts: 29
Joined: Thu Feb 11, 2021 8:07 pm

eightbo wrote:
Sat May 21, 2022 2:06 pm
Hi Andy, yes this would be stored values, and excel intergration :)

Start with the Bet Angel User Guide
You can try the BA youtube channel, too.

I would suggest aiming for a graph which plots the price data of the players over time instead, as this would be more useful to you than IP low/high.

Best of luck with it
Thanks for the grown up reply, seems not everyone's a dick
User avatar
ODPaul82
Posts: 471
Joined: Sun May 08, 2011 6:32 am
Location: Digswell Herts

It wasn't meant as sarcastic, it was to point out that it's covered in the manual.

You don't even need the Excel integration part, if you log the stored values & have 'Export report on market closure' ticked in guardian then you can extract the data out from the resulting log files.
User avatar
AndyIsHere
Posts: 29
Joined: Thu Feb 11, 2021 8:07 pm

ODPaul82 wrote:
Sat May 21, 2022 8:02 pm
It wasn't meant as sarcastic, it was to point out that it's covered in the manual.

You don't even need the Excel integration part, if you log the stored values & have 'Export report on market closure' ticked in guardian then you can extract the data out from the resulting log files.
Ok thanks, never used the log file I'll look into it
Post Reply

Return to “Betfair Data”