Trade analysis & record keeping : Excel Trading Analysis

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

Fri Aug 24, 2018 2:40 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: 222
Joined: Thu Nov 06, 2014 12:35 pm
Location: Newmarket Suffolk

Mon Sep 17, 2018 4:08 pm

Can anyone tell me please: Has this spreadsheet been updated so that it will work in Excel 2010? Thanks

spreadbetting
Posts: 2945
Joined: Sun Jan 31, 2010 8:06 pm

Mon Sep 17, 2018 4:40 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: 222
Joined: Thu Nov 06, 2014 12:35 pm
Location: Newmarket Suffolk

Tue Sep 18, 2018 5:29 pm

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: 834
Joined: Thu Jul 18, 2013 12:30 pm

Mon Oct 15, 2018 9:29 am

Very cool Nigel.Thank you. I can merge all sorts of interesting stuff into this.Cheers mate :ugeek:

tomek154
Posts: 11
Joined: Tue Feb 27, 2018 1:11 am

Wed Oct 31, 2018 11:39 pm

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

First post here btw... evening all.

Tom

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

Fri May 24, 2019 10:16 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

Sat Aug 24, 2019 9:27 am

Perfect!

Post Reply

Return to “Trade analysis & record keeping”

  • Information
  • Who is online

    Users browsing this forum: No registered users and 1 guest