Betfair Data : Simple Profit & Loss Chart Spreadsheet

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

Fri Aug 05, 2016 8:31 pm

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.

User avatar
Kaz2
Posts: 40
Joined: Fri Feb 24, 2017 11:33 am

Sun May 28, 2017 1:38 pm

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 :oops: .

Thanks
Kaz

User avatar
Dallas
Posts: 8140
Joined: Sun Aug 09, 2015 10:57 pm

Sun May 28, 2017 2:11 pm

Kaz2 wrote:
Sun May 28, 2017 1:38 pm
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 :oops: .

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

Sun May 28, 2017 2:44 pm

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

User avatar
Kaz2
Posts: 40
Joined: Fri Feb 24, 2017 11:33 am

Sun May 28, 2017 3:32 pm

Thanks Dallas, as always.

Kaz

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

Sun Jun 25, 2017 4:32 pm

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
Posts: 5
Joined: Thu Feb 18, 2016 7:44 pm

Mon Jan 01, 2018 11:47 pm

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

User avatar
Dallas
Posts: 8140
Joined: Sun Aug 09, 2015 10:57 pm

Tue Jan 02, 2018 2:59 pm

stevielew75 wrote:
Mon Jan 01, 2018 11:47 pm
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

Post Reply

Return to “Betfair Data”

  • Information
  • Who is online

    Users browsing this forum: No registered users and 1 guest