Get External Data from Web issue

[Deep Analysis]

Hi all,

I am trying to collect FInancial data from reuters.com, using Data - Get External data - From Web, where I simply paste, for example, this link AAPL.OQ - Apple Inc. Financials | Reuters and click Import.

However, when I get the data in Excel, I see everything except for the table headers (i.e. I don't see the years above the table) - cells are blank.

I would really appreciate your help to fix this issue.

Let me know if more info is needed. Attached is how I see the table in Excel. Thanks a lot!

 

[Deep Analysis]

Exactly, this is why I am thinking more about Data - Get External data - from Web. But then dates are not visible.

 

[sandy666]

update your profile (Account details) about Excel version and OS, don't forget to scroll down and hit save

 

[sandy666]

But then dates are not visible.

 

[Deep Analysis]

update your profile (Account details) about Excel version and OS, don't forget to scroll down and hit save

Done

 

[Deep Analysis]

View attachment 26219

A bit offtopic, do you see the same picture (see attached image)?

I have no idea why in this view years are not shown.

 

[sandy666]

maybe turn off Adblock or any other this kind software
or try another browser

 

[Deep Analysis]

I see it in browser, but not when I go through Data - Get External data - From web

 

[sandy666]

if you have XL2016 try my way from post#10 then post#13

 

[Deep Analysis]

But this approach means that it is impossible to loop it via VBA, right?

P.S. I really appreciate both your (sandy666) and denzo36 help. Just trying to understand what I can do with automating the task.

 

[sandy666]

read post#10 (not a picture there)
about parameters you can find info here

Power Query documentation - Power Query

Power Query is used to filter, combine, and mash up data from one or more supported data sources.

docs.microsoft.com

or google