Fftoday | | r/Fantasy_Football - Fantasy Football Advice

I'm pulling data from a table on a webpage. I would like a shorter process to be able to get the different table parameters data, since only a single number is changing in the URL. Looking at the advanced editor in power query makes me believe it can be done..
Current Process In Power Query:

Click "New Source">"Other Sources">"Web"
Paste URL>add week number {1,2,...,18} to URL "&GameWeek={#}" >
Connect> Select Table 3(always table 3)> Load.
Repeat for Weeks 1-18 >
Append first query with all subsequent weeks' queries.

For example this is the M Query Code of separately loading two tables and then appending the two tables together (table "week 3" with table "week 4"):
let
Source = Web.Page(Web.Contents("https://www.fftoday.com/stats/playerstats.php?Season=2022&GameWeek=1&PosID=20&LeagueID=193033")),
Data3 = Source{3}[Data],
#"Promoted Headers" = Table.PromoteHeaders(Data3, [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Player#(cr)#(lf)Sort First: Last:", type text}, {"Team", type text}, {"G", Int64.Type}, {"Att", Int64.Type}, {"Yard", Int64.Type}, {"TD", Int64.Type}, {"Target", Int64.Type}, {"Rec", Int64.Type}, {"Yard_1", Int64.Type}, {"TD_2", Int64.Type}, {"FPts", type number}, {"FPts/G", type number}}),
#"Appended Query" = Table.Combine({#"Changed Type", #"Table 3 (3)", #"Table 3 (4)"})
in
#"Appended Query"
I would like to know if its possible to code all the sources into one query or IDK just make it so this process isnt so time consuming...

Thanks in advance.

Link has 2022 run-pass attempts per game. Phillie (32) averaged one more run per game than Dallas (31). Only ten teams ran higher percentage.
Not seeing where running more will help us. Especially if we don’t add an excellent RB. If Pollard gets in low 20’s attempts, who can be effective on other 12? Consistent running first downs, 5/6 per drive?
https://fftoday.com/stats/22_run_pass_ratios.html

[Part 1- Passing Game]
[Part 2- Rushing and Special Teams] <--- You are here
[Part 3- Defense and Non-QB Offense]
[Part 4- QBs and Team Quadrant Charts]

https://preview.redd.it/ccr2nsvpy7ja1.jpg?width=1413&format=pjpg&auto=webp&s=8b1685f1379b02a65bf06e25c55c4228fd1d52ff

https://preview.redd.it/l9xz5b0ry7ja1.jpg?width=1398&format=pjpg&auto=webp&s=07699f8792fea0c59a1d47813c4b5a3288ba3b3a

https://preview.redd.it/yig4uuwry7ja1.jpg?width=1412&format=pjpg&auto=webp&s=b08cc2f137c724a2a8da5775cccd71c4227b5002

https://preview.redd.it/3pfrnovc58ja1.jpg?width=1412&format=pjpg&auto=webp&s=687bd0d59c681498db0844dc2fdcc4574d923083

https://preview.redd.it/hvh2gxfvy7ja1.jpg?width=1412&format=pjpg&auto=webp&s=cad57cacdee6e5ee662ec25a907ce02f9c06a061

Most of the data is from the regular season, but I used regular season+playoffs anywhere I could find it. Z-Scores are measured against the average of ALL NFL teams. Z-Scores exclusively use team/positional group data (this includes QB groups). If you're looking to dunk on individual players, this isn't really the right data to do so.

Tried to account for QBs as much as I could so that each QB group's impact could be estimated later on.

Playoff byes were counted as wins so as to accurately reflect how far each team got.

Credit to u/dvd5671 for the idea to use team logos as data points.

Data	Source	Link
Rush Att (Team), Rush Yd (Team)	NFL Stats	Link
Rush att (QB), Rush Yd (QB)	Fantasy Football Today	Link
FG Att, FG Made, FG %, PAT %	NFL Stats	Link

Edit: Duplicate Jags logo corrected in 4th chart

New week, new charts! Please find below a graphical representation of fantasy football data trends for Fantasy Points Allowed compliments of FF Today.

