Spreadsheet Tool for Exacta players.

[Ray2000]

Lately, I've been using a spreadsheet "App" to decide whether to box3, box2, keybox or wheel my picks.
I believe this sheet can improve a player's ROI by cutting down on the No-value bets.
Some Harness Exacta players here might find it useful. (It's limited to 10 horse fields but can be used for T-breds with some changes)

I will put this sheet up as an attachment if there is enough interest and if I can get some feed back on its use.
I need some beta testers :) ...I will not sell it but post it for free use.

Cost?.....It's free
What Tracks?..............................Most USA tracks plus Mohawk, Woodbine
Do I need an account or password?....No, It uses freely available WEB data
Do I have to handicap the Race?......Actually No, You can watch if the crowd faves are overlays in the Exacta pool or examine any 3 picks using current Toteboard odds. (What are the gray horse paying? :)) If you don't want to create a line for your top 3 picks, it will use the current tote line.

What does it do????

It keeps a running history of the Exacta Will-Pays for Crowd Faves and also Your picks as the race approaches Posttime, showing which combos are poor bets. BTW, I am aware of the big objection to trying to use toteboard odds because of the last flip changes but I have found that patterns do exist. Poor bets tend to stay poor and bets "on the cusp" usually get pounded but others show promise. Finding what works at the track you play is all part of the game.

I've found that I can trust looking at prices, up to 2-3 minutes beyond the first appearance of "0 MTP" and still use the board info in getting a bet down. This is where patterns become useful.

The layout looks a bit confusing but some rows can be cleared if not wanted. At the very top you set the Track and Race number. Click on either of 2 Red Update buttons and the next 12 rows will show the usual tote information plus an alternate Win odds line created by "How the horse is being used" in Exacta pool. (This can sometimes spot barn money trying to hide in Exacta Wheels). 2 other rows give Place bet Minimum Prices and Dr Z Place pool Expectancies by Win/Place inefficiencies.

Now for the good part...

The bottom half of the spreadsheet has current Exacta Will Pays for Crowd Faves and Your Picks for the 6 combos of Exacta Plays...a/b, b/a, a/c, c/a, b/c, c/b. Poor paying bets to avoid are shown in red font. The algorithm uses Discounted Harville calculations based on Win pool amounts to determine "Good vs Poor" Bets. For the users Picks/Odds it includes an adjustable "safety" factor. By watching the "RED" bets you can decide to go for 3box (all white font) or 2box or Part wheel. If you "Update" once a minute the history of the Exacta Will Pays will be recorded so you can judge if any patterns are emerging and wether a wager is called for.

I am not going to spend the time and effort to write up the "Manual Details" unless there's enough interest.

The attachment shows The Meadows Race #7 today where I was able to limit my bet to the 1-4 Box.
I placed the bet at the 5927$ point in time...(It hit)


I'll be interested in any comments/suggestions.

[mrroyboy]

Ray Of course I want it. I have been following you for years. Anything you make has got to be good!!!
mrroyboy@embarqmail.com

[jimnancy]

I would like to look at it also Ray. Not sure if I could fiqure it out but I would like to try. As I told you before the exacta wiil pays used to be my thing.

Do you need my email?

[tamaharbor]

Please post it Ray. You are my idol!

[teddy]

Count me in!

[traynor]

Original paper:
http://www.jstor.org/discover/10.2307/2284068?uid=3739736&uid=2129&uid=2&uid=70&uid=4&uid=3739256&sid=21101123919201

http://stat-www.berkeley.edu/~aldous/157/Papers/ali.pdf

[SchagFactorToWin]

All I play are exactas at 2 tracks, so I'm in.

[pacer]

How do I get the calculator

[Ray2000]

pacer
I'll put up the 1st version later today. I'm waiting for some tracks to open to make some tweaks.



traynor
thx for the links
the Harville approach (even discounted Harville) is one of the weaker methods to predict 2nd and 3rd place finishers (Henery is better ?) but for the purpose of this sheet, it provides a workable base for comparison of the exacta combinations in the 3 box.


.

[Sinner369]

Ray.........count me in for the App!

And thanks in advance!

[mrroyboy]

See Everybody wants it. Told you so.

[Ray2000]

Ok, seems there's enough interest...

