No New Markets every Monday using Gruss with Excel

[Kelpiemedia]

Hi,

I have been using Gruss for around 6 months now with an excel sheet driving my strategy. Recently (in the last month or so) I have noticed that every Monday, without fail, the spreadsheet fails to place any bets via Gruss despite there being plenty of markets within my strategy. Indeed bets were placed on the sunday up until midnight.

Is this something that others experience?
Is this an issue with Gruss?
Is this an issue with Betfair, does it have system maintenance or such like at this time?

My Developer and I have reviewed the VB behind the spreadsheet and it works fine, it just doesn't want to place any bets for around 12 hours on a Monday.

It's driving us daft... any help or advice greatly appreciated.

Best Wishes

Stephen

[Captain Sensible]

I have bots running on the AUS stuff and they plod thru the market fine.

When you say "there being plenty of markets within my strategy" are those markets actually loaded? Does your sheet log any bets it places or are the opportunities just not showing up for those 12 hours.

[Kelpiemedia]

Hi,

The log on the excel sheet simply says that the market "failed to load". We have come to the conclusion that it is not the criteria within my strategy as it can be too much of a coincidence that it has happened every Monday for the last 5 weeks.

I appreciate the "failed to load", is our term for our log, but gruss is cycling through, the excel sheet is registering the cycle, it's just not placing any bets despite there being many markets within the criteria set.

As I say this happens every Monday and bets were placed yesterday, and will be again tomorrow I don't doubt. It's just frustrating to be losing the ability to place bets for 24 hours once per week.

We are 95% certain it is not the excel sheet (as mentioned it places bets to my criteria every other day of the week without changing or tweaking it), so it must be Gruss or Betfair. If others were experiencing this it would make it easier to determine which.

Markets I place bets on are Tennis, American Football, basketball, baseball, icehockey, darts, soccer, rugby, snooker and cricket. I don't use the Australian exchange.

All the best

Stephen

[Captain Sensible]

Does your bot resume after that 12 hour period or do you need to manually restart it?

Do the new markets actually populate into the quick pick list just the market "failed to load". I've had markets fail to load before but always down to a VBA error for me.

Have you also looked at the markets it's failing to load on and the times it occurs, If your program is reloading the market list after 12:00am it'll usually load a lot of completed markets especially on a sunday night when the markets aren't cleared as quickly as usual. MIght be worth looking at any time based code or code you use to deal with completed and settled markets