7 Responses

  1. rockycolavito1
    rockycolavito1 at | | Reply

    I get all the way to step 16, but the final VLOOKUP formula results in a bunch of #N/A entries. Not sure why, everything else in the step by step worked perfectly.

  2. Mike
    Mike at | | Reply

    Can web queries also be used to automatically bring in projections as well? If so, how would one do that? Thanks!

    1. Tanner Bell
      Tanner Bell at | | Reply

      Hi Mike. Yes, you can use a web query to get just about any kind of data that’s in a table format on a web page (like the FantasyPros ADP). Projections would be another great candidate for this. You just need to find projections that are all listed on one page. That’s one of the really nice things about the FantasyPros site, they list everyone on one page and don’t divide it onto separate web pages (which would be difficult to web query).

      I should warn you that some sites do not allow web querying of their content so you should check the terms of use for the sites you want to pull from. I think they dislike people taking their content but not sticking around and using the site, viewing their ads, etc. .

      Just follow steps 1-8 above using the site you want to grab projections from.

  3. zdm
    zdm at | | Reply

    after i pasted the revised data into the PLAYERIDMAP, the three new columns were not inlcuded as part of the PLAYERIDMAP table, and therefore the vlookup is not finding the FANTPROSNAME link. for the life of me i can’t figure out how to add the three columns to the table! any help?

    1. Tanner
      Tanner at | | Reply

      Hi zdm. Let’s see if I can explain this without any screenshots. Go to the bottom right hand corner of the Player ID Map. Find the lower right hand corner of the “table”, where blue and white shading ends. Hover your mouse right over that bottom right hand corner and you will get the option to resize the table to include additional columns.. Click the mouse button down and drag the resize icon to the right in order to get more risks, etc.

Leave a Reply