This is a very interesting concept, I'd be up for helping you create the filters that you have found that would profit?
Do they have a highlights section? Which highlights profitable angles already?
@Kurtis-Steven-Graham Hard to say.
It's the actual rules that tell you what is happening.
@GREGORIOS-KARASHIALIS you could look for strong ELO teams that score lots of first half goals? You won't get any filter that 'always' home team goes 1-0 up but you may get one that does it often.
I cannot sadly as I stopped trading that strategy, the reason being is that I went all in on automation and turned off everything else.
So I wish I could help but I haven't tracked it. But I like the thinking that you have there, that's key to becoming a profitable trader taking an idea and putting your own spin on it!
You will be able to backtest that when the footie backtesting is done! 😄
@Alex-Rendell Thanks for this, I'll have a look. Yes, I agree, there isn't a magic stat or strategy and it is all about taking good value - bottom line.
Regarding my post, it was just me being curious, there hasn't been a lot of football to trade recently so I've decided to do some testing. I personally like the idea of knowing as much as possible about the markets I trade. With markets changing all the time, I personally see testing as a good way to stay on top of my trading and to keep biases, opinions and assumptions at bay - all about data.
Thanks for your feedback, as I said I'll have a look at FTS, the name rings a bell.
Nick
@william-marley can you reply to this so it notifies me in tomorrow as it's too late for me to make a filter today but will help you tomorrow 🙂
Script
SOURCE_SPREADSHEET_ID = spreadsheet id
Example: https://docs.google.com/spreadsheets/d/1fffffkLZZh8FtG6WCIQ--pmul4OWkWlSdevQDoBY1_I/edit#gid=345667
Always save your script before running it after replacing the "Daily Qualifiers List" of the day.
function customTrim(x) { return x.replace(/^\s+|\s+$/gm,''); } function importDataBasedOnRules() { // Get the source and target spreadsheets let sourceSpreadsheet = SpreadsheetApp.openById('SOURCE_SPREADSHEET_ID'); let targetSpreadsheet = SpreadsheetApp.getActiveSpreadsheet(); //assuming the script is bound to the target spreadsheet // Get the source sheet and its data let sourceSheet = sourceSpreadsheet.getSheets()[0]; // get the first sheet let sourceLastRow = sourceSheet.getLastRow(); let sourceLastCol = sourceSheet.getLastColumn(); // Fetch the displayed values from the source sheet let sourceRange = sourceSheet.getRange(2, 1, sourceLastRow-1, sourceLastCol); //get the range let rawValues = sourceRange.getDisplayValues(); //get displayed values including the format // Process the data: ignore certain columns and split race_date_time into race_date and race_time let values = rawValues.map(([strategyName, , , raceDateTime, courseName, raceType, going, horseName, selectionId]) => { let [raceDate, raceTime] = raceDateTime.split(' '); return [selectionId, raceDate, raceTime, courseName, horseName, raceType, going]; }); // Write the processed values into the target sheet for(let i = 0; i < values.length; i++) { let strategyName = customTrim(rawValues[i][0]); //fetch strategy name let targetSheet = targetSpreadsheet.getSheetByName(strategyName); //find the sheet with the same name if (targetSheet) { //if the sheet exists let targetLastRow = targetSheet.getLastRow(); let targetRange = targetSheet.getRange(targetLastRow+1, 1, 1, values[i].length); //set the range in the target sheet targetRange.setValues([values[i]]); //write the values } else { //if the sheet doesn't exist, handle the error (you can modify this part to fit your needs) Logger.log("The sheet for strategy " + strategyName + " does not exist in the target spreadsheet."); } } }@Stephen-McIntyre hi mate select 'Betfair' 'Odds' then 'home' then choose your price 🙂
Night 16 results:
Price threw first and won at 1.4 = -£1
Aspinall threw first and won at 2.12 = £1.12
Smith threw first and lost at 1.34 = £2.85
MvG threw first and won at 1.4 = -£1
Aspinall threw first and lost at 2.90 = -£1
MvG v DvdB was a walkover, no bets.
Price threw first and lost at 1.34 = £2.85
Overall sixteenth night returns: £3.82
League total return: £23.20
And that's all folks! Only the playoffs to go which is a different format.
@rachel-dawes Hi Rachel, ive only recently joined and just seen this post. If you haven't already worked it out this is how. On Guardian click list, then the page icon on the far left. you can add up to five automation rules columns and various others like nominations for multiple strategies. Hope this helps
@darren-bennett probably worth putting in the bet Angel thread
I have tried to build this and can't find a way to get it the way exactly you want it.
I see Adam has replied on this thread
https://forum.betfairtradingcommunity.com/topic/222/football-software-and-ratings-support-thread
@patrik-mellqvist I moved to quarterly - it was really good!!!
I liked it
@gary-finnigan-0 got the past 3 weeks here: https://docs.google.com/spreadsheets/d/1baRoxh9Jup5FkTKptcwgueSHxymonRerebbq24s1FD8/edit#gid=0
Yes I'd be very interested to know in more detail how your testing has gone on this and what it's revealed.
@dan-peacey worth checking out the set and forget thread, I have some ELO stuff going on at the moment
@paul-foster your work on this is really good. Superb strike rates on all three markets, especially the FHG. Hopefully your stats will withstand variance and remain more or less the same at 500/750 tested matches. You’ll have something nice and solid to really work with then.