Releases: scipio314/draftKnight
draftKnight v1.71
draftKnight v1.7
This update fixes projections not working due to the fantasypros dfs paywall area. It also is now compatible with the DraftKings new .csv format. I've also added a new feature to set exposure limits on players.
I am also in the process of creating a version to stack positions QB/WR, QB/RB, QB/TE. It is not functional at the moment.
Projections
- Fixed: FantasyPros stats are now sourced from this page: https://www.fantasypros.com/nfl/projections/qb.php and then calculated based on DraftKings scoring. The calculations are done in GoogleSheets and automatically updated every 4 hours.
All Players
- Fixed: Sheet is now compatible with the new DraftKings .csv lineup format.
Optimization Features
- New: Added the ability to set a maximum exposure. This Exp column can be updated to limit the amount of lineups the player can be in.
Ex: Setting an exposure of 20% forces the optimization to limit that player to only 20% of the lineups.
draftKnight v1.62
Small update to fix the duplicate Chris Thompson issue. Chris Thompson (WR HOU) will be placed on the ignored players list.
My Team Tab
Fix: Chris Thompson added to "ignored players" list
draftKnight v1.61
Quick update to fix the "performance" tab.
Fixed: Performance tab will properly update when you have more than 45 lineups to evaluate
NOTE YOU WILL NEED TO RE-DOWNLOAD THE DRAFTKINGS PLAYER POOL IN STEP 1 AND COPY AND PASTE YOUR LINEUPS FROM THE GENERATED .CSV FILE INTO THE "OPTIMAL LINEUPS" TAB.
draftKnight v1.6
All Players
- Fixed: Patrick Mahomes spelling to be compatible with fantasypros.
Lineup Errors
- Added: An error message will now pop up if there is an error.
Uploading to DraftKings
- Fixed: Opening and closing the generated .csv file is no longer needed to upload to DraftKings.
Performance Sheet
- Fixed: Formatting issues when not many optimized lineups were created.
My Team
- Fixed: Player news comment markers now get deleted properly. see this issue: #1
draftKnight v1.5
Updated for the 2017 season
Data Connection
- Updated the URL for fantasypros ECR projections page.
If you have problems with refreshing projections try doing the steps outlined below to login to fantasypros inside Excel.
Important steps to get the player projections to work:
- Go to the "Data" tab in Excel and then select "Connections".
- Select "FPProjections" and click the "Properties" button.
- Go to "Definition" and then "Edit Query..."
- This will open the projections page. Select "yes" a ton of times.
- Once you click through the pop-up hell, hover your mouse over the left hand side and move up and down until you see "Log In".
- Select that and login to fantasypros with your credentials.
You should only have to do this once. If this doesn't work go to this issues thread and report there. Someone may have a solution for you.
Players
- Created a script to update differences in player names (example: Mitchell Trubisky changes to Mitch Trubisky).
- Michael Thomas changed to Mike Thomas to avoid confusion.
draftKnight v1.4
Custom Projections
- Fixed: All previous entries are removed before adding new player pool.
Optimization Results
- Fixed: Previous entries are removed when downloading a new player pool.
Performance
- Fixed: Now supports more than 100 entries.
- Fixed: Graphs show more than 100 entries.
- Fixed: Formatting bugs.
- Fixed: .csv output file for a perfect lineup is now called "DKEntry - Perfect Lineup.csv" instead of "DKEntry - Post Optimal Lineup.csv"
My Team
- Fixed: WR's that get locked now appear darkened.
draftKnight v1.3
- Added: There is now a column on the "My Team" page that shows the opponent the player is facing. #2
draftKnight v1.2
- Fixed: workbook connections are now re-pathed to users folder directory.
draftKnight v1.1
- Fixed: Optimal team now shows up up on "Performance" sheet
- Fixed: Chart min and max values now adjust to results
- Fixed: Comment markers are now deleted when refreshing "My Team" page (hopefully)