RATIOS
Get an extensive set of financial and accounting ratios for a given company over time.
Syntax
=OBB.EQUITY.FUNDAMENTAL.RATIOS(symbol,[period],[limit],[with_ttm])
Examples
=OBB.EQUITY.FUNDAMENTAL.RATIOS("AAPL")
=OBB.EQUITY.FUNDAMENTAL.RATIOS("AAPL","annual",12)
Parameters
| Name | Type | Description | Required |
|---|---|---|---|
| symbol | Text | Symbol to get data for. Multiple comma separated items allowed. | True |
| period | Text | Time period of the data to return. | False |
| limit | Number | The number of data entries to return. | False |
| with_ttm | Boolean | Include trailing twelve months (TTM) data. | False |
Data
- fmp
| Name | Description |
|---|---|
| period_ending | The date of the data. |
| fiscal_period | Period of the financial ratios. |
| fiscal_year | Fiscal year. |