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.
Betfair Data : Simple Profit & Loss Chart Spreadsheet
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
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.
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.
-
- Posts: 5
- Joined: Thu Feb 18, 2016 7:44 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 daystevielew75 wrote: ↑Mon Jan 01, 2018 11:47 pmDumb question but how to I enter the data? Do I have to input it manually?
https://www.horseracebase.com/index.php
-
- Information
-
Who is online
Users browsing this forum: No registered users and 0 guests