Because things change so drastically on a week to week basis in the NFL, I wanted to see how the matchups looked using a three week window.

Here's the results for Week 17:

Scoring Rules	URL
Standard	https://i.imgur.com/cVtyUn6.png
0.5 PPR	https://i.imgur.com/jVw5G0u.png
PPR	https://i.imgur.com/rK6zK6f.png

How to read the chart: This data is showing the amount of points allowed, so if you’re looking at QBs, the Philadelphia Eagles are allowing a lot of PPG in the last 3 weeks (good matchup for Andy Dalton) while the Cleveland Browns are not (bad matchup for Taylor Heinicke).

Blue = good matchup, White = average matchup, Red = bad matchup.
The team in the Opponent column is who plays the team on the left this week.
The teams in the Prev 3 Opponents column are the teams that the team on the left has played in the last 3 weeks.
The team in the Opponent column is who plays the team on the left this week.
The team in the Next Opponent column is who plays the team on the left next week.
Teams with a bye in the last 3 weeks will look back a 4th week to capture 3 games worth of data.

Please keep in mind that D/ST Data will likely be different due to varied league settings.

Also, some have asked for the ability to sort by position, so here's a link to the data in a Google Doc.
Best of luck in the playoffs this week!

New week, new charts! Please find below a graphical representation of fantasy football data trends for Fantasy Points Allowed compliments of FF Today.

Because things change so drastically on a week to week basis in the NFL, I wanted to see how the matchups looked using a three week window.

Here's the results for Week 16:

Scoring Rules	URL
Standard	https://i.imgur.com/qJzaFSB.png
0.5 PPR	https://i.imgur.com/u1NuVfO.png
PPR	https://i.imgur.com/36Z6zqN.png

How to read the chart: This data is showing the amount of points allowed, so if you’re looking at QBs, the Tennessee Titans are allowing a lot of PPG in the last 3 weeks (good matchup for Davis Mills) while the Pittsburgh Steelers are not (bad matchup for Derek Carr).

Blue = good matchup, White = average matchup, Red = bad matchup.
The team in the Opponent column is who plays the team on the left this week.
The teams in the Prev 3 Opponents column are the teams that the team on the left has played in the last 3 weeks.
The team in the Opponent column is who plays the team on the left this week.
The team in the Next Opponent column is who plays the team on the left next week.
Teams with a bye in the last 3 weeks will look back a 4th week to capture 3 games worth of data.

Please keep in mind that D/ST Data will likely be different due to varied league settings.

Also, some have asked for the ability to sort by position, so here's a link to the data in a Google Doc.
Best of luck in the playoffs this week!

New week, new charts! Please find below a graphical representation of fantasy football data trends for Fantasy Points Allowed compliments of FF Today.

Because things change so drastically on a week to week basis in the NFL, I wanted to see how the matchups looked using a three week window.

Here's the results for Week 15:

Scoring Rules	URL
Standard	https://i.imgur.com/zPVU57T.png
0.5 PPR	https://i.imgur.com/yUPW638.png
PPR	https://i.imgur.com/A6K8xyX.png

How to read the chart: This data is showing the amount of points allowed, so if you’re looking at QBs, the Tennessee Titans are allowing a lot of PPG in the last 3 weeks (good matchup for Justin Herbert) while the Pittsburgh Steelers are not (bad matchup for Sam Darnold).

Blue = good matchup, White = average matchup, Red = bad matchup.
The team in the Opponent column is who plays the team on the left this week.
The teams in the Prev 3 Opponents column are the teams that the team on the left has played in the last 3 weeks.
The team in the Opponent column is who plays the team on the left this week.
The team in the Next Opponent column is who plays the team on the left next week.
Teams with a bye in the last 3 weeks will look back a 4th week to capture 3 games worth of data.

Please keep in mind that D/ST Data will likely be different due to varied league settings.

Also, some have asked for the ability to sort by position, so here's a link to the data in a Google Doc.
Best of luck in the playoffs this week!

