Betfair Data : Simple Profit & Loss Chart Spreadsheet

[nigelk]

Using excel 2007 here.

Click on the pivot table so that the pivot table tools are visible on the ribbon tab,select 'options' and 'change data source'

A dialogue box will open and you can set a new data source range.

[Kaz2]

Hi,

If using ''automation'' all day, how do I enter my results into this spreadsheet please?

Sorry for what will probably be a stupid question but I am not very technically minded .

Thanks
Kaz

[Dallas]

Hi,

If using ''automation'' all day, how do I enter my results into this spreadsheet please?

Sorry for what will probably be a stupid question but I am not very technically minded .

Thanks
Kaz

You would just enter them manually on the 'My Results' tab (first delete out the samples ones that are their already) then just refresh as per the instructions on the OP to update all the charts etc

[cybernet69]

Be good if this somehow could be included as part of guardian.

[Kaz2]

Thanks Dallas, as always.

Kaz

[nigelk]

I'm currently working on a project to create a spreadsheet similar to the one created by Dallas & shown above, but I need some volunteers.

This will all be automation based, so you must be using Excel to place your trades.

Ideally:

1. Someone who uses Guardian & Excel to cycle through & place bets during the day.-NOT training mode
2. Someone who uses excel alone and auto trades each race as it comes-NOT training mode
3. Someone who uses the Betfair training mode.
4. Someone who uses Betadaq, but to micro stakes (10p/50p/£1) etc.

There will be a lot of sending/receiving spreadsheets so if you consider your P&L figures to be private then this isn't for you.
If interested please pm me.

Cheers,NIgel.

[stevielew75]

Dumb question but how to I enter the data? Do I have to input it manually?

[Dallas]

Dumb question but how to I enter the data? Do I have to input it manually?

Yes thats correct the columns are set up so that you can just download the days races from the following site then copy and pasted it straight across which will give you all the course, racy types distances etc - that just leaves the P/L to be manually entered for them at the end of each day
https://www.horseracebase.com/index.php

[Makai]

Hi Dallas, just looking at the Horse Race Base website, I can't see an easy way to extract just the required information for your spreadsheet. Is there a setting on there I'm missing?

[Dallas]

Hi Dallas, just looking at the Horse Race Base website, I can't see an easy way to extract just the required information for your spreadsheet. Is there a setting on there I'm missing?

Without looking and if i remember rightly you just needed to cut and paste the columns needed for the spreadsheet from the main export sheet on HRB