Getting Started
Yahoo Finance
IG Index / IG Markets
EODHistoricalData.com
Quandl

Excel Formula Reference: Income Statement

Excel Price Feed Quandl Example Spreadsheet Download
Click the Excel icon to download a sample spreadsheet with all Excel Price Feed Yahoo Finance stock formulas.

All these formulas require both a stock ticker and reporting year, for example: =EPF.Yahoo.AnnualRevenue("GOOG",2018)

Yahoo Finance generally provides the past 4 years reported data.


Yahoo Finance Excel Formulas Income Statement

Formula Description
EPF.Yahoo.AnnualRevenue Total Revenue.
EPF.Yahoo.AnnualCostOfRevenue Cost of Revenue.
EPF.Yahoo.AnnualGrossProfit Gross Profit.
EPF.Yahoo.AnnualResearchAndDevelopmentExpense Research and development expense (R&D).
EPF.Yahoo.AnnualSellingGeneralAndAdministrationExpense Selling, general and administration expenses.
EPF.Yahoo.AnnualTotalOperatingExpenses Total operating expenses.
EPF.Yahoo.AnnualOperatingIncome Total operating income.
EPF.Yahoo.AnnualInterestExpense Interest expense.
EPF.Yahoo.AnnualTotalOtherIncomeExpenseNet Total other income / expenses net.
EPF.Yahoo.AnnualPretaxIncome Pre-tax income / income before tax.
EPF.Yahoo.AnnualTaxProvision Tax provision / expense.
EPF.Yahoo.AnnualIncomeContinuingOperations Income from Continuing Operations.
EPF.Yahoo.AnnualBasicEPS Basic EPS.
EPF.Yahoo.AnnualDilutedEPS Diluted EPS.
EPF.Yahoo.AnnualBasicSharesOutstanding Basic shares outstanding.
EPF.Yahoo.AnnualDilutedSharesOutstanding Diluted shares outstanding.
EPF.Yahoo.AnnualEBITDA EBITDA.

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.
Risk Warning: Spread bets and CFDs are complex instruments and come with a high risk of losing money rapidly due to leverage. 76% of retail investor accounts lose money when trading spread bets and CFDs. You should consider whether you understand how spread bets and CFDs work and whether you can afford to take the high risk of losing your money. Disclaimer: Coderun Technologies may receive compensation from companies linked to from this website.