This spreadsheet requires the features of Microsoft Office 2007 for Conditional Cell Formatting and the function "IFERROR". Also you will need to allow Macros to run.
Open Excel 2007 and click the Office button
Click the Trust Center button on the left.
Select Trust Center Settings. at the bottom right
choose Macro Settings...then.enable all macros

This Forum doesn't allow attachments of Excel files of type .xlsm so I have changed the extension to ".xls". After downloading (by right clicking the attachment) change the name back to ExactaWatch.xlsm.

MAKE A COPY of THE FILE to fall back on if necessary.

You can now open the spreadsheet. There are no hidden pages or cells, the macro code is unlocked.
The only cells that the user should change are in yellow, (Your Picks and/or Odds and 2 constants).
Lambda is the adjustment for Harville Discount, OLEF is a safety margin for "Minimal Accepted WillPays"
Cells are not locked, so keep the changes limited to the yellow cells.

Select a track from the drop down box and set the current Race number. Click on either Red Update Button (there are 2 so you can minimize the window and still see one). Data takes about 5 secs to come in. A message box will appear if unsuccessful but not all errors are trapped as yet.

There are 2 other settings, a check box for "Keep Exacta WillPays" allows you to suspend the grid update if you want to check another track and then come back to the grid history.

The other option setting... "For My Picks" ...tells the program which Odds to use for The picks entered in the yellow cells for your top 3 picks. If you leave the cells for MYodds blank then the sheet will use current toteboard odds for those picks. If you're going to enter your own odds for MyPicks, then try to be realistic meaning, MyOdds1 would be the lowest .... 0.5 - 2.5 (enter numbers as decimal odds). MyOdds 2 and 3 would be in the range of 2.0-6.0 either close or more widespread. This setting might be a little confusing until you get the hang of it. For now "Use My Odds" means use the numbers presently in cells L14:M14 for the odds on my picks.



I'm having a bit of a problem with Excel "forgetting" how to sort the faves ?? Need to Check Fave1 for most win money for a while, until I get this resolved.
error when web data in midst of changing to the next race

other known issues

Batavia Buffalo Lebanon are not always available
Pompano reports numbers differently (after-takeout) and $1 will pays?
others may also have 1$ exactas (need list)

In the top right corner is a list of available or soon to be available tracks.
The T-Bred tracks are not in the drop list at this time.

Not all errors are trapped, refresh should correct but may have to revert to last save

The running history of Crowd favorites' exacta prices (green grid) is not that useful.
.. the 2nd and 3rd faves (sometimes no.1), will most likely be changing.

I'm creating this sheet from a larger version the robot uses, so I don't have as much testing on this one as I would like, but let's see how it goes.



What follows is RaysRobot top3 picks/odds for today, for placing into cells I14-N14 as practice. :)


PHL R6 1 6 7 0.92 2.59 7.48
PHL R7 2 4 5 2.12 2.90 3.12
PHL R8 7 5 2 0.93 4.24 4.94
PHL R9 8 4 7 1.74 2.57 4.08
PHL R10 6 2 5 1.34 5.42 8.33
PHL R12 2 3 1 2.34 3.54 3.59
PHL R13 3 2 4 2.28 2.40 3.31
PHL R14 5 4 3 1.04 2.71 5.57
STGA R1 6 2 8 2.19 3.07 3.08
STGA R2 4 1 5 1.50 2.16 3.94
STGA R3 7 5 4 0.63 4.58 5.29
STGA R5 5 2 1 1.79 3.20 3.95
STGA R7 6 7 3 0.84 4.80 5.02
STGA R8 4 7 6 1.93 2.27 4.48
STGA R9 2 5 4 0.66 4.67 6.14
STGA R10 1 7 2 0.76 3.31 5.53
STGA R11 8 3 6 1.59 2.21 3.88
STGA R12 1 4 6 1.67 2.58 4.16
MEA R2 2 7 5 2.99 3.11 3.32
MEA R3 4 5 6 0.99 2.43 4.07
MEA R5 3 5 6 1.57 2.37 4.87
MEA R6 4 5 6 1.23 2.31 3.30
MEA R7 8 3 7 2.05 3.69 4.23
MEA R8 5 3 2 1.06 2.00 4.17
MEA R9 8 1 4 1.75 2.31 4.20
MEA R10 8 5 9 0.86 3.65 5.73
MEA R11 9 3 5 2.21 2.35 4.60
MEA R12 4 7 1 1.12 2.14 6.79
MEA R13 1 2 4 1.80 4.14 4.22
MEA R14 3 8 2 1.88 1.97 4.48
MEA R15 6 8 5 0.94 4.56 4.64

