throttling / refresh rates etc

[Rastis]

Hi Folks,

I've put together an Excel file for trading football. I was trading 10 matches last night with 3 markets per match open - each linked to a separate tab. The file also had 2 summary tabs with some modest conditional triggers. And, yes, it was slow - unworkably slow.

I've previously had 10 x 2 markets open with primative triggers that seemed to run almost in real time.

Thus, I'm after some opinions and advice on what specifically causes the delays, and how to improve the refresh rate.

My questions;

1. Would exceeding Betfairs data request limit help?
2. Would doing so cost me a fortune? Am I right in saying that if the commission generated on profits covers that Data Request Surcharge then there is no charge?
3. Would rationalising my triggers/formulae make much of a difference?
4. Would upgrading my PC or Broadband connection make much of a difference?

Any input would be great.

Cheers

R

[Rastis]

Hello - is there anybody out there

[MarketTrader]

There are plenty of people out here judging by the activity around the forum.

But I expect no one is running a machine as hard as you are.

I have a Quad core, 6GB, Windows 7 64 bit machine and I'm fairly sure it would give a couple of startled squawks and then the frozen look if I tried to do all that.

I think your question might be better asked on a Excel forum or computer geek forum.

But in my opinion:

1 - No
2 - Yes it would cost a fortune. Not sure about the commission part.
3 - Of course
4 - It depends what you are on now. A 2Mb connection should be fine.

[Rastis]

Cheers MT.

An update; I've noticed that the market I am viewing in BA refreshes in real time (in Guardian and Excel) - but the other markets that I have opened in BA Guardian refresh very much slower.

Thus, I am thinking that my issue is at the BA end.

[lotsbg]

i have the same problem, and it seems to be a massive betangel issue of which I cannot find an answer for