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.
Excel Trading Analysis
-
- 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
-
- 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 !!!
Hi Spreadbettingspreadbetting wrote: ↑Mon Sep 17, 2018 4:40 pmI was using the tweaked version here https://www.betangel.com/forum/download ... hp?id=8922 in excel 2010 and had no problems
Do you still have that tweaked spreadsheet available?
-
- 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
-
- 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.
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.spreadbetting wrote: ↑Wed Dec 30, 2020 2:11 pmSadly 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.
Can you post the updated spreadsheet please?gazuty wrote: ↑Wed Dec 30, 2020 8:35 pmThank you, all received, much appreciated.spreadbetting wrote: ↑Wed Dec 30, 2020 2:11 pmSadly 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.