[Sinner369]

Ray is the file estension below.........wrong?..........because I cannot open it.

I cannot open it with Excel 2003 neither! I changed the file extension to xlsx and converted it to xls with an online program!



http://www.paceadvantage.com/forum/images/attach/xls.gifExactaWatch.xls (http://www.paceadvantage.com/forum/attachment.php?attachmentid=9507) (80.9 KB, 13 views)

[Ray2000]

the file extension is .XLSM and you need Office 2007 or later

hope this helps, if not I'll put up a 2003 version since I have 2 errors to correct already.

[Ray2000]

This sheet should work on older Excel programs and the short fields (5&6) display correctly

No need to change any file name.

[Ray2000]

Attached is the final write of ExactaWatch. It is in Excel Version 2003 so no extension name change is needed.
It can be used as is. It will open in compatibility mode for newer versions of Excel.

Repeat..USER should ONLY CHANGE Track/RaceNo and the values in the YELLOW cells


1. Corrected errors generated by field sizes smaller than 7

2. Removed Vernon (not available) added Philadelphia (Chester/Philly are the same track)

3. Added a cell showing time lapsed from 1st appearance of "0 MTP" when refreshing

4. Handles Crowd favorite #1 if there's been a change.

5. The row for Dr Z percentages is formatted to only turn green if Expectation > 115% and Tote Odds <10
..In theory, a Ziemba 100 means no place pool inefficiency, 100+ gives positive expectation on place bets.
Searching this Forum for "Dr Z" will turn up numerous discussions on this system.
The complete Dr Z system incorporates Kelly wager sizing/dutching calcs. (Not included in this sheet)


BTW... The sheet has the data for Harrahs R5 today where a 1/5 shot #1 gets beat.
Crowd Exacta 2-1 shows up White ;) . Robot didn't use the deuce. :(


Here is the Robots oddsline for some possible Ex box bets today, Friday 10th
You can copy copy columns 3 thru 8 / paste in NotePad / recopy/paste to spreadsheet

GOOD LUCK ALL


MAY R1 4 3 2 0.80 3.07 7.79 Moses Hanover-3/1
MAY R3 6 7 3 1.41 1.70 8.78 Joey Lee Macdavid-3/1
MAY R6 9 6 5 0.85 3.56 5.75 Little More Ram-3/1
MAY R7 5 2 6 1.90 2.10 2.34 Guts N Glory-7/2
MAY R9 1 4 3 1.40 2.71 5.31 Uniqueaway-3/1
MEA R1 2 3 5 2.14 2.31 5.20 Hall Of Memories-2/1
MEA R2 7 3 5 2.17 2.53 3.87 Komma Ka Z-6/1
MEA R3 6 2 4 1.11 3.13 5.25 Ak'S Livin Large-7/2
MEA R13 4 2 6 0.93 3.02 4.34 Itsghostlyoutside-7/2
M R9 1 7 10 2.07 3.20 4.36 Lil Miss Bourbon-5/2
M R11 6 4 5 1.60 2.88 7.20 Bluff-8/5
PHL R7 1 6 3 1.94 1.98 4.34 Kamanche Sun-3/1
PHL R8 4 2 7 1.31 4.86 5.20 Look Siera-4/1
PHL R9 1 4 3 1.24 2.31 5.80 Precious Potato-8/1
PHL R10 2 4 3 2.24 2.38 3.37 Higher And Higher-5/2
PHL R11 1 5 3 1.83 2.37 4.60 Kayla'S Dream-3/1
PHL R12 5 3 7 0.89 4.44 4.76 Sevruga-3/1
PHL R13 1 6 5 1.42 1.71 6.17 Restless Native-9/2
PHL R14 4 1 5 1.62 1.94 4.42 Jin Dandy-9/2
STGA R2 7 6 3 1.11 3.11 4.65 Alias Smitty-5/2
STGA R5 9 4 5 1.80 1.94 4.13 Silver Delivery-3/1
STGA R11 3 1 5 1.26 2.05 3.93 Super Manning-2/1
YR R8 6 2 1 0.84 3.64 6.93 Mm'S Lucky Boy-8/5
YR R12 1 2 7 0.84 3.01 7.07 Bet On Luck-8/5

