Hey there! I hope you have found this video and the spreadsheet helpful! Once you have saved your free spreadsheet: docs.google.com/spreadsheets/d/1I0s_3FK3R_RtqSh_k4Jc9znVoPTjR_RI6KfxMshweKc/edit?usp=sharing please head to the Welcome Offers guides to make your £600 profit risk free: www.teamprofit.com/welcome-offers-list Any questions please do add a comment and I will do my best to help cheers!
Wow, fantastic. How accurate is the built in calculator compared to profit accumulator calculator? Basically, does it give accurate liabilities and lay bets? It looks great
Hey Samuel! Great to hear you like the look of the spreadsheet. The built in calculator gives fully accurate liabilities and lay stake amounts, it'll be the same (or within 1p due to rounding) of any calculator such as OddsMonkey or profit accumulator! Any questions with this please do add a comment thanks!
Can you use this spreadsheet with the smarkets offer that you bet on 5 premier league football games and if you lose they credit your £10 stake back? Cheers
Hi there! We haven't updated it for the new Smarkets offer unfortunately - however you can fill out the offer as a spare bet in the refunds tab :) Hope this helps Tom
This looks amazing! One question.. what happens if the join up offers have changed.. e.g. Skybet has a free no deposit £10 bet now instead of the play £5 get £20 free bet offer... Can I just change the textbox on SkyBet from "£20 free bet" to "£10 free bet", ignore the £5 qualifying bet row and fill in what happened with my £10 free bet and it all still works? I'm not Excel-savvy... would it mess up any of the formulae used to calculate things automatically? Thanks for the help!
Hi Rebecca! Great to hear you like the spreadsheet :) I update the offers in the spreadsheet every time an offer changes, so when you open up the spreadsheet from the google drive link then it should have all the up to date offers (for example, it now has the £10 no deposit offer for SkyBet rather than Be £5 Get £20). Should an offer change after you have started using the spreadsheet, if you're not comfortable with changing the formula yourself no problem! Just share your spreadsheet (using the top right Share button) and send it to me either via Live Help on the website or to support@teamprofit.com and I'll edit it for you no problem :) Any questions with this please let me know and thanks for your comment!
I tend to use Betdaq due to it's leading 0% commission however I do not know if you can add another row to the exchange table- good idea this spreadsheet is though- but I think I'm just going to make a list of my withdrawals and deposits from my bank account
Never really used Betdaq myself as they stung me a few years back and didn't honour a promo. Smarkets have 0% if you're with Oddsmonkey, and Team Profit has 0% with Matchbook at the moment :D Tom
so on my ladbrokes 4 free 5 bets there is no room is the column to add all my bets ... waste of time spent half the night clicking around on a spreadsheet instead of making money
Hi, i have come across your speadsheet and it looks good. I currently use pocketbet and matchbook for my exchanges. Is there anyway of adding these to the spreadsheet. I tried to but it messed up the formulas thanks
Hi, was wondering, I know the mug betting appears to be open to opinion, however if I wanted to do the odd mug bet, how could I integrate it into the spreadsheet, many thanks, Mart.
Hey Sjohno98! Thanks I'm glad you like it. If you have a question it may be best hopping on our live chat, or email help@teamprofit.com . We can answer a lot quicker for you :) Tom
Another question... the Exchange used on all of these is Betfair with 5% commission... If I did an offer with a different Exchange e.g. Smarkets with 2% commission how could I change the 'rule' so that it works it out with the different commission rate? Thanks
Hey Rebecca! Ah we missed this out on the first recording, please see the second short video here: ruclips.net/video/uXlVD-KLRI4/видео.html In summary though, simply change the name Betfair to Smarkets and it automatically applies the 2% rather than 5% commission :) Any questions with this please let me know and thanks again!
I tried changing the name from Betfair to Betdaq. Nothing happened, still says Betfair! Suggest this space is left blank for clients to enter the exchange of their choice.
Hey! I think there is a mistake on the spreadsheet on cells P59 and P60 on Bet X Get Y sheet. They are supposed to be Betdaq and K8 but in the formulas next to them they are linked to Royal Panda and Betsafe.
Hey Team profit, I will be doing mug I was wondering how it would be possible to extend the spreadsheet? I will be placing mug bettings quite regular and will soon run out of space. Many thanks in advance :)
@@TeamprofitUK hey figured it all out, I'm just left scratching my head as tk how to add another exchange, specifaclly Matchbook, that does not seem as straight forward as adding more rows , thanks:)
Hi there! Thanks for the compliments! :) I've just tested it and seems to be showing 5% for me. Can you check the "Welcome Offers Bet X Get Y" tab and see if Cell U10 is displaying 5%? Because if you have that set to 0% then it'll show all Betfair results as 0% :) Cheers Tom
Great spreadsheet. Thanks for giving it to us. What do we do when offers change? Eg, Skybet offer on spreadsheet shows "bet £10, get £40 free bets". Right now, they are offering "bet £5, get £30 free bets". Where would I put my £5 trigger bet?
You would still use the spreadsheet, just put the new numbers in to overwrite the original ones, as it uses the same formula and goes off what you input :)
Hi Lula! If you scroll to the bottom of the bet x get y tab, there are plenty of spare bets rows. So you don't need to add anything in, just use these :) Hope this helps!
Hi Frank! You can use smarkets on the spreadsheet by simply changing the word "betfair" to "smarkets" on the column B for each bet. This will automatically change the calculation to accomodate 2% commission! Unfortunately we haven't set it up for Matchbook though! Hope this helps :)
Hey Frank - we have a guide on this! vimeo.com/258228223 What we're doing is replacing the 0.98 calculations all over the spreadsheet with 1.00! Hope this helps! :)
hello im having trouble making a copy on a MacBook, it makes a copy on my drive but I am unable to locate it.is it ok to open in Microsoft excel, would this be ok? thanks frank
Hey Frank! It's completely fine to open in Microsoft Excel - Google sheets and Microsoft Excel and pretty much compatible on the whole. You shouldn't find any glitches as it just uses formulae which works on both platforms :)
hello just wanted to ask one more thing the calculator, calculates the lay liability and p/l slightly different to the oddsmatcher and bookie calculator, is it something that I am doing wrong?
Great spreadsheet and I'm looking at moving over to this from my own one - been match betting for about 4 years on and off. But I'm struggling to see how I can log ACCAs on it. I'm laying each game off separately in Smarkets. Any ideas? Thanks
Thank you for your comment Joe! We have a spreadsheet for accas here (method 2).www.teamprofit.com/laying-accas Then once the acca is complete, you can log it in the reloads second of the profit tracker spreadsheet :)
Hi there Guy. Are you able to email us with screenshots at help@teamprofit.com? We would be happy to take a look at your spreadsheet to see what went wrong :)
It shoudn't. Make sure to never use your overdraft or a loan to fund your matched betting as this could have an impact. But otherwise it shouldn't. There will be soft searches made but only you will be able to see these on your credit report. :) Here is more info www.teamprofit.com/mb-credit-and-mortgage
Hello, very nice this video. But if i have win a freebet from a past acca bonus insurance and i must bet this free bet again only with acca, what calculate to use?
I must use SNR because if i lost the acca the bookmaker will not give me other freebet, i must have profit from lay bets in betfair betting one by one the legs, right?
@@TeamprofitUK If you fill out a spare trigger bet at bottom of the sheet I'm assuming you can insert more lines and copy contents down, seems to work and formula's copy but just thought Id check.
@@TeamprofitUK Also can you rename the Trigger bet cell without it affecting anything, can't see any formula doing lookup in B:B but I may have missed something....thanks
Hi Daren - thanks a lot, glad you're enjoying it! We recommend Oddsmonkey as being the best paid matched betting service and have a £1 trial running at the moment for 7 days of premium membership here, www.teamprofit.com/oddsmonkey-trial If you're just starting out with matched betting and not yet moved onto the 'reload offers' then Team Profit has everything you need for 35+ welcome offers :) for free! Hope this helps!
Hello! My Total Profit and Net Balance are different, does anyone know why that might be and/or how to fix it? I found the offer from where the discrepancy started. It's one of the spares for Trigger bets. When I put in 'win' the profit goes higher than the Net Balance, if I put 'lose' it goes the other way. Is this supposed to happen?
I found the culprit for this one - if anyone else has this problem, make sure you check the formulas for that bookie in the columns Q, R and S and changed the formula to add the spare in all of them :)
I noticed an error in your spreadsheet. When I enter a bookmaker current balance in the spare 1-3 slot, it will show up in the wrong slot on the balance tracker. Can this be fixed?
Hey skygem thanks for your comment, please could you share your spreadsheet (click Share on the top right then Copy Link) and send it the email address listed here: teamprofit.com/contact-us (I don't think RUclips allows adding an email address in a comment) and I'll take a look and will fix any errors in the master version too! Thanks again :)
Hi there. If there are single bets and the match is cancelled, you would get the cash back from bookie and exchange. So yes, you can delete all inputs. :)
So I've just started on MB and using the spreadsheet but what do you do if you keep a balance in your exchange account and use this for your other bets rather than depositing/withdrawing?
@@TeamprofitUK Hi, I finally got the hang of filling it in but i do wonder if I've gone wrong somewhere as my profit and net balances are different figures, with my net balance showing £146 higher, any ideas why that would be? Also the paddy power offer i have on my sheet isn't matching the same lay stake & liab i got on smarkets? Why could this be?
Hi there Chris Please help me. I need to know how to change all the betfair exchange to smarkets as i only use smarkets. I dont want to mess up the formulas. Also with the offers, some have changed since this spreadsheet came out so need to know how do i add rows for more free bets? eg sky bet has three £10 offers yet i have no space to fill them in and get correct calculations. Im so confused and stressing. Please help me sort this out.
Hi Tayla! Not to worry. All you need to do to change the spreadsheet to smarkets is change to part of the formula where it says 0.95 to 0.98 if you're on 2% commission on Smarkets. If you're on 0%, just change it to 1. :) Any offers that you have that don't fit in the welcome offers section, you can simply add them to the reloads sheet. If you need anything else, do give us a shout! :)
@@TeamprofitUK Thank you for replying. I am still really confused on what i need to do on the spreadsheet. I am on 2% commission. Will i have to change every bet i do or can i edit one section for them to do all the bets the same?
In the back stake box, when I type 2.5 as in a £2.50 bet, it rounds it up to £3. Iv tried every back stake box and it always rounds the back stake up to a round number. Any ideas why?
Hey Dirt! Not too sure why that's happening. Im not sure if it's actually rounding it up properly, it may just be showing as £3 however when the formula works out it goes off the £2.50. I could be wrong - but either way it shouldn't be showing £3! Are you able to email into help@teamprofit.com and we can take a look for ya? Cheers! Tom
@@TeamprofitUK Thanks for the reply. One more question, is there a way of inserting RISK FREE BETS into this spreadsheet, as in if your first bet loses you qualify?? Just seems to be for the normal bet x get y?
the liability says 6 euro on my betfair but 5.72 on the spreadsheet, why is that? all the info matches up so idk why I'm getting different values, I converted it too and 5.72 gbp is well over 6 euro so
Hi there. Did you enter the right commission in the calculator? If you can send us an email at help@temaprofit.com with screenshots, id be happy to take a look for you :)
@@TeamprofitUK Okay nevermind it was just a weird bug I guess with the coral one, every single other one works PERFECTLY, god this is sooo helpful to keep track of everything, can't thank you enough
Sorry I forgot to add that if you want to get help we have various ways to get in touch, found here - www.teamprofit.com/support alternatively you can ask any questions you have here on RUclips :)
That's absolutely fine! In the formula, you then just need to amend where it says 0.95 (5% commission at Betfair) to 0.98 (2% at Smarkets). Then it should all tally up! :)
Hello! Please go to this page: teamprofit.com/matched-betting-spreadsheet/ and click the blue link 'Click here to get your matched betting spreadsheet.' Once you have opened the spreadsheet, to create your own version, click File > Make a copy > Okay. Please note it is hosted in Google Drive rather than being a download. Hope that helps and any questions please add a reply thanks!
Hi Safsum - sorry for the late reply! On the Profit Tracker spreadsheet you can change the word "betfair" to "smarkets" under the trigger bets and free bets and it will automatically change the calculation giving you 2% commission instead of 5%. Hope this helps - feel free to add a comment if you need anymore guidance :)
Hi George - no the currencies are not interchangeable sadly. Do you have different accounts in different currencies or are they all in a different currency to GBP? Cheers!
Hi Trevor Moy - the spreadsheet loads to google docs online, but then you can download your own version to your browser by following the steps found here :) teamprofit.com/matched-betting-spreadsheet/
I’m trying to view this on an iPad, I’m tapping the bottom right box to expand the video to be able to read the print. But it’s not expanding, is it me?
Hi there! Do you mean this link is showing as blank? docs.google.com/spreadsheets/d/1I0s_3FK3R_RtqSh_k4Jc9znVoPTjR_RI6KfxMshweKc/edit?usp=sharing&pageId=114437264312274508919 Have you clicked onto the 2nd tab on the document? Cheers, Jon.
Morning Erik - ah yes sadly the bookmaker offers will vary from country to country and we only really focus on the UK & Ireland offers. Are there any good offers in Sweden, out of interest? Cheers :)
Hey Annoney Mouse, The first few offers will take a little while to get your ahead around, but with 30+ sign ups and far more daily offers then once you've understood it, it becomes an absolute gold mine :)
Punting can be fun but the websites offer you worse odds than the actual outcome. If something has a 1 in 5 chance of coming in, they should be offering you odds of 5.0. But they won't, they'll offer you 4.0 or 3.5. This is how they win in the long run! If you have any spare time then feel free to check out our video guides section which makes it a lot easier to understand and a lot less boring www.teamprofit.com/matched-betting-guide We'll walk you through all offers, and we have a live chat and email to answer any questions you may have. Our Facebook group currently has 5000+ members, and we are, and always will be FREE! :)
Hey there! I hope you have found this video and the spreadsheet helpful! Once you have saved your free spreadsheet: docs.google.com/spreadsheets/d/1I0s_3FK3R_RtqSh_k4Jc9znVoPTjR_RI6KfxMshweKc/edit?usp=sharing
please head to the Welcome Offers guides to make your £600 profit risk free: www.teamprofit.com/welcome-offers-list
Any questions please do add a comment and I will do my best to help cheers!
hi, i tried joining your Facebook group but i cant get through, emailed you guys 3 times got no response, is there something off?
Thanks for this. I've just started match betting and knew I would very quickly lose track of my money so this is a great resource. Thank you.
Hi Rebecca :) and welcome! Really glad you're finding the spreadsheet helpful! Get in touch any time you have any questions.
Wow, fantastic. How accurate is the built in calculator compared to profit accumulator calculator? Basically, does it give accurate liabilities and lay bets? It looks great
Hey Samuel! Great to hear you like the look of the spreadsheet. The built in calculator gives fully accurate liabilities and lay stake amounts, it'll be the same (or within 1p due to rounding) of any calculator such as OddsMonkey or profit accumulator! Any questions with this please do add a comment thanks!
Can you use this spreadsheet with the smarkets offer that you bet on 5 premier league football games and if you lose they credit your £10 stake back? Cheers
Hi there!
We haven't updated it for the new Smarkets offer unfortunately - however you can fill out the offer as a spare bet in the refunds tab :)
Hope this helps
Tom
This looks amazing! One question.. what happens if the join up offers have changed.. e.g. Skybet has a free no deposit £10 bet now instead of the play £5 get £20 free bet offer... Can I just change the textbox on SkyBet from "£20 free bet" to "£10 free bet", ignore the £5 qualifying bet row and fill in what happened with my £10 free bet and it all still works? I'm not Excel-savvy... would it mess up any of the formulae used to calculate things automatically? Thanks for the help!
Hi Rebecca! Great to hear you like the spreadsheet :)
I update the offers in the spreadsheet every time an offer changes, so when you open up the spreadsheet from the google drive link then it should have all the up to date offers (for example, it now has the £10 no deposit offer for SkyBet rather than Be £5 Get £20).
Should an offer change after you have started using the spreadsheet, if you're not comfortable with changing the formula yourself no problem! Just share your spreadsheet (using the top right Share button) and send it to me either via Live Help on the website or to support@teamprofit.com and I'll edit it for you no problem :)
Any questions with this please let me know and thanks for your comment!
I tend to use Betdaq due to it's leading 0% commission however I do not know if you can add another row to the exchange table- good idea this spreadsheet is though- but I think I'm just going to make a list of my withdrawals and deposits from my bank account
Never really used Betdaq myself as they stung me a few years back and didn't honour a promo. Smarkets have 0% if you're with Oddsmonkey, and Team Profit has 0% with Matchbook at the moment :D
Tom
@@TeamprofitUK Strange, I think i just had a deposit bonus w/ Oddsmonkey's Smarkets sign-up, think I will stick with Odds Monkey ProfitTracker btw
OddsMonkey have given me 0% off betdaq, is matchbook worth it?
Yeah it's defo worth it, best to have all of the exchanges and 0% at them all if possible :)
How do i remove the commision from the betting exchange as I am on 0% commision at the moment
so on my ladbrokes 4 free 5 bets there is no room is the column to add all my bets ... waste of time spent half the night clicking around on a spreadsheet instead of making money
Great spreadsheet but one question can it be used with all sports or just football, I do horse racing as well as football and this seems ideal
Hi, i have come across your speadsheet and it looks good. I currently use pocketbet and matchbook for my exchanges. Is there anyway of adding these to the spreadsheet. I tried to but it messed up the formulas thanks
Hi, is there a way to use this on a phone or tablet.
I have the Google sheets app but it says view only and wont let me input any stats.
Hi Andy
You need to go to File > Make a copy , and you can edit this :)
Tom
Hi, was wondering, I know the mug betting appears to be open to opinion, however if I wanted to do the odd mug bet, how could I integrate it into the spreadsheet, many thanks, Mart.
Hey Mart! You can use the spare rows at the bottom of the sheet, and just treat them as trigger bets with no freebies :)
Tom
Hi, I'm not able to add anything on the spreadsheet besides the opening bet and the free bet. How can I add more rows for my next bets?
Hi, great spreadsheet I just have one question about inputting the smarkets £10 after first loss sign up offer. Thanks
Hey Sjohno98!
Thanks I'm glad you like it. If you have a question it may be best hopping on our live chat, or email help@teamprofit.com . We can answer a lot quicker for you :)
Tom
I would assume that if
you already have a Coral account you would have to create another to get the offer?
You won't be allowed to im afraid! One per person
Excellent tutorial. Well done! :-)
Thanks Julian - I hope you find the spreadsheet helpful :)
really helpful video and great spreadsheet, thanks
Another question... the Exchange used on all of these is Betfair with 5% commission... If I did an offer with a different Exchange e.g. Smarkets with 2% commission how could I change the 'rule' so that it works it out with the different commission rate? Thanks
Hey Rebecca! Ah we missed this out on the first recording, please see the second short video here: ruclips.net/video/uXlVD-KLRI4/видео.html
In summary though, simply change the name Betfair to Smarkets and it automatically applies the 2% rather than 5% commission :)
Any questions with this please let me know and thanks again!
I tried changing the name from Betfair to Betdaq. Nothing happened, still says Betfair! Suggest this space is left blank for clients to enter the exchange of their choice.
However, once I downloaded a copy of the spreadsheet for myself, I could then alter Betfair to another exchange.
Hey! I think there is a mistake on the spreadsheet on cells P59 and P60 on Bet X Get Y sheet. They are supposed to be Betdaq and K8 but in the formulas next to them they are linked to Royal Panda and Betsafe.
Thanks. I'll pass on your feedback to team! :)
Hey Team profit, I will be doing mug I was wondering how it would be possible to extend the spreadsheet? I will be placing mug bettings quite regular and will soon run out of space. Many thanks in advance :)
Hey Thomas - You can just add some more rows at the bottom! :)
@@TeamprofitUK hey figured it all out, I'm just left scratching my head as tk how to add another exchange, specifaclly Matchbook, that does not seem as straight forward as adding more rows , thanks:)
I have almost used up all the extra trigger bet and freebet lines. How do I add extra lines?
Hi Kenneth,
If you go to the Weekly Offers tab there is loads of extra lines for you :)
Thanks
Hi love the site/spreadsheet so far, but 1 problem
On the Reload offers tab Betfair seems to be using 0% commission on FB.
Hi there!
Thanks for the compliments! :)
I've just tested it and seems to be showing 5% for me. Can you check the "Welcome Offers Bet X Get Y" tab and see if Cell U10 is displaying 5%? Because if you have that set to 0% then it'll show all Betfair results as 0% :)
Cheers
Tom
Thank you for the reply. My match betting takes place in euro only. Would you have another template per chance?
Great spreadsheet. Thanks for giving it to us. What do we do when offers change? Eg, Skybet offer on spreadsheet shows "bet £10, get £40 free bets". Right now, they are offering "bet £5, get £30 free bets". Where would I put my £5 trigger bet?
You would still use the spreadsheet, just put the new numbers in to overwrite the original ones, as it uses the same formula and goes off what you input :)
yes, that works. Thanks v. much for replying :O)
How can I use if I use iPad only
I know this video is a little old now but does anyone know of the spreadsheet can be used on IPad?
how would i add in another row on the welcome offers bet x get y? In column B?
Hi Lula!
If you scroll to the bottom of the bet x get y tab, there are plenty of spare bets rows. So you don't need to add anything in, just use these :)
Hope this helps!
Can we use the insert row function, or will that mess up the spreadsheet?
hello , just wanted to ask if this can be tailored for smarkets or matchbook 0% commission. thank you
Hi Frank! You can use smarkets on the spreadsheet by simply changing the word "betfair" to "smarkets" on the column B for each bet. This will automatically change the calculation to accomodate 2% commission! Unfortunately we haven't set it up for Matchbook though! Hope this helps :)
thank you , it just that Smarkets are also 0% commission at the moment, can the spreadsheet reflect this.
Hey Frank - we have a guide on this! vimeo.com/258228223 What we're doing is replacing the 0.98 calculations all over the spreadsheet with 1.00! Hope this helps! :)
thank you
hello im having trouble making a copy on a MacBook, it makes a copy on my drive but I am unable to locate it.is it ok to open in Microsoft excel, would this be ok? thanks frank
Hey Frank! It's completely fine to open in Microsoft Excel - Google sheets and Microsoft Excel and pretty much compatible on the whole. You shouldn't find any glitches as it just uses formulae which works on both platforms :)
Really good spreadsheet, thank you
hello just wanted to ask one more thing the calculator, calculates the lay liability and p/l slightly different to the oddsmatcher and bookie calculator, is it something that I am doing wrong?
Hey Frank, are you putting the correct commission into the calculator? (so 5% for betfair, 2% for smarkets)?
yes i even followed your tutorial for making smarkets 0% , not sure whether or not i have done it correctly.
Hey Frank, did you want me to check it over for you?
Is there anyway to use this with different odds for same bet?
Great spreadsheet and I'm looking at moving over to this from my own one - been match betting for about 4 years on and off. But I'm struggling to see how I can log ACCAs on it. I'm laying each game off separately in Smarkets. Any ideas? Thanks
Thank you for your comment Joe! We have a spreadsheet for accas here (method 2).www.teamprofit.com/laying-accas Then once the acca is complete, you can log it in the reloads second of the profit tracker spreadsheet :)
Hi, please could you explain and help! My calculator for liability and lay stake doesn’t work, what can I do?
Did you ever find a solution? I have the same issue
@@EmpressSoul Where the box states 'Exchange', type in Smarkets or Betfair or whatever exchange you are using. it will work after that
what is the 40£ betfair? i dont understand that bit
i dont understand why u are comparing it to a 40£ to get lay odds? i dont understand what lay odds are either
This is just enough to deposit to cover all of your bets :)
when i add back stake, back odds and Lay odds the spreadsheet does not automatically enter anything into the Lay stake and liability boxes.
Hi there Guy. Are you able to email us with screenshots at help@teamprofit.com? We would be happy to take a look at your spreadsheet to see what went wrong :)
Very good tutorial.. QQ - will this method effect my credit score ?
It shoudn't. Make sure to never use your overdraft or a loan to fund your matched betting as this could have an impact. But otherwise it shouldn't. There will be soft searches made but only you will be able to see these on your credit report. :) Here is more info www.teamprofit.com/mb-credit-and-mortgage
Hello, very nice this video. But if i have win a freebet from a past acca bonus insurance and i must bet this free bet again only with acca, what calculate to use?
Hi there. You have to get the combined odds for the acca at the bookie and then build the acca on Smarkets and then use the free bet calculator :)
I must use SNR because if i lost the acca the bookmaker will not give me other freebet, i must have profit from lay bets in betfair betting one by one the legs, right?
You dont have to do one at a time if you build the acca on smarkets. Here's a guide that will help :) www.teamprofit.com/smarkets-lay-multiples
Can you use the spreadsheet for normal bet/lays ie without an offer
Yes you would just fill out a spare trigger and dont fill out the free bet part :)
Tom
@@TeamprofitUK If you fill out a spare trigger bet at bottom of the sheet
I'm assuming you can insert more lines and copy contents down, seems to work and formula's copy but just thought Id check.
@@TeamprofitUK Also can you rename the Trigger bet cell without it affecting anything, can't see any formula doing lookup in B:B but I may have missed something....thanks
love the spreadsheet, who are you affiliated to? I am joining a matched betting service but unsure who to join at the moment
Hi Daren - thanks a lot, glad you're enjoying it! We recommend Oddsmonkey as being the best paid matched betting service and have a £1 trial running at the moment for 7 days of premium membership here, www.teamprofit.com/oddsmonkey-trial
If you're just starting out with matched betting and not yet moved onto the 'reload offers' then Team Profit has everything you need for 35+ welcome offers :) for free!
Hope this helps!
Hello! My Total Profit and Net Balance are different, does anyone know why that might be and/or how to fix it? I found the offer from where the discrepancy started. It's one of the spares for Trigger bets. When I put in 'win' the profit goes higher than the Net Balance, if I put 'lose' it goes the other way. Is this supposed to happen?
I found the culprit for this one - if anyone else has this problem, make sure you check the formulas for that bookie in the columns Q, R and S and changed the formula to add the spare in all of them :)
HI, what about if you back to draw and lay to draw? you put win or lose? Thank you
Hi there. That is correct to do. What you back is what you lay so you would be covered :)
I noticed an error in your spreadsheet. When I enter a bookmaker current balance in the spare 1-3 slot, it will show up in the wrong slot on the balance tracker. Can this be fixed?
Hey skygem thanks for your comment, please could you share your spreadsheet (click Share on the top right then Copy Link) and send it the email address listed here: teamprofit.com/contact-us (I don't think RUclips allows adding an email address in a comment) and I'll take a look and will fix any errors in the master version too! Thanks again :)
Why is my total profit box not reacting to the values when I put win/lose
Hi there. did you enter all the info ie back and lay odds?
@@TeamprofitUK yes I'm on about row 200
hello, what do i put in the boxes if the match has been cancelled should i just delete all imputs as bets have been returned ? thank you
Hi there. If there are single bets and the match is cancelled, you would get the cash back from bookie and exchange. So yes, you can delete all inputs. :)
So I've just started on MB and using the spreadsheet but what do you do if you keep a balance in your exchange account and use this for your other bets rather than depositing/withdrawing?
Hi there. The spreadsheet would factor this in.
@@TeamprofitUK Hi, I finally got the hang of filling it in but i do wonder if I've gone wrong somewhere as my profit and net balances are different figures, with my net balance showing £146 higher, any ideas why that would be? Also the paddy power offer i have on my sheet isn't matching the same lay stake & liab i got on smarkets? Why could this be?
Hi there Chris
Please help me.
I need to know how to change all the betfair exchange to smarkets as i only use smarkets. I dont want to mess up the formulas.
Also with the offers, some have changed since this spreadsheet came out so need to know how do i add rows for more free bets? eg sky bet has three £10 offers yet i have no space to fill them in and get correct calculations. Im so confused and stressing. Please help me sort this out.
Hi Tayla! Not to worry. All you need to do to change the spreadsheet to smarkets is change to part of the formula where it says 0.95 to 0.98 if you're on 2% commission on Smarkets. If you're on 0%, just change it to 1. :)
Any offers that you have that don't fit in the welcome offers section, you can simply add them to the reloads sheet. If you need anything else, do give us a shout! :)
@@TeamprofitUK Thank you for replying. I am still really confused on what i need to do on the spreadsheet. I am on 2% commission. Will i have to change every bet i do or can i edit one section for them to do all the bets the same?
Can i not change all the betfair exchange to smarkets in the first colum?
In the back stake box, when I type 2.5 as in a £2.50 bet, it rounds it up to £3. Iv tried every back stake box and it always rounds the back stake up to a round number. Any ideas why?
Hey Dirt!
Not too sure why that's happening. Im not sure if it's actually rounding it up properly, it may just be showing as £3 however when the formula works out it goes off the £2.50. I could be wrong - but either way it shouldn't be showing £3!
Are you able to email into help@teamprofit.com and we can take a look for ya?
Cheers!
Tom
@@TeamprofitUK Thanks for the reply. One more question, is there a way of inserting RISK FREE BETS into this spreadsheet, as in if your first bet loses you qualify?? Just seems to be for the normal bet x get y?
@@XMO5000 Hello :) if you head to the "refund offers" tab, there are some spare boxes at the bottom. Hope this helps!
the liability says 6 euro on my betfair but 5.72 on the spreadsheet, why is that? all the info matches up so idk why I'm getting different values, I converted it too and 5.72 gbp is well over 6 euro so
Hi there. Did you enter the right commission in the calculator? If you can send us an email at help@temaprofit.com with screenshots, id be happy to take a look for you :)
@@TeamprofitUK Oh, how do I go about changing the commission? I thought it would be 5 percent for betfair, maybe they change it?
@@TeamprofitUK Okay nevermind it was just a weird bug I guess with the coral one, every single other one works PERFECTLY, god this is sooo helpful to keep track of everything, can't thank you enough
Hey there how do I find Jon and do you help customers by phone
Hey Ziem! Jon isn't really involved with Team Profit anymore - what did you want to contact him about? And no there is no phone line support sadly.
Sorry I forgot to add that if you want to get help we have various ways to get in touch, found here - www.teamprofit.com/support alternatively you can ask any questions you have here on RUclips :)
Can you send me a link to your Facebook group please
Hey Ziem,
Here you go :) facebook.com/groups/525981434223410/
Cheers
Tom
ziem khan shut up
Hi, what if you use Smarkets and not Betfair for any offers?
That's absolutely fine! In the formula, you then just need to amend where it says 0.95 (5% commission at Betfair) to 0.98 (2% at Smarkets). Then it should all tally up! :)
@@TeamprofitUK Hi, the Smarkets offer i've got is 0% - how might I ammend the formula to reflect this please?
where do you download spreadsheet from please
Hello! Please go to this page: teamprofit.com/matched-betting-spreadsheet/ and click the blue link 'Click here to get your matched betting spreadsheet.'
Once you have opened the spreadsheet, to create your own version, click File > Make a copy > Okay.
Please note it is hosted in Google Drive rather than being a download.
Hope that helps and any questions please add a reply thanks!
Could I use this spreadsheet right now in 2021
You can yes. You can access it here our site www.teamprofit.com/matched-betting-spreadsheet :)
Ladbrokes has 4x £5 free bets, any way to change the spreadsheet to this?
We are looking to update the spreadsheet, yes :)
@@TeamprofitUK thank you! I tried doing it myself but excel is far beyond my comprehension lol
Hi, Can you add more banks/skrill and exchanges?
Hey John - will take a look at this for sure :)
Tom
@@TeamprofitUK I'm sure I can make a separate one for my banks and skrill. It's a great spreadsheet, thanks for sharing it.
does it matter if youre using smarkets?
Hi Safsum - sorry for the late reply! On the Profit Tracker spreadsheet you can change the word "betfair" to "smarkets" under the trigger bets and free bets and it will automatically change the calculation giving you 2% commission instead of 5%. Hope this helps - feel free to add a comment if you need anymore guidance :)
can you change currency for this spreadsheet?
Hi George - no the currencies are not interchangeable sadly. Do you have different accounts in different currencies or are they all in a different currency to GBP? Cheers!
Where does the spread sheet load to?
Hi Trevor Moy - the spreadsheet loads to google docs online, but then you can download your own version to your browser by following the steps found here :) teamprofit.com/matched-betting-spreadsheet/
I’m trying to view this on an iPad, I’m tapping the bottom right box to expand the video to be able to read the print.
But it’s not expanding, is it me?
Sounds like a problem with your Ipad or RUclips Trish - unfortunately we don't have the solution! :(
Hi there Chris do you have Jon on Facebook
Hi there Ziem! Yep he is in the facebook group here, facebook.com/groups/525981434223410/ Cheers!
dont mean sound daft but ur spreadsheet is absoloutly blank ?? sorry sound thick but new to this plz help need keep track
Hi there! Do you mean this link is showing as blank? docs.google.com/spreadsheets/d/1I0s_3FK3R_RtqSh_k4Jc9znVoPTjR_RI6KfxMshweKc/edit?usp=sharing&pageId=114437264312274508919
Have you clicked onto the 2nd tab on the document? Cheers, Jon.
I can't use alot of these offers because i live in sweden
Morning Erik - ah yes sadly the bookmaker offers will vary from country to country and we only really focus on the UK & Ireland offers. Are there any good offers in Sweden, out of interest? Cheers :)
yes, but it's much more work because i have to do much more research to find it
Seems like a lot of pissing around this match betting
Hey Annoney Mouse,
The first few offers will take a little while to get your ahead around, but with 30+ sign ups and far more daily offers then once you've understood it, it becomes an absolute gold mine :)
Team Profit thanks for the reply I really want to look into it as im putting bets on weekly on so called bankers and losing
Punting can be fun but the websites offer you worse odds than the actual outcome. If something has a 1 in 5 chance of coming in, they should be offering you odds of 5.0. But they won't, they'll offer you 4.0 or 3.5. This is how they win in the long run! If you have any spare time then feel free to check out our video guides section which makes it a lot easier to understand and a lot less boring www.teamprofit.com/matched-betting-guide
We'll walk you through all offers, and we have a live chat and email to answer any questions you may have. Our Facebook group currently has 5000+ members, and we are, and always will be FREE! :)