Football Excel Challenge

A place to discuss anything.
Post Reply
StellaBot
Posts: 842
Joined: Thu Jan 26, 2017 11:52 am

Another pointer
All bets have to be 1.4 or above
thats my criteria
hopefully in near future
;)
Top
User avatar
Kai
Posts: 7183
Joined: Tue Jan 20, 2015 12:21 pm

StellaBot wrote: ↑
Sun Apr 11, 2021 7:40 pm
 TY KAI
ty for
the thumbs up thing
I cant define or reply a thumbs up on here
Image

No worries, you can borrow this megathumb from Dallas if you need to
Top
User avatar
Euler
Posts: 26501
Joined: Wed Nov 10, 2010 1:39 pm

It's curious
Top
User avatar
Euler
Posts: 26501
Joined: Wed Nov 10, 2010 1:39 pm

How something that could be done in one sentence
Top
User avatar
Euler
Posts: 26501
Joined: Wed Nov 10, 2010 1:39 pm

Can be spread across multiple posts.
Top
User avatar
LeTiss
Posts: 5489
Joined: Fri May 08, 2009 6:04 pm

:lol: :lol:
Top
User avatar
Kai
Posts: 7183
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 ¯\_(ツ)_/¯
Top
User avatar
ODPaul82
Posts: 819
Joined: Sun May 08, 2011 6:32 am

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.
Top
StellaBot
Posts: 842
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
Top
StellaBot
Posts: 842
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.
Top
User avatar
ODPaul82
Posts: 819
Joined: Sun May 08, 2011 6:32 am

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.
Top
StellaBot
Posts: 842
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.
Top
User avatar
Derek27
Posts: 25159
Joined: Wed Aug 30, 2017 11:44 am

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

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.
Top
StellaBot
Posts: 842
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
Top
Post Reply

Return to “General discussion”