LFC SHOP

Reply To: SORTED

News Forums Football SORTED Reply To: SORTED

#2263
Spireman
Participant

SORTED Week 3
I have tried everything to get a spread sheet to paste in a readable format but all I can do is remove as many columns as possible and post the information in two tables.
The first will be the matches sorted by the best prices offered for the home side. So the banker homes (short prices) will be at the top and the banker aways will be at the bottom and hopefully the banker draws will be in the middle.
What you will see is the Division/League The team names The Home odds the Draw odds then the Away odds.

Div Date/Time Match Home Draw Away
Odds Odds Odds
EP 21/08/2021 15:00 ManC v Norwich 1.1 10 20
GB 22/08/2021 16:30 B Munich v Koln 1.11 10.5 16
SL 22/08/2021 18:30 A Madrid v Elche 1.18 6.5 19
EP 21/08/2021 12:30 Liverpool v Burnley 1.2 6.5 15
IS 22/08/2021 19:45 Napoli v Venezia 1.28 5.5 10
SP 21/08/2021 15:00 Celtic v St. Mirren 1.28 5.75 7
IS 21/08/2021 17:30 Inter Milan v Genoa 1.33 5.25 10
S2 21/08/2021 15:00 Falkirk v Clyde 1.4 4.5 5.5
S3 21/08/2021 15:00 Kelty Hrts v Edinburgh 1.4 4.5 5.5
FL 22/08/2021 20:00 Lyon v Clermont 1.5 4.5 5.75
GB 21/08/2021 14:30 Frankfurt v Augsburg 1.53 4.33 5.5
SL 22/08/2021 16:00 R Sociedad v Rayo V 1.53 4 6.5
C0 21/08/2021 15:00 Sheffi U v Huddersfield 1.53 4 6
S1 21/08/2021 15:00 Caledonian T v Ayr U 1.61 3.5 5.25
C0 21/08/2021 15:00 Fulham v Hull C 1.61 3.75 5.5
C1 21/08/2021 15:00 Sundrland v Wimbldon 1.65 4 5
FL 21/08/2021 20:00 Monaco v Lens 1.65 4 4.75
C0 21/08/2021 15:00 Bournemouth v Blackpool 1.66 3.75 5
EP 21/08/2021 17:30 Brighton n H v Watford 1.7 3.6 5.25
IS 22/08/2021 17:30 Bologna v Salernitana 1.7 3.6 5.25
IS 22/08/2021 19:45 Roma v Fiorentina 1.72 3.75 5
EP 21/08/2021 15:00 Aston V v Newcastle U 1.75 3.75 4.5
C2 21/08/2021 15:00 Salford C v Swindon T 1.8 3.5 4.5
C2 21/08/2021 15:00 Forest G v Crawley T 1.83 3.5 4.33
FL 22/08/2021 16:00 Rennes v Nantes 1.85 3.6 4.2
SP 22/08/2021 15:00 St.Jonstone v Dndee U 1.9 3.5 3.6
C1 21/08/2021 15:00 Gilligham v Morecmbe 1.9 3.6 3.75
FL 22/08/2021 14:00 Strasbourg v Troyes 1.95 3.4 4
C0 21/08/2021 15:00 Preston  v Peterbrough 2 3.5 3.6
GB 22/08/2021 14:30 Hoffenheim v U Berlin 2 3.6 3.5
C2 21/08/2021 15:00 Mansfield T v Bradford 2.05 3.3 3.5
SP 21/08/2021 15:00 Livingston v Motherwell 2.05 3.4 3.2
C1 21/08/2021 15:00 Ipswich T v Milton KD 2.1 3.4 3.4
C0 21/08/2021 15:00 Stoke C v Nottis F 2.1 3.4 3.4
C1 21/08/2021 15:00 Fleetwood v Cheltnham 2.1 3.3 3.5
EP 21/08/2021 15:00 Leeds U v Everton 2.1 3.6 3.25
FL 22/08/2021 14:00 Montpellier v Lorient 2.15 3.2 3.6
C2 21/08/2021 15:00 Northmpton v Rochdale 2.2 3.25 3.25
S1 21/08/2021 15:00 Morton v Queen O T S 2.2 3.4 2.9
C0 21/08/2021 15:00 Luton T v Birmingham C 2.2 3.4 3.2
C2 21/08/2021 15:00 Exeter C v Bristol R 2.25 3.25 3.2
SL 21/08/2021 16:00 D Alaves v Mallorca 2.25 3.3 3.2
C0 21/08/2021 15:00 Cardiff C v Millwall 2.25 3.2 3.25
C1 21/08/2021 15:00 Charlton A v Wigan A 2.25 3.4 3.1
C2 21/08/2021 15:00 Carlisle U v Leyton O 2.25 3.25 3.2
C0 21/08/2021 15:00 Coventry  v Reading 2.25 3.25 3.2
C1 21/08/2021 15:00 Shrewsburyv Plymouth 2.25 3.25 3.2
C0 21/08/2021 12:30 QPR v Barnsley 2.25 3.4 3.1
SP 22/08/2021 15:00 Hearts v Aberdeen 2.25 3.3 2.9
C1 21/08/2021 13:00 Rotherham  v Sheff W 2.3 3.25 3.1
GB 21/08/2021 17:30 Bayer L v Borussia M 2.3 3.6 3
C2 21/08/2021 15:00 Tranmere  v Newport 2.3 3.3 3
S3 21/08/2021 15:00 Albion R v Annan A 2.3 3.6 2.5
S3 21/08/2021 15:00 Stenhusmuir v Cowdeh 2.3 3.6 2.5
FL 22/08/2021 14:00 Metz v Reims 2.3 3 3.4
C2 21/08/2021 15:00 Hartlepool U v Walsall 2.3 3.25 2.7
C1 21/08/2021 15:00 Wycombe W v Lincoln 2.3 3.4 3
C2 21/08/2021 15:00 Stevenage B v Port V 2.37 3.25 3
S2 21/08/2021 15:00 Alloa v Queen’s P 2.4 3.6 2.4
S2 21/08/2021 15:00 Peterhead v Airdrie 2.4 3.6 2.4
SL 21/08/2021 18:30 Granada v Valencia 2.4 3.4 2.87
S2 21/08/2021 15:00 East Fife v Montrose 2.4 3.4 2.5
S3 21/08/2021 15:00 Elgin City v Forfar A 2.4 3.6 2.4
S3 21/08/2021 15:00 Stranraer v Stirling A 2.4 3.4 2.5
C1 21/08/2021 15:00 Crewe A v Accrington 2.45 3.5 2.7
GB 21/08/2021 14:30 Greuther F v Arminia 2.45 3.4 2.75
GB 21/08/2021 14:30 Bochum v Mainz 05 2.5 3.5 2.62
C1 21/08/2021 15:00 Bolton W v Oxford U 2.5 3.5 2.7
C2 21/08/2021 15:00 Oldham A v Colchester 2.6 3.25 2.7
C2 21/08/2021 15:00 Scunthorpe  v Sutton 2.62 3.3 2.62
FL 22/08/2021 12:00 Bordeaux v Angers 2.62 3.5 2.6
EP 21/08/2021 15:00 Crystal P v Brentford 2.7 3.2 2.7
SL 21/08/2021 18:30 Espanyol v Villarreal 2.75 3.4 2.45
C0 21/08/2021 15:00 Blackburn  v West B 2.8 3.3 2.5
FL 22/08/2021 19:45 Nice v Marseille 2.8 3.4 2.45
S2 21/08/2021 15:00 Dumbarton v Cove R 2.9 3.75 2
IS 21/08/2021 17:30 Hellas V v Sassuolo 2.9 3.25 2.45
GB 21/08/2021 14:30 Hertha B v Wolfsburg 3 3.4 2.3
C1 21/08/2021 15:00 Cambridge U v Burton A 3.1 3.25 2.3
FL 21/08/2021 16:00 St Etienne v Lille 3.1 3.5 2.2
C0 21/08/2021 15:00 Derby C v Middlesbro 3.25 3.4 2.15
S1 21/08/2021 15:00 Arbroath v Partick T 3.3 3.3 2.05
SL 21/08/2021 21:00 A Bilbao v Barcelona 3.4 3.75 2
C1 21/08/2021 15:00 Doncaster v Portsmuth 3.4 3.4 2.1
SP 22/08/2021 12:00 Dundee v Hibernian 3.5 3.75 1.83
EP 22/08/2021 14:00 Wolves v Tottenham H 3.5 3.25 2.15
S1 21/08/2021 15:00 Hamilton v Kilmarnock 3.75 3.3 1.9
EP 22/08/2021 16:30 Arsenal v Chelsea 4.75 3.6 1.7
IS 21/08/2021 19:45 Empoli FC v Lazio 4.75 3.75 1.72
IS 21/08/2021 19:45 Torino v Atalanta 5.25 4.33 1.57
EP 22/08/2021 14:00 Southampton v Man U 5.5 4 1.6
GB 21/08/2021 14:30 Freiburg v Borussia D 5.75 4.75 1.45
SL 22/08/2021 21:00 Levante v R Madrid 6 4.5 1.5
IS 22/08/2021 17:30 Udinese v Juventus 6 4.2 1.53
SP 22/08/2021 15:00 Ross C v Rangers 11 6.5 1.18

