Combine Win & Place Markets

Example spreadsheets and comments on example spreadsheets.
Post Reply
6thSense
Bet Angel
Bet Angel
Posts: 375
Joined: Fri Nov 30, 2012 5:02 pm

Another common spreadsheet request is to combine both the win and place horse racing markets on the same sheet.

This spreadsheet will do just that. You can use this as a template to develop something more useful. At the moment this will just display the prices. It won't place bets or make any decisions.

Firstly, add a win and a place market to Guardian. Make sure these are the only markets in Guardian.

Select to auto bind the Bet Angel Sheets.

Open the workbook in the Guardian Excel section and connect.

You will see a sheet called 'Combined'.

This sheet will also highlight where most of the volume has been placed in each market. Which may be useful.

If you find this sheet useful please let me know.

Required: Excel 2010
You do not have the required permissions to view the files attached to this post.
User avatar
RichStone
Posts: 26
Joined: Sun Oct 28, 2012 1:31 pm
Location: Gibraltar

Thanks for this, gunna give it a go tomorrow :)
neilrickaby
Posts: 1
Joined: Thu Feb 21, 2013 9:51 pm

this is a fantastic sheet, many thanks. Sometimes the values get 'stuck' when switching from market to market. Is there any way to 'flush' them and clear the sheet?
User avatar
gstar1975
Posts: 615
Joined: Thu Nov 24, 2011 11:59 am

neilrickaby wrote:
Fri May 16, 2014 1:22 pm
this is a fantastic sheet, many thanks. Sometimes the values get 'stuck' when switching from market to market. Is there any way to 'flush' them and clear the sheet?
Also The place prices are from the next race, not the current race. Bit Buggy, can anyone update this please?
User avatar
gstar1975
Posts: 615
Joined: Thu Nov 24, 2011 11:59 am

6thSense wrote:
Mon Jan 07, 2013 4:30 pm
Another common spreadsheet request is to combine both the win and place horse racing markets on the same sheet.

This spreadsheet will do just that. You can use this as a template to develop something more useful. At the moment this will just display the prices. It won't place bets or make any decisions.

Firstly, add a win and a place market to Guardian. Make sure these are the only markets in Guardian.

Select to auto bind the Bet Angel Sheets.

Open the workbook in the Guardian Excel section and connect.

You will see a sheet called 'Combined'.

This sheet will also highlight where most of the volume has been placed in each market. Which may be useful.

If you find this sheet useful please let me know.

Required: Excel 2010
The Placed market is the win market from the next race for example in the win market is the win prices for the 3pm and the place sheet has the win prices for the 315pm, how can I get this to work properly?
asahenettleton
Posts: 15
Joined: Sat Apr 04, 2020 6:30 pm

This is something that I was looking for or hoping to reinvent if necessary, thank you! I look forward to trying it.
Post Reply

Return to “Bet Angel - Example spreadsheets”