trouble linking to Yahoo finance (sales data)

C

ChristinaBB

New Member
Joined
Nov 23, 2010
Messages
6
I am having trouble linking to Yahoo finance data. I would like to use the Data/From Web for e.g. this page: Microsoft Corporation (MSFT) Income Statement - Yahoo Finance in order to extract eg the TTM Total Revenues.
However, when I paste the link into the Da
ta/From Web there is only Document, not Table available for selection (se attached screenshot).
What am I doing wrong?
 

Attachments

  • excel question.JPG
    excel question.JPG
    31.6 KB · Views: 10
  • yahoo finance question.JPG
    yahoo finance question.JPG
    193.7 KB · Views: 10

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.
Sort by date Sort by votes
You must log in or register to reply here.

Similar threads

A
  • Question Question
Excel Online Sharepoint - Workbook Links Updating with New Rows Added
Replies
0
Views
400
ah_mktanlys_01
A
N
  • Solved
VBA to separate three tabs form master and paste existing data's in it as "values" (no link to master when separated)
2
Replies
14
Views
640
nscaria00
N
Anigito
  • Question Question
Get Webpage Title Text by URL Generated in MS Excel
Replies
1
Views
1K
Anigito
Anigito
A
  • Locked
  • Question Question
how to get historical from data from yahoo finance Japan link from a particular Start Date to End date using VBA.
Replies
3
Views
945
Peter_SSs
Peter_SSs
A
  • Solved
How can I pull data or scrap table for multiple pages from the given link below for a particular start date to end date using VBA or power query?
Replies
6
Views
2K
abhi221996
A

Forum statistics

Threads
1,224,823
Messages
6,181,176
Members
453,021
Latest member
Justyna P

Share this page

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
Back
Top