Simple Profit & Loss Chart Spreadsheet

nigelk
Posts: 469
Joined: Wed Apr 15, 2009 11:00 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

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: 22671
Joined: Sun Aug 09, 2015 10:57 pm
Location: Working From Home

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

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

Thanks Dallas, as always.

Kaz
nigelk
Posts: 469
Joined: Wed Apr 15, 2009 11:00 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: 7
Joined: Thu Feb 18, 2016 7:44 pm

Dumb question but how to I enter the data? Do I have to input it manually?
User avatar
Dallas
Posts: 22671
Joined: Sun Aug 09, 2015 10:57 pm
Location: Working From Home

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
Makai
Posts: 1
Joined: Thu Jan 17, 2019 8:08 pm

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?
User avatar
Dallas
Posts: 22671
Joined: Sun Aug 09, 2015 10:57 pm
Location: Working From Home

Makai wrote:
Fri Jan 18, 2019 11:12 am
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
rik
Posts: 1583
Joined: Sat Jan 25, 2014 5:16 am
Location: London

Thanks for the spreadsheet. there is no way to load the Betfair profit file into it, would have to enter every market manually??
User avatar
nikolong
Posts: 18
Joined: Thu Nov 30, 2017 8:27 pm

I have recently got into automation and this has blown my mind. I have a betting strategy that I want to evaluate and this will be awesome. Thank you Dallas you truly are great.
Niko
User avatar
nikolong
Posts: 18
Joined: Thu Nov 30, 2017 8:27 pm

Would it be possible to add your own row headings, i don't know how to do pivot tables. I would like 'days of the week' and 'trainers' to have their own rows too. This is because you know how different Saturdays are to Mondays say, and there is different behaviors associated with different trainers.
Thanks,

Niko
User avatar
Dallas
Posts: 22671
Joined: Sun Aug 09, 2015 10:57 pm
Location: Working From Home

nikolong wrote:
Thu Aug 01, 2019 8:34 am
Would it be possible to add your own row headings, i don't know how to do pivot tables. I would like 'days of the week' and 'trainers' to have their own rows too. This is because you know how different Saturdays are to Mondays say, and there is different behaviors associated with different trainers.
Thanks,

Niko
Yes you can modify it any way you want, it doesn't use and macro's so there's no danger of messing anything up in the background
Post Reply

Return to “Betfair Data”