The BTC Football Trading Thread
-
@martin-futter Hi mate when I've previously traded it the average win was 0.25pts green and the average loss was -0.662pts red.
I have since deleted a few leagues to thin out result updates would be good to have an all-league master filter updated with Adam's spreadsheet then create a winning sub filter from it.
-
@alan-steward do you know the average win and loss percentage of stake on the split stake? just want to get a minimum strike rate figure for the mastersheet and seem to remember you having a good idea of them before
-
@ryan-carruthers hopefully no Norwich players involved
-
@daniel-cooper said in The BTC Football Trading Thread:
@martin-futter said in The BTC Football Trading Thread:
@daniel-cooper how long a period is that over?
Since mid September
Be wary of not drilling too deep some of those losers could be highly priced as the market expects the event to happen... Look for that happy medium which can maximise profits
-
@martin-futter said in The BTC Football Trading Thread:
Brilliant Pens again by Scotland, why isn't McClean taking them for Norwich? We never score pens!
What with McClean & Idah we're getting there
Heading back to the land of plenty??? OTBC
-
@martin-futter said in The BTC Football Trading Thread:
@daniel-cooper how long a period is that over?
Since mid September
-
@daniel-cooper how long a period is that over?
-
@martin-futter said in The BTC Football Trading Thread:
@martin-futter said in The BTC Football Trading Thread:
@daniel-cooper said in The BTC Football Trading Thread:
@daniel-cooper said in The BTC Football Trading Thread:
Hi Guys. Done some spreadsheet tidying up today and the filter I've had cooking since mid September which was originally intended to be a "Lay U3.5 at K/O" filter and to find high scoring games has 150 results in currently and 75% of games had 1 or more FHG. Unfortunately I don't have the goal times, but if anyone wants the sheet and results ping me, happy to share.
The other highlights are as follows:
Done my own digging and refining, and refined to a new filter with 32 existing entries. 87.5% of the games have 1 or more FHGs, 50% had 2 or more FHG's. The average first goal time was 18:10 and the average goal time for H1 was 24:59.
that's impressive!
is the 87% over 32 results? needs more results if so but very good so far!
Yeah unfortunately, the sheet has 150 odd results in but once I applied further filters and constraints, it got the S/R nice and high but limited it to many less results! Will see how it goes.
-
@martin-futter said in The BTC Football Trading Thread:
@daniel-cooper said in The BTC Football Trading Thread:
@daniel-cooper said in The BTC Football Trading Thread:
Hi Guys. Done some spreadsheet tidying up today and the filter I've had cooking since mid September which was originally intended to be a "Lay U3.5 at K/O" filter and to find high scoring games has 150 results in currently and 75% of games had 1 or more FHG. Unfortunately I don't have the goal times, but if anyone wants the sheet and results ping me, happy to share.
The other highlights are as follows:
Done my own digging and refining, and refined to a new filter with 32 existing entries. 87.5% of the games have 1 or more FHGs, 50% had 2 or more FHG's. The average first goal time was 18:10 and the average goal time for H1 was 24:59.
that's impressive!
is the 87% over 32 results? needs more results if so but very good so far!
-
@bottlabroon said in The BTC Football Trading Thread:
@alan-steward said in The BTC Football Trading Thread:
@richard-latimer exactly mate, Shaun can use a method not sure of its name lol and pair information to extract other information goal times, results etc... You'd pick it up in no time mate
It’s amazing what you can do with VBA and macros in Excel. I’m not particularly good with it myself but you can get your spreadsheets developed for peanuts on sites like people per hour. I used to spend weeks trying to figure out how to update spreadsheet A from spreadsheet B and merge data from spreadsheet C on a daily basis only to find some whizz kid in India could develop the programs in a couple of hours for a tenner
Yeah I used to speak with someone who used VBA all the time. Looked like rocket science to me haha!!
-
@alan-steward said in The BTC Football Trading Thread:
@richard-latimer exactly mate, Shaun can use a method not sure of its name lol and pair information to extract other information goal times, results etc... You'd pick it up in no time mate
It’s amazing what you can do with VBA and macros in Excel. I’m not particularly good with it myself but you can get your spreadsheets developed for peanuts on sites like people per hour. I used to spend weeks trying to figure out how to update spreadsheet A from spreadsheet B and merge data from spreadsheet C on a daily basis only to find some whizz kid in India could develop the programs in a couple of hours for a tenner
-
@richard-latimer exactly mate, Shaun can use a method not sure of its name lol and pair information to extract other information goal times, results etc... You'd pick it up in no time mate
-
@martin-futter said in The BTC Football Trading Thread:
@alan-steward said in The BTC Football Trading Thread:
@martin-futter Excellent @Shaun-Harrison is also interested so that's two right off the bat
well that's a start, what is it that helps you so much? I will email out to members and see if it's something they would want
If I could learn how to use it and it help me update my own sheets quicker then for sure. Easy updating through the week but updating after a weekend an be a real grind. Especially if it was a losing weekend.
-
@martin-futter I've teamed up with Shaun Harrison as we have very similar mindsets and trading goals and mixing my trading experience with his data analysis is helping to lift our success to new levels... Shaun has amazing knowledge of spreadsheets and can do stuff I could only dream of... He could extract results from that sheet and add them to ours... Not 100% sure how he does it but am sure many members could benefit from his method for sure... Yes they'd be a learning curve but once past that it would be a real time saver
-
@martin-futter do you mean updating results mate?
-
@daniel-cooper Seems to be some gold in that filter mate... Well done for stripping it down... Its amazing what you can find
-
@alan-steward said in The BTC Football Trading Thread:
@martin-futter I would find that spreadsheet really useful as I would be able to update results quicker to measure and manage my filters... I think more members would track results on their filters more if they had a quicker process to do it.
I appreciate the video you did the other day re "Deep Dive" into that filter but my Deep Dive is much more that that... I've just tweaked two filters to convert SHG at 80% conversion but it takes time to do all that and being able to update my results much quicker helps me find more time to make my filters even more profitable.
I also have 3 months of data that needs results and being able to import results from another sheet would allow me to profit from that data quicker...
maybe that would help me with mine, I'm so behind on it!
