It is possible for Guardian to scan an excel file for horse name then place said bet?
If not is there another way of doing it. I was thinking excel somehow but I have been looking at the user guide and it might as well be in a foreign language lol I can not get my head around linking everything together. I would even pay someone for a little help, or as I know you lot are loaded lol I could even donate to a charity
Yes, once you're comfortable linking a spreadsheet up to Bet Angel and pressing the connect button you should see the sheet moving live. Once you've watched some of the YouTube videos on Excel you should feel pretty confident loading a days' worth of markets up, turning on restrict refresh and selecting a good refresh speed. Have you got that far?
Once the sheet is ticking along, you're just going to need some simple formulas so if a name of a runner matches one, I am assuming you will have typed in manually the morning of the race, it will trigger a bet.
Get comfortable with using the template workbook first, watch some Excel videos on some simple IF statements and have a go. If you're still struggling, post back here with what you have managed to figure out and help will follow.
Been doing this for 18 months full time and traded 87,000 markets, yet am still to dip my toe into the water of Excel trading. I really must pull my finger out!
You'll be pleased to know that you don't have to get to grips with Guardian other than telling it which markets are attached to which sheets (and by 'sheets' I mean the individual tabs in a single excel workbook). It's become common for people to refer to an individual excel file as a spreadsheet, but that's actually a 'workbook' which contains any number of individual spreadsheet, each shown on a seperate tab.
Once you've told BA to connect, each of these spreadsheets will then be populated with the details for the corresponding race. And near the name of the selections there are cells into which you can place commands. These are checked each time Guardian cycles through its markets and the action is performed, ie back, lay, cancel etc.
But... If getting excel to work properly might be a long job for you, you could create your basic back or lay conditions in Guardian itself and then just select a nominated horse on each race manually. That would only take a few minutes once you've used it. If you're not certain your strategy is going to be profitable it might be worth doing it that way, albeit not so slick, and then doing the harder excel stuff once you know it'll be worthwhile.
I have been watching a lot of betangel youtube videos and think I now know what I have to do and how to do it. I was going to pay someone but going to learn myself so in future if I need to add or change anything I will be able to do it myself.
This will work 100% as I am doing it now but on bookmaker websites, not the exchange. Currently on 8,560 bets in 7 months with an ROI of Just over 10% The only trouble with that way is they are so quick to limit you and you need plenty of family and friends to open new accounts.
If I switch over to the exchange I will not have to worry about any of that. I take it some bets might not be matched but that's a small price to pay plus it will be automated so I can get on with my other jobs.
I have made a workbook that places the bets how I would like. I am having trouble cancelling all unmatched bets. I would like to cancel all unmatched bets when I have staked £30 on the back market. I tried =IF(AA:AA=30,"CANCEL_ALL","") in the Global Commond cell but that does not seem to work.
So the global commands cell and the one immediately to the right are both empty? Then you place a back bet(s) into the market, £30 or more is matched and then the CANCEL_ALL string appears on the screen? The cell to the right should either flash up "OK" or "ERROR" or something at least? Bit more detail if you can please.
Also, maybe change your proposed string to >=30 just incase anything went wrong and you matched more than £30, you'd want to get out immediately I'd imagine.
So the global commands cell and the one immediately to the right are both empty? Then you place a back bet(s) into the market, £30 or more is matched and then the CANCEL_ALL string appears on the screen? The cell to the right should either flash up "OK" or "ERROR" or something at least? Bit more detail if you can please.
Also, maybe change your proposed string to >=30 just incase anything went wrong and you matched more than £30, you'd want to get out immediately I'd imagine.
Hi CallumPerry.
I have got it working, for some reason, I do not think it was counting the column AA. What I did was in cell AG I put =SUM(AA:AA) then in Global Command put =IF(AG1>=30,"CANCEL_ALL","") and seems to be working.
Now just need to find out how to cycle through markets on a single spreadsheet. I could use Multiples but that means having 30+ spreadsheets open and did not want it to slow down my computer.
Yeah try to get a whole list of markets loaded up in Guardian with different start times i.e.horse races and then browse for the workbook, connect, auto-bind and auto-clear and then go to the advanced settings tab and tick restrict refresh on and select the window of time you want to view. Not that difficult to figure out.
Yeah try to get a whole list of markets loaded up in Guardian with different start times i.e.horse races and then browse for the workbook, connect, auto-bind and auto-clear and then go to the advanced settings tab and tick restrict refresh on and select the window of time you want to view. Not that difficult to figure out.
Thanks for that it worked perfectly. The only trouble was the 'Status' box was not changing for each new race so new bets were not being placed. No doubt something could be done with VBA but going to go with a multi spreadsheet.
No worries and yeah there are example spreadsheets available on this forum which auto-refresh, you could take the formulae/VBA code from these to add to your custom multi-workbook to get this to work. Most of us who use spreadsheets make up our own way of clearing the cells as and when we want, specifically for our own systems.
