total matched and average odd in excel

[Sbidivuda]

I need to read, inside the excel sheet connected to a market, the total matched and the average odd for a specific selection.
For example, if the bets for a given selection are 10€ at 3.00 and 15€ at 4.00 and 20€ at 5.00 then the result I need is 45€ of total matched at 4.22.
Where are the cells that hold these information ?
In alternative if such a cells dosn't exist, how can I solve the problem ?

[GaryRussell]

The total matched is already output to column P. If you install the Beta version it has done the calculation for you. See http://www.gruss-software.co.uk/forum/v ... php?t=6193 for download link.

When you link to Excel you have the option of selecting "Average last matched price" under additional columns. Additional columns are output starting column Y.