[mrroyboy]

Thank you Ray for all the work you put into this. It will take me a while to figure it out. I am not exactly a high tech 21st century person. I'm one of those guys who still needs a paper copy of the PP's to handicap!!

[CHeCK EyE]

Ray, if you ran a class on this stuff, I'd attend. I'll download and look through this...I gotta say I don't understand it right now and likely won't after getting a chance to look :confused: k ...but I'm fascinated

[Ray2000]

Thx guys

Keep in mind the purpose of this sheet for watching the Exacta Board is to eliminate some bets rather than finding them. Cutting your cost (number) of tickets will of course, reduce your Return (strike rate) as well but hopefully your Return On Investment will go up and you can raise your base percent of capital.

I put in rows for the usual tote info, alternate win odds and the Dr Z place watch (which many believe is just hokum anyway) but the way I use this spreadsheet is to crop the Excel window down so just the blue grid and my picks show. Set the track and race and refresh about once a minute, starting about 5 MTP. Payoffs starting and staying in the "Red" usually end up in the "Red" and just aren't worth the risk, for me anyway. It depends on which odds you assign to them, the track and maybe the phase of the moon. My main ADW account allows Queuing bets up in a preview form, so I set up the possibilities... Box abc, Box ab or ac or cb, Kybox a w/bc etc and wait and watch to about 2-3 mins beyond "0 MTP" then select best way of betting and submit.

As for setting the odds on your picks ...
1/1 - 2/1 - 4/1 is not a bad start for a Pick 1 you really like
or 1 - 3 - 3 if pick 2 and 3 are a toss up.
or 2 - 2 - 3 if you like them all about the same
or you can use current board odds, but I haven't followed that as closely.

The Overlay margin is set at 125%.
You can raise that constant (OLEF) which will set a higher bar for acceptable bets in the blue grid.


Good Luck and I hope you find it saves some $$.

Actually I get the same endorphin hit when only losing $4 instead of $12 :D



Here are the races I'll be watching today.


HP R6 6 7 1 0.80 5.35 5.43 Rising Artist-4/1
HP R8 7 9 2 1.29 2.29 5.58 Peyton'S Troubador-8/1
HP R10 7 6 8 1.41 2.01 4.39 Smarter Yet-10/1
HP R11 6 5 8 1.92 3.69 4.45 Her Request-6/1
INDY R4 6 3 4 1.77 2.57 3.55 I Got My Wish-6/1
INDY R6 5 2 1 1.81 1.97 2.49 Casino Captor-4/1
INDY R10 7 3 5 1.78 1.78 5.55 September Road-4/1
LEX R2 5 6 7 0.93 3.89 3.92 Paul T-6/1
LEX R4 1 4 3 1.65 3.52 3.61 Whispers Art-4/1
LEX R9 2 4 9 1.48 2.82 4.79 Title Shot-8/1
MOH R2 3 2 5 1.59 2.41 5.83 Rock Me Amastreos-9/2
MOH R8 10 2 9 0.77 4.51 4.69 Misty Moonstone-7/1
M R8 7 9 5 1.12 3.83 6.19 Mickey Hanover-8/1
M R9 5 7 4 1.80 2.71 5.13 Rileys Luck-6/1
NFLD R12 2 3 7 1.40 2.35 3.48 Full Of Elegance-10/1
PCD R9 8 1 5 0.86 3.74 6.74 Mobile-15/1
RP R2 6 3 8 0.87 4.55 5.71 Count The Cost-9/2
RP R12 8 1 2 1.74 1.83 4.76 Whistle A Tune-8/1
SCD R4 5 6 4 1.38 4.47 5.97 Northern Breakout-6/1
STGA R7 8 1 3 1.21 2.65 5.03 Show Me Up-6/1
TGDN R7 8 9 5 2.09 2.47 2.73 Jersey Boy-6/1
YR R10 1 4 3 1.56 2.19 3.75 Or-6/1

[mrroyboy]

Very good Ray. Thank you.

[melman]

Ray not sure how the Robot will handle this trainer but what a mile in last. I give this one a BIG shot at a price. Let's say off odds of 4 or 5-1 or more.

R4 8 Main A Dieu Too 8-1 on the m/l.

