One click trading - free program coming soon

[GaryRussell]

Originally posted by: Toma
Cheers Ian let you know how I get on

[GaryRussell]

Originally posted by: Toma
IanP that is brilliant mate, cant thank you enough.....Promise I will listen in class more often!!

Fantastic thanks again!

[GaryRussell]

Originally posted by: Toma
IanP, dunno if it is possible and if it is to much trouble don't worry about it but.......is it possible to remove the previous off time when the next event is loaded?

It doesn't cause me a problem as it is < than the current time and won't trigger my bet it is just a cosmetic change thats all.

If possible then great if to much grief then no problem and once again thanks for your fantastic help!!!

[GaryRussell]

Originally posted by: treider
Can anyone tell me what does the WOM column means? Thanks in advance, and congratulations layit.

[GaryRussell]

Originally posted by: IanP
Toma ... havn't been able to test this properly as I can't see anything going in-running just now. But it does clear N1 on change of market.

Private Sub Worksheet_Calculate()
Static MyInPlay As Variant
Static MyMarket As Variant
Application.EnableEvents = False
Application.Calculation = xlCalculationManual
If [E2].Value = MyInPlay Then
GoTo Xit1
Else
If [E2].Value = "In Play" Then
[N1].Value = [C2].Value
End If
MyInPlay = [E2].Value
End If
Xit1:
If [A1].Value = MyMarket Then
GoTo Xit2
Else
[N1].Value = ""
MyMarket = [A1].Value
End If
Xit2:
Application.EnableEvents = True
Application.Calculation = xlCalculationAutomatic
End Sub

BTW anyone know if its possible to post so that the leading blanks are not nulled.
The coding isn't as untidy as it appears - honest !!

[GaryRussell]

Originally posted by: RD
Gary, would it be within the realms of possibility to use the program to place multiple bets (doubles, trebles, accas, not necessarily but maybe lucky15s and stuff like that) across different markets?
Could something like that be a similar facility to your 'quick pick', instead using individual selections?
Such an innovation would be fantastic.

[GaryRussell]

Originally posted by: chuffmagarley
Ian cp ,hi we've spoke on the aus stuff many moons ago ( about a visa and your stress free life!!)

would it be possible for you to send me a screen shot of how an excel sheet would look like for setting up laythefield at short odds,that would be submitted after the off ?? A big ask I know,if you are to bust or cant no worries

sodium@shinyfeet.c o m

[GaryRussell]

Originally posted by: chuffmagarley
bust = busy!!

[GaryRussell]

Originally posted by: G-Factor
Thunderfoot,

I'm not sure how a screenshot would help, but you can see for yourself.

Make sure you are NOT logged in, then just put a stake and odds in columns O and P, then type either "BACK" or "LAY" in column N on the same row.

It will then try to place a bet but come back with an error.

Or....... you could be logged in and request a bet that will not be taken, ie. a back at 100 for £2 on a favourite. You will then get a bet reference and zero's in the 2 end columns.

You could then type "CANCEL" in column N and watch your bet get automatically cancelled


Mikeyboymike,

I thought I read that the CANCEL trigger cancelled a bet tho I could be wrong. I thought CLEAR just cleared the bet refs.

I'm off out in a minute, but you could try what I've written above to see what it does.

[GaryRussell]

Originally posted by: G-Factor
Hi LayIt,

Is it possible when the 'send to Excel' box comes up, for it to ignore hidden workbooks?

It's only a couple of mouse clicks for me, but sooner or later I'm bound to start sending info to my PERSONAL.XLS book, which I'd rather not do.

[GaryRussell]

Originally posted by: IanP
Chuff .. I havn't actually got a spreadsheet that does that .. I was just showing Toma how to capture the Off Time .. I don't actually play in running unless its to get out of the sh1t !!

[GaryRussell]

Originally posted by: G-Factor
chuff,

rather than try to capture the 'off' time, you could check that E2 is "In Play", and F2 is not "Suspended".

Unless I'm missing something I think that would have the same effect.

[GaryRussell]

Originally posted by: IanP
G-Factor ... that would work to place a bet immediately but Toma wanted to delay it for 20 secs.

[GaryRussell]

Originally posted by: G-Factor
Not that I need to I suppose, but I don't understand why 20 seconds?

[GaryRussell]

Originally posted by: G-Factor
IanP, I've just re-read it and noticed you were replying to Toma, not chuffmagarley, sorry