Excel Formula Reference: EODHistoricalData.com Stocks Financial Analysis

Excel Price Feed Quandl Example Spreadsheet Download
Click the Excel icon to download a sample spreadsheet with Excel Price Feed EODHistoricalData.com formulas.

Excel Price Feed provides Excel formulas for financial analysis including Income Statement, Balance Sheet and Cash Flow data for a large range of stocks across many different exchanges and countries.

For example, here is an extract of the Financial Analysis tab for Microsoft stock from our sample spreadsheet (click the Excel icon above to download):

Microsoft stock financial analysis in Excel

Please note you need an active subscription with EODHistoricData.com to access this data.

All of these formulas require just a symbol/exchange and year, for example: =EPF.EOD.IncomeStatement.Annual.TotalRevenue("AAPL.US", 2019)

Income Statement

Formula Description
EPF.EOD.IncomeStatement.Annual.TotalRevenue Total Revenue
EPF.EOD.IncomeStatement.Annual.GrossProfit Gross Profit
EPF.EOD.IncomeStatement.Annual.ResearchAndDevelopmentExpense Research And Development
(R&D) Expense
EPF.EOD.IncomeStatement.Annual.OperatingIncome Operating Income
EPF.EOD.IncomeStatement.Annual.InterestExpense Interest Expense
EPF.EOD.IncomeStatement.Annual.NetIncome Net Income


Balance Sheet

Formula Description
EPF.EOD.BalanceSheet.Annual.Cash Cash
EPF.EOD.BalanceSheet.Annual.Inventory Inventory
EPF.EOD.BalanceSheet.Annual.CurrentAssetsTotal Total Current Assets
EPF.EOD.BalanceSheet.Annual.NonCurrentAssetsTotal Total Non-current Assets
EPF.EOD.BalanceSheet.Annual.IntangibleAssets Intangible Assets
EPF.EOD.BalanceSheet.Annual.AssetsTotal Total Assets
EPF.EOD.BalanceSheet.Annual.CurrentLiabilitiesTotal Total Current Liabilities
EPF.EOD.BalanceSheet.Annual.LongTermDebt Long Term Debt
EPF.EOD.BalanceSheet.Annual.LiabilitiesTotal Total Liabilities


Cash Flow

Formula Description
EPF.EOD.CashFlow.Annual.CashFlowOperatingActivities Cash Flow
from Operating Activities
EPF.EOD.CashFlow.Annual.CashFlowInvestingActivities Cash Flow
from Investing Activities
EPF.EOD.CashFlow.Annual.CashFlowFinancingActivities Cash Flow
from Financing Activities
EPF.EOD.CashFlow.Annual.ChangeInCash Net Change In Cash
EPF.EOD.CashFlow.Annual.CapitalExpenditure Capital Expenditure
EPF.EOD.CashFlow.Annual.DividendsPaid Dividends Paid
EPF.EOD.CashFlow.Annual.StockBuybacks Stock Buybacks