Export logarithmic axes to Excel

[Jordan_23]

Hi all

When viewing a game, i.e. Man. City - Chelsea, and looking at the odds for home, draw, and away victory, one can click and obtain the log axis in betfair.com. Is it possible to export this log axis to a excel spreadsheet?

Thanks!

[Euler]

No it isn't, but there is no reason why you can't collate data yourself and plot it however you wish. There are a couple of spreadsheets for Bet Angel that will auto collect data.

[Jordan_23]

Do you have an example such that I can view how it looks? This is indeed needed before I decide on purchasing Betangel.
Regarding simply 'eyeballing' the graph and manually plotting the values won't do it - the errors obtained this way are simply too large!
Thanks

[Euler]

Here is the spreadsheet: -

viewtopic.php?f=31&t=2385

You can get a trial of Bet Angel to have a good play with it.

[Jordan_23]

I have now purchased Betangel 1 month for a total of 15£. However, I cannot connect your spreadsheet to the Betangel. When I press on the 'Excel' button in Betangel only a calculator pops up.
How do I connect the odds to the spreadsheet? And would it automatically update?
In advance - thanks!

[Euler]

http://www.betangel.tv/video/using-bet- ... readsheets

[Jordan_23]

The videos got me one step further to the goal! However, the updates are always committed in the same cell. Is it possible to nummerate it? I.e. as for the case of S&P 500 data:

http://snp500data.blogspot.com/2011/05/ ... excel.html

Hence, the first column should depict time and the second column should simply depict the odds.

[Euler]

Here is the spreadsheet: -

viewtopic.php?f=31&t=2385

You can get a trial of Bet Angel to have a good play with it.

Use the spreadsheet I highlighted earlier in the thread.

[Jordan_23]

[] Tick to record should simply be entered.
[x] - now it works. Thank you very much for your help, I really appreciate it!

[Jordan_23]

One last question. When opening the sheet referred to following is seen:
Sheet 1 := Betangel
Sheet 2 := Data
Is it possible in sheet 3 to obtain the odds depicted with oldest in top (reversed to what the program actually does)? And in addition, only one column representing the 'back odds', of, say each horse.
The illustration would be something like:
Time Odds Horse 1 Odds Horse 2 ... Odds Horse N
1 3,4 2,85 5,45
2 3,45 2,85 5,25
3 3,45 2,90 5,20
: : :
T 3,25 2,50 4,80

[Bet Angel]

You will have to recode the spreadsheet or transpose the data on the spreadsheet into the order you wish.