Software advice -Linking prices from an excel spreadsheet to the exchanges.

Gruss. Perfect.

I have downloaded gruss but there does not seem to be an instruction manual on how to link my excel spreadsheet. Any idea?

There's a guide to how to setup the link in the help section- you have to figure out the excel stuff yourself but it's not difficult.

great, found it. Thanks.

aye robot is right.gruss is super.

A little confused.. Does it only allow you to put in one bet per market? ie don't seem to be able to put a lay price and a back price for Arsenal to win?

what excactly you want to do?
try to post to the gruss forum also.there is great support there.( i think right now their forum is "down" though)

You'll have to put the bets in separately, IE put the back bet in first then the lay bet. Either that or use two sheets, one for backs and the other for lays.

aye robot are you posting in gruss forum also?

No.

pitty.i wanted to ask something in private

Sorry Gup, but I don't enter into any correspondance. Nothing personal.

fine. :)

sqzy 11 Feb 16:30
A little confused.. Does it only allow you to put in one bet per market? ie don't seem to be able to put a lay price and a back price for Arsenal to win?

you can do that easy with gruss, check the excel triggers in the help file.

This is what I want to do. My spreadsheet tells me what price a match should be using various formulae. For example in a football sheet I will put in the players ratings, score, time, aggression etc and it will formulate a win %. I will then have a cell with what price I am willing to lay this team at and the stake I want to place. The same with the 'back' side and also the other team and the draw. This price will change every 30 secs or so. All I want is a platform to put these prices onto betfair from my spreadsheet and update these as I update the differing variables in the spreadsheet and crucially allow me to terminate these bets at a push of a button.

I'm not sure this Gruss software is what I'm looking for...

You can do that with Gruss.

you can do it, but yes it is complicated, and if you are suppose to go in running you have to consider the x second delay.

Gruss is deffinately what you're looking for, it will do exaclty what you describe. You just have to work on your spreadsheet and do a little light VBA to keep automatically updating your bets and provide you with a cancel button. If you're proficient in excel it won't be difficult.

sqzy 11 Feb 17:39


I'm not sure this Gruss software is what I'm looking for...

I doubt any of of the other software out there is advanced as gruss for excel integration you've got alsorts of access using simple formulas or even as far as the com interface to call the api functions direct. If you can't do it thru gruss you may as well get someone to write bespoke software for you imo

That's a veritable barber shop choir of agreement.

Is there a delay between the spreadsheet and betfair? I understand there is no delay from Betfair for cancelling bets only placing them but that is fine.
I think I would probably be better to get someone to write a platform specifically for me.

No- once you put a trigger in it goes to Betfair as fast as the internet can carry it.

link the stake/odds boxes to the cells that tell you your desired stake/odds, so that they change in sync. you will need formula/vba code to place "BACK" in the trigger cell, once the bet is placed use "UPDATE" in the same trigger cell and the back odds will update every time the value in the odds cell changes, you cannot update your stake. cancel using the "CANCEL" trigger. you will prob need a separate sheet for lays...

can be done fully automatic but will take a bit of work/playing around/vba...

B-)

thanks aye. Thinking about it then yes if I make a cancel button and write a bit of VBA (not great at that) it could work. Will try it. First thoughts are that at the moment if I type in incorrect variables I just rewrite them before manually placing the bet with betfair whereas using this software if I typed in 90 mins gone instead of 9 mins gone etc it would have severe consequences. I suppose I need to put safety clauses into my excel spreadsheet to stop these possibilities.

sqzy 11 Feb 17:54
Is there a delay between the spreadsheet and betfair? I understand there is no delay from Betfair for cancelling bets only placing them but that is fine.
I think I would probably be better to get someone to write a platform specifically for me.

Only delay is down to the refresh rate you'd set so I doubt a 1/10 of a second should be too much of a problem.

£6 per month compared to god knows how much a coder would charge you for the app + ongoing maintenance API fees etc, might be worth trying gruss first especially as anyone writing betfair specific excel stuff would probably write it to link with with gruss anyway :)

You could easily automate things like the time gone and even monitor the CS market (or a website) to bring the score in for you too. There is advice on all this kind of stuff on the Gruss forum.

Just build something, try it out with small stakes and trouble shoot it live. You can always cancel your bets manually through the Gruss interface if you get in a mess. You never know, you might even enjoy it.....