Help with optimising Guardian/Excel Refresh Rate

[EyePeaSea]

Hi All,

At the moment, I'm checking/firing trades at races from 2h before the start, so Guardian 'Restrict Refresh' is set to 7260 seconds and 60 seconds.

With the BetFair Streaming, Guardian/Excel is refreshing much quicker than previously, although on very busy days, there'll be about 30 races being updated and so it may take 2 or 3 seconds to refresh each sheet.

BetDaq, with a slower refresh rate is really struggling, and I'm convinced that's why I'm getting duplicate trades.

I've run BetDaq with no code in the 'Worksheet_Change' subs and that makes no discernible difference to the speed of update, so I'm fairly sure my code isn't making a significant difference.

So - how to optimise Guardian? I occasionally check a race out in BA itself, but most of the time, it's just Guardian.

Apart from 'Refresh Interval' and 'Restrict Refresh', most of the settings are in BA. Which one of those will affect refresh of Guardian?

So, looking at BA for BD - can anyone help with my understanding of the following please?

Matched & Unmatched Bets - I've set this to '10 seconds' as I'm not worried about having Excel updated immediately on this.

Full market depth - Set to 1 minute, but I think this has no effect on Guardian?

Traded volume - Set to 1 minute, might have an effect on Guardian, but I'm not worried about these stats being updated really quickly.

Ladder settings - I leave these at default, as I assume they don't have any effect on Guardian.

Any help would be greatly appreciated.

Thanks


Ian

[karnage]

hi
Do you have a lot of formulas in your spreadsheet? and what version of Excel are you using? and finally, what CPU does your computer have?

[workpeter]

Performance is very important for me too and i also had 3 second update speed with or without my personal code. I needed millisecond refresh rate.

I solved it by limiting the restrict refresh to 30 minutes in guardian advanced settings.

I still am able to capture all races in a day, because i use the multiple sheet spreadsheet with 40 tabs. Once the 30min hits, a new tab is auto grabbed by guardian and starts to populate. So at the end of the day, all tabs are full of data for different races.

Anything more than 30 min starts introducing a delay due to guardian looking at too many races at the same time.

[EyePeaSea]

Hi Karnage,

My trading PC (It's only used for trading, not 'normal' stuff) is a Xeon, 8 core @ 3.5Ghz. Excel 2016. Very few background services and I've tested with/without AV running.

There are no Formulas in the Spreadsheet, and I use EnableEvents = True/False to stop BA from updating sheets whilst I'm processing.

I can reliably get it to double bet (about 25% of the time) on BetDaq when I have more than 6 or 7 sheets being updated at the same time.

BetFair used to have the same problem, but now with streaming that's 100% ok.

I have a work-around - the same as WorkPeter, so that's ok, just not ideal.

Thanks

Ian

[EyePeaSea]

I solved it by limiting the restrict refresh to 30 minutes in guardian advanced settings.

Hi Peter,

Thanks for the suggestion and that's what I'm doing as well. For BetDaq, I'm making bets up to 60 minutes before the start and am now skipping some markets so that there are never more than 5 races active at any one moment. Quieter days like today, I've only had to skip two races, but on Saturday, I had to miss quite a few.

It's been fine like this for 8 days, but I'll give it another few days and then increase the number of races that can be active. Keep doing that until I find the point where it starts to double bet again.

I'm pretty certain that this a BA problem, but as it only affects BD, I'm not that bothered and it is free software, so I'm not going to moan.

But... a "Don't bet for another X seconds" or even better (for me) "Don't bet more than X times on a horse" option would fix it

Ian

[workpeter]

Oh you got a double bet problem. Check out my solution:
https://www.betangel.com/forum/viewtopi ... 37#p113337