One click trading - free program coming soon

[GaryRussell]

Originally posted by: The Gambling Monkey
LayItYouMug,
I didn't think it possible but the program is even better now you've added Triggered Betting. Thanks again.

I have a general excel formula query if any of you clever people can help me. I want to record all prices at only one instance namely 13:30:00. Being new to this malarkey I came up with:

=IF(C2<TIMEVALUE("13:30:00"),(((H:H-F:F)/2)+F:F),"Problem as I want it to do Nothing but Keep the Result of the Formula Here")

But as you can see this will never work as all I want to do is keep the result when TRUE and do nothing yet still keeping the TRUE result when FALSE.

Is there a WHEN function?

Any help gratefully received. Thanks.

[GaryRussell]

Originally posted by: Aditza
It's that Ro Alex?

[GaryRussell]

Originally posted by: Alexandru
Close, Md.

[GaryRussell]

Originally posted by: Addict^
Mind if u change a few words? U have a messenger id?

[GaryRussell]

Originally posted by: russ8s
HOW CAQN I ADJUST THE WINDOW SIZE FOR THE FIELD ?

so i can see all the runners and bets made at the same time please

[GaryRussell]

Originally posted by: The Gambling Monkey
Click on Options and untick Display Betting Options and Display Bets Manager

[GaryRussell]

Originally posted by: Tarquin Otter
I've read through these posts but still not sure how to work this program. Can someone tell me what the WOM is for and what doese it mean when it turns pink and blue.

[GaryRussell]

Originally posted by: Handy Andy
Hello, I have the pre -release version. How do I upgrade to the current version?

[GaryRussell]

Originally posted by: RSPL
My understanding is if its pink there is more money waiting to lay than bet and visa versa.


Its still on prerelease version bad foreground colour and background colour for my eyes anyway but its at the link

<a href="http://www.gruss.pwp.blueyonder.co.uk/" target="_blank">http://www.gruss.pwp.blueyonder.co.uk/</a>

[GaryRussell]

Originally posted by: nutter punter
The WOM will not make you money and to be honest it is best ignored. Instead take advantage of Gary's awesome ability to bring you a programme that responds and acts far quicker than the standard Betfair interface.

The guy has done us a great favour !

[GaryRussell]

Originally posted by: Tarquin Otter
When using this program do you need to be logged into betfair as well, or can you use it without even having the betfair site loaded?

[GaryRussell]

Originally posted by: nutter punter
You can be logged in or not whichever is more convenient.

[GaryRussell]

Originally posted by: smh
I'm quite new to the program and still exploring, but there's a few things that i would really like to see implemented:

Most of all, it would be great if the placed bets can be sorted.
Being able to change the stake for unmatched bets would be nice too.

Is it possible to add some more information about a match, like what is displayd on the rules tab. For example if a match will turn in play or not?

Can you make the suspended box smaller or put in a different place, i sometimes would like to see the last betting status.

The read me could probably be extended a bit, although most of you probably know what ya doing. I found one small error at the override odds section. It's pointing to the top right corner, should be left now.

Don't get me wrong, i'm not complaining, this program makes life a whole lot easier

[GaryRussell]

Originally posted by: Gaseous
To THE GAMBLING MONKEY

Sorry this is so late - and messy, but i can't come up with a formula for you.

I have a macro that i hope does what you want
In excel press down ALT + F11 to open the VBA Editor
press ALT + I, ALT + M to open a module sheet and paste this in.

Sub split()
If Range("C2") < Range("A31") Then Application.OnTime Now() + TimeValue("00:00:01"), "split"
If Range("C2") = Range("A31") Then
Range("B31").Value = Application.WorksheetFunction.Sum(Range("H:H")) - Application.WorksheetFunction.Sum(Range("F:F"))
Range("B31").Value = Range("A32").Value / 2 + Application.WorksheetFunction.Sum(Range("H:H"))
End If
End Sub

Go back to your workbook now. Basically the code will look at cell C2 and when it is less than the time value you place in cell A31, the macro will keep calling itself every second. When the value you placed in A31 = C2 then it will put the result of your calculation in cell B31. You may need to format cell A31 to time, but it might work without you doing this. After you enter the time in A31, you need to start the macro. Press ALT + F8 and run the "split" macro.

You may have more luck on mrexcel.com for a formula, possibly Aladin if he's around (excel God), but i can't get the value to stay after the time specified - the formula result just keeps changing.

Hope this makes sense.
George

[GaryRussell]

Originally posted by: The Gambling Monkey
Thanks for that George, not quite what I wanted but I think I can tweak your macro to do what I want.
Thanks for you help it is much appreciated.

On another topic, anyone know why I can only log prices from a maximum of three markets at a time?
Also I can't get the markets to close in the Betting Assistant, I've tried right clicking the tab but that no longer works.
Cheers.