Analysing Betfair graph in excel

[danjuma]

Generally, one of the indicators used during pre-off horse trading is the BF graph to determine the general trending of the horse (steaming, flat or drifting). Just wondered if anyone has managed to find a way of integrating/ analysing this data/information in excel to use for trigger betting (ie, being able to monitor in excel the long term trending of the horse)? Cheers

[xraymitch]

Hi Dan,

Have a look at what Gary has done to charting with his latest beta.

Though it doesn't answer your question it may provide food for thought.

Ray

[danjuma]

Hi Dan,

Have a look at what Gary has done to charting with his latest beta.

Though it doesn't answer your question it may provide food for thought.

Ray

Hi xraymitch. Yes, seen the new charting, but like you mentioned does not answer my question. What I am basically after is a way in excel to be able to identify a horse that's been steaming, drifting or flat all day or last couple of hours or so. Anybody has any idea? Thanks

[doris_day]

I think there's only one way which is to capture all the data yourself as the graph Betfair shows doesnt have a quantitive equivalent that is readily available from their site.
It would then be a matter of working out the best MA to decide if the current price is above or below the line.

Fracsoft, which I used to use collect this data, or did at any rate but you may not want to pay their exhorbitant monthly fee (was £300 when I used it a few months ago).

You need to find a service that collects all the data for you and that you can tap into when you need it.

Perhaps Gary could organise this and offer it as a separate service. I do think there would be a market for it.

[danjuma]

I think there's only one way which is to capture all the data yourself as the graph Betfair shows doesnt have a quantitive equivalent that is readily available from their site.
It would then be a matter of working out the best MA to decide if the current price is above or below the line.

Fracsoft, which I used to use collect this data, or did at any rate but you may not want to pay their exhorbitant monthly fee (was £300 when I used it a few months ago).

You need to find a service that collects all the data for you and that you can tap into when you need it.

Perhaps Gary could organise this and offer it as a separate service. I do think there would be a market for it.

Thanks D_D

[xraymitch]

Dan,

Have a look at quantsports and Ninjatrader

http://www.quantsports.co.uk/wordpress/wp-content/uploads/2010/09/1.png

You can use both programs for free and will give you a feel for the range of indicators that can be used in Technical Analysis.

So far I can't get my head round it but I keep coming back to it every so often - maybe you will fair better.

Incidently I have Doris_Day to thank for putting me on to this.

Ray

[danjuma]

Dan,

Have a look at quantsports and Ninjatrader

http://www.quantsports.co.uk/wordpress/wp-content/uploads/2010/09/1.png

You can use both programs for free and will give you a feel for the range of indicators that can be used in Technical Analysis.

So far I can't get my head round it but I keep coming back to it every so often - maybe you will fair better.

Incidently I have Doris_Day to thank for putting me on to this.

Ray

Thanks xraymitch. Already knew about quantsports and irs integration with Ninjatrader. I personally find a bit complicated and OTT for exchange horse racing trading. Don't personally see the advantage you gain over just following BF's chart or the charts you get with other bots available.

[xraymitch]

Hi Danjuma,

I guess I am thinking along the lines of finding out what are the underlying numbers that create the graphs which give their buy and sell signals, and to use these numbers as triggers in excel.

Me thinks we are both looking for the Holy Grail of formulas that can predict market direction...

Ray