Not long joined this site, so thought I'd start by posting details of my Ultimatcher spreadsheet.
4shared.com - online file sharing and storage - download UltimatcherV2.xls
Ultimatcher is a matching spreadsheet I wrote that controls all bookie balances, banking balances, multi-currency matching, dutching etc etc.
Full instructions are contained within the spreadsheet. The full discussion on this spreadsheet can be found on MSE at Ultimatcher.. Version 2 now available! - MoneySavingExpert.com Forums
So I don't have to re-write everything... here's what I posted on MSE for the new version2:
Update From Version 1
If you use my Version 1 Ultimatcher, and don’t want the hassle of inputting all your information into Version 2, a button on the Control page will move the information for you (If you’ve changed version 1 in any way, it MAY not work). Also, note that Pending bets and banking information will not be transferred. Your version 1 file will not be overwritten in any way.
3 Bet Matching Sheets
There are now a total of 3 bet matching sheets, enabling you to queue bets that haven’t been fully matched on the exchange.
All foreign currencies are now handled precisely. All bank and bookie balances are stored and calculated in their own respective currencies.
The new Multiback sheet (Grumbiliser), now contains many more Asian handicap betting options.
New Banking System
The banking page has been totally overhauled. You can now add as many banking options as you require (unlimited)
Remove a Bank / Remove a Bookie
You now have the facility to remove a bank or bookie from the list. (Option available on the Control Page)
Optional Bet Labels
Do you do Matched Betting for other people? Need to be able to locate these bets quickly and easily to calculate the profits? Using the optional bet labels on the bet matching sheets allows you to find these bets again easily by using the filter buttons on the log page.
Clear Screen Buttons
Added for ease of clearing the screen.
Save button added to the Control page, allowing you to save your Ultimatcher to a different file for each day of the week, so keeping 6 backups at any time. (Option to save to just one file)
New Stats Screen
Shows all the stats for your sheet, including a graph of bookie profits.
Auto Exchange Rates
Exchange Rates are now automatically updated from the internet every time the spreadsheet is opened. If you don’t have access to the internet, you can turn this function off and manually specify the rates.
Add URL to Bookies
You can now add a URL hyperlink to your bookies, so that when you click the name of the bookie, it takes you directly to the site!
3 Custom buttons allow you to pre-fill information on the Bet Matching sheets. Handy if you make the same bet / type of bet regularly.
New “Settled Odds” on the Pending screen
If a bet is settled at different odds from when you placed the bet, you can now specify the settled odds so that all your balances are kept accurate.
Bank Account Adjustment
You can now add or subtract funds from your bank balances (if you spend some or accrue interest)
Match Side 'Same' Buttons
If your Match Side bet is the same as your Back side bet (when you back and lay), click the “Same” button. The selection name of the Back side will be copied into the Match side.
Please feel free to use this one (Optional of course). Considering the version 1 has had nearly 2000 downloads, I can see it’s well used. A lot of time and effort has gone into this, and will continue as new features are requested (version 3 will follow).
... plus many more changes.
Instructions are included within the spreadsheet.
All pages are protected to stop you accidentally overwriting any formulas. If any errors are found, I'll post update files that will automatically update the spreadsheet. Because of this, it'll be best if you do not change the sheet in any way. If you do, the updates will probably not work correctly.
I have tested it as much as I could be arsed to, and think I have ironed out any glitches. If there are any errors, please let me know and I'll upload an update file to correct them (the update file will correct the errors without you having to re-download the spreadsheet and put your details back in).
If you have any requests for features, post them on here and I'll look into including them into Version 3.
Hope you find it useful.
I vouch for this spreadsheet! If you haven't seen it for yourself then you should. Amazingly useful piece of kit which has obviously had a hell of a lot of work put into it. It really does make tracking your matched betting history fun!
Thanks for the post thegoon, didn't realize you were over here already
Yes I would highly recommend this spreadsheet - whilst I don't actually use it, I would do if I were starting out from scratch (and am thinking of using it for tracking my brother's match betting progress).
I started using version 1 just after xmas - very very good
Will have a look at home later but glad to hear about more asian handicap options - sometimes took a bit of working out how to bet just using the +0.25
I can't recommend this enough!
For those using version 1, get v2 and upload all data from your first spreadsheet!
I've just downloaded it and will start using it soon. every thing is a big mess at the moment. I'm finding it hard to keep track of all my matched betting activities so the Ultimatcher should help.
Me too even though I'm using such spreadsheet!
Originally Posted by sofaking
It's my own fault of rushing through 8 horse bets in a couple of hours and not enough Excel TLC means that now none of my bookies balance with my spreadsheet!
I wish i had something as good as that when i started. Infortunately im a bit set in my ways now and wouldnt be able to adapt. It looks like it would be great though and has certainly had a lot of time and effort put into it. Thanks for sharing.
Have a plan and stick to it
Well ive got two probs now ... one minor one a pain but not to bad
When adding banks i added a misspelt Moneybookers ... easy enough delete on the control page ...selected it, it deleted off the 'Bank Details' .... but remained on the credits side of the statement - more annoying/bugging me seeing it there but not really a prob
the pain is i dont know how to save it lol
Sussed out why it didnt save before ... but dont have a clue what a control path is as such
I think ive found the full path by going to properties (but not a clue if thats the whole of it)
C:\Documents and Settings\Rob\My Documents\MB stuff
and im either going blind or downloaded the wrong one but ive only got the one save button on the control page
looks a bit like this at the bottom right of the control page (underlined are buttons)
'Bank Box' 'Remove Bank'
'Update from V1' 'Save' 'Show Instructions'
still absolutly loving the whole lay out etc of the sheet though but like all new things they can be a bit of a pain to start with