Hey folks!
If you've frequented the sub throughout the season, you might have seen my charts that show weekly matchups based on stats from the last 3 weeks of games compliments of FFToday.
The below chart takes that same dataset and shows the upcoming matchups for teams so that you can better prepare for the quickly approaching playoffs.

https://i.imgur.com/ahrYqEL.png

Link to Google Sheet for easier mobile experience

How to read the chart: This dataset is ranking matchups for Weeks 15-17 for the players playing for the teams on the left-hand side.

A rank of 1 indicates that the players for this team have the best matchup on paper while a rank of 32 indicates that the players for this team have the worst matchup.
Blue = good matchup, White = average matchup, Red = bad matchup.
Rather than look at season long trends, I am using the last three weeks of data to determine rankings.
Teams with a bye in the last 3 weeks will look back a 4th week to capture 3 games worth of data.

Bring home those trophies!!!

New week, new charts! Please find below a graphical representation of fantasy football data trends for Fantasy Points Allowed compliments of FF Today.

Because things change so drastically on a week to week basis in the NFL, I wanted to see how the matchups looked using a three week window.

Here's the results for Week 14:

Scoring Rules	URL
Standard	https://i.imgur.com/587Iexn.png
0.5 PPR	https://i.imgur.com/PZV6arr.png
PPR	https://i.imgur.com/RrYZLXi.png

How to read the chart: This data is showing the amount of points allowed, so if you’re looking at QBs, the Jacksonville Jaguars are allowing a lot of PPG in the last 3 weeks (good matchup for Ryan Tannehill) while the Houston Texans are not (bad matchup for Dak Prescott).

Blue = good matchup, White = average matchup, Red = bad matchup.
The team in the Opponent column is who plays the team on the left this week.
The teams in the Prev 3 Opponents column are the teams that the team on the left has played in the last 3 weeks.
The team in the Opponent column is who plays the team on the left this week.
The team in the Next Opponent column is who plays the team on the left next week.
Teams with a bye in the last 3 weeks will look back a 4th week to capture 3 games worth of data.

Please keep in mind that D/ST Data will likely be different due to varied league settings.

Also, some have asked for the ability to sort by position, so here's a link to the data in a Google Doc.
Best of luck in this week!

New week, new charts! Please find below a graphical representation of fantasy football data trends for Fantasy Points Allowed compliments of FF Today.

Because things change so drastically on a week to week basis in the NFL, I wanted to see how the matchups looked using a three week window.

Here's the results for Week 13:

Scoring Rules	URL
Standard	https://i.imgur.com/Q7winYO.png
0.5 PPR	https://i.imgur.com/TQsNzll.png
PPR	https://i.imgur.com/tImXXUV.png

How to read the chart: This data is showing the amount of points allowed, so if you’re looking at QBs, the Detroit Lions are allowing a lot of PPG in the last 3 weeks (good matchup for Trevor Lawrence) while the San Francisco 49ers are not (bad matchup for Tua Tagovailoa).

Blue = good matchup, White = average matchup, Red = bad matchup.
The team in the Opponent column is who plays the team on the left this week.
The teams in the Prev 3 Opponents column are the teams that the team on the left has played in the last 3 weeks.
The team in the Opponent column is who plays the team on the left this week.
The team in the Next Opponent column is who plays the team on the left next week.
Teams with a bye in the last 3 weeks will look back a 4th week to capture 3 games worth of data.

Please keep in mind that D/ST Data will likely be different due to varied league settings.

Also, some have asked for the ability to sort by position, so here's a link to the data in a Google Doc.
Lastly, in the spirit of Giving Tuesday, every year our show gives back to the Greater Pittsburgh community via our Rocking Around the 412 fundraiser. Every single penny goes to less fortunate families in our area to provide a Christmas for their children that otherwise wouldn't be possible. Last year alone, we were able to provide Christmas in it's entirety to 30 kids across 13 different families in our area. If you feel like these charts have helped out this year, we'd appreciate it if you consider donating!

Best of luck in this week!

New week, new charts! Please find below a graphical representation of fantasy football data trends for Fantasy Points Allowed compliments of FF Today.

