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