Binary Ladder

Example spreadsheets and comments on example spreadsheets.
Post Reply
Bet Angel
Bet Angel
Bet Angel
Posts: 3999
Joined: Tue Apr 14, 2009 3:47 pm

The author of this spreadsheet has been in touch with an updated version. We are working with him to bring some more along in the near future.

We have attached the updated version.
You do not have the required permissions to view the files attached to this post.
PeterLe
Posts: 3715
Joined: Wed Apr 15, 2009 3:19 pm

Hi
Was just looking at this demo...
I've noticed that the spreadsheet displays the odds/amount traded for individual selections.
Can anyone please tell me how it is possible to pass this information to Excel as I would like to incorporate it into my spreadsheets too?
Thanks
Peter
herbie
Posts: 342
Joined: Mon May 11, 2009 8:56 pm

hello peterle.... did you every find out how this demo achieves getting matched individual prices.
regards
herbie
User avatar
TheTub
Posts: 267
Joined: Thu Mar 26, 2009 7:53 pm
Location: Nottinghamshire

I'm not sure what you are looking at here?

It shows the money available by the three available prices - as read off the 'Bet Angel' sheet. And it shows the total matched on the market.

But I can't see amount traded by individual selections.

Unless you're referring to the 'Runner volume' cells on the Bet Angel sheet? This data is supplied by Bet Angel by default.

TT
rik
Posts: 1583
Joined: Sat Jan 25, 2014 5:16 am
Location: London

the file for binary ladder is not working for me, anyone knows why or any other options how to get a binary ladder? thank you
User avatar
vladilyich
Posts: 127
Joined: Fri Jan 22, 2016 6:58 pm

This looks like a fantastic piece of kit. How do you import it to Guardian and populate the chart with information?

Thanks.
gauravchadhabpl
Posts: 1
Joined: Sat Nov 12, 2016 10:13 am

Bet Angel wrote:
Wed Jul 15, 2009 11:16 am
The author of this spreadsheet has been in touch with an updated version. We are working with him to bring some more along in the near future.

We have attached the updated version.
hi
i see the demo version of this Spreadsheet great work by Author. can i get the latest version of this spreadsheet (unprotected).....

rgds
gaurav
Markwinnsmith
Posts: 14
Joined: Sat Jan 16, 2016 1:21 pm

I don't think there is an updated version of that sheet anymore. It would be great if we could get the full range of data into Excel, it's the one thing that is really missing for me at the moment. I did take a look at that sheet but there were no real clues as to how they were pulling through the data. Can only assume it was from when the Excel integration ran differently in the past.
nigelk
Posts: 469
Joined: Wed Apr 15, 2009 11:00 pm

Does anyone know who the original creator of this spreadsheet is (forum name?). Tried the big & rich website but it's no longer functioning.
User avatar
Euler
Posts: 24701
Joined: Wed Nov 10, 2010 1:39 pm
Location: Bet Angel HQ

I think I remember who the original author was. I may be able to rouse him if you are interested.
nigelk
Posts: 469
Joined: Wed Apr 15, 2009 11:00 pm

If he no longer visits it doesn't matter.
Markwinnsmith
Posts: 14
Joined: Sat Jan 16, 2016 1:21 pm

Just looked at this sheet again and realised that it doesn't really show you anything more than the normal spreadsheet. I mistakenly thought they had managed to pull in all the available money on all prices. Does anyone know if Bet Angel plan to add to the existing Excel integration in the future so that all price info is available?
User avatar
workpeter
Posts: 165
Joined: Sat Jul 30, 2016 8:29 pm

Yeah, it's misleading, it just shows queued money not the matched money at each price.

I did write a method a while back which is able to show matched money at individual prices. The results were indicative but not 100% accurate partly due to limitations in spreadsheet update speed but also peeps pulling money from queues.

I found using LTP was misleading, so my method compared how the queued money change vs. total matched against the runner. There are some things you have to consider though. First of you have to normalise the matched amount by dividing it by 2, this is because betfair show the UK horse market (for example) £50 matched as £100 matched because it calculates money matched on both sides of the ladders.

So then you look at the absolute difference between normalised money matched vs. how much the queue degraded on both sides. Whichever comparison has an absolute difference of 0 (or pseudo 0) then that's where the money went.

The below code is a small snippet of my function to give you an idea what i am talking about. There are 4 variations:Back (price didn't change),Back (price changed), Lay (price didn't change) and Lay (price changed).

iNormalisedAmount = (iCurrentAmount - iOldAmount) / 2

'Compare existing queue money with amount increase
iBackAmountDiff = iOldBackAmount - iNormalisedAmount
iLayAmountDiff = iOldLayAmount - iNormalisedAmount


iMatchedDirection(0) = Abs(iOldBackAmount - iNormalisedAmount)
iMatchedDirection(1) = Abs(iBackAmountDiff - Me.Cells(10, 7))

iMatchedDirection(2) = Abs(iOldLayAmount - iNormalisedAmount)
iMatchedDirection(3) = Abs(iLayAmountDiff - Me.Cells(10, 8))

'Find the direction matched
iClosestMatch = Application.WorksheetFunction.Small(iMatchedDirection, 1)

'allow for small variation from normalistion process.
If iClosestMatch <= 1 Then

If iClosestMatch = iMatchedDirection(0) Or iClosestMatch = iMatchedDirection(1) Then
'Show as back activity increase
ElseIf iClosestMatch = iMatchedDirection(2) Or iClosestMatch = iMatchedDirection(3) Then
'Show as lay activity increase
End If
End If
User avatar
workpeter
Posts: 165
Joined: Sat Jul 30, 2016 8:29 pm

Ok i may have a 100% solution for this, but I would need to do some API research. I was looking at something unrelated today when i came across a topic on a programming forum whereby peeps were talking about extracting data from other application objects. I'll need to look into this, but if possible, I could extract the data from the ladder which means i can show the matched bets in excel just the same way its shown in BA.
Laugro1968
Posts: 83
Joined: Thu Oct 06, 2016 12:04 pm

Hi Peter,

I for one would be very interested!

Best regards,
Laurent
Post Reply

Return to “Bet Angel - Example spreadsheets”