Extracting data form Reuters using VBA?

[Tanya Addison]

Can some one help me with the code to extract data from Reuters or Bloomsberg into Excel using VBA?
A million thanks

Tanya

 

[Andrew Poulsom]

Can't you just create a Web query and record it? That will give you the code.

 

[Tanya Addison]

Could you expand on creating a web query? Thanks

 

[Andrew Poulsom]

Look it up in Excel Help. That explains it much better than I could.

 

[Ekim]

Depending on what you are doing, a web query can be a relatively easy matter or something quite complex.

See this article:

Web Queries and Dynamic Chart Data in Excel 2002
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnexcl2k2/html/odc_WebQueries.asp

Also, read the comments in the following reference and download a free sample file (the file retrieves financial information from Yahoo).

Using Excel Web Queries to Retrieve Global Historical Data from the Internet
http://www.willowsolutions.com/tips/tips_2002_08.shtml

You could contact Reuters or Bloomsberg directly to determine whether they have a free “off-the-shelf” Excel macro. A long shot, but worth a try.


HTH

 

[Tanya Addison]

Thanks for you help the links have been of great use to me!

Tanya

 

[Ekim]

Tanya,

Recently on another Board, someone asked the same question as you in relation to Bloomberg. In answering the question, a Microsoft MVP advised that Bloomberg provide an XL Add-In which allows a person to query their data directly from Excel. The MVP suggested that the person navigate to the download section somewhere in Bloomberg’s Help section.

Regards,

Mike