Dumb question

[Torino33]

Hello,

I have just downloaded the software and would like to know if i can gather some data from this software-via excel?

I have clicked on the tab - Excel-log current prices but nothing is recording. All i see in my excel is the same thing as i see on the software.

For example, i need the software-excel to capture the odds when the total amount matched on this market reach exactly GBP20000...Is this possible? And how?

The reason is that, as i'm not from UK, usually GBP20000 is reached around 5am(my time), and it's a pain in the a** to wake up at this time

Many thanks for your help!

[GaryRussell]

We do not have a historical data license from Betfair and therefore cannot provide software to record the prices, only monitor the prices for the purpose of triggered betting for example.

[throwmeadisc]

Ok some simple code, I have not put a great deal of thought into it but here goes.

Create a new Workbook and name the first sheet as BA Input.

Next goto the VBA editor (Alt+F11) and double click on the BA Input sheet on the left handside and paste in the following code.

Code: Select all

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Columns.Count <> 16 Then Exit Sub
With Application
    .EnableEvents = False
    .ScreenUpdating = False
End With

Dim SheetName As String

Set ws = ThisWorkbook.Sheets("BA Input")

If ws.Range("B3").Value >= 20000 And ws.Range("AA1").Value <> True Then
    ws.Copy After:=ws
    SheetName = ActiveSheet.Range("A1").Value
    SheetName = Left(SheetName, InStr(1, SheetName, ":") + 2) & "(" & Format(Time, "hh:mm:ss") & ")"
    SheetName = Replace(Replace(SheetName, " ", ""), ":", "-")
    ActiveSheet.Name = SheetName
    ws.Range("AA1").Value = True
End If

Set ws = Nothing

With Application
    .EnableEvents = True
    .ScreenUpdating = True
End With
End Sub

Then connect up Excel to BA Input and when the total matched hits 20000 the sheet will be copied with a time stamp. I have taken out the spaces as there is a 31 character limit on sheet names. Also the Cell AA1 on the BA Input sheet will = TRUE meaning that it has copied the sheet, clear this to set the sheet to copy again.

Hope this helps.

Al

[Torino33]

Hi Al,

Exactly what i was looking for. But it's only for one market. What about if i open multiple race meeting? Can it be done if i call each sheet, BA Input...BA Input1...BA Input2...etc..?

Many thanks!

Note to admin: I think you misunderstood my question. But anyway, you have gained a new customer. I plan to subscribe to the software after my 30days trial.

[GaryRussell]

Sorry, you are right. I saw 'gather some data' and got defensive. We have to be careful, don't want to upset Betfair

Yes you can name them BA Input1, BA Input2, etc., paste the code into each worksheet and change the line that reads as follows to contain the correct worksheet name.

Code: Select all

Set ws = ThisWorkbook.Sheets("BA Input")

You will need to open each market in a new tab page in Betting Assistant and log them to each worksheet.

[throwmeadisc]

Hi Torina,

No worries mate. I'm glad you got it to work. Yeah like I said I didn't put a great deal of thought into it, at least it's a platform to get you started. And like Gary say you can just amend the code to BA Input2, BA Input3 etc... that will do the job.

Hope it goes well and remember me when you hit the big time!

Al

[Torino33]

Hello,

Just a question. Is there a reason why it does not alway work? Sometime, it reach 16000 but the sheet is not copied.

Thanks

[throwmeadisc]

The value is set at 20000.

Al

[Torino33]

Hello All,

I'm requesting your help to create a trigger formula. This may be easy for someone with some experience with excel.

What i need is something that trigger a back bet for my specific selection @ SP

A lay bet in running to take profit when the odd steam to 50% (including winner) ie: a lay bet 1.5 times my original stake.

And also include a stop loss of 0.50 pts. Ex: back odd 3.00...stoploss 6.00
but the stoploss must read the back odd and take the price on the lay odd.

Hope you understand my explanation.

Thanks a lot!