search

scipio314 / draftKnight

draftKnight is an excel sheet that generates optimized fantasy football lineups for DraftKings
GNU General Public License v3.0
31 stars 13 forks source link

Still working for 2020 Season :) #26

Open browneye-boop opened 3 years ago

browneye-boop commented 3 years ago

Hey scipio314 - awesome work. I was able to use this in last week's games. It takes some manual configuration since some projection values return 0 for players who's names on the spreadsheet may not match FantasyPros.

Was just wondering - are the projections in Standard, PPR or Half PPR?

scipio314 commented 3 years ago

Projections are based on DraftKings scoring.

These pages are scraped: https://www.fantasypros.com/nfl/projections/wr.php

Then their stats are converted into equivalent fantasy points based on DraftKings scoring (including bonuses for 100+ yards in a game).

browneye-boop commented 3 years ago

Thank you for the reply scipio314!

Is there any fix I can make to the spreadsheet to eliminate the manual work on the "My Team" tab of identifying player name cells who's corresponding value comes in as 0 simply because the value of the player name does not exactly match the player name value during the scraping process?

i.e. an example is DK Metcalf's value comes in as '0' after refreshing projections / injuries, because fantasy pros has his value as D.K. Metcalf (with punctuation after 'D' and 'K'.

scipio314 commented 3 years ago

My suggestion would be to create a column of "Fantasy Pros Names" and a second column "DraftKings Names" and try to do a conversion macro.