FORWARD_SALES
Get forward sales estimates.
Syntax
=OBB.EQUITY.ESTIMATES.FORWARD_SALES([symbol],[fiscal_year],[fiscal_period],[calendar_year],[calendar_period])
Examples
=OBB.EQUITY.ESTIMATES.FORWARD_SALES("AAPL")
=OBB.EQUITY.ESTIMATES.FORWARD_SALES(,2025,"fy")
Parameters
| Name | Type | Description | Required |
|---|---|---|---|
| symbol | Text | Symbol to get data for. Multiple comma separated items allowed. | 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 |
| fiscal_period | Text | The future fiscal period to retrieve estimates for. Options: fy, q1, q2, q3, q4. | 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
- 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 | The sales estimate low for the period. |
| high_estimate | The sales estimate high for the period. |
| mean | The sales estimate mean for the period. |
| median | The sales estimate median for the period. |
| standard_deviation | The sales estimate standard deviation for the period. |
| number_of_analysts | Number of analysts providing estimates for the period. |
| revisions_1w_up | Number of revisions up in the last week. |
| revisions_1w_down | Number of revisions down in the last week. |
| revisions_1w_change_percent | The analyst revisions percent change in estimate for the period of 1 week. |
| revisions_1m_up | Number of revisions up in the last month. |
| revisions_1m_down | Number of revisions down in the last month. |
| revisions_1m_change_percent | The analyst revisions percent change in estimate for the period of 1 month. |
| revisions_3m_up | Number of revisions up in the last 3 months. |
| revisions_3m_down | Number of revisions down in the last 3 months. |
| revisions_3m_change_percent | The analyst revisions percent change in estimate for the period of 3 months. |