Average Price Matched

Discussion regarding the spreadsheet functionality of Bet Angel.
Post Reply
jonne14
Posts: 2
Joined: Wed Jan 21, 2015 12:56 pm

Hi guys!

Maybe a stupid question but is it possible to get the Average Matched Price of a horse or result in a Spreadsheet?

For example:
£100 matched at 1.20
£500 matched at 1.25
£1000 matched at 1.30

I´m looking for to get this average 1,278 live updated. Is it possible?

Thanks in advance!

Best Regards
Wyndon
Posts: 237
Joined: Sun Nov 13, 2011 10:14 am

You get this in column Z of the BetAngel spreadsheet.
jonne14
Posts: 2
Joined: Wed Jan 21, 2015 12:56 pm

Hi,

Thanks for the answer.

I´m not sure if that is the right thing, I´m not looking for only my bets, I´m looking for totally matched bets.

Thanks.
burdo77
Posts: 351
Joined: Sun Jun 09, 2013 4:13 am

100*1.2 +500*1.25+1000*1.3= 2045/ money invested which is 1600

2045/1600 = 1.278

Hope that helps
LinusP
Posts: 1918
Joined: Mon Jul 02, 2012 10:45 pm

Do you want the weighted average price for your orders or everyones orders?
Post Reply

Return to “Bet Angel - Spreadsheet / Excel chat”