Fields

Fields represent the specific data points you can retrieve about a financial entity.

Basically, fields are the financial ids that you can find here. You just need to copy the id and paste it in your query.

For now, you can select only one field per query. This is a precautionary measure to test the api under full load. We will add support for multiple fields in the near future.

Examples

Retrieve the LTM (last 12 months) value for eps

Query

get(eps) for('AAPL US')

Result

381623000000

When you dont use any parameters, it will return just the last 12 months value.

---

Retrieve the last annual value for eps

Query

get(eps(fa_period_type=A)) for ('AAPL US')

Result

381623000000

---

Retrieve revenue values for quarters between Q3 2020 and Q1 2022

Query

get(is_sales_revenue_turnover(fa_period_type=Q, fa_period_reference=range('2020Q3', '2022Q1'))) for ('AAPL US')

Result

fiscal_year	period_label	period_end_date	is_sales_revenue_turnover
2020	Q3	2020-06-30	59685000000
2020	Q4	2020-09-30	64698000000
2021	Q1	2020-12-31	111439000000
2021	Q2	2021-03-31	89584000000
2021	Q3	2021-06-30	81434000000
2021	Q4	2021-09-30	83360000000
2022	Q1	2021-12-31	123945000000

---

Retrieve the eps the last four LTM periods

Query

get(is_sales_revenue_turnover(fa_period_type=Q, fa_period_reference=range('2020', '2022'))) for('AAPL US')

Result

fiscal_year	period_label	period_end_date	is_sales_revenue_turnover
2020	Q4	2020-09-30	64698000000
2021	Q4	2021-09-30	83360000000
2022	Q4	2022-09-30	90146000000

Why don't we have the Q1, Q2, Q3 values? Because fa_period_reference is a sampling of the data, not the period type.

• When you specify a range of years or a particular year, you take the value for the end of the fiscal year.

• When you specify a range of quarters, you take the value for the end of the quarter. More information is here.

For now, we do not support financial data pricing like pr_last, pr_low, pr_high, etc.