Bet Angel - Spreadsheet / Excel chat : IN PLAY highest odds

Discussion regarding the spreadsheet functionality of Bet Angel.
Post Reply
rain91
Posts: 28
Joined: Tue Feb 07, 2017 7:11 pm

Sun Feb 04, 2018 8:43 am

Hi guys

How can i see the in play high odds in horse racing?

Inplay high = highest odds where min. 100 GPD traded (as timeform).

I cant use LTP, because there is "refresh rate", and because of this ("refresh rate"), sometimes i cant see where was the highest odds.

User avatar
Dallas
Posts: 8448
Joined: Sun Aug 09, 2015 10:57 pm

Sun Feb 04, 2018 10:46 am

The 'Market Overview' screen (Speedo Icon) will show the Hi/Lo a selection has traded at

rain91
Posts: 28
Joined: Tue Feb 07, 2017 7:11 pm

Sun Feb 04, 2018 11:15 am

Dallas wrote:
Sun Feb 04, 2018 10:46 am
The 'Market Overview' screen (Speedo Icon) will show the Hi/Lo a selection has traded at
Thanks. How can i integrate to Excel?

PeterLe
Posts: 3340
Joined: Wed Apr 15, 2009 3:19 pm

Sun Feb 04, 2018 11:54 am

Take a look here - http://www.betfairpromo.com/betfairsp/prices/index.php
This shows the previous days results (in CSV format)

rain91
Posts: 28
Joined: Tue Feb 07, 2017 7:11 pm

Sun Feb 04, 2018 12:09 pm

Thank, but i know.

I make a strategy based on the linked page (Betfairpromo), but i cant not see INP High and Low odds in Betangel Excel.

So i need INP High and Low odds per runners, in Betangel excel. Unfortunately LTP is not to good.
Képkivágás.PNG
You do not have the required permissions to view the files attached to this post.

spreadbetting
Posts: 1621
Joined: Sun Jan 31, 2010 8:06 pm

Sun Feb 04, 2018 2:15 pm

If the data isn't sent to excel it's simple enough to write your own VBA routine to monitor the LTP to record the max price

rain91
Posts: 28
Joined: Tue Feb 07, 2017 7:11 pm

Sun Feb 04, 2018 2:40 pm

spreadbetting wrote:
Sun Feb 04, 2018 2:15 pm
If the data isn't sent to excel it's simple enough to write your own VBA routine to monitor the LTP to record the max price
Ok, but LTP isnt enough :( Refresh rate is 200 ms, and if excel in "free time" ("0-200" ms), i dont know, where was the odds, and how much was it the traded volume.

Not possible, the market overview to excel integrate?

spreadbetting
Posts: 1621
Joined: Sun Jan 31, 2010 8:06 pm

Sun Feb 04, 2018 3:24 pm

Streaming is supposed to push the odds so theorectically you shouldn't miss any prices but obviously if you're not on the market it won't be logging those highs

User avatar
ShaunWhite
Posts: 3347
Joined: Sat Sep 03, 2016 3:42 am

Sun Feb 04, 2018 4:57 pm

I'd assumed that info was pushed to excel at the Guardian refresh rate not the market overview rate (one click or ladder). I should check that though rather than assuming.

You could always spark up another instance of BA and run it at 20ms?

rain91
Posts: 28
Joined: Tue Feb 07, 2017 7:11 pm

Fri Mar 16, 2018 12:20 pm

Yes, i set it in guardian. But the minimum is 200ms, but sometimes in reality it is more, ~500ms - 1 sec.

But i think, 200 ms is also many.

I run my strategy in real money, and it is not good, compare to my theory strategy.

(i need someway the real INPLAY HIGH odds (min. 100 GPD traded, as in betfairpromo statistics) to excel integrate.

Post Reply

Return to “Bet Angel - Spreadsheet / Excel chat”

  • Information
  • Who is online

    Users browsing this forum: No registered users and 2 guests