***** excel triggered betting making a simple bot

[1/4 of a millionaire fund]

You need to look at it logically, I used to have a sheet that sent bets with a fill/kill and just monitored the profit/loss column to decide which bet to place.

If the pnl column was >=0 no bets had been placed so it'd fire of a lay with fill/kill and offsets attached. If the bet was unmatched and fill/kill came into place the column showed as cancelled so an if statement would send in a clear request so further bets could be submitted. If the column was showing a negative figure a bet had been matched and the offset would take care of that, if that was matched the pnl column would now show as >=0 allowing further bets to be placed.

The reason I mentioned Garys sheet is that if you're trading more than one runner that pnl column isn't reliable whereas Garys coding will show you the current situtation for bets placed on each runner individually so you can see if they've generated a profit so you can then send extra bets, you can use your vlookup to look solely for unmatched bets on that runner to avoid placing further bets until that unmatched bet has either been cancelled by fill/kill or matched in which case it would send an unmatched offset which would prevent further bets being placed.

Not too sure why you needed to look for filled bets rather than unmatched bets.

[Timstertoo]

You need to look at it logically, I used to have a sheet that sent bets with a fill/kill and just monitored the profit/loss column to decide which bet to place.

If the pnl column was >=0 no bets had been placed so it'd fire of a lay with fill/kill and offsets attached. If the bet was unmatched and fill/kill came into place the column showed as cancelled so an if statement would send in a clear request so further bets could be submitted. If the column was showing a negative figure a bet had been matched and the offset would take care of that, if that was matched the pnl column would now show as >=0 allowing further bets to be placed.

The reason I mentioned Garys sheet is that if you're trading more than one runner that pnl column isn't reliable whereas Garys coding will show you the current situtation for bets placed on each runner individually so you can see if they've generated a profit so you can then send extra bets, you can use your vlookup to look solely for unmatched bets on that runner to avoid placing further bets until that unmatched bet has either been cancelled by fill/kill or matched in which case it would send an unmatched offset which would prevent further bets being placed.

Not too sure why you needed to look for filled bets rather than unmatched bets.

This makes sense, will give it a shot when I get home tonight.:Thumbs

[Bumble]

Thank you for this, very informative. I can see how to (having got the data) the excel formluae and VB will get some optimal pricing. Sorry, I'm a real newbie. Only discovered The Toy a few days ago (having stayed away from horses for a few years due to dismal failures with a system involving upping stakes until I won.. or lost eveything). Anyway, less of that, this trading makes a lot more sense. I'm learning.

Two questions:
1. What is a *****? I seem to need it to get the data.
2. Having calculated an optimal bet, can I automate placing it? Or is the idea that I use the bot to bring up fast information on the screen and use The Geeks Toy to place the bet?

[Timstertoo]

Thank you for this, very informative. I can see how to (having got the data) the excel formluae and VB will get some optimal pricing. Sorry, I'm a real newbie. Only discovered The Toy a few days ago (having stayed away from horses for a few years due to dismal failures with a system involving upping stakes until I won.. or lost eveything). Anyway, less of that, this trading makes a lot more sense. I'm learning.

Two questions:
1. What is a *****? I seem to need it to get the data.
2. Having calculated an optimal bet, can I automate placing it? Or is the idea that I use the bot to bring up fast information on the screen and use The Geeks Toy to place the bet?

Hi Bumble,

Welcome to the forum!

The bot betting described in this thread is done through ***** Betting Assistant which can be found here:

http://www.*****1-software.co.uk/

There is a 30 day trial I think, might be shorter but there is a trial. After that it is 6 English pounds a month so friendly pricing.

***** is a comparable product as GeeksToy with the difference that ***** will let you automate betting through excel.

In short. Betfair sends data to *****, ***** sends that data to an excel sheet. With those numbers you do your own calculations/decision making and enter "triggers" in the excel file.

Once those parameters you decide are met excel tells ***** to put in a bet on Betfair.

And to fully answer your second question, yes you can fully automate your betting through *****. Once you've managed to program a bot that does exactly what you want when you want it you can concentrate on watching the worldcup and drink copious amounts of beer. Preferably in a certain bar in Amsterdam.

[starter22]

Hi Bumble,

The bot betting described in this thread is done through ***** Betting Assistant which can be found here:

http://www.*****1-software.co.uk/

Hope you don't mind me saying but I think that link is dead? Try instead (also)...
http://www.*****-software.co.uk/

Ttfn, Mick

[Timstertoo]

Hope you don't mind me saying but I think that link is dead? Try instead (also)...
http://www.*****-software.co.uk/

Ttfn, Mick

Don't mind at all!

It's working for me though! (both are for that matter)

[starter22]

Sorry about that - when I made post "*****1" link was DEFINITELY
not working? Maybe I'm going MAD!!! BOTH working now???

