Gruss Forum • View topic

by **NorthView** » Wed Mar 25, 2009 7:10 pm

Thanks Gary, I was doing something daft - testing it by using USA races. :roll:

It seems to be working perfectly - much appreciated.

by **danjuma** » Sun May 03, 2009 10:51 pm

GaryRussell wrote:I had some code knocking around for capturing the live show from sportinglife.com so I have adapted it for use in Excel

You can download the example from http://www.gruss-software.co.uk/Excel/S ... _Shows.xls

It provides a custom function named getLiveShow which you can see used in column Y

I know it's not the bookies live prices as requested, but I had the code already so it wasn't too much effort and i've been meaning to upload this example for a while. I will still provide something for capturing the bookies live prices.

Gary, just wondered whether you could modify the sheet ".../Sporting_Life_Live_Shows.xls" to capture the odds in different cells as they change? This is so that one could compare the different odds to identify a price that's been consistenly shortening / drifting. Alternatively, you could provide a formula or macro that could do this.
I appreciate you are a very busy man, so if you do not have the time to oblige, I understand.

Cheers
Dan

by **NorthView** » Mon May 04, 2009 6:31 pm

I frequently have problems getting Ladbrokes prices for some UK meetings using this method: the Ladbrokes website shows the prices as normal, but the VBA function returns zeroes.

It seems to be random meetings that are affected on random days. Do you have any ideas what could be causing this, Gary, or where I should start looking?

by **Ian** » Mon May 04, 2009 9:00 pm

I think the problem occurs when there are two races timed the same. Often Ladbrokes have the the race from France, Germany or wherever first on the screen, where the individual race URLS are picked up from.

by **NorthView** » Mon May 04, 2009 9:08 pm

Thanks Ian, that sounds plausible. I'll check it out.

by **manager1** » Fri May 08, 2009 3:26 am

Yes, I can't get Ladbrokes prices anymore either, all return 0's.

by **danjuma** » Wed May 13, 2009 4:49 pm

danjuma wrote:
GaryRussell wrote:I had some code knocking around for capturing the live show from sportinglife.com so I have adapted it for use in Excel

You can download the example from http://www.gruss-software.co.uk/Excel/S ... _Shows.xls

It provides a custom function named getLiveShow which you can see used in column Y

I know it's not the bookies live prices as requested, but I had the code already so it wasn't too much effort and i've been meaning to upload this example for a while. I will still provide something for capturing the bookies live prices.

Gary, just wondered whether you could modify the sheet ".../Sporting_Life_Live_Shows.xls" to capture the odds in different cells as they change? This is so that one could compare the different odds to identify a price that's been consistenly shortening / drifting. Alternatively, you could provide a formula or macro that could do this.
I appreciate you are a very busy man, so if you do not have the time to oblige, I understand.

Cheers
Dan

Gary, just wondered whether you gave any thought to my request above? Cheers
Dan

by **GaryRussell** » Wed May 13, 2009 4:56 pm

You can do it without me having to change the code. You could create some general purpose code to capture any cell that changes over time. I'll try and do an example for you tomorrow.

by **danjuma** » Wed May 13, 2009 7:55 pm

Many thanks Gary, much appreciated, look forward to it.

by **danjuma** » Tue May 19, 2009 3:46 pm

GaryRussell wrote:You can do it without me having to change the code. You could create some general purpose code to capture any cell that changes over time. I'll try and do an example for you tomorrow.

Any joy with this Gary?

Cheers
Dan

by **GaryRussell** » Tue May 19, 2009 4:07 pm

I'm working on it at the moment. I'll post something later.

by **danjuma** » Tue May 19, 2009 4:41 pm

Thanks

by **GaryRussell** » Tue May 19, 2009 4:43 pm

Here is an example of how it can be done.

http://www.gruss-software.co.uk/Excel/S ... istory.xls

The earliest show will be logged in column Z then when they change they will be logged in column AA, AB, etc.

by **danjuma** » Wed May 20, 2009 11:33 pm

Gary, what can I say! Yet again, you have come to the rescue of we mere mortals. You are indispensable, and may you be around for a very long time.

Cheers.

by **borti16** » Wed May 26, 2010 5:13 pm

GaryRussell wrote:Here is an example of how it can be done.

http://www.gruss-software.co.uk/Excel/S ... istory.xls

The earliest show will be logged in column Z then when they change they will be logged in column AA, AB, etc.

Hi Gary:

Thx for the spreadsheet.
I have small problems with it, which makes it not useful for me.
Whenever the Sportinglife Website changes the odds i get a flip of the odds in the history
Example, Sportinglife changes the odds from 5,5 to 6
My Spreadsheet looks like this beginning in the colum Y
5,5 ; 6 ; 5,5 ; 6 ; 5,5 ; 6 ;
Any idea why this happens?
Sometimes there are also a few zeros between the odds.
I would really appreciate if you can help me to fix this spreadsheet.

Get Tissue Prices

Who is online

Sports betting software from Gruss Software