Excel Price Feed for
Fundamental Analysis

Q: How do I do fundamental analysis in Excel with Excel Price Feed?

Excel Price Feed is an Excel Add-in that provides formulas to pull income statement, balance sheet and cash flow data from Yahoo Finance directly into your spreadsheet. Enter a formula such as =EPF.Yahoo.AnnualRevenue("AAPL",2025), press Refresh Sheet, and combine the live data with your own analysis.

Q: Can I get Yahoo Finance fundamental data in Excel without copy and paste?

Yes. Excel Price Feed fetches Yahoo Finance fundamental data automatically using Excel formulas. You do not need to copy and paste figures from the Yahoo Finance website into your spreadsheet.

Q: What fundamental data does Excel Price Feed provide from Yahoo Finance?

Excel Price Feed provides approximately four years of annual financials and quarterly metrics covering income statements, balance sheets and cash flow statements, plus trailing twelve months (TTM) figures and key financial ratios such as P/E ratio and dividend yield.

Q: What Excel formulas are available for stock fundamental analysis?

Excel Price Feed includes Yahoo Finance formulas for annual, quarterly and TTM data, plus key financial ratio formulas such as =EPF.Yahoo.PERatio. See the formula reference for balance sheet, cash flow, income statement and key financial ratios.

Q: Do I need a Yahoo Finance account to use Excel Price Feed fundamental data formulas?

No. Yahoo Finance is included with Excel Price Feed and does not require a Yahoo account or API key.

Q: Are there Excel templates for fundamental stock analysis?

Yes. Excel Price Feed provides ready-to-use templates including Stock Fundamental Analysis, Company Income Summary 10-K and Stock Cash Flow, all populated with Yahoo Finance formulas.

No copying and pasting from websites into your spreadsheet
Analyse key financial ratios, income statements, balance sheet and cash flow data in Excel
Compare valuation ratios and financial metrics across companies
Simple Excel formulas for annual and quarterly fundamental data

Data is fetched directly from Yahoo Finance via Excel Price Feed formulas - no copy/paste required.

Analyse Fundamental Data

Pull fundamental data automatically into your spreadsheet direct from Yahoo Finance.

Coverage

~4 years of annual financials Quarterly income statement, balance sheet & cash flow Key financial ratios

How it works

Enter an Excel Price Feed formula in a cell
The latest data is automatically downloaded from Yahoo Finance into the Excel cell
Combine formulas with your own analysis in Excel

Excel formula syntax examples

Annual: =EPF.Yahoo.AnnualRevenue("AAPL",2025)
Quarterly: =EPF.Yahoo.QuarterlyRevenue("AAPL",0)
TTM: =EPF.Yahoo.TTMRevenue("AAPL")
Key Financial Ratios e.g. P/E Ratio: =EPF.Yahoo.PERatio("AAPL")

How to get started

Press the yellow Try it FREE for 10 days button to request your Activation Code.
Download the installer for your version of Excel.
Install the Excel Price Feed Add-in on your PC.
Activate your free 10 day trial using the Activation Code from your email.
Build your fundamental analysis spreadsheet using the 100+ new Excel Price Feed formulas or download one of the templates below.

Try it FREE for 10 days

Fundamental Analysis Excel Templates

Stock Fundamental Analysis

A template for analysing fundamental stock data.

Company Income Summary 10-K

Company income summary based on SEC form 10-K.

Stock Cash Flow

A template for analysing stock cash flow data.

Fundamental Analysis Excel Formulas

Balance sheet formulas

Annual and quarterly assets, liabilities and equity metrics from Yahoo Finance.

Cash flow formulas

Operating, investing and financing cash flow data for fundamental analysis.

Income statement formulas

Revenue, profitability, EPS and other income statement metrics.

Key financial ratios

P/E ratio, market cap, dividend yield and other valuation and summary metrics.

FAQ

How do I do fundamental analysis in Excel with Excel Price Feed?

Excel Price Feed is an Excel Add-in with formulas for income statement, balance sheet and cash flow data from Yahoo Finance. Enter a formula such as =EPF.Yahoo.AnnualRevenue("AAPL",2025), press Refresh Sheet, and build your analysis in Excel.

Can I get Yahoo Finance fundamental data in Excel without copy and paste?

Yes. Excel Price Feed pulls Yahoo Finance data directly into your spreadsheet using standard Excel formulas. There is no need to copy and paste figures from websites.

What fundamental data does Excel Price Feed provide from Yahoo Finance?

Approximately four years of annual financials, plus quarterly income statement, balance sheet and cash flow metrics. Trailing twelve months (TTM) formulas and key financial ratios such as P/E ratio and dividend yield are also available.

What Excel formulas are available for stock fundamental analysis?

Annual formulas, quarterly formulas, TTM formulas and key financial ratio formulas such as =EPF.Yahoo.PERatio("AAPL"). See the Yahoo Finance formula reference for balance sheet, cash flow, income statement and key financial ratios.

Do I need a Yahoo Finance account to use Excel Price Feed fundamental data formulas?

No. Yahoo Finance is included with Excel Price Feed at no extra cost and does not require a Yahoo account or API key.

Are there Excel templates for fundamental stock analysis?

Yes. Download ready-to-use templates including Stock Fundamental Analysis, Company Income Summary 10-K and Stock Cash Flow.

More resources

Excel Price Feed is wholly owned by Coderun Technologies Ltd. Coderun is a private limited company registered in England and Wales (company number 09864381). Registered office at First Floor, Telecom House, 125-135 Preston Road, Brighton, England, BN1 6AF. Email: hello@coderun.net