New Updated Spreadsheet and Filters for SET & FORGET Strategies
-
Hello everyone,
I have continued adding data and I done a deep dive on new years day, changing odds and tweaking leagues. Below is my up to date spreadsheet along with the updated filters. Hope it can be of interest. If anyone can see anything that I am missing that could improve them, that would be great.
Kind regards Vince. -
@Vince-Kavanagh this is really interesting work, I've commented before on your ELO back away strategy, but a BTTS strategy is one really want to develop and use! I guess it goes back to my younger days of dropping into the local bookies on a Saturday morning and putting on a £2 goals galore coupon! Keep up the good work!
-
Seems to becoming a common theme throughout Jan, where everyone is down somewhere. Winter blues on the players perhaps? Shouldn’t be on those salaries!
-
Hello everyone, hope you are all well?
I have updated my results for January, not as good as I would have hoped for. The ELO Back Away team is down 11 points on the month for the first time. The others had a little profit, very minimal though, but overall a very slight profit combined. On to this month of Feb -
@Andrew-Gray Thank you. It would look more tidy if I could do that. Thanks for your help. Its a true refection of my results now, with the 2% commission off each bet. (I couldn't work it out, went on google sheets formula strategy generator) not very spreadsheet savey
-
@Vince-Kavanagh Looks good as you've done but if you wanted it in one column you could just do:
=IF(I5=1, (G5-1)*0.98, -1)
That will work on all of your "back" strats. For lay ones you will have to reverse the equation to work out the liability lost when the lay "loses" and it's just 0.98 for every "win"
Hope that makes sense
-
@Vince-Kavanagh I'm the sort of numpty who just does it manually
-
@Andrew-Gray. Hi there sorry to message again. I think I have figured out a formula for the 2% deduction, will run through all my sheets and update in the next day or so. Thanks again for pointing this out to me.
-
@Andrew-Gray I have tried to do that but it has come up error, shall I do another column next to it to get the -2% commission. I would prefer to work it out with just the one column though. Thanks if you can help.
-
@Andrew-Gray Will do that, thanks for letting me know, sorry I didnt get back sooner.
-
Quality stuff Vince thanks for sharing.
One thing I did notice is that you are just taking off 2% of your total profit but that is not how Betfair commission works in real life, they will take 2% off of every winning trade. So you might want to add that in the individual sheets for every bet (Simple enough just add "*0.98" to every profit cell formula)
Because think about it if you win 10 £1 bets at evens and lose 10, you would say that you made 0 with your current formula, when in fact you would be losing 10*0.02 = 20p because of the commish on the winning bets.
-
@Rudra-Radasandaran Thanks for your reply, I am pleased that my spreadsheets could help.
-
@Simon-Bates I haven't thought of doing the Home ELO, I will have a look, but I think the odds might be too short as they are playing at home. Its defiantly worth a look at though. Thanks for your reply.
-
@Vince-Kavanagh sorry don't have a lot to add with things you can improve but it was really interesting seeing the information you are capturing in your spreadsheet. It highlighted how I need to be capturing a lot more information to be able to test my strategies better
-
Hi @Vince-Kavanagh your ELO rating filter for the away team, have you ever reversed the ELO home and away filters to turn this strategy into an ELO rating for the home team and favour the win for them.
-
@Vince-Kavanagh 100%
-
@Vince-Kavanagh you can but still keep the % small in terms of bankroll, I use 0.5% stakes personally (though when laying the liability can go up to around 2.5%)
-
@Vince-Kavanagh let her win?