First attempts with Excel

Discuss anything related to using the program (eg. triggered betting tactics)

Moderator: 2020vision

First attempts with Excel

Postby Guerilla » Fri Jul 14, 2006 6:58 pm

Hi all,

I am just starting to use excel with BA. Are there any help files on this anywhere?

I have managed to get a BACK bet triggered using IF statements for criterias, however, I now want to move on to laying a bet once the BACK has been matched to lock in a small profit. How would I go about this? I am proficient in using excel (not VBA). Can you help?

Matt
Guerilla
 
Posts: 1
Joined: Fri Jul 14, 2006 6:52 pm

Postby The Gambling Monkey » Sat Jul 15, 2006 12:46 pm

Try doing a forum search for CLEAR and you will come up with a way of doing what you want.

Look at the sample triggered betting files, they will give you guidance.

For anything specific just ask.
The Gambling Monkey
 
Posts: 39
Joined: Fri Nov 18, 2005 9:22 pm
Location: St. Albans

Postby Mitch » Sat Jul 15, 2006 2:35 pm

The main problem is that you'll have to have conditions in your formula for when to say "BACK", "LAY", "WAIT", and "CLEAR". I'm not even sure if it's possible. If you want to make an equal profit on all runners then you'll also need a formula in your stake column, which unless you manually type the details of your bet somewhere else on the sheet, will have no info to work with once the CLEAR command has been used.

I know it sounds daunting, but you are so much better off trying to learn a little bit of vba, it makes it so much easier. If you have any coding experience either with a scripting language or any form of BASIC you'll pick it up easily. Even if you haven't it's not difficult to learn and there are lots of people here who can help - especially if you're willing to learn.
User avatar
Mitch
 
Posts: 365
Joined: Sat Nov 19, 2005 12:28 am
Location: Leicester

Postby The Gambling Monkey » Sat Jul 15, 2006 3:05 pm

Mitch,

I wasn't aware that there was a "WAIT" trigger. How long does it wait?

Cheers,

Scott
The Gambling Monkey
 
Posts: 39
Joined: Fri Nov 18, 2005 9:22 pm
Location: St. Albans

Postby Captain Sensible » Sat Jul 15, 2006 7:04 pm

Just need to add a few extra if/and statements. I have one that just decides to green up by lay or back dependant on the profit loss column. You can kick off clear if say the matched stake is a certain amount or some other criteria

=IF(AND(stakematch>0, betref>1),"CLEAR",O4) O4 would just contain some other calcs deciding whether to say lay or back.

Or to make things simpler just open the market in another tab and have that pointing at separate calcs on say sheet2
User avatar
Captain Sensible
 
Posts: 2901
Joined: Sat Nov 19, 2005 2:29 pm

Postby Mitch » Sat Jul 15, 2006 9:05 pm

The Gambling Monkey wrote:Mitch,

I wasn't aware that there was a "WAIT" trigger. How long does it wait?

Cheers,

Scott


There isn't a "WAIT" trigger, it was just an example of something that won't trigger the original BACK. You could use any word(s) or leave it blank, whatever you do now is ok.

Sorry my post was misleading.
User avatar
Mitch
 
Posts: 365
Joined: Sat Nov 19, 2005 12:28 am
Location: Leicester

Postby oddlegs » Fri Nov 03, 2006 7:53 pm

what trigger will i need to lay two horses at same time at 2.00or less
oddlegs
 
Posts: 4
Joined: Thu Aug 03, 2006 4:54 pm


Return to Discussion

Who is online

Users browsing this forum: No registered users and 15 guests

Sports betting software from Gruss Software


The strength of Gruss Software is that it’s been designed by one of you, a frustrated sports punter, and then developed by listening to dozens of like-minded enthusiasts.

Gruss is owned and run by brothers Gary and Mark Russell. Gary discovered Betfair in 2004 and soon realised that using bespoke software to place bets was much more efficient than merely placing them through the website.

Gary built his own software and then enhanced its features after trialling it through other Betfair users and reacting to their improvement ideas, something that still happens today.

He started making a small monthly charge so he could work on it full-time and then recruited Mark to help develop the products and Gruss Software was born.

We think it’s the best of its kind and so do a lot of our customers. But you can never stand still in this game and we’ll continue to improve the software if any more great ideas emerge.