Cymatic Trader Community

[nig299]

If you like to keep track and anaylse your trades, you might find the attached useful.

To use it, download the Betfair P&L spreadsheet (NOT the betting history) and save to your computer,

Press the update button and load your saved file You should see something similar to this:

Selecting a Track,RaceType or Distance bring up the details on the right hand side. At Salisbury I've traded 12 markets, and the details on the right show the breakdown of each one. You can see I've done 485 trades and made a handsome profit of 50p. I plan to retire sometime in the next 800 years.

[Gavin]

Hi Nigel,

It looks like another very nice spreadsheet

The attached spreadsheet that you've uploaded just seems to have a single worksheet called sheet0, containing raw data downloaded from Betfair with no macros, it's not the same smart one shown in the picture.

Kind regards,

Gavin

[xplayer]

Hi Nigel,

I do like to keep track and am wondering if you uploaded the wrong sheet

It looks lovely by the way.

Ray

[nig299]

Sorry, that was the raw data from Befair. Here's the proper sheet

[gmoney999]

How do you load the betfair file?

and where do I place the download Betfair file?

[Gavin]

How do you load the betfair file?

and where do I place the download Betfair file?

Go to your Betfair account using the Betfair website, then download the file mentioned in this topic. You can save it anywhere on your PC.

Then when you open the sample spreadsheet 'Copy of Trading Record2-1.xls), go to Sheet 3 where you will find a button labelled 'Update'. When you click it, a file open dialogue box appear that enables you to browse to the file that you downloaded from your Betfair account.

Kind regards,

Gavin

[Chiyo]

Hi im in my betfair account P&L button I cant find how to save the files its a breakdown of ever race and no save file button

[Gavin]

Hi im in my betfair account P&L button I cant find how to save the files its a breakdown of ever race and no save file button

In the top right corner of the Betfair P&L web page, there should be a blue text link called 'Download to spreadsheet'.

Kind regards,

Gavin