It took a bit of amending but it now looks better. I hope I can do this with the goal stats.

GOAL STATS showing Division/:eague , Date /Time Teams. home goals. Away goals and goal difference.
If I spot any bets I will post later.

Div. Match Date /Time Home Away Goal
Goals Goals Diffrnce
IS Napoli v Venezia 22/08 19:45 3.89 0.02 3.87
GB B Munich v Koln 22/08 16:30 3.88 0.25 3.63
HK PSV v Cambuur 21/08 19:00 3.47 0.06 3.41
EP Man C v Norwich 21/08 15:00 3.44 0.07 3.37
HK Feyenoord v GA Eagles 22/08 13:30 3.08 0.08 3.00
GB E Frankfurt v Augsburg 21/08 14:30 3.08 0.19 2.89
IS Inter Milan v Genoa 21/08 17:30 3.05 0.21 2.84
FL Lyon v Clermont 22/08 20:00 2.94 0.18 2.76
IS Bologna v Salernitana 22/08 17:30 2.91 0.23 2.68
SL A Madrid v Elche 22/08 18:30 2.76 0.13 2.63
HK Vitesse v Willem II 22/08 15:45 2.84 0.23 2.61
SL R Sociedad v Rayo V 22/08 16:00 2.62 0.11 2.51
C0 Bournemouth v Blackpool 21/08 15:00 2.61 0.13 2.48
S2 Falkirk v Clyde 21/08 15:00 2.61 0.32 2.29
P0 Sp Lisbon v Belenenses 21/08 20:30 2.43 0.18 2.25
S1 Arbroath v Partick T 21/08 15:00 2.36 0.15 2.21
SP Celtic v St. Mirren 21/08 15:00 2.46 0.26 2.20
IS Roma v Fiorentina 22/08 19:45 2.58 0.40 2.18
S1 Raith R v Dunfermline 20/08 19:45 2.49 0.36 2.13
S1 Caledonian T v Ayr U 21/08 15:00 2.36 0.23 2.13
SL R Betis v N Cadiz 20/08 20:00 2.38 0.30 2.08
EP Brighton n H v Watford 21/08 17:30 2.27 0.24 2.03
C1 Lincoln v Bolton 17/08 19:45 2.28 0.29 1.99
EP Liverpool v Burnley 21/08 12:30 2.40 0.43 1.97
C2 Exeter C v Bristol R 21/08 15:00 2.09 0.16 1.93
S3 Elgin City v Forfar A 21/08 15:00 2.23 0.32 1.91
SL D Alaves v Mallorca 21/08 16:00 2.10 0.20 1.90
C0 Preston v Peterbrgh 21/08 15:00 2.02 0.12 1.90
C1 Fleetwood v CheltenhamT 21/08 15:00 2.10 0.25 1.85
P0 V Guimaraes v Vizela 22/08 20:30 2.06 0.22 1.84
C1 Portsmth v Shrewsbury 17/08 19:45 2.09 0.29 1.80
C1 Gillingham v Morecambe 21/08 15:00 2.05 0.25 1.80
FL Strasbourg v Troyes 22/08 14:00 2.11 0.33 1.78
C0 Reading v Bristol C 17/08 20:00 2.10 0.33 1.77
C1 Accrington v Doncaster 17/08 19:45 2.07 0.38 1.69
C2 Salford v Swindon 21/08 15:00 1.85 0.23 1.62
C1 Rotherham v SheffW 21/08 13:00 1.98 0.37 1.61
C0 Fulham v Hull C 21/08 15:00 1.98 0.39 1.59
S2 Alloa v Queen’s P 21/08 15:00 2.09 0.50 1.59
C2 Mansfield v Bradford 21/08 15:00 1.95 0.37 1.58
EP Crystal P v Brentford 21/08 15:00 2.00 0.42 1.58
GB Hoffenheim v U Berlin 22/08 14:30 2.09 0.51 1.58
SL Villarreal v Granada 16/08 19:00 2.10 0.53 1.57
C1 Sunderlnd v Wimbdon 21/08 15:00 2.11 0.54 1.57
C1 Oxford U v Crewe A 17/08 19:45 2.00 0.45 1.55
C0 Blackburn v West Brom 21/08 15:00 1.87 0.33 1.54
C1 Plymouth v Cambridge 17/08 19:45 1.94 0.41 1.53
C1 Wigan v Wycombe 17/08 19:45 1.83 0.30 1.53
C2 Scunthorpe v Sutton 21/08 15:00 1.76 0.24 1.52
FL Monaco v Lens 21/08 20:00 2.15 0.63 1.52
GB RB Leipzig v Stuttgart 20/08 19:30 2.04 0.62 1.42
C0 Barnsley v Luton T 17/08 19:45 1.79 0.38 1.41
GB Bayer L v Borussia M 21/08 17:30 2.16 0.75 1.41
C2 Forest G v Crawley 21/08 15:00 1.79 0.46 1.33
P0 Belenenses v Maritimo 16/08 21:15 1.57 0.40 1.17
C0 Millwall v Fulham 17/08 19:45 1.52 0.42 1.10
SL Granada v Valencia 21/08 18:30 1.70 0.63 1.07
HK Heerenveen v Waalwijk 21/08 17:45 1.60 0.55 1.05
C0 Cardiff C v Millwall 21/08 15:00 1.49 0.62 0.87
C0 Stoke C v Nottingham F 21/08 15:00 1.34 0.52 0.82
C2 Northampton v Rochdale 21/08 15:00 1.45 0.63 0.82
C1 Charlton v Wigan 21/08 15:00 1.55 0.77 0.78
HK Sparta v Heracles 21/08 19:00 1.61 0.84 0.77
C1 Ipswich T v Milton KD 21/08 15:00 1.40 0.74 0.66
S3 Stenhsmuir v Cowdnbeth 21/08 15:00 1.33 0.70 0.63
C2 Stevenage v Port V 21/08 15:00 1.22 0.59 0.63
FL Montpellier v Lorient 22/08 14:00 1.66 1.08 0.58
SP St. Jhnstone v Dndee U 22/08 15:00 1.14 0.57 0.57
EP Aston V v Newcastle U 21/08 15:00 1.48 0.99 0.49
P0 Tondela v Portimonense 22/08 15:30 1.24 0.75 0.49
C2 Tranmere v Newport 21/08 15:00 1.15 0.66 0.49
C0 Swansea v Stoke C 17/08 19:45 1.05 0.61 0.44
C2 Barrow v Exeter C 17/08 19:45 1.16 0.77 0.39
S2 Peterhead v Airdrie 21/08 15:00 1.20 0.84 0.36
C2 Harrogate T v Barrow 21/08 15:00 1.14 0.84 0.30
C1 Shrewsbury v Plymouth 21/08 15:00 1.29 1.00 0.29
C2 Walsall v Scunthorpe 17/08 19:45 1.10 0.82 0.28
S3 Albion R v Annan A 21/08 15:00 1.19 0.91 0.28
C2 Carlisle v Leyton O 21/08 15:00 1.07 0.80 0.27
C2 Oldham v Colchester 21/08 15:00 1.25 0.98 0.27
C1 Wimbledon v Gillingham 17/08 19:45 1.26 1.02 0.24
SL Elche v A Bilbao 16/08 21:00 1.05 0.89 0.16
C0 Luton T v Birmingham 21/08 15:00 1.01 0.86 0.15
C2 Port V v Carlisle U 17/08 19:45 0.98 0.83 0.15
FL Nice v Marseille 22/08 19:45 1.22 1.07 0.15
S2 East Fife v Montrose 21/08 15:00 1.24 1.12 0.12
C0 Coventry C v Reading 21/08 15:00 1.10 1.00 0.10
S3 Stranraer v Stirling A 21/08 15:00 1.24 1.14 0.10
S1 Hamilton v Kilmarnock 21/08 15:00 1.16 1.06 0.10
C2 Crawley v Salford 17/08 19:45 0.88 0.80 0.08
C1 Crewe v Accrington 21/08 15:00 1.13 1.05 0.08
S2 Dumbarton v Cove R 21/08 15:00 0.97 0.90 0.07
FL Bordeaux v Angers 22/08 12:00 1.10 1.04 0.06
FL Metz v Reims 22/08 14:00 1.11 1.07 0.04
C2 Colchester v Mansfield 17/08 19:45 1.02 1.03 -0.01
FL Rennes v Nantes 22/08 16:00 1.04 1.06 -0.02
EP Leeds U v Everton 21/08 15:00 1.08 1.11 -0.03
C0 West Brom v Sheff U 18/08 20:00 0.99 1.04 -0.05
P0 Boavista v Pacos de F 16/08 19:00 0.98 1.09 -0.11
S1 Morton v Queen O T S 21/08 15:00 1.10 1.22 -0.12
C0 QPR v Barnsley 21/08 12:30 0.89 1.03 -0.14
EP Arsenal v Chelsea 22/08 16:30 0.91 1.08 -0.17
C0 Middlesbro v QPR 18/08 19:45 0.83 1.08 -0.25
C0 Notts F v Blackburn 18/08 19:45 0.82 1.07 -0.25
C1 Milton KD v Charlton 17/08 19:45 1.00 1.26 -0.26
C1 Morecmbe v Rotherham 17/08 19:45 0.98 1.25 -0.27
GB Freiburg v Borussia D 21/08 14:30 1.18 1.67 -0.49
C2 Bradford C v Stevenage 17/08 19:45 0.57 1.16 -0.59
C0 Derby C v Middlesbro 21/08 15:00 0.61 1.28 -0.67
EP Wolves v Tottenham H 22/08 14:00 0.86 1.54 -0.68
C0 Sheff U v Huddersfield 21/08 15:00 0.68 1.37 -0.69
HK Groningen v Utrecht 21/08 20:00 0.62 1.43 -0.81
C0 Hull C v Derby C 18/08 19:45 0.51 1.36 -0.85
SP Livingston v Motherwell 21/08 15:00 0.57 1.46 -0.89
C1 Sheff W v Fleetwood 17/08 19:45 0.52 1.44 -0.92
C0 Huddersfield v Preston 17/08 19:45 0.58 1.53 -0.95
C2 Swindon v Tranmere 17/08 19:45 0.44 1.45 -1.01
SP Hearts v Aberdeen 22/08 15:00 0.57 1.62 -1.05
GB Greuther Fv Arminia B 21/08 14:30 0.58 1.64 -1.06
C0 Blackpool v Coventry 17/08 19:45 0.44 1.53 -1.09
C1 Wycombe W v Lincoln 21/08 15:00 0.49 1.58 -1.09
P0 Moreirense v Sp Braga 20/08 21:15 0.63 1.73 -1.10
C2 Bristol R v Oldham 17/08 19:45 0.57 1.68 -1.11
C2 Hartlepool v Walsall 21/08 15:00 0.41 1.52 -1.11
C1 Burton A v Sunderland 17/08 19:45 0.79 1.91 -1.12
IS Hellas V v Sassuolo 21/08 17:30 0.64 1.78 -1.14
C2 Rochdale v Forest G 17/08 19:45 0.40 1.63 -1.23
C1 Cheltenham v Ipswich 17/08 19:45 0.35 1.65 -1.30
GB Hertha B v Wolfsburg 21/08 14:30 0.55 1.95 -1.40
C1 Cambridge v Burton 21/08 15:00 0.34 1.82 -1.48
P0 Arouca v Famalicao 20/08 19:00 0.31 1.79 -1.48
HK Nijmegen v Zwolle 20/08 19:00 0.54 2.03 -1.49
C0 Bristol C v Swansea 20/08 19:45 0.30 1.80 -1.50
SL A Bilbao v Barcelona 21/08 21:00 0.58 2.10 -1.52
C0 Birmingham v Bournemth 18/08 19:45 0.45 2.00 -1.55
GB Bochum v Mainz 05 21/08 14:30 0.39 1.99 -1.60
FL St Etienne v Lille 21/08 16:00 0.41 2.13 -1.72
SP Dundee v Hibernian 22/08 12:00 0.32 2.06 -1.74
C1 Doncaster v Portsmth 21/08 15:00 0.38 2.24 -1.86
C1 Bolton W v Oxford U 21/08 15:00 0.35 2.23 -1.88
IS Udinese v Juventus 22/08 17:30 0.35 2.27 -1.92
P0 Gil Vicente v Benfica L 21/08 18:00 0.32 2.24 -1.92
IS Empoli FC v Lazio 21/08 19:45 0.38 2.33 -1.95
SL Levante v R Madrid 22/08 21:00 0.31 2.27 -1.96
SL Espanyol v Villarreal 21/08 18:30 0.26 2.27 -2.01
S3 Kelty Harts v Edinburgh 21/08 15:00 0.24 2.36 -2.12
C0 Peterborough v Cardiff 17/08 19:45 0.12 2.29 -2.17
FL Brest v Paris SG 20/08 16:30 0.35 2.58 -2.23
EP Southampton v Man U 22/08 14:00 0.35 2.63 -2.28
P0 Maritimo F v FC Porto 22/08 18:00 0.23 2.57 -2.34
IS Torino v Atalanta 21/08 19:45 0.42 2.95 -2.53
HK Twente v Ajax 22/08 11:15 0.23 2.78 -2.55
SP Ross C v Rangers 22/08 15:00 0.20 2.78 -2.58

Well it all looks great until I post it then all the column alignment is lost. Sorry