kfinance

class BusinessRelationships

Business relationships object that represents the current and previous companies of a given Company object.

Parameters

• current – A Companies set that represents the current company_ids.

• previous – A Companies set that represents the previous company_ids.

__getnewargs__(self)

Return self as a plain tuple. Used by copy and pickle.

__new__(_cls, current: ForwardRef('Companies'), previous: ForwardRef('Companies'))

Create new instance of BusinessRelationships(current, previous)

__repr__(self)

Return a nicely formatted representation string

__str__(self) → 'str'

String representation for the BusinessRelationships object

_asdict(self)

Return a new dict which maps field names to their values.

_replace(self, /, **kwds)

Return a new BusinessRelationships object replacing specified fields with new values

class Client

Client class with LLM tools and a pre-credentialed Ticker object

Parameters

• tools (dict[str, Callable]) – A dictionary mapping function names to functions, where each function is an llm tool with the Client already passed in if applicable

• anthropic_tool_descriptions (list[dict]) – A list of dictionaries, where each dictionary is an Anthropic tool definition

• gemini_tool_descriptions (dict[list[dict]]) – A dictionary mapping “function_declarations” to a list of dictionaries, where each dictionary is a Gemini tool definition

• openai_tool_descriptions (list[dict]) – A list of dictionaries, where each dictionary is an OpenAI tool definition

__init__(self, refresh_token: 'Optional[str]' = None, client_id: 'Optional[str]' = None, private_key: 'Optional[str]' = None, api_host: 'str' = 'https://kfinance.kensho.com', api_version: 'int' = 1, okta_host: 'str' = 'https://kensho.okta.com', okta_auth_server: 'str' = 'default')

Initialization of the client.

Parameters

• refresh_token (str, Optional) – users refresh token

• client_id (str, Optional) – users client id will be provided by support@kensho.com

• private_key (str, Optional) – users private key that corresponds to the registered public sent to support@kensho.com

• api_host (str) – the api host URL

• api_version (int) – the api version number

• okta_host (str) – the okta host URL

• okta_auth_server (str) – the okta route for authentication

company(self, company_id: 'int') → 'Company'

Generate the Company object from company_id

Parameters

company_id (int) – CIQ company id

Returns

The Company specified by the the company id

Return type

Company

get_latest() → 'LatestPeriods'

Get the latest annual reporting year, latest quarterly reporting quarter and year, and current date.

Returns

A dict in the form of {“annual”: {“latest_year”: int}, “quarterly”: {“latest_quarter”: int, “latest_year”: int}, “now”: {“current_year”: int, “current_quarter”: int, “current_month”: int, “current_date”: str of Y-m-d}}

Return type

Latest

get_n_quarters_ago(n: 'int') → 'YearAndQuarter'

Get the year and quarter corresponding to [n] quarters before the current quarter

Parameters

n (int) – the number of quarters before the current quarter

Returns

A dict in the form of {“year”: int, “quarter”: int}

Return type

YearAndQuarter

security(self, security_id: 'int') → 'Security'

Generate Security object from security_id

Parameters

security_id (int) – CIQ security id

Returns

The Security specified by the the security id

Return type

Security

ticker(self, identifier: 'int | str', exchange_code: 'Optional[str]' = None, function_called: 'Optional[bool]' = False) → 'Ticker'

Generate Ticker object from [identifier] that is a ticker, ISIN, or CUSIP.

Parameters

• identifier (str) – the ticker symbol, ISIN, or CUSIP

• exchange_code (str, optional) – The code representing the equity exchange the ticker is listed on.

• function_called (bool, optional) – Flag for use in signaling function calling

Returns

Ticker object from that corresponds to the identifier

Return type

Ticker

tickers(self, country_iso_code: 'Optional[str]' = None, state_iso_code: 'Optional[str]' = None, simple_industry: 'Optional[str]' = None, exchange_code: 'Optional[str]' = None) → 'Tickers'

Generate tickers object representing the collection of Tickers that meet all the supplied parameters

One of country_iso_code, simple_industry, or exchange_code must be supplied. A parameter set to None is not used to filter on

Parameters

• country_iso_code (str, optional) – The ISO 3166-1 Alpha-2 or Alpha-3 code that represent the primary country the firm is based in. It default None

• state_iso_code (str, optional) – The ISO 3166-2 Alpha-2 code that represents the primary subdivision of the country the firm the based in. Not all ISO 3166-2 codes are supported as S&P doesn’t maintain the full list but a feature request for the full list is submitted to S&P product. Requires country_iso_code also to have a value other then None. It default None

• simple_industry (str, optional) – The S&P CIQ Simple Industry defined in ciqSimpleIndustry in XPF. It default None

• exchange_code (str, optional) – The exchange code for the primary equity listing exchange of the firm. It default None

Returns

A tickers object that is the group of Ticker objects meeting all the supplied parameters

Return type

Tickers

trading_item(self, trading_item_id: 'int') → 'TradingItem'

Generate TradingItem object from trading_item_id

Parameters

trading_item_id (int) – CIQ trading item id

Returns

The trading item specified by the the trading item id

Return type

TradingItem

class Companies

Base class for representing a set of Companies

__init__(self, kfinance_api_client: 'KFinanceApiClient', company_ids: 'Iterable[int]') → 'None'

Initialize the Companies object

Parameters

• kfinance_api_client (KFinanceApiClient) – The KFinanceApiClient used to fetch data

• company_ids (Iterable[int]) – An iterable of S&P CIQ Company ids

class Company

Company class

Parameters

• kfinance_api_client (KFinanceApiClient) – The KFinanceApiClient used to fetch data

• company_id (int) – The S&P Global CIQ Company Id

__init__(self, kfinance_api_client: 'KFinanceApiClient', company_id: 'int')

Initialize the Company object

Parameters

• kfinance_api_client (KFinanceApiClient) – The KFinanceApiClient used to fetch data

• company_id (int) – The S&P Global CIQ Company Id

__str__(self) → 'str'

String representation for the company object