Because things change so drastically on a week to week basis in the NFL, I wanted to see how the matchups looked using a three week window.

Here's the results for Week 12:

Scoring Rules	URL
Standard	https://i.imgur.com/GXm8T5T.png
0.5 PPR	https://i.imgur.com/jv9lpjm.png
PPR	https://i.imgur.com/zhPGxhU.png

How to read the chart: This data is showing the amount of points allowed, so if you’re looking at QBs, the Detroit Lions are allowing a lot of PPG in the last 3 weeks (good matchup for Josh Allen) while the Philadelphia Eagles are not (bad matchup for Aaron Rodgers).

Blue = good matchup, White = average matchup, Red = bad matchup.
The team in the Opponent column is who plays the team on the left this week.
The teams in the Prev 3 Opponents column are the teams that the team on the left has played in the last 3 weeks.
The team in the Opponent column is who plays the team on the left this week.
The team in the Next Opponent column is who plays the team on the left next week.
Teams with a bye in the last 3 weeks will look back a 4th week to capture 3 games worth of data.

Please keep in mind that D/ST Data will likely be different due to varied league settings.

Also, some have asked for the ability to sort by position, so here's a link to the data in a Google Doc.
Best of luck in this week!

New week, new charts! Please find below a graphical representation of fantasy football data trends for Fantasy Points Allowed compliments of FF Today.

Because things change so drastically on a week to week basis in the NFL, I wanted to see how the matchups looked using a three week window.

Here's the results for Week 11:

Scoring Rules	URL
Standard	https://i.imgur.com/mOOOmQb.png
0.5 PPR	https://i.imgur.com/rwXGrwo.png
PPR	https://i.imgur.com/kxJoF66.png

How to read the chart: This data is showing the amount of points allowed, so if you’re looking at QBs, the Detroit Lions are allowing a lot of PPG in the last 3 weeks (good matchup for Daniel Jones) while the Denver Broncos are not (bad matchup for Derek Carr).

Blue = good matchup, White = average matchup, Red = bad matchup.
The team in the Opponent column is who plays the team on the left this week.
The teams in the Prev 3 Opponents column are the teams that the team on the left has played in the last 3 weeks.
The team in the Opponent column is who plays the team on the left this week.
The team in the Next Opponent column is who plays the team on the left next week.
Teams with a bye in the last 3 weeks will look back a 4th week to capture 3 games worth of data.

Please keep in mind that D/ST Data will likely be different due to varied league settings.

Also, some have asked for the ability to sort by position, so here's a link to the data in a Google Doc.
Best of luck in this week!

New week, new charts! Please find below a graphical representation of fantasy football data trends for Fantasy Points Allowed compliments of FF Today.

Because things change so drastically on a week to week basis in the NFL, I wanted to see how the matchups looked using a three week window.

Here's the results for Week 10:

Scoring Rules	URL
Standard	https://i.imgur.com/XLDh5QW.png
0.5 PPR	https://i.imgur.com/kWbtUr9.png
PPR	https://i.imgur.com/O1m6IC3.png

How to read the chart: This data is showing the amount of points allowed, so if you’re looking at QBs, the Arizona Cardinals are allowing a lot of PPG in the last 3 weeks (good matchup for Matthew Stafford) while the Denver Broncos are not (bad matchup for Ryan Tannehill/Malik Willis).

Blue = good matchup, White = average matchup, Red = bad matchup.
The team in the Opponent column is who plays the team on the left this week.
The teams in the Prev 3 Opponents column are the teams that the team on the left has played in the last 3 weeks.
The team in the Opponent column is who plays the team on the left this week.
The team in the Next Opponent column is who plays the team on the left next week.
Teams with a bye in the last 3 weeks will look back a 4th week to capture 3 games worth of data.

Please keep in mind that D/ST Data will likely be different due to varied league settings.

Also, some have asked for the ability to sort by position, so here's a link to the data in a Google Doc.
Best of luck in this week!

