Getting traded values off a chart...

[JayBee]

On each runner's chart the table on the right contains the amount traded for each odds.

It would be good to get these values off the chart (plus the associated odds) and into Excel.

Any ideas?

[GaryRussell]

It's only possible if you use the COM interface. See http://gruss-software.co.uk/forum/viewtopic.php?t=3726 for an example.

[JayBee]

Just what I needed. Thank you.

[JayBee]

I just realised this is not what I require.

I don't want the total matched for a race, I want the amount matched for each odds and for each horse. ie Nag A, £120 matched at 3.0, £89 matched at 3.1, £223 matched at 3.2 and so on.

[Captain Sensible]

getAllTradedVolume gives you that information

[JayBee]

Okay, so I get a big string to parse. Thanks.

[Captain Sensible]

Unfortunately thats the way the data's output, can't imagine there's anyeasy way for it to be sent to the screen due to the number of price increments and numbers of runners etc. Guess you'd have to let vba do all the hard work before getting the exact info you need rather than excel functions

[alrodopial]

Or you can call the individual pages of the horses you want in excel using links like the below with the info you want

http://uk.site.sports.betfair.com/betti ... rrency=EUR

You need the race id which is available from BA and the horses' id which I think Garry will provide for every horse in a feature release (I think).
These web queries are not so quickly like updating the odds but if you only want few data (horses) and not so often they maybe good for you.

Or only the:

http://uk.site.sports.betfair.com/betti ... Id=4244566

[JayBee]

I tried the COM interface and get...

Run-time error '-2147024894 (80070002)':

File or assembly name BettingAssistantCom, or one of its dependencies, was not found

Any ideas?

[GaryRussell]

Did you follow these instructions from the user guide?

Locate the program Excel.exe where your Microsoft Office program files are installed.

A file named Excel.exe.config needs to be created in the same folder if it does not already exist.

Edit the file with Notepad and insert the following lines.
<configuration>
<startup>
<supportedRuntime version="v2.0.50727"/>
<supportedRuntime version="v1.1.4322"/>
</startup>
</configuration>

[JayBee]

100%.

Removed v65 and replaced with v66

Put config file next to Excel.exe

Turned the COM interface on in preferences.

Started the XLS file. Started macros when prompted.

Found a race in BA and then started logging to Excel.

[GaryRussell]

If you view the Excel code editor and select "References" from the tools menu does it have "BettingAssistantCom" ticked? It may also show this with "missing" next to it which would be a problem.

[JayBee]

BettingAssistantCom is ticked.

I am running Excel 2000 (9.0.3821 SR-1) if that is of any help.

I can't afford to update. I normally run Linux but am using BA on a Vista machine with whatever is on it.

[GaryRussell]

Are you sure you named Excel.exe.config properly? I had a user with the same problem and they had file extensions hidden in Windows Explorer and after unhiding file extensions we could see that the file was actually named Excel.exe.exe.config which was incorrect.

[JayBee]

Same name, no go.