[lewismbet]

Hi this is more a general excel question than looking for a solution.

I am looking to record the last x prices at y time interval however I would like to store them 'dynamically' rather than recording them in a1, a2,a3. I think it may be easier to store this in an array [or something more appropriate?] rather than being in my sheet themselves.

Basically what am I trying to do? I need a phrase that I can bang into google and go looking for and research myself. While I am relatively knew to VBA I have found it ok to get to grips with however just now I know my solution but don't know enough about VBA to ask the question.

[neeeel]

you could store them as an array,



to find the size of array, multiply your x by your y

dim prices(x*y) as double

to sample prices at some time interval, you could use

Private Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)

although im not sure if the application keeps running during the sleep, or if it just pauses.

you can get the system time using the Time function

Dim MyTime
MyTime = Time

or you can use this sub

Public Sub Wait(intNrOfSeconds As Integer)
Dim varStart As Variant
varStart = Timer
Do While Timer < varStart + intNrOfSeconds
DoEvents
Loop
End Sub

hope this helps

[lewismbet]

Thanks neeel that is the sort of thing I was looking for. Now that I know I am on the right track will go and read some more books. Cheers

[Bumble]

Hi this is more a general excel question than looking for a solution.

I am looking to record the last x prices at y time interval however I would like to store them 'dynamically' rather than recording them in a1, a2,a3. I think it may be easier to store this in an array [or something more appropriate?] rather than being in my sheet themselves.

Basically what am I trying to do? I need a phrase that I can bang into google and go looking for and research myself. While I am relatively knew to VBA I have found it ok to get to grips with however just now I know my solution but don't know enough about VBA to ask the question.

I'm a long-time Excel user but fairly new to VB.

Yes, I'd have thought you'd need at least a two dimensional array - one being the horse/selection, the other being the prices over time. With more dimensions you could store more date (e.g. money placed at each price, corresponding lay odds) for later analysis.

One of the useful examples I found in a ***** forum included a "Worksheet_Change" event. Basically, every time the worksheet changes then this routine is fired off. Here is a shell:

Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False

If Not Intersect(Target, ThisWorkbook.Sheets(Target.Worksheet.Name).Range(" H5:H20")) Is Nothing Then

[do stuff]
....
End If
Application.EnableEvents = True
End Sub


The above If statement just checks whether the celll that changed
and fired the event handler was one we were interested in (like changed prices in H5 and below). If so, it 'does stuff'. The turning event handling off & on looks important to stop it getting itself in a twist.

Your 'stuff' would be to take the odds offered at each refresh (which would trigger the event handler) and extract them (from cell H5 and below or H15 if you've followed Millionaire Fund's advice to leave a gap at the top). Loop through each selection and store the current H column price in your array, then increment a counter waiting for the next refresh.

At the end, find some way of getting data out of the array (maybe write to a worksheet with one row per selection and one colum per price refresh).

I'm not sure what Google search would help but "Visual Basic Event Handler" might give something.

[The Geek]

With all the programming knowledge on here you lot will be writing your own toy soon.

[Scumbag trader]

I have a problem, dunno if anyone can help me . . .

I built a bot last night, and it works fine, all the triggers come in when they are supposed too, everything is fine.

Except, no bets are going in. I can't understand why, the trigger appears but nothing happens

I've tried re building it, twice, and there are no mistakes. It's using minimum stakes so it's not exceeding account balance, triggered betting is enabled, i checked everything

Can anyone help ?

Cheers . . . .

[Mickey Pearce]

Try changing the trigger in a couple of cells to something really simple at odds that won't get taken and see if it fires the bets in. Make sure you try this on the same markets that you have been having the trouble with.

[Scumbag trader]

Try changing the trigger in a couple of cells to something really simple at odds that won't get taken and see if it fires the bets in. Make sure you try this on the same markets that you have been having the trouble with.

Yep, tried that mate, still no joy

This error message appeared when i did that though, on the ExcelErrorLog in *****:

Action - Writing Odds

System.Runtime.InteropServices.COMException (0x800AC472): Exception from HRESULT: 0x800AC472
at Microsoft.VisualBasic.CompilerServices.LateBinding .InternalLateSet(Object o, Type& objType, String name, Object[] args, String[] paramnames, Boolean OptimisticSet, CallType UseCallType)
at Microsoft.VisualBasic.CompilerServices.NewLateBind ing.LateSet(Object Instance, Type Type, String MemberName, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, Boolean OptimisticSet, Boolean RValueBase, CallType CallType)
at Microsoft.VisualBasic.CompilerServices.NewLateBind ing.LateSet(Object Instance, Type Type, String MemberName, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments)
at Betting_Assistant.Excel.setCells(Object xlRange, Object[,] wCells, String action)

Not sure if that means anything ?