How to import Growth Estimates: Next 5 years(per annum) from yahoo finance to microsoft excel?
$\begingroup$
$\endgroup$
Add a comment
|
2 Answers
$\begingroup$
$\endgroup$
There is no direct connection for excel.
These steps work though.
Still tedious but Yahoo Finance is what it is. You can use https://finance.yahoo.com/quote/GOOG/analysis?p=GOOG and combine this with a query that executes for all tickers you would like. The ticker lookup is located here.
$\begingroup$
$\endgroup$
2
If you know about Microsoft Power BI, you can use it and pick which columns of which tables you want to import.
add tables using examples button at the bottom as in the attached images.
Then start to add items from tables then it will complete by itself automatically. The idea is that you try adding several different items from different tables in the new table in PowerBI then it will automatically collect all other items for these columns into the newly created one. Later on, when the source on Yahoo got updated your tables will be updated automatically. You can see more details about this feature on YouTube like these videos: https://www.youtube.com/results?search_query=add+table+using+examples+power+bi
-Later update-
Power Query in Excel does not include Add Table Using Examples option. check image below.
Good luck. Mohamed
-
$\begingroup$ It's the identical steps as outlined in my answer but a lot better presented! $\endgroup$– AKdemyMay 23, 2022 at 7:33
-
$\begingroup$ My friend, Power Query in Excel does not include the option or feature to add table using examples, and you can check it yourself as it is only available in Power BI. $\endgroup$ May 23, 2022 at 10:55