Combine Win & Place Markets

[6thSense]

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

[RichStone]

Thanks for this, gunna give it a go tomorrow

[neilrickaby]

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?

[gstar1975]

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?

[gstar1975]

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]

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

[Xeres]

I'm a bit late to this party but is there a way to loop through the win/place, say every 5 seconds? so if we take all the win and place markets today, I'd like to loop though them check the prices, do stuff, then move onto the next race and so on....

[Dallas]

I'm a bit late to this party but is there a way to loop through the win/place, say every 5 seconds? so if we take all the win and place markets today, I'd like to loop though them check the prices, do stuff, then move onto the next race and so on....

You can stored values to link markets together, there's some step by step instructions here
viewtopic.php?t=16230

and a few ready-made examples in the shared files section including these ones
viewtopic.php?f=53&t=16239
viewtopic.php?f=52&t=17026

[Xeres]

Perfect thank you

[BeddyBoy]

Thank you for your sheet.

My question is that I am trying to use this in Guardian with multiple racing markets. Once the first markets are completed (Win & Place), the Combined sheet won't automatically move onto sheets 3 & 4, ie the win/place markets for the next race and so on. (because the sheets have different names obviously)

What can I do to have one combined sheet that automatically changes to the markets of the next race(s)?

Many thanks!

[elofan0]

theres this file too

viewtopic.php?t=21821