Web Query - Retrieve Dynamic Loaded Data? Query Results Blank

[bs0d]

I was looking for an answer to an Excel web query issue, and found a pseudo solution on an older thread (linked in trackback).

The issue I'm having is retrieving data from an Excel web query, where the data on the web is dynamically obtained after the page has loaded. The result is an empty table. When you visit the site, the table is temporarily empty, and data loaded within 1-2 seconds.

In the linked thread, a user posted the $_GET link to the data obtained through some browser monitoring tool.

I'm trying to get data from the same site (CME Group), but different tables. Can someone talk about obtaining right URL such that the data will pull for these tables:

• http://www.cmegroup.com/trading/energy/crude-oil/light-sweet-crude.html
• http://www.cmegroup.com/trading/energy/natural-gas/natural-gas.html

-OR- possibly delaying the fetch (if that would work)? Even if I try to just highlight and copy and paste directly into Excel without a web query- it crashes Excel (2013).

Thanks

 

[bs0d]

Any thoughts? Here is the related thread:
http://www.mrexcel.com/forum/excel-questions/444596-web-query-select-table-not-being-captured.html

 

[bs0d]

Delay macro perhaps? Thoughts?

 

[bs0d]

last bump.

 

[bs0d]

Surely someone has had to deal with this type of thing?