Pulling certain info from Yahoo Finance without ticker symbols

Hi all,

I need some help with a project. Essentially, I need to pull the "Sector" and "Industry" of certain companies from yahoo finance to see how they are classified. Issue is, I have around 1,000 companies to do this for.

I am looking to build a macro that will take the company name in col B, and pull it's sector and industry and plant them into rows E and F. It then needs to repeat the process until it hits the bottom of the list. When the macro hits the first blank cell in column B, it should stop. Row 8 is my first row.

Is this even possible? The thought of doing this by hand (like a caveman) is enough to make me cringe. I can only make recorded macros, but after encountering a situation like this, i see a need to learn the real way.

Hello wolfy,

Welcome to the Forum!

If you want to retrieve information from a website, you need to provide that information (URL of the page you want). Some finance sites are accessible only if you are a member. Please let us know if this is a member only site.

Sincerely,
Leith Ross

It is a free site: finance.yahoo.com

For example, if the company I am looking for was Google, i would need the macro to go here: http://finance.yahoo.com/q/pr?s=GOOG which is the profile of the company, I would then need it to pull information from the "details" box. Specifically:

The "Sector", in this case, Technology, would need to go into column E.

The Industry, in this case, Internet Service Providors, would need to go into column F

to search for a company the macro must search the company name, "Google", and paste it into the "get quotes", then go to the "profile page".

If a ticker symbol is absolutely necessary, as to simply create a macro that plugs in the symbol at the end of the link shown above, I can possibly retrieve the tickers for each company.

Let me know and thanks a lot for the welcome!

Hi all - i have an easier request now. I recorded a macro that does basically what i want, but i need it to now loop itself until i hit the bottom of my list. Here's the macro: If there is an error, i would prefer it to just output "ERROR" or something to that effect just so i can esily identify them, but then continue down the list, but it's not necessary.

I have a feeling there's some not-needed stuff in there. I don't want it to always go to http://finance.yahoo.com/q/pr?s=goog obviously, but whatever link is in column D.

Please Login or Register  to view this content.

Ok, so this is my new Macro. All i need is for it to now loop. I used what you said, but I will now need it to run down the list until the list ends.

Please Login or Register  to view this content.