[Ray2000]

Mel
Strange computer logic, bot had the 9 and 10 rated highest but rejected the race because both were breakers.

That left

BigM....R4....8-3......Main A Dieu Too-8/1 - In Kenny's Honor 5/1

as the computer picks but it didn't get on the playlist.

Ocean Downs horse makes the Big times...:) ...could be....GL

[Ray2000]

A request from a T-Bred player prompted this update. The Spreadsheet can be used if the field size of the runners is less 11. Also, the calculations are using generic Takeouts of 17% Win/Place/Show and 20% on Exactas, so if you want, you can update the numbers in range "AB5:AC60" on sheet "Imports" to have more accuracy. It probably won't change output that much.
To add a track not covered, PM me.

The attached .xls file also has a change to adjust for the imported data having a changed format, causing an impolite exit. :)

[teddy]

Anyone able to get tbred tracks to work on the program?

[Ray2000]

The spreadsheet is operating OK for some Tbred tracks on my machine, but I found a bug when selecting the option .. "Use Toteboard Odds" for Players Picks (not Players own line).

Also, some TBred Exactas at ebet are being reported to the dollar base not $2 (Aqueduct)

If I can find a method to determine Exacta base amount from Win prices and probables, I'll put up a new version. Until then this latest file should work on $2 payoffs, but you will have to ignore 1$ prices.

[teddy]

not finding a place to change settings in 2007

[teddy]

Got it working in compatibility mode. If I get a 11 percent rebate how can I change the olef to get more actual overlays? I lowered my olef to 115.

[Ray2000]

teddy

The spreadsheet is a bit clumsy in that it's displaying possible overlays for 2 different scenarios. The green columns are showing Harville probs vs tote probs for the top 3 crowd picks. The Blue columns are using any 3 player picks and either the current tote odds or the player's own (manually entered) oddsline for those 3 picks.

Harville's original method was altered and later called Discounted Harville, to allow for the 'Silky Sullivan' effect,
(The horse will win or beat nobody, meaning, small chance to Place)
http://www.paceadvantage.com/forum/showthread.php?t=35264

People argue over how much discount should be applied so I put this in as an adjustment but it only applies to the green columns, the top 3 crowd choices. (BTW, a discount of 1.0 is the original Harville, .78 seems to be the accepted discount)

For the blue columns, the players picks, I used the original Harville formula and then as an after thought before posting, put in the OLEF (Overlay Exacta Factor) which is simply a multiplier for the $2 Acceptable Minimum Prices on Players picks. Lowering the number in .1 increments like 1.15...1.0...0.9...0.8 will show more prices "in the black" but doubtful overlays.

The latest version (posted in reply #25) was saved with Aqueduct race 3 numbers and that has the $1 base problem. Use only on tracks giving $2 probables until I correct that problem or set OLEF to .5 ?

[teddy]

Can we double the exacta number and compare to the h olay number to decide. Or do we need to c hange the olef factor first.

You cant be till they are loading at least, I saw quite a few go from great overlays to no overlay after the start. Even on heavy favorites.

[Ray2000]

Doubling the payoff would be best, that's why I'm trying out a "Work-Around" solution where the program will look at the average exacta payoffs compared to the winpool-based Harvilles on the lowest 6 exactas and if way too low will convert to 2$ payoffs. Need to test it out for awhile this PM.

I made this sheet from the one I use to get away from Log-In requirements. Some missing tracks and no base price info is the trade off.

[teddy]

Definitely something at work looking at overlays too.. 5-1 with 6-1 overlays seemed to stay overlays. Just my one night of watching.. did catch a nice one on the first try though.

[Ray2000]

Ok
My 1st method at setting the base price on Exacta Probables sucked.

This version goes back to setting the multiplier by a lookup table and hope each track stays constant in the imported data.

I have the correct numbers for Churchill, Calder and Aqueduct entered.
For other tracks the table will need updated as they come available.

go to sheet Imports, ...cell range AA5 thru AA60
and set the multiplier for any new track
You can also update the Take-outs there. (currently using generic for T-Breds)


Originally designed for Harness so field size is limited to 10


The way I use this sheet is mostly for structuring the Exacta bets on my picks.

If my top 3 picks are showing 5 or 6 combos, ie ab,ac bc,ba ca in the black
...then I go for the $2 3horse box Exacta.

If only 2 like bc, cb then a $3 dollar 2 box Exacta is called for.

Like wise for Key boxing like ab, ac, ca, ba are black and bc, cb are red...key "a"


Good Luck

[teddy]

Exacta Will Pays on Current Favorites Exacta Pool $20,489
Exacta Combos Next Races to Go- -Next Races to Go Next Races to Go- -Next Races to Go - -
Current 2$ Will Pays #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!
Harville-Chance #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!
Need for H-Olay Scr Scr Scr Scr Scr Scr
210407 0 MTP #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!
20489 0 MTP #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!
20489 0 MTP #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!



all my exacta screens are looking like this suddenly???

Seems to be not finding the favorites but the pools show up in the top section?

[Ray2000]

refresh again

make sure the race has only 10 or less original starters
not like churchill with 15 listed, 7 scratched

What race ?what track?

If the sheet was saved with that mess, download a fresh file.

[teddy]

Deleted all copies and downloaded again, Hollywood park would not work but Turf Paradise did. Both came up with track not available. Turf Paradise still loaded.

[Ray2000]

For Hollywood

Goto Sheet "imports"....cell Z47

change HOL to BHP (all caps)

go back to sheet "ToteBoard"....Save the sheet

for other tracks, check ebet results for the track in question and the code letters will be in url address.

[teddy]

Thanks, can the colors be changed? The red on green hurts my old eyes.

[Ray2000]

You can change any of the cells fill color you would like.

Font color on some cells is conditionally set to red (if less than acceptable price)

You can select "Manage Conditional Rules" and set format to your liking.

[Ray2000]

For the sake of completeness, I'll put this info in this thread, but it really wasn't worth investigating.

The Harville formula

Pj|i = Pj/(1-Pj)

for Exacta probability (P) to hit based on win pool amounts was later adjusted (Discounted) by the addition of a power factor, Lambda. (see 'Lo, V.S.Y. and Bacon-Shone, J')

The accepted value for Lambda was .76 for the T-Bred race data set they used.

I looked at 32,000 harness races at 46 tracks this year and the best Lambda for comparing closeness of fit of actual Exacta Payoffs to Discounted Harville predictions was 0.90. The fit was very close, see below.

The track differences and takeouts had little effect on this constant so if anyone's using this spreadsheet, you can change cell R24 to 0.9


.

[Ray2000]

Too late to edit

The Harville Ex formula is Pj|i = PiPj/(1-Pi)

[netbet]

Ray,

I just downloaded the latest version and followed along with a few races at Parx. Nice app and I plan to use it on a daily basis. Thanks so much for your efforts and hard work.

Patrick

[mrroyboy]

Uh Ray? Can you repeat that in english please?? LOL

[Ray2000]

Ray,

I just downloaded the latest version and followed along with a few races at Parx. Nice app and I plan to use it on a daily basis. Thanks so much for your efforts and hard work.

Patrick


thanks Pat, if you have any questions, let me know.

[Ray2000]

Uh Ray? Can you repeat that in english please?? LOL


Only one letter in Greek, roy.... :D ..just kidding

[mikeb]

convert multi file format to single comma delimiter format


could this be done?
thanx
MB

[Ray2000]

I'm not sure, mike, never had to deal with them in Harness.
The T-bred forums have posted on this topic in the past.

http://www.paceadvantage.com/forum/showthread.php?t=13104

There's a couple references to free utilities that might work, in that thread

[netbet]

Ray,

How do I get the spreadsheet to show Gulfstream and Tampa Bay? I tried using the spreadsheet this afternoon and these tracks are not available in the dropdown.

Thanks.

Patrick

[mabred]

how does one get it to work is the ???

brisnet tote ??could someone give a short

tutorial

mabred

[Ray2000]

The Spreadsheet was designed for Harness tracks, where 7 to 10 program entries are common. I could redo it for T-Breds (if there's enough interest), to handle those larger fields.

The attached updated version has Gulfstream and Tampa but I had to remove (over write) Turf Paradise and Golden Gate to fit those 2 tracks in.

IT only works with eBet tracks. I did this to get away from using TwinSpires where one has to log in to get to the tote.


mabred,

I never wrote a tutorial other than what is contained in this thread. Guess I should add a Help Page. If you have any specific problem, let me know.

[netbet]

Ray,

Thank you for the update.

Patrick

[u2popmart]

ray,
is there a way of recording the history of the win odds,alt odds and dr z place everytime you update. with the conditional colors at that recorded time.

thanks.


Win Odds 1382417/2617142112Alt Win Odds by Ex Pool18/17/22/145/17/245/14/119/120/19/1Morning Line Odds1045207/2156121212DrZ Place% Expectancy89%87%89%77%79%90%121%82%83%92%

[Ray2000]

u2popmart


Not automatically, sorry.

You could copy cells A8 thru L11 then

go down to about cell A50 and Paste Special Values.... ( Home>Paste>PasteValues in Excel 2007-10 )

Go back and select the same range for copying format and 'paint' the copied data below to make reading easier. Formatting that range only needs to be done once. Then repeat pasting below that for the next update.

BTW

The Dr Z method says..quote

"Bets are made when the estimated expected return on a dollar place or show
wager is greater than 1.14 for major racetracks and 1.18 for minor racetracks and when the
odds are less than or equal to 8-1."

On this sheet, the values (in row 11) for Place % Expectancy turn Green if > 1.15 but do not take into account the 8-1 odds criteria.

[u2popmart]

i been using your spreadsheet. i use for tb. i keep getting beat by the horsses outside the 10 post.
is there a way to expand it 5 more to include horses up to the 15 post. if is too much work. just let me know what area of the spreadsheet can i modify to include o make the change.
thanks again.

[Ray2000]

It's not just a range of cells that needs expanded, the macro does a 'sort' on 10 to find the crowd's top 3. It will need changed also.

I've been meaning to redo it anyway to add some other features, so I'll put up an expanded version in a few days.

[u2popmart]

thanks ray .

[u2popmart]

Ray,
if i may . May i make a suggetion.
There was a spreadsheet that i once downloaded. It had a automatic refresh option. i have the spreadshhet and the code for it i just dont know how to apply it to yours. is this something you think you can do. i could forward you the spreadsheet.
thanks

[beaucap]

Ray,
if i may . May i make a suggetion.
There was a spreadsheet that i once downloaded. It had a automatic refresh option. i have the spreadshhet and the code for it i just dont know how to apply it to yours. is this something you think you can do. i could forward you the spreadsheet.
thanks

Look what you got us into now Ollie...........:bang:

[Ray2000]

Funny one, Bo :D



u2
I have that feature on the version I use, so I can put it in there fairly easy. Though it might get a little cluttered .
.

[MightBeSosa]

Only a madman could create something like this

http://img94.imageshack.us/img94/7928/88789876.jpg

[JJMartin]

It's not just a range of cells that needs expanded, the macro does a 'sort' on 10 to find the crowd's top 3. It will need changed also.

I've been meaning to redo it anyway to add some other features, so I'll put up an expanded version in a few days.

I have some formulas that can address the sorting part which would eliminate the need to sort if you want, I already tried it on your imports sheet.

[Ray2000]

Thx for the suggestion, jjmartin

Thinking back when I was on version 1.0, I briefly tried using ranking formulas and was having trouble with the imported data not being placed in the same range or not being in all text or number values. (can't remember which) at which point I went to doing the job in VBA. Also, that's the reason for all the 'offset' function use in the formulas.

[formula_2002]

I've been down loading the live twinspires straight and exacta pools for about two years and have hundreds if not a thousand or so excell files.
most files were down loaded with 1 min to post.
here is a bit of a file sample..
Not betting, while looking for a long term profit, has saved me thousands of dollars, and I think it will continue that way for some time :)

[Ray2000]

formula_2002

The board watching spreadsheet that I use also goes to twin for the data. I put this sheet up (using ebet) for people not familiar with importing data, so as to get away from requiring an account and logging in, password. etc. Twin has a better slate of tracks and more reliable data table format. (and they give the base price 1$ or 2$ for Exacta probs)

[JJMartin]

Thx for the suggestion, jjmartin

Thinking back when I was on version 1.0, I briefly tried using ranking formulas and was having trouble with the imported data not being placed in the same range or not being in all text or number values. (can't remember which) at which point I went to doing the job in VBA. Also, that's the reason for all the 'offset' function use in the formulas.

ok, I used the last file you posted on 12-5-12, added code to imports sheet range Q53:Q72, R53:R72 and moved the favorites named ranges to the S column and added a vlookup code to those ranges. Seems that excel is able to detect the numbers as numbers although they look like text (range E53 and down). The code I added will cover 20 horses if needed. I did not change anything in the VBA.

PS: the formula was designed to compensate for any ties in the pool so as to not confuse the vlookup; the rank will therefore not have any ties but will rather rank the 2nd and any subsequent ties in ascending order according to the post.

[Ray2000]

Excellent, thanks for your input.

I'll incorporate the formulas in my next update and get rid of the unnecessary VBA code segment.

[Ray2000]

Done for today and won't be around tomorrow...

I'll make this update available as a beta test, still not complete, I want to see if file size is too big for PACE. May have to use a file-sharing site.

File name change ---> BoardWatch.xls

It's good for 15 starters

Has drop down selector for Harness or T-Bred

Saves Win Pool history (amounts)

Has an auto refresh (use "q" to exit, adjustable interval)

Uses JJ's formulas, (had to relocate them, macro was clearing that region)


Still needs some Track Take-Out's, base multiplier for Probables and a Help/Info page.

and a way to stop the letter "q" from appearing in cell A1 :D

[u2popmart]

thank you ray for your hard work . im grateful . and all others that help out too. looks good. the auto update is great work. keeps you from being tethered to your computer.

[Ray2000]

JJ

the formulas failed on some scratch races. see Penn National R3

You can look at completed races up to 6 am the following day.

might be because I have the sheet saved in 2003 format for people using older Excel
that version doesn't have the function.... iferror()

The attached version goes back to macro sort method.

[JJMartin]

JJ

the formulas failed on some scratch races. see Penn National R3

You can look at completed races up to 6 am the following day.

might be because I have the sheet saved in 2003 format for people using older Excel
that version doesn't have the function.... iferror()

The attached version goes back to macro sort method.

Checking now...

[JJMartin]

Ray, it was the scratches - I had the formula so it would count the number of entries starting from cell E53 which is post #1 from the pool side, I changed it to count only from the entries side (starting cell D53) so now the scratches won't effect it and I removed IFERROR, that should fix it.

[Ray2000]

Ok, thanks

It goes back in the final version..... :)

[u2popmart]

ray,

i have a twin account .
what web address do i need to change to get there?

[Ray2000]

ray,

i have a twin account .
what web address do i need to change to get there?


It's not just an address change. The track codes are different and this spreadsheet wouldn't work at all with Twin.

If you're familar with building spreadsheets and Visual Basic you might find this PACE thread helpful for Twin.

http://www.paceadvantage.com/forum/showthread.php?t=61958


Back in 2009 I posted a reply (#11) in that thread which offered a tiny quick Harville using CBedos instructions for getting web data.

GL & Happy Holidays

[u2popmart]

thanks

[Ray2000]

Hopefully this is the final version :)

If anyone finds serious errors let me know.

I've updated all Takeouts, as best as web data will allow

Verified many but not all Exacta Base Prices $1 or $2

Corrected some errors, max entries is now truly 15 not 12

Added a "Help" page

Added "Average" Place Prices in addition to Minimum Place Prices

Added Wind speed and Wind direction, relative to Stretch Direction.

Added BridgeJumper Alert



I wonder if Jumpers are using the Place Pool now because of no rebates on negative Show Pools. :confused:

[mabred]

sweet
thanks ray

mabred

[Ray2000]

PM request for a
Fix on Bridgejumper alert

Changed Color formatting on Exacta Will Pays

no other changes.

[hyipro]

e bet usa now part of penn national gaming, so the sheets do not work ???
any other site where I can pick up the data and change the sheet ???

[Ray2000]

hyipro

Yes, that ebet change has messed me up on getting current race results WITH Scratches.
I can always log into my ADW but that's not as convenient.

As for pulling the exacta info, I put up a slightly different version for comparing ROIs on any 3 picks in different structures. box, keybox, straight etc.

That spreadsheet uses "SuperTote" by brisnet.
You will need an account but it's free.

Here is the link to the PaceAdvantage post.

http://www.paceadvantage.com/forum/showthread.php?t=132121

If you download, don't use the ge.tt site, instead use the attachment at the bottom of that thread.

Best_Exacta_Combos.zip (80.0 KB, 54 views)

The "Help" sheet has more info.

GL

[hyipro]

Thank you so much ............