One click trading - free program coming soon

[GaryRussell]

Originally posted by: IanP
No apology needed .... Cheers

[GaryRussell]

Originally posted by: soccergeez
Is there are way in trading mode to set an amount you want to win regardless of the result & then the program automatically places the bet when the amount is reached?

eg. I lay Barnet for £100 at Evens & tell the program I want to win £30 what ever the outcome, then the program calculates what price I need to go "all green" for £30 & places the bet for me?

[GaryRussell]

Originally posted by: nutter punter
Layit, for those of us without the required Excel knowledge to set up a decent betting sheet would it be possible for you to do a basic version and put it up on your website.? I am sure there are quite a few of us who can't take advantage of many of your excellent features such as triggered betting because we don't know how to use macros etc in Excel.

Cheers

[GaryRussell]

Originally posted by: 21Ants
I've finally got the hang of trigger betting but have been a bit disappointed at the prices I've been matched at, I realise that when you reach your target price and the trigger is pressed you are at the back of the qeue for that price and will be lucky to get matched at that price but I have been getting matched sometimes at 2.2 after setting the trigger at 3.4. I think if your only doing a few in a race it's best to back them manually when they're approaching your target price, anyone agree..

[GaryRussell]

Originally posted by: Toma
Hi Guys,

Does anyone know anyway that you can reset the Cols Q to T when you load a new event into your spreadsheet. I have been looking at using the AUTOLOAD markets from my pick list and it works really well however I need these cols reset from the previous event in order for my triggering to function correctly.

Any Ideas or Layityoumug is this something you coul dmaybe include in a future release?????

Much appreicated and once again thansk for a FANTASTIC program!!!

[GaryRussell]

Originally posted by: mikeyboymike
Layit, it's frozen on me once. At the end of a race, it went suspended then froze. I didn't notice anything specific about my setup, had a few markets on Auto select but can't give you any more info I'm afraid.

[GaryRussell]

Originally posted by: mikeyboymike
Toma, Layit has recently included a "CLEAR" trigger which will reset those fields for you.

[GaryRussell]

Originally posted by: tigerg
does anyone have trouble with excel too? i have office 2003 and the program never starts logging prices.

[GaryRussell]

Originally posted by: Toma
Hi Mikeyboymike, Thanks for your suggestion and I have tried that but my problem is that I have almost fully automated my betting strategy using the autoselect features to load the next race etc.

The problem I have is when the next race is loaded it retains my bet information from the previous race and as my strategy only backs 1 horse per race I check these cols for data before executing the bet. I therefore was lookign for an automated way of clearing these cols when the next race is automatically loaded.....hope that makes sense!

Once again thanks for the reply and I can't believe the quality of this program. I am forever in your debt Layityoumug!!!

Cheers
Toma

[GaryRussell]

Originally posted by: IanP
Toma .. I think you need some sort of Workbook_Calculate macro which will run every time the sheet calculates. It would need to check whether or not A1 has changed from the last time it ran.

[GaryRussell]

Originally posted by: Toma
Thanks IanP, I was thinking it may have to be some sort of Macro.....I will have a look at that thanks for the suggestion. Much appreciated!

[GaryRussell]

Originally posted by: IanP
I think this might do it ....

Private Sub Worksheet_Calculate()
Static MyMarket As Variant
Application.EnableEvents = False
Application.Calculation = xlCalculationManual
If [A1].Value = MyMarket Then
GoTo Xit
Else
MyMarket = [A1].Value
Range(Cells(5, 17), Cells(100, 20)).Value = ""
End If
Xit:
Application.EnableEvents = True
Application.Calculation = xlCalculationAutomatic
End Sub

You need to set this up as a worksheet macro not a general macro.

[GaryRussell]

Originally posted by: peter piper
Layit,

I have been using this excellent program for several months now. Having just got a new laptop ive downloaded version 0.98n. This is fine on the old laptop, but the settings on the new one are causing the bottom edge of the odds to be missed off.

I know its a prob at my end, and have tried changing the screen set up but cant get this to work.

Im on XP with a 1440 x 900 screen.

Any ideas?

Cheers,

P P

[GaryRussell]

Originally posted by: Joey Silvera
Toma

If you stick something like...

=IF((D$2=TIMEVALUE("0:03:55")),"CLEAR","")

...somewhere in your present trigger, I think that would do the job. Set the TIMEVALUE to a couple of seconds after your 'auto-select to market' time.

[GaryRussell]

Originally posted by: RogerL
God, Is there any way of getting to this end of the thread quickly?

I too have the bottom of characters in the Betfair odds display chopped off. Works fine on my other machine, but my laptopp is at 1920 x1200. The reason, I think, is that BF allowed extra vertical space on ther page for people like me using 120 d.p.i characters instead of the normal 96 d.p.i., but Betting Trader is much tighter.

I can't work out how to use the program at all. Am I missing a User Guide somewhere, or Help Screens?

How do you get the Excel part working? Do you have to provide a workbook prenamed to it?

Last little problem. Being colourblind, I use yellow for laying not pink. This is stored in the Settings. Any chance this could be retrieved and used, or failing that a way of changing colours?

Only heard of the Excel feature today, and am really looking forward to looking into the possibilities. The basic program looks very good.