Yahoo Finance Scraper | How to scrape Yahoo Finance with no technical knowledge

If you are a savvy investor, it’s likely you follow the stock market on sites like Yahoo Finance. 

Problem: To do a proper analysis of the data, you need to extract Yahoo Finance information into a spreadsheet. But are you still using copy/paste? No way! 

Solution: Easily extract company information such as dividend, dividend yield, EPS, regular market price and many more from Yahoo Finance into a spreadsheet without any technical knowledge using our template to scrape Yahoo Finance and the ImportFromWeb add-on.

Yahoo Finance Scraper

Extract Yahoo Finance information easily with ImportFromWeb

To properly set yourself up to extract thousands of data points from Yahoo Finance, the first thing you need to do is copy the template of our Yahoo Finance Scraper and install the ImportFromWeb add-on into your Google Sheets. This is an easy process that just takes a minute and enables you to easily extract a high-volume of data from Yahoo Finance and most other websites.

Follow these steps:

  1. Make a copy of our Yahoo Finance Scraper here.

2. Simply, install the tool into your Google Sheets from the Google Workspace Marketplace following the step-by-step instructions indicated by the add-on. 

3. From there, you can access the tool by clicking “Add-ons” and activating ImportFromWeb within the spreadsheet. 

4. In the first tab, you will see a message ‘✓ You’re all set’ that indicates the add-on has been installed correctly and you’re ready to go!

Input the Stock Symbol into the Yahoo Finance Scraper

A stock symbol is a unique series of letters assigned to a security for trading purposes. Stocks listed on the New York Stock Exchange (NYSE) have four letters or less. Nasdaq-listed securities have up to five characters.

The only thing you need to know about the stock data you want to retrieve is the Stock Symbol. In Yahoo Finance the information about stocks is displayed in URLs such as this one: 

https://finance.yahoo.com/quote/LIN

In this example:

The Common URL to all market stocks: https://finance.yahoo.com/quote/

The Stock Symbol: LIN

So, in the second tab of the Yahoo Finance Scraper, introduce as many stock values as you want, one per row, using this pattern: Common URL + STOCK SYMBOL

In a few seconds, you will see all the indicators for each stock value appear in the spreadsheet! 

Yahoo Finance indicators you can extract with our scraper

When we say that you can extract hundreds of data points from Yahoo Finance with our scraper, we are serious! Here you have a list of the different data points you can retrieve: 

Indicators:
Previous Close
Open
Bid
Ask
Day Low
Day High
52 Week Low
52 Week High
Volume
Avg. Volume
Market Cap
Beta (5Y Monthly)
PE Ratio (TTM)
trailingPE
EPS
Earnings Date
Régular Market Price
dividend
Dividend Yield
Ex-Dividend Date
1y Target Est
Exchange Name
symbol
Enterprise Value
Trailing PE
Forward PE
PEG Ratio (5yrs)
PriceToSales
PriceToBook
Entreprise To Revenue
Enterprise To Ebitda
52-Week Change
S&P500 52-Week Change
52 Week High or Low
50-Day or 200-Day Moving Average
Avg Vol (3 month or 10 day)
Shares Outstanding
Implied Shares Outstanding
Float
% Held by Insiders
% Held by Institutions
Shares Short (specific date)
Short Ratio (specific date)
Short % of Float (specific date)
Short % of Shares Outstanding (specific date)
Shares Short (prior month)
Forward Annual Dividend Rate or Yield
Trailing Annual Dividend Rate or Yield
5 Year Average Dividend Yield
Payout Ratio
Dividend Date
Last Split Factor
Last Split Date
Fiscal Year Ends
Most Recent Quarter (mrq)
Profit Margin
Operating Margin (ttm)
Return on Assets (ttm)
Return on Equity (ttm)
Revenue (ttm)
Revenue Per Share (ttm)
Quarterly Revenue Growth (yoy)
Gross Profit (ttm)
EBITDA
Net Income Avi to Common (ttm)
Diluted EPS (ttm)
Quarterly Earnings Growth (yoy)
Total Cash (mrq)
Total Cash Per Share (mrq)
Total Debt (mrq)
Total Debt/Equity (mrq)
Current Ratio (mrq)
Book Value Per Share (mrq)
Operating Cash Flow (ttm)
Levered Free Cash Flow (ttm)
Name
Phone
Website
Address
City
State
Country
Sector
Industry
Full Time Employee
Key Executives/name
Key Executives/title
Key Executives/pay
Key Executives/year born
Description
Audit Risk
Board Risk
Compensation Risk
Share Holder Rights Risk
Overall Risk
No. of Analysts – current or next Quarter or  Year
Avg. Estimate – current or next Quarter or Year
Low Estimate- current or next Quarter or Year
high Estimate- current or next Quarter or Year
yearsAgoEPS Estimate- current or next Quarter or  Year
Year Ago Sales- current or next Quarter or Year
Sales Growth (year/est)- current or next Quarter  or Year
EPS Est. – 3, 6, 9, 12 month ago
EPS Actual – 3, 6, 9, 12 month ago
EPS Difference – 3, 6, 9, 12 month ago
Suprise % – 3, 6, 9, 12 month ago
Current Estimate – current or next Quarter
Current Estimate – current or next Year
7 Days Ago – current or next Quarter or Year
30 Days Ago – current or next Quarter or Year
60 Days Ago – current or next Quarter or Year
90 Days Ago – current or next Quarter or Year
Up Last 7 or 30 Days
Down Last 7 or 30 Days
Current or Next Quarter or Year
Next or Past 5 Years (per annum)
% of Shares Held by All Insider
% of Shares Held by Institutions
% of Float Held by Institutions
Number of Institutions Holding Shares
/HOLDER
/SHARES
/DATE REPORTED
/% OUT
VALUE
Total ESG Risk score
Environment Risk Score
Social Risk Score
Governance Risk Score
Significant Controversy level 

Did you find this tool useful?

Has it helped you to create your own Finance dashboards? We’d love to hear all of your feedback so that we can keep providing the best information on web scraping.