Excel Price Feed provides Excel formulas for financial analysis (both annual and quarterly) , including Income Statement, Balance Sheet and Cash Flow data for a large range of stocks across many different exchanges and countries.
This feature enables you to easily analyse company reported earnings/results in Excel using simple Excel formulas.
For example, here is an extract of the Microsoft annual results from our sample spreadsheet (click the Excel icon above to download):
And here is an extract of quarterly results for Microsoft, again from our sample spreadsheet:
Please note you need an active subscription with EODHistoricData.com to access this data.
For annual reported results these formulas require a symbol/exchange and year. For example:
Will return the 2019 annual revenue for Apple.
For quarterly reported results you need to also specify a quarter. For example:
=EPF.EOD.IncomeStatement.TotalRevenue("MSFT.US", 2020, 3)
Will return the 2020 3rd quarter revenue for Microsoft.
The "quarter" number determines which period the companies quarter ended. The table below shows how the quarter numbers correspond to months:
|Quarter ends in either January, February or March.
|Quarter ends in either April, May or June.
|Quarter ends in either July, August or September.
|Quarter ends in either October, November or December.
There are two useful formulas which can be used to return the end date for the earnings (i.e. year or quarter end) as well as the date the earnings were filed:
|Reporting Period End Date
|Cost of Revenue
|Research And Development
|Total Current Assets
|Total Non-current Assets
|Total Current Liabilities
|Long Term Debt
from Operating Activities
from Investing Activities
from Financing Activities
|Net Change In Cash