Oddschecker

[orange]

sent

[osknows]

There is a slight difference between 2003/2007 excel handling of shapes. I've just sent you an update, if you can confirm all is ok with this I'll post up link to latest version

Os

[orange]

email sent

[orange]

That last one is bang on the button.

Thanks for that

[osknows]

Latest version http://www.mediafire.com/file/zgiehjmmh ... hecker.xls

[danjuma]

osknows,

Many many thanks for doing this, you are a top bloke (I assume you are a bloke )

I have just tried it with the horse racing tomorrow and these are my findings (may be it's me doing something wrong):

I followed the instructions on the sheet - selected a market on BA (Wolv 11th Jan-13.30 6f Hcap), linked it to the speadsheet (market 1), clicked "Reset BA worksheets", and then "Reload Selected Markets". Also selected "yes" in column B for the required oddschecker market, in this case the first two - horse racing and football English premier league.

1. Nothing appeared in column H of "Oddschecker Link" sheet.

I then decided to copy and paste the oddschecker link for the market directly in column H (the link I pasted is below):

http://www.oddschecker.com/horse-racing ... win-market.

When I then selected "Yes" in column I for the link, I got a Run-time error '1004', Unable to get the Insert property of the Picture class.

I then clicked 'End' to end and close the run-time error dialogue box. The data from oddschecker (horses names, bookies and odds) got displayed from column BD as it should, but did not update. Probably the sheet stopped working because of the run-time error.

Cheers
Dan

[osknows]

I followed the instructions on the sheet - selected a market on BA (Wolv 11th Jan-13.30 6f Hcap), linked it to the speadsheet (market 1), clicked "Reset BA worksheets", and then "Reload Selected Markets". Also selected "yes" in column B for the required oddschecker market, in this case the first two - horse racing and football English premier league.

1. Nothing appeared in column H of "Oddschecker Link" sheet.

It doen't put the market in automatically, it loads column H with a list of matches and you have to select the market you need from the pulldown. Eg the first market will have a pulldown in cell H5. I tried with the same market and all seems okay here.

http://www.oddschecker.com/horse-racing/2010-01-11-wolverhampton/13:30/win-market.

When I then selected "Yes" in column I for the link, I got a Run-time error '1004', Unable to get the Insert property of the Picture class.

Not sure, I'll need to investigate this. Have you tried the URL without . on the end? What excel version are you using? Do you know which part of the code it fails on?

[osknows]

http://www.oddschecker.com/horse-racing/2010-01-11-wolverhampton/13:30/win-market.

When I then selected "Yes" in column I for the link, I got a Run-time error '1004', Unable to get the Insert property of the Picture class.

I think you may be using Excel 2007 SP1 where this is the problem http://support.microsoft.com/kb/928983/en-us

Can you confirm you are using SP1 (Windows/Excel Options/Resources/about MS Excel 2007)?

Updating to SP2 will solve this but let me know if you still have problems

[danjuma]

It doen't put the market in automatically, it loads column H with a list of matches and you have to select the market you need from the pulldown. Eg the first market will have a pulldown in cell H5. I tried with the same market and all seems okay here.

Ha, ok, it's all become clear now. Ta


I have downloaded and installed the SP2 like you suggested, and I am no longer getting the run-time error. So far, the spreadsheet is working fine, and just to say thanks once more for doing this, it's fantastic!

Just one thing, how often does the spreadsheet refresh the prices? I was comparing the odds displayed on the spreadsheet with the odds on oddschecker. Once I see the spreadsheet refresh and updates the odds, I manually refresh oddschecker site so as to compare the odds. Everytime I have done this, the odds are slightly out (just by a few ticks). For example, oddschecker might be displaying 3.85, 9.5, 24, and the sheet would be displaying 4.1, 10, 25

Cheers
Dan

[osknows]

I'm glad to see it's working now

Each market updates approx every minute. The difference in prices you are seeing are for the exchanges only I think; by default oddschecker adjusts the odds by a percentage commission. Goto the bottom left of oddschecker on Site Settings/Exchange Settings and turn off 'Include commision settings'. The prices should then match.

[danjuma]

I'm glad to see it's working now

Each market updates approx every minute. The difference in prices you are seeing are for the exchanges only I think; by default oddschecker adjusts the odds by a percentage commission. Goto the bottom left of oddschecker on Site Settings/Exchange Settings and turn off 'Include commision settings'. The prices should then match.

Sir,

Thank you very much!!!

Cheers.

[danjuma]

Hi osknows,

If you do have a minute, could you check this out for us again please? Does not seem to be working properly (i.e. not displaying selections and prices from odds checker) both linking manually and using the fuzzy market search.
Many thanks.

[osknows]

Hi Dan,

It looks like they've changed their website since I last did this. I won't get a chance to look at this for a while I'm afraid but if you look at the code in the original file it should have everything you need to be able replicate.

All the best
Os

[danjuma]

Ok, no probs osknows. Thanks.

[danjuma]

osknows,

If you do have the time to have a look at this or advise me as to how to go about amending it, would be much appreciated. Can't figure it out myself, my VBA is not at that level yet. Cheers.