Get External Data from Web issue

Deep Analysis

New Member
Joined
Sep 8, 2015
Messages
11
Office Version
  1. 2016
Platform
  1. Windows
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!
 

Attachments

  • no years.JPG
    no years.JPG
    21.4 KB · Views: 10

Some videos you may like

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

denzo36

Board Regular
Joined
Sep 22, 2019
Messages
146
Office Version
  1. 365
Platform
  1. Windows
Hi there what version of Excel do you have?
 

denzo36

Board Regular
Joined
Sep 22, 2019
Messages
146
Office Version
  1. 365
Platform
  1. Windows
Ok you can use Power Query to connect to it

If you go the the Data tab -> New Query -> From Other Sources -> From Web then paste in your URL

From the resultant window, select the table on the left hand side (not document) - you'll then see a preview of the table

If you just want to take the table as it is then just click 'Load' to load it into the spreadsheet - if you want to transform the data in some way then select 'Edit' which will take you to the Power Query Editor
 

Deep Analysis

New Member
Joined
Sep 8, 2015
Messages
11
Office Version
  1. 2016
Platform
  1. Windows

ADVERTISEMENT

@denzo36 , thanks for the suggestion; however, it sems there is no way to loop this approach within the VBA macros.

Would there be any other alternatives using Data - Get External data - From Web?
 

denzo36

Board Regular
Joined
Sep 22, 2019
Messages
146
Office Version
  1. 365
Platform
  1. Windows
Are you trying to get all the data that is on the web page? I notice that there's Annual and Quarterly figures as well as Income Statement, Balance Sheet and Cash Flow that would manually need to click to get the figures to change - are you trying to 'loop' through these to get all the information on the web page?
 

Deep Analysis

New Member
Joined
Sep 8, 2015
Messages
11
Office Version
  1. 2016
Platform
  1. Windows

ADVERTISEMENT

Are you trying to get all the data that is on the web page? I notice that there's Annual and Quarterly figures as well as Income Statement, Balance Sheet and Cash Flow that would manually need to click to get the figures to change - are you trying to 'loop' through these to get all the information on the web page?
Even when I try to get data from web only for, lets say, Income statement annual - it doesn't show me the years on the top of the data. I.e. I get all the numbers, etc. However, I don't see for which years/periods they are. This is the main issue.
 

sandy666

Banned - Rules violations
Joined
Oct 24, 2015
Messages
7,499
there are dates as headers, do you see that?
Column126-Sep-2028-Sep-1929-Sep-1830-Sep-1724-Sep-16
Revenue274515260174265595229234215639
Total Revenue274515260174265595229234215639
Cost of Revenue, Total169559161782163756141048131376
Gross Profit104956983921018398818684263
Selling/General/Admin. Expenses, Total1991618245167051526114194
Research & Development1875216217142361158110045
Total Operating Expense208227196244194697167890155615
Operating Income6628863930708986134460024
Interest Inc.(Exp.),Net-Non-Op., Total8901385244628782543
Other, Net-87422-441-133-1195
Net Income Before Taxes6709165737729036408961372
Provision for Income Taxes968010481118721573815685
Net Income After Taxes5741155256610314835145687
Net Income Before Extra. Items5741155256610314835145687
Net Income5741155256595314835145687
Income Available to Com Excl ExtraOrd5741155256610314835145687
Income Available to Com Incl ExtraOrd5741155256595314835145687
Diluted Net Income5741155256595314835145687
Diluted Weighted Average Shares17528.2118595.6520000.4421006.7722001.12
Diluted EPS Excluding ExtraOrd Items3.282.973.052.32.08
DPS - Common Stock Primary Issue0.80.750.680.60.55
Diluted Normalized EPS3.282.973.052.32.08
Total Extraordinary Items-1500
 

Deep Analysis

New Member
Joined
Sep 8, 2015
Messages
11
Office Version
  1. 2016
Platform
  1. Windows
Yes, did you get them via New Query from Web? In this case, I couldn't loop the VBA code. Different companies might have different dates, so using the same for all the companies is not an option.
 

sandy666

Banned - Rules violations
Joined
Oct 24, 2015
Messages
7,499
fromweb.png

Power Query not tolerate vba

for different companies you can try query with parameter(s)
 

Watch MrExcel Video

Forum statistics

Threads
1,127,653
Messages
5,626,101
Members
416,161
Latest member
David1966Lewis

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top