Streaming Data behind a Java Script

**Johnny_Drama** · 11-11-2010, 09:31 PM

Hi All,

I am looking to stream data from a website that is behind a java script. Specifically the website is here:

http://www.cmegroup.com/trading/agri...penOutcry.html

If you click the link, you will notice that the website takes a few moments before it starts retrieving the data from its actual source. I've tried using the "Get Data from an External Web Page" tool, but it doesn't stream the data because all I get is data before it starts streaming from the actual source. (In other words I get a bunch of hyphens.)

Is there anyway to obtain the data that comes a few seconds after?

Specifically I am hoping to obtain the value in the "Prior Settle" column, so I don't need the data to actually stream. I just require the closing price of the contract. I'm looking to use whatever macro /add-in / tip you guys give me, across different markets so it would also be helpful if you clarify what else I might need to change when looking at a different market.

Thanks for the help!

**antoka05** · 11-12-2010, 05:38 AM

See attached file, I hope it's what you need.

Regards,
Antonio

**snb** · 11-12-2010, 11:12 AM

Or, with minimum writing into the worksheet:

Please Login or Register  to view this content.

**Johnny_Drama** · 11-12-2010, 11:43 AM

Hi snb,

Thanks for the help/code, I'm a little busy right now so I wasn't able to check your code to see if it works, but I appreciate the help anyways. Thanks.

Hi Antoka05,

Thanks for the help! Much appreciated. I'm testing it across the markets I'm using (modifying for sheet name and url). However for some reason it did not work for this link:

http://www.cmegroup.com/trading/inte...sury-bond.html

I get the following error:

An Error Occurred: 91 - Object Variable or With Block Variable not set

Is there a way around this?

Please Login or Register  to view this content.

**snb** · 11-12-2010, 11:54 AM

No problem with:

Please Login or Register  to view this content.

**Johnny_Drama** · 11-12-2010, 12:28 PM

Hi SNB,

Thanks for your help, but for your code I get the error that internetexplorer has not been defined as a type?

**snb** · 11-12-2010, 12:32 PM

You have to activate/check the reference (Menu Bar in VBEditor/Extra/references/Microsoft Internet Controls)

**Johnny_Drama** · 11-12-2010, 12:48 PM

Thanks SNB! It now works for ZB. I'm really busy today, but I'm gonna test it across the markets I'm using tomorrow and if it works on all of them then I'll mark this thread solved.

For those in the future who have the same problem and come across this thread, the reference that SNB refers to is under Microsoft Browser Helpers in Excel 2007. (VBA-->Tools-->references-->Microsoft Browser Helpers)