Fundamentals
Returns data from the [fundamentals] table.
This table contains 100+ financial indicators based on the financial statement data in official company filings.
For more information on the dataset and the available indicators, please review the fundamentals table on the Data Explorer page.
The table is queried via the following endpoint
https://api.findl.com/v1.0/data/fundamentals?apiKey=test-api-keyThe queries are authenticated and filtered using query parameters. A query parameter specifies a particular option or filter for the data to be returned. Examples of query parameter include the data format to be returned (format), the table columns to return (fields) or a filter to be applied (tablename). These are appended to the endpoint above, following a ?. The most important of these is your API key (apiKey) which is used to authenticate you. Without a valid API key, results will not be returned.
The fundamentals table supports the following query parameters.
| Parameter | Description | Default | Examples |
|---|---|---|---|
| format | The format of the results to be returned. | csv | format=json |
| from | Specifies the filing date from which to return data. | 30 days ago | from=2023-08-01 |
| to | Specifies the filing date to return data until. | prior day | to=2023-08-31 |
| fields | The fields (table columns) to return. | all | fields=ticker,date,dimension,revenue,cor |
| calendardate | Specifies the calendardate for which to return data. | calendardate=2023-08-31 | |
| dimension | Specifies the reporting dimension of the data. | all | dimension=MRT |
| lastupdated | Specifies the last date on which a record was updated. This can be used to retrieve recently updated records. | lastupdated.gte=2023-09-31 | |
| ticker | Returns results for the specified ticker. Multiple tickers should be separated with a comma(,). | all | calendardate=2023-08-31 |
| limit | The number of records to return. | 10000 | limit=100000 |
| skip | The number of results to skip before returning data. | 0 | skip=10000 |
| sort | The field used to sort the data and the sort method (asc/desc). | date.desc | sort=indicator.asc |
Return fundamentals data for a ticker
https://api.findl.com/v1.0/data/fundamentals?apiKey=test-api-key&format=csv&ticker=AAPLReturn fundamentals data for a specified ticker and reporting dimension
https://api.findl.com/v1.0/data/fundamentals?apiKey=test-api-key&format=csv&ticker=AAPL&dimension=MRQReturn fundamentals data that has been updated since a specified date
https://api.findl.com/v1.0/data/fundamentals?apiKey=test-api-key&format=csv&tablename=fundamentals&lastupdated.gte=2023-01-01Return fundamentals data for a specified ticker and dimension where the filing date is greater than a specified date, columns returned are limited to specified fields and the data is sorted by a specified field.
https://api.findl.com/v1.0/data/fundamentals?apiKey=test-api-key&format=csv&ticker=AAPL&dimension=MRQ&fields=date,calendardate,reportperiod,revenue,cor,gp,netinc&from=2015-01-01&sort=calendardate.ascCopyright © findl 2024. All rights reserved.