Getting results from Betfair into a usable form

[brimson25]

I'm a bit embarassed to be asking this.

I've been downloading my P/L and keeping good records. But it takes me ages!

Is there a way I can get ROI, P/L, strike rate etc without faffing around like a bad data entry clerk?

I know I should have sorted this before. Please don't laugh at me too much.

[spreadbetting]

Not sure what you're actually looking for, Betfair have a couple of formats you can download, either th simple profit and loss of each market or if you want a complete list of all bets you can download the betting history files and create your own pnl. I'm sure Nigel has posted a few spreadsheets on the site that'll work out the pnl/strike rates etc from those files

Here's one

download/file.php?id=8922

viewtopic.php?f=60&t=133&hilit=spreadsheet+stats

[brimson25]

Cheers. I'm not really sure what I'm looking for. I'm hopeless with Excel. I had a go a few months ago, but will prevail this time!

[brimson25]

That's great! Almost everything I need.

Except - is there is a way I can derive my ROI without manually entering my turnover?

Thanks very much.

[brimson25]

I've just worked it out, using a post from this forum from 2010. Wish I could delete this thread. Feel like an idiot!