Football Excel Challenge

A place to discuss anything.
User avatar
LeTiss
Posts: 5386
Joined: Fri May 08, 2009 6:04 pm

:lol: :lol:
User avatar
Kai
Posts: 6092
Joined: Tue Jan 20, 2015 12:21 pm

Euler wrote:
Mon Apr 12, 2021 10:18 am
It's curious
The curious case of Stella Bot is an intriguing one indeed. Perhaps this is simply how it was programmed ¯\_(ツ)_/¯
User avatar
ODPaul82
Posts: 683
Joined: Sun May 08, 2011 6:32 am
Location: Digswell Herts

Apr 21 Football.xlsx
There you go Stella, my spreadsheet for April so far, have a pivot and cumulative graph
The raw betfair results is included on a second tab as I sum up the markets for each game.
You do not have the required permissions to view the files attached to this post.
StellaBot
Posts: 818
Joined: Thu Jan 26, 2017 11:52 am

Starting Bank £100
Bets £5
Minimum Odds 1.4

2 bets for today
1st won 1.8= 0.8
2nd kicking off 7pm
edit
2nd matched at 1.42(0.42)

Thanks ODPAUL
Bit too much though
was only needing a rolling profit/loss one with strikerate
StellaBot
Posts: 818
Joined: Thu Jan 26, 2017 11:52 am

1st two up ;)
also only do over/under 2.5

Started on a profit loss spreadsheet
will try to work out how to do strike rate
had one in 2019 but was on open office
FOOTBALL PROFIT LOSS.xlsx
You do not have the required permissions to view the files attached to this post.
User avatar
ODPaul82
Posts: 683
Joined: Sun May 08, 2011 6:32 am
Location: Digswell Herts

For strike rate you could use formula =IF(profit>=0, "W", "L"), add data to a pivot table with the W/L as column headings and calculate from that.

If you're not confident with a pivot table you could do a count of the column with =COUNTIF(column with W/L, "W") repeat for "L" and then calculate from that.
StellaBot
Posts: 818
Joined: Thu Jan 26, 2017 11:52 am

Thanks ODPAUL
Should be ok now
FOOTBALL PROFIT LOSS.xlsx
You do not have the required permissions to view the files attached to this post.
User avatar
Derek27
Posts: 23475
Joined: Wed Aug 30, 2017 11:44 am
Location: UK

How is this an "excel" challenge? If somebody took part but didn't use excel would their bets count? ;)
User avatar
ODPaul82
Posts: 683
Joined: Sun May 08, 2011 6:32 am
Location: Digswell Herts

I didn't even realise it was a challenge (barring the title of the thread saying it) :lol:
Just thought the bot wanted a cumulative graph line!

Happy to do some funky stuff with index, offset & indirect though.
StellaBot
Posts: 818
Joined: Thu Jan 26, 2017 11:52 am

Never knew myself also to be honest
Had noticed other threads with word "Challenge"
Was challenging my own system
and hence asking for a spreadsheet/advice

YES
THE CUMULATIVE GRAPH LINE IS REQD

I am rubbish at them

Can that be added to the last excel chart I uploaded? plz
User avatar
ODPaul82
Posts: 683
Joined: Sun May 08, 2011 6:32 am
Location: Digswell Herts

FOOTBALL PROFIT LOSS.xlsx
There you go
You do not have the required permissions to view the files attached to this post.
StellaBot
Posts: 818
Joined: Thu Jan 26, 2017 11:52 am

Updated sheet with 2% commision
FOOTBALL PROFIT LOSS.xlsx
You do not have the required permissions to view the files attached to this post.
StellaBot
Posts: 818
Joined: Thu Jan 26, 2017 11:52 am

Updated sheet
FOOTBALL PROFIT LOSS.xlsx
You do not have the required permissions to view the files attached to this post.
StellaBot
Posts: 818
Joined: Thu Jan 26, 2017 11:52 am

Updated sheet
1 game postponed
Luxembourg not on betfair?

no games for tomorrow
FOOTBALL PROFIT LOSS.xlsx
You do not have the required permissions to view the files attached to this post.
StellaBot
Posts: 818
Joined: Thu Jan 26, 2017 11:52 am

2 matches today
FOOTBALL PROFIT LOSS.xlsx
You do not have the required permissions to view the files attached to this post.
Post Reply

Return to “General discussion”