Yahoo changed his structure for the financials (fundamental) report. In the past (last month) at the page https://finance.yahoo.com/quote/AAPL/financials?p=AAPL&guccounter=1 I could download the information regarding the financial Income Statement or Balance Sheet or Cash Flow in VBA Excel as a table. Now they have updated the "new" version that appears as a table but I cannot extract it con VBA Excel. There someone that can help me? If you need I can post the code in VBA regarding the old version, that can download all the tables in the HTML page.
To better explain I need the information in the yellow box.
You can see that it appears as a table, but if you look inside in the HTML code there is not the normal tag regarding tables.
I identify that the starting "table" has this tag <div class="D(tbrg)"
but I don't know how to proceed to extract data.
The same "table" is in the Balance Sheet and Cash Flow selection.
Thanks in advance
Power Query
akaGet & Transform
– Ron Rosenfeld