What are the parameters for downloading financial information from yahoo finance?

Question

i am trying to get balance sheet , income statement and other stats in an excel macro and automatically put on a spreadsheet

Answer 1

I have a free open-source add-in that can get a lot of different information off of the web for you. The add-in, documentation, and sample templates can all be found in the files area of this Yahoo group:

http://finance.groups.yahoo.com/group/smf_addin/

I wrote the add-in because of issues I ran into using Web Queries, although in most cases they will probably get you what you want. A more comprehensive source of financial statements data can be found from AdvFN -- there is also a template for that in the files area. I also use a PHP routine to gather 10 years (or 20 quarters) of the financial statements data from AdvFN. For example (these can be opened directly into EXCEL):

http://ogres-crypt.com/php/advfn-financials.php?sym=MMM&per=q
http://ogres-crypt.com/php/advfn-financials.php?sym=MMM&per=a

Answer 2

If you copy one company's balance sheet/income statement/etc. into Excel, and create a refreshable web query (I believe thats the technical term), you can just "edit query" and type in the new ticker, which should get you the new data. I don't know how to write macros, so thats how I import data for valuation purposes...
Should you want to reach me for any reason, my email is [e-mail]
Hope this helps get you started.

Answer 3

Because "NTZ" is not really a "stock", its an ADR... Maybe you are a bit confused about what you are actually buying when you buy "NTZ" on the NYSE? NTZ is not shares of "stock", per se, but rather "American Depository Receipts". Since (Admittedly I may just be making a big assumption about you here!) you do not have a taxpayer ID as an Italian, you cannot invest directly in Italian stocks. Look up the data for Nokia (NOK), another ADR, and you will find the same "problem"! Best wishes!