form data, how did a team perform in the last 6 games

[1003064]

Hi Guys,
I have a spreadsheet with lots of football scores, I have attached it so you know what I'm talking about.

Here is one of the entries,[TABLE="class: text_table"]
<tbody style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; vertical-align: baseline;">[TR="class: text_table_cke_show_border"]
[TD]Ref[/TD]
[TD="width: 67"]Output[/TD]
[TD="width: 89"]Home[/TD]
[TD="width: 89"]Away[/TD]
[TD="width: 67"]HTHome[/TD]
[TD="width: 67"]HTAway[/TD]
[TD="width: 77"]Date[/TD]
[TD="width: 67"]FTHome[/TD]
[TD="width: 67"]FTAway[/TD]
[TD="width: 67"]HT[/TD]
[TD="width: 67"]FT[/TD]
[TD="width: 67"]HT FT[/TD]
[TD="width: 67"]Away HT[/TD]
[TD="width: 67"]Away FT[/TD]
[TD="width: 75"]Away HT FT[/TD]
[/TR]
[TR="class: text_table_cke_show_border"]
[TD]1[/TD]
[TD]1[/TD]
[TD]Arsenal[/TD]
[TD]Leicester[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]11/08/2017[/TD]
[TD]4[/TD]
[TD]3[/TD]
[TD]D[/TD]
[TD]W[/TD]
[TD]DW[/TD]
[TD]D[/TD]
[TD]L[/TD]
[TD]DL[/TD]
[/TR]
</tbody>[/TABLE]

So from this, I know that Arsenal Won the Game 4-3.

I have a long list of results like this,

What I want to do, is known the previous form before a game, so for example, on Boxing Day, Liverpool Played Swansea,[TABLE="class: text_table"]
<tbody style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; vertical-align: baseline;">[TR="class: text_table_cke_show_border"]
[TD]Ref[/TD]
[TD="width: 67"]Output[/TD]
[TD="width: 89"]Home[/TD]
[TD="width: 89"]Away[/TD]
[TD="width: 67"]HTHome[/TD]
[TD="width: 67"]HTAway[/TD]
[TD="width: 77"]Date[/TD]
[TD="width: 67"]FTHome[/TD]
[TD="width: 67"]FTAway[/TD]
[TD="width: 67"]HT[/TD]
[TD="width: 67"]FT[/TD]
[TD="width: 67"]HT FT[/TD]
[TD="width: 67"]Away HT[/TD]
[TD="width: 67"]Away FT[/TD]
[TD="width: 75"]Away HT FT[/TD]
[/TR]
[TR="class: text_table_cke_show_border"]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="class: text_table_cke_show_border"]
[TD]194[/TD]
[TD]20[/TD]
[TD]Liverpool[/TD]
[TD]Swansea[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]26/12/2017[/TD]
[TD]5[/TD]
[TD]0[/TD]
[TD]W[/TD]
[TD]W[/TD]
[TD]WW[/TD]
[TD]L[/TD]
[TD]L[/TD]
[TD]LL[/TD]
[/TR]
</tbody>[/TABLE]


I would like to know the form of Liverpool and Swansea in the last 6 games, for example, was Liverpools form W W W W W W, did they win all the last six games.

I will eventually be putting this information in number form, i.e. (3 for a win, 1 for a Draw, 0 for a Loss), so for example, a score of 18 for liverpool would mean that they won the last three.

The games can be home and away, I want to know the form of the last 6 games, regardless of whether it was home or away.

I also want to be able to drag the formula down, so then I can enter next weeks fixtures and get the form data based on the past form.

I have seen lots of people make a form table, the different with mine is I want to know them form at each fixture throughout the season.

It would be handy if the formulas could easily be adapted to check the form of the last 3 games also - if it is easy! Prem.xlsx

Any questions let me know.

Here is the link for the data http://www.football-data.co.uk/mmz4281/1718/E0.csv

Cheers!