The BTC Football Trading Thread
-
well that leiknir game went a bit mad didnt it. Nice to get matched on fhg easily in the end.
-
@johannes-van-leeuwen-0 Golden rule is it depends if game selection is coming from a filter and how that filter performs! If you go through the games on my spreadsheet you will see that it will maximise profits by trading how I suggested... Your games may well trade differently
-
@richard-latimer only know how to do it on google sheets, had to watch a video to figure it out at first. Really easy on there tho, just the same as usual you click sum and then scroll to the cell on a different sheet and click and it loads nicely. No idea how to do it with other spreadsheet apps tho
-
@darri said in The BTC Football Trading Thread:
@martin-walker are you using google sheets? Would you want something like mine, all my sheets are fully synced between each tab. So all my results from each strategy sheet is recorded in the summary too. Should be able to download them and i could help you tweak it to suit you for each sheet? All the formulas or calculations all setup
I should really learn how to collate all results on to one summary tab like that.
-
@martin-walker said in The BTC Football Trading Thread:
@ben-dobie this is what i do at the moment mate. Im attempting to have it record strike rate and profit at the top but have no idea what im doing
I'm self taught on formulas and a lot of the time I'm copying my existing formulas onto other sheets or googling it haha!
Feel free to steal if you want.
-
@ben-dobie said in The BTC Football Trading Thread:
@chris-osborne looks good mate might tap you up myself never known how to record data from.one tab into another...I'm self taught so learn as I go and only know the basics
No problem, I work with spreadsheets for 40hrs a week, if you want something ping me your email and strategies and I can adapt easily enough
-
@martin-walker are you using google sheets? Would you want something like mine, all my sheets are fully synced between each tab. So all my results from each strategy sheet is recorded in the summary too. Should be able to download them and i could help you tweak it to suit you for each sheet? All the formulas or calculations all setup
-
@chris-osborne looks good mate might tap you up myself never known how to record data from.one tab into another...I'm self taught so learn as I go and only know the basics
-
@ben-dobie said in The BTC Football Trading Thread:
@martin-walker it's probably quite easy but maybe not for what I do ie several strategies, I'm sure @Chris-Osborne Will be able to you
This is an example of what I put together for James all formula driven so just have to enter results on seoerate Tab
-
@martin-walker it's probably quite easy but maybe not for what I do ie several strategies, I'm sure @Chris-Osborne Will be able to you
-
@ben-dobie this is what i do at the moment mate. Im attempting to have it record strike rate and profit at the top but have no idea what im doing
-
@chris-osborne said in The BTC Football Trading Thread:
@martin-walker said in The BTC Football Trading Thread:
Whats the easiest way to make a spreadsheet do strike rate for me? Beginner with spreadsheets
I put together a spreadsheet for @jameseverard to record results including strike rate, I can let you have it if you ping me your email address if you like
This is a better response
-
@martin-walker said in The BTC Football Trading Thread:
Whats the easiest way to make a spreadsheet do strike rate for me? Beginner with spreadsheets
I put together a spreadsheet for @jameseverard to record results including strike rate, I can let you have it if you ping me your email address if you like
-
@martin-walker I generally just collect all.my results mate and record the data in I want on the spreadsheet from each game using flash scores then work out strike rate manually every 100 games...
Can send you an example of one of my sheets but it doesn't work out sr automatically as I like to record sr for quite a few different strategies -
Whats the easiest way to make a spreadsheet do strike rate for me? Beginner with spreadsheets
-
@alan-steward said in The BTC Football Trading Thread:
If trading o2.5 goals I think following would be best
Cash out on 2 goals upto & including 65mins
2 goals between 65 & 75mins out for minimal loss
Any game with 0 to 1 goal before 75mins on 75mins lay next score to cover red or % ofnow y made a error , not always cash out after 2 goals but depends on the games
but the golden rule is over 50% roi y can cash out or take the red depends on the trader -
@alan-steward said in The BTC Football Trading Thread:
@martin-walker said in The BTC Football Trading Thread:
@alan-steward do you have restrict to current season selected on this filter?
I presume you're referring to the one in my signature link... Straight answer "No"
I can't now remember why lol but have posted full settings other than leagues below... I will try to dig deep in my brain and work out why as I believe I was doing this towards the beginning of the month... Maybe it was because it limited games due to winter leagues finishing and summer leagues just starting but I checked how many games were played and looked for consistency with early season results to end of last seasons results on Sofascore.
It won't hurt to add that to the settings, I'm very experienced trading correct scores and can often work a way to scratch if required... Of course I come unstuck from time to time... That's trading, the one thing with what I do is I'm now able to keep liabilities down to a minimum so my losses can be quite nominal to my wins.
Obviously you will be using this more for FH, SH goals or o2.5 goals and using the latter should lower your liabilities... This filter is more about finding consistent teams doing consistent things... Scoring goals! It's then a matter of extracting the best value.
Hope this helps
in your filter games today??
-
If trading o2.5 goals I think following would be best
Cash out on 2 goals upto & including 65mins
2 goals between 65 & 75mins out for minimal loss
Any game with 0 to 1 goal before 75mins on 75mins lay next score to cover red or % of -
@martin-walker Yes but French league only just started up again
Just checked games that were level at HT (LTD)
29 games 0-0, 1-1 or 3-3
23 games went on to have another goal -
@alan-steward yes 2.2 in the lyon game but 1.45 in leiknir from the filter
