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: 9
  • yahoo finance question.JPG
    yahoo finance question.JPG
    193.7 KB · Views: 8

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)
Sort by date Sort by votes
You must log in or register to reply here.

Similar threads

A
  • Question
Excel Online Sharepoint - Workbook Links Updating with New Rows Added
Replies
0
Views
104
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
282
nscaria00
N
Anigito
  • Question
Get Webpage Title Text by URL Generated in MS Excel
Replies
1
Views
447
Anigito
Anigito
A
  • Locked
  • 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
766
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,215,166
Messages
6,123,395
Members
449,098
Latest member
ArturS75

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