https://twitter.com/JameyEisenberg/status/1589285064084705280?t=l_3275pKVw-1UxXlzdEISg&s=19
We just had Tom Spencer on @FFToday on @CBSSportsHQ & he's in the booth w/ Nantz & Romo. He said Rachaad White could play as much as 40% of the snaps as the Bucs want to ease the workload a little for Leonard Fournette. We'll see what happens but make sure White is rostered.

New week, new charts! Please find below a graphical representation of fantasy football data trends for Fantasy Points Allowed compliments of FF Today.

Because things change so drastically on a week to week basis in the NFL, I wanted to see how the matchups looked using a three week window.

Here's the results for Week 9:

Scoring Rules	URL
Standard	https://i.imgur.com/cu9i7lb.png
0.5 PPR	https://i.imgur.com/MztFsEI.png
PPR	https://i.imgur.com/EHs6yij.png

How to read the chart: This data is showing the amount of points allowed, so if you’re looking at QBs, the Atlanta Falcons are allowing a lot of PPG in the last 3 weeks (good matchup for Justin Herbert) while the LA Rams are not (bad matchup for Tom Brady).

Blue = good matchup, White = average matchup, Red = bad matchup.
The team in the Opponent column is who plays the team on the left this week.
The teams in the Prev 3 Opponents column are the teams that the team on the left has played in the last 3 weeks.
The team in the Opponent column is who plays the team on the left this week.
The team in the Next Opponent column is who plays the team on the left next week.
Teams with a bye in the last 3 weeks will look back a 4th week to capture 3 games worth of data.

Please keep in mind that D/ST Data will likely be different due to varied league settings.

Also, some have asked for the ability to sort by position, so here's a link to the data in a Google Doc.
Best of luck in this week!

New week, new charts! Please find below a graphical representation of fantasy football data trends for Fantasy Points Allowed compliments of FF Today.

Because things change so drastically on a week to week basis in the NFL, I wanted to see how the matchups looked using a three week window.

Here's the results for Week 8:

Scoring Rules	URL
Standard	https://i.imgur.com/7jSbBjG.png
0.5 PPR	https://i.imgur.com/iDCWqQA.png
PPR	https://i.imgur.com/PxQA5iA.png

How to read the chart: This data is showing the amount of points allowed, so if you’re looking at QBs, the Atlanta Falcons are allowing a lot of PPG in the last 3 weeks (good matchup for PJ Walker) while the LA Rams are not (bad matchup for Jimmy Garoppolo).

Blue = good matchup, White = average matchup, Red = bad matchup.
The team in the Opponent column is who plays the team on the left this week.
The teams in the Prev 3 Opponents column are the teams that the team on the left has played in the last 3 weeks.
The team in the Opponent column is who plays the team on the left this week.
The team in the Next Opponent column is who plays the team on the left next week.
Teams with a bye in the last 3 weeks will look back a 4th week to capture 3 games worth of data.

Please keep in mind that D/ST Data will likely be different due to varied league settings.

Also, some have asked for the ability to sort by position, so here's a link to the data in a Google Doc.
Best of luck in this week!

New week, new charts! Please find below a graphical representation of fantasy football data trends for Fantasy Points Allowed compliments of FF Today.

Because things change so drastically on a week to week basis in the NFL, I wanted to see how the matchups looked using a three week window.

Here's the results for Week 7:

Scoring Rules	URL
Standard	https://i.imgur.com/JqEmhzH.png
0.5 PPR	https://i.imgur.com/LncPylQ.png
PPR	https://i.imgur.com/oRaPKnH.png

How to read the chart: This data is showing the amount of points allowed, so if you’re looking at QBs, the Las Vegas Raiders are allowing a lot of PPG in the last 3 weeks (good matchup for Davis Mills) while the Green Bay Packers are not (bad matchup for Taylor Heinicke).

Blue = good matchup, White = average matchup, Red = bad matchup.
The team in the Opponent column is who plays the team on the left this week.
The teams in the Prev 3 Opponents column are the teams that the team on the left has played in the last 3 weeks.
The team in the Opponent column is who plays the team on the left this week.
The team in the Next Opponent column is who plays the team on the left next week. NEW
Teams with a bye in the last 3 weeks will look back a 4th week to capture 3 games worth of data.

Please keep in mind that D/ST Data will likely be different due to varied league settings.

Also, some have asked for the ability to sort by position, so here's a link to the data in a Google Doc.
Best of luck in this week!

New week, new charts! Please find below a graphical representation of fantasy football data trends for Fantasy Points Allowed compliments of FF Today.

Because things change so drastically on a week to week basis in the NFL, I wanted to see how the matchups looked using a three week window.

Here's the results for Week 6:

Scoring Rules	URL
Standard	https://i.imgur.com/qI7lLMm.png
0.5 PPR	https://i.imgur.com/L4l191e.png
PPR	https://i.imgur.com/sWtUTRm.png

How to read the chart: This data is showing the amount of points allowed, so if you’re looking at QBs, the Pittsburgh Steelers are allowing a lot of PPG in the last 3 weeks (good matchup for Tom Brady) while the LA Rams are not (bad matchup for PJ Walker).

Blue = good matchup, White = average matchup, Red = bad matchup.
The team in the Opponent column is who plays the team on the left this week.
The teams in the Prev 3 Opponents column are the teams that the team on the left has played in the last 3 weeks.
The team in the Opponent column is who plays the team on the left this week.
Teams with a bye in the last 3 weeks will look back a 4th week to capture 3 games worth of data

Please keep in mind that D/ST Data will likely be different due to varied league settings.

Also, some have asked for the ability to sort by position, so here's a link to the data in a Google Doc.
Best of luck in this week!

New week, new charts! Please find below a graphical representation of fantasy football data trends for Fantasy Points Allowed compliments of FF Today.

Because things change so drastically on a week to week basis in the NFL, I wanted to see how the matchups looked using a three week window.

Here's the results for Week 5:

Scoring Rules	URL
Standard	https://i.imgur.com/UPRMQb8.png
0.5 PPR	https://i.imgur.com/KKY04Gr.png
PPR	https://i.imgur.com/PGzOqAI.png

How to read the chart: This data is showing the amount of points allowed, so if you’re looking at QBs, the Miami Dolphins are allowing a lot of PPG in the last 3 weeks (good matchup for Zach Wilson) while the San Francisco 49ers are not (bad matchup for Baker Mayfield).

Blue = good matchup, White = average matchup, Red = bad matchup.
The team in the Opponent column is who plays the team on the left this week.
The teams in the Prev 3 Opponents column are the teams that the team on the left has played in the last 3 weeks.
The team in the Opponent column is who plays the team on the left this week.
Teams with a bye in the last 3 weeks will look back a 4th week to capture 3 games worth of data

Please keep in mind that D/ST Data will likely be different due to varied league settings.

Also, some have asked for the ability to sort by position, so here's a link to the data in a Google Doc.
Best of luck in this week!

We are three weeks in, so I am back for another season to bring you the latest data trends for Fantasy Points Allowed compliments of FFToday.

Because things change so drastically on a week to week basis in the NFL, I wanted to see how the matchups looked using a three week window.

Here's the results for Week 4:

Scoring Rules	URL
Standard	https://i.imgur.com/rUWObK0.png
0.5 PPR	https://i.imgur.com/AtohAMi.png
PPR	https://i.imgur.com/5viouQ2.png

How to read the chart: This data is showing the amount of points allowed, so if you’re looking at QBs, the Miami Dolphins are allowing a lot of PPG in the last 3 weeks (good matchup for Joe Burrow) while the Buffalo Bills are not (bad matchup for Lamar Jackson).

Blue = good matchup, White = average matchup, Red = bad matchup.
The team in the Opponent column is who plays the team on the left this week.
The teams in the Prev 3 Opponents column are the teams that the team on the left has played in the last 3 weeks.
Teams with a bye in the last 3 weeks will look back a 4th week to capture 3 games worth of data.

Please keep in mind that D/ST Data will likely be different due to varied league settings.

Also, some have asked for the ability to sort by position, so here's a link to the data in a Google Doc.