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

Point Projections from FantasyPros not working #8

Closed scipio314 closed 6 years ago

scipio314 commented 7 years ago

FantasyPros has changed the URL to their point projections. The latest update (v1.5) corrects the URL. However some users still may have some problems. One solution might be logging into fantasypros via Excels browser. Steps to do that are below:

Important steps to get the player projections to work:

  1. Go to the "Data" tab in Excel and then select "Connections".
  2. Select "FPProjections" and click the "Properties" button.
  3. Go to "Definition" and then "Edit Query..."
  4. This will open the projections page. Select "yes" a ton of times.
  5. 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".
  6. Select that and login to fantasypros with your credentials.

From there you can hit cancel in the bottom left. This should work but I have been unable to properly test it. Report here if this doesn't work. You should only need to do these steps once.

scipio314 commented 6 years ago

Issue has been resolved in version 1.7