The BTC Football Trading Thread

[Mark Maguire]

At the risk of worsening everyones day .. SHG Toulouse

[A Former User]

@eamonn-hogan Drop me a DM if you still need a hand with this mate

It's likely different as I don't know how you're recording your data but i'll try and re format what i'm using so you can make sense of it. Just change the bits in bold:

=SUM(filter(RESULTS,'COUNTRY="Sweden",'LEAGUE="Allsvenskan"))

e.g.

Where it says results/country/league you need the column data range, for example J2:J999

I have mine linked to a separate sheet (called SHG LCS/LTD) with my results (I just put in how many points the trade made or lost) - 'SHG LCS/LTD'!J2:J2998'

I have a separate column for country and league as I rip the exported csv straight from the btc filters and thats how it comes.

[Richard Latimer]

@dan-mackinnon said in The BTC Football Trading Thread:

@richard-latimer said in The BTC Football Trading Thread:

Having a poor morning here too, not helped by VAR

You and me both.

An abysmal start now going 2/5 ffs haha

[Dan MacKinnon]

@richard-latimer said in The BTC Football Trading Thread:

Having a poor morning here too, not helped by VAR

You and me both.

[Richard Latimer]

@eamonn-hogan said in The BTC Football Trading Thread:

Anybody able to help me to set up on google sheets a formula to tell me what my strike rate is for each league?
@Private-Coaching-Daniel-Mills

Go on my sheet and copy mine if you like

[Richard Latimer]

Having a poor morning here too, not helped by VAR

[Eamonn Hogan]

Anybody able to help me to set up on google sheets a formula to tell me what my strike rate is for each league?
@Private-Coaching-Daniel-Mills

[Mark Maguire]

Not to be - sorry folks

[Dan MacKinnon]

@dan-mackinnon said in The BTC Football Trading Thread:

SHG Tosu vs Oita

Well that wasn’t a good start to the day. Sorry guys

[Mark Maguire]

SHG in Thailand Port FC

[Dan MacKinnon]

SHG Tosu vs Oita

[Mark Maguire]

@steve-sandell All your others seemed to work though Steve .. so well done you I say

[Richard Latimer]

@steve-sandell said in The BTC Football Trading Thread:

@steve-sandell said in The BTC Football Trading Thread:

SHG Newcastle v Leeds currently 1-1

not to be

On it too. Oh well.

[Steve Sandell]

@steve-sandell said in The BTC Football Trading Thread:

SHG Newcastle v Leeds currently 1-1

not to be

[Mark Maguire]

And there it is .

[Steve Sandell]

SHG Newcastle v Leeds currently 1-1

[Mark Maguire]

@richard-latimer Thanks mate

Also going for another goal at Celta Vigo

[Richard Latimer]

@mark-maguire said in The BTC Football Trading Thread:

@mark-maguire 3/3 Not the toughest of picks but they will do

Nothing is easy
Well done.

[Steve Sandell]

@steve-sandell said in The BTC Football Trading Thread:

Hertha Berlin v Greuther Furth currently 0-0

Goal 0-1 nice and quick

[Steve Sandell]

Hertha Berlin v Greuther Furth currently 0-0