Keeping track of bets?

DiarmuidBoy89 · 20-05-2012 6:54pm #1

Hi does anyone know what's the best way to keep track of your bets to see have you made profit and were your going wrong ect?

FANTAPANTS · 20-05-2012 6:58pm

keep a note book... what stakes you backed...then keep winner loser profits on it simple!!

tinodz · 21-05-2012 10:19pm

You could use the Log Sub-Fourm on here - although that means you are making stuff public

A spreadsheet in Google Docs works wonders if you set it up right

Although buying a nice little Moleskine notebook is great - I found if you write down everything you do it ends up helping you make smarter decisions in the long run. Having something physical to keep track of when you make a bets (especially when doing a lot of online bets) is a great plus.

xVLtx.jpg?1

stingerro · 22-05-2012 9:22pm

DiarmuidBoy89 wrote: »

Hi does anyone know what's the best way to keep track of your bets to see have you made profit and were your going wrong ect?

I would reccomend registering (for free) at mysbrforum.com and using their spreadsheet. For example this guy who is an excellent NHL tipster use it - http://guil0000.mysbrforum.com/spreadsheet/

mcw92 · 22-05-2012 11:49pm

This is a great spreadsheet for keeping track of bets :

Betting Spreadsheet.

It has stats on every market you bet on, sports you bet on, a diagram of total profit/loss etc.

SteelyDanJalapeno · 23-05-2012 12:36am

mcw92 wrote: »

This is a great spreadsheet for keeping track of bets :

Betting Spreadsheet

It has stats on every market you bet on, sports you bet on, a diagram of total profit/loss etc.

That link brings me to facebook warning me about potential malware and phishing!? Dafuq

Anyway, I'd echo Stingerro, SBR is good

mcw92 · 23-05-2012 12:38am

TiltedBrain wrote: »

That link brings me to facebook warning me about potential malware and phishing!? Dafuq

Anyway, I'd echo Stingerro, SBR is good

Sorry, i got it of a mate on facebook so i just copied the link from it.

Heres the original : Betting Spreadsheet.

SteelyDanJalapeno · 23-05-2012 12:47am

mcw92 wrote: »

Sorry, i got it of a mate on facebook so i just copied the link from it.

Heres the original : Betting Spreadsheet.

looks good.

MrJoeSoap · 23-05-2012 12:58am

mcw92 wrote: »

Sorry, i got it of a mate on facebook so i just copied the link from it.

Heres the original : Betting Spreadsheet.

Great detail in that, thanks for the link!

yesno1234 · 23-05-2012 12:10pm

mcw92 wrote: »

Sorry, i got it of a mate on facebook so i just copied the link from it.

Heres the original : Betting Spreadsheet.

That's class, cheers for posting it up. Just one thing, how do you change the currency to €? I know it makes no difference really but still.

Edit: Nevermind figured it out.

markc91 · 24-05-2012 3:56am

yesno1234 wrote: »

That's class, cheers for posting it up. Just one thing, how do you change the currency to €? I know it makes no difference really but still.

Edit: Nevermind figured it out.

+1 on that but havnt figured out how to change it to euro??

yesno1234 · 24-05-2012 8:28am

markc91 wrote: »

+1 on that but havnt figured out how to change it to euro??

Firstly you have to unprotect the editable sheets
"Worksheet protection
As it stands, only limited sections of this spreadsheet can be edited. This is to prevent key formulas from being accidentally overwritten. To unlock a worksheet, go to that worksheet and select Tools -> Protection -> Unprotect Sheet The password to unlock each worksheet is sport"
Then highlight any columns that are £ and on the home tab (at the top), look for the Number column, it's the fourth one across. With all the £ column highlighted look for the dropable menu with the note and coins. Click it and Euro should be there. You might have to go through the whole sheet highlighting and changing but it shouldn't take long. I couldn't find any way to do it all at once. I attached a screenshot with the relevant stuff highlighted.

markc91 · 24-05-2012 1:49pm

Im looking now and the microsoft excel i have says compatabity mode and all the options at the top are greyed out so i cant touch tools or anything, I must not have the full version

MrJoeSoap · 24-05-2012 3:14pm

markc91 wrote: »

Im looking now and the microsoft excel i have says compatabity mode and all the options at the top are greyed out so i cant touch tools or anything, I must not have the full version

Which version (what year) of Excel do you have?

markc91 · 24-05-2012 3:24pm

Microsoft Excel Starter 2010

Any Ideas??

markc91 · 29-06-2012 1:51am

markc91 wrote: »

Microsoft Excel Starter 2010

Any Ideas??

Im coming down near the end of the spreadsheet and still cant add more lines any1 any ideas??

yesno1234 · 29-06-2012 12:22pm

markc91 wrote: »

Im coming down near the end of the spreadsheet and still cant add more lines any1 any ideas??

Have you unlocked the worksheets to all editing?

From the intro page:
"Worksheet protection

As it stands, only limited sections of this spreadsheet can be edited.
This is to prevent key formulas from being accidentally overwritten.
To unlock a worksheet, go to that worksheet and select Tools -> Protection -> Unprotect Sheet
The password to unlock each worksheet is sport"

markc91 · 29-06-2012 12:25pm

yesno1234 wrote: »

Have you unlocked the worksheets to all editing?

From the intro page:
"Worksheet protection

As it stands, only limited sections of this spreadsheet can be edited.
This is to prevent key formulas from being accidentally overwritten.
To unlock a worksheet, go to that worksheet and select Tools -> Protection -> Unprotect Sheet
The password to unlock each worksheet is sport"

I cant get into tools to edit anything it says something about compatibility mode