data usage

[Dmite036]

Just a quick one. I'm slightly concerned about exceeding my internet data limit using gruss for triggered betting in excel.

I'm only loading markets a minute before the off (auto market load) and my refresh rate is 10 seconds.

I was wondering if BA still refreshes even thought it might be 'between' races where there could be a 5-10+ minute gap depending where you are betting.

I have a monthly 20gig limit.

[GaryRussell]

Yes it does, but you can control the refresh rate from Excel.

Enter the required refresh rate in cell Q2. You could have a formula or macro change the refresh rate between races.

[Dmite036]

Thanks.

I've been searching for another answer but i'm a bit lost.

What do i type in to Q2 if i only want refreshes to occur 1 minute before my quick list races, then cease once those have ended?

I basically only need refreshes when my selected races are about to start. Everything in between is a waste.

[GaryRussell]

There isn't an option to stop refreshing altogether. You must specify a refresh rate. The best you can do is reduce the number of refreshes. You also have to consider that the refresh rate is only checked on each refresh so if you specify a rate that is too long you could miss the start of the race altogether.

I'll put it down as a suggestion to have the option to only refresh prices a certain number of minutes before a race. This will benefit the API in general as it will reduce the load on the server.

[Dmite036]

Thank you Gary that would be a worthy inclusion for my methods.