Hiya All
I am looking for a template spreadsheet that can combine the win and place markets onto one sheet so I can appy some formulas/calculations for each of the markets to make a selection and place bets. Was wondering if anyone had a basic template that they are willing to share. I know there is one in the example spreadsheet section but this does not seem to work or allow me to add my own calculations anyway it was done many years ago so maybe with the updates it doesnt work now. Many Thanks
Win and Place Markets on one spreadsheet
- ShaunWhite
- Posts: 9731
- Joined: Sat Sep 03, 2016 3:42 am
Load the win market in one sheet and the place market on a second sheet, then create a third sheet that references cells from the first & second sheets.
Use that third sheet to perform your calculations and then write the trade instructions back to either the first or second sheet.
Use that third sheet to perform your calculations and then write the trade instructions back to either the first or second sheet.
- ShaunWhite
- Posts: 9731
- Joined: Sat Sep 03, 2016 3:42 am
You need to go through each market in Guardian and tell it where you want the info to go.
There are 1000s of way Guardian<->Excel is used so there is nothing std to do exactly what you want. Doesn't take long to set it up.
- ShaunWhite
- Posts: 9731
- Joined: Sat Sep 03, 2016 3:42 am
Select all your win markets in Guardian and set them to "Bet Angel"
Select all your place markets in Guardian and set them to "Bet Angel (1)"
Resrict the refresh in the Guardian Advanced tab, so that just the current market is being refreshed. If you don't restrict it then several markets will be writting to the one tab, each overwritting the previous, over and over again.
But, it would be better still if you have a spreadsheet that has seperate pairs of worksheet tabs for every win/place market you want to monitor in Guardian.
BetAngel - A win market
BetAngel (1) - A place market
BetAngel (2) - A win market
BetAngel (3) - A place market
BetAngel (4) - A win market
BetAngel (5) - A place market
...etc and then the refresh won't be an issue, every market will go to it's own tab.
Select all your place markets in Guardian and set them to "Bet Angel (1)"
Resrict the refresh in the Guardian Advanced tab, so that just the current market is being refreshed. If you don't restrict it then several markets will be writting to the one tab, each overwritting the previous, over and over again.
But, it would be better still if you have a spreadsheet that has seperate pairs of worksheet tabs for every win/place market you want to monitor in Guardian.
BetAngel - A win market
BetAngel (1) - A place market
BetAngel (2) - A win market
BetAngel (3) - A place market
BetAngel (4) - A win market
BetAngel (5) - A place market
...etc and then the refresh won't be an issue, every market will go to it's own tab.
Thanks Think I have got it although quite abit for my tiny brain to get round but Ill have a play around and see if I can get it. At the momment I have one spread sheet with a page named Win Markets and a second page for place markets then a third sheet for the calculations etc but Ill have a play around and sure the penny will drop Many thanks for you help
Have you managed to do this?Banthorpe wrote: ↑Sat May 26, 2018 2:29 pmThanks Think I have got it although quite abit for my tiny brain to get round but Ill have a play around and see if I can get it. At the momment I have one spread sheet with a page named Win Markets and a second page for place markets then a third sheet for the calculations etc but Ill have a play around and sure the penny will drop Many thanks for you help