Volunteers to test new version required

[GaryRussell]

I think I have also had the problem osknows mentions, occasionally when switching from ladder to grid, the grid interface would just be a thin column on the left of the screen. Going to a new market and back again would correct it.

Also, after about an hour and a half today (3:30pm) the jockey silks were not loading in the ladder interface. If I selected a new horse on each column then it would load the silks. Maybe this was a general problem at this busy time?

Not sure what happened with the jockey silks, but if that problem or the problem with the grid not displaying correctly occurs can you send the log file as described in the previous post.

I think your problem with the grid not displaying is different from osknows' problem so the log file would be a great help.

[greenfingers]

I've e-mailed you the files, Gary.

One other small change I've noticed is that the horse info doesn't seem to stay visible as long as it used to (when you hover the cursor over)?

[GaryRussell]

One other small change I've noticed is that the horse info doesn't seem to stay visible as long as it used to (when you hover the cursor over)?

Yes, you're right. I will fix this.

[greenfingers]

The silks problem and the grid problem are both solved in the latest version. Fantastic support, many thanks Gary.

[greenfingers]

I've just noticed that I have 1,200 excess refresh requests! I know I should have the throttle on but I've never incurred charges (until now!). Are the betfair graphs being refreshed at the market refresh rate like in older versions of the software until you made it more efficient? Even with one graph open the refresh requests are averaging 5 per second at a refresh rate of 0.5

[GaryRussell]

No, the graphs are refreshed every 10 seconds.

At every refresh interval it makes 4 requests. So at 0.5 seconds there are up to 8 requests per second.

1) Prices.
2) Bets
3) Traded volume
4) Market depth

Is there a reason why you don't want to enable throttling?

[greenfingers]

Ok, sorry for casting aspersions! The refresh requests do seem to go up noticeably when there is a graph open, although that didn't cause my excess requests.

I accidentally had 2 of the 3 tabs I had open at a different refresh rate to the first as I was working on a new spreadsheet.

I stopped using the throttle because I realised that with the commission I'm paying I didn't need it! As I've been having a lumpy internet connection I'd rather have an occasional excess of requests than miss getting up to date info. I don't know whether it also throttles the placement of bets if you happen to enter an order at a time where your requests are already at 20?

Cheers.

[dax]

Maybe I have found a bug on Windows 7 32 bit.

I have standard ladder interface set, when open a market tab the first time that switch from ladder to grid interface grid appear corrupted and collapsed at the left side, then if switch in ladder and re-switch in grid, the second time grid open correctly. this bug appears only the first switch ladder>grid

Maybe depend on precedent setting version W not deleted that cause conflict (?)

[GaryRussell]

I'm not sure it's a conflict with the previous version. I am investigating.

[GaryRussell]

I have fixed the grid bug. Please uninstall and re-install.

[xraymitch]

7) When displaying the same market on separate tab pages it will now use the same price and bet refresh requests from the first tab displaying the market instead of making new requests. This reduces bandwidth and is useful for Excel users who want to run separate triggers on the same market from separate tabs. It only works if each tab has the same refresh rate.

Gary, for the last month or so I have been working on a new project so I am wary of using a different version.

My project allows for the possibility of 10 Meetings and 8 Races per Meeting, thus making a total of 80 pages opened from early morning onwards. I am not sure if Excel 2007 can handle it despite having a very high spec dedicated PC.


So far I have tested with a max of 24 pages and whilst there is a slowdown in refreshes of about 5 seconds per page it has not crashed over a 12 hour period.

Will update 7 help if I have as many as 80 pages loaded in BA ?

Your comments appreciated as always.

Thanks,

Ray


PS Is there a trigger that could switch of logging a sheet once the market has closed ?

[GaryRussell]

Update 7 only helps if you are refreshing the same market on two or more tabs and at the same refresh rate. It sounds like all your markets are unique so it won't make any difference.

There isn't currently a trigger to stop logging a sheet after the market has closed. A closed market does not make API requests though and you can set the refresh rate in cell Q2 to 999 which means it will only update Excel every 16 minutes.

[xraymitch]

Update 7 only helps if you are refreshing the same market on two or more tabs and at the same refresh rate. It sounds like all your markets are unique so it won't make any difference.

There isn't currently a trigger to stop logging a sheet after the market has closed. A closed market does not make API requests though and you can set the refresh rate in cell Q2 to 999 which means it will only update Excel every 16 minutes.

Thanks Gary,

That is a useful piece of information re the closed market not making API requests. I assumed that because the time elapsed was still showing it was still making requests.

Basically I am looking to find as many ways as possible to cut down on the CPU overhead within EXCEL as I am not confident that BA with 80 Tabs/Pages linked to 10 Excel Workbooks and 8 Sheets per Workbook can cope.

Much obliged for your super fast response.

Ray

PS Something I have always come across with Microsoft over the last 30 years or so is that when you do things with their progs on what I call an "industrial level" they just let you down...

[kiint]

Hi,

Noticed a wee problem this morning. I had the same market open in two tabs. I turned off auto refresh on the first tab and it also stopped the second tab from refreshing as well even though the box was checked.

Apart from that, all seems good.

Cheers,
Kiint

[GaryRussell]

Hi,

Noticed a wee problem this morning. I had the same market open in two tabs. I turned off auto refresh on the first tab and it also stopped the second tab from refreshing as well even though the box was checked.

Apart from that, all seems good.

Cheers,
Kiint

It's because both tabs share the same requests. I didn't think of this scenario. I will fix it.