Moderator: 2020vision
by mak » Tue Jul 25, 2017 4:16 pm
by Captain Sensible » Tue Jul 25, 2017 4:41 pm
mak wrote:I am very confused with the coding part since I don't know a lot and can not understand how it works
sometimes it does move to the next market, some times not.
really need a developer here to help me out I think
the problem is that there are some bugs in this version also which makes it very difficult for me
if I place a bet in default profile, the bet manager shows the bets fine
but if open a second profile in the second profile does not showing any bets
this is happening if I place the bet manual or through excel
by alrodopial » Tue Jul 25, 2017 6:26 pm
Dim marketChanging As Boolean, currentMarket As String, triggerInQ2 As Variant
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Columns.Count = 16 Then
Dim BA_Array() As Variant, MyQ2 As Variant
Application.EnableEvents = False
With ThisWorkbook.Sheets(Target.Worksheet.Name)
BA_Array = .Range("A1:BZ55").Value ' this read is probably too much for every update while full stream is on
'If BA_Array(2, 59) <= 520 And Target(2, 6) <> "Closed" Then
'MyQ2 = "FULL-STREAM-ON"
'Else
'MyQ2 = "FULL-STREAM-OFF"
'End If
If Target(2, 5) = "In Play" And Target(2, 6) = "" Then ' is this If statement needed????
MyQ2 = "FULL-STREAM-ON"
' ...........
ElseIf (Target(2, 5) = "In Play" And Target(2, 6) = "Suspended") Or Target(2, 6) = "Closed" Then
If Not marketChanging Then
marketChanging = True
currentMarket = Target(1, 1)
MyQ2 = -1
Else
If Target(1, 1) <> currentMarket Then marketChanging = False
End If
Else
MyQ2 = "FULL-STREAM-OFF"
End If
If triggerInQ2 <> MyQ2 Then
.Range("Q2").Value = MyQ2
triggerInQ2 = MyQ2
End If
' ..........
End With
' ..........
Application.EnableEvents = True
End If
End Sub
by Captain Sensible » Tue Jul 25, 2017 6:34 pm
by mak » Tue Jul 25, 2017 8:38 pm
by mak » Wed Jul 26, 2017 2:07 pm
by KESIMKESIM » Thu Aug 03, 2017 5:49 pm
by Captain Sensible » Thu Aug 03, 2017 5:55 pm
by KESIMKESIM » Thu Aug 03, 2017 8:34 pm
by Captain Sensible » Thu Aug 03, 2017 8:44 pm
by KESIMKESIM » Thu Aug 03, 2017 8:51 pm
by MarkRussell » Fri Aug 04, 2017 10:21 am
KESIMKESIM wrote:I tried both streaming and refreshing at 0.2 secs - same effect. It appears that BA is just buffering the incoming data from BF in some way.
by KESIMKESIM » Fri Aug 04, 2017 11:51 am
by MarkRussell » Fri Aug 04, 2017 12:34 pm
KESIMKESIM wrote:Thanks for getting back to me.
Can I ask, under what circumstances would BF do this? Is it something I'm doing that is causing BF to do this? I can adjust the way I work if its something I'm doing wrong, however back on v34a today, so far everything is fine.
Ian
by Captain Sensible » Fri Aug 04, 2017 3:40 pm
The strength of Gruss Software is that it’s been designed by one of you, a frustrated sports punter, and then developed by listening to dozens of like-minded enthusiasts.
Gruss is owned and run by brothers Gary and Mark Russell. Gary discovered Betfair in 2004 and soon realised that using bespoke software to place bets was much more efficient than merely placing them through the website.
Gary built his own software and then enhanced its features after trialling it through other Betfair users and reacting to their improvement ideas, something that still happens today.
He started making a small monthly charge so he could work on it full-time and then recruited Mark to help develop the products and Gruss Software was born.
We think it’s the best of its kind and so do a lot of our customers. But you can never stand still in this game and we’ll continue to improve the software if any more great ideas emerge.