One click trading - free program coming soon

[GaryRussell]

Originally posted by: captainktheacetrader
LayIt,

You are providing a fantastic piece of kit for free.

IMHO any moaners should be shafted, with a 9x3, forthwith.

[GaryRussell]

Originally posted by: moocher
Totally agree with that sentiment Capt'n !

[GaryRussell]

Originally posted by: Gaseous
soccergeez

If you can enter the start time as part of a formula, increase this time by 45 min you can then display BACK if price > 2.3

Something like =if(and(cellwithcurrenttime>starttime+45,odds>2.5),"BACK","")

I know it's a bit scrappy, but as i'm at work i don't know how the layout would look. This should get you on the right road though.

[GaryRussell]

Originally posted by: Harvey
lol layit youve created a cult mate...................they'll be wanting a signed photo yet...........

(the minimum stake was just a bit of mischief)


Do you really only have 20 or so users,I thought we'd be up to the 80 mark by now,looking at the various posts on this thread...............

Ive set the new collating tangents for the cricket upgrade and hope to reap the benifits,watching those green numbers grow is like watching a blue peter appeal.....


.

[GaryRussell]

Originally posted by: Alexandru
I am also surprized that only 20 ppl use this prog. At the same time it's cool for the 20 of us 'cuz we have a competitive edge

[GaryRussell]

Originally posted by: SmallDave
Hi Layit,

You are doing an excellent job with this.

Noticed a slight problem with the dutching - if you select items 1,2 and 4 for a dutch, and then Betfair change the order of the items, you still remain with items 1,2 and 4 dutched - but they are different selections now.

Keep it up mate - it's great!

[GaryRussell]

Originally posted by: Alexandru
SmallDave:

don't be that lazy: uncheck and check.

[GaryRussell]

Originally posted by: soccergeez
Gaseous,
cheers for that mate Ill give it a try, much appreciated. Bearing that in mind do your unmatched bets still get cancelled on Layit's program when a match turns in running or a goal is scored etc?

[GaryRussell]

Originally posted by: soccergeez
whoops just realised that ain't gonna work cos its not an actual clock in my excel I just manually input how much of the match remains, any other ideas? Like how to get a real clock in excel????

[GaryRussell]

Originally posted by: Gaseous
soccergeez - don't think we're on the same page with this one.

If you put the formula =IF(C2>TIMEVALUE("00:49:00")+TIMEVALUE("00:02:30"),"yes","no")
It will check the cell c2 (the clock that is constantly being updated from the trading software) and if the time in that is greater than 00:49 (yes, should be asleep by now) + 2.5 min, display "yes", otherwise display "no" 'til this happens.

Not sure if it's the layout of your workbook that is getting confusing. if you replace the 00:49 with the cell ref that you manually input to show the start of the game, 02:30 should be "00:45:00" to show 45 min.

LayityouMug may need to start another thread just for the excel stuff.

[GaryRussell]

Originally posted by: russ8s
HAS THIS BEEN UPDATED AGAIN

how can i keep the same version ?

[GaryRussell]

Originally posted by: soccergeez
Thanks again Gaseous, Sorry, Im just rather thick.

[GaryRussell]

Originally posted by: nutter punter
Curiously I have just come across my first small problem. The actual refresh rate has increased to around 1500ms over the last day or so. Does anyone have any idea why?

[GaryRussell]

Originally posted by: Addict^
Alexandru, do u mind if I ask u where are u from?

[GaryRussell]

Originally posted by: Alexandru
Addict: why? if you ask me because of my name, then u're close.