All posts by Trader247

Api delay testing

Before I installed MSOffice on the Tagadab VPS,I checked the delay to see what improvement there was. I took some snips to show the difference.

This is the delay on my PC on a UK market. It averages around 93ms. This is impacted by any other activity though, even on other devices. I watched it as I downloaded a new skin onto my RPi and it slowed it to around 200ms for about 10s.

wp-1459233091444.jpeg

This is the same UK market, now on the VPS. Average delay is around 18ms, a vast improvement and I didn’t notice any periods of change.

wp-1459233104437.jpeg

This is an Aus market on my PC. Delay around 700ms with refresh at 800ms. It’s actually set at 0.2s.

wp-1459233114730.jpeg

The same Aus market on the VPS. Delay is about 320ms with refresh down to 400ms. I’m more surprised by this change than the UK markets as that was expected. I admit I don’t understand where this improvement is achieved.

wp-1459233129540.jpeg

 

 

VPS active

I’ve spent some time setting up the VPS. I decided to go with Tagadab after looking at many different providers. Although the others appear to be cheaper, when you add all the different charges together they aren’t that much different. I looked at reviews and concluded that low cost equals poor service. I’ve chosen the SVS1000 without SSD, it’s £17.99/month. It took about 10 minutes to be set up.

Installing Gruss was easy once I figured out how to download it. Internet Explorer wouldn’t do it at first, I had to change security settings to allow downloads from untrusted sites, then changed it back once done. I just logged in as normal and set the options as they are on my PC.

My MSOffice key wouldn’t work again. I know others have reused theirs but they are only meant for one install. I tried but it refused. It may be because I got my original one as a student (OU), I think I got the full package for about £40. So I’ve purchased a new Office 2010 key at a cost of £54. It downloaded and installed pretty quickly.

With Gruss and Office installed I just needed to get my bot installed. A simple copy and paste of the file and it was done. It’s now up and running.

Week ending 20-03-2016

Starting with the UK dogs, a poor result. The two large losses early in the week were both multiple losing trades on one selection in each event. The rest of the week had a general downward trend. I wondered if Cheltenham had any effect. I know it impacts on all the horse racing as people get involved with other venues whilst trading/betting the main races. Maybe some dabble on the dogs as well.

The Aus markets returned well although errors persist. At around the 125 point Gruss was updated with a fix regarding the error related to the bets manager. I was hoping this would fix my errors but the second to last market had an error similar to what I’ve experienced previously, with a lay placed in the last seconds before off. I can’t work it out from the data I have.

Another issue I had came on Saturday afternoon when I decided to update my PC. Saturday afternoons are usually quiet, probably because most people focus on the horses or football. As I’m on Windows 7, I don’t get update notifications, only the GET WINDOWS TEN FOR FREE message every day. So I have to go into the control panel to check for updates and there was about 50 pending. After an hour of updating it failed and, if you’ve ever had this happen you’ll know, it then needed to be left overnight to revert back. This meant I missed Saturday evening and Sunday afternoon on the dogs and all Aus races on Sunday. This is an occasion when a VPS would have been brilliant. More on the VPS project later.

 

160320weekAus160320week

Overflow

I came home the other day and found my bot had stopped due to an overflow error.

After each market is traded the “My Bets” page data is added to a log sheet along with bet attempt data. Every week or so I save this sheet and clear it in the bot.

When running, the code finds the next empty row to paste to but that row number value is an integer data type. This has a limit of 32767. As can be seen, I’d left it too long and it reached it’s limit.

wp-1458927489814.jpeg

 

CROSS-MATCHING RESIDUAL FUNDS

Betfair’s Aus exchange has some money in it’s account and I get a cut. Here’s the message I got –

As you may realise, many Australian markets offered by Betfair employ cross-matching, a process that increases the likelihood of customers’ bets being matched through a specifically-calculated algorithm (for more detailed information on cross-matching on Australian markets, please click here.

Over time, the cross-matching process on Australian markets results in the accumulation of a small amount of residual funds within our internal matching account, which we are required to distribute to eligible customers at certain intervals.

As you have placed a bet in an Australian exchange market that employs cross-matching since the last distribution of funds, you are entitled to an allocation of a share of these funds.

As any Betfair customer throughout the world to have placed a bet in an Australian cross-matching market is entitled to a share of the distributed funds, the relevant amounts per customer are quite small. Please be advised that your share of the distributed funds has been deposited into your main wallet in your local currency.

If you have any further queries, please get in touch here.

Thank you
Betfair

A very helpful Live Chat guy volunteered to look through my transactions (there’s thousands of them) to find out how much I got.

Here’s the payment –

AusResFunds

That is £2.51 (GBP)

I wonder how much others got?

VPS

I’ve floated the idea of moving to a VPS before but haven’t progressed far as I’ve been a little unsure. Anyway, Mike commented on the site and gave some detail about His choice of VPS and I’m going to have a go.

Here’s the chat we had.

Mike

Hi. Just discovered your blog. As someone who currently runs automated trading exclusively (i.e. no live manual trading) and manages to make a “reasonable” return off it, I’m intrigued to follow your progress. Not many blogs out there dealing solely in automation. A couple of things I’ve found in the journey so far that may be of interest.
Firstly the cost of moving to a VPS has been far outweighed by the reliability/stability. I moved over a year ago and have no regrets. No server downtime or dropouts from my end since then. Secondly, I too trade the Aussie markets overnight. I’ve found however, that there is a big difference between Metro/Prov tracks and all the rest. Not just in matched volume but the way the volume enters the market. My returns on the former are 3x my returns on the latter. It might be something you should think about if you haven’t already. Good luck, will follow with interest.
trader247
Hi Mike,
Thanks for the comment.
The VPS is definitely something I want to do. Do you run third-party software, eg Gruss/Bet Angel, or do you have your own program?
I’m currently using Gruss but this would require a Windows VPS with MSOffice installed.
Also, could you tell me who you went with for VPS as I’ve looked and am unsure about what to go for, various prices/location/spec to choose from.
Thanks
Mike
I’m a Gruss user. Self programming is obviously the next goal but at the moment Gruss handles what I need so in no hurry on that front. Rather do it right than rush it. A few people on the forum over there suggested Tagadab and that’s what I went for. I’ve gone for a SSD VPS with 1GB RAM and 35 GB storage. Basically there lowest spec. Yes you will need to install a copy of MSOffice but if you have a licence on your own machine that’s usually good for 3 PC’s I think. At least that’s what I used.
I’m currently using it close to its capacity with what I run but that can be up to 6 tabs & excel sheets refreshing at the max 0.2 secs leading up to the start of any particular race market. Costs me 22.19 a month which I think is good value for the stability and it frees up the home connection for development work. It’s also a month to month cost, no lock in subscription, so you can always dip your toe in and leave if it doesn’t suit.
Good luck

trader247

Thanks Mike, this is really useful stuff. I’ve had a look at Tagadab and I’m going to give it a go, might be Easter when I get to it though. I’m not sure about my MSOffice license but I can give it a go. I’ll roll this info into a post, thanks again

Multiples

I don’t do serious betting on horses but have a dabble on some big events just for fun. I got Blaklion yesterday which was good. Anyway, I picked four today and had a multiples, done on Betdaq. I thought I’d see how much I’d get with Betfair, expecting it to be more. Look at the difference though, same selections. £68k Betdaq and £40k Betfair – don’t do multiples on Betfair!

img_20160317_103750.jpg

img_20160317_103821.jpg

 

Aus errors – update

The problem starts with the Aus API failing to reply to a call and then Gruss gets a bit stuck, trying endlessly to get a reply. The guys at Gruss may be able to provide a  fix as Betfair appear to be away from the desk with this one.

A user on the Gruss forum has reported testing alongside BA and not had the errors replicated. This should mean that the error can be ignored. I’m hoping it is fixed soon as I’m seeing more errors by the day.

This should motivate me to get on and complete my own bot…

Error pic

Aus errors

The Aus trading has experienced some errors lately (see chart, they’re the sharp jumps up and down) which I put down to my underwhelming internet connection. However, I was reading some posts over at Gruss and there might be another explanation. This post talks about an issue with the Aus API where bets are not updated in real time (if you log into the Gruss forum there’s an acknowledgement of this error in the Bug Reports section). The errors that I have looked at occur close to the off which would make sense if the bet status is delayed whilst my bot is greening; it’s calculating on incorrect data. I could stop trading further out but I don’t really want to as some markets only start getting active in the last few minutes. I’ll employ the ‘wait and see’ approach to this problem.

Aus160306weeks