One click trading - free program coming soon

[GaryRussell]

Originally posted by: The Gambling Monkey
Brilliant!
Cheers Gaaseous just had to change one I to a G and it works perfectly, many thanks.

[GaryRussell]

Originally posted by: Gaseous
soccergeez - not sure this is possible. Your data will basically depend on the scoreline, and i don't think this is displayed anywhere on the betfair site. I tried something similar a while back, but even looking at the lowest value in the correct score section can throw up errors.

Pulling the score in from another site is an option, but using webqueries will require setting it up before the game and allowing your data to look at the appropriate cells - but only if you are sure that lines will not be removed from the site after the game has started. eg Rangers v Celtic are the 3rd game listed so you set everything up to pull the data from row9 One of the other games finished and RvC get moved up to row6 Not good for your betting.

[GaryRussell]

Originally posted by: soccergeez
Thanks anyway Gaseous, maybe Layit will add a current score box sometime soon!!!!

[GaryRussell]

Originally posted by: The Gambling Monkey
Soccergeez,

From my limited understanding you will probably have to manually enter whether the team are winning or not in a cell say A1.

Then
IF(A1=WIN True use your existing formula

False use your existing formula but referencing the cells where the new prices are

I doubt this helps but I thought I'd try and help.

[GaryRussell]

Originally posted by: soccergeez
Yeah cheers GM all suggestions welcome! I was trying to avoid doing it manually cos if I have to do that I may as well carry on as I am now rather than use Layit's program.

[GaryRussell]

Originally posted by: PillHead
While we are on Excel, can anybody ell me if you can make it beep(or make any sound) if a cell equals a certain value?

Thanks

[GaryRussell]

Originally posted by: The Sound Man
Well done layit.

[GaryRussell]

Originally posted by: Guess
neck and neck with the --------------MEN OF MYSTERY---------- thread 1233 replies each

[GaryRussell]

Originally posted by: sally
LayIt,brilliant. One small request,could there be a more prominent button for cancelling triggered betting and enabling it.If possible maybe from the worksheet

[GaryRussell]

Originally posted by: Gaseous
PillHead - sorry this took so long, was busy trying the new poker site.

Right click on the excel sheet tab and select view code. Paste this in

Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("l5")) Is Nothing Then
Exit Sub
Else

'Call PlaySound("D:\D Drive\GEORGE\Music\music\duel_a.wav", 0)
beep

End If
End Sub


and in a module (ALT + F11, ALT + I, ALT + M) paste this

Declare Function PlaySound Lib "winmm.dll" Alias _
"sndPlaySoundA" (ByVal wavFile As String, _
ByVal lNum As Long) As Long

The code in the sheet will let you hear a beep from the computer If cell I5 changes.
If you want to play a wav file, delete the ' that is infront of the line that will be green and remove the beep. This will let you play a tune or cash register if you have that wav sound.

Hope this is what you were looking for.

George

[GaryRussell]

Originally posted by: Gaseous
LayItYouMug - sorry if i'm taking up too much room on your thread - any thoughts on if we should have another thread? - or is that just going to confuse people looking for help?

PS love the changes you have made. If we can cancel unmatched bets from excel then i'll kiss you. Actually scrub that - i'll buy you a beer instead.

[GaryRussell]

Originally posted by: PillHead
Gaseous

Many thanks for a sound routine.

You obviously excel at excel

Cheers

[GaryRussell]

Originally posted by: shaun T
STOPLOSS trigger

Hi there any one interested in a nifty little stoploss using layits excel progy I have devised, it is suited to IN RUNNING, fires in an order if selection is first in the BF market at user defined values with a nifty macro, contact with info of email etc if interested

Shaun

[GaryRussell]

Originally posted by: mderek
Yes would be very interested. dmartyn at talktalk.net.
It would be better still if Gary could incorporate one of these in the program.

[GaryRussell]

Originally posted by: Alexandru
In Tennis>Mercedes Cup, I can not choose 1. The Final. There is only Winner market available.
Anyone else has this problem?

I tried refresh 20 times.