accounts_payable(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1018

accounts_receivable(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1021

accrued_expenses(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1016

accumulated_depreciation(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1075

additional_paid_in_capital(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1084

additional_paid_in_capital_preferred_stock(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for preferred_stock_additional_paid_in_capital

ciq data item 1085

adjustments_to_cash_flow_net_income(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 21523

amortization_of_goodwill_and_intangibles(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 31

asset_writedown(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 32

assets(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for total_assets

ciq data item 1007

balance_sheet(self, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

The templated balance sheet

basic_earning_per_share(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for basic_eps

ciq data item 9

basic_earning_per_share_excluding_extra_items(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for basic_eps_excluding_extra_items

ciq data item 3064

basic_earning_per_share_from_accounting_change(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for basic_eps_from_accounting_change

ciq data item 145

basic_earning_per_share_from_accounting_change_and_extraordinary_items(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for basic_eps_from_accounting_change_and_extraordinary_items

ciq data item 45

basic_earning_per_share_from_extraordinary_items(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for basic_eps_from_extraordinary_items

ciq data item 146

basic_earning_per_share_including_extra_items(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for basic_eps

ciq data item 9

basic_eps(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 9

basic_eps_excluding_extra_items(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 3064

basic_eps_from_accounting_change(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 145

basic_eps_from_accounting_change_and_extraordinary_items(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 45

basic_eps_from_extraordinary_items(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 146

basic_eps_including_extra_items(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for basic_eps

ciq data item 9

borrower

Returns the associated company’s current and previous borrowers

capex(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for capital_expenditure

ciq data item 2021

capital_expenditure(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2021

capital_expenditures(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for capital_expenditure

ciq data item 2021

capital_leases(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1183

capitalized_leases(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for capital_leases

ciq data item 1183

cash(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for cash_and_equivalents

ciq data item 1096

cash_acquisitions(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2057

cash_and_cash_equivalents(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for cash_and_equivalents

ciq data item 1096

cash_and_equivalents(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1096

cash_and_short_term_investments(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for total_cash_and_short_term_investments

ciq data item 1002

cash_flow(self, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

The templated cash flow statement

cash_flow_from_operations(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for cash_from_operations

ciq data item 2006

cash_from_discontinued_operation(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for net_cash_from_discontinued_operation

ciq data item 2081

cash_from_financing(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2004

cash_from_financing_activities(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for cash_from_financing

ciq data item 2004

cash_from_investing(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2005

cash_from_investing_activities(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for cash_from_investing

ciq data item 2005

cash_from_operating_activities(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for cash_from_operations

ciq data item 2006

cash_from_operations(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2006

cashflow(self, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

The templated cash flow statement

cashflow_from_financing(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for cash_from_financing

ciq data item 2004

cashflow_from_financing_activities(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for cash_from_financing

ciq data item 2004

cashflow_from_investing(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for cash_from_investing

ciq data item 2005

cashflow_from_investing_activities(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for cash_from_investing

ciq data item 2005

change_in_accounts_payable(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2017

change_in_accounts_receivable(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2018

change_in_cash(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for net_change_in_cash

ciq data item 2093

change_in_deferred_taxes(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2084

change_in_income_taxes(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2101

change_in_inventories(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2099

change_in_net_operating_assets(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2010

change_in_net_working_capital(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 4421

change_in_other_net_operating_assets(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2045

change_in_trading_asset_securities(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2134

change_in_unearned_revenue(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2139

client_services

Returns the associated company’s current and previous client_servicess

cogs(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for cost_of_goods_sold

ciq data item 34

common_dividends_paid(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2074

common_equity(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for total_common_equity

ciq data item 1006

common_shares_outstanding(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1100

common_stock(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1103

company_id

Set and return the company id for the object

continued_operations_earnings(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for earnings_from_continued_operations

ciq data item 7

convertible_preferred_stock(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for preferred_stock_convertible

ciq data item 1214

cor(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for cost_of_revenue

ciq data item 1

cost_of_goods_sold(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 34

cost_of_revenue(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1

creditor

Returns the associated company’s current and previous creditors

currency_exchange_gains(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 38

current_accounts_receivable(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for accounts_receivable

ciq data item 1021

current_assets(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for total_current_assets

ciq data item 1008

current_borrowing(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for short_term_borrowings

ciq data item 1046

current_borrowings(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for short_term_borrowings

ciq data item 1046

current_debt_issued(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for short_term_debt_issued

ciq data item 2043

current_debt_repaid(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for short_term_debt_repaid

ciq data item 2044

current_deferred_tax_asset(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for deferred_tax_asset_current_portion

ciq data item 1117

current_deferred_tax_liability(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1119

current_income_taxes_payable(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1094

current_liabilities(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for total_current_liabilities

ciq data item 1009

current_notes_receivable(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for notes_receivable

ciq data item 1048

current_other_receivables(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for other_receivables

ciq data item 1206

current_portion_of_cap_leases(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for current_portion_of_capital_leases

ciq data item 1090

current_portion_of_capital_leases(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1090

current_portion_of_capitalized_leases(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for current_portion_of_capital_leases

ciq data item 1090

current_portion_of_income_taxes_payable(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for current_income_taxes_payable

ciq data item 1094

current_portion_of_leases(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for current_portion_of_capital_leases

ciq data item 1090

current_portion_of_long_term_debt(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1297

current_portion_of_long_term_debt_and_capital_leases(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1279

current_portion_of_long_term_debt_and_capitalized_leases(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for current_portion_of_long_term_debt_and_capital_leases

ciq data item 1279

current_portion_of_lt_debt(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for current_portion_of_long_term_debt

ciq data item 1297

current_portion_of_lt_debt_and_cap_leases(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for current_portion_of_long_term_debt_and_capital_leases

ciq data item 1279

current_portion_of_non_current_debt(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for current_portion_of_long_term_debt

ciq data item 1297

current_portion_of_non_current_debt_and_capital_leases(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for current_portion_of_long_term_debt_and_capital_leases

ciq data item 1279

current_portion_of_non_current_debt_and_capitalized_leases(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for current_portion_of_long_term_debt_and_capital_leases

ciq data item 1279

current_portion_of_unearned_revenue(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for current_unearned_revenue

ciq data item 1074

current_ratio(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 4030

current_total_receivable(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for total_receivables

ciq data item 1001

current_total_receivables(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for total_receivables

ciq data item 1001

current_unearned_revenue(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1074

customer

Returns the associated company’s current and previous customers

d_and_a(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for depreciation_and_amortization

ciq data item 41

debt_ratio(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for total_debt_to_equity_ratio

ciq data item 4034

deferred_tax_asset_current_portion(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1117

depreciation(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2143

depreciation_and_amortization(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 41

depreciation_of_rental_assets(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 42409

diluted_earning_per_share(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for diluted_eps

ciq data item 8

diluted_earning_per_share_excluding_extra_items(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for diluted_eps_excluding_extra_items

ciq data item 142

diluted_earning_per_share_from_accounting_change(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for diluted_eps_from_accounting_change

ciq data item 141

diluted_earning_per_share_from_accounting_change_and_extraordinary_items(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for diluted_eps_from_accounting_change_and_extraordinary_items

ciq data item 44

diluted_earning_per_share_from_discontinued_operations(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for diluted_eps_from_discontinued_operations

ciq data item 143

diluted_earning_per_share_from_extraordinary_items(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for diluted_eps_from_extraordinary_items

ciq data item 144

diluted_earning_per_share_including_extra_items(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for diluted_eps

ciq data item 8

diluted_eps(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 8

diluted_eps_excluding_extra_items(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 142

diluted_eps_from_accounting_change(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 141

diluted_eps_from_accounting_change_and_extraordinary_items(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 44

diluted_eps_from_discontinued_operations(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 143

diluted_eps_from_extraordinary_items(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 144

diluted_eps_including_extra_items(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for diluted_eps

ciq data item 8

discontinued_operations_earnings(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for earnings_from_discontinued_operations

ciq data item 40

distributable_cash_per_share(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 23317

distributor

Returns the associated company’s current and previous distributors

divestitures(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2077

dividends_paid(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for total_dividends_paid

ciq data item 2022

dividends_per_share(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 3058

dna(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for depreciation_and_amortization

ciq data item 41

earnings_before_interest_and_taxes(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for ebit

ciq data item 400

earnings_before_interest_taxes_and_amortization(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for ebita

ciq data item 100689

earnings_before_interest_taxes_depreciation_amortization_and_rental_expense(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for ebitdar

ciq data item 21674

earnings_before_interest_taxes_depreciation_and_amortization(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for ebitda

ciq data item 4051

earnings_before_taxes_excluding_unusual_items(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for ebt_excluding_unusual_items

ciq data item 4

earnings_before_taxes_including_unusual_items(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for ebt_including_unusual_items

ciq data item 139

earnings_call_datetimes

Get the datetimes of the companies earnings calls

Returns

a list of datetimes for the companies earnings calls

Return type

list[datetime]

earnings_from_continued_operations(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 7

earnings_from_discontinued_operations(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 40

ebit(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 400

ebita(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 100689

ebitda(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 4051

ebitdar(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 21674

ebt_excluding_unusual_items(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 4

ebt_including_unusual_items(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 139

effective_tax_rate(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 4376

equity(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for total_equity

ciq data item 1275

equity_adjustment_preferred_stock(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for preferred_stock_equity_adjustment

ciq data item 1215

exploration_and_drilling_costs(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 49

exploration_and_drilling_expense(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for exploration_and_drilling_costs

ciq data item 49

extraordinary_item_and_accounting_change(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 42

fees_and_other_income(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 168

ffo(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for funds_from_operations

ciq data item 3074

finance_division_debt_current_portion(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1030

finance_division_debt_long_term_portion(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for finance_division_debt_non_current_portion

ciq data item 1035

finance_division_debt_non_current_portion(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1035

finance_division_interest_expense(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 50

finance_division_loans_and_leases_long_term(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1033

finance_division_loans_and_leases_short_term(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1032

finance_division_long_term_debt(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for finance_division_debt_non_current_portion

ciq data item 1035

finance_division_long_term_loans_and_leases(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for finance_division_loans_and_leases_long_term

ciq data item 1033

finance_division_non_current_debt(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for finance_division_debt_non_current_portion

ciq data item 1035

finance_division_operating_expense(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 51

finance_division_other_current_assets(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1029

finance_division_other_current_liabilities(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1031

finance_division_other_long_term_assets(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for finance_division_other_non_current_assets

ciq data item 1034

finance_division_other_long_term_liabilities(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for finance_division_other_non_current_liabilities

ciq data item 1036

finance_division_other_non_current_assets(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1034

finance_division_other_non_current_liabilities(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1036

finance_division_other_short_term_assets(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for finance_division_other_current_assets

ciq data item 1029

finance_division_revenue(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 52

finance_division_short_term_loans_and_leases(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for finance_division_loans_and_leases_short_term

ciq data item 1032

foreign_exchange_adjustments(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for foreign_exchange_rate_adjustments

ciq data item 2144

foreign_exchange_rate_adjustments(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2144

franchisee

Returns the associated company’s current and previous franchisees

franchisor

Returns the associated company’s current and previous franchisors

funds_from_operations(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 3074

fx_adjustments(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for foreign_exchange_rate_adjustments

ciq data item 2144

gain_from_sale_of_assets(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 62

gain_from_sale_of_investments(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 56

goodwill(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1171

gppe(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for gross_property_plant_and_equipment

ciq data item 1169

gross_ppe(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for gross_property_plant_and_equipment

ciq data item 1169

gross_profit(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 10

gross_property_plant_and_equipment(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1169

impairment_o_and_g(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for impairment_of_oil_gas_and_mineral_properties

ciq data item 71

impairment_of_goodwill(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 209

impairment_of_oil_and_gas(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for impairment_of_oil_gas_and_mineral_properties

ciq data item 71

impairment_of_oil_gas_and_mineral_properties(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 71

in_process_r_and_d_cost(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for in_process_research_and_development_expense

ciq data item 72

in_process_r_and_d_expense(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for in_process_research_and_development_expense

ciq data item 72

in_process_research_and_development_cost(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for in_process_research_and_development_expense

ciq data item 72

in_process_research_and_development_expense(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 72

in_process_rnd_cost(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for in_process_research_and_development_expense

ciq data item 72

in_process_rnd_expense(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for in_process_research_and_development_expense

ciq data item 72

income_from_affiliates(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 47

income_statement(self, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

The templated income statement

income_stmt(self, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

The templated income statement

income_tax(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for income_tax_expense

ciq data item 75

income_tax_expense(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 75

income_taxes(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for income_tax_expense

ciq data item 75

info

Get the company info

Returns

a dict with containing: name, status, type, simple industry, number of employees, founding date, webpage, address, city, zip code, state, country, & iso_country

Return type

dict

insurance_division_operating_expense(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 69

insurance_division_revenue(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 70

insurance_settlements(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 73

interest_and_investment_income(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 65

interest_expense(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 82

interest_expense_finance_division(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for finance_division_interest_expense

ciq data item 50

inventories(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for inventory

ciq data item 1043

inventory(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1043

investor_relations_client

Returns the associated company’s current and previous investor_relations_clients

investor_relations_firm

Returns the associated company’s current and previous investor_relations_firms

issuance_of_common_stock(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2169

issuance_of_preferred_stock(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2181

landlord

Returns the associated company’s current and previous landlords

latest_earnings_call

Set and return the latest earnings call item for the object

Raises

NotImplementedError – This function is not yet implemented

legal_settlements(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 77

lessee

Returns the associated company’s current and previous lessees

lessor

Returns the associated company’s current and previous lessors

liabilities(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for total_liabilities

ciq data item 1276

liabilities_and_equity(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for total_liabilities_and_equity

ciq data item 1013

licensee

Returns the associated company’s current and previous licensees

licensor

Returns the associated company’s current and previous licensors

line_item(self, line_item: str, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

Get a DataFrame of a financial line item according to the date ranges.

loans_held_for_sale(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1185

loans_receivable(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for long_term_loans_receivable

ciq data item 1050

long_term_accounts_receivable(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1088

long_term_debt(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1049

long_term_debt_issued(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2034

long_term_debt_repaid(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2036

long_term_deferred_charges(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1025

long_term_deferred_tax_assets(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1026

long_term_finance_division_loans_and_leases(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for finance_division_loans_and_leases_long_term

ciq data item 1033

long_term_investments(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1054

long_term_leases(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for capital_leases

ciq data item 1183

long_term_loans_and_leases_of_the_finance_division(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for finance_division_loans_and_leases_long_term

ciq data item 1033

long_term_loans_receivable(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1050

long_term_other_assets(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for other_long_term_assets

ciq data item 1060

long_term_other_liabilities(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for other_non_current_liabilities

ciq data item 1062

long_term_unearned_revenue(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for non_current_unearned_revenue

ciq data item 1256

loss_on_equity_investments(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2086

merger_and_restructuring_charges(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 363

merger_charges(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 80

minority_interest_in_earnings(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 83

misc_cash_flow_adj(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for miscellaneous_cash_flow_adjustments

ciq data item 2149

miscellaneous_cash_flow_adjustments(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2149

net_cash_from_discontinued_operation(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2081

net_cash_from_investments(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2027

net_change_in_cash(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2093

net_debt(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 4364

net_decrease_in_investment_loans_originated_and_sold(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2032

net_decrease_in_loans_originated_and_sold(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2033

net_income(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 15

net_income_allocable_to_general_partner(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 249

net_income_to_common_shareholders_excluding_extra_items(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 379

net_income_to_common_shareholders_including_extra_items(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 16

net_income_to_company(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 41571

net_income_to_minority_interest(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for minority_interest_in_earnings

ciq data item 83

net_interest_expense(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 368

net_ppe(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for net_property_plant_and_equipment

ciq data item 1004

net_property_plant_and_equipment(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1004

net_working_capital(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1311

non_current_accounts_receivable(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for long_term_accounts_receivable

ciq data item 1088

non_current_debt(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for long_term_debt

ciq data item 1049

non_current_debt_issued(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for long_term_debt_issued

ciq data item 2034

non_current_debt_repaid(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for long_term_debt_repaid

ciq data item 2036

non_current_deferred_charges(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for long_term_deferred_charges

ciq data item 1025

non_current_deferred_tax_assets(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for long_term_deferred_tax_assets

ciq data item 1026

non_current_deferred_tax_liability(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1027

non_current_investments(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for long_term_investments

ciq data item 1054

non_current_loans_receivable(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for long_term_loans_receivable

ciq data item 1050

non_current_other_assets(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for other_long_term_assets

ciq data item 1060

non_current_other_liabilities(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for other_non_current_liabilities

ciq data item 1062

non_current_unearned_revenue(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1256

non_redeemable_preferred_stock(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for preferred_stock_non_redeemable

ciq data item 1216

normal_revenue(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for revenue

ciq data item 112

normalized_basic_earning_per_share(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for normalized_basic_eps

ciq data item 4379

normalized_basic_eps(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 4379

normalized_diluted_earning_per_share(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for normalized_diluted_eps

ciq data item 4380

normalized_diluted_eps(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 4380

notes_receivable(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1048

nppe(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for net_property_plant_and_equipment

ciq data item 1004

operating_expense(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for total_operating_expense

ciq data item 373

operating_expense_finance_division(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for finance_division_operating_expense

ciq data item 51

operating_expense_insurance_division(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for insurance_division_operating_expense

ciq data item 69

operating_income(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 21

other_adjustments_to_net_income(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 259

other_amortization(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2014

other_current_assets(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1055

other_current_assets_of_the_finance_division(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for finance_division_other_current_assets

ciq data item 1029

other_current_liabilities(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for other_current_liability

ciq data item 1057

other_current_liability(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1057

other_equity(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1028

other_financing_activities(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2050

other_intangibles(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1040

other_investing_activities(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2051

other_long_term_assets(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1060

other_long_term_assets_of_the_finance_division(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for finance_division_other_non_current_assets

ciq data item 1034

other_long_term_liabilities(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for other_non_current_liabilities

ciq data item 1062

other_non_current_assets(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for other_long_term_assets

ciq data item 1060

other_non_current_assets_of_the_finance_division(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for finance_division_other_non_current_assets

ciq data item 1034

other_non_current_liabilities(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1062

other_non_operating_income(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 85

other_operating_activities(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2047

other_operating_expense(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 260

other_preferred_stock(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for preferred_stock_other

ciq data item 1065

other_preferred_stock_adjustments(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 281

other_receivables(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1206

other_revenue(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 90

other_short_term_assets_of_the_finance_division(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for finance_division_other_current_assets

ciq data item 1029

other_unusual_items(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 87

pension_and_other_post_retirement_benefit(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1213

ppe(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for net_property_plant_and_equipment

ciq data item 1004

pre_opening_costs(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 96

pre_opening_expense(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for pre_opening_costs

ciq data item 96

preferred_dividends_and_other_adjustments(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 97

preferred_dividends_paid(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2116

preferred_equity(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for total_preferred_equity

ciq data item 1005

preferred_stock(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for total_preferred_equity

ciq data item 1005

preferred_stock_additional_paid_in_capital(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1085

preferred_stock_convertible(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1214

preferred_stock_dividend(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 280

preferred_stock_equity_adjustment(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1215

preferred_stock_non_redeemable(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1216

preferred_stock_other(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1065

preferred_stock_redeemable(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1217

premium_on_redemption_of_preferred_stock(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 279

prepaid_expense(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1212

prepaid_expenses(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for prepaid_expense

ciq data item 1212

primary_security

Return the primary security item for the Company object

Returns

a Security object of the primary security of company_id

Return type

Security

property_plant_and_equipment(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for net_property_plant_and_equipment

ciq data item 1004

provision_for_bad_debt(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for provision_for_bad_debts

ciq data item 95

provision_for_bad_debts(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 95

provision_for_credit_losses(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2112

quick_ratio(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 4121

r_and_d_cost(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for research_and_development_expense

ciq data item 100

r_and_d_expense(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for research_and_development_expense

ciq data item 100

redeemable_preferred_stock(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for preferred_stock_redeemable

ciq data item 1217

regular_revenue(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for revenue

ciq data item 112

relationships(self, relationship_type: kensho_finance.constants.BusinessRelationshipType) → 'BusinessRelationships'

Returns a BusinessRelationships object that includes the current and previous Companies associated with company_id and filtered by relationship_type. The function calls fetch_companies_from_business_relationship.

Parameters

relationship_type (BusinessRelationshipType) – The type of relationship to filter by. Valid relationship types are defined in the BusinessRelationshipType class.

Returns

A BusinessRelationships object containing a tuple of Companies objects that lists current and previous company IDs that have the specified relationship with the given company_id.

Return type

BusinessRelationships

repurchase_of_common_stock(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2164

repurchase_of_preferred_stock(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2172

research_and_development_cost(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for research_and_development_expense

ciq data item 100

research_and_development_expense(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 100

restricted_cash(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1104

restructuring_charges(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 98

retained_earnings(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1222

revenue(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 112

revenue_from_interest_and_investment_income(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 110

revenue_from_sale_of_assets(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 104

revenue_from_sale_of_investments(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 106

rnd_cost(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for research_and_development_expense

ciq data item 100

rnd_expense(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for research_and_development_expense

ciq data item 100

sale_of_intangible_asset(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for sale_of_intangible_assets

ciq data item 2029

sale_of_intangible_assets(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2029

sale_of_intangibles(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for sale_of_intangible_assets

ciq data item 2029

sale_of_ppe(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for sale_of_property_plant_and_equipment

ciq data item 2042

sale_of_property_plant_and_equipment(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2042

sale_of_real_estate(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2040

sale_of_real_estate_properties(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for sale_of_real_estate

ciq data item 2040

sale_of_real_properties(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for sale_of_real_estate

ciq data item 2040

sale_proceeds_from_rental_assets(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 42411

securities

Return the security items for the Company object

Returns

a Securities object containing the list of securities of company_id

Return type

Securities

selling_general_and_admin(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for selling_general_and_admin_expense

ciq data item 102

selling_general_and_admin_cost(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for selling_general_and_admin_expense

ciq data item 102

selling_general_and_admin_expense(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 102

sg_and_a(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for selling_general_and_admin_expense

ciq data item 102

sga(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for selling_general_and_admin_expense

ciq data item 102

shareholders_equity(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for total_equity

ciq data item 1275

short_term_accounts_receivable(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for accounts_receivable

ciq data item 1021

short_term_assets(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for total_current_assets

ciq data item 1008

short_term_borrowing(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for short_term_borrowings

ciq data item 1046

short_term_borrowings(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1046

short_term_debt_issued(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2043

short_term_debt_repaid(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2044

short_term_deferred_tax_asset(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for deferred_tax_asset_current_portion

ciq data item 1117

short_term_finance_division_loans_and_leases(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for finance_division_loans_and_leases_short_term

ciq data item 1032

short_term_investments(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1069

short_term_loans_and_leases_of_the_finance_division(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for finance_division_loans_and_leases_short_term

ciq data item 1032

short_term_notes_receivable(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for notes_receivable

ciq data item 1048

short_term_other_receivables(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for other_receivables

ciq data item 1206

short_term_total_receivable(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for total_receivables

ciq data item 1001

short_term_total_receivables(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for total_receivables

ciq data item 1001

special_dividends_paid(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2041

statement(self, statement_type: str, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

Get the company’s financial statement

stock_based_compensation(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2127

strategic_alliance

Returns the associated company’s current and previous strategic_alliances

supplier

Returns the associated company’s current and previous suppliers

tax_benefit_from_stock_options(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2135

tax_rate(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for effective_tax_rate

ciq data item 4376

tenant

Returns the associated company’s current and previous tenants

total_assets(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1007

total_cash_and_short_term_investments(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1002

total_common_equity(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1006

total_current_assets(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1008

total_current_liabilities(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1009

total_current_portion_of_long_term_debt_and_capital_leases(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for current_portion_of_long_term_debt_and_capital_leases

ciq data item 1279

total_current_portion_of_long_term_debt_and_capitalized_leases(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for current_portion_of_long_term_debt_and_capital_leases

ciq data item 1279

total_current_portion_of_lt_debt_and_cap_leases(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for current_portion_of_long_term_debt_and_capital_leases

ciq data item 1279

total_current_portion_of_non_current_debt_and_capital_leases(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for current_portion_of_long_term_debt_and_capital_leases

ciq data item 1279

total_current_portion_of_non_current_debt_and_capitalized_leases(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for current_portion_of_long_term_debt_and_capital_leases

ciq data item 1279

total_d_and_a(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for total_depreciation_and_amortization

ciq data item 2

total_debt(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 4173

total_debt_issued(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2161

total_debt_ratio(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for total_debt_to_equity_ratio

ciq data item 4034

total_debt_repaid(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2166

total_debt_to_capital(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 43907

total_debt_to_equity(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for total_debt_to_equity_ratio

ciq data item 4034

total_debt_to_equity_ratio(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 4034

total_debt_to_total_equity(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for total_debt_to_equity_ratio

ciq data item 4034

total_depreciation_and_amortization(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2

total_dividends_paid(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2022

total_dna(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for total_depreciation_and_amortization

ciq data item 2

total_equity(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1275

total_liabilities(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1276

total_liabilities_and_equity(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1013

total_operating_expense(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 373

total_other_investing_activities(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2177

total_other_non_cash_items(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2179

total_other_non_operating_income(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 371

total_other_operating_expense(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 380

total_other_revenue(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 357

total_other_unusual_items(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 374

total_preferred_equity(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1005

total_preferred_stock(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for total_preferred_equity

ciq data item 1005

total_receivable(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for total_receivables

ciq data item 1001

total_receivables(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1001

total_revenue(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 28

total_selling_general_and_admin(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for total_selling_general_and_admin_expense

ciq data item 23

total_selling_general_and_admin_cost(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for total_selling_general_and_admin_expense

ciq data item 23

total_selling_general_and_admin_expense(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 23

total_sga(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for total_selling_general_and_admin_expense

ciq data item 23

total_shareholders_equity(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for total_equity

ciq data item 1275

total_short_term_assets(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for total_current_assets

ciq data item 1008

total_unusual_items(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 19

trading_asset_securities(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1244

transfer_agent

Returns the associated company’s current and previous transfer_agents

transfer_agent_client

Returns the associated company’s current and previous transfer_agent_clients

treasury_convertible_preferred_stock(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for treasury_stock_preferred_stock_convertible

ciq data item 1249

treasury_non_redeemable_preferred_stock(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for treasury_stock_preferred_stock_non_redeemable

ciq data item 1250

treasury_preferred_stock_convertible(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for treasury_stock_preferred_stock_convertible

ciq data item 1249

treasury_preferred_stock_non_redeemable(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for treasury_stock_preferred_stock_non_redeemable

ciq data item 1250

treasury_preferred_stock_redeemable(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for treasury_stock_preferred_stock_redeemable

ciq data item 1251

treasury_redeemable_preferred_stock(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for treasury_stock_preferred_stock_redeemable

ciq data item 1251

treasury_stock(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1248

treasury_stock_convertible_preferred_stock(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for treasury_stock_preferred_stock_convertible

ciq data item 1249

treasury_stock_non_redeemable_preferred_stock(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for treasury_stock_preferred_stock_non_redeemable

ciq data item 1250

treasury_stock_preferred_stock_convertible(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1249

treasury_stock_preferred_stock_non_redeemable(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1250

treasury_stock_preferred_stock_redeemable(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1251

treasury_stock_redeemable_preferred_stock(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for treasury_stock_preferred_stock_redeemable

ciq data item 1251

unusual_items(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for total_unusual_items

ciq data item 19

validate_inputs(self, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → None

Test the time inputs for validity.

vendor

Returns the associated company’s current and previous vendors

weighted_average_basic_shares_outstanding(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 3217

weighted_average_diluted_shares_outstanding(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 342

working_capital(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 4165

class Securities

Base class for representing a set of Securities

__init__(self, kfinance_api_client: 'KFinanceApiClient', security_ids: 'Iterable[int]') → 'None'

Initialize the Securities

Parameters

• kfinance_api_client (KFinanceApiClient) – The KFinanceApiClient used to fetch data

• security_ids (Iterable[int]) – An iterable of S&P CIQ Security ids

class Security

Security class

Parameters

• kfinance_api_client (KFinanceApiClient) – The KFinanceApiClient used to fetch data

• security_id (int) – The S&P CIQ security id

__init__(self, kfinance_api_client: 'KFinanceApiClient', security_id: 'int')

Initialize the Security object.

Parameters

• kfinance_api_client (KFinanceApiClient) – The KFinanceApiClient used to fetch data

• security_id (int) – The CIQ security id

__str__(self) → 'str'

String representation for the security object

cusip

Get the CUSIP for the object

Returns

The CUSIP

Return type

str

isin

Get the ISIN for the object

Returns

The ISIN

Return type

str

primary_trading_item

Return the primary trading item for the Security object

Returns

a TradingItem object of the primary trading item of security_id

Return type

TradingItem

trading_items

Return the trading items for the Security object

Returns

a TradingItems object containing the list of trading items of security_id

Return type

TradingItems

class Ticker

Base Ticker class for accessing data on company

Parameters

• kfinance_api_client (KFinanceApiClient) – The KFinanceApiClient used to fetch data

• exchange_code (str, optional) – The exchange code identifying which exchange the ticker is on

__init__(self, kfinance_api_client: 'KFinanceApiClient', identifier: 'Optional[str]' = None, exchange_code: 'Optional[str]' = None, company_id: 'Optional[int]' = None, security_id: 'Optional[int]' = None, trading_item_id: 'Optional[int]' = None) → 'None'

Initialize the Ticker object. [identifier] can be a ticker, ISIN, or CUSIP. Identifier is prioritized over identification triple (company_id, security_id, & trading_item_id)

Parameters

• kfinance_api_client (KFinanceApiClient) – The KFinanceApiClient used to fetch data

• identifier (str, optional) – The ticker symbol, ISIN, or CUSIP, default None

• exchange_code (str, optional) – The exchange code identifying which exchange the ticker is on. It is only needed if symbol is passed in and default None

• company_id (int, optional) – The S&P Global CIQ Company Id, defaults None

• security_id (int, optional) – The S&P Global CIQ Security Id, default None

• trading_item_id (int, optional) – The S&P Global CIQ Trading Item Id, default None

__str__(self) → 'str'

String representation for the ticker object

accounts_payable(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1018

accounts_receivable(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1021

accrued_expenses(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1016

accumulated_depreciation(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1075

additional_paid_in_capital(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1084

additional_paid_in_capital_preferred_stock(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for preferred_stock_additional_paid_in_capital

ciq data item 1085

adjustments_to_cash_flow_net_income(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 21523

amortization_of_goodwill_and_intangibles(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 31

asset_writedown(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 32

assets(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for total_assets

ciq data item 1007

balance_sheet(self, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

The templated balance sheet

basic_earning_per_share(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for basic_eps

ciq data item 9

basic_earning_per_share_excluding_extra_items(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for basic_eps_excluding_extra_items

ciq data item 3064

basic_earning_per_share_from_accounting_change(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for basic_eps_from_accounting_change

ciq data item 145

basic_earning_per_share_from_accounting_change_and_extraordinary_items(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for basic_eps_from_accounting_change_and_extraordinary_items

ciq data item 45

basic_earning_per_share_from_extraordinary_items(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for basic_eps_from_extraordinary_items

ciq data item 146

basic_earning_per_share_including_extra_items(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for basic_eps

ciq data item 9

basic_eps(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 9

basic_eps_excluding_extra_items(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 3064

basic_eps_from_accounting_change(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 145

basic_eps_from_accounting_change_and_extraordinary_items(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 45

basic_eps_from_extraordinary_items(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 146

basic_eps_including_extra_items(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for basic_eps

ciq data item 9

borrower

Returns the associated company’s current and previous borrowers

capex(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for capital_expenditure

ciq data item 2021

capital_expenditure(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2021

capital_expenditures(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for capital_expenditure

ciq data item 2021

capital_leases(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1183

capitalized_leases(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for capital_leases

ciq data item 1183

cash(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for cash_and_equivalents

ciq data item 1096

cash_acquisitions(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2057

cash_and_cash_equivalents(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for cash_and_equivalents

ciq data item 1096

cash_and_equivalents(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1096

cash_and_short_term_investments(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for total_cash_and_short_term_investments

ciq data item 1002

cash_flow(self, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

The templated cash flow statement

cash_flow_from_operations(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for cash_from_operations

ciq data item 2006

cash_from_discontinued_operation(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for net_cash_from_discontinued_operation

ciq data item 2081

cash_from_financing(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2004

cash_from_financing_activities(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for cash_from_financing

ciq data item 2004

cash_from_investing(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2005

cash_from_investing_activities(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for cash_from_investing

ciq data item 2005

cash_from_operating_activities(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for cash_from_operations

ciq data item 2006

cash_from_operations(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2006

cashflow(self, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

The templated cash flow statement

cashflow_from_financing(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for cash_from_financing

ciq data item 2004

cashflow_from_financing_activities(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for cash_from_financing

ciq data item 2004

cashflow_from_investing(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for cash_from_investing

ciq data item 2005

cashflow_from_investing_activities(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for cash_from_investing

ciq data item 2005

change_in_accounts_payable(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2017

change_in_accounts_receivable(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2018

change_in_cash(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for net_change_in_cash

ciq data item 2093

change_in_deferred_taxes(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2084

change_in_income_taxes(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2101

change_in_inventories(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2099

change_in_net_operating_assets(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2010

change_in_net_working_capital(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 4421

change_in_other_net_operating_assets(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2045

change_in_trading_asset_securities(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2134

change_in_unearned_revenue(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2139

client_services

Returns the associated company’s current and previous client_servicess

cogs(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for cost_of_goods_sold

ciq data item 34

common_dividends_paid(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2074

common_equity(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for total_common_equity

ciq data item 1006

common_shares_outstanding(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1100

common_stock(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1103

company

Set and return the company for the object

Returns

The company returned as Company object

Return type

Company

company_id

Get the company id for the object

Returns

the CIQ company id

Return type

int

continued_operations_earnings(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for earnings_from_continued_operations

ciq data item 7

convertible_preferred_stock(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for preferred_stock_convertible

ciq data item 1214

cor(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for cost_of_revenue

ciq data item 1

cost_of_goods_sold(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 34

cost_of_revenue(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1

creditor

Returns the associated company’s current and previous creditors

currency_exchange_gains(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 38

current_accounts_receivable(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for accounts_receivable

ciq data item 1021

current_assets(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for total_current_assets

ciq data item 1008

current_borrowing(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for short_term_borrowings

ciq data item 1046

current_borrowings(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for short_term_borrowings

ciq data item 1046

current_debt_issued(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for short_term_debt_issued

ciq data item 2043

current_debt_repaid(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for short_term_debt_repaid

ciq data item 2044

current_deferred_tax_asset(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for deferred_tax_asset_current_portion

ciq data item 1117

current_deferred_tax_liability(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1119

current_income_taxes_payable(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1094

current_liabilities(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for total_current_liabilities

ciq data item 1009

current_notes_receivable(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for notes_receivable

ciq data item 1048

current_other_receivables(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for other_receivables

ciq data item 1206

current_portion_of_cap_leases(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for current_portion_of_capital_leases

ciq data item 1090

current_portion_of_capital_leases(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1090

current_portion_of_capitalized_leases(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for current_portion_of_capital_leases

ciq data item 1090

current_portion_of_income_taxes_payable(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for current_income_taxes_payable

ciq data item 1094

current_portion_of_leases(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for current_portion_of_capital_leases

ciq data item 1090

current_portion_of_long_term_debt(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1297

current_portion_of_long_term_debt_and_capital_leases(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1279

current_portion_of_long_term_debt_and_capitalized_leases(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for current_portion_of_long_term_debt_and_capital_leases

ciq data item 1279

current_portion_of_lt_debt(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for current_portion_of_long_term_debt

ciq data item 1297

current_portion_of_lt_debt_and_cap_leases(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for current_portion_of_long_term_debt_and_capital_leases

ciq data item 1279

current_portion_of_non_current_debt(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for current_portion_of_long_term_debt

ciq data item 1297

current_portion_of_non_current_debt_and_capital_leases(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for current_portion_of_long_term_debt_and_capital_leases

ciq data item 1279

current_portion_of_non_current_debt_and_capitalized_leases(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for current_portion_of_long_term_debt_and_capital_leases

ciq data item 1279

current_portion_of_unearned_revenue(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for current_unearned_revenue

ciq data item 1074

current_ratio(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 4030

current_total_receivable(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for total_receivables

ciq data item 1001

current_total_receivables(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for total_receivables

ciq data item 1001

current_unearned_revenue(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1074

cusip

Get the CUSIP for the object

Returns

The CUSIP

Return type

str

customer

Returns the associated company’s current and previous customers

d_and_a(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for depreciation_and_amortization

ciq data item 41

debt_ratio(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for total_debt_to_equity_ratio

ciq data item 4034

deferred_tax_asset_current_portion(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1117

depreciation(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2143

depreciation_and_amortization(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 41

depreciation_of_rental_assets(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 42409

diluted_earning_per_share(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for diluted_eps

ciq data item 8

diluted_earning_per_share_excluding_extra_items(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for diluted_eps_excluding_extra_items

ciq data item 142

diluted_earning_per_share_from_accounting_change(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for diluted_eps_from_accounting_change

ciq data item 141

diluted_earning_per_share_from_accounting_change_and_extraordinary_items(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for diluted_eps_from_accounting_change_and_extraordinary_items

ciq data item 44

diluted_earning_per_share_from_discontinued_operations(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for diluted_eps_from_discontinued_operations

ciq data item 143

diluted_earning_per_share_from_extraordinary_items(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for diluted_eps_from_extraordinary_items

ciq data item 144

diluted_earning_per_share_including_extra_items(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for diluted_eps

ciq data item 8

diluted_eps(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 8

diluted_eps_excluding_extra_items(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 142

diluted_eps_from_accounting_change(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 141

diluted_eps_from_accounting_change_and_extraordinary_items(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 44

diluted_eps_from_discontinued_operations(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 143

diluted_eps_from_extraordinary_items(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 144

diluted_eps_including_extra_items(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for diluted_eps

ciq data item 8

discontinued_operations_earnings(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for earnings_from_discontinued_operations

ciq data item 40

distributable_cash_per_share(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 23317

distributor

Returns the associated company’s current and previous distributors

divestitures(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2077

dividends_paid(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for total_dividends_paid

ciq data item 2022

dividends_per_share(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 3058

dna(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for depreciation_and_amortization

ciq data item 41

earnings_before_interest_and_taxes(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for ebit

ciq data item 400

earnings_before_interest_taxes_and_amortization(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for ebita

ciq data item 100689

earnings_before_interest_taxes_depreciation_amortization_and_rental_expense(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for ebitdar

ciq data item 21674

earnings_before_interest_taxes_depreciation_and_amortization(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for ebitda

ciq data item 4051

earnings_before_taxes_excluding_unusual_items(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for ebt_excluding_unusual_items

ciq data item 4

earnings_before_taxes_including_unusual_items(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for ebt_including_unusual_items

ciq data item 139

earnings_call_datetimes

Get the datetimes of the companies earnings calls

Returns

a list of datetimes for the companies earnings calls

Return type

list[datetime]

earnings_from_continued_operations(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 7

earnings_from_discontinued_operations(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 40

ebit(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 400

ebita(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 100689

ebitda(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 4051

ebitdar(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 21674

ebt_excluding_unusual_items(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 4

ebt_including_unusual_items(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 139

effective_tax_rate(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 4376

equity(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for total_equity

ciq data item 1275

equity_adjustment_preferred_stock(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for preferred_stock_equity_adjustment

ciq data item 1215

exploration_and_drilling_costs(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 49

exploration_and_drilling_expense(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for exploration_and_drilling_costs

ciq data item 49

extraordinary_item_and_accounting_change(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 42

fees_and_other_income(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 168

ffo(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for funds_from_operations

ciq data item 3074

finance_division_debt_current_portion(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1030

finance_division_debt_long_term_portion(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for finance_division_debt_non_current_portion

ciq data item 1035

finance_division_debt_non_current_portion(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1035

finance_division_interest_expense(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 50

finance_division_loans_and_leases_long_term(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1033

finance_division_loans_and_leases_short_term(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1032

finance_division_long_term_debt(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for finance_division_debt_non_current_portion

ciq data item 1035

finance_division_long_term_loans_and_leases(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for finance_division_loans_and_leases_long_term

ciq data item 1033

finance_division_non_current_debt(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for finance_division_debt_non_current_portion

ciq data item 1035

finance_division_operating_expense(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 51

finance_division_other_current_assets(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1029

finance_division_other_current_liabilities(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1031

finance_division_other_long_term_assets(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for finance_division_other_non_current_assets

ciq data item 1034

finance_division_other_long_term_liabilities(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for finance_division_other_non_current_liabilities

ciq data item 1036

finance_division_other_non_current_assets(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1034

finance_division_other_non_current_liabilities(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1036

finance_division_other_short_term_assets(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for finance_division_other_current_assets

ciq data item 1029

finance_division_revenue(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 52

finance_division_short_term_loans_and_leases(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for finance_division_loans_and_leases_short_term

ciq data item 1032

foreign_exchange_adjustments(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for foreign_exchange_rate_adjustments

ciq data item 2144

foreign_exchange_rate_adjustments(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2144

franchisee

Returns the associated company’s current and previous franchisees

franchisor

Returns the associated company’s current and previous franchisors

funds_from_operations(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 3074

fx_adjustments(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for foreign_exchange_rate_adjustments

ciq data item 2144

gain_from_sale_of_assets(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 62

gain_from_sale_of_investments(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 56

goodwill(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1171

gppe(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for gross_property_plant_and_equipment

ciq data item 1169

gross_ppe(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for gross_property_plant_and_equipment

ciq data item 1169

gross_profit(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 10

gross_property_plant_and_equipment(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1169

history(self, periodicity: 'str' = 'day', adjusted: 'bool' = True, start_date: 'Optional[str]' = None, end_date: 'Optional[str]' = None) → 'pd.DataFrame'

Retrieves the historical price data for a given asset over a specified date range.

Parameters

• periodicity (str) – Determines the frequency of the historical data returned. Options are “day”, “week”, “month” and “year”. This default to “day”

• adjusted (bool, optional) – Whether to retrieve adjusted prices that account for corporate actions such as dividends and splits, it defaults True

• start_date (str, optional) – The start date for historical price retrieval in format “YYYY-MM-DD”, default to None

• end_date (str, optional) – The end date for historical price retrieval in format “YYYY-MM-DD”, default to None

Returns

A pd.DataFrame containing historical price data with columns corresponding to the specified periodicity, with Date as the index, and columns “open”, “high”, “low”, “close”, “volume” in type decimal. The Date index is a string that depends on the periodicity. If periodicity=”day”, the Date index is the day in format “YYYY-MM-DD”, eg “2024-05-13” If periodicity=”week”, the Date index is the week number of the year in format “YYYY Week ##”, eg “2024 Week 2” If periodicity=”month”, the Date index is the month name of the year in format “<Month> YYYY”, eg “January 2024”. If periodicity=”year”, the Date index is the year in format “YYYY”, eg “2024”.

Return type

pd.DataFrame

history_metadata

Get information about exchange and quotation

Returns

A dict containing data about the currency, symbol, exchange, type of instrument, and the first trading date

Return type

HistoryMetadata

impairment_o_and_g(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for impairment_of_oil_gas_and_mineral_properties

ciq data item 71

impairment_of_goodwill(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 209

impairment_of_oil_and_gas(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for impairment_of_oil_gas_and_mineral_properties

ciq data item 71

impairment_of_oil_gas_and_mineral_properties(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 71

in_process_r_and_d_cost(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for in_process_research_and_development_expense

ciq data item 72

in_process_r_and_d_expense(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for in_process_research_and_development_expense

ciq data item 72

in_process_research_and_development_cost(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for in_process_research_and_development_expense

ciq data item 72

in_process_research_and_development_expense(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 72

in_process_rnd_cost(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for in_process_research_and_development_expense

ciq data item 72

in_process_rnd_expense(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for in_process_research_and_development_expense

ciq data item 72

income_from_affiliates(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 47

income_statement(self, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

The templated income statement

income_stmt(self, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

The templated income statement

income_tax(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for income_tax_expense

ciq data item 75

income_tax_expense(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 75

income_taxes(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for income_tax_expense

ciq data item 75

info

Get the company info for the ticker

Returns

a dict with containing: name, status, type, simple industry, number of employees, founding date, webpage, address, city, zip code, state, country, & iso_country

Return type

dict

insurance_division_operating_expense(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 69

insurance_division_revenue(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 70

insurance_settlements(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 73

interest_and_investment_income(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 65

interest_expense(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 82

interest_expense_finance_division(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for finance_division_interest_expense

ciq data item 50

inventories(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for inventory

ciq data item 1043

inventory(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1043

investor_relations_client

Returns the associated company’s current and previous investor_relations_clients

investor_relations_firm

Returns the associated company’s current and previous investor_relations_firms

isin

Get the ISIN for the object

Returns

The ISIN

Return type

str

issuance_of_common_stock(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2169

issuance_of_preferred_stock(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2181

landlord

Returns the associated company’s current and previous landlords

legal_settlements(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 77

lessee

Returns the associated company’s current and previous lessees

lessor

Returns the associated company’s current and previous lessors

liabilities(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for total_liabilities

ciq data item 1276

liabilities_and_equity(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for total_liabilities_and_equity

ciq data item 1013

licensee

Returns the associated company’s current and previous licensees

licensor

Returns the associated company’s current and previous licensors

line_item(self, line_item: str, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

Get a DataFrame of a financial line item according to the date ranges.

loans_held_for_sale(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1185

loans_receivable(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for long_term_loans_receivable

ciq data item 1050

long_term_accounts_receivable(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1088

long_term_debt(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1049

long_term_debt_issued(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2034

long_term_debt_repaid(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2036

long_term_deferred_charges(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1025

long_term_deferred_tax_assets(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1026

long_term_finance_division_loans_and_leases(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for finance_division_loans_and_leases_long_term

ciq data item 1033

long_term_investments(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1054

long_term_leases(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for capital_leases

ciq data item 1183

long_term_loans_and_leases_of_the_finance_division(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for finance_division_loans_and_leases_long_term

ciq data item 1033

long_term_loans_receivable(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1050

long_term_other_assets(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for other_long_term_assets

ciq data item 1060

long_term_other_liabilities(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for other_non_current_liabilities

ciq data item 1062

long_term_unearned_revenue(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for non_current_unearned_revenue

ciq data item 1256

loss_on_equity_investments(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2086

merger_and_restructuring_charges(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 363

merger_charges(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 80

minority_interest_in_earnings(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 83

misc_cash_flow_adj(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for miscellaneous_cash_flow_adjustments

ciq data item 2149

miscellaneous_cash_flow_adjustments(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2149

net_cash_from_discontinued_operation(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2081

net_cash_from_investments(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2027

net_change_in_cash(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2093

net_debt(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 4364

net_decrease_in_investment_loans_originated_and_sold(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2032

net_decrease_in_loans_originated_and_sold(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2033

net_income(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 15

net_income_allocable_to_general_partner(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 249

net_income_to_common_shareholders_excluding_extra_items(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 379

net_income_to_common_shareholders_including_extra_items(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 16

net_income_to_company(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 41571

net_income_to_minority_interest(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for minority_interest_in_earnings

ciq data item 83

net_interest_expense(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 368

net_ppe(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for net_property_plant_and_equipment

ciq data item 1004

net_property_plant_and_equipment(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1004

net_working_capital(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1311

non_current_accounts_receivable(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for long_term_accounts_receivable

ciq data item 1088

non_current_debt(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for long_term_debt

ciq data item 1049

non_current_debt_issued(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for long_term_debt_issued

ciq data item 2034

non_current_debt_repaid(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for long_term_debt_repaid

ciq data item 2036

non_current_deferred_charges(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for long_term_deferred_charges

ciq data item 1025

non_current_deferred_tax_assets(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for long_term_deferred_tax_assets

ciq data item 1026

non_current_deferred_tax_liability(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1027

non_current_investments(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for long_term_investments

ciq data item 1054

non_current_loans_receivable(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for long_term_loans_receivable

ciq data item 1050

non_current_other_assets(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for other_long_term_assets

ciq data item 1060

non_current_other_liabilities(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for other_non_current_liabilities

ciq data item 1062

non_current_unearned_revenue(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1256

non_redeemable_preferred_stock(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for preferred_stock_non_redeemable

ciq data item 1216

normal_revenue(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for revenue

ciq data item 112

normalized_basic_earning_per_share(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for normalized_basic_eps

ciq data item 4379

normalized_basic_eps(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 4379

normalized_diluted_earning_per_share(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for normalized_diluted_eps

ciq data item 4380

normalized_diluted_eps(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 4380

notes_receivable(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1048

nppe(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for net_property_plant_and_equipment

ciq data item 1004

operating_expense(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for total_operating_expense

ciq data item 373

operating_expense_finance_division(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for finance_division_operating_expense

ciq data item 51

operating_expense_insurance_division(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for insurance_division_operating_expense

ciq data item 69

operating_income(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 21

other_adjustments_to_net_income(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 259

other_amortization(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2014

other_current_assets(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1055

other_current_assets_of_the_finance_division(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for finance_division_other_current_assets

ciq data item 1029

other_current_liabilities(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for other_current_liability

ciq data item 1057

other_current_liability(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1057

other_equity(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1028

other_financing_activities(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2050

other_intangibles(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1040

other_investing_activities(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2051

other_long_term_assets(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1060

other_long_term_assets_of_the_finance_division(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for finance_division_other_non_current_assets

ciq data item 1034

other_long_term_liabilities(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for other_non_current_liabilities

ciq data item 1062

other_non_current_assets(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for other_long_term_assets

ciq data item 1060

other_non_current_assets_of_the_finance_division(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for finance_division_other_non_current_assets

ciq data item 1034

other_non_current_liabilities(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1062

other_non_operating_income(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 85

other_operating_activities(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2047

other_operating_expense(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 260

other_preferred_stock(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for preferred_stock_other

ciq data item 1065

other_preferred_stock_adjustments(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 281

other_receivables(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1206

other_revenue(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 90

other_short_term_assets_of_the_finance_division(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for finance_division_other_current_assets

ciq data item 1029

other_unusual_items(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 87

pension_and_other_post_retirement_benefit(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1213

ppe(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for net_property_plant_and_equipment

ciq data item 1004

pre_opening_costs(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 96

pre_opening_expense(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for pre_opening_costs

ciq data item 96

preferred_dividends_and_other_adjustments(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 97

preferred_dividends_paid(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2116

preferred_equity(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for total_preferred_equity

ciq data item 1005

preferred_stock(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for total_preferred_equity

ciq data item 1005

preferred_stock_additional_paid_in_capital(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1085

preferred_stock_convertible(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1214

preferred_stock_dividend(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 280

preferred_stock_equity_adjustment(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1215

preferred_stock_non_redeemable(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1216

preferred_stock_other(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1065

preferred_stock_redeemable(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1217

premium_on_redemption_of_preferred_stock(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 279

prepaid_expense(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1212

prepaid_expenses(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for prepaid_expense

ciq data item 1212

price_chart(self, periodicity: 'str' = 'day', adjusted: 'bool' = True, start_date: 'Optional[str]' = None, end_date: 'Optional[str]' = None) → 'Image'

Get the price chart.

Parameters

• periodicity (str) – Determines the frequency of the historical data returned. Options are “day”, “week”, “month” and “year”. This default to “day”

• adjusted (bool, optional) – Whether to retrieve adjusted prices that account for corporate actions such as dividends and splits, it defaults True

• start_date (str, optional) – The start date for historical price retrieval in format “YYYY-MM-DD”, default to None

• end_date (str, optional) – The end date for historical price retrieval in format “YYYY-MM-DD”, default to None

Returns

An image showing the price chart of the trading item

Return type

Image

primary_security

Set and return the primary security for the object

Returns

The primary security as a Security object

Return type

Security

primary_trading_item

Set and return the trading item for the object

Returns

The trading item returned as TradingItem object

Return type

TradingItem

property_plant_and_equipment(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for net_property_plant_and_equipment

ciq data item 1004

provision_for_bad_debt(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for provision_for_bad_debts

ciq data item 95

provision_for_bad_debts(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 95

provision_for_credit_losses(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2112

quick_ratio(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 4121

r_and_d_cost(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for research_and_development_expense

ciq data item 100

r_and_d_expense(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for research_and_development_expense

ciq data item 100

redeemable_preferred_stock(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for preferred_stock_redeemable

ciq data item 1217

regular_revenue(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for revenue

ciq data item 112

relationships(self, relationship_type: kensho_finance.constants.BusinessRelationshipType) → 'BusinessRelationships'

Returns a BusinessRelationships object that includes the current and previous Companies associated with company_id and filtered by relationship_type. The function calls fetch_companies_from_business_relationship.

Parameters

relationship_type (BusinessRelationshipType) – The type of relationship to filter by. Valid relationship types are defined in the BusinessRelationshipType class.

Returns

A BusinessRelationships object containing a tuple of Companies objects that lists current and previous company IDs that have the specified relationship with the given company_id.

Return type

BusinessRelationships

repurchase_of_common_stock(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2164

repurchase_of_preferred_stock(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2172

research_and_development_cost(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for research_and_development_expense

ciq data item 100

research_and_development_expense(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 100

restricted_cash(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1104

restructuring_charges(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 98

retained_earnings(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1222

revenue(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 112

revenue_from_interest_and_investment_income(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 110

revenue_from_sale_of_assets(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 104

revenue_from_sale_of_investments(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 106

rnd_cost(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for research_and_development_expense

ciq data item 100

rnd_expense(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for research_and_development_expense

ciq data item 100

sale_of_intangible_asset(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for sale_of_intangible_assets

ciq data item 2029

sale_of_intangible_assets(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2029

sale_of_intangibles(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for sale_of_intangible_assets

ciq data item 2029

sale_of_ppe(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for sale_of_property_plant_and_equipment

ciq data item 2042

sale_of_property_plant_and_equipment(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2042

sale_of_real_estate(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2040

sale_of_real_estate_properties(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for sale_of_real_estate

ciq data item 2040

sale_of_real_properties(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for sale_of_real_estate

ciq data item 2040

sale_proceeds_from_rental_assets(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 42411

security_id

Get the CIQ security id for the object

Returns

the CIQ security id

Return type

int

selling_general_and_admin(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for selling_general_and_admin_expense

ciq data item 102

selling_general_and_admin_cost(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for selling_general_and_admin_expense

ciq data item 102

selling_general_and_admin_expense(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 102

set_company_id(self) → 'int'

Set the company id for the object

Returns

the CIQ company id

Return type

int

set_identification_triple(self) → 'None'

Get & set company_id, security_id, & trading_item_id for ticker with an exchange

set_security_id(self) → 'int'

Set the security id for the object

Returns

the CIQ security id

Return type

int

set_trading_item_id(self) → 'int'

Set the trading item id for the object

Returns

the CIQ trading item id

Return type

int

sg_and_a(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for selling_general_and_admin_expense

ciq data item 102

sga(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for selling_general_and_admin_expense

ciq data item 102

shareholders_equity(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for total_equity

ciq data item 1275

short_term_accounts_receivable(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for accounts_receivable

ciq data item 1021

short_term_assets(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for total_current_assets

ciq data item 1008

short_term_borrowing(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for short_term_borrowings

ciq data item 1046

short_term_borrowings(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1046

short_term_debt_issued(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2043

short_term_debt_repaid(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2044

short_term_deferred_tax_asset(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for deferred_tax_asset_current_portion

ciq data item 1117

short_term_finance_division_loans_and_leases(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for finance_division_loans_and_leases_short_term

ciq data item 1032

short_term_investments(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1069

short_term_loans_and_leases_of_the_finance_division(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for finance_division_loans_and_leases_short_term

ciq data item 1032

short_term_notes_receivable(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for notes_receivable

ciq data item 1048

short_term_other_receivables(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for other_receivables

ciq data item 1206

short_term_total_receivable(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for total_receivables

ciq data item 1001

short_term_total_receivables(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for total_receivables

ciq data item 1001

special_dividends_paid(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2041

statement(self, statement_type: str, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

Get the company’s financial statement

stock_based_compensation(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2127

strategic_alliance

Returns the associated company’s current and previous strategic_alliances

supplier

Returns the associated company’s current and previous suppliers

tax_benefit_from_stock_options(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2135

tax_rate(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for effective_tax_rate

ciq data item 4376

tenant

Returns the associated company’s current and previous tenants

ticker

Get the ticker if it isn’t available from initialization

total_assets(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1007

total_cash_and_short_term_investments(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1002

total_common_equity(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1006

total_current_assets(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1008

total_current_liabilities(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1009

total_current_portion_of_long_term_debt_and_capital_leases(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for current_portion_of_long_term_debt_and_capital_leases

ciq data item 1279

total_current_portion_of_long_term_debt_and_capitalized_leases(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for current_portion_of_long_term_debt_and_capital_leases

ciq data item 1279

total_current_portion_of_lt_debt_and_cap_leases(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for current_portion_of_long_term_debt_and_capital_leases

ciq data item 1279

total_current_portion_of_non_current_debt_and_capital_leases(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for current_portion_of_long_term_debt_and_capital_leases

ciq data item 1279

total_current_portion_of_non_current_debt_and_capitalized_leases(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for current_portion_of_long_term_debt_and_capital_leases

ciq data item 1279

total_d_and_a(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for total_depreciation_and_amortization

ciq data item 2

total_debt(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 4173

total_debt_issued(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2161

total_debt_ratio(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for total_debt_to_equity_ratio

ciq data item 4034

total_debt_repaid(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2166

total_debt_to_capital(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 43907

total_debt_to_equity(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for total_debt_to_equity_ratio

ciq data item 4034

total_debt_to_equity_ratio(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 4034

total_debt_to_total_equity(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for total_debt_to_equity_ratio

ciq data item 4034

total_depreciation_and_amortization(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2

total_dividends_paid(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2022

total_dna(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for total_depreciation_and_amortization

ciq data item 2

total_equity(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1275

total_liabilities(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1276

total_liabilities_and_equity(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1013

total_operating_expense(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 373

total_other_investing_activities(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2177

total_other_non_cash_items(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 2179

total_other_non_operating_income(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 371

total_other_operating_expense(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 380

total_other_revenue(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 357

total_other_unusual_items(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 374

total_preferred_equity(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1005

total_preferred_stock(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for total_preferred_equity

ciq data item 1005

total_receivable(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for total_receivables

ciq data item 1001

total_receivables(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1001

total_revenue(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 28

total_selling_general_and_admin(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for total_selling_general_and_admin_expense

ciq data item 23

total_selling_general_and_admin_cost(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for total_selling_general_and_admin_expense

ciq data item 23

total_selling_general_and_admin_expense(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 23

total_sga(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for total_selling_general_and_admin_expense

ciq data item 23

total_shareholders_equity(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for total_equity

ciq data item 1275

total_short_term_assets(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for total_current_assets

ciq data item 1008

total_unusual_items(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 19

trading_asset_securities(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1244

trading_item_id

Get the CIQ trading item id for the object

Returns

the CIQ trading item id

Return type

int

transfer_agent

Returns the associated company’s current and previous transfer_agents

transfer_agent_client

Returns the associated company’s current and previous transfer_agent_clients

treasury_convertible_preferred_stock(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for treasury_stock_preferred_stock_convertible

ciq data item 1249

treasury_non_redeemable_preferred_stock(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for treasury_stock_preferred_stock_non_redeemable

ciq data item 1250

treasury_preferred_stock_convertible(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for treasury_stock_preferred_stock_convertible

ciq data item 1249

treasury_preferred_stock_non_redeemable(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for treasury_stock_preferred_stock_non_redeemable

ciq data item 1250

treasury_preferred_stock_redeemable(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for treasury_stock_preferred_stock_redeemable

ciq data item 1251

treasury_redeemable_preferred_stock(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for treasury_stock_preferred_stock_redeemable

ciq data item 1251

treasury_stock(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1248

treasury_stock_convertible_preferred_stock(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for treasury_stock_preferred_stock_convertible

ciq data item 1249

treasury_stock_non_redeemable_preferred_stock(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for treasury_stock_preferred_stock_non_redeemable

ciq data item 1250

treasury_stock_preferred_stock_convertible(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1249

treasury_stock_preferred_stock_non_redeemable(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1250

treasury_stock_preferred_stock_redeemable(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 1251

treasury_stock_redeemable_preferred_stock(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for treasury_stock_preferred_stock_redeemable

ciq data item 1251

unusual_items(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

alias for total_unusual_items

ciq data item 19

validate_inputs(self, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → None

Test the time inputs for validity.

vendor

Returns the associated company’s current and previous vendors

weighted_average_basic_shares_outstanding(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 3217

weighted_average_diluted_shares_outstanding(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 342

working_capital(self: Any, period_type: Optional[str] = None, start_year: Optional[int] = None, end_year: Optional[int] = None, start_quarter: Optional[int] = None, end_quarter: Optional[int] = None) → pandas.core.frame.DataFrame

ciq data item 4165

class Tickers

Base TickerSet class for representing a set of Tickers

__init__(self, kfinance_api_client: 'KFinanceApiClient', id_triples: 'Iterable[IdentificationTriple]') → 'None'

Initialize the Ticker Set

Parameters

• kfinance_api_client (KFinanceApiClient) – The KFinanceApiClient used to fetch data

• id_triples (Iterable[IdentificationTriple]) – An Iterable of IdentificationTriples that will become the ticker objects making up the tickers object

companies(self) → 'Companies'

Build a group of company objects from the group of tickers

Returns

The Companies corresponding to the Tickers

Return type

Companies

securities(self) → 'Securities'

Build a group of security objects from the group of tickers

Returns

The Securities corresponding to the Tickers

Return type

Securities

trading_items(self) → 'TradingItems'

Build a group of trading item objects from the group of ticker

Returns

The TradingItems corresponding to the Tickers

Return type

TradingItems

class TradingItem

Trading Class

Parameters

• kfinance_api_client (KFinanceApiClient) – The KFinanceApiClient used to fetch data

• trading_item_id (int) – The S&P CIQ Trading Item ID

__init__(self, kfinance_api_client: 'KFinanceApiClient', trading_item_id: 'int')

Initialize the trading item object

Parameters

• kfinance_api_client (KFinanceApiClient) – The KFinanceApiClient used to fetch data

• trading_item_id (int) – The S&P CIQ Trading Item ID

__str__(self) → 'str'

String representation for the company object

from_ticker(kfinance_api_client: 'KFinanceApiClient', ticker: 'str', exchange_code: 'Optional[str]' = None) → "'TradingItem'"

Return TradingItem object from ticker

Parameters

• kfinance_api_client (KFinanceApiClient) – The KFinanceApiClient used to fetch data

• ticker (str) – the ticker symbol

• exchange_code (str, optional) – The exchange code identifying which exchange the ticker is on.

history(self, periodicity: 'str' = 'day', adjusted: 'bool' = True, start_date: 'Optional[str]' = None, end_date: 'Optional[str]' = None) → 'pd.DataFrame'

Retrieves the historical price data for a given asset over a specified date range.

Parameters

• periodicity (str) – Determines the frequency of the historical data returned. Options are “day”, “week”, “month” and “year”. This default to “day”

• adjusted (Optional[bool]) – Whether to retrieve adjusted prices that account for corporate actions such as dividends and splits, it defaults True

• start_date (Optional[str]) – The start date for historical price retrieval in format “YYYY-MM-DD”, default to None

• end_date (Optional[str]) – The end date for historical price retrieval in format “YYYY-MM-DD”, default to None

Returns

A pd.DataFrame containing historical price data with columns corresponding to the specified periodicity, with Date as the index, and columns “open”, “high”, “low”, “close”, “volume” in type decimal. The Date index is a string that depends on the periodicity. If periodicity=”day”, the Date index is the day in format “YYYY-MM-DD”, eg “2024-05-13” If periodicity=”week”, the Date index is the week number of the year in format “YYYY Week ##”, eg “2024 Week 2” If periodicity=”month”, the Date index is the month name of the year in format “<Month> YYYY”, eg “January 2024”. If periodicity=”year”, the Date index is the year in format “YYYY”, eg “2024”.

Return type

pd.DataFrame

history_metadata

Get information about exchange and quotation

Returns

A dict containing data about the currency, symbol, exchange, type of instrument, and the first trading date

Return type

HistoryMetadata

price_chart(self, periodicity: 'str' = 'day', adjusted: 'bool' = True, start_date: 'Optional[str]' = None, end_date: 'Optional[str]' = None) → 'Image'

Get the price chart.

Parameters

• periodicity (str) – Determines the frequency of the historical data returned. Options are “day”, “week”, “month” and “year”. This default to “day”

• adjusted (Optional[bool]) – Whether to retrieve adjusted prices that account for corporate actions such as dividends and splits, it defaults True

• start_date (Optional[str]) – The start date for historical price retrieval in format “YYYY-MM-DD”, default to None

• end_date (Optional[str]) – The end date for historical price retrieval in format “YYYY-MM-DD”, default to None

Returns

An image showing the price chart of the trading item

Return type

Image

trading_item_id

Get the trading item id for the object

Returns

the CIQ trading item id

Return type

int

class TradingItems

Base class for representing a set of Trading Items

__init__(self, kfinance_api_client: 'KFinanceApiClient', trading_item_ids: 'Iterable[int]') → 'None'

Initialize the Trading Items

Parameters

• kfinance_api_client (KFinanceApiClient) – The KFinanceApiClient used to fetch data

• company_ids (Iterable[int]) – An iterable of S&P CIQ Company ids