Sunday, December 4, 2011

How do I make Excel web-query financial information?

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)|||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.

No comments:

Post a Comment