Profit/loss by odds ranges

[tryingtotrade]

Hello,

I feel my strategy might be doing better at higher odds compared to the favorites.
It doesn't seem possible to get that information off the Betfair statement but I would have to export all my bets directly from Betangel?
Would someone be able to achieve this, for example calculate the profit of all back bets placed over the odds of 10 or lay bets between odds 10-20 etc or is there a template for this already?
Thank you

[firlandsfarm]

Export the Betfair Betting History to a spreadsheet and review it in Excel

[tryingtotrade]

Export the Betfair Betting History to a spreadsheet and review it in Excel

Is it easy to do?

[sniffer66]

Logged in as yourself on BF, go here, set your filters for the data you need and hit " Get History". That will then download as a CSV file you can open in Excel, then you can filter\total etc for your required price parameters

https://myaccount.betfair.com/activity/bettinghistory

[firlandsfarm]

Logged in as yourself on BF, go here, set your filters for the data you need and hit " Get History". That will then download as a CSV file you can open in Excel, then you can filter\total etc for your required price parameters

https://myaccount.betfair.com/activity/bettinghistory

Hey sniffer, I didn't know you could access it direct, I always go vis the Bf website!

[sniffer66]

Logged in as yourself on BF, go here, set your filters for the data you need and hit " Get History". That will then download as a CSV file you can open in Excel, then you can filter\total etc for your required price parameters

https://myaccount.betfair.com/activity/bettinghistory

Hey sniffer, I didn't know you could access it direct, I always go vis the Bf website!

Sorry, I should have said, that is a link to the BF website

[firlandsfarm]

Logged in as yourself on BF, go here, set your filters for the data you need and hit " Get History". That will then download as a CSV file you can open in Excel, then you can filter\total etc for your required price parameters

https://myaccount.betfair.com/activity/bettinghistory

Hey sniffer, I didn't know you could access it direct, I always go vis the Bf website!

Sorry, I should have said, that is a link to the BF website

No, I saw that, what i meant was that I didn't realise you could address the page directly by URL ... I've always gone through the 'Activity' links on the general webpages

[sniffer66]

Hey sniffer, I didn't know you could access it direct, I always go vis the Bf website!

Sorry, I should have said, that is a link to the BF website

No, I saw that, what i meant was that I didn't realise you could address the page directly by URL ... I've always gone through the 'Activity' links on the general webpages

Got you. I've no idea if you can but would be great if you could specify the filter parameters in the URL, then you could do an immediate download on the csv from a single click. Cue someone telling m you can

[Anbell]

Sorry, I should have said, that is a link to the BF website

No, I saw that, what i meant was that I didn't realise you could address the page directly by URL ... I've always gone through the 'Activity' links on the general webpages

Got you. I've no idea if you can but would be great if you could specify the filter parameters in the URL, then you could do an immediate download on the csv from a single click. Cue someone telling m you can

It couldnt be easier than doing it directly in excel!

[sniffer66]

No, I saw that, what i meant was that I didn't realise you could address the page directly by URL ... I've always gone through the 'Activity' links on the general webpages

Got you. I've no idea if you can but would be great if you could specify the filter parameters in the URL, then you could do an immediate download on the csv from a single click. Cue someone telling m you can

It couldnt be easier than doing it directly in excel!

When you say "directly in Excel", I do all my filtering in Excel but I mean when you specify the date range, sport etc in the dropdowns on the History page. is it possible to do that directly ?

[firlandsfarm]

No, I saw that, what i meant was that I didn't realise you could address the page directly by URL ... I've always gone through the 'Activity' links on the general webpages

Got you. I've no idea if you can but would be great if you could specify the filter parameters in the URL, then you could do an immediate download on the csv from a single click. Cue someone telling m you can

It couldnt be easier than doing it directly in excel!

I need to explore Excel more, especially PowerQuery

[Anbell]

Got you. I've no idea if you can but would be great if you could specify the filter parameters in the URL, then you could do an immediate download on the csv from a single click. Cue someone telling m you can

It couldnt be easier than doing it directly in excel!

When you say "directly in Excel", I do all my filtering in Excel but I mean when you specify the date range, sport etc in the dropdowns on the History page. is it possible to do that directly ?

I dont think so