Smartgambler
Pro-Punter

Go Back   OZmium Sports Betting and Horse Racing Forums > Public Forums > General Topics
User Name
Password
Register FAQ Search Today's Posts Mark all topics as read

To advertise on these
forums, e-mail us.

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 3rd January 2014, 08:28 PM
Pat123 Pat123 is offline
Member
 
Join Date: Nov 2013
Posts: 323
Default Help finding potential profit/loss

I was wondering if there was an easy/relatively quick way of finding out what my profit/loss would be if I were to lay a specific horse (no. 5) in every AUS/NZ meet today the 3rd of Jan? Based on the following:

1. $100 lay stakes
2. Lay horse number 5 every single AUS and NZ thoroughbred race available on Betfair today
3. Only lay if horse is between odds 3.00 - 14.00
4. If horse scratched - on to the next race.

I've been looking at one site using their fixed prices but I really want to use Betfair's results however I cannot find the horses numbers...

If it were easy enough, I'd like to find out profit/loss from December laying all eligible AUS/NZ races. Any help would be greatly appreciated!
Reply With Quote
  #2  
Old 3rd January 2014, 11:44 PM
Chrome Prince Chrome Prince is offline
Member
 
Join Date: Jan 1970
Posts: 4,424
Default

Depends on how badly you really want to find out. I mean the work involved.

1. Go to Betfair website and download the csv data files.
2. Combine them to one workbook or import them into a database.
3. Extract the horse number from the selection i.e. 5. Power To Possess
In Excel assume that horse number and name is in cell A1.
=LEFT(A1,SEARCH(". ",A1)-1) Put this formula into cell B1.
This gives you the TAB number.
Then it's just a matter of filtering by TAB number and then by price.
Will take you a fair bit of time, especially if the database isn't set up yet with tables and fields.
__________________
RaceCensus - powerful system testing software.
Now with over 407,000 Metropolitan, Provincial and Country races!
http://www.propun.com.au/horse_raci...ng_systems.html
*RaceCensus now updated to 30/09/2024
Video overview of RaceCensus here:
http://www.youtube.com/watch?v=W821YP_b0Pg
Reply With Quote
  #3  
Old 4th January 2014, 06:04 AM
Michal Michal is offline
Member
 
Join Date: Oct 2005
Posts: 1,007
Default

You could buy Axis Historical, $395 per year, create a system with one rule; TAB no 5, then run it over the past data and then use the Axis Betting Analyser to analyse your bets (for laying) using actual Betfair prices. You could adjust for the Betfair Commission rate you think you will be on as well. Probably take you all of 5 min to do that. Test using flat stakes or proportional laying. As well as that you could analyse your system against about 115 forms/ratings factors to see where the edge is for any ideas you may have. You also get with your yearly subscription access to yesterdays data files so you can test all your systems, methods and ideas and see how they went each day. Its a great research tool and especially for the purposes of laying. In this case if you had Axis Historical already you would have known the answer in less time then it took you to write that post. Is the amount of time you could save worth the $1.08 per day it costs?
__________________
Michal - Ratings2Win Pty Ltd
R2W Axis - Axis is Australia's leading horse racing software and database;
with sophisticated form analysis tools and accurate horse performance ratings for TAB meetings.
http://www.ratings2win.com.au/

Last edited by Michal : 4th January 2014 at 06:11 AM.
Reply With Quote
  #4  
Old 4th January 2014, 06:17 AM
Michal Michal is offline
Member
 
Join Date: Oct 2005
Posts: 1,007
Default

Sorry I didn't notice the other rule, yes you can set a price range as another rule for your system and also set your lay stake to $100. or what ever bet size you want.
__________________
Michal - Ratings2Win Pty Ltd
R2W Axis - Axis is Australia's leading horse racing software and database;
with sophisticated form analysis tools and accurate horse performance ratings for TAB meetings.
http://www.ratings2win.com.au/
Reply With Quote
  #5  
Old 4th January 2014, 06:31 AM
demodocus demodocus is offline
Member
 
Join Date: Apr 2010
Posts: 59
Default

Quote:
Originally Posted by Pat123

1. $100 lay stakes
2. Lay horse number 5 every single AUS and NZ thoroughbred race available on Betfair today
3. Only lay if horse is between odds 3.00 - 14.00
4. If horse scratched - on to the next race.


Here are some longer term stats ..... sample 112,451 horses @ TAB 5. 14,073 of them Won (87.49% Lost) at an average AAP SP $6.43. Nobody knows what the Lay price would be. Make your own assumption and do the maths to calculate your loss :-)

Don't forget that quite frequently you're selecting a horse based on it's name (equal weights allocated TAB's alphabetically).

Betsender or Bf Bot Manager are simple and ideal for this type of task.
Reply With Quote
  #6  
Old 4th January 2014, 08:50 AM
The Ocho The Ocho is offline
Member
 
Join Date: Aug 2010
Posts: 1,037
Default

Be careful if you use BF Bot Manager as it will take into account any scratchings.

i.e. you want TAB no 5 then you lay the fifth runner by position. However if there is a scratching or two then it will bet on the 5th number after scratchings. So if No 1 & No 2 are scratched it will bet on No 7, etc.
__________________
Never give up on a dream just because of the time it will take to accomplish it. The time will pass anyway.”

― Earl Nightingale
Reply With Quote
  #7  
Old 4th January 2014, 10:18 AM
Mark Mark is offline
Member
 
Join Date: Jan 1970
Location: Qld
Posts: 1,406
Default

Here's a quick way to save money and time. Don't do it, it won't work.
Reply With Quote
  #8  
Old 4th January 2014, 12:04 PM
Chrome Prince Chrome Prince is offline
Member
 
Join Date: Jan 1970
Posts: 4,424
Exclamation

There is one problem, Betfair prices are copyright to Betfair unless you have a written authority to reproduce and distribute them and pay for that privilige.
Personal use is fine.
__________________
RaceCensus - powerful system testing software.
Now with over 407,000 Metropolitan, Provincial and Country races!
http://www.propun.com.au/horse_raci...ng_systems.html
*RaceCensus now updated to 30/09/2024
Video overview of RaceCensus here:
http://www.youtube.com/watch?v=W821YP_b0Pg
Reply With Quote
  #9  
Old 4th January 2014, 01:04 PM
UselessBettor UselessBettor is offline
Member
 
Join Date: Sep 2011
Posts: 1,517
Default

Quote:
Originally Posted by Chrome Prince
There is one problem, Betfair prices are copyright to Betfair unless you have a written authority to reproduce and distribute them and pay for that privilige.
Personal use is fine.

And betfair even cracks down on people collecting the prices without placing bets.
Reply With Quote
  #10  
Old 4th January 2014, 01:04 PM
norisk norisk is offline
Member
 
Join Date: Dec 2011
Posts: 334
Default

Quote:
Originally Posted by Mark
Here's a quick way to save money and time. Don't do it, it won't work.



beat me to it.
__________________
"Now let me get this straight - Whatever I do don't bet this horse?"
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is On
Forum Jump



All times are GMT +10. The time now is 08:57 AM.


Powered by: vBulletin Version 3.0.3
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
©2008 OZmium Pty. Ltd. All rights reserved . ACN 091184655