Go Back   Pace and Cap - Sartin Methodology & The Match Up > General Discussion
Mark Forums Read
Google Site Search Get RDSS Sartin Library RDSS FAQs Conduct Register Site FAQ Members List Search Today's Posts

General Discussion General Horse Racing Discussion

Reply
 
Thread Tools Display Modes
Old 10-11-2018, 09:39 AM   #1
CheckMark
Conley
 
Join Date: Sep 2018
Location: Fergus, Canada
Posts: 40
Calculating Profit

ted, I went with your advice and track my selections and see how I do. Well, I don't have time to handicap every race, so I went with doing Pick 4,5, and 6's from different harness and thoroughbred tracks. I started doing this since October 2nd and have hit 5/7 on my bets! But the real reason is to calculate profit, which I think I am doing wrong. Can you check my spreadsheet out and see how to calculate it properly if I did it wrong. Thanks Ted. I think you might need a google account unless the link works than I guess you don't =)

https://docs.google.com/spreadsheets...KuM/edit#gid=0

Last edited by CheckMark; 10-11-2018 at 09:43 AM.
CheckMark is offline   Reply With Quote
Old 10-11-2018, 09:57 AM   #2
Ted Craven
Grade 1
 
Ted Craven's Avatar
 
Join Date: Jun 2005
Location: Huntsville, Ontario, Canada
Posts: 7,209
Will do. You need to grant me permission to access that.


Ted
__________________

R
DSS -
Racing Decision Support System™ Follow on Twitter @SartinMethod
Ted Craven is offline   Reply With Quote
Old 10-11-2018, 09:59 AM   #3
CheckMark
Conley
 
Join Date: Sep 2018
Location: Fergus, Canada
Posts: 40
Quote:
Originally Posted by Ted Craven View Post
Will do. You need to grant me permission to access that.


Ted
Maybe this link would work

https://docs.google.com/spreadsheets...it?usp=sharing
https://docs.google.com/spreadsheets...it?usp=sharing

Last edited by CheckMark; 10-11-2018 at 10:02 AM.
CheckMark is offline   Reply With Quote
Old 10-11-2018, 10:12 AM   #4
Ted Craven
Grade 1
 
Ted Craven's Avatar
 
Join Date: Jun 2005
Location: Huntsville, Ontario, Canada
Posts: 7,209
They work. I'll get back to you.


Ted
__________________

R
DSS -
Racing Decision Support System™ Follow on Twitter @SartinMethod
Ted Craven is offline   Reply With Quote
Old 10-11-2018, 10:49 AM   #5
Ted Craven
Grade 1
 
Ted Craven's Avatar
 
Join Date: Jun 2005
Location: Huntsville, Ontario, Canada
Posts: 7,209
Good results so far! Post these PickNs online in Selections if you like, even harness - develop a track record.

Like any wager log, I'd suggest tracking:

- wager identity
- selections
- amount BET
- amount RETURNed (or $0, if a loss)
- profit/loss on the wager
- running bankroll balance

In your sheet, Cols A - F are fine.

Col G should be a numeric column showing $ RETURN (or $0 if a complete loss)

Col H Profit/Loss should be a formula: Col F - Col G ($Bet - $Ret): positive if a Profit or 0 or negative if either a Loss or if the $Return did not cover the $Bet

Col I Running Balance should be a formula: the previous row balance plus Col H (Profit/Loss) from the current wager.

To accommodate Col I (Running Balance), you should insert a new line above the first wager with an amount in Col I representing your opening Bankroll.

You can also add a separate column where you record W or L (Win or Loss) like you have done in your Col G - to track your actual hit versus miss, and thus your number of runouts in a row, though the positive to negative ratio in the Profit/Loss column also gives you that info, more or less (though it mixes in Hits which did not break even, which is not necessarily a Loss).

Of course to be real-world about it, your opening bank should be big enough such that a modest percentage (e.g. 2%) covers your wager, otherwise one loss wipes you out. In reality, the % of Bankroll bet should be in relation to your Strike Rate which so far is pretty high, but with a mix of various Pick-Ns (Pick 4,5,6s) the Strike Rate will vary for each and so a different % of Bank should be used for each.

I say - set your opening Bank at $100,000 (why not! ). That way 2% gives you $2000 for each wager (either multiple tickets on your Pick4s and 5s, and at least a single $1 ticket with the numbers of runners in each leg that you show for that one Pick6 for today). Good luck on tat Pick6 today, BTW.

Of course there are more optimal ways to bet PickNs, such as Steve Crist's ABC system, or even better ones.

Hope that helps! Good luck - and skill.

Ted
__________________

R
DSS -
Racing Decision Support System™ Follow on Twitter @SartinMethod
Ted Craven is offline   Reply With Quote
Old 10-11-2018, 11:55 AM   #6
CheckMark
Conley
 
Join Date: Sep 2018
Location: Fergus, Canada
Posts: 40
Quote:
Originally Posted by Ted Craven View Post
Good results so far! Post these PickNs online in Selections if you like, even harness - develop a track record.

Like any wager log, I'd suggest tracking:

- wager identity
- selections
- amount BET
- amount RETURNed (or $0, if a loss)
- profit/loss on the wager
- running bankroll balance

In your sheet, Cols A - F are fine.

Col G should be a numeric column showing $ RETURN (or $0 if a complete loss)

Col H Profit/Loss should be a formula: Col F - Col G ($Bet - $Ret): positive if a Profit or 0 or negative if either a Loss or if the $Return did not cover the $Bet

Col I Running Balance should be a formula: the previous row balance plus Col H (Profit/Loss) from the current wager.

To accommodate Col I (Running Balance), you should insert a new line above the first wager with an amount in Col I representing your opening Bankroll.

You can also add a separate column where you record W or L (Win or Loss) like you have done in your Col G - to track your actual hit versus miss, and thus your number of runouts in a row, though the positive to negative ratio in the Profit/Loss column also gives you that info, more or less (though it mixes in Hits which did not break even, which is not necessarily a Loss).

Of course to be real-world about it, your opening bank should be big enough such that a modest percentage (e.g. 2%) covers your wager, otherwise one loss wipes you out. In reality, the % of Bankroll bet should be in relation to your Strike Rate which so far is pretty high, but with a mix of various Pick-Ns (Pick 4,5,6s) the Strike Rate will vary for each and so a different % of Bank should be used for each.

I say - set your opening Bank at $100,000 (why not! ). That way 2% gives you $2000 for each wager (either multiple tickets on your Pick4s and 5s, and at least a single $1 ticket with the numbers of runners in each leg that you show for that one Pick6 for today). Good luck on tat Pick6 today, BTW.

Of course there are more optimal ways to bet PickNs, such as Steve Crist's ABC system, or even better ones.

Hope that helps! Good luck - and skill.

Ted
Can you see if I did the correct profit earned after I do them please.
CheckMark is offline   Reply With Quote
Old 10-11-2018, 12:35 PM   #7
Ted Craven
Grade 1
 
Ted Craven's Avatar
 
Join Date: Jun 2005
Location: Huntsville, Ontario, Canada
Posts: 7,209
Your Profit - column H (really, your Bankroll Balance) is incorrect. You're forgetting to deduct your losses (and other arithmetic errors)!

This is what it should be, using the formulas I gave you above.

Name:  conley.jpg
Views: 89
Size:  64.9 KB


.
__________________

R
DSS -
Racing Decision Support System™ Follow on Twitter @SartinMethod

Last edited by Ted Craven; 10-11-2018 at 12:38 PM.
Ted Craven is offline   Reply With Quote
Reply

Thread Tools
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

BB code is On
Smilies are On
[IMG] code is On
HTML code is On

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Profit Line Data ginag2 General Discussion 2 03-13-2018 11:43 AM
Reflecting on my month with the Methodology Jeebs Sartin Methodology Handicapping 101 (102 ...) 13 03-28-2017 09:59 PM
Calculating TPR CaptDon100 Sartin Methodology Handicapping 101 (102 ...) 21 08-25-2014 09:50 PM
How I Get And Profit From The Big Horse partsnut Previous 'Handicapping Discussion' Forum 10 11-28-2012 11:21 AM
Matching for PROFIT - The "Mind's Eye" and WINNING pattern recognition RichieP Matchup Discussion 7 10-08-2010 08:36 PM


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2018, vBulletin Solutions Inc.

All times are GMT -4. The time now is 11:29 PM.