One click trading - free program coming soon

[GaryRussell]

Originally posted by: Gaseous
Monkey, just a thought, but if you go back to my original macro and put it into the sheet code - does that do anything for you? (Making the corrections of course)

Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("A4")) Is Nothing Then
Exit Sub
Else
1
If Range("D2") < Range("A4") Then
Then Application.Wait Now + TimeValue("00:00:01")
goto 1
else
If Range("D2") >= Range("A4") Then
maxfield = ActiveSheet.Range("b65536").End(xlUp).Row
For I = 5 To maxfield
Range("A" & I).Value = Application.WorksheetFunction.Sum(Range("I" & I)) - Application.WorksheetFunction.Sum(Range("G" & I))
Range("A" & I).Value = Range("A" & I).Value / 2 + Application.WorksheetFunction.Sum(Range("G" & I))
Next I
End If
end if
end sub

This way (i hope) after you enter the time in A4 the sheet will run the code on itself until the time is the same - and hopefully you can do that on each sheet.

[GaryRussell]

Originally posted by: Gaseous
OK, 3 in a row on someone elses thread is not good - sorry 'bout this.

Just to let folks know i will not have computer access, except at work, for about a week so will not be able to offer much in the way of solutions.

George

[GaryRussell]

Originally posted by: The Gambling Monkey
Cheers George, I'll test them after racing has finished, many thanks.

LayItYouMug,
Is it alright to discuss Excel & Macro issues relating to your application on this thread or did you want to start an "Official One Click Trading Excel & Macro" thread?

[GaryRussell]

Originally posted by: PillHead
Gaseous

Both the beep and the wav files are now working - I had to set the enable macros on.

Many thanks for your help

[GaryRussell]

Originally posted by: Walrus
.

[GaryRussell]

Originally posted by: smipi
why i cannot see all markets?

[GaryRussell]

Originally posted by: sally
I have tried all sorts of triggers using this brilliant program but I must be plain stupid,as I cant think of one yet that makes a consistent profit!its my fault,not the programs.

[GaryRussell]

Originally posted by: RSPL
Sally, I have had the same problem, the program is great and layit has done a wonderful job. It allows you to try all sorts of things for small stakes and i have found some successful some not so. But the real problem is it makes everything easy so it is tempting just to play for the sake of playing and pinch the odd bet here and there.

I have come to the conclusion its a great tool, but for me I need to use it as a better way of placing my bets not an easy way to try and make money without the necessary work.

[GaryRussell]

Originally posted by: sally
Rspl,glad to know someone is in the same boat as me,finding a strategy even with a small edge
is my priority,it is so easy to be caught up in the versatity of this program,I can think of many ways of playing with the excel sheet,hours of fun,playing with min stakes,it makes losing enjoyable!

[GaryRussell]

Originally posted by: Snake Plissken
Funny I'm the complete reverse. Never used his program but make shedloads of money.

[GaryRussell]

Originally posted by: smipi
i can see only the winner market, and if i try to refresh several time can i see the other markets,but for a while...

[GaryRussell]

Originally posted by: pred
whats the site address?

the only web site i can find selling the program are looking 97 quid for it.

anyone have any ideas?

[GaryRussell]

Originally posted by: RSPL
Snake Plissken 27 Jul 20:31


Funny I'm the complete reverse. Never used his program but make shedloads of money.



Funny how there are so many CC's around. Some people are just a bit more honest with other people and themselves. Did that make you feel nice and superior, can you tell me what the point was apart from making you look like a Richard.

Pred if you look in the middle of page 24 on the thread you will find the link.

[GaryRussell]

Originally posted by: pred
cheers mate, appreciated

[GaryRussell]

Originally posted by: PuntingMuppet
Is anyone finding the Betfair Refresh isn't working? Mine has in the past, but in the last week or so it doesn't seem to be updating the actual odds....it still goes through the motions (sounds, activity at the bottom of the screen) but the actual refresh of prices doesn't seem to go.

Is anyone else experiencing this?

I re-installed the software with the latest edition but it seems to make no difference.

Any help greatly appreciated.