Forum Discussion
Get data from a Dynamic Webpage - How to change the table selector
Hi, I'm trying to get from web. I need the Income Statement (Quarterly data) for Apple from Yahoo Finance website: https://finance.yahoo.com/quote/AAPL/financials?p=AAPL&.tsrc=fin-srch Any idea on...
Thanks for feeding back, agree that copying and pasting is a work around but that would require me to repeate this task every quarter for every share I analyse. Is that the best PBI can offer me? To be quite honest I'm not impressed with PBI capabilities to get data from Web... :smileyfrustrated:
Hi, I'm trying to get from Yahoo Finance. I need the Income Statement (Quarterly data) for Apple from this link: https://finance.yahoo.com/quote/AAPL/financials?p=AAPL&.tsrc=fin-srch
Since the page address does not change, I have not managed to extract Quarterly data instead of Annual data which appears in the initial page.
Does anyone has a clever suggestion on how to manipulate the table selector (Annual /Quarterly)?
Regards,
Mark
Anonymous ,
You can contact Yahoo Finance support to check if it provides any Rest API to get the Quarterly data, it is possible to connect to REST API in web connector of Power BI Desktop.
Regards,
LydiaLygia, Yahoo Finance API was discontinued in May 18, 2018. So, we need to pursui another path to find out a solution.