Excel Trading Analysis

Post Reply
spreadbetting
Posts: 3140
Joined: Sun Jan 31, 2010 8:06 pm

He's talking about the Betting profit and loss sheet that gives the market pnl not the betting history that show all individual bets. BettingPandL.xls from https://myaccount.betfair.com/activity/profitandloss

He'd have to re-write the sheet completely for it to be used in open office as the VBA wouldn't work so probably ot really a viable option for the work invovled for something one or two people would use.
User avatar
Black Ice
Posts: 258
Joined: Thu Nov 06, 2014 12:35 pm
Location: Newmarket Suffolk

Can anyone tell me please: Has this spreadsheet been updated so that it will work in Excel 2010? Thanks
spreadbetting
Posts: 3140
Joined: Sun Jan 31, 2010 8:06 pm

I was using the tweaked version here download/file.php?id=8922 in excel 2010 and had no problems
User avatar
Black Ice
Posts: 258
Joined: Thu Nov 06, 2014 12:35 pm
Location: Newmarket Suffolk

Very many thanks spreadbetting...it seems to have downloaded ok..I just have to learn now how to attach it to BF P&L,,,expect i can learn from the BA Guide? Thanks again! :)
User avatar
mcgoo
Posts: 898
Joined: Thu Jul 18, 2013 12:30 pm

Very cool Nigel.Thank you. I can merge all sorts of interesting stuff into this.Cheers mate :ugeek:
tomek154
Posts: 28
Joined: Tue Feb 27, 2018 1:11 am

Has anyone found any way of getting this functioning on openoffice ?

First post here btw... evening all.

Tom
bigtimesmallshot
Posts: 20
Joined: Fri May 24, 2019 9:41 pm

Downloaded this sheet tonight and 5 minutes later I had what I needed - so simple and so effective - thank you and very well done !!!
thecodfather
Posts: 3
Joined: Mon Jun 10, 2019 7:57 pm

Perfect!
User avatar
gazuty
Posts: 2547
Joined: Sun Jun 26, 2011 11:03 am
Location: Green land :)

spreadbetting wrote:
Mon Sep 17, 2018 4:40 pm
I was using the tweaked version here https://www.betangel.com/forum/download ... hp?id=8922 in excel 2010 and had no problems
Hi Spreadbetting

Do you still have that tweaked spreadsheet available?
spreadbetting
Posts: 3140
Joined: Sun Jan 31, 2010 8:06 pm

Recently switched PC so I'll check my old one when I get time later
spreadbetting
Posts: 3140
Joined: Sun Jan 31, 2010 8:06 pm

Sadly I'd deleted all the old excel sheets I never use when I switched PC's . I've one copy of the sheet but unfortunately it's the one I hadn't amended :(

I'll see if I can get it working after racing has finished.

Edit: tweaked the file I had and PM'd you a link to it as the forum doesn't allow macro enabled xlsm files. It was made with excel 2019 so hopefully compatible with your version.
User avatar
gazuty
Posts: 2547
Joined: Sun Jun 26, 2011 11:03 am
Location: Green land :)

spreadbetting wrote:
Wed Dec 30, 2020 2:11 pm
Sadly I'd deleted all the old excel sheets I never use when I switched PC's . I've one copy of the sheet but unfortunately it's the one I hadn't amended :(

I'll see if I can get it working after racing has finished.

Edit: tweaked the file I had and PM'd you a link to it as the forum doesn't allow macro enabled xlsm files. It was made with excel 2019 so hopefully compatible with your version.
Thank you, all received, much appreciated.
User avatar
billbo001
Posts: 105
Joined: Mon Aug 01, 2016 3:45 pm
Location: Deal

Hi Spread betting
Any chance you could send me a copy. I've been looking all week, I can only find old P&L that don't work now :roll:
Thankyou in advance
TRAVI5Ty
Posts: 1
Joined: Sat Jan 30, 2021 3:50 am

hi does anyone have the tweaked version i am having a hell of a time getting it to load the betfair spreadsheet
User avatar
gstar1975
Posts: 615
Joined: Thu Nov 24, 2011 11:59 am

gazuty wrote:
Wed Dec 30, 2020 8:35 pm
spreadbetting wrote:
Wed Dec 30, 2020 2:11 pm
Sadly I'd deleted all the old excel sheets I never use when I switched PC's . I've one copy of the sheet but unfortunately it's the one I hadn't amended :(

I'll see if I can get it working after racing has finished.

Edit: tweaked the file I had and PM'd you a link to it as the forum doesn't allow macro enabled xlsm files. It was made with excel 2019 so hopefully compatible with your version.
Thank you, all received, much appreciated.
Can you post the updated spreadsheet please?
Post Reply

Return to “Trade analysis & record keeping”