PDA

View Full Version : Import External Data



froggyface88
01-01-2014, 03:10 PM
I'm trying to write some code to automate my fantasy basketball analysis. I'm getting my data off of https://basketballmonster.com/Boxscores.aspx

I've been using Data -> import external data -> new web query to get the data off the website into excel. The first time I tried this was at night, after all games had been played that day, and the web query worked fine.

I'm trying again today from scratch, but none of today's games have been played yet. I'm looking to analyze the data from yesterday's games, but when I go through the new web query interface and click back to yesterday, then select the tables I want to import, I get the following error message: "This web query returned no data. To modify the query, click OK, click the name of the external data range in the name box on the formula bar, and then click Edit Query on the External Data toolbar".

Is there a way to use the web query feature on previous calendar days of the data?

Thanks!