Skip to main content

HISTORICAL

Get historical analyst estimates for earnings and revenue.

Syntax

=OBB.EQUITY.ESTIMATES.HISTORICAL(symbol,[period],[limit])

Examples

=OBB.EQUITY.ESTIMATES.HISTORICAL("AAPL")

Parameters

NameTypeDescriptionRequired
symbolTextSymbol to get data for. Multiple comma separated items allowed.True
periodTextTime period of the data to return. Options: quarter, annual.False
limitNumberThe number of data entries to return.False

Data

NameDescription
symbolSymbol representing the entity requested in the data.
dateThe date of the data.
estimated_revenue_lowEstimated revenue low.
estimated_revenue_highEstimated revenue high.
estimated_revenue_avgEstimated revenue average.
estimated_sga_expense_lowEstimated SGA expense low.
estimated_sga_expense_highEstimated SGA expense high.
estimated_sga_expense_avgEstimated SGA expense average.
estimated_ebitda_lowEstimated EBITDA low.
estimated_ebitda_highEstimated EBITDA high.
estimated_ebitda_avgEstimated EBITDA average.
estimated_ebit_lowEstimated EBIT low.
estimated_ebit_highEstimated EBIT high.
estimated_ebit_avgEstimated EBIT average.
estimated_net_income_lowEstimated net income low.
estimated_net_income_highEstimated net income high.
estimated_net_income_avgEstimated net income average.
estimated_eps_avgEstimated EPS average.
estimated_eps_highEstimated EPS high.
estimated_eps_lowEstimated EPS low.
number_analyst_estimated_revenueNumber of analysts who estimated revenue.
number_analysts_estimated_epsNumber of analysts who estimated EPS.