the volume match for each price in the ladder in excel

Discuss anything related to using the program (eg. triggered betting tactics)

Moderator: 2020vision

the volume match for each price in the ladder in excel

Postby treehead » Tue Jan 08, 2013 5:53 pm

can I obtain the individual matched volume that is down the side of the ladder to put into excel using getallvolume COM?

Im looking for the highest traded and the lowest traded price for each runner, pre-start to embed in my excel sheet...
any ideas please?
thanks
treehead
 
Posts: 18
Joined: Mon Dec 18, 2006 10:40 am

Postby GaryRussell » Wed Jan 09, 2013 3:12 pm

Here is an example using the getAllTradedVolume() COM function.

http://gruss-software.co.uk/forum/viewtopic.php?t=3726
User avatar
GaryRussell
Site Admin
 
Posts: 9679
Joined: Fri Nov 18, 2005 8:09 pm
Location: Birmingham, UK

Postby treehead » Wed Jan 09, 2013 3:33 pm

Thanks for the promp reply Gary.
I've been looking at the getAllTradedVolume example. Can I just clarify a few things please?

First off, I have the COM function all set up and working on my machine.
I have been using excel and VB for a while now and can re-edit sample code to use with success.. but Im no expert.

In the sample on sheet1 in DK6:EP6, is that the price and volume matched for 'secret night' in A6?

And if so which part of the code is generating this?




I cant find anything written down to guide me

Code: Select all
Option Explicit

Dim ba As BettingAssistantCom.ComClass

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Columns.Count = 16 Then
        Application.EnableEvents = False
        If ba Is Nothing Then
            Set ba = New BettingAssistantCom.ComClass
        End If
        Dim tradedVol As Variant, tradedVols As Variant
        Dim totalTraded As Double, totalProfit As Double
        tradedVol = ba.getAllTradedVolume
        If Not IsEmpty(tradedVol) Then
            Dim i As Integer, r As Integer, selecName As String, j As Integer
            r = 5
            Do
                selecName = Cells(r, 1).Value
                If selecName <> "" Then
                    For i = 0 To UBound(tradedVol)
                        If tradedVol(i).Selection = selecName Then
                            Cells(r, 26).Value = tradedVol(i).actualBsp
                            Cells(r, 27).Value = tradedVol(i).totalBspBackMatchedAmount
                            Cells(r, 28).Value = tradedVol(i).totalBspLiabilityMatchedAmount
                            tradedVols = tradedVol(i).tradedVolumes
                            totalTraded = 0
                            totalProfit = 0
                            For j = 0 To UBound(tradedVols)
                                 If tradedVols(j).totalMatchedAmount <> 0 Then
                                    totalTraded = totalTraded + tradedVols(j).totalMatchedAmount
                                    totalProfit = totalProfit + (tradedVols(j).odds - 1) * tradedVols(j).totalMatchedAmount
                                 End If
                                 If tradedVols(j).odds = Cells(r, 15).Value Then
                                    Cells(r, 25).Value = tradedVols(j).totalMatchedAmount
                                 End If
                            Next
                            Cells(r, 29).Value = Round((totalProfit / totalTraded) + 1, 2)
                            Exit For
                        End If
                    Next
                End If
                r = r + 1
            Loop Until selecName = ""
        End If
        Application.EnableEvents = True
    End If
End Sub



In the end Im just trying to get the lowest and highest price matched pre-off for each runner into my sheet... Ive been on this for months thanks

I hope you understand my query


regards

herbie

Edited by 2020vision to make clean view - hope you don't mind?
treehead
 
Posts: 18
Joined: Mon Dec 18, 2006 10:40 am

Re: the volume match for each price in the ladder in excel

Postby watso12 » Sat Nov 13, 2021 6:51 pm

anyone know how to get matched volume that is down the side of the ladder to put into excel yet?
Myself have been trying for months, but still nothing.
Any help would be great
watso12
 
Posts: 16
Joined: Mon Apr 05, 2021 7:36 pm


Return to Discussion

Who is online

Users browsing this forum: No registered users and 8 guests

Sports betting software from Gruss Software


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.