*****New Football Thread*****

Martin

@Alex-Rule 100% not a bad rule for money in life either!

Alex Rule

@Martin Yep end of month big admin day for me after holidays the last couple of weeks.

Spreadsheet tidying and strategy reviews. Very exciting stuff for a Saturday but seems to be paying dividends at and setting up for future success.

Martin

@Alex-Rule said in *****New Football Thread*****:

@Greg-Mitchell

I have added a liability column to my Lay strats for tracking and adjusted the ROI to reflect the total liability as opposed to stakes (which I have kept for my backing strats)

Thanks again

Love this!

Alex Rule

@Greg-Mitchell

I have added a liability column to my Lay strats for tracking and adjusted the ROI to reflect the total liability as opposed to stakes (which I have kept for my backing strats)

Thanks again

Simon Bates

@Simon-Bates only 'just' got this, 10th goal scored in the 91st minute just before full time whistle

Simon Bates

It's only half time shame I can't find this game on Betfair.

Martin

@Alex-Rule I'm annoyed now as I should have sent the stats from their match at the weekend, the away team were dominant (against 10 men)

Alex Rule

@Martin bit of a shocker there lol

I guess maybe more stats for home and away are needed to get a better feel for the league. Pretty early on on their season.

Still, first time using the daily stats sheet so we will see if any other nuggets pop up!

Martin

@Alex-Rule they did ok in the away game a couple of days ago but then Fred were down to 10 men early on

Alex Rule

Anyone else liking the look of Tromso v Fredrikstad?

Laying the home team - stats look pretty decent for the price - if Fredrikstad score first you could green up nicely I would have thought.

Alex Rule

@Greg-Mitchell Cheers Greg - will have play later on

Greg Mitchell

@Alex-Rule said in *****New Football Thread*****:

Can someone help me out with a basic spreadsheet formula?

All of my tracking currently uses total staked at the amount - however on LAY strategies it would be more accurate to use stake x odds to get the true staking value per pick. Does that make sense? Any easy advice for an amateur spreadsheet user would be appreciated. Cheers!

Add a column for Liability. so if you have say for example:

Column A is Bet Type (Back or Lay), Column B is the current one you have for stake, Column C is the odds and Column D is the P & L, add a column E for Liability.

If your data starts in row 2, then the formula in Column E should be:

=IF(A2 ="Back",B2,B2*(C2-1))

Alex Rule

Can someone help me out with a basic spreadsheet formula?

All of my tracking currently uses total staked at the amount - however on LAY strategies it would be more accurate to use stake x odds to get the true staking value per pick. Does that make sense? Any easy advice for a amateur spreadsheet user would be appreciated. Cheers!

Martin

@Simon-Bates depends on how much faith you have in a FHG, so looking at the FHG odds they are short, one option is to wait in play for better odds. So you could look to enter at 15-20 mins.

Simon Bates

I've found this game from Norways Obos Ligaen between Sandnes v Kongsvinger.
100% fhg goal, no 0-0's, can someone give me some ideas on how they would trade this game please.
Also check out all the games from this league tomorrow (Monday) they all have a high % of fhg

Ricky Simpson

A nice LTD trade in after 7mins using the stats email & the ratings page

Ricky Simpson

@Martin that sounds like a good idea.. no plans today, will have a look now for a couple of angles

Martin

@Ricky-Simpson have a siesta then Scandinavian leagues in the eve!

Ricky Simpson

Yep, me too @Martin back at it again this morning

Martin

@Ricky-Simpson said in *****New Football Thread*****:

Love the summer leagues all trading wrapped up before midday, no need to go looking for anymore, just enjoy the day

massive advantage isn't it! well for those of us who like me are up at 5am