Stock information into Excel

[A A Ron]

I have been having a heck of a time finding specific stock information and bringing it into Excel. I am aware of the formulas that allow you to bring in certain Yahoo Finance information. That is helpful for some of the variables I am working with, but I still have a few pices of info I can't pull up on certain companies.

The info that I am missing is the following:
Assets
Liabilities
Long Term Debt

Does anyone know how I can pull this in VBA, or if there are formulas I can use to pull this. I will be pulling info on 500 companies, so using the Data --> From Web function would take far too long.

Thank You in advance for the help!

 

[Bigbz]

Hi,

Sorry i cant help you, but I would also be keen on this information if anyone can help?

Thanks

 

[JoeMo]

Randy Harmelink has developed an extensive Excel add-in for accessing a wide spectrum of stock market information. Take a look at this website to get started.
https://groups.yahoo.com/neo/groups/smf_addin/info

 

[A A Ron]

Thank You Joe!

 

[JoeMo]

Thank You Joe!

You are welcome -thanks for the reply.