Matched Betting May Update
May has been a quiet month for me with regards to matched betting. I have been busy at work with overseas business trips and also a holiday which means I only spent 14 out of 31 days at the screens, yet I have far exceeded the profit I made in April. Read on to find out how it went.
The screenshot below shows the offers screen in the excellent Profit Accumulator site that I am using to help guide me through the matched betting maze. At the time of writing there are 15 beginners’ offers, of which I have completed 12. I have purposely not done the 3 remaining ones as they require a large stake in my exchange accounts that I don’t have at present.
In the advanced offers there are currently 34 of which I have completed 14. The casino and bingo offers have been left untouched so far. I have placed a number of reload bets as and when they have come up.
I made a decision not to deposit any of my own money into any of my accounts during May – instead I’m using my profits to grow the accounts. This has been largely successful although I came a little unstuck towards the end of the month when several of my lay bets at odds between 6 and 12 all won and depleted my Smarkets and Betfair accounts. The winnings now in my bookies accounts took 2-3 days to transfer out so I that limited my betting during this time.
This quiet period gave me the opportunity to look a little closer at the reload offers and create a new tracking spreadsheet. Once my betting exchanges had been replenished I took advantage of a handful of the simpler reload offers and made some nice profits on them. They are a lot more work for the rewards on offer but still profit is profit. I took William Hill up on their Euro16 offer by backing England to win the whole competition. I placed a £10 bet and layed it off so I will make a 26p loss either way. However, I will get a free £5 bet every time England wins. Betting on England to win a game of football in a major tournament is asking a lot, however surely they can muster at least one win which will see me into profit.
How do I keep track of my bets?
Keeping track of all my bets was starting to become a handful. I searched the internet and on the Profit Accumulators forum for a good spreadsheet that would satisfy my requirements. My search was in vain so I took the good bits from the various spreadsheets that I had amassed and created my own.
It is still very much a work in progress but thought I would give you an insight to how it works here and see if anyone has any ideas for improving it and if there is any interest I will share it.
Sheet 1: The bank
The first sheet is the bank and tracks all transactions in and out of each account. This is a simple manual process of inputting the date, account and whether it is a deposit or withdrawal. The balance is a simple total generated by a simple autosum formula.
Sheet2: Log sheet
The next element is the log sheet where details of each bet are recorded. This is the hub of the whole spreadsheet and where all the profit data is pulled from. Here I record all important aspects of the bet including dates, the event itself, what the bet is for, who the bookie is etc. The sheet calculates the risk, potential return and the bet profit. I have added an “Actual Profit” column where I can manually enter the profit as I have found on a few occasions that the calculated profits are a penny or two out. I contacted Smarkets about this and they told me that their odds are only shown to two decimal places and this is the reason for this small discrepancy.
Sheet 3: Monthly profit summary
One of the key elements that I wanted to see was an overview of my monthly profits that would automatically update with no input from myself. The table below is my current incarnation and actually shows my real profits. The profits in March are from the last week only as that is when I started.
Sheet 3: Daily profit summary
The next element that I wanted was an overview of the daily profit summary. The image below shows an auto updating screenshot for each day of the month. This is my favourite part of the spreadsheet as it shows me how I am progressing daily.
Sheet 3: Account summary
The account summary is an auto populating sheet that shows the account balance and profit/loss for each account as well as the overall totals for my matched betting adventures.
As you can see in total I have put £525 into my accounts and made £823.54 profit. I haven’t monitored my screen time during May so don’t know what my hourly rate is, however £552.07 is a nice profit and I am determined June will be my best yet as I more time to spend on it.
There are a further two sheets to the spreadsheet. One that that tracks the bets that I have signed up to and any time limits or special conditions that have to be met. I then colour code them as I progress through them. The second sheet is to keep a record of my sign up details to each account.
Is it still worth doing?
After my first month of doing Matched Betting the answer was a resounding “YES”. After my second month I am even more convinced. Not only is it a very easy way to make money, I also find it very enjoyable. As always, I would urge you to do our research and bet responsibly. If you have any questions, please get in touch.[thrive_leads id=’1426′]