Gruss Forum • View topic - One click trading

by **GaryRussell** » Sat Jul 23, 2005 1:10 pm

Originally posted by: LayItYouMug
soccergeez. Are you using it correctly? For each separate market you must select a different worksheet. eg. for the 1st market select 'Sheet1' from the drop down list (this is the default selection) and for the 2nd market you select 'Sheet2' from the drop down list. Separate markets cannot be logged to the same worksheet.

by **GaryRussell** » Sat Jul 23, 2005 1:10 pm

Originally posted by: The Owls are Going Up
Layityoumug

Did you receive my email

Haviton

by **GaryRussell** » Sat Jul 23, 2005 1:14 pm

Originally posted by: LayItYouMug
Haviton. Just replied.

by **GaryRussell** » Sat Jul 23, 2005 1:19 pm

Originally posted by: LayItYouMug
You may have noticed. An 'In Play' indicator is logged to the worksheet next to the update time. You could use this in your formulas to place a bet only when the market is in play. I tested it earlier on a South African race laying the field at 1.01 when the market was in play. To my surprise I won £10, my first 1.01 loser

by **GaryRussell** » Sat Jul 23, 2005 1:21 pm

Originally posted by: soccergeez
Thanks for all your help GM & Layit, I gotta g out now but Ill try it again later on, cheers

by **GaryRussell** » Sat Jul 23, 2005 1:59 pm

Originally posted by: soccergeez
ok, how do I get the prices onto a sheet other than the default one without un ticking and then ticking again the log current prices box - which makes the clock stop?

by **GaryRussell** » Sat Jul 23, 2005 2:13 pm

Originally posted by: LayItYouMug
soccergeez. Sounds like you are not opening the separate markets on separate tab pages. Are you clicking on 'New page' and then selecting the new tab page. Each tab page works independently and can log to Excel independently.

by **GaryRussell** » Sat Jul 23, 2005 3:06 pm

Originally posted by: soccergeez
Thanks Layit, sorry Im so slow with this sort of thing

by **GaryRussell** » Sat Jul 23, 2005 3:59 pm

Originally posted by: Gaseous
lol - looks like this thread is going to get even busier with all the excel queries that are coming up.

I had the same problem as soccergeez re looking at more than 1 market in excel at the same time. Took a while to figure out that the software had to be looking at 2 markets if i wanted to get the data from 2.

I think all the queries were answered, but if not i should be around for a while longer (try to keep my answers as short as possible).

George

by **GaryRussell** » Sat Jul 23, 2005 6:16 pm

Originally posted by: The Gambling Monkey
Attn. Gaseous
George are you around?

I've been trying to adapt your macro but I've gone crazy trying.
Basically what I am trying to get it to do is as follows:

Using LayItYouMug's Betting Assistant I log the prices to Excel but put the top left cell as B1 leaving column A clear.

At 13:30 the average price (at that instant) for each horse, dictated by the formula ((Lay Odds1-Back Odds1) / 2) + Back Odds1, is put in Column A for each Row

So if at 13:30 Horse A (in Row 5) is: Back Odds 3.1 and Lay Odds 3.2 then 3.15 is entered in Cell A5.

I'm getting to grips with functions but Macros are doing my head in!! lol

Cheers

by **GaryRussell** » Sat Jul 23, 2005 6:46 pm

Originally posted by: Gaseous
i'll have a look for you. - just to let you know i'm around

by **GaryRussell** » Sat Jul 23, 2005 6:52 pm

Originally posted by: soccergeez
On my chart I use one set of match odds when the game is level and a different set if either team is leading, can anyone think of a formula that will enable layits program to use the correct set of match odds depending on the score without me having to do it manually?

by **GaryRussell** » Sat Jul 23, 2005 6:56 pm

Originally posted by: The Gambling Monkey
Cheers George

Soccergeez a bit more detail if you please.

by **GaryRussell** » Sat Jul 23, 2005 7:05 pm

Originally posted by: soccergeez
Ok. I have prices for home, draw, away set up on a spreadsheet and want Layit's program to place a bet when the available odds are bigger than my calculated ones which Ithink I now know how to do.
When either side is winning the game I need Layit's program to compare the current available odds on Betfair to a different set of home, draw, away prices which I also have on the sheet and ignore the original home, draw, away prices.

by **GaryRussell** » Sat Jul 23, 2005 7:11 pm

Originally posted by: Gaseous
Hey Monkey man, this should do it.

Sub split()
If Range("D2") < Range("A3") Then Application.OnTime Now() + TimeValue("00:00:01"), "split"
If Range("D2") >= Range("A3") 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("I" & i))
Next i
End If
End Sub

One click trading - free program coming soon

Who is online

Sports betting software from Gruss Software