Noob Excel Questions

[Jimmyjet1978]

Hi all, hopefully someone can help me out.

What I am trying to do is back horses in various different meetings across the board, in both the win and the place market.

I have managed so far to download the "place_bets" spreadsheet that is provided in the forum, and I have seemingly successfully set this up for the first race, in the win market. Obviously I'll have to wait for the first race to ensure that the triggers are working properly. All good.

However before I start messing around with what I have already done, I need to know if it is possible to set up the triggers for both the win, and the place market, and if I need seperate sheets for this. Also the fact I have selected the first race from the quick picks list, will it now recognise the horses from the other meetings I have inputted into the Excel sheet, or do I have to manually select the next race from the quick picks list?

Any help would be appreciated.

[GaryRussell]

I need to know if it is possible to set up the triggers for both the win, and the place market

You will need to use a separate workbook for the place markets.

1) Take a copy of the place_bets spreadsheet and rename it to something like "place_bets_place_markets"

2) Open this new workbook using File|Open in the win markets workbook.

3) Select "New page" from the application menu to create a new tab page.

4) Select Market|Add to quick pick list|All UK Place (assuming you require UK racing markets)

5) Link this tab page to Excel as you did the win markets. Be sure to select the place markets workbook from the drop down list when setting up the link.

Also the fact I have selected the first race from the quick picks list, will it now recognise the horses from the other meetings I have inputted into the Excel sheet, or do I have to manually select the next race from the quick picks list?

You may not have noticed in the instructions accompanying place_bets that it mentions selecting "Markets|Auto select markets|At specific time before the off" from the application menu. You need to use this option for it to auto select each market.