Home » questions » How do I make Excel web-query financial information?

How do I make Excel web-query financial information?

1
2006-07-29 11:01:49, Category: Programming & Design
I'm trying to use Excel worksheets to gather financial information on companies from Yahoo Finance, MSN Money, Reuters etc. However, I want to make the worksheet pull information on whatever company symbol I enter? (For example, I enter YHOO and it pulls up data for YHOO) I've been using web-query (under Tools) to pull the info so far.

Answers

  1. Rafael

    On 2006-07-29 11:57:49


    You might need to write a macro for that. The macro itself is a complex Visual Basic program that would hunt up the web site you want and pick data from its databases, using a web service. However, i dont think its possible to rip data off the website for a company you want. Check with your company's IT.. thats the best bet.