Oddschecker

[lindemann]

Dan,

I used the sheet again at lunchtime and although I got some instances of strange behaviour like you describe, it did eventually settle down and work. I won't be able to do any more until tomorrow but in case it helps the "improved" sheet I'm using is here:

http://www.mediafire.com/file/knwhbkvmk ... orking.xls

[danjuma]

Dan,

I used the sheet again at lunchtime and although I got some instances of strange behaviour like you describe, it did eventually settle down and work. I won't be able to do any more until tomorrow but in case it helps the "improved" sheet I'm using is here:

http://www.mediafire.com/file/knwhbkvmk ... orking.xls

Ok thanks lindemann,

Will give your sheet a try tomorrow. Ta

[lindemann]

Sod's Law innit!! After racing I hooked up the latest version of my sheet and absolutely nothing happened. I couldn't get it to refresh from OC no matter what I tried. I'll try again tomorrow.

[Ian]

I find there is now a duplicate sheet in the VB project window (if you know what I mean). I then now have to use BA to kill all excel processes to clear this and reopen sheet.

Dan, this happens to me all the time if I close down a workbook whilst it is linked to BA. It is immediately re-opened in a hidden window. There's another thread about this where someone else reported it.

[lindemann]

I'm up and running again this morning but with some strange behaviour from Excel occasionally.

The spreadsheet I did yesterday doesn't work today because Excel won't convert OC data to numbers, it's overwritten with text on every refresh. I'll have to redesign this bit of my sheet. Also Naas isn't on the list of courses and needs to be added.

Otherwise, it's working fine and downloading from OC every minute just like it says on the tin. Strange behaviour from Excel:

I first coupled to BA with Excel window minimised and it wouldn't open up for a couple of minutes, I'm thinking this is some kind of "initialisation" period when everything's busy.
In general, my system is a bit sluggish when this is running. The Task Manager performance window shows CPU usage at 100% for about 20 - 25 secs and 30% or so for the rest of the time.
BA markets sometimes take about 10secs to change but mostly they're normal and change instantly.
Finally, the second race at Bath has two sets of market data going right across to Column CN. I think this originates from OC and I think there are perhaps other OC issues that can cause strange behaviour in Excel. As long as these issues happen from cell BA1 onwards, other parts of the sheet aren't affected and the basic functions continue as normal.

Personally, I would use this sheet for an hour or so to assess markets before racing starts. I wouldn't run anything else and from that point of view the sheet is usable and gets round the problems presented by OC.

Hope this helps.

[osknows]

I've amended things slightly, can you see if this is any better?

http://www.mediafire.com/?16jt12ll85ayiva

[osknows]

Also, if anyone knows how to run javascript within VBA without opening a browser can you PM me please. If it's possible then I could make this run much quicker

[lindemann]

Os,

As soon as I open the latest version I'm getting: "Compile error: Expected sub or function" and the debugger is highlighting the first instance of PtrSafe in line 4 of the module code.

The other version is still working for me albeit a bit clunky and weird at times.

[osknows]

Delete all instances of "PtrSafe" it's required for Excel 2010 but should be removed from earlier versions.

[lindemann]

Working OK. I've run it on Excel 2003 and 2007 and it can clunk and freeze in both systems but once it's working it pretty much behaves itself....so far.

[danjuma]

Hi OS,

Just tried the new spreadsheet and my findings below:

1. This time it worked without me having to open IE first.
2. Linked the first market, and it updated both odds, OC and BA. Then manually selected next market on BA, the odds on the sheet got updated once or so for BA and OC, and then froze. Then tried to select next market on BA, and BA froze at the "Market Loading" stage.
3. The 'stall' column (column BB) is displaying the following instead - <A href=". I am not too bothered about this as it is not information I require anyway.
4. Finally, the now usual thing of a duplicate sheet appearing in the VBA editor when you close the spreadsheet after freezing and reopening it.

Cheers, and thanks for all your hard work!!!

Just a question if you do not mind, how is this sheet different from the the one before it that was working excellently (for me anyway) until OC decided to change something on their website? Is it not possible to amend that sheet to work again?

Dan

[Ian]

Dan, are you using the formula I suggested for working out the OC Url or are you copying and pasting it into worksheet ? I'm just wondering if it is the formula that is causing the problem with freezing because, as you know, my bestbetting workbook suffers from the same problem. What I have found is that if I leave the workbook when it is shown as not responding, after a couple of minutes it actually starts working again.

[osknows]

I've come up with a completely different way of doing this now. This version first navigates to oddschecker and amends the cookie to include the required settings. Hopefully this should work much quicker than opening and instance of IE

http://www.mediafire.com/?r2gx2iidsd873d2

Dan - the main differences are that OC have changed some of the identifying tags in their pages, also only the data based on the settings are sent rather than previously where all odds types were in the source code.

[danjuma]

I've come up with a completely different way of doing this now. This version first navigates to oddschecker and amends the cookie to include the required settings. Hopefully this should work much quicker than opening and instance of IE

http://www.mediafire.com/?b2c8skcxazdv8bb

Dan - the main differences are that OC have changed some of the identifying tags in their pages, also only the data based on the settings are sent rather than previously where all odds types were in the source code.

Os,

Download link coming up invalid link! May be you have temporarily deleted it to amend something, will try again in a few minutes. Cheers

[danjuma]

Dan, are you using the formula I suggested for working out the OC Url or are you copying and pasting it into worksheet ? I'm just wondering if it is the formula that is causing the problem with freezing because, as you know, my bestbetting workbook suffers from the same problem. What I have found is that if I leave the workbook when it is shown as not responding, after a couple of minutes it actually starts working again.

Yes Ian, I am using your formula for working out the OC url in cell BA1, which worked fine with the previous sheet. Cheers