FORWARD_EPS
Get forward EPS estimates.
Syntax
=OBB.EQUITY.ESTIMATES.FORWARD_EPS([symbol],[provider],[fiscal_period],[limit],[include_historical],[fiscal_year],[calendar_year],[calendar_period])
Examples
=OBB.EQUITY.ESTIMATES.FORWARD_EPS("AAPL","intrinio")
=OBB.EQUITY.ESTIMATES.FORWARD_EPS(,"intrinio","fy",,,2025)
Parameters
| Name | Type | Description | Required |
|---|---|---|---|
| symbol | Text | Symbol to get data for. Multiple comma separated items allowed. | False |
| provider | Text | Options: fmp, intrinio, defaults to fmp. | False |
| fiscal_period | Text | The future fiscal period to retrieve estimates for. Options: annual, quarter.The future fiscal period to retrieve estimates for. Options: fy, q1, q2, q3, q4. | False |
| limit | Number | The number of data entries to return. | False |
| include_historical | Boolean | If True, the data will include all past data and the limit will be ignored. | False |
| fiscal_year | Number | The future fiscal year to retrieve estimates for. When no symbol and year is supplied the current calendar year is used. | False |
| calendar_year | Number | The future calendar year to retrieve estimates for. When no symbol and year is supplied the current calendar year is used. | False |
| calendar_period | Text | The future calendar period to retrieve estimates for. Options: q1, q2, q3, q4. | False |
Data
- fmp
- intrinio
| Name | Description |
|---|---|
| symbol | Symbol representing the entity requested in the data. |
| name | Name of the entity. |
| date | The date of the data. |
| fiscal_year | Fiscal year for the estimate. |
| fiscal_period | Fiscal quarter for the estimate. |
| calendar_year | Calendar year for the estimate. |
| calendar_period | Calendar quarter for the estimate. |
| low_estimate | Estimated EPS low for the period. |
| high_estimate | Estimated EPS high for the period. |
| mean | Estimated EPS mean for the period. |
| median | Estimated EPS median for the period. |
| standard_deviation | Estimated EPS standard deviation for the period. |
| number_of_analysts | Number of analysts providing estimates for the period. |
| revisions_change_percent | The earnings per share (EPS) percent change in estimate for the period. |
| mean_1w | The mean estimate for the period one week ago. |
| mean_1m | The mean estimate for the period one month ago. |
| mean_2m | The mean estimate for the period two months ago. |
| mean_3m | The mean estimate for the period three months ago. |
| Name | Description |
|---|---|
| symbol | Symbol representing the entity requested in the data. |
| name | Name of the entity. |
| date | The date of the data. |
| fiscal_year | Fiscal year for the estimate. |
| fiscal_period | Fiscal quarter for the estimate. |
| calendar_year | Calendar year for the estimate. |
| calendar_period | Calendar quarter for the estimate. |
| low_estimate | Estimated EPS low for the period. |
| high_estimate | Estimated EPS high for the period. |
| mean | Estimated EPS mean for the period. |
| median | Estimated EPS median for the period. |
| standard_deviation | Estimated EPS standard deviation for the period. |
| number_of_analysts | Number of analysts providing estimates for the period. |