Basic Syntax
The structure of command syntax is standardized across common fields. This ensures that a date
is always a date
and the format remains consistent throughout.
Standardized parameters include, but are not limited to:
When looking at a function's docstring, the standard parameters (shared across multiple providers) are positioned first. Provider-specific parameters positionally follow the provider
argument. The example below is from, obb.equity.price.quote
:
Parameters
----------
symbol : str
Symbol to get data for. In this case, the comma separated list of symbols.
provider : Optional[Literal['fmp', 'intrinio']]
The provider to use for the query, by default None.
If None, the provider specified in defaults is selected or 'fmp' if there is
no default.
source : Literal['iex', 'bats', 'bats_delayed', 'utp_delayed', 'cta_a_delayed', 'cta_b_delayed', 'intrinio_mx', 'intrinio_mx_plus', 'delayed_sip']
Source of the data. (provider: intrinio)
Examples below assume that the Python interface has been imported in the current session, and/or the Fast API has been started.
from openbb import obb
or
uvicorn openbb_core.api.rest_api:app
Provider
The provider
parameter is the way to select the specific source of the data from the endpoint. If a preference for the default provider has not been defined, the default will be the first, alphabetically, installed provider. Provider values are entered in lower-case, with an underscore for multiple words - for example:
historical_prices = obb.equity.price.historical("aapl", provider="alpha_vantage")
Provider coverage can be ascertained with the command below:
obb.coverage.providers
Refer to, Data Extensions, for instructions on installing data provider extensions.
Symbol
Symbols are not case-sensitive, and where the function allows, can be entered as a string
, List[str]
, or a comma-separated string
. The exact format of the symbol may vary between providers - for example, share classes, exchange suffixes, and global composites. An example of this difference is shown below:
obb.equity.price.historical("brk.b", provider="polygon")
obb.equity.price.historical("brk-b", provider="fmp")
While some providers handle the different formats on their end, others do not. This is something to consider when no results are returned from one source.
With providers supporting market data from multiple jurisdictions, the most common method for requesting data outside of US-listings is to append a suffix to the ticker symbol (e.g., RELIANCE.NS
). Formats may be unique to a provider, so it is best to review the source's documentation for an overview of their specific conventions. This page on Yahoo describes how they format symbols, which many others follow to some degree.
One Symbol
Details
quote = obb.equity.price.quote(symbol="td", provider="fmp")
Multiple Symbols
Details
The OpenBB Provider module enforces REST-compliant lists that can be entered in either format through the Python interface.
Comma-Separated String
This is the format required by the Fast API, when creating new data endpoints, it is important that the Python interface is able to accept both formats.
quotes = obb.equity.price.quote("td,schw,jpm,ms", provider="fmp")
import requests
r = requests.get("http://127.0.0.1:8000/api/v1/equity/price/quote?provider=fmp&symbol=td,schw,ms,jpm")
r.json()
Python List
Entering a list will provide the same outcome as above.
quotes = obb.equity.price.quote(["td","schw","jpm","ms"], provider="fmp")
Lists of symbols can be generated from the results of other functions, and then passed to the input.
symbol="spgi"
symbols = obb.equity.compare.peers(symbol).results.peers_list+[symbol]
quotes = obb.equity.price.quote(symbols)
To accomplish this same task through the Fast API, convert the list to a comma-separated string.
import requests
symbol="spgi"
r = requests.get(f"http://127.0.0.1:8000/api/v1/equity/compare/peers?provider=fmp&symbol={symbol}")
symbols_list = r.json()["results"]["peers_list"]+[symbol]
symbols = ",".join(symbols_list)
response = requests.get(f"http://127.0.0.1:8000/api/v1/equity/price/quote?provider=fmp&symbol={symbols}")
response.json()
Dates
Dates are entered everywhere as a string, formatted as, "YYYY-MM-DD". If the function has only the date
parameter, the data will be a snapshot instead of a time series.
historical_prices = obb.equity.price.historical(symbol="qqq", start_date="2023-01-10", end_date="2023-01-31", provider="fmp")
For flexibility and programmatic purposes, a datetime
object is also accepted.
from datetime import datetime
symbol="qqq"
start = datetime.strptime("100123", "%d%m%y")
end = datetime.strptime("2023-01-31","%Y-%m-%d")
historical_prices = obb.equity.price.historical(symbol, start_date=start, end_date=end, provider="fmp")
import requests
response = requests.get(f"http://127.0.0.1:8000/api/v1/equity/price/historical?provider=fmp&symbol={symbol}&start_date={start}&end_date={end}")
response.json()
Limit
Where, optional, limit
parameters are supplied, they are likely to have sensible default states that return N results starting from the most recent entry or the start_date
. Enter these values as an integer.
income = obb.equity.fa.income("AAPL", period="quarter", provider="fmp", limit=4)
**kwargs
All endpoints accept additional keyword arguments, but non-existent parameters will be ignored. Invalid parameters are communicated via the warnings
field in the command response. Parameters can be stored as a dictionary and fed to the command as **kwargs
. If a provider, or function, has an undocumented parameter it can still be accessed by supplying the additional kwargs.
kwargs = {"symbol":"msft","start_date":"2023-01-01","provider":"polygon"}
historical_prices = obb.equity.price.historical(**kwargs)
data = obb.equity.price.quote("brk-b", provider="fmp", source="bats")
data.warnings
[Warning_(category='OpenBBWarning', message="Parameter 'source' is not supported by fmp. Available for: intrinio.")]
References
All functions, parameters, and responses are detailed under the Reference pages. The data models for each provider source are described within the Data Models pages.
These pages are a quick way to cross-reference differences between providers. The same information is provided in a function's signature and docstring.