Best way to track MB?

[Xorro]

I've seen the Match & Go spreadsheet, but are there any alternatives or better ways to track it all, or is this the best?

I'm using an old laptop which only has Office 2003 which doesn't work well with the M&G spreadsheet.

 

[Jon]

Give ultimatcher a try

https://blog.themoneyshed.co.uk/ultimatcher-beginners-guide/

 

[Xorro]

Give ultimatcher a try

https://blog.themoneyshed.co.uk/ultimatcher-beginners-guide/

That looks good, thank you.

 

[Xorro]

Drat, I get an error when I try to add a bookie "Run-time error 1004. Method 'Range' of object '_Global' failed"

I searched and someone else here had the same issue but unfortunately no one had a solution.

 

[Quincy452]

I downloaded a spreadsheet from Team Profit. Looks good so far. Maybe give it a try.

 

[Xorro]

Thanks Lolly, I grabbed that one earlier, from what you said it sounds like its worth trying. I'll watch the videos and give it a whirl.


I like the idea of using Google sheets as I can then access it from all my devices.

 

[Stims]

ULTI is by far the best if you wanna be really detailed and accurate. I still use it now.. although i've taken to just updating my balances mostly as it saves a ton of time for me.

 

[rninja]

May I suggest good old fashioned lined A4 paper (I still use this every Saturday as an experienced Mber), also this has the advantage of you documenting everything and learning to be methodical and rigorous - the two most important qualities in matched betting.

 

[Jon]

Drat, I get an error when I try to add a bookie "Run-time error 1004. Method 'Range' of object '_Global' failed"

I searched and someone else here had the same issue but unfortunately no one had a solution.

Pain the backside that error.

Just checking, you have downloaded the 2003 version of Ulitmatcher for Office 2003 etc haven't you?

 

[Xorro]

Pain the backside that error.

Just checking, you have downloaded the 2003 version of Ulitmatcher for Office 2003 etc haven't you?

Yes, I did. I also fixed the errors in the macros. One was looking for cell NZ1 which didn't exist, so I changed that to N1 (or something), then I got another error which was to do with formatting so I commented it out. It all worked after that.

However, I thought Ulti was a bit busy so I've written my own system in Google Sheets

 

[Xorro]

...I also like having Google Sheets as I can then access it from the mac, laptop, iPhone etc.

I thought I'd post my changes in case anyone else has the same problems:

Use Alt+F11 to bring up the VBA editor, open the Pending module and find the below code, comment out the green bit.

Dim lastlogrow

lastlogrow = Range("AB3").Value

Range("Q9:Q" & lastlogrow).Select
Selection.FormatConditions.Delete
Selection.FormatConditions.Add Type:=xlCellValue, Operator:=xlLess, _
Formula1:="=0"
' Selection.FormatConditions(Selection.FormatConditions.Count).SetFirstPriority
' With Selection.FormatConditions(1).Font
' .Bold = True
' .Italic = False
' .Color = -16776961
' .TintAndShade = 0
' End With
' Selection.FormatConditions(1).StopIfTrue = False



Range("A9").Select

Sheets("Pending").Select
Range(celladd).Select


Open New_Bookie_Sheet and find the below code.

Rows(insert_row & ":" & insert_row).Select
Selection.Insert Shift:=xlDown

Range("B1:NZ1").Select
Selection.Copy
Range("B" & insert_row).Select
ActiveSheet.Paste

Change NZ1 to Q1

Range("B1:Q1").Select

This seems to work OK, but as I said I decided to do my own version in the end.

 

[Hollyhock64]

...I also like having Google Sheets as I can then access it from the mac, laptop, iPhone etc.

I thought I'd post my changes in case anyone else has the same problems:

Use Alt+F11 to bring up the VBA editor, open the Pending module and find the below code, comment out the green bit.

Dim lastlogrow

lastlogrow = Range("AB3").Value

Range("Q9:Q" & lastlogrow).Select
Selection.FormatConditions.Delete
Selection.FormatConditions.Add Type:=xlCellValue, Operator:=xlLess, _
Formula1:="=0"
' Selection.FormatConditions(Selection.FormatConditions.Count).SetFirstPriority
' With Selection.FormatConditions(1).Font
' .Bold = True
' .Italic = False
' .Color = -16776961
' .TintAndShade = 0
' End With
' Selection.FormatConditions(1).StopIfTrue = False



Range("A9").Select

Sheets("Pending").Select
Range(celladd).Select


Open New_Bookie_Sheet and find the below code.

Rows(insert_row & ":" & insert_row).Select
Selection.Insert Shift:=xlDown

Range("B1:NZ1").Select
Selection.Copy
Range("B" & insert_row).Select
ActiveSheet.Paste

Change NZ1 to Q1

Range("B1:Q1").Select

This seems to work OK, but as I said I decided to do my own version in the end.

You what?????

 

[MuckleMaker]

... although i've taken to just updating my balances mostly as it saves a ton of time for me.

Yeah me too @Stims - For about 2 years I'd been recording lots of detail but now I don't and just count up at the end of the month. I keep my QLs low and Free bets high (not too high of course). I'm spending more time on my betting profile with each bookie as opposed to how much I make from each offer.

If you're starting out in MB then you want to keep detailed records in case you make mistakes and you can track where your money is. But I've been in this game a while with the highs and the not-so-highs and found it helps to just concentrate on working the process as opposed to analysing each offer, thereby helping to avoid paralysis by analysis - "there'll be time enough for counting when the dealings done"

 

[Cas]

Give ultimatcher a try

https://blog.themoneyshed.co.uk/ultimatcher-beginners-guide/

I am looking to start doing matched betting trying to get all my tools in place . I am using a mac , in guessing that Ulitmatcher does not work on there .

Are there any alternatives for a mac user ?

 

[Jon]

I am looking to start doing matched betting trying to get all my tools in place . I am using a mac , in guessing that Ulitmatcher does not work on there .

Are there any alternatives for a mac user ?

There sure is

Use @auntygeek own Match and Go matched betting spreadsheet

http://matchandgo.co.uk/spreadsheet/

 

[Jon]

I am looking to start doing matched betting trying to get all my tools in place . I am using a mac , in guessing that Ulitmatcher does not work on there .

Are there any alternatives for a mac user ?

Actually, why don't you just use Profit Tracker on PA. It's included in your subscription is completely online as you can just click the 'store' button when you do an offer and it automatically tracks your profit/loss and even shows it to you in lovely graph form