Issues at start with SUSPENDED using multiple spreadsheet

Discussion regarding the spreadsheet functionality of Bet Angel.
Post Reply
User avatar
SteveJeffrey
Posts: 3
Joined: Wed Apr 15, 2009 11:52 pm

Hi All,

Have any of you had issues trading football with the multiple spreadsheet going suspended before the start of a match?.

I've been using it a bit this weekend, and thought that I could set my events pre KO, then let it run. However, as soon as the match kicks off, the Market goes SUSPENDED, then INPLAY, and the STATUS field is stuck with MARKET_SUSPENDED, meaning I have to be there to remove it and allow my bets to become active.

This has happened a number of times, and means that I either need to be there at the start of every event, or write some conditional VBA to get around the problem.

Any similar experiences or suggestions as to how to circumvent?

-Steve
jopearse
Posts: 1
Joined: Wed May 06, 2009 8:57 pm

Hi All,

I have found similar problems when using the Excel spreadsheet, often switches to market suspended, likewise no idea how to overcome this problem...

Any thoughts much appreciated...

Cheers,

Jo
nigelk
Posts: 469
Joined: Wed Apr 15, 2009 11:00 pm

Hi Guys.

Not sure what cell the "MARKET_SUSPENDED" appears in, but something along these lines should help (change A1 to whatever value you need).

This code needs to go into the individual sheet, NOT a module.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Range("a1") = "MARKET_SUSPENDED" Then
Range("a1").ClearContents
End If
End Sub


If you want the same effect over several sheets, you'll have to put it in "This Workbook"

Any problems, get back, I'll try to help.
Nigel.
Post Reply

Return to “Bet Angel - Spreadsheet / Excel chat”