Trade analysis & record keeping : Excel Trading Analysis

Post Reply
Rafick385
Posts: 14
Joined: Tue Oct 21, 2014 1:07 pm

Sat May 16, 2015 3:29 am

Hi,

I'm testing a rule and would like to know how to use this together with the Bet Angel P&L spreadsheet. I'm not good at spreadsheets and I have never been able to get something readable from Bet Angel's spreadsheet.

Thanks.

Rafick

Rafick385
Posts: 14
Joined: Tue Oct 21, 2014 1:07 pm

Mon May 25, 2015 2:46 am

Nobody replied but I've been able to sort it out. Thanks.

andyfuller
Posts: 4619
Joined: Wed Mar 25, 2009 12:23 pm

Fri Apr 01, 2016 12:18 pm

Does anyone know if this would work with Betdaq's P&L's?

Also (more importantly) where do you download the latest version - I have read through the whole thread and can't seem to figure it out :?

Or is there a different thread where an analysis spreadsheet is available?

TIA.

User avatar
deanbond07
Posts: 3
Joined: Mon Nov 21, 2016 12:15 pm
Location: Cambridge

Wed Nov 23, 2016 10:32 am

I know this was back in 2009, but I just downloaded and amended the directories in the Macro and it works perfectly - brilliant...thank you :)

User avatar
gstar1975
Posts: 123
Joined: Thu Nov 24, 2011 11:59 am

Mon Apr 02, 2018 1:54 pm

Bet Angel wrote:
Tue May 19, 2009 9:52 pm
Please see attached..
Is there any instructions on how to use this spreadsheet? How do I link it to my Betfair account results?

jaipal2004
Posts: 44
Joined: Sat Aug 05, 2017 11:33 am

Mon Apr 23, 2018 12:13 pm

Hi

how easy would this be to adapt to football markets? Can it be used as it is for somethingother than horse racing?

thanks

nigelk
Posts: 461
Joined: Wed Apr 15, 2009 11:00 pm

Mon Apr 23, 2018 1:54 pm

Wouldn't work for the football as the markets are completely different, overs, unders, etc etc, however, given enough market info it would be possible to create one.

Cheers,Nigel.

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

Mon Apr 23, 2018 4:13 pm

jaipal2004 wrote:
Mon Apr 23, 2018 12:13 pm
Hi

how easy would this be to adapt to football markets? Can it be used as it is for somethingother than horse racing?

thanks


I did a rough and ready tweak of the spreadsheet so it would run for AUS markets, greyhounds , football etc a while back, copy is on this thread

viewtopic.php?f=11&t=14488&p=146639&hil ... et#p146224

jaipal2004
Posts: 44
Joined: Sat Aug 05, 2017 11:33 am

Mon Apr 23, 2018 4:42 pm

thanks both :D

User avatar
gstar1975
Posts: 123
Joined: Thu Nov 24, 2011 11:59 am

Fri Aug 24, 2018 12:39 pm

nigelk wrote:
Mon May 18, 2009 12:16 pm
All,

I've made a spreadsheet that can be used in conjunction with the spreadsheet that can be downloaded from Betfair that lists your trades over a period of time.

It gives the total races you have traded and the overall profit/loss figure

It also lists details of your trades by course/racetype/distance and gives the profit/loss figure against each one.

You can also double click on a track/race type/distance to get further details.

On the sheet attached, you can see that at Bangor, I traded 5 races, double clicking brings up more details (under the blue header), that lists all 5 trades, their distances, race types and profit loss.

You can do the same with the race type and distances.

Ticking one of the boxes at the top will also sort
by profit/loss and number of trades

It will work on Excel 2000/2003

However, you do need to change the pathway to tell it where the Betfair spreadsheet is.

Press alt/f11 scroll down a little bit down you should see:

'***************************************************************

'COPY DATA FROM DOWNLOADED BETFAIR SPREADSHEET

ChDir "C:\Users\nigel\Desktop"
Workbooks.Open Filename:="C:\Users\nigel\Desktop\BettingPandL.xls"

As long as you save the Betfair spreadsheet to the desktop and don't rename it, all you should have to change is the user name.

Once you have done that, just press the "update" button.

Sheets 1 and 4 are hidden, purely for cosmetic purposes. However, deleting/moving columns will have a detrimental effect as I have not included any error checking routines.

It does contain macros, so don't be alarmed about the warning that pops up when you first open it.

Any problems, please get back to me.

Nigel
Which spreadsheet from betfair do you mean? Betting History/Betting Profit Loss/ or a different one. Also would you be able to make a spreadsheet that works in Open Office please :)

Post Reply

Return to “Trade analysis & record keeping”

  • Information
  • Who is online

    Users browsing this forum: No registered users and 0 guests