Link Excel to Yahoo Finance

[andreastasia95]

Hello everybody,
I'm trying to download financial data from yahoo finance: specifically I have all the tickers of the shares of the Italian market (circa 450 stocks) in an Excel file and I would like to extract some tables from the "key-statistics" section. I'm not very skilled with VBA and what I did was create a query that uses a variable input (the link, easily reconstructed), based on the youtube tutorial (

). This procedures works with the downloading from reuters.com, but the problem for using that site is that I should know the RICs (reuters id of a stock), with yahoo finance I have to know only the ticker and I know it.

The problem is that while writing the exact link, Excel cannot extract the tables, but doing single a single query for every ticker, it works. I think that the problem is related to the existance of a lot of tables in that yahoo finance page (for example look at NEXI (NEXI.MI) Misure di valutazione e statistiche finanziarie).

I'm going crazy, does anyone have any ideas?

Thank you!!

 

[andreastasia95]

Sorry but i don't understand... power query and these thing are a new world for me

 

[sandy666]

drag Attribute column to the end or simply right click on this column and select Remove

I suggest to reaad:

• What is PowerQuery
• Getting started with PQ
• PowerQuery Help
• PowerQuery M reference

 

[andreastasia95]

Thank you very much!

You solved a very big problem for me

 

[sandy666]

LOL really ? so I am glad I could help

 

[andreastasia95]

Yeah, because now I have the possibility to use these data for some analysis, like a financial provider, but are free!!

Thanks

 

[sandy666]

You are welcome
Thanks for the feedback