{
"cells": [
{
"attachments": {},
"cell_type": "markdown",
"id": "83014ba8",
"metadata": {},
"source": [
"
\n",
" \n",
"\n",
"\n",
"[![GitHub Sponsors](https://img.shields.io/badge/Sponsor_this_Project-grey?logo=github)](https://github.com/sponsors/JerBouma)\n",
"[![Documentation](https://img.shields.io/badge/Documentation-grey?logo=readme)](https://www.jeroenbouma.com/projects/financedatabase)\n",
"[![Supported Python Versions](https://img.shields.io/pypi/pyversions/financedatabase)](https://pypi.org/project/financedatabase/)\n",
"[![PYPI Version](https://img.shields.io/pypi/v/financedatabase)](https://pypi.org/project/financedatabase/)\n",
"[![PYPI Downloads](https://static.pepy.tech/badge/financedatabase/month)](https://pepy.tech/project/financedatabase)\n",
"\n",
"The **FinanceDatabase** serves the role of providing anyone with any type of financial product categorisation entirely for free. To be able to achieve this, the FinanceDatabase relies on involvement from the community to add, edit and remove tickers over time. This is made easy enough that anyone, even with a lack of coding experience can contribute because of the usage of CSV files that can be manually edited. I'd like to invite you to go to the **[Contributing Guidelines](https://github.com/JerBouma/FinanceDatabase/blob/main/CONTRIBUTING.md)** to understand how you can help. Thank you!\n",
"\n",
"As a private investor, the sheer amount of information that can be found on the internet is rather daunting. Trying to \n",
"understand what type of companies or ETFs are available is incredibly challenging with there being millions of\n",
"companies and derivatives available on the market. Sure, the most traded companies and ETFs can quickly be found\n",
"simply because they are known to the public (for example, Microsoft, Tesla, S&P500 ETF or an All-World ETF). However, \n",
"what else is out there is often unknown.\n",
"\n",
"**This database tries to solve that**. It features 300.000+ symbols containing Equities, ETFs, Funds, Indices, \n",
"Currencies, Cryptocurrencies and Money Markets. It therefore allows you to obtain a broad overview of sectors,\n",
"industries, types of investments and much more.\n",
"\n",
"The aim of this database is explicitly _not_ to provide up-to-date fundamentals or stock data as those can be obtained \n",
"with ease (with the help of this database) by using the [FinanceToolkit](https://github.com/JerBouma/FinanceToolkit). Instead, it gives insights into the products \n",
"that exist in each country, industry and sector and gives the most essential information about each product. With \n",
"this information, you can analyse specific areas of the financial world and/or find a product that is hard to find.\n"
]
},
{
"attachments": {},
"cell_type": "markdown",
"id": "f0f9849a",
"metadata": {},
"source": [
"## Table of Contents\n",
"\n",
"1. [Installation](#installation)\n",
"2. [Quick Start](#quickstart)\n",
"3. [Understanding the available options](#understanding-the-available-options)\n",
"4. [Collecting information from the database](#collecting-information-from-the-database)\n",
" 1. [Equities](#equities)\n",
" 2. [ETFs](#etfs)\n",
" 3. [Funds](#funds)\n",
" 4. [Indices](#indices)\n",
" 5. [Currencies](#currencies)\n",
" 6. [Cryptocurrencies](#cryptocurrencies)\n",
" 7. [Money Markets](#moneymarkets)\n",
"5. [Searching the database in detail](#searching-the-database-in-detail)"
]
},
{
"attachments": {},
"cell_type": "markdown",
"id": "3a2a1a46",
"metadata": {},
"source": [
"# Installation\n",
"To install the FinanceDatabase it simply requires the following:\n",
"\n",
"```\n",
"pip install financedatabase -U\n",
"```\n",
"\n",
"Then within Python use:\n",
"\n",
"```python\n",
"import financedatabase as fd\n",
"```"
]
},
{
"cell_type": "code",
"execution_count": 1,
"id": "e847b00b",
"metadata": {},
"outputs": [],
"source": [
"import financedatabase as fd"
]
},
{
"attachments": {},
"cell_type": "markdown",
"id": "f38d4843",
"metadata": {},
"source": [
"# Quickstart"
]
},
{
"attachments": {},
"cell_type": "markdown",
"id": "d45b268e",
"metadata": {},
"source": [
"Same methods apply to all other asset classes as well. Columns may vary."
]
},
{
"cell_type": "code",
"execution_count": 2,
"id": "6e0271f5",
"metadata": {},
"outputs": [],
"source": [
"# Initialize the Equities database\n",
"equities = fd.Equities()\n",
"\n",
"# Obtain all countries from the database\n",
"equities_countries = equities.options(\"country\")\n",
"\n",
"# Obtain all sectors from the database\n",
"equities_sectors = equities.options(\"sector\")\n",
"\n",
"# Obtain all industry groups from the database\n",
"equities_industry_groups = equities.options(\"industry_group\")\n",
"\n",
"# Obtain all industries from a country from the database\n",
"equities_germany_industries = equities.options(\"industry\", country=\"Germany\")\n",
"\n",
"# Obtain a selection from the database\n",
"equities_united_states = equities.select(country=\"United States\")\n",
"\n",
"# Obtain a detailed selection from the database\n",
"equities_usa_machinery = equities.select(\n",
" country=\"United States\", industry=\"Machinery\"\n",
")\n",
"\n",
"# Search specific fields from the database\n",
"equities_uk_biotech = equities.search(\n",
" country=\"United Kingdom\", summary=\"biotech\", exchange=\"LSE\"\n",
")\n",
"\n",
"# Search specific fields from the database with lists\n",
"equities_media_services = equities.search(\n",
" industry=\"Interactive Media & Services\",\n",
" country=\"United States\",\n",
" market_cap=[\"Large Cap\", \"Mega Cap\"]\n",
")\n",
"\n",
"# Use the tickers to obtain data via the Finance Toolkit\n",
"telecomunication_services = equities.search(\n",
" industry=\"Diversified Telecommunication Services\",\n",
" country=\"United States\",\n",
" market_cap=\"Mega Cap\",\n",
" exclude_exchanges=True)\n",
"\n",
"toolkit = telecomunication_services.to_toolkit(\n",
" api_key=\"FINANCIAL_MODELING_PREP_KEY\",\n",
" start_date=\"2000-01-01\",\n",
" progress_bar=False\n",
")\n",
"\n",
"# For example, obtain the historical data\n",
"historical_data = toolkit.get_historical_data()"
]
},
{
"attachments": {},
"cell_type": "markdown",
"id": "9cb7fe0a",
"metadata": {},
"source": [
"# Understanding the available options"
]
},
{
"attachments": {},
"cell_type": "markdown",
"id": "c578765b",
"metadata": {},
"source": [
"Understanding which countries, sectors, industries and categories exist is important to be able to search the database properly. Not only to understand the focus a specific the country but also to understand which area holds the most data. The output of all functionalities is cut off in this README for illustration purposes.\n",
"\n",
"With `obtain_options` all possible options are given per column. This is useful as it doesn't require loading the larger data files. For example, obtaining all options for equities is done as follow:"
]
},
{
"cell_type": "code",
"execution_count": 3,
"id": "a8f1241b",
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"{'currency': array(['ARS', 'AUD', 'BRL', 'CAD', 'CHF', 'CLP', 'CNY', 'COP', 'CZK',\n",
" 'DKK', 'EUR', 'GBP', 'HKD', 'HUF', 'IDR', 'ILA', 'ILS', 'INR',\n",
" 'ISK', 'JPY', 'KES', 'KRW', 'LKR', 'MXN', 'MYR', 'NOK', 'NZD',\n",
" 'PEN', 'PHP', 'PLN', 'QAR', 'RUB', 'SAR', 'SEK', 'SGD', 'THB',\n",
" 'TRY', 'TWD', 'USD', 'ZAR', 'ZAc'], dtype=object),\n",
" 'sector': array(['Communication Services', 'Consumer Discretionary',\n",
" 'Consumer Staples', 'Energy', 'Financials', 'Health Care',\n",
" 'Industrials', 'Information Technology', 'Materials',\n",
" 'Real Estate', 'Utilities'], dtype=object),\n",
" 'industry_group': array(['Automobiles & Components', 'Banks', 'Capital Goods',\n",
" 'Commercial & Professional Services',\n",
" 'Consumer Durables & Apparel', 'Consumer Services',\n",
" 'Diversified Financials', 'Energy', 'Food & Staples Retailing',\n",
" 'Food, Beverage & Tobacco', 'Health Care Equipment & Services',\n",
" 'Household & Personal Products', 'Insurance', 'Materials',\n",
" 'Media & Entertainment',\n",
" 'Pharmaceuticals, Biotechnology & Life Sciences', 'Real Estate',\n",
" 'Retailing', 'Semiconductors & Semiconductor Equipment',\n",
" 'Software & Services', 'Technology Hardware & Equipment',\n",
" 'Telecommunication Services', 'Transportation', 'Utilities'],\n",
" dtype=object),\n",
" 'industry': array(['Aerospace & Defense', 'Air Freight & Logistics', 'Airlines',\n",
" 'Auto Components', 'Automobiles', 'Banks', 'Beverages',\n",
" 'Biotechnology', 'Building Products', 'Capital Markets',\n",
" 'Chemicals', 'Commercial Services & Supplies',\n",
" 'Communications Equipment', 'Construction & Engineering',\n",
" 'Construction Materials', 'Consumer Finance', 'Distributors',\n",
" 'Diversified Consumer Services', 'Diversified Financial Services',\n",
" 'Diversified Telecommunication Services', 'Electric Utilities',\n",
" 'Electrical Equipment',\n",
" 'Electronic Equipment, Instruments & Components',\n",
" 'Energy Equipment & Services', 'Entertainment',\n",
" 'Equity Real Estate Investment Trusts (REITs)',\n",
" 'Food & Staples Retailing', 'Food Products', 'Gas Utilities',\n",
" 'Health Care Equipment & Supplies',\n",
" 'Health Care Providers & Services', 'Health Care Technology',\n",
" 'Hotels, Restaurants & Leisure', 'Household Durables',\n",
" 'Household Products', 'IT Services',\n",
" 'Independent Power and Renewable Electricity Producers',\n",
" 'Industrial Conglomerates', 'Insurance',\n",
" 'Interactive Media & Services',\n",
" 'Internet & Direct Marketing Retail', 'Machinery', 'Marine',\n",
" 'Media', 'Metals & Mining', 'Multi-Utilities',\n",
" 'Oil, Gas & Consumable Fuels', 'Paper & Forest Products',\n",
" 'Pharmaceuticals', 'Professional Services',\n",
" 'Real Estate Management & Development', 'Road & Rail',\n",
" 'Semiconductors & Semiconductor Equipment', 'Software',\n",
" 'Specialty Retail', 'Technology Hardware, Storage & Peripherals',\n",
" 'Textiles, Apparel & Luxury Goods', 'Thrifts & Mortgage Finance',\n",
" 'Tobacco', 'Trading Companies & Distributors',\n",
" 'Transportation Infrastructure', 'Water Utilities'], dtype=object),\n",
" 'exchange': array(['AMS', 'AQS', 'ASE', 'ASX', 'ATH', 'BER', 'BRU', 'BSE', 'BTS',\n",
" 'BUD', 'BUE', 'CAI', 'CCS', 'CNQ', 'CPH', 'CSE', 'DOH', 'DUS',\n",
" 'EBS', 'ENX', 'FKA', 'FRA', 'GER', 'HAM', 'HAN', 'HEL', 'HKG',\n",
" 'ICE', 'IOB', 'ISE', 'IST', 'JKT', 'JNB', 'JPX', 'KLS', 'KOE',\n",
" 'KSC', 'LIS', 'LIT', 'LSE', 'MCE', 'MCX', 'MEX', 'MIL', 'MUN',\n",
" 'NAE', 'NAS', 'NCM', 'NEO', 'NGM', 'NMS', 'NSE', 'NSI', 'NYQ',\n",
" 'NYS', 'NZE', 'OBB', 'OSL', 'PAR', 'PCX', 'PNK', 'PRA', 'RIS',\n",
" 'SAO', 'SAP', 'SAT', 'SAU', 'SES', 'SET', 'SGO', 'SHH', 'SHZ',\n",
" 'STO', 'STU', 'TAI', 'TAL', 'TLO', 'TLV', 'TOR', 'TWO', 'VAN',\n",
" 'VIE'], dtype=object),\n",
" 'market': array(['Aequitas NEO Exchange (Lit Book)', 'Aktie Torget',\n",
" 'Aquis Exchange', 'Athens Stock Exchange',\n",
" 'Australian Securities Exchange', 'BATS BZX Exchange', 'BSE India',\n",
" 'BX Worldcaps', 'Berlin Stock Exchange',\n",
" 'Bolsa De Valores De Caracas',\n",
" 'Bolsa de Comercio de Santiago de Chile', 'Borsa Istanbul',\n",
" 'Borsa Italiana', 'Bovespa Soma', 'Budapest Stock Exchange',\n",
" 'Buenos Aires Mercato De Valores', 'Bursa Malaysia',\n",
" 'Canadian Securities Exchange', 'Dusseldorf Stock Exchange',\n",
" 'Egyptian Exchange', 'EuroTLX', 'Euronext', 'Euronext Amsterdam',\n",
" 'Euronext Brussels', 'Euronext Lisbon', 'Euronext Paris',\n",
" 'First North Copenhagen', 'First North Iceland',\n",
" 'Frankfurt Stock Exchange', 'Fukuoka Stock Exchange',\n",
" 'Hamburg Stock Exchange', 'Hanover Stock Exchange',\n",
" 'Hong Kong Stock Exchange', 'Indonesia Stock Exchange',\n",
" 'Irish Stock Exchange', 'Johannesburg Stock Exchange', 'KONEX',\n",
" 'KOSPI Stock Market', 'London Stock Exchange (OTC and ITR)',\n",
" 'London Stock Exchange (international)',\n",
" 'Metropolitan Stock Exchange', 'Mexico Stock Exchange',\n",
" 'Moscow Exchange - MICEX', 'Munich Stock Exchange',\n",
" 'NASDAQ Capital Market', 'NASDAQ Global Select',\n",
" 'NASDAQ OMX Helsinki', 'NASDAQ OMX Riga', 'NASDAQ OMX Stockholm',\n",
" 'NASDAQ OMX Tallinn', 'NASDAQ OMX Vilnius', 'NYSE Arca',\n",
" 'NYSE MKT', 'Nasdaq Copenhagen',\n",
" 'National Stock Exchange of India', 'New York Stock Exchange',\n",
" 'New Zealand Exchange', 'Nordic Growth Market',\n",
" 'OTC Bulletin Board', 'Oslo Bors', 'Prague Stock Exchange',\n",
" 'Qatar Exchange', 'Sapporo Securities Exchange',\n",
" 'Saudi Arabian Stock Exchange', 'Shanghai Stock Exchange',\n",
" 'Shenzhen Stock Exchange', 'Singapore Exchange',\n",
" 'Sociedad de Bolsas (SIBE)', 'Stuttgart Stock Exchange',\n",
" 'TSX Toronto Exchange', 'TSX Venture Exchange',\n",
" 'Taiwan Stock Exchange', 'Tel Aviv Stock Exchange',\n",
" 'The Stock Exchange of Thailand', 'Tokyo Stock Exchange',\n",
" 'Vienna Stock Exchange', 'XETRA', 'us24_market', 'us_market'],\n",
" dtype=object),\n",
" 'country': array(['Afghanistan', 'Anguilla', 'Argentina', 'Australia', 'Austria',\n",
" 'Azerbaijan', 'Bahamas', 'Bangladesh', 'Barbados', 'Belgium',\n",
" 'Belize', 'Bermuda', 'Botswana', 'Brazil',\n",
" 'British Virgin Islands', 'Cambodia', 'Canada', 'Cayman Islands',\n",
" 'Chile', 'China', 'Colombia', 'Costa Rica', 'Cyprus',\n",
" 'Czech Republic', 'Denmark', 'Dominican Republic', 'Egypt',\n",
" 'Estonia', 'Falkland Islands', 'Finland', 'France',\n",
" 'French Guiana', 'Gabon', 'Georgia', 'Germany', 'Ghana',\n",
" 'Gibraltar', 'Greece', 'Greenland', 'Guernsey', 'Hong Kong',\n",
" 'Hungary', 'Iceland', 'India', 'Indonesia', 'Ireland',\n",
" 'Isle of Man', 'Israel', 'Italy', 'Ivory Coast', 'Japan', 'Jersey',\n",
" 'Jordan', 'Kazakhstan', 'Kenya', 'Kyrgyzstan', 'Latvia',\n",
" 'Liechtenstein', 'Lithuania', 'Luxembourg', 'Macau', 'Macedonia',\n",
" 'Malaysia', 'Malta', 'Mauritius', 'Mexico', 'Monaco', 'Mongolia',\n",
" 'Montenegro', 'Morocco', 'Mozambique', 'Myanmar', 'Namibia',\n",
" 'Netherlands', 'Netherlands Antilles', 'New Zealand', 'Nigeria',\n",
" 'Norway', 'Panama', 'Papua New Guinea', 'Peru', 'Philippines',\n",
" 'Poland', 'Portugal', 'Qatar', 'Reunion', 'Romania', 'Russia',\n",
" 'Saudi Arabia', 'Senegal', 'Singapore', 'Slovakia', 'Slovenia',\n",
" 'South Africa', 'South Korea', 'Spain', 'Suriname', 'Sweden',\n",
" 'Switzerland', 'Taiwan', 'Tanzania', 'Thailand', 'Turkey',\n",
" 'Ukraine', 'United Arab Emirates', 'United Kingdom',\n",
" 'United States', 'Uruguay', 'Vietnam', 'Zambia'], dtype=object),\n",
" 'state': array(['AB', 'ACT', 'AK', 'AL', 'AM', 'AN', 'AP', 'AR', 'AV', 'AZ', 'BA',\n",
" 'BC', 'BG', 'BI', 'BJ', 'BL', 'BO', 'BS', 'CA', 'CE', 'CI', 'CO',\n",
" 'CT', 'CU', 'DC', 'DE', 'DF', 'EM', 'ES', 'FE', 'FI', 'FL', 'FO',\n",
" 'FR', 'GA', 'GE', 'GJ', 'GO', 'GU', 'HI', 'IA', 'ID', 'IL', 'IN',\n",
" 'JA', 'KS', 'KY', 'LA', 'LC', 'LT', 'LU', 'MA', 'MB', 'MD', 'ME',\n",
" 'MG', 'MH', 'MI', 'MN', 'MO', 'MS', 'MT', 'NB', 'NC', 'ND', 'NE',\n",
" 'NF', 'NH', 'NJ', 'NL', 'NM', 'NS', 'NSW', 'NT', 'NU', 'NV', 'NY',\n",
" 'OH', 'OK', 'ON', 'OR', 'PA', 'PD', 'PE', 'PG', 'PI', 'PR', 'PS',\n",
" 'PV', 'QC', 'QLD', 'QR', 'RA', 'RE', 'RI', 'RJ', 'RM', 'RN', 'RS',\n",
" 'SA', 'SC', 'SD', 'SE', 'SI', 'SK', 'SO', 'SP', 'TAS', 'TN', 'TO',\n",
" 'TR', 'TS', 'TV', 'TX', 'UD', 'UT', 'VA', 'VC', 'VE', 'VI', 'VIC',\n",
" 'VR', 'VT', 'WA', 'WI', 'WV', 'WY', 'YT'], dtype=object),\n",
" 'city': array([\"'s-Hertogenbosch\", '6th of October', 'Aabenraa', ...,\n",
" 'a€˜s-Hertogenbosch', 'tacheng', 'Ílhavo'], dtype=object),\n",
" 'zipcode': array(['00-105', '00-116', '00-124', ..., 'YO8 8PH', 'Z05T1X3', 'v4B 3L1'],\n",
" dtype=object),\n",
" 'market_cap': array(['Large Cap', 'Mega Cap', 'Micro Cap', 'Mid Cap', 'Nano Cap',\n",
" 'Small Cap'], dtype=object),\n",
" 'isin': array(['AN8068571086', 'ANN4327C1220', 'AT000000STR1', ...,\n",
" 'ZAE000265971', 'ZAE000296554', 'ZAE000298253'], dtype=object),\n",
" 'cusip': array(['00089H106', '00090Q103', '00108J109', ..., '99406100', '99501108',\n",
" '99502106'], dtype=object),\n",
" 'figi': array(['#REF!', 'BBG000B9XKF0', 'BBG000B9XZV9', ..., 'BBG01FC8CFV3',\n",
" 'BBG01FPC3G48', 'BBG01FRH5MP7'], dtype=object),\n",
" 'composite_figi': array(['BBG000B9WX45', 'BBG000B9XG87', 'BBG000B9XRY4', ...,\n",
" 'BBG01FC8CFN2', 'BBG01FP5R015', 'BBG01FRH5MK2'], dtype=object),\n",
" 'shareclass_figi': array(['BBG001S112S8', 'BBG001S112X2', 'BBG001S112Y1', ...,\n",
" 'BBG01CCBKDK1', 'BBG01FP5R033', 'BBG01FRH5ND8'], dtype=object)}"
]
},
"execution_count": 3,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"# Obtain all possible options for equities\n",
"fd.obtain_options(\"equities\")"
]
},
{
"attachments": {},
"cell_type": "markdown",
"id": "99032b0f",
"metadata": {},
"source": [
"Then, when initalising the equities dataset, the unique countries, sectors and industries of all equities in the database with any combination:"
]
},
{
"cell_type": "code",
"execution_count": 4,
"id": "735ec31b",
"metadata": {},
"outputs": [],
"source": [
"# Initialize the Equities database\n",
"equities = fd.Equities()"
]
},
{
"attachments": {},
"cell_type": "markdown",
"id": "6ae6fb1d",
"metadata": {},
"source": [
"For countries, you will find the following list if you print `equities_countries`"
]
},
{
"cell_type": "code",
"execution_count": 5,
"id": "d9b107df",
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"array(['Afghanistan', 'Anguilla', 'Argentina', 'Australia', 'Austria',\n",
" 'Azerbaijan', 'Bahamas', 'Bangladesh', 'Barbados', 'Belgium',\n",
" 'Belize', 'Bermuda', 'Botswana', 'Brazil',\n",
" 'British Virgin Islands', 'Cambodia', 'Canada', 'Cayman Islands',\n",
" 'Chile', 'China', 'Colombia', 'Costa Rica', 'Cyprus',\n",
" 'Czech Republic', 'Denmark', 'Dominican Republic', 'Egypt',\n",
" 'Estonia', 'Falkland Islands', 'Finland', 'France',\n",
" 'French Guiana', 'Gabon', 'Georgia', 'Germany', 'Ghana',\n",
" 'Gibraltar', 'Greece', 'Greenland', 'Guernsey', 'Hong Kong',\n",
" 'Hungary', 'Iceland', 'India', 'Indonesia', 'Ireland',\n",
" 'Isle of Man', 'Israel', 'Italy', 'Ivory Coast', 'Japan', 'Jersey',\n",
" 'Jordan', 'Kazakhstan', 'Kenya', 'Kyrgyzstan', 'Latvia',\n",
" 'Liechtenstein', 'Lithuania', 'Luxembourg', 'Macau', 'Macedonia',\n",
" 'Malaysia', 'Malta', 'Mauritius', 'Mexico', 'Monaco', 'Mongolia',\n",
" 'Montenegro', 'Morocco', 'Mozambique', 'Myanmar', 'Namibia',\n",
" 'Netherlands', 'Netherlands Antilles', 'New Zealand', 'Nigeria',\n",
" 'Norway', 'Panama', 'Papua New Guinea', 'Peru', 'Philippines',\n",
" 'Poland', 'Portugal', 'Qatar', 'Reunion', 'Romania', 'Russia',\n",
" 'Saudi Arabia', 'Senegal', 'Singapore', 'Slovakia', 'Slovenia',\n",
" 'South Africa', 'South Korea', 'Spain', 'Suriname', 'Sweden',\n",
" 'Switzerland', 'Taiwan', 'Tanzania', 'Thailand', 'Turkey',\n",
" 'Ukraine', 'United Arab Emirates', 'United Kingdom',\n",
" 'United States', 'Uruguay', 'Vietnam', 'Zambia'], dtype=object)"
]
},
"execution_count": 5,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"# Obtain all countries from the database\n",
"equities.options(\"country\")"
]
},
{
"attachments": {},
"cell_type": "markdown",
"id": "754b1ee6",
"metadata": {},
"source": [
"For sectors, you will find the following list if you print `equities_sectors`:"
]
},
{
"cell_type": "code",
"execution_count": 6,
"id": "f0e17359",
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"array(['Communication Services', 'Consumer Discretionary',\n",
" 'Consumer Staples', 'Energy', 'Financials', 'Health Care',\n",
" 'Industrials', 'Information Technology', 'Materials',\n",
" 'Real Estate', 'Utilities'], dtype=object)"
]
},
"execution_count": 6,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"# Obtain all sectors from the database\n",
"equities.options(\"sector\")"
]
},
{
"attachments": {},
"cell_type": "markdown",
"id": "0ab89b95",
"metadata": {},
"source": [
"For industry groups, you will find the following list if you print `equities_industry_groups`:"
]
},
{
"cell_type": "code",
"execution_count": 7,
"id": "e21194f5",
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"array(['Automobiles & Components', 'Banks', 'Capital Goods',\n",
" 'Commercial & Professional Services',\n",
" 'Consumer Durables & Apparel', 'Consumer Services',\n",
" 'Diversified Financials', 'Energy', 'Food & Staples Retailing',\n",
" 'Food, Beverage & Tobacco', 'Health Care Equipment & Services',\n",
" 'Household & Personal Products', 'Insurance', 'Materials',\n",
" 'Media & Entertainment',\n",
" 'Pharmaceuticals, Biotechnology & Life Sciences', 'Real Estate',\n",
" 'Retailing', 'Semiconductors & Semiconductor Equipment',\n",
" 'Software & Services', 'Technology Hardware & Equipment',\n",
" 'Telecommunication Services', 'Transportation', 'Utilities'],\n",
" dtype=object)"
]
},
"execution_count": 7,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"equities.options(\"industry_group\")"
]
},
{
"attachments": {},
"cell_type": "markdown",
"id": "a611d685",
"metadata": {},
"source": [
"For industries, you will find the following list if you print `equities_industries`:"
]
},
{
"cell_type": "code",
"execution_count": 8,
"id": "4fbfd4bf",
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"array(['Aerospace & Defense', 'Air Freight & Logistics', 'Airlines',\n",
" 'Auto Components', 'Automobiles', 'Banks', 'Beverages',\n",
" 'Biotechnology', 'Building Products', 'Capital Markets',\n",
" 'Chemicals', 'Commercial Services & Supplies',\n",
" 'Communications Equipment', 'Construction & Engineering',\n",
" 'Construction Materials', 'Consumer Finance', 'Distributors',\n",
" 'Diversified Consumer Services', 'Diversified Financial Services',\n",
" 'Diversified Telecommunication Services', 'Electric Utilities',\n",
" 'Electrical Equipment',\n",
" 'Electronic Equipment, Instruments & Components',\n",
" 'Energy Equipment & Services', 'Entertainment',\n",
" 'Equity Real Estate Investment Trusts (REITs)',\n",
" 'Food & Staples Retailing', 'Food Products', 'Gas Utilities',\n",
" 'Health Care Equipment & Supplies',\n",
" 'Health Care Providers & Services', 'Health Care Technology',\n",
" 'Hotels, Restaurants & Leisure', 'Household Durables',\n",
" 'Household Products', 'IT Services',\n",
" 'Independent Power and Renewable Electricity Producers',\n",
" 'Industrial Conglomerates', 'Insurance',\n",
" 'Interactive Media & Services',\n",
" 'Internet & Direct Marketing Retail', 'Machinery', 'Marine',\n",
" 'Media', 'Metals & Mining', 'Multi-Utilities',\n",
" 'Oil, Gas & Consumable Fuels', 'Paper & Forest Products',\n",
" 'Pharmaceuticals', 'Professional Services',\n",
" 'Real Estate Management & Development', 'Road & Rail',\n",
" 'Semiconductors & Semiconductor Equipment', 'Software',\n",
" 'Specialty Retail', 'Technology Hardware, Storage & Peripherals',\n",
" 'Textiles, Apparel & Luxury Goods', 'Thrifts & Mortgage Finance',\n",
" 'Tobacco', 'Trading Companies & Distributors',\n",
" 'Transportation Infrastructure', 'Water Utilities'], dtype=object)"
]
},
"execution_count": 8,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"# Obtain all industries from the database\n",
"equities.options(\"industry\")"
]
},
{
"attachments": {},
"cell_type": "markdown",
"id": "e568759c",
"metadata": {},
"source": [
"When you wish to get country, sector or industry specific lists, you can use the related `country`, `sector` and `industry` tags as also found in the help window with `help(equities.options)`"
]
},
{
"cell_type": "code",
"execution_count": 9,
"id": "b532c8b0",
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"Help on method options in module financedatabase.Equities:\n",
"\n",
"options(selection: str, country: str = '', sector: str = '', industry_group: str = '', industry: str = '') -> pandas.core.series.Series method of financedatabase.Equities.Equities instance\n",
" Retrieve all options for the specified selection.\n",
" \n",
" This method returns a series containing all available options for the specified\n",
" selection, which can be one of the following: \"currency\", \"sector\", \"industry_group\",\n",
" \"industry\", \"exchange\", \"market\", \"country\", \"state\", \"zip_code\", \"market_cap\".\n",
" \n",
" Args:\n",
" selection (str):\n",
" The selection you want to see the options for. Choose from:\n",
" - \"currency\"\n",
" - \"sector\"\n",
" - \"industry_group\"\n",
" - \"industry\"\n",
" - \"exchange\"\n",
" - \"market\"\n",
" - \"country\"\n",
" - \"state\"\n",
" - \"zip_code\"\n",
" - \"market_cap\"\n",
" country (str, optional):\n",
" Specific country to retrieve data for. If not provided, returns data for all countries.\n",
" sector (str, optional):\n",
" Specific sector to retrieve data for. If not provided, returns data for all sectors.\n",
" industry_group (str, optional):\n",
" Specific industry group to retrieve data for. If not provided, returns data for all industry groups.\n",
" industry (str, optional):\n",
" Specific industry to retrieve data for. If not provided, returns data for all industries.\n",
" \n",
" Returns:\n",
" pd.Series:\n",
" A series with all options for the specified selection, sorted and without duplicates.\n",
"\n"
]
}
],
"source": [
"help(equities.options)"
]
},
{
"attachments": {},
"cell_type": "markdown",
"id": "9b1a5303",
"metadata": {},
"source": [
"For example, if I wish to know all available industries within the sector \"Basic Materials\" in the country United States I can use"
]
},
{
"cell_type": "code",
"execution_count": 10,
"id": "18a5f4db",
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"array(['Chemicals', 'Construction Materials', 'Metals & Mining',\n",
" 'Paper & Forest Products'], dtype=object)"
]
},
"execution_count": 10,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"# Obtain a filtered selection of available industries\n",
"equities.options(selection=\"industry\", country=\"United States\", sector=\"Materials\")"
]
},
{
"attachments": {},
"cell_type": "markdown",
"id": "c8bec645",
"metadata": {},
"source": [
"This also extends further if you are looking into a different category. For example, find all available currencies by using "
]
},
{
"cell_type": "code",
"execution_count": 11,
"id": "c1e123ff",
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"array(['AED', 'AFN', 'ALL', 'AMD', 'ANG', 'AOA', 'ARS', 'AUD', 'AUS',\n",
" 'AUX', 'AWG', 'AZN', 'BAM', 'BBD', 'BDT', 'BGN', 'BHD', 'BIF',\n",
" 'BMD', 'BND', 'BOB', 'BRL', 'BSD', 'BTN', 'BWP', 'BYN', 'BZD',\n",
" 'CAD', 'CDF', 'CHF', 'CLF', 'CLP', 'CNH', 'CNY', 'COP', 'CRC',\n",
" 'CUC', 'CUP', 'CVE', 'CZK', 'DJF', 'DKK', 'DOP', 'DZD', 'EGP',\n",
" 'ERN', 'ETB', 'EUR', 'EUX', 'FJD', 'FKP', 'GBP', 'GEL', 'GHS',\n",
" 'GIP', 'GMD', 'GNF', 'GTQ', 'GYD', 'HKD', 'HNL', 'HRK', 'HTG',\n",
" 'HUF', 'IDR', 'ILS', 'INR', 'IQD', 'IRR', 'ISK', 'JMD', 'JOD',\n",
" 'JPY', 'KES', 'KGS', 'KHR', 'KMF', 'KRW', 'KWD', 'KYD', 'KZT',\n",
" 'LAK', 'LBP', 'LKR', 'LRD', 'LSL', 'LYD', 'MAD', 'MDL', 'MGA',\n",
" 'MKD', 'MMK', 'MNT', 'MOP', 'MRU', 'MUR', 'MVR', 'MWK', 'MXN',\n",
" 'MXV', 'MYR', 'MZN', 'NAD', 'NGN', 'NIO', 'NOK', 'NPR', 'NZD',\n",
" 'OMR', 'PAB', 'PEN', 'PGK', 'PHP', 'PKR', 'PLN', 'PYG', 'QAR',\n",
" 'RON', 'RSD', 'RUB', 'RWF', 'SAR', 'SBD', 'SCR', 'SDG', 'SEK',\n",
" 'SGD', 'SHP', 'SLL', 'SOS', 'SRD', 'SSP', 'STN', 'SVC', 'SYP',\n",
" 'SZL', 'THB', 'TJS', 'TMT', 'TND', 'TOP', 'TRY', 'TTD', 'TWD',\n",
" 'TZS', 'UAH', 'UGX', 'USD', 'USY', 'UYU', 'UZS', 'VES', 'VND',\n",
" 'VUV', 'WST', 'XAF', 'XCD', 'XCU', 'XDR', 'XOF', 'XPF', 'YER',\n",
" 'ZAR', 'ZMW'], dtype=object)"
]
},
"execution_count": 11,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"# Initialize the Currencies database\n",
"currencies = fd.Currencies()\n",
"\n",
"# Obtain all available currencies\n",
"currencies.options(selection=\"base_currency\")"
]
},
{
"attachments": {},
"cell_type": "markdown",
"id": "b0fd3392",
"metadata": {},
"source": [
"But also when it comes to `etfs` with"
]
},
{
"cell_type": "code",
"execution_count": 12,
"id": "4f882c16",
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"array(['Alternative', 'Bonds', 'Commodities Broad Basket',\n",
" 'Communications', 'Consumer Discretionary', 'Consumer Staples',\n",
" 'Currencies', 'Derivatives', 'Developed Markets',\n",
" 'Emerging Markets', 'Energy', 'Equities', 'Factors', 'Financials',\n",
" 'Health Care', 'Industrials', 'Materials', 'Real Estate',\n",
" 'Technology', 'Trading', 'Utilities'], dtype=object)"
]
},
"execution_count": 12,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"# Initialize the ETFs database\n",
"etfs = fd.ETFs()\n",
"\n",
"# Obtain all availables categories\n",
"etfs.options(selection=\"category\")"
]
},
{
"attachments": {},
"cell_type": "markdown",
"id": "3048a2f2",
"metadata": {},
"source": [
"# Collecting information from the database"
]
},
{
"attachments": {},
"cell_type": "markdown",
"id": "872918b0",
"metadata": {},
"source": [
"## Equities"
]
},
{
"attachments": {},
"cell_type": "markdown",
"id": "da9376fe",
"metadata": {},
"source": [
"If you wish to collect data from all equities you can use the following:"
]
},
{
"cell_type": "code",
"execution_count": 13,
"id": "52141713",
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"
\n",
"\n",
"
\n",
" \n",
" \n",
" | \n",
" name | \n",
" summary | \n",
" currency | \n",
" sector | \n",
" industry_group | \n",
" industry | \n",
" exchange | \n",
" market | \n",
" country | \n",
" state | \n",
" city | \n",
" zipcode | \n",
" website | \n",
" market_cap | \n",
" isin | \n",
" cusip | \n",
" figi | \n",
" composite_figi | \n",
" shareclass_figi | \n",
"
\n",
" \n",
" symbol | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
"
\n",
" \n",
" \n",
" \n",
" A | \n",
" Agilent Technologies, Inc. | \n",
" Agilent Technologies, Inc. provides applicatio... | \n",
" USD | \n",
" Health Care | \n",
" Pharmaceuticals, Biotechnology & Life Sciences | \n",
" Biotechnology | \n",
" NYQ | \n",
" New York Stock Exchange | \n",
" United States | \n",
" CA | \n",
" Santa Clara | \n",
" 95051 | \n",
" http://www.agilent.com | \n",
" Large Cap | \n",
" US00846U1016 | \n",
" 00846U101 | \n",
" BBG000C2V541 | \n",
" BBG000C2V3D6 | \n",
" BBG001SCTQY4 | \n",
"
\n",
" \n",
" AA | \n",
" Alcoa Corporation | \n",
" Alcoa Corporation, together with its subsidiar... | \n",
" USD | \n",
" Materials | \n",
" Materials | \n",
" Metals & Mining | \n",
" NYQ | \n",
" New York Stock Exchange | \n",
" United States | \n",
" PA | \n",
" Pittsburgh | \n",
" 15212-5858 | \n",
" http://www.alcoa.com | \n",
" Mid Cap | \n",
" US0138721065 | \n",
" 13872106 | \n",
" BBG00B3T3HK5 | \n",
" BBG00B3T3HD3 | \n",
" BBG00B3T3HF1 | \n",
"
\n",
" \n",
" AAALF | \n",
" Aareal Bank AG | \n",
" Aareal Bank AG, together with its subsidiaries... | \n",
" USD | \n",
" Financials | \n",
" Banks | \n",
" Banks | \n",
" PNK | \n",
" OTC Bulletin Board | \n",
" Germany | \n",
" NaN | \n",
" Wiesbaden | \n",
" 65189 | \n",
" http://www.aareal-bank.com | \n",
" Small Cap | \n",
" US00254K1088 | \n",
" 00254K108 | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
"
\n",
" \n",
" AAALY | \n",
" Aareal Bank AG | \n",
" Aareal Bank AG, together with its subsidiaries... | \n",
" USD | \n",
" Financials | \n",
" Banks | \n",
" Banks | \n",
" PNK | \n",
" OTC Bulletin Board | \n",
" Germany | \n",
" NaN | \n",
" Wiesbaden | \n",
" 65189 | \n",
" http://www.aareal-bank.com | \n",
" Small Cap | \n",
" US00254K1088 | \n",
" 00254K108 | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
"
\n",
" \n",
" AABB | \n",
" Asia Broadband, Inc. | \n",
" Asia Broadband Inc., through its subsidiary, A... | \n",
" USD | \n",
" Materials | \n",
" Materials | \n",
" Metals & Mining | \n",
" PNK | \n",
" OTC Bulletin Board | \n",
" United States | \n",
" NV | \n",
" Las Vegas | \n",
" 89135 | \n",
" http://www.asiabroadbandinc.com | \n",
" Micro Cap | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
"
\n",
" \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
"
\n",
" \n",
" NaN | \n",
" Nano Labs Ltd American Depositary Shares | \n",
" NaN | \n",
" USD | \n",
" Information Technology | \n",
" Semiconductors & Semiconductor Equipment | \n",
" Semiconductors & Semiconductor Equipment | \n",
" NMS | \n",
" NASDAQ Global Select | \n",
" China | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" Nano Cap | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
"
\n",
" \n",
" NaN | \n",
" Nano Labs Ltd American Depositary Shares | \n",
" NaN | \n",
" USD | \n",
" Information Technology | \n",
" Semiconductors & Semiconductor Equipment | \n",
" Semiconductors & Semiconductor Equipment | \n",
" NMS | \n",
" NASDAQ Global Select | \n",
" China | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" Micro Cap | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
"
\n",
" \n",
" NaN | \n",
" Nano Labs Ltd American Depositary Shares | \n",
" NaN | \n",
" USD | \n",
" Information Technology | \n",
" Semiconductors & Semiconductor Equipment | \n",
" Semiconductors & Semiconductor Equipment | \n",
" NMS | \n",
" NASDAQ Global Select | \n",
" China | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" Nano Cap | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
"
\n",
" \n",
" NaN | \n",
" Nano Labs Ltd American Depositary Shares | \n",
" NaN | \n",
" USD | \n",
" Information Technology | \n",
" Semiconductors & Semiconductor Equipment | \n",
" Semiconductors & Semiconductor Equipment | \n",
" NMS | \n",
" NASDAQ Global Select | \n",
" China | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" Nano Cap | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
"
\n",
" \n",
" NaN | \n",
" Nano Labs Ltd American Depositary Shares | \n",
" NaN | \n",
" USD | \n",
" Information Technology | \n",
" Semiconductors & Semiconductor Equipment | \n",
" Semiconductors & Semiconductor Equipment | \n",
" NMS | \n",
" NASDAQ Global Select | \n",
" China | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" Nano Cap | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
"
\n",
" \n",
"
\n",
"
23198 rows × 19 columns
\n",
"
"
],
"text/plain": [
" name \\\n",
"symbol \n",
"A Agilent Technologies, Inc. \n",
"AA Alcoa Corporation \n",
"AAALF Aareal Bank AG \n",
"AAALY Aareal Bank AG \n",
"AABB Asia Broadband, Inc. \n",
"... ... \n",
"NaN Nano Labs Ltd American Depositary Shares \n",
"NaN Nano Labs Ltd American Depositary Shares \n",
"NaN Nano Labs Ltd American Depositary Shares \n",
"NaN Nano Labs Ltd American Depositary Shares \n",
"NaN Nano Labs Ltd American Depositary Shares \n",
"\n",
" summary currency \\\n",
"symbol \n",
"A Agilent Technologies, Inc. provides applicatio... USD \n",
"AA Alcoa Corporation, together with its subsidiar... USD \n",
"AAALF Aareal Bank AG, together with its subsidiaries... USD \n",
"AAALY Aareal Bank AG, together with its subsidiaries... USD \n",
"AABB Asia Broadband Inc., through its subsidiary, A... USD \n",
"... ... ... \n",
"NaN NaN USD \n",
"NaN NaN USD \n",
"NaN NaN USD \n",
"NaN NaN USD \n",
"NaN NaN USD \n",
"\n",
" sector \\\n",
"symbol \n",
"A Health Care \n",
"AA Materials \n",
"AAALF Financials \n",
"AAALY Financials \n",
"AABB Materials \n",
"... ... \n",
"NaN Information Technology \n",
"NaN Information Technology \n",
"NaN Information Technology \n",
"NaN Information Technology \n",
"NaN Information Technology \n",
"\n",
" industry_group \\\n",
"symbol \n",
"A Pharmaceuticals, Biotechnology & Life Sciences \n",
"AA Materials \n",
"AAALF Banks \n",
"AAALY Banks \n",
"AABB Materials \n",
"... ... \n",
"NaN Semiconductors & Semiconductor Equipment \n",
"NaN Semiconductors & Semiconductor Equipment \n",
"NaN Semiconductors & Semiconductor Equipment \n",
"NaN Semiconductors & Semiconductor Equipment \n",
"NaN Semiconductors & Semiconductor Equipment \n",
"\n",
" industry exchange \\\n",
"symbol \n",
"A Biotechnology NYQ \n",
"AA Metals & Mining NYQ \n",
"AAALF Banks PNK \n",
"AAALY Banks PNK \n",
"AABB Metals & Mining PNK \n",
"... ... ... \n",
"NaN Semiconductors & Semiconductor Equipment NMS \n",
"NaN Semiconductors & Semiconductor Equipment NMS \n",
"NaN Semiconductors & Semiconductor Equipment NMS \n",
"NaN Semiconductors & Semiconductor Equipment NMS \n",
"NaN Semiconductors & Semiconductor Equipment NMS \n",
"\n",
" market country state city zipcode \\\n",
"symbol \n",
"A New York Stock Exchange United States CA Santa Clara 95051 \n",
"AA New York Stock Exchange United States PA Pittsburgh 15212-5858 \n",
"AAALF OTC Bulletin Board Germany NaN Wiesbaden 65189 \n",
"AAALY OTC Bulletin Board Germany NaN Wiesbaden 65189 \n",
"AABB OTC Bulletin Board United States NV Las Vegas 89135 \n",
"... ... ... ... ... ... \n",
"NaN NASDAQ Global Select China NaN NaN NaN \n",
"NaN NASDAQ Global Select China NaN NaN NaN \n",
"NaN NASDAQ Global Select China NaN NaN NaN \n",
"NaN NASDAQ Global Select China NaN NaN NaN \n",
"NaN NASDAQ Global Select China NaN NaN NaN \n",
"\n",
" website market_cap isin cusip \\\n",
"symbol \n",
"A http://www.agilent.com Large Cap US00846U1016 00846U101 \n",
"AA http://www.alcoa.com Mid Cap US0138721065 13872106 \n",
"AAALF http://www.aareal-bank.com Small Cap US00254K1088 00254K108 \n",
"AAALY http://www.aareal-bank.com Small Cap US00254K1088 00254K108 \n",
"AABB http://www.asiabroadbandinc.com Micro Cap NaN NaN \n",
"... ... ... ... ... \n",
"NaN NaN Nano Cap NaN NaN \n",
"NaN NaN Micro Cap NaN NaN \n",
"NaN NaN Nano Cap NaN NaN \n",
"NaN NaN Nano Cap NaN NaN \n",
"NaN NaN Nano Cap NaN NaN \n",
"\n",
" figi composite_figi shareclass_figi \n",
"symbol \n",
"A BBG000C2V541 BBG000C2V3D6 BBG001SCTQY4 \n",
"AA BBG00B3T3HK5 BBG00B3T3HD3 BBG00B3T3HF1 \n",
"AAALF NaN NaN NaN \n",
"AAALY NaN NaN NaN \n",
"AABB NaN NaN NaN \n",
"... ... ... ... \n",
"NaN NaN NaN NaN \n",
"NaN NaN NaN NaN \n",
"NaN NaN NaN NaN \n",
"NaN NaN NaN NaN \n",
"NaN NaN NaN NaN \n",
"\n",
"[23198 rows x 19 columns]"
]
},
"execution_count": 13,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"equities = fd.Equities()\n",
"\n",
"equities.select()"
]
},
{
"attachments": {},
"cell_type": "markdown",
"id": "bb45507c",
"metadata": {},
"source": [
"This returns approximately 20.000 different equities. Note that by default, only the American exchanges are selected. These are symbols like `TSLA` (Tesla) and `MSFT` (Microsoft) that tend to be recognized by a majority of data providers and therefore is the default. To disable this, you can set the `exclude_exchanges` argument to `False` which then results in approximately 155.000 different symbols. Find a more elaborate explanation with `help(equities.select)`:"
]
},
{
"cell_type": "code",
"execution_count": 14,
"id": "15e46b81",
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"Help on method select in module financedatabase.Equities:\n",
"\n",
"select(country: str = '', sector: str = '', industry_group: str = '', industry: str = '', exclude_exchanges: bool = True, capitalize: bool = True) -> pandas.core.frame.DataFrame method of financedatabase.Equities.Equities instance\n",
" Retrieve equity data based on specified criteria.\n",
" \n",
" This method allows you to retrieve data for specific equities based on a combination\n",
" of country, sector, industry group, and industry filters. You can also exclude\n",
" exchanges from the search. If no input criteria are provided, it returns data for all equities.\n",
" \n",
" Args:\n",
" country (str, optional):\n",
" Specific country to retrieve data for. If not provided, returns data for all countries.\n",
" sector (str, optional):\n",
" Specific sector to retrieve data for. If not provided, returns data for all sectors.\n",
" industry_group (str, optional):\n",
" Specific industry group to retrieve data for. If not provided, returns data for all industry groups.\n",
" industry (str, optional):\n",
" Specific industry to retrieve data for. If not provided, returns data for all industries.\n",
" exclude_exchanges (bool, optional):\n",
" Whether to exclude exchanges from the search. If False, you will receive\n",
" data for equities from different exchanges. Default is True.\n",
" capitalize (bool, optional):\n",
" Indicates whether country, sector, and industry names should be capitalized for matching.\n",
" Default is True.\n",
" \n",
" Returns:\n",
" pd.DataFrame:\n",
" A DataFrame containing equity data matching the specified input criteria.\n",
"\n"
]
}
],
"source": [
"help(equities.select)"
]
},
{
"attachments": {},
"cell_type": "markdown",
"id": "39bb5bc2",
"metadata": {},
"source": [
"As an example, in [Understanding the available options](#understanding-the-available-options), we've used `equities.options(selection='industry', country=\"United States\", sector=\"Materials\")` which allowed us to look at a specific industry in the United States. So with this information in hand, I can now query the industry `Metals & Mining` as follows:\n"
]
},
{
"cell_type": "code",
"execution_count": 15,
"id": "ec271fe9",
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"\n",
"\n",
"
\n",
" \n",
" \n",
" | \n",
" name | \n",
" summary | \n",
" currency | \n",
" sector | \n",
" industry_group | \n",
" industry | \n",
" exchange | \n",
" market | \n",
" country | \n",
" state | \n",
" city | \n",
" zipcode | \n",
" website | \n",
" market_cap | \n",
" isin | \n",
" cusip | \n",
" figi | \n",
" composite_figi | \n",
" shareclass_figi | \n",
"
\n",
" \n",
" symbol | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
"
\n",
" \n",
" \n",
" \n",
" CLF | \n",
" Cleveland-Cliffs Inc. | \n",
" Cleveland-Cliffs Inc. operates as an independe... | \n",
" USD | \n",
" Materials | \n",
" Materials | \n",
" Metals & Mining | \n",
" NYQ | \n",
" New York Stock Exchange | \n",
" United States | \n",
" OH | \n",
" Cleveland | \n",
" 44114-2315 | \n",
" http://www.clevelandcliffs.com | \n",
" Large Cap | \n",
" US1858991011 | \n",
" 185899101 | \n",
" BBG000BFRH97 | \n",
" BBG000BFRF55 | \n",
" BBG001S5PW43 | \n",
"
\n",
" \n",
" FCX | \n",
" Freeport-McMoRan Inc. | \n",
" Freeport-McMoRan Inc. engages in the mining of... | \n",
" USD | \n",
" Materials | \n",
" Materials | \n",
" Metals & Mining | \n",
" NYQ | \n",
" New York Stock Exchange | \n",
" United States | \n",
" AZ | \n",
" Phoenix | \n",
" 85004-2189 | \n",
" http://fcx.com | \n",
" Large Cap | \n",
" US35671D8570 | \n",
" 35671D857 | \n",
" BBG000BJDCQ6 | \n",
" BBG000BJDB15 | \n",
" BBG001S5R3F3 | \n",
"
\n",
" \n",
" NEM | \n",
" Newmont Corporation | \n",
" Newmont Corporation engages in the production ... | \n",
" USD | \n",
" Materials | \n",
" Materials | \n",
" Metals & Mining | \n",
" NYQ | \n",
" New York Stock Exchange | \n",
" United States | \n",
" CO | \n",
" Denver | \n",
" 80237 | \n",
" http://www.newmont.com | \n",
" Large Cap | \n",
" US6516391066 | \n",
" 651639106 | \n",
" BBG000BPWYG4 | \n",
" BBG000BPWXK1 | \n",
" BBG001S5TKX3 | \n",
"
\n",
" \n",
" NUE | \n",
" Nucor Corporation | \n",
" Nucor Corporation manufactures and sells steel... | \n",
" USD | \n",
" Materials | \n",
" Materials | \n",
" Metals & Mining | \n",
" NYQ | \n",
" New York Stock Exchange | \n",
" United States | \n",
" NC | \n",
" Charlotte | \n",
" 28211 | \n",
" http://www.nucor.com | \n",
" Large Cap | \n",
" US6703461052 | \n",
" 670346105 | \n",
" BBG000BQ8MY5 | \n",
" BBG000BQ8KV2 | \n",
" BBG001S5TRV0 | \n",
"
\n",
" \n",
" RS | \n",
" Reliance Steel & Aluminum Co. | \n",
" Reliance Steel & Aluminum Co. operates as a me... | \n",
" USD | \n",
" Materials | \n",
" Materials | \n",
" Metals & Mining | \n",
" NYQ | \n",
" New York Stock Exchange | \n",
" United States | \n",
" CA | \n",
" Los Angeles | \n",
" 90071 | \n",
" http://www.rsac.com | \n",
" Large Cap | \n",
" US7595091023 | \n",
" 759509102 | \n",
" BBG000CJ2332 | \n",
" BBG000CJ2181 | \n",
" BBG001S81M27 | \n",
"
\n",
" \n",
" SCCO | \n",
" Southern Copper Corporation | \n",
" Southern Copper Corporation engages in mining,... | \n",
" USD | \n",
" Materials | \n",
" Materials | \n",
" Metals & Mining | \n",
" NYQ | \n",
" New York Stock Exchange | \n",
" United States | \n",
" AZ | \n",
" Phoenix | \n",
" 85014 | \n",
" http://www.southerncoppercorp.com | \n",
" Large Cap | \n",
" US84265V1052 | \n",
" 84265V105 | \n",
" BBG000BSHKK0 | \n",
" BBG000BSHH72 | \n",
" BBG001S6ZM88 | \n",
"
\n",
" \n",
" STLD | \n",
" Steel Dynamics, Inc. | \n",
" Steel Dynamics, Inc., together with its subsid... | \n",
" USD | \n",
" Materials | \n",
" Materials | \n",
" Metals & Mining | \n",
" NMS | \n",
" NASDAQ Global Select | \n",
" United States | \n",
" IN | \n",
" Fort Wayne | \n",
" 46804 | \n",
" http://www.steeldynamics.com | \n",
" Large Cap | \n",
" US8581191009 | \n",
" 858119100 | \n",
" BBG000HH03N1 | \n",
" BBG000HGYNZ9 | \n",
" BBG001S98JK5 | \n",
"
\n",
" \n",
" X | \n",
" United States Steel Corporation | \n",
" United States Steel Corporation produces and s... | \n",
" USD | \n",
" Materials | \n",
" Materials | \n",
" Metals & Mining | \n",
" NYQ | \n",
" New York Stock Exchange | \n",
" United States | \n",
" PA | \n",
" Pittsburgh | \n",
" 15219-2800 | \n",
" http://www.ussteel.com | \n",
" Large Cap | \n",
" US9129091081 | \n",
" 912909108 | \n",
" BBG000BX3W91 | \n",
" BBG000BX3TD3 | \n",
" BBG001S5XL75 | \n",
"
\n",
" \n",
"
\n",
"
"
],
"text/plain": [
" name \\\n",
"symbol \n",
"CLF Cleveland-Cliffs Inc. \n",
"FCX Freeport-McMoRan Inc. \n",
"NEM Newmont Corporation \n",
"NUE Nucor Corporation \n",
"RS Reliance Steel & Aluminum Co. \n",
"SCCO Southern Copper Corporation \n",
"STLD Steel Dynamics, Inc. \n",
"X United States Steel Corporation \n",
"\n",
" summary currency sector \\\n",
"symbol \n",
"CLF Cleveland-Cliffs Inc. operates as an independe... USD Materials \n",
"FCX Freeport-McMoRan Inc. engages in the mining of... USD Materials \n",
"NEM Newmont Corporation engages in the production ... USD Materials \n",
"NUE Nucor Corporation manufactures and sells steel... USD Materials \n",
"RS Reliance Steel & Aluminum Co. operates as a me... USD Materials \n",
"SCCO Southern Copper Corporation engages in mining,... USD Materials \n",
"STLD Steel Dynamics, Inc., together with its subsid... USD Materials \n",
"X United States Steel Corporation produces and s... USD Materials \n",
"\n",
" industry_group industry exchange market \\\n",
"symbol \n",
"CLF Materials Metals & Mining NYQ New York Stock Exchange \n",
"FCX Materials Metals & Mining NYQ New York Stock Exchange \n",
"NEM Materials Metals & Mining NYQ New York Stock Exchange \n",
"NUE Materials Metals & Mining NYQ New York Stock Exchange \n",
"RS Materials Metals & Mining NYQ New York Stock Exchange \n",
"SCCO Materials Metals & Mining NYQ New York Stock Exchange \n",
"STLD Materials Metals & Mining NMS NASDAQ Global Select \n",
"X Materials Metals & Mining NYQ New York Stock Exchange \n",
"\n",
" country state city zipcode \\\n",
"symbol \n",
"CLF United States OH Cleveland 44114-2315 \n",
"FCX United States AZ Phoenix 85004-2189 \n",
"NEM United States CO Denver 80237 \n",
"NUE United States NC Charlotte 28211 \n",
"RS United States CA Los Angeles 90071 \n",
"SCCO United States AZ Phoenix 85014 \n",
"STLD United States IN Fort Wayne 46804 \n",
"X United States PA Pittsburgh 15219-2800 \n",
"\n",
" website market_cap isin cusip \\\n",
"symbol \n",
"CLF http://www.clevelandcliffs.com Large Cap US1858991011 185899101 \n",
"FCX http://fcx.com Large Cap US35671D8570 35671D857 \n",
"NEM http://www.newmont.com Large Cap US6516391066 651639106 \n",
"NUE http://www.nucor.com Large Cap US6703461052 670346105 \n",
"RS http://www.rsac.com Large Cap US7595091023 759509102 \n",
"SCCO http://www.southerncoppercorp.com Large Cap US84265V1052 84265V105 \n",
"STLD http://www.steeldynamics.com Large Cap US8581191009 858119100 \n",
"X http://www.ussteel.com Large Cap US9129091081 912909108 \n",
"\n",
" figi composite_figi shareclass_figi \n",
"symbol \n",
"CLF BBG000BFRH97 BBG000BFRF55 BBG001S5PW43 \n",
"FCX BBG000BJDCQ6 BBG000BJDB15 BBG001S5R3F3 \n",
"NEM BBG000BPWYG4 BBG000BPWXK1 BBG001S5TKX3 \n",
"NUE BBG000BQ8MY5 BBG000BQ8KV2 BBG001S5TRV0 \n",
"RS BBG000CJ2332 BBG000CJ2181 BBG001S81M27 \n",
"SCCO BBG000BSHKK0 BBG000BSHH72 BBG001S6ZM88 \n",
"STLD BBG000HH03N1 BBG000HGYNZ9 BBG001S98JK5 \n",
"X BBG000BX3W91 BBG000BX3TD3 BBG001S5XL75 "
]
},
"execution_count": 15,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"metals_and_mining = equities.search(industry=\"Metals & Mining\", country=\"United States\", market_cap=\"Large Cap\", exclude_exchanges=True)\n",
"\n",
"metals_and_mining"
]
},
{
"cell_type": "markdown",
"id": "e8a507e4",
"metadata": {},
"source": [
"The companies found from the Finance Database can be used to feed into the Finance Toolkit. For example the companies as found above can be used to obtain the income statements of all companies in the Metals & Mining industry in the United States by using the `to_toolkit` functionality.\n",
"\n",
"Get an API key from Financial Modeling Prep **[here](https://site.financialmodelingprep.com/developer/docs/pricing/jeroen/)**. Note that the Free version only gets you 5 years of data and no quarterly statements but this link offers a 15% discount while also supporting the project."
]
},
{
"cell_type": "code",
"execution_count": 16,
"id": "56546c15",
"metadata": {},
"outputs": [
{
"name": "stderr",
"output_type": "stream",
"text": [
"Obtaining company profiles: 100%|██████████| 8/8 [00:00<00:00, 9.30it/s]\n"
]
},
{
"data": {
"text/html": [
"\n",
"\n",
"
\n",
" \n",
" \n",
" | \n",
" CLF | \n",
" FCX | \n",
" NEM | \n",
" NUE | \n",
" RS | \n",
" SCCO | \n",
" STLD | \n",
" X | \n",
"
\n",
" \n",
" \n",
" \n",
" Symbol | \n",
" CLF | \n",
" FCX | \n",
" NEM | \n",
" NUE | \n",
" RS | \n",
" SCCO | \n",
" STLD | \n",
" X | \n",
"
\n",
" \n",
" Price | \n",
" 19.53 | \n",
" 37.2 | \n",
" 32.12 | \n",
" 181.06 | \n",
" 294.65 | \n",
" 80.12 | \n",
" 119.74 | \n",
" 45.64 | \n",
"
\n",
" \n",
" Beta | \n",
" 2.027 | \n",
" 2.059 | \n",
" 0.526 | \n",
" 1.624 | \n",
" 0.862 | \n",
" 1.298 | \n",
" 1.409 | \n",
" 2.043 | \n",
"
\n",
" \n",
" Average Volume | \n",
" 9399009 | \n",
" 12314373 | \n",
" 11644590 | \n",
" 1547147 | \n",
" 235091 | \n",
" 1023808 | \n",
" 1313057 | \n",
" 6936880 | \n",
"
\n",
" \n",
" Market Capitalization | \n",
" 9731584170 | \n",
" 53344056000 | \n",
" 37017978800 | \n",
" 44511609340 | \n",
" 16933889080 | \n",
" 61941653320 | \n",
" 19375847840 | \n",
" 10211037200 | \n",
"
\n",
" \n",
" Last Dividend | \n",
" 0 | \n",
" 0.6000000000000001 | \n",
" 1.6 | \n",
" 2.16 | \n",
" 4 | \n",
" 3.2 | \n",
" 1.7000000000000002 | \n",
" 0.2 | \n",
"
\n",
" \n",
" Range | \n",
" 13.61-22.83 | \n",
" 32.83-44.7 | \n",
" 31.615-52.76 | \n",
" 129.79-190.96 | \n",
" 227.87-302.89 | \n",
" 64.66-88.4 | \n",
" 90.55-136.46 | \n",
" 20.4-50.2 | \n",
"
\n",
" \n",
" Changes | \n",
" 0.36 | \n",
" 0.54 | \n",
" 0.08 | \n",
" 1.58 | \n",
" 5.58 | \n",
" 2.09 | \n",
" 1.37 | \n",
" 0.04 | \n",
"
\n",
" \n",
" Company Name | \n",
" Cleveland-Cliffs Inc. | \n",
" Freeport-McMoRan Inc. | \n",
" Newmont Corporation | \n",
" Nucor Corporation | \n",
" Reliance Steel & Aluminum Co. | \n",
" Southern Copper Corporation | \n",
" Steel Dynamics, Inc. | \n",
" United States Steel Corporation | \n",
"
\n",
" \n",
" Currency | \n",
" USD | \n",
" USD | \n",
" USD | \n",
" USD | \n",
" USD | \n",
" USD | \n",
" USD | \n",
" USD | \n",
"
\n",
" \n",
" CIK | \n",
" 764065 | \n",
" 831259 | \n",
" 1164727 | \n",
" 73309 | \n",
" 861884 | \n",
" 1001838 | \n",
" 1022671 | \n",
" 1163302 | \n",
"
\n",
" \n",
" ISIN | \n",
" US1858991011 | \n",
" US35671D8570 | \n",
" US6516391066 | \n",
" US6703461052 | \n",
" US7595091023 | \n",
" US84265V1052 | \n",
" US8581191009 | \n",
" US9129091081 | \n",
"
\n",
" \n",
" CUSIP | \n",
" 185899101 | \n",
" 35671D857 | \n",
" 651639106 | \n",
" 670346105 | \n",
" 759509102 | \n",
" 84265V105 | \n",
" 858119100 | \n",
" 912909108 | \n",
"
\n",
" \n",
" Exchange | \n",
" New York Stock Exchange | \n",
" New York Stock Exchange | \n",
" New York Stock Exchange | \n",
" New York Stock Exchange | \n",
" New York Stock Exchange | \n",
" New York Stock Exchange | \n",
" NASDAQ Global Select | \n",
" New York Stock Exchange | \n",
"
\n",
" \n",
" Exchange Short Name | \n",
" NYSE | \n",
" NYSE | \n",
" NYSE | \n",
" NYSE | \n",
" NYSE | \n",
" NYSE | \n",
" NASDAQ | \n",
" NYSE | \n",
"
\n",
" \n",
" Industry | \n",
" Steel | \n",
" Copper | \n",
" Gold | \n",
" Steel | \n",
" Steel | \n",
" Copper | \n",
" Steel | \n",
" Steel | \n",
"
\n",
" \n",
" Website | \n",
" https://www.clevelandcliffs.com | \n",
" https://fcx.com | \n",
" https://www.newmont.com | \n",
" https://www.nucor.com | \n",
" https://www.rsac.com | \n",
" https://www.southernperu.com | \n",
" https://stld.steeldynamics.com | \n",
" https://www.ussteel.com | \n",
"
\n",
" \n",
" Description | \n",
" Cleveland-Cliffs Inc. operates as a flat-rolle... | \n",
" Freeport-McMoRan Inc. engages in the mining of... | \n",
" Newmont Corporation engages in the production ... | \n",
" Nucor Corporation manufactures and sells steel... | \n",
" Reliance Steel & Aluminum Co. operates as a di... | \n",
" Southern Copper Corporation engages in mining,... | \n",
" Steel Dynamics, Inc., together with its subsid... | \n",
" United States Steel Corporation produces and s... | \n",
"
\n",
" \n",
" CEO | \n",
" Mr. C. Lourenco Goncalves | \n",
" Mr. Richard C. Adkerson | \n",
" Mr. Thomas Ronald Palmer | \n",
" Mr. Leon J. Topalian | \n",
" Ms. Karla R. Lewis | \n",
" Mr. Oscar Gonzalez Rocha | \n",
" Mr. Mark D. Millett | \n",
" Mr. David Boyd Burritt | \n",
"
\n",
" \n",
" Sector | \n",
" Basic Materials | \n",
" Basic Materials | \n",
" Basic Materials | \n",
" Basic Materials | \n",
" Basic Materials | \n",
" Basic Materials | \n",
" Basic Materials | \n",
" Basic Materials | \n",
"
\n",
" \n",
" Country | \n",
" US | \n",
" US | \n",
" US | \n",
" US | \n",
" US | \n",
" US | \n",
" US | \n",
" US | \n",
"
\n",
" \n",
" Full Time Employees | \n",
" 28000 | \n",
" 25600 | \n",
" 14600 | \n",
" 31400 | \n",
" 14500 | \n",
" 15018 | \n",
" 12060 | \n",
" 21803 | \n",
"
\n",
" \n",
" Phone | \n",
" 216 694 5700 | \n",
" 602 366 8100 | \n",
" 303 863 7414 | \n",
" 704 366 7000 | \n",
" 213 687 7700 | \n",
" 602 264 1375 | \n",
" 260 969 3500 | \n",
" 412 433 1121 | \n",
"
\n",
" \n",
" Address | \n",
" 200 Public Square | \n",
" 333 North Central Avenue | \n",
" 6900 East Layton Avenue | \n",
" 1915 Rexford Road | \n",
" 350 South Grand Avenue | \n",
" 1440 East Missouri Avenue | \n",
" 7575 West Jefferson Boulevard | \n",
" 600 Grant Street | \n",
"
\n",
" \n",
" City | \n",
" Cleveland | \n",
" Phoenix | \n",
" Denver | \n",
" Charlotte | \n",
" Los Angeles | \n",
" Phoenix | \n",
" Fort Wayne | \n",
" Pittsburgh | \n",
"
\n",
" \n",
" State | \n",
" OH | \n",
" AZ | \n",
" CO | \n",
" NC | \n",
" CA | \n",
" AZ | \n",
" IN | \n",
" PA | \n",
"
\n",
" \n",
" ZIP Code | \n",
" 44114-2315 | \n",
" 85004-2189 | \n",
" 80237 | \n",
" 28211 | \n",
" 90071 | \n",
" 85014 | \n",
" 46804 | \n",
" 15219-2800 | \n",
"
\n",
" \n",
" DCF Difference | \n",
" 16.51996 | \n",
" 21.57819 | \n",
" -231.65902 | \n",
" -128.8227 | \n",
" 13.6802 | \n",
" 22.55334 | \n",
" -122.2899 | \n",
" 29.47643 | \n",
"
\n",
" \n",
" DCF | \n",
" 3.010037895253636 | \n",
" 15.621806675801688 | \n",
" 268.0290222054616 | \n",
" 304.1727004463441 | \n",
" 213.01 | \n",
" 57.566656979207266 | \n",
" 238.42990084781277 | \n",
" 16.16356712951636 | \n",
"
\n",
" \n",
" IPO Date | \n",
" 1987-11-05 | \n",
" 1995-07-10 | \n",
" 1980-03-17 | \n",
" 1980-03-17 | \n",
" 1994-09-16 | \n",
" 1996-01-05 | \n",
" 1996-11-22 | \n",
" 1991-04-12 | \n",
"
\n",
" \n",
"
\n",
"
"
],
"text/plain": [
" CLF \\\n",
"Symbol CLF \n",
"Price 19.53 \n",
"Beta 2.027 \n",
"Average Volume 9399009 \n",
"Market Capitalization 9731584170 \n",
"Last Dividend 0 \n",
"Range 13.61-22.83 \n",
"Changes 0.36 \n",
"Company Name Cleveland-Cliffs Inc. \n",
"Currency USD \n",
"CIK 764065 \n",
"ISIN US1858991011 \n",
"CUSIP 185899101 \n",
"Exchange New York Stock Exchange \n",
"Exchange Short Name NYSE \n",
"Industry Steel \n",
"Website https://www.clevelandcliffs.com \n",
"Description Cleveland-Cliffs Inc. operates as a flat-rolle... \n",
"CEO Mr. C. Lourenco Goncalves \n",
"Sector Basic Materials \n",
"Country US \n",
"Full Time Employees 28000 \n",
"Phone 216 694 5700 \n",
"Address 200 Public Square \n",
"City Cleveland \n",
"State OH \n",
"ZIP Code 44114-2315 \n",
"DCF Difference 16.51996 \n",
"DCF 3.010037895253636 \n",
"IPO Date 1987-11-05 \n",
"\n",
" FCX \\\n",
"Symbol FCX \n",
"Price 37.2 \n",
"Beta 2.059 \n",
"Average Volume 12314373 \n",
"Market Capitalization 53344056000 \n",
"Last Dividend 0.6000000000000001 \n",
"Range 32.83-44.7 \n",
"Changes 0.54 \n",
"Company Name Freeport-McMoRan Inc. \n",
"Currency USD \n",
"CIK 831259 \n",
"ISIN US35671D8570 \n",
"CUSIP 35671D857 \n",
"Exchange New York Stock Exchange \n",
"Exchange Short Name NYSE \n",
"Industry Copper \n",
"Website https://fcx.com \n",
"Description Freeport-McMoRan Inc. engages in the mining of... \n",
"CEO Mr. Richard C. Adkerson \n",
"Sector Basic Materials \n",
"Country US \n",
"Full Time Employees 25600 \n",
"Phone 602 366 8100 \n",
"Address 333 North Central Avenue \n",
"City Phoenix \n",
"State AZ \n",
"ZIP Code 85004-2189 \n",
"DCF Difference 21.57819 \n",
"DCF 15.621806675801688 \n",
"IPO Date 1995-07-10 \n",
"\n",
" NEM \\\n",
"Symbol NEM \n",
"Price 32.12 \n",
"Beta 0.526 \n",
"Average Volume 11644590 \n",
"Market Capitalization 37017978800 \n",
"Last Dividend 1.6 \n",
"Range 31.615-52.76 \n",
"Changes 0.08 \n",
"Company Name Newmont Corporation \n",
"Currency USD \n",
"CIK 1164727 \n",
"ISIN US6516391066 \n",
"CUSIP 651639106 \n",
"Exchange New York Stock Exchange \n",
"Exchange Short Name NYSE \n",
"Industry Gold \n",
"Website https://www.newmont.com \n",
"Description Newmont Corporation engages in the production ... \n",
"CEO Mr. Thomas Ronald Palmer \n",
"Sector Basic Materials \n",
"Country US \n",
"Full Time Employees 14600 \n",
"Phone 303 863 7414 \n",
"Address 6900 East Layton Avenue \n",
"City Denver \n",
"State CO \n",
"ZIP Code 80237 \n",
"DCF Difference -231.65902 \n",
"DCF 268.0290222054616 \n",
"IPO Date 1980-03-17 \n",
"\n",
" NUE \\\n",
"Symbol NUE \n",
"Price 181.06 \n",
"Beta 1.624 \n",
"Average Volume 1547147 \n",
"Market Capitalization 44511609340 \n",
"Last Dividend 2.16 \n",
"Range 129.79-190.96 \n",
"Changes 1.58 \n",
"Company Name Nucor Corporation \n",
"Currency USD \n",
"CIK 73309 \n",
"ISIN US6703461052 \n",
"CUSIP 670346105 \n",
"Exchange New York Stock Exchange \n",
"Exchange Short Name NYSE \n",
"Industry Steel \n",
"Website https://www.nucor.com \n",
"Description Nucor Corporation manufactures and sells steel... \n",
"CEO Mr. Leon J. Topalian \n",
"Sector Basic Materials \n",
"Country US \n",
"Full Time Employees 31400 \n",
"Phone 704 366 7000 \n",
"Address 1915 Rexford Road \n",
"City Charlotte \n",
"State NC \n",
"ZIP Code 28211 \n",
"DCF Difference -128.8227 \n",
"DCF 304.1727004463441 \n",
"IPO Date 1980-03-17 \n",
"\n",
" RS \\\n",
"Symbol RS \n",
"Price 294.65 \n",
"Beta 0.862 \n",
"Average Volume 235091 \n",
"Market Capitalization 16933889080 \n",
"Last Dividend 4 \n",
"Range 227.87-302.89 \n",
"Changes 5.58 \n",
"Company Name Reliance Steel & Aluminum Co. \n",
"Currency USD \n",
"CIK 861884 \n",
"ISIN US7595091023 \n",
"CUSIP 759509102 \n",
"Exchange New York Stock Exchange \n",
"Exchange Short Name NYSE \n",
"Industry Steel \n",
"Website https://www.rsac.com \n",
"Description Reliance Steel & Aluminum Co. operates as a di... \n",
"CEO Ms. Karla R. Lewis \n",
"Sector Basic Materials \n",
"Country US \n",
"Full Time Employees 14500 \n",
"Phone 213 687 7700 \n",
"Address 350 South Grand Avenue \n",
"City Los Angeles \n",
"State CA \n",
"ZIP Code 90071 \n",
"DCF Difference 13.6802 \n",
"DCF 213.01 \n",
"IPO Date 1994-09-16 \n",
"\n",
" SCCO \\\n",
"Symbol SCCO \n",
"Price 80.12 \n",
"Beta 1.298 \n",
"Average Volume 1023808 \n",
"Market Capitalization 61941653320 \n",
"Last Dividend 3.2 \n",
"Range 64.66-88.4 \n",
"Changes 2.09 \n",
"Company Name Southern Copper Corporation \n",
"Currency USD \n",
"CIK 1001838 \n",
"ISIN US84265V1052 \n",
"CUSIP 84265V105 \n",
"Exchange New York Stock Exchange \n",
"Exchange Short Name NYSE \n",
"Industry Copper \n",
"Website https://www.southernperu.com \n",
"Description Southern Copper Corporation engages in mining,... \n",
"CEO Mr. Oscar Gonzalez Rocha \n",
"Sector Basic Materials \n",
"Country US \n",
"Full Time Employees 15018 \n",
"Phone 602 264 1375 \n",
"Address 1440 East Missouri Avenue \n",
"City Phoenix \n",
"State AZ \n",
"ZIP Code 85014 \n",
"DCF Difference 22.55334 \n",
"DCF 57.566656979207266 \n",
"IPO Date 1996-01-05 \n",
"\n",
" STLD \\\n",
"Symbol STLD \n",
"Price 119.74 \n",
"Beta 1.409 \n",
"Average Volume 1313057 \n",
"Market Capitalization 19375847840 \n",
"Last Dividend 1.7000000000000002 \n",
"Range 90.55-136.46 \n",
"Changes 1.37 \n",
"Company Name Steel Dynamics, Inc. \n",
"Currency USD \n",
"CIK 1022671 \n",
"ISIN US8581191009 \n",
"CUSIP 858119100 \n",
"Exchange NASDAQ Global Select \n",
"Exchange Short Name NASDAQ \n",
"Industry Steel \n",
"Website https://stld.steeldynamics.com \n",
"Description Steel Dynamics, Inc., together with its subsid... \n",
"CEO Mr. Mark D. Millett \n",
"Sector Basic Materials \n",
"Country US \n",
"Full Time Employees 12060 \n",
"Phone 260 969 3500 \n",
"Address 7575 West Jefferson Boulevard \n",
"City Fort Wayne \n",
"State IN \n",
"ZIP Code 46804 \n",
"DCF Difference -122.2899 \n",
"DCF 238.42990084781277 \n",
"IPO Date 1996-11-22 \n",
"\n",
" X \n",
"Symbol X \n",
"Price 45.64 \n",
"Beta 2.043 \n",
"Average Volume 6936880 \n",
"Market Capitalization 10211037200 \n",
"Last Dividend 0.2 \n",
"Range 20.4-50.2 \n",
"Changes 0.04 \n",
"Company Name United States Steel Corporation \n",
"Currency USD \n",
"CIK 1163302 \n",
"ISIN US9129091081 \n",
"CUSIP 912909108 \n",
"Exchange New York Stock Exchange \n",
"Exchange Short Name NYSE \n",
"Industry Steel \n",
"Website https://www.ussteel.com \n",
"Description United States Steel Corporation produces and s... \n",
"CEO Mr. David Boyd Burritt \n",
"Sector Basic Materials \n",
"Country US \n",
"Full Time Employees 21803 \n",
"Phone 412 433 1121 \n",
"Address 600 Grant Street \n",
"City Pittsburgh \n",
"State PA \n",
"ZIP Code 15219-2800 \n",
"DCF Difference 29.47643 \n",
"DCF 16.16356712951636 \n",
"IPO Date 1991-04-12 "
]
},
"execution_count": 16,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"companies = metals_and_mining.to_toolkit(api_key=\"FINANCIAL_MODEL_PREP_KEY\", start_date=\"2000-01-01\", quarterly=False)\n",
"\n",
"companies.get_profile()"
]
},
{
"attachments": {},
"cell_type": "markdown",
"id": "35eaae54",
"metadata": {},
"source": [
"## ETFs"
]
},
{
"attachments": {},
"cell_type": "markdown",
"id": "e2b33328",
"metadata": {},
"source": [
"If you wish to collect data from all etfs you can use the following:"
]
},
{
"cell_type": "code",
"execution_count": 17,
"id": "9f3a15b7",
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"\n",
"\n",
"
\n",
" \n",
" \n",
" | \n",
" name | \n",
" currency | \n",
" summary | \n",
" category_group | \n",
" category | \n",
" family | \n",
" exchange | \n",
" market | \n",
"
\n",
" \n",
" symbol | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
"
\n",
" \n",
" \n",
" \n",
" ^ACWI | \n",
" ISHARES TRUST | \n",
" USD | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NIM | \n",
" us_market | \n",
"
\n",
" \n",
" ^ADFI-IV | \n",
" NFIELD DYNAMIC FIXED INCOME ETF | \n",
" USD | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" ASE | \n",
" us_market | \n",
"
\n",
" \n",
" ^ADRE | \n",
" INVESCO ACTIVELY M | \n",
" USD | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NIM | \n",
" us_market | \n",
"
\n",
" \n",
" ^ARB-EU | \n",
" ALTSHARES MERGER ARBITRAGE ETF | \n",
" USD | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" ASE | \n",
" us_market | \n",
"
\n",
" \n",
" ^ARB-IV | \n",
" ALTSHARES MERGER ARBITRAGE ETF | \n",
" USD | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" ASE | \n",
" us_market | \n",
"
\n",
" \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
"
\n",
" \n",
" VGFPF | \n",
" Vanguard Funds Public Limited Company - Vangua... | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
"
\n",
" \n",
" VFDEF | \n",
" Vanguard Funds Public Limited Company - Vangua... | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
"
\n",
" \n",
" WSDMF | \n",
" WisdomTree Issuer ICAV - WisdomTree Europe Equ... | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
"
\n",
" \n",
" WDSSF | \n",
" WisdomTree Issuer ICAV - WisdomTree US Quality... | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
"
\n",
" \n",
" ZKBHF | \n",
" ZKB Gold ETF | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
"
\n",
" \n",
"
\n",
"
2860 rows × 8 columns
\n",
"
"
],
"text/plain": [
" name currency summary \\\n",
"symbol \n",
"^ACWI ISHARES TRUST USD NaN \n",
"^ADFI-IV NFIELD DYNAMIC FIXED INCOME ETF USD NaN \n",
"^ADRE INVESCO ACTIVELY M USD NaN \n",
"^ARB-EU ALTSHARES MERGER ARBITRAGE ETF USD NaN \n",
"^ARB-IV ALTSHARES MERGER ARBITRAGE ETF USD NaN \n",
"... ... ... ... \n",
"VGFPF Vanguard Funds Public Limited Company - Vangua... NaN NaN \n",
"VFDEF Vanguard Funds Public Limited Company - Vangua... NaN NaN \n",
"WSDMF WisdomTree Issuer ICAV - WisdomTree Europe Equ... NaN NaN \n",
"WDSSF WisdomTree Issuer ICAV - WisdomTree US Quality... NaN NaN \n",
"ZKBHF ZKB Gold ETF NaN NaN \n",
"\n",
" category_group category family exchange market \n",
"symbol \n",
"^ACWI NaN NaN NaN NIM us_market \n",
"^ADFI-IV NaN NaN NaN ASE us_market \n",
"^ADRE NaN NaN NaN NIM us_market \n",
"^ARB-EU NaN NaN NaN ASE us_market \n",
"^ARB-IV NaN NaN NaN ASE us_market \n",
"... ... ... ... ... ... \n",
"VGFPF NaN NaN NaN NaN NaN \n",
"VFDEF NaN NaN NaN NaN NaN \n",
"WSDMF NaN NaN NaN NaN NaN \n",
"WDSSF NaN NaN NaN NaN NaN \n",
"ZKBHF NaN NaN NaN NaN NaN \n",
"\n",
"[2860 rows x 8 columns]"
]
},
"execution_count": 17,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"etfs = fd.ETFs()\n",
"\n",
"etfs.select()"
]
},
{
"attachments": {},
"cell_type": "markdown",
"id": "7accdfd6",
"metadata": {},
"source": [
"This returns approximately 2.500 different ETFs. Note that by default, only the American exchanges are selected. These are symbols like `SPY` (SPDR S&P 500 ETF Trust) and `VTI` (Vanguard Total Stock Market Index Fund ETF) that tend to be recognized by a majority of data providers and therefore is the default. To disable this, you can set the `exclude_exchanges` argument to `False` which then results in approximately 35.000 different symbols. Find a more elaborate explanation with `help(etfs.select)`:"
]
},
{
"cell_type": "code",
"execution_count": 18,
"id": "010292bd",
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"Help on method select in module financedatabase.ETFs:\n",
"\n",
"select(category_group: str = '', category: str = '', family: str = '', exclude_exchanges: bool = True, capitalize: bool = True) -> pandas.core.frame.DataFrame method of financedatabase.ETFs.ETFs instance\n",
" Retrieve ETF data based on specified criteria.\n",
" \n",
" This method allows you to retrieve data for specific ETFs based on a combination\n",
" of category group, category, and family filters. You can also exclude\n",
" exchanges from the search. If no input criteria are provided, it returns data for all ETFs.\n",
" \n",
" Args:\n",
" category_group (str, optional):\n",
" Specific category group to retrieve data for. If not provided, returns data for all category groups.\n",
" category (str, optional):\n",
" Specific category to retrieve data for. If not provided, returns data for all categories.\n",
" family (str, optional):\n",
" Specific family to retrieve data for. If not provided, returns data for all families.\n",
" exclude_exchanges (bool, optional):\n",
" Whether to exclude exchanges from the search. If False, you will receive\n",
" data for ETFs from different exchanges. Default is True.\n",
" capitalize (bool, optional):\n",
" Indicates whether category group, category, and family names should be capitalized for matching.\n",
" Default is True.\n",
" \n",
" Returns:\n",
" pd.DataFrame:\n",
" A DataFrame containing ETF data matching the specified input criteria.\n",
"\n"
]
}
],
"source": [
"help(etfs.select)"
]
},
{
"attachments": {},
"cell_type": "markdown",
"id": "6d8fecc2",
"metadata": {},
"source": [
"With this information in hand, and having seen the available options within [Understanding the available options](#understanding-the-available-options), we can specify the selection as follows:"
]
},
{
"cell_type": "code",
"execution_count": 19,
"id": "2fe5fceb",
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"\n",
"\n",
"
\n",
" \n",
" \n",
" | \n",
" name | \n",
" currency | \n",
" summary | \n",
" category_group | \n",
" category | \n",
" family | \n",
" exchange | \n",
" market | \n",
"
\n",
" \n",
" symbol | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
"
\n",
" \n",
" \n",
" \n",
" AFK | \n",
" VanEck Vectors Africa Index ETF | \n",
" USD | \n",
" The investment seeks to replicate as closely a... | \n",
" Equities | \n",
" Developed Markets | \n",
" VanEck Asset Management | \n",
" PCX | \n",
" us_market | \n",
"
\n",
" \n",
" AGT | \n",
" iShares MSCI Argentina and Global Exposure ETF | \n",
" USD | \n",
" The investment seeks to track the investment r... | \n",
" Equities | \n",
" Developed Markets | \n",
" BlackRock Asset Management | \n",
" BTS | \n",
" us_market | \n",
"
\n",
" \n",
" ARGT | \n",
" Global X MSCI Argentina ETF | \n",
" USD | \n",
" The investment seeks to provide investment res... | \n",
" Equities | \n",
" Developed Markets | \n",
" Global X Funds | \n",
" PCX | \n",
" us_market | \n",
"
\n",
" \n",
" AVMU | \n",
" Avantis Core Municipal Fixed Income ETF | \n",
" USD | \n",
" The investment seeks current income that is ex... | \n",
" Fixed Income | \n",
" Developed Markets | \n",
" Avantis Investors | \n",
" PCX | \n",
" us_market | \n",
"
\n",
" \n",
" BBEU | \n",
" JPMorgan BetaBuilders Europe ETF | \n",
" USD | \n",
" The investment seeks investment results that c... | \n",
" Equities | \n",
" Developed Markets | \n",
" JPMorgan Asset Management | \n",
" BTS | \n",
" us_market | \n",
"
\n",
" \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
"
\n",
" \n",
" XMPT | \n",
" VanEck Vectors CEF Municipal Income ETF | \n",
" USD | \n",
" The investment seeks to replicate as closely a... | \n",
" Fixed Income | \n",
" Developed Markets | \n",
" VanEck Asset Management | \n",
" BTS | \n",
" us_market | \n",
"
\n",
" \n",
" ZCAN | \n",
" SPDR Solactive Canada ETF | \n",
" USD | \n",
" The investment seeks to track the performance ... | \n",
" Equities | \n",
" Developed Markets | \n",
" State Street Global Advisors | \n",
" PCX | \n",
" us_market | \n",
"
\n",
" \n",
" ZDEU | \n",
" SPDR Solactive Germany ETF | \n",
" USD | \n",
" The investment seeks to track the performance ... | \n",
" Equities | \n",
" Developed Markets | \n",
" State Street Global Advisors | \n",
" PCX | \n",
" us_market | \n",
"
\n",
" \n",
" ZGBR | \n",
" SPDR Solactive United Kingdom ETF | \n",
" USD | \n",
" The investment seeks to track the performance ... | \n",
" Equities | \n",
" Developed Markets | \n",
" State Street Global Advisors | \n",
" PCX | \n",
" us_market | \n",
"
\n",
" \n",
" ZJPN | \n",
" SPDR Solactive Japan ETF | \n",
" USD | \n",
" The investment seeks to track the performance ... | \n",
" Equities | \n",
" Developed Markets | \n",
" State Street Global Advisors | \n",
" PCX | \n",
" us_market | \n",
"
\n",
" \n",
"
\n",
"
169 rows × 8 columns
\n",
"
"
],
"text/plain": [
" name currency \\\n",
"symbol \n",
"AFK VanEck Vectors Africa Index ETF USD \n",
"AGT iShares MSCI Argentina and Global Exposure ETF USD \n",
"ARGT Global X MSCI Argentina ETF USD \n",
"AVMU Avantis Core Municipal Fixed Income ETF USD \n",
"BBEU JPMorgan BetaBuilders Europe ETF USD \n",
"... ... ... \n",
"XMPT VanEck Vectors CEF Municipal Income ETF USD \n",
"ZCAN SPDR Solactive Canada ETF USD \n",
"ZDEU SPDR Solactive Germany ETF USD \n",
"ZGBR SPDR Solactive United Kingdom ETF USD \n",
"ZJPN SPDR Solactive Japan ETF USD \n",
"\n",
" summary category_group \\\n",
"symbol \n",
"AFK The investment seeks to replicate as closely a... Equities \n",
"AGT The investment seeks to track the investment r... Equities \n",
"ARGT The investment seeks to provide investment res... Equities \n",
"AVMU The investment seeks current income that is ex... Fixed Income \n",
"BBEU The investment seeks investment results that c... Equities \n",
"... ... ... \n",
"XMPT The investment seeks to replicate as closely a... Fixed Income \n",
"ZCAN The investment seeks to track the performance ... Equities \n",
"ZDEU The investment seeks to track the performance ... Equities \n",
"ZGBR The investment seeks to track the performance ... Equities \n",
"ZJPN The investment seeks to track the performance ... Equities \n",
"\n",
" category family exchange market \n",
"symbol \n",
"AFK Developed Markets VanEck Asset Management PCX us_market \n",
"AGT Developed Markets BlackRock Asset Management BTS us_market \n",
"ARGT Developed Markets Global X Funds PCX us_market \n",
"AVMU Developed Markets Avantis Investors PCX us_market \n",
"BBEU Developed Markets JPMorgan Asset Management BTS us_market \n",
"... ... ... ... ... \n",
"XMPT Developed Markets VanEck Asset Management BTS us_market \n",
"ZCAN Developed Markets State Street Global Advisors PCX us_market \n",
"ZDEU Developed Markets State Street Global Advisors PCX us_market \n",
"ZGBR Developed Markets State Street Global Advisors PCX us_market \n",
"ZJPN Developed Markets State Street Global Advisors PCX us_market \n",
"\n",
"[169 rows x 8 columns]"
]
},
"execution_count": 19,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"etfs.select(category=\"Developed Markets\")"
]
},
{
"attachments": {},
"cell_type": "markdown",
"id": "86b5d8b2",
"metadata": {},
"source": [
"## Funds"
]
},
{
"attachments": {},
"cell_type": "markdown",
"id": "ae3c8bcc",
"metadata": {},
"source": [
"If you wish to collect data from all funds you can use the following:"
]
},
{
"cell_type": "code",
"execution_count": 20,
"id": "9fa956af",
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"\n",
"\n",
"
\n",
" \n",
" \n",
" | \n",
" name | \n",
" currency | \n",
" summary | \n",
" manager_name | \n",
" manager_bio | \n",
" category_group | \n",
" category | \n",
" family | \n",
" exchange | \n",
" market | \n",
"
\n",
" \n",
" symbol | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
"
\n",
" \n",
" \n",
" \n",
" AAAAX | \n",
" DWS RREEF Real Assets Fund - Class A | \n",
" USD | \n",
" The investment seeks total return in excess of... | \n",
" John Vojticek | \n",
" Co-Head of Liquid Real Assets / Chief Investme... | \n",
" Equities | \n",
" World | \n",
" DWS | \n",
" NAS | \n",
" us_market | \n",
"
\n",
" \n",
" AAACX | \n",
" A3 Alternative Credit Fund | \n",
" USD | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NAS | \n",
" us_market | \n",
"
\n",
" \n",
" AAAEX | \n",
" Virtus AllianzGI Health Sciences Fund Class P | \n",
" USD | \n",
" The investment seeks long-term capital appreci... | \n",
" Peter Pirsch | \n",
" Mr. Pirsch is a senior portfolio manager, a se... | \n",
" Equities | \n",
" Health Care | \n",
" Virtus | \n",
" NAS | \n",
" us_market | \n",
"
\n",
" \n",
" AAAFX | \n",
" American Century One Choice Blend+ 2015 Portfo... | \n",
" USD | \n",
" The investment seeks the highest total return ... | \n",
" Scott A. Wilson | \n",
" Mr. Wilson, Vice President and Portfolio Manag... | \n",
" Equities | \n",
" Target Date | \n",
" American Investments | \n",
" NAS | \n",
" us_market | \n",
"
\n",
" \n",
" AAAGX | \n",
" Thrivent Large Cap Growth Fund Class A | \n",
" USD | \n",
" The investment seeks long-term capital appreci... | \n",
" Lauri Brunner | \n",
" Ms. Brunner has been with Thrivent Financial s... | \n",
" Equities | \n",
" Factors | \n",
" Thrivent Funds | \n",
" NAS | \n",
" us_market | \n",
"
\n",
" \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
"
\n",
" \n",
" ZVNBX | \n",
" Zevenbergen Growth Fund Investor Class | \n",
" USD | \n",
" The investment seeks long-term capital appreci... | \n",
" Joseph Dennison | \n",
" Mr. Dennison joined ZCI in 2011.   In hi... | \n",
" Equities | \n",
" Factors | \n",
" Zevenbergen Capital Investments | \n",
" NAS | \n",
" us_market | \n",
"
\n",
" \n",
" ZVNIX | \n",
" Zevenbergen Growth Fund Institutional Class | \n",
" USD | \n",
" The investment seeks long-term capital appreci... | \n",
" Joseph Dennison | \n",
" Mr. Dennison joined ZCI in 2011.   In hi... | \n",
" Equities | \n",
" Factors | \n",
" Zevenbergen Capital Investments | \n",
" NAS | \n",
" us_market | \n",
"
\n",
" \n",
" ZVZZCNX | \n",
" Nasdaq NextShares Test Instrume | \n",
" USD | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NAS | \n",
" us_market | \n",
"
\n",
" \n",
" ZZZAX | \n",
" Test Demand Deposit Account - T | \n",
" USD | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NAS | \n",
" us_market | \n",
"
\n",
" \n",
" ZZZZIX | \n",
" Nasdaq Test - AIP Managed Futur | \n",
" USD | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NAS | \n",
" us_market | \n",
"
\n",
" \n",
"
\n",
"
31440 rows × 10 columns
\n",
"
"
],
"text/plain": [
" name currency \\\n",
"symbol \n",
"AAAAX DWS RREEF Real Assets Fund - Class A USD \n",
"AAACX A3 Alternative Credit Fund USD \n",
"AAAEX Virtus AllianzGI Health Sciences Fund Class P USD \n",
"AAAFX American Century One Choice Blend+ 2015 Portfo... USD \n",
"AAAGX Thrivent Large Cap Growth Fund Class A USD \n",
"... ... ... \n",
"ZVNBX Zevenbergen Growth Fund Investor Class USD \n",
"ZVNIX Zevenbergen Growth Fund Institutional Class USD \n",
"ZVZZCNX Nasdaq NextShares Test Instrume USD \n",
"ZZZAX Test Demand Deposit Account - T USD \n",
"ZZZZIX Nasdaq Test - AIP Managed Futur USD \n",
"\n",
" summary manager_name \\\n",
"symbol \n",
"AAAAX The investment seeks total return in excess of... John Vojticek \n",
"AAACX NaN NaN \n",
"AAAEX The investment seeks long-term capital appreci... Peter Pirsch \n",
"AAAFX The investment seeks the highest total return ... Scott A. Wilson \n",
"AAAGX The investment seeks long-term capital appreci... Lauri Brunner \n",
"... ... ... \n",
"ZVNBX The investment seeks long-term capital appreci... Joseph Dennison \n",
"ZVNIX The investment seeks long-term capital appreci... Joseph Dennison \n",
"ZVZZCNX NaN NaN \n",
"ZZZAX NaN NaN \n",
"ZZZZIX NaN NaN \n",
"\n",
" manager_bio category_group \\\n",
"symbol \n",
"AAAAX Co-Head of Liquid Real Assets / Chief Investme... Equities \n",
"AAACX NaN NaN \n",
"AAAEX Mr. Pirsch is a senior portfolio manager, a se... Equities \n",
"AAAFX Mr. Wilson, Vice President and Portfolio Manag... Equities \n",
"AAAGX Ms. Brunner has been with Thrivent Financial s... Equities \n",
"... ... ... \n",
"ZVNBX Mr. Dennison joined ZCI in 2011.   In hi... Equities \n",
"ZVNIX Mr. Dennison joined ZCI in 2011.   In hi... Equities \n",
"ZVZZCNX NaN NaN \n",
"ZZZAX NaN NaN \n",
"ZZZZIX NaN NaN \n",
"\n",
" category family exchange market \n",
"symbol \n",
"AAAAX World DWS NAS us_market \n",
"AAACX NaN NaN NAS us_market \n",
"AAAEX Health Care Virtus NAS us_market \n",
"AAAFX Target Date American Investments NAS us_market \n",
"AAAGX Factors Thrivent Funds NAS us_market \n",
"... ... ... ... ... \n",
"ZVNBX Factors Zevenbergen Capital Investments NAS us_market \n",
"ZVNIX Factors Zevenbergen Capital Investments NAS us_market \n",
"ZVZZCNX NaN NaN NAS us_market \n",
"ZZZAX NaN NaN NAS us_market \n",
"ZZZZIX NaN NaN NAS us_market \n",
"\n",
"[31440 rows x 10 columns]"
]
},
"execution_count": 20,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"funds = fd.Funds()\n",
"\n",
"funds.select()"
]
},
{
"attachments": {},
"cell_type": "markdown",
"id": "16059f26",
"metadata": {},
"source": [
"This returns approximately 30.000 different Funds. Note that by default, only the American exchanges are selected. These are symbols that tend to be recognized by a majority of data providers and therefore is the default. To disable this, you can set the `exclude_exchanges` argument to `False` which then results in approximately 55.000 different symbols. Find a more elaborate explanation with `help(funds.select)`:\n"
]
},
{
"cell_type": "code",
"execution_count": 21,
"id": "9c8bc2a4",
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"Help on method select in module financedatabase.Funds:\n",
"\n",
"select(category_group: str = '', category: str = '', family: str = '', exclude_exchanges: bool = True, capitalize: bool = True) -> pandas.core.frame.DataFrame method of financedatabase.Funds.Funds instance\n",
" Retrieve fund data based on specified criteria.\n",
" \n",
" This method allows you to retrieve data for specific funds based on a combination\n",
" of category group, category, and family filters. You can also exclude\n",
" exchanges from the search. If no input criteria are provided, it returns data for all funds.\n",
" \n",
" Args:\n",
" category_group (str, optional):\n",
" Specific category group to retrieve data for. If not provided, returns data for all category groups.\n",
" category (str, optional):\n",
" Specific category to retrieve data for. If not provided, returns data for all categories.\n",
" family (str, optional):\n",
" Specific family to retrieve data for. If not provided, returns data for all families.\n",
" exclude_exchanges (bool, optional):\n",
" Whether to exclude exchanges from the search. If False, you will receive\n",
" data for funds from different exchanges. Default is True.\n",
" capitalize (bool, optional):\n",
" Indicates whether category group, category, and family names should be capitalized for matching.\n",
" Default is True.\n",
" \n",
" Returns:\n",
" pd.DataFrame:\n",
" A DataFrame containing fund data matching the specified input criteria.\n",
"\n"
]
}
],
"source": [
"help(funds.select)"
]
},
{
"attachments": {},
"cell_type": "markdown",
"id": "426bf626",
"metadata": {},
"source": [
"With this information in hand, and having seen the available options within [Understanding the available options](#understanding-the-available-options), we can specify the selection as follows:"
]
},
{
"cell_type": "code",
"execution_count": 22,
"id": "259c5df4",
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"array(['Alternative', 'Commodities', 'Derivatives', 'Equities',\n",
" 'Fixed Income', 'Infrastructure', 'Miscellaneous', 'Real Estate'],\n",
" dtype=object)"
]
},
"execution_count": 22,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"funds.options(selection=\"category_group\")"
]
},
{
"cell_type": "code",
"execution_count": 23,
"id": "c93e5a52",
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"array(['Africa', 'Allocation', 'Asia', 'Australia', 'Austria', 'Canada',\n",
" 'China', 'Communications', 'Consumer Discretionary',\n",
" 'Consumer Staples', 'Emerging Markets', 'Energy', 'Equities',\n",
" 'Europe', 'Factors', 'Financials', 'France', 'Germany',\n",
" 'Health Care', 'Hong Kong', 'India', 'Industrials', 'Islamic',\n",
" 'Italy', 'Japan', 'Latin America', 'Mexico', 'Netherlands',\n",
" 'New Zealand', 'North America', 'Scandinavia', 'Sector', 'Spain',\n",
" 'Target Date', 'Technology', 'Thailand', 'Trading',\n",
" 'United Kingdom', 'United States', 'Utilities', 'Vietnam', 'World'],\n",
" dtype=object)"
]
},
"execution_count": 23,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"funds.options(selection=\"category\", category_group=\"Equities\")"
]
},
{
"cell_type": "code",
"execution_count": 24,
"id": "18c9cec0",
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"\n",
"\n",
"
\n",
" \n",
" \n",
" | \n",
" name | \n",
" currency | \n",
" summary | \n",
" manager_name | \n",
" manager_bio | \n",
" category_group | \n",
" category | \n",
" family | \n",
" exchange | \n",
" market | \n",
"
\n",
" \n",
" symbol | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
"
\n",
" \n",
" \n",
" \n",
" AACFX | \n",
" Invesco Greater China Fund Class A | \n",
" USD | \n",
" The investment seeks long-term growth of capit... | \n",
" Mike Shiao | \n",
" Mike Shiao has 25 years of investment experien... | \n",
" Equities | \n",
" China | \n",
" Invesco Asset Management | \n",
" NAS | \n",
" us_market | \n",
"
\n",
" \n",
" ACEAX | \n",
" AB All China Equity Portfolio Class A | \n",
" USD | \n",
" The investment seeks long-term growth of capit... | \n",
" Stuart Rae | \n",
" Stuart Rae has been Chief Investment Officer o... | \n",
" Equities | \n",
" China | \n",
" AllianceBernstein | \n",
" NAS | \n",
" us_market | \n",
"
\n",
" \n",
" ACEYX | \n",
" AB All China Equity Portfolio Advisor Class | \n",
" USD | \n",
" The investment seeks long-term growth of capit... | \n",
" Stuart Rae | \n",
" Stuart Rae has been Chief Investment Officer o... | \n",
" Equities | \n",
" China | \n",
" AllianceBernstein | \n",
" NAS | \n",
" us_market | \n",
"
\n",
" \n",
" AMCYX | \n",
" Invesco Greater China Fund Class Y | \n",
" USD | \n",
" The investment seeks long-term growth of capit... | \n",
" Mike Shiao | \n",
" Mike Shiao has 25 years of investment experien... | \n",
" Equities | \n",
" China | \n",
" Invesco Asset Management | \n",
" NAS | \n",
" us_market | \n",
"
\n",
" \n",
" BCAKX | \n",
" Baillie Gifford China A Shares Fund Class K | \n",
" USD | \n",
" The investment seeks capital appreciation. Th... | \n",
" Sophie Earnshaw | \n",
" Sophie Earnshaw, CFA, Portfolio Manager, joine... | \n",
" Equities | \n",
" China | \n",
" Baillie Gifford Funds | \n",
" NAS | \n",
" us_market | \n",
"
\n",
" \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
"
\n",
" \n",
" USCOX | \n",
" U.S. Global Investors China Region Fund Invest... | \n",
" USD | \n",
" The investment seeks long-term growth of capit... | \n",
" Frank Holmes | \n",
" NaN | \n",
" Equities | \n",
" China | \n",
" U.S. Global Investors | \n",
" NAS | \n",
" us_market | \n",
"
\n",
" \n",
" WAGCX | \n",
" Wasatch Greater China Fund Investor Class Shares | \n",
" USD | \n",
" The investment seeks long-term growth of capit... | \n",
" Kevin I. Huerta Unger | \n",
" Kevin Unger, CFA has been an associate portfol... | \n",
" Equities | \n",
" China | \n",
" Wasatch | \n",
" NAS | \n",
" us_market | \n",
"
\n",
" \n",
" WCMCX | \n",
" WCM China Quality Growth Fund Institutional Cl... | \n",
" USD | \n",
" The investment seeks long-term capital appreci... | \n",
" Michael Z. Tian | \n",
" As Business Analyst, Michael’s primary re... | \n",
" Equities | \n",
" China | \n",
" WCM Investment Management | \n",
" NAS | \n",
" us_market | \n",
"
\n",
" \n",
" WCQGX | \n",
" WCM China Quality Growth Fund Investor Class S... | \n",
" USD | \n",
" The investment seeks long-term capital appreci... | \n",
" Michael Z. Tian | \n",
" As Business Analyst, Michael’s primary re... | \n",
" Equities | \n",
" China | \n",
" WCM Investment Management | \n",
" NAS | \n",
" us_market | \n",
"
\n",
" \n",
" WGGCX | \n",
" Wasatch Greater China Fund Institutional Class... | \n",
" USD | \n",
" The investment seeks long-term growth of capit... | \n",
" Kevin I. Huerta Unger | \n",
" Kevin Unger, CFA has been an associate portfol... | \n",
" Equities | \n",
" China | \n",
" Wasatch | \n",
" NAS | \n",
" us_market | \n",
"
\n",
" \n",
"
\n",
"
79 rows × 10 columns
\n",
"
"
],
"text/plain": [
" name currency \\\n",
"symbol \n",
"AACFX Invesco Greater China Fund Class A USD \n",
"ACEAX AB All China Equity Portfolio Class A USD \n",
"ACEYX AB All China Equity Portfolio Advisor Class USD \n",
"AMCYX Invesco Greater China Fund Class Y USD \n",
"BCAKX Baillie Gifford China A Shares Fund Class K USD \n",
"... ... ... \n",
"USCOX U.S. Global Investors China Region Fund Invest... USD \n",
"WAGCX Wasatch Greater China Fund Investor Class Shares USD \n",
"WCMCX WCM China Quality Growth Fund Institutional Cl... USD \n",
"WCQGX WCM China Quality Growth Fund Investor Class S... USD \n",
"WGGCX Wasatch Greater China Fund Institutional Class... USD \n",
"\n",
" summary \\\n",
"symbol \n",
"AACFX The investment seeks long-term growth of capit... \n",
"ACEAX The investment seeks long-term growth of capit... \n",
"ACEYX The investment seeks long-term growth of capit... \n",
"AMCYX The investment seeks long-term growth of capit... \n",
"BCAKX The investment seeks capital appreciation. Th... \n",
"... ... \n",
"USCOX The investment seeks long-term growth of capit... \n",
"WAGCX The investment seeks long-term growth of capit... \n",
"WCMCX The investment seeks long-term capital appreci... \n",
"WCQGX The investment seeks long-term capital appreci... \n",
"WGGCX The investment seeks long-term growth of capit... \n",
"\n",
" manager_name \\\n",
"symbol \n",
"AACFX Mike Shiao \n",
"ACEAX Stuart Rae \n",
"ACEYX Stuart Rae \n",
"AMCYX Mike Shiao \n",
"BCAKX Sophie Earnshaw \n",
"... ... \n",
"USCOX Frank Holmes \n",
"WAGCX Kevin I. Huerta Unger \n",
"WCMCX Michael Z. Tian \n",
"WCQGX Michael Z. Tian \n",
"WGGCX Kevin I. Huerta Unger \n",
"\n",
" manager_bio category_group \\\n",
"symbol \n",
"AACFX Mike Shiao has 25 years of investment experien... Equities \n",
"ACEAX Stuart Rae has been Chief Investment Officer o... Equities \n",
"ACEYX Stuart Rae has been Chief Investment Officer o... Equities \n",
"AMCYX Mike Shiao has 25 years of investment experien... Equities \n",
"BCAKX Sophie Earnshaw, CFA, Portfolio Manager, joine... Equities \n",
"... ... ... \n",
"USCOX NaN Equities \n",
"WAGCX Kevin Unger, CFA has been an associate portfol... Equities \n",
"WCMCX As Business Analyst, Michael’s primary re... Equities \n",
"WCQGX As Business Analyst, Michael’s primary re... Equities \n",
"WGGCX Kevin Unger, CFA has been an associate portfol... Equities \n",
"\n",
" category family exchange market \n",
"symbol \n",
"AACFX China Invesco Asset Management NAS us_market \n",
"ACEAX China AllianceBernstein NAS us_market \n",
"ACEYX China AllianceBernstein NAS us_market \n",
"AMCYX China Invesco Asset Management NAS us_market \n",
"BCAKX China Baillie Gifford Funds NAS us_market \n",
"... ... ... ... ... \n",
"USCOX China U.S. Global Investors NAS us_market \n",
"WAGCX China Wasatch NAS us_market \n",
"WCMCX China WCM Investment Management NAS us_market \n",
"WCQGX China WCM Investment Management NAS us_market \n",
"WGGCX China Wasatch NAS us_market \n",
"\n",
"[79 rows x 10 columns]"
]
},
"execution_count": 24,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"funds.select(category_group=\"Equities\", category=\"China\")"
]
},
{
"attachments": {},
"cell_type": "markdown",
"id": "5f5e775d",
"metadata": {},
"source": [
"## Indices"
]
},
{
"attachments": {},
"cell_type": "markdown",
"id": "7bef885e",
"metadata": {},
"source": [
"If you wish to collect data from all indices you can use the following:"
]
},
{
"cell_type": "code",
"execution_count": 25,
"id": "427616f4",
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"\n",
"\n",
"
\n",
" \n",
" \n",
" | \n",
" name | \n",
" currency | \n",
" market | \n",
" exchange | \n",
" exchange timezone | \n",
"
\n",
" \n",
" symbol | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
"
\n",
" \n",
" \n",
" \n",
" GBKX | \n",
" KBW Nasdaq Global Bank Index | \n",
" NaN | \n",
" us_market | \n",
" NIM | \n",
" EDT | \n",
"
\n",
" \n",
" GBKXN | \n",
" KBW Nasdaq Global Bank Net Total Return Index | \n",
" NaN | \n",
" us_market | \n",
" NIM | \n",
" EDT | \n",
"
\n",
" \n",
" GBKXT | \n",
" KBW Nasdaq Global Bank Total Return Index | \n",
" NaN | \n",
" us_market | \n",
" NIM | \n",
" EDT | \n",
"
\n",
" \n",
" ^A1BSC | \n",
" Dow Jones Americas Basic Materi | \n",
" USD | \n",
" us_market | \n",
" DJI | \n",
" EDT | \n",
"
\n",
" \n",
" ^A1CYC | \n",
" Dow Jones Americas Consumer Ser | \n",
" USD | \n",
" us_market | \n",
" DJI | \n",
" EDT | \n",
"
\n",
" \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
"
\n",
" \n",
" ^ZSL-EU | \n",
" ProShares UltraShort Silver (Es | \n",
" USD | \n",
" us_market | \n",
" ASE | \n",
" EDT | \n",
"
\n",
" \n",
" ^ZSL-IV | \n",
" ProShares UltraShort Silver (In | \n",
" USD | \n",
" us_market | \n",
" ASE | \n",
" EDT | \n",
"
\n",
" \n",
" ^ZSL-NV | \n",
" ProShares UltraShort Silver (Ne | \n",
" USD | \n",
" us_market | \n",
" ASE | \n",
" EDT | \n",
"
\n",
" \n",
" ^ZSL-TC | \n",
" ProShares UltraShort Silver (To | \n",
" USD | \n",
" us_market | \n",
" ASE | \n",
" EDT | \n",
"
\n",
" \n",
" ^ZVZZT-624 | \n",
" ZVZZT.624 Test Symbol | \n",
" USD | \n",
" us_market | \n",
" NYS | \n",
" EDT | \n",
"
\n",
" \n",
"
\n",
"
62140 rows × 5 columns
\n",
"
"
],
"text/plain": [
" name currency market \\\n",
"symbol \n",
"GBKX KBW Nasdaq Global Bank Index NaN us_market \n",
"GBKXN KBW Nasdaq Global Bank Net Total Return Index NaN us_market \n",
"GBKXT KBW Nasdaq Global Bank Total Return Index NaN us_market \n",
"^A1BSC Dow Jones Americas Basic Materi USD us_market \n",
"^A1CYC Dow Jones Americas Consumer Ser USD us_market \n",
"... ... ... ... \n",
"^ZSL-EU ProShares UltraShort Silver (Es USD us_market \n",
"^ZSL-IV ProShares UltraShort Silver (In USD us_market \n",
"^ZSL-NV ProShares UltraShort Silver (Ne USD us_market \n",
"^ZSL-TC ProShares UltraShort Silver (To USD us_market \n",
"^ZVZZT-624 ZVZZT.624 Test Symbol USD us_market \n",
"\n",
" exchange exchange timezone \n",
"symbol \n",
"GBKX NIM EDT \n",
"GBKXN NIM EDT \n",
"GBKXT NIM EDT \n",
"^A1BSC DJI EDT \n",
"^A1CYC DJI EDT \n",
"... ... ... \n",
"^ZSL-EU ASE EDT \n",
"^ZSL-IV ASE EDT \n",
"^ZSL-NV ASE EDT \n",
"^ZSL-TC ASE EDT \n",
"^ZVZZT-624 NYS EDT \n",
"\n",
"[62140 rows x 5 columns]"
]
},
"execution_count": 25,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"indices = fd.Indices()\n",
"\n",
"indices.select()"
]
},
{
"attachments": {},
"cell_type": "markdown",
"id": "5b9e0c17",
"metadata": {},
"source": [
"This returns approximately 60.000 different indices. Note that by default, only the American exchanges are selected. These are symbols like `^GSPC` (S&P 500) that tend to be recognized by a majority of data providers and therefore is the default. To disable this, you can set the `exclude_exchanges` argument to `False` which then results in approximately 90.000 different symbols. Find a more elaborate explanation with `help(indices.select)`:"
]
},
{
"cell_type": "code",
"execution_count": 26,
"id": "441812f3",
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"Help on method select in module financedatabase.Indices:\n",
"\n",
"select(currency: str = '', capitalize: bool = True, exclude_exchanges: bool = True) -> pandas.core.frame.DataFrame method of financedatabase.Indices.Indices instance\n",
" Returns all indices when no input is given and has the option to give\n",
" a specific combination of indices based on the currency defined.\n",
" \n",
" Args:\n",
" currency (str, optional):\n",
" If filled, gives all data for a specific currency.\n",
" capitalize (bool, optional):\n",
" Whether the currency needs to be capitalized. By default, the values\n",
" are always capitalized as that is also how it is represented in the CSV files.\n",
" exclude_exchanges (bool, optional):\n",
" Whether you want to exclude exchanges from the search. If False,\n",
" you will receive multiple instances of the same product from different exchanges.\n",
" \n",
" Returns:\n",
" indices_df (pd.DataFrame):\n",
" Returns a DataFrame with a selection or all data based on the input.\n",
"\n"
]
}
],
"source": [
"help(indices.select)"
]
},
{
"attachments": {},
"cell_type": "markdown",
"id": "b6679da8",
"metadata": {},
"source": [
"## Currencies"
]
},
{
"attachments": {},
"cell_type": "markdown",
"id": "571f448b",
"metadata": {},
"source": [
"If you wish to collect data from all currencies you can use the following:"
]
},
{
"cell_type": "code",
"execution_count": 27,
"id": "e43f6df3",
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"\n",
"\n",
"
\n",
" \n",
" \n",
" | \n",
" name | \n",
" base_currency | \n",
" quote_currency | \n",
" exchange | \n",
" market | \n",
"
\n",
" \n",
" symbol | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
"
\n",
" \n",
" \n",
" \n",
" AED=X | \n",
" USD/AED | \n",
" USD | \n",
" AED | \n",
" CCY | \n",
" ccy_market | \n",
"
\n",
" \n",
" AEDAUD=X | \n",
" AED/AUD | \n",
" AED | \n",
" AUD | \n",
" CCY | \n",
" ccy_market | \n",
"
\n",
" \n",
" AEDBRX=X | \n",
" AED/BRX | \n",
" AED | \n",
" BRX | \n",
" CCY | \n",
" ccy_market | \n",
"
\n",
" \n",
" AEDCAD=X | \n",
" AED/CAD | \n",
" AED | \n",
" CAD | \n",
" CCY | \n",
" ccy_market | \n",
"
\n",
" \n",
" AEDCHF=X | \n",
" AED/CHF | \n",
" AED | \n",
" CHF | \n",
" CCY | \n",
" ccy_market | \n",
"
\n",
" \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
"
\n",
" \n",
" ZMWEUR=X | \n",
" ZMW/EUR | \n",
" ZMW | \n",
" EUR | \n",
" CCY | \n",
" ccy_market | \n",
"
\n",
" \n",
" ZMWGBP=X | \n",
" ZMW/GBP | \n",
" ZMW | \n",
" GBP | \n",
" CCY | \n",
" ccy_market | \n",
"
\n",
" \n",
" ZMWJPY=X | \n",
" ZMW/JPY | \n",
" ZMW | \n",
" JPY | \n",
" CCY | \n",
" ccy_market | \n",
"
\n",
" \n",
" ZMWUSD=X | \n",
" ZMW/USD | \n",
" ZMW | \n",
" USD | \n",
" CCY | \n",
" ccy_market | \n",
"
\n",
" \n",
" ZMWZAR=X | \n",
" ZMW/ZAR | \n",
" ZMW | \n",
" ZAR | \n",
" CCY | \n",
" ccy_market | \n",
"
\n",
" \n",
"
\n",
"
2556 rows × 5 columns
\n",
"
"
],
"text/plain": [
" name base_currency quote_currency exchange market\n",
"symbol \n",
"AED=X USD/AED USD AED CCY ccy_market\n",
"AEDAUD=X AED/AUD AED AUD CCY ccy_market\n",
"AEDBRX=X AED/BRX AED BRX CCY ccy_market\n",
"AEDCAD=X AED/CAD AED CAD CCY ccy_market\n",
"AEDCHF=X AED/CHF AED CHF CCY ccy_market\n",
"... ... ... ... ... ...\n",
"ZMWEUR=X ZMW/EUR ZMW EUR CCY ccy_market\n",
"ZMWGBP=X ZMW/GBP ZMW GBP CCY ccy_market\n",
"ZMWJPY=X ZMW/JPY ZMW JPY CCY ccy_market\n",
"ZMWUSD=X ZMW/USD ZMW USD CCY ccy_market\n",
"ZMWZAR=X ZMW/ZAR ZMW ZAR CCY ccy_market\n",
"\n",
"[2556 rows x 5 columns]"
]
},
"execution_count": 27,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"currencies = fd.Currencies()\n",
"\n",
"currencies.select()"
]
},
{
"attachments": {},
"cell_type": "markdown",
"id": "db0f9516",
"metadata": {},
"source": [
"This returns approximately 2.500 different currencies. Find a more elaborate explanation with `help(currencies.select)`:"
]
},
{
"cell_type": "code",
"execution_count": 28,
"id": "7efe7c8b",
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"Help on method select in module financedatabase.Currencies:\n",
"\n",
"select(base_currency: str = '', quote_currency: str = '', capitalize: bool = True) -> pandas.core.frame.DataFrame method of financedatabase.Currencies.Currencies instance\n",
" Retrieve currency data based on specified criteria.\n",
" \n",
" This method allows you to retrieve data for specific base or quote currencies,\n",
" with the option to customize the capitalization of currency names. If no input\n",
" criteria are provided, it returns data for all currencies.\n",
" \n",
" Args:\n",
" base_currency (str, optional):\n",
" Specific base currency to retrieve data for. If not provided, returns data for all base currencies.\n",
" quote_currency (str, optional):\n",
" Specific quote currency to retrieve data for. If not provided, returns data for all quote currencies.\n",
" capitalize (bool, optional):\n",
" Indicates whether the currency names should be capitalized for matching. Default is True.\n",
" \n",
" Returns:\n",
" pd.DataFrame:\n",
" A DataFrame containing currency data matching the specified input criteria.\n",
"\n"
]
}
],
"source": [
"# Help Window\n",
"help(currencies.select)"
]
},
{
"attachments": {},
"cell_type": "markdown",
"id": "b51f49d8",
"metadata": {},
"source": [
"With this information in hand, and having seen the available options within [Understanding the available options](#understanding-the-available-options), we can specify the selection as follows:\n"
]
},
{
"cell_type": "code",
"execution_count": 29,
"id": "814f32d8",
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"\n",
"\n",
"
\n",
" \n",
" \n",
" | \n",
" name | \n",
" base_currency | \n",
" quote_currency | \n",
" exchange | \n",
" market | \n",
"
\n",
" \n",
" symbol | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
"
\n",
" \n",
" \n",
" \n",
" AEDAUD=X | \n",
" AED/AUD | \n",
" AED | \n",
" AUD | \n",
" CCY | \n",
" ccy_market | \n",
"
\n",
" \n",
" AEDBRX=X | \n",
" AED/BRX | \n",
" AED | \n",
" BRX | \n",
" CCY | \n",
" ccy_market | \n",
"
\n",
" \n",
" AEDCAD=X | \n",
" AED/CAD | \n",
" AED | \n",
" CAD | \n",
" CCY | \n",
" ccy_market | \n",
"
\n",
" \n",
" AEDCHF=X | \n",
" AED/CHF | \n",
" AED | \n",
" CHF | \n",
" CCY | \n",
" ccy_market | \n",
"
\n",
" \n",
" AEDEUR=X | \n",
" AED/EUR | \n",
" AED | \n",
" EUR | \n",
" CCY | \n",
" ccy_market | \n",
"
\n",
" \n",
" AEDGBP=X | \n",
" AED/GBP | \n",
" AED | \n",
" GBP | \n",
" CCY | \n",
" ccy_market | \n",
"
\n",
" \n",
" AEDHKD=X | \n",
" AED/HKD | \n",
" AED | \n",
" HKD | \n",
" CCY | \n",
" ccy_market | \n",
"
\n",
" \n",
" AEDINR=X | \n",
" AED/INR | \n",
" AED | \n",
" INR | \n",
" CCY | \n",
" ccy_market | \n",
"
\n",
" \n",
" AEDJPY=X | \n",
" AED/JPY | \n",
" AED | \n",
" JPY | \n",
" CCY | \n",
" ccy_market | \n",
"
\n",
" \n",
" AEDKRW=X | \n",
" AED/KRW | \n",
" AED | \n",
" KRW | \n",
" CCY | \n",
" ccy_market | \n",
"
\n",
" \n",
" AEDKWD=X | \n",
" AED/KWD | \n",
" AED | \n",
" KWD | \n",
" CCY | \n",
" ccy_market | \n",
"
\n",
" \n",
" AEDLKR=X | \n",
" AED/LKR | \n",
" AED | \n",
" LKR | \n",
" CCY | \n",
" ccy_market | \n",
"
\n",
" \n",
" AEDMAD=X | \n",
" AED/MAD | \n",
" AED | \n",
" MAD | \n",
" CCY | \n",
" ccy_market | \n",
"
\n",
" \n",
" AEDMUR=X | \n",
" AED/MUR | \n",
" AED | \n",
" MUR | \n",
" CCY | \n",
" ccy_market | \n",
"
\n",
" \n",
" AEDMYX=X | \n",
" AED/MYX | \n",
" AED | \n",
" MYX | \n",
" CCY | \n",
" ccy_market | \n",
"
\n",
" \n",
" AEDNOK=X | \n",
" AED/NOK | \n",
" AED | \n",
" NOK | \n",
" CCY | \n",
" ccy_market | \n",
"
\n",
" \n",
" AEDNZD=X | \n",
" AED/NZD | \n",
" AED | \n",
" NZD | \n",
" CCY | \n",
" ccy_market | \n",
"
\n",
" \n",
" AEDOMR=X | \n",
" AED/OMR | \n",
" AED | \n",
" OMR | \n",
" CCY | \n",
" ccy_market | \n",
"
\n",
" \n",
" AEDPKR=X | \n",
" AED/PKR | \n",
" AED | \n",
" PKR | \n",
" CCY | \n",
" ccy_market | \n",
"
\n",
" \n",
" AEDQAR=X | \n",
" AED/QAR | \n",
" AED | \n",
" QAR | \n",
" CCY | \n",
" ccy_market | \n",
"
\n",
" \n",
" AEDSAR=X | \n",
" AED/SAR | \n",
" AED | \n",
" SAR | \n",
" CCY | \n",
" ccy_market | \n",
"
\n",
" \n",
" AEDSEK=X | \n",
" AED/SEK | \n",
" AED | \n",
" SEK | \n",
" CCY | \n",
" ccy_market | \n",
"
\n",
" \n",
" AEDSGD=X | \n",
" AED/SGD | \n",
" AED | \n",
" SGD | \n",
" CCY | \n",
" ccy_market | \n",
"
\n",
" \n",
" AEDTHX=X | \n",
" AED/THX | \n",
" AED | \n",
" THX | \n",
" CCY | \n",
" ccy_market | \n",
"
\n",
" \n",
" AEDTRY=X | \n",
" AED/TRY | \n",
" AED | \n",
" TRY | \n",
" CCY | \n",
" ccy_market | \n",
"
\n",
" \n",
" AEDUSD=X | \n",
" AED/USD | \n",
" AED | \n",
" USD | \n",
" CCY | \n",
" ccy_market | \n",
"
\n",
" \n",
" AEDXDR=X | \n",
" AED/XDR | \n",
" AED | \n",
" XDR | \n",
" CCY | \n",
" ccy_market | \n",
"
\n",
" \n",
" AEDZAR=X | \n",
" AED/ZAR | \n",
" AED | \n",
" ZAR | \n",
" CCY | \n",
" ccy_market | \n",
"
\n",
" \n",
"
\n",
"
"
],
"text/plain": [
" name base_currency quote_currency exchange market\n",
"symbol \n",
"AEDAUD=X AED/AUD AED AUD CCY ccy_market\n",
"AEDBRX=X AED/BRX AED BRX CCY ccy_market\n",
"AEDCAD=X AED/CAD AED CAD CCY ccy_market\n",
"AEDCHF=X AED/CHF AED CHF CCY ccy_market\n",
"AEDEUR=X AED/EUR AED EUR CCY ccy_market\n",
"AEDGBP=X AED/GBP AED GBP CCY ccy_market\n",
"AEDHKD=X AED/HKD AED HKD CCY ccy_market\n",
"AEDINR=X AED/INR AED INR CCY ccy_market\n",
"AEDJPY=X AED/JPY AED JPY CCY ccy_market\n",
"AEDKRW=X AED/KRW AED KRW CCY ccy_market\n",
"AEDKWD=X AED/KWD AED KWD CCY ccy_market\n",
"AEDLKR=X AED/LKR AED LKR CCY ccy_market\n",
"AEDMAD=X AED/MAD AED MAD CCY ccy_market\n",
"AEDMUR=X AED/MUR AED MUR CCY ccy_market\n",
"AEDMYX=X AED/MYX AED MYX CCY ccy_market\n",
"AEDNOK=X AED/NOK AED NOK CCY ccy_market\n",
"AEDNZD=X AED/NZD AED NZD CCY ccy_market\n",
"AEDOMR=X AED/OMR AED OMR CCY ccy_market\n",
"AEDPKR=X AED/PKR AED PKR CCY ccy_market\n",
"AEDQAR=X AED/QAR AED QAR CCY ccy_market\n",
"AEDSAR=X AED/SAR AED SAR CCY ccy_market\n",
"AEDSEK=X AED/SEK AED SEK CCY ccy_market\n",
"AEDSGD=X AED/SGD AED SGD CCY ccy_market\n",
"AEDTHX=X AED/THX AED THX CCY ccy_market\n",
"AEDTRY=X AED/TRY AED TRY CCY ccy_market\n",
"AEDUSD=X AED/USD AED USD CCY ccy_market\n",
"AEDXDR=X AED/XDR AED XDR CCY ccy_market\n",
"AEDZAR=X AED/ZAR AED ZAR CCY ccy_market"
]
},
"execution_count": 29,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"currencies.select(base_currency=\"AED\")"
]
},
{
"attachments": {},
"cell_type": "markdown",
"id": "065b35a2",
"metadata": {},
"source": [
"## Cryptocurrencies"
]
},
{
"attachments": {},
"cell_type": "markdown",
"id": "8c9be340",
"metadata": {},
"source": [
"If you wish to collect data from all cryptocurrencies you can use the following:"
]
},
{
"cell_type": "code",
"execution_count": 30,
"id": "c0f08947",
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"\n",
"\n",
"
\n",
" \n",
" \n",
" | \n",
" name | \n",
" cryptocurrency | \n",
" currency | \n",
" summary | \n",
" exchange | \n",
" market | \n",
"
\n",
" \n",
" symbol | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
"
\n",
" \n",
" \n",
" \n",
" AAVE-CAD | \n",
" Aave CAD | \n",
" AAVE | \n",
" CAD | \n",
" Aave (AAVE) is a cryptocurrency and operates o... | \n",
" CCC | \n",
" ccc_market | \n",
"
\n",
" \n",
" AAVE-CNY | \n",
" Aave CNY | \n",
" AAVE | \n",
" CNY | \n",
" Aave (AAVE) is a cryptocurrency and operates o... | \n",
" CCC | \n",
" ccc_market | \n",
"
\n",
" \n",
" AAVE-ETH | \n",
" Aave ETH | \n",
" AAVE | \n",
" ETH | \n",
" Aave (AAVE) is a cryptocurrency and operates o... | \n",
" CCC | \n",
" ccc_market | \n",
"
\n",
" \n",
" AAVE-EUR | \n",
" Aave EUR | \n",
" AAVE | \n",
" EUR | \n",
" Aave (AAVE) is a cryptocurrency and operates o... | \n",
" CCC | \n",
" ccc_market | \n",
"
\n",
" \n",
" AAVE-GBP | \n",
" Aave GBP | \n",
" AAVE | \n",
" GBP | \n",
" Aave (AAVE) is a cryptocurrency and operates o... | \n",
" CCC | \n",
" ccc_market | \n",
"
\n",
" \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
"
\n",
" \n",
" ZYN-INR | \n",
" Zynecoin INR | \n",
" ZYN | \n",
" INR | \n",
" Zynecoin (ZYN) is a cryptocurrency . Users are... | \n",
" CCC | \n",
" ccc_market | \n",
"
\n",
" \n",
" ZYN-JPY | \n",
" Zynecoin JPY | \n",
" ZYN | \n",
" JPY | \n",
" Zynecoin (ZYN) is a cryptocurrency . Users are... | \n",
" CCC | \n",
" ccc_market | \n",
"
\n",
" \n",
" ZYN-KRW | \n",
" Zynecoin KRW | \n",
" ZYN | \n",
" KRW | \n",
" Zynecoin (ZYN) is a cryptocurrency . Users are... | \n",
" CCC | \n",
" ccc_market | \n",
"
\n",
" \n",
" ZYN-RUB | \n",
" Zynecoin RUB | \n",
" ZYN | \n",
" RUB | \n",
" Zynecoin (ZYN) is a cryptocurrency . Users are... | \n",
" CCC | \n",
" ccc_market | \n",
"
\n",
" \n",
" ZYN-USD | \n",
" Zynecoin USD | \n",
" ZYN | \n",
" USD | \n",
" Zynecoin (ZYN) is a cryptocurrency . Users are... | \n",
" CCC | \n",
" ccc_market | \n",
"
\n",
" \n",
"
\n",
"
3367 rows × 6 columns
\n",
"
"
],
"text/plain": [
" name cryptocurrency currency \\\n",
"symbol \n",
"AAVE-CAD Aave CAD AAVE CAD \n",
"AAVE-CNY Aave CNY AAVE CNY \n",
"AAVE-ETH Aave ETH AAVE ETH \n",
"AAVE-EUR Aave EUR AAVE EUR \n",
"AAVE-GBP Aave GBP AAVE GBP \n",
"... ... ... ... \n",
"ZYN-INR Zynecoin INR ZYN INR \n",
"ZYN-JPY Zynecoin JPY ZYN JPY \n",
"ZYN-KRW Zynecoin KRW ZYN KRW \n",
"ZYN-RUB Zynecoin RUB ZYN RUB \n",
"ZYN-USD Zynecoin USD ZYN USD \n",
"\n",
" summary exchange \\\n",
"symbol \n",
"AAVE-CAD Aave (AAVE) is a cryptocurrency and operates o... CCC \n",
"AAVE-CNY Aave (AAVE) is a cryptocurrency and operates o... CCC \n",
"AAVE-ETH Aave (AAVE) is a cryptocurrency and operates o... CCC \n",
"AAVE-EUR Aave (AAVE) is a cryptocurrency and operates o... CCC \n",
"AAVE-GBP Aave (AAVE) is a cryptocurrency and operates o... CCC \n",
"... ... ... \n",
"ZYN-INR Zynecoin (ZYN) is a cryptocurrency . Users are... CCC \n",
"ZYN-JPY Zynecoin (ZYN) is a cryptocurrency . Users are... CCC \n",
"ZYN-KRW Zynecoin (ZYN) is a cryptocurrency . Users are... CCC \n",
"ZYN-RUB Zynecoin (ZYN) is a cryptocurrency . Users are... CCC \n",
"ZYN-USD Zynecoin (ZYN) is a cryptocurrency . Users are... CCC \n",
"\n",
" market \n",
"symbol \n",
"AAVE-CAD ccc_market \n",
"AAVE-CNY ccc_market \n",
"AAVE-ETH ccc_market \n",
"AAVE-EUR ccc_market \n",
"AAVE-GBP ccc_market \n",
"... ... \n",
"ZYN-INR ccc_market \n",
"ZYN-JPY ccc_market \n",
"ZYN-KRW ccc_market \n",
"ZYN-RUB ccc_market \n",
"ZYN-USD ccc_market \n",
"\n",
"[3367 rows x 6 columns]"
]
},
"execution_count": 30,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"cryptos = fd.Cryptos()\n",
"\n",
"cryptos.select()"
]
},
{
"attachments": {},
"cell_type": "markdown",
"id": "74a29e93",
"metadata": {},
"source": [
"This returns approximately 3.000 different cryptocurrencies. Find a more elaborate explanation with `help(cryptos.select)`:"
]
},
{
"cell_type": "code",
"execution_count": 31,
"id": "aed99e3c",
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"Help on method select in module financedatabase.Cryptos:\n",
"\n",
"select(crypto: str = '', currency: str = '', capitalize: bool = True) -> pandas.core.frame.DataFrame method of financedatabase.Cryptos.Cryptos instance\n",
" Obtain cryptocurrency data based on specified criteria.\n",
" \n",
" This method allows you to retrieve data for specific cryptocurrencies and currencies,\n",
" with the option to customize the capitalization of cryptocurrency names. If no input\n",
" criteria are provided, it returns data for all cryptocurrencies.\n",
" \n",
" Args:\n",
" crypto (str, optional):\n",
" Specific cryptocurrency to retrieve data for. If not provided, returns data for all cryptocurrencies.\n",
" currency (str, optional):\n",
" Specific currency to filter by. If not provided, no currency filtering is applied.\n",
" capitalize (bool, optional):\n",
" Indicates whether the cryptocurrency names should be capitalized for matching. Default is True.\n",
" \n",
" Returns:\n",
" pd.DataFrame:\n",
" A DataFrame containing cryptocurrency data matching the specified input criteria.\n",
"\n"
]
}
],
"source": [
"help(cryptos.select)"
]
},
{
"attachments": {},
"cell_type": "markdown",
"id": "d0ec3009",
"metadata": {},
"source": [
"With this information in hand, and having seen the available options within [Understanding the available options](#understanding-the-available-options), we can specify the selection as follows. Which returns a total of 5 combination of cryptocurrencies that include the ETH."
]
},
{
"cell_type": "code",
"execution_count": 32,
"id": "5e02f1fc",
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"\n",
"\n",
"
\n",
" \n",
" \n",
" | \n",
" name | \n",
" cryptocurrency | \n",
" currency | \n",
" summary | \n",
" exchange | \n",
" market | \n",
"
\n",
" \n",
" symbol | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
"
\n",
" \n",
" \n",
" \n",
" ETH-BTC | \n",
" Ethereum BTC | \n",
" ETH | \n",
" BTC | \n",
" Ethereum (ETH) is a cryptocurrency . Users are... | \n",
" CCC | \n",
" ccc_market | \n",
"
\n",
" \n",
" ETH-CAD | \n",
" Ethereum CAD | \n",
" ETH | \n",
" CAD | \n",
" Ethereum (ETH) is a cryptocurrency . Users are... | \n",
" CCC | \n",
" ccc_market | \n",
"
\n",
" \n",
" ETH-EUR | \n",
" Ethereum EUR | \n",
" ETH | \n",
" EUR | \n",
" Ethereum (ETH) is a cryptocurrency . Users are... | \n",
" CCC | \n",
" ccc_market | \n",
"
\n",
" \n",
" ETH-GBP | \n",
" Ethereum GBP | \n",
" ETH | \n",
" GBP | \n",
" Ethereum (ETH) is a cryptocurrency . Users are... | \n",
" CCC | \n",
" ccc_market | \n",
"
\n",
" \n",
" ETH-USD | \n",
" Ethereum USD | \n",
" ETH | \n",
" USD | \n",
" Ethereum (ETH) is a cryptocurrency . Users are... | \n",
" CCC | \n",
" ccc_market | \n",
"
\n",
" \n",
"
\n",
"
"
],
"text/plain": [
" name cryptocurrency currency \\\n",
"symbol \n",
"ETH-BTC Ethereum BTC ETH BTC \n",
"ETH-CAD Ethereum CAD ETH CAD \n",
"ETH-EUR Ethereum EUR ETH EUR \n",
"ETH-GBP Ethereum GBP ETH GBP \n",
"ETH-USD Ethereum USD ETH USD \n",
"\n",
" summary exchange \\\n",
"symbol \n",
"ETH-BTC Ethereum (ETH) is a cryptocurrency . Users are... CCC \n",
"ETH-CAD Ethereum (ETH) is a cryptocurrency . Users are... CCC \n",
"ETH-EUR Ethereum (ETH) is a cryptocurrency . Users are... CCC \n",
"ETH-GBP Ethereum (ETH) is a cryptocurrency . Users are... CCC \n",
"ETH-USD Ethereum (ETH) is a cryptocurrency . Users are... CCC \n",
"\n",
" market \n",
"symbol \n",
"ETH-BTC ccc_market \n",
"ETH-CAD ccc_market \n",
"ETH-EUR ccc_market \n",
"ETH-GBP ccc_market \n",
"ETH-USD ccc_market "
]
},
"execution_count": 32,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"cryptos.select(crypto=\"ETH\")"
]
},
{
"attachments": {},
"cell_type": "markdown",
"id": "df9c87c5",
"metadata": {},
"source": [
"## Moneymarkets"
]
},
{
"attachments": {},
"cell_type": "markdown",
"id": "1c502197",
"metadata": {},
"source": [
"If you wish to collect data from all money markets you can use the following:"
]
},
{
"cell_type": "code",
"execution_count": 33,
"id": "6aa26df8",
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"\n",
"\n",
"
\n",
" \n",
" \n",
" | \n",
" name | \n",
" category | \n",
" currency | \n",
" market | \n",
" exchange | \n",
"
\n",
" \n",
" symbol | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
"
\n",
" \n",
" \n",
" \n",
" AABXX | \n",
" SEI Daily Income Trust Government Fund | \n",
" NaN | \n",
" USD | \n",
" us_market | \n",
" NAS | \n",
"
\n",
" \n",
" AAFXX | \n",
" American Funds U.S. Government | \n",
" NaN | \n",
" USD | \n",
" us_market | \n",
" NAS | \n",
"
\n",
" \n",
" AALXX | \n",
" Thrivent Money Market Fund | \n",
" Thrivent Mutual Funds | \n",
" USD | \n",
" us_market | \n",
" NAS | \n",
"
\n",
" \n",
" AAOXX | \n",
" American Beacon U.S. Government Money Market S... | \n",
" NaN | \n",
" USD | \n",
" us_market | \n",
" NAS | \n",
"
\n",
" \n",
" AARXX | \n",
" AARP Money Market Fund | \n",
" NaN | \n",
" USD | \n",
" us_market | \n",
" NAS | \n",
"
\n",
" \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
"
\n",
" \n",
" WRNXX | \n",
" Ivy Government Money Market Fund | \n",
" Ivy Funds | \n",
" USD | \n",
" us_market | \n",
" NAS | \n",
"
\n",
" \n",
" WTLXX | \n",
" Treasury Plus Money Market Fund | \n",
" Wells Fargo Funds Trust | \n",
" USD | \n",
" us_market | \n",
" NAS | \n",
"
\n",
" \n",
" WTPXX | \n",
" Treasury Plus Money Market Fund | \n",
" Wells Fargo Funds Trust | \n",
" USD | \n",
" us_market | \n",
" NAS | \n",
"
\n",
" \n",
" WTRXX | \n",
" 100% Treasury Money Market Fund | \n",
" Wells Fargo Funds Trust | \n",
" USD | \n",
" us_market | \n",
" NAS | \n",
"
\n",
" \n",
" WUCXX | \n",
" Municipal Cash Management Money Market Fund | \n",
" Wells Fargo Advantage Money Market Funds | \n",
" USD | \n",
" us_market | \n",
" NAS | \n",
"
\n",
" \n",
"
\n",
"
1364 rows × 5 columns
\n",
"
"
],
"text/plain": [
" name \\\n",
"symbol \n",
"AABXX SEI Daily Income Trust Government Fund \n",
"AAFXX American Funds U.S. Government \n",
"AALXX Thrivent Money Market Fund \n",
"AAOXX American Beacon U.S. Government Money Market S... \n",
"AARXX AARP Money Market Fund \n",
"... ... \n",
"WRNXX Ivy Government Money Market Fund \n",
"WTLXX Treasury Plus Money Market Fund \n",
"WTPXX Treasury Plus Money Market Fund \n",
"WTRXX 100% Treasury Money Market Fund \n",
"WUCXX Municipal Cash Management Money Market Fund \n",
"\n",
" category currency market exchange \n",
"symbol \n",
"AABXX NaN USD us_market NAS \n",
"AAFXX NaN USD us_market NAS \n",
"AALXX Thrivent Mutual Funds USD us_market NAS \n",
"AAOXX NaN USD us_market NAS \n",
"AARXX NaN USD us_market NAS \n",
"... ... ... ... ... \n",
"WRNXX Ivy Funds USD us_market NAS \n",
"WTLXX Wells Fargo Funds Trust USD us_market NAS \n",
"WTPXX Wells Fargo Funds Trust USD us_market NAS \n",
"WTRXX Wells Fargo Funds Trust USD us_market NAS \n",
"WUCXX Wells Fargo Advantage Money Market Funds USD us_market NAS \n",
"\n",
"[1364 rows x 5 columns]"
]
},
"execution_count": 33,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"moneymarkets = fd.Moneymarkets()\n",
"\n",
"moneymarkets.select()"
]
},
{
"attachments": {},
"cell_type": "markdown",
"id": "d631d56f",
"metadata": {},
"source": [
"This returns approximately 3.000 different money markets. Find a more elaborate explanation with `help(fd.select_moneymarkets)`:\n"
]
},
{
"cell_type": "code",
"execution_count": 34,
"id": "6d29bfb7",
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"Help on method select in module financedatabase.Moneymarkets:\n",
"\n",
"select(category: str = '', capitalize: bool = True, exclude_exchanges: bool = True) -> pandas.core.frame.DataFrame method of financedatabase.Moneymarkets.Moneymarkets instance\n",
" Returns all moneymarkets when no input is given and has the option to give\n",
" a specific combination of moneymarkets based on the category defined.\n",
" \n",
" Args:\n",
" category (str, optional):\n",
" If filled, gives all data for a specific category. Default is an empty string.\n",
" capitalize (bool, optional):\n",
" Whether the category needs to be capitalized. Default is True.\n",
" exclude_exchanges (bool, optional):\n",
" Whether you want to exclude exchanges from the search. If False,\n",
" you will receive multiple times the product from different exchanges.\n",
" Default is True.\n",
" \n",
" Returns:\n",
" indices_df (pd.DataFrame):\n",
" Returns a DataFrame with a selection or all data based on the input.\n",
"\n"
]
}
],
"source": [
"help(moneymarkets.select)"
]
},
{
"cell_type": "code",
"execution_count": 35,
"id": "ed324026",
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"\n",
"\n",
"
\n",
" \n",
" \n",
" | \n",
" name | \n",
" category | \n",
" currency | \n",
" market | \n",
" exchange | \n",
"
\n",
" \n",
" symbol | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
"
\n",
" \n",
" \n",
" \n",
" GVIXX | \n",
" Government Money Market Fund | \n",
" Wells Fargo Funds Trust | \n",
" USD | \n",
" us_market | \n",
" NAS | \n",
"
\n",
" \n",
" MMIXX | \n",
" National Tax-Free Money Market Fund | \n",
" Wells Fargo Funds Trust | \n",
" USD | \n",
" us_market | \n",
" NAS | \n",
"
\n",
" \n",
" NWGXX | \n",
" Government Money Market Fund | \n",
" Wells Fargo Funds Trust | \n",
" USD | \n",
" us_market | \n",
" NAS | \n",
"
\n",
" \n",
" NWIXX | \n",
" Cash Investment Money Market Fund | \n",
" Wells Fargo Funds Trust | \n",
" USD | \n",
" us_market | \n",
" NAS | \n",
"
\n",
" \n",
" NWMXX | \n",
" National Tax-Free Money Market Fund | \n",
" Wells Fargo Funds Trust | \n",
" USD | \n",
" us_market | \n",
" NAS | \n",
"
\n",
" \n",
" NWTXX | \n",
" 100% Treasury Money Market Fund | \n",
" Wells Fargo Funds Trust | \n",
" USD | \n",
" us_market | \n",
" NAS | \n",
"
\n",
" \n",
" PISXX | \n",
" Treasury Plus Money Market Fund | \n",
" Wells Fargo Funds Trust | \n",
" USD | \n",
" us_market | \n",
" NAS | \n",
"
\n",
" \n",
" PIVXX | \n",
" Treasury Plus Money Market Fund | \n",
" Wells Fargo Funds Trust | \n",
" USD | \n",
" us_market | \n",
" NAS | \n",
"
\n",
" \n",
" PRVXX | \n",
" Treasury Plus Money Market Fund | \n",
" Wells Fargo Funds Trust | \n",
" USD | \n",
" us_market | \n",
" NAS | \n",
"
\n",
" \n",
" SHIXX | \n",
" Heritage Money Market Fund | \n",
" Wells Fargo Funds Trust | \n",
" USD | \n",
" us_market | \n",
" NAS | \n",
"
\n",
" \n",
" SHMXX | \n",
" Heritage Money Market Fund | \n",
" Wells Fargo Funds Trust | \n",
" USD | \n",
" us_market | \n",
" NAS | \n",
"
\n",
" \n",
" STGXX | \n",
" Money Market Fund | \n",
" Wells Fargo Funds Trust | \n",
" USD | \n",
" us_market | \n",
" NAS | \n",
"
\n",
" \n",
" WFAXX | \n",
" Cash Investment Money Market Fund | \n",
" Wells Fargo Funds Trust | \n",
" USD | \n",
" us_market | \n",
" NAS | \n",
"
\n",
" \n",
" WFFXX | \n",
" Government Money Market Fund | \n",
" Wells Fargo Funds Trust | \n",
" USD | \n",
" us_market | \n",
" NAS | \n",
"
\n",
" \n",
" WFGXX | \n",
" Government Money Market Fund | \n",
" Wells Fargo Funds Trust | \n",
" USD | \n",
" us_market | \n",
" NAS | \n",
"
\n",
" \n",
" WFIXX | \n",
" Cash Investment Money Market Fund | \n",
" Wells Fargo Funds Trust | \n",
" USD | \n",
" us_market | \n",
" NAS | \n",
"
\n",
" \n",
" WFJXX | \n",
" Heritage Money Market Fund | \n",
" Wells Fargo Funds Trust | \n",
" USD | \n",
" us_market | \n",
" NAS | \n",
"
\n",
" \n",
" WFNXX | \n",
" National Tax-Free Money Market Fund | \n",
" Wells Fargo Funds Trust | \n",
" USD | \n",
" us_market | \n",
" NAS | \n",
"
\n",
" \n",
" WFQXX | \n",
" Cash Investment Money Market Fund | \n",
" Wells Fargo Funds Trust | \n",
" USD | \n",
" us_market | \n",
" NAS | \n",
"
\n",
" \n",
" WFTXX | \n",
" 100% Treasury Money Market Fund | \n",
" Wells Fargo Funds Trust | \n",
" USD | \n",
" us_market | \n",
" NAS | \n",
"
\n",
" \n",
" WGAXX | \n",
" Government Money Market Fund | \n",
" Wells Fargo Funds Trust | \n",
" USD | \n",
" us_market | \n",
" NAS | \n",
"
\n",
" \n",
" WHTXX | \n",
" Heritage Money Market Fund | \n",
" Wells Fargo Funds Trust | \n",
" USD | \n",
" us_market | \n",
" NAS | \n",
"
\n",
" \n",
" WMOXX | \n",
" Money Market Fund | \n",
" Wells Fargo Funds Trust | \n",
" USD | \n",
" us_market | \n",
" NAS | \n",
"
\n",
" \n",
" WMPXX | \n",
" Money Market Fund | \n",
" Wells Fargo Funds Trust | \n",
" USD | \n",
" us_market | \n",
" NAS | \n",
"
\n",
" \n",
" WNTXX | \n",
" National Tax-Free Money Market Fund | \n",
" Wells Fargo Funds Trust | \n",
" USD | \n",
" us_market | \n",
" NAS | \n",
"
\n",
" \n",
" WOTXX | \n",
" 100% Treasury Money Market Fund | \n",
" Wells Fargo Funds Trust | \n",
" USD | \n",
" us_market | \n",
" NAS | \n",
"
\n",
" \n",
" WTLXX | \n",
" Treasury Plus Money Market Fund | \n",
" Wells Fargo Funds Trust | \n",
" USD | \n",
" us_market | \n",
" NAS | \n",
"
\n",
" \n",
" WTPXX | \n",
" Treasury Plus Money Market Fund | \n",
" Wells Fargo Funds Trust | \n",
" USD | \n",
" us_market | \n",
" NAS | \n",
"
\n",
" \n",
" WTRXX | \n",
" 100% Treasury Money Market Fund | \n",
" Wells Fargo Funds Trust | \n",
" USD | \n",
" us_market | \n",
" NAS | \n",
"
\n",
" \n",
"
\n",
"
"
],
"text/plain": [
" name category currency \\\n",
"symbol \n",
"GVIXX Government Money Market Fund Wells Fargo Funds Trust USD \n",
"MMIXX National Tax-Free Money Market Fund Wells Fargo Funds Trust USD \n",
"NWGXX Government Money Market Fund Wells Fargo Funds Trust USD \n",
"NWIXX Cash Investment Money Market Fund Wells Fargo Funds Trust USD \n",
"NWMXX National Tax-Free Money Market Fund Wells Fargo Funds Trust USD \n",
"NWTXX 100% Treasury Money Market Fund Wells Fargo Funds Trust USD \n",
"PISXX Treasury Plus Money Market Fund Wells Fargo Funds Trust USD \n",
"PIVXX Treasury Plus Money Market Fund Wells Fargo Funds Trust USD \n",
"PRVXX Treasury Plus Money Market Fund Wells Fargo Funds Trust USD \n",
"SHIXX Heritage Money Market Fund Wells Fargo Funds Trust USD \n",
"SHMXX Heritage Money Market Fund Wells Fargo Funds Trust USD \n",
"STGXX Money Market Fund Wells Fargo Funds Trust USD \n",
"WFAXX Cash Investment Money Market Fund Wells Fargo Funds Trust USD \n",
"WFFXX Government Money Market Fund Wells Fargo Funds Trust USD \n",
"WFGXX Government Money Market Fund Wells Fargo Funds Trust USD \n",
"WFIXX Cash Investment Money Market Fund Wells Fargo Funds Trust USD \n",
"WFJXX Heritage Money Market Fund Wells Fargo Funds Trust USD \n",
"WFNXX National Tax-Free Money Market Fund Wells Fargo Funds Trust USD \n",
"WFQXX Cash Investment Money Market Fund Wells Fargo Funds Trust USD \n",
"WFTXX 100% Treasury Money Market Fund Wells Fargo Funds Trust USD \n",
"WGAXX Government Money Market Fund Wells Fargo Funds Trust USD \n",
"WHTXX Heritage Money Market Fund Wells Fargo Funds Trust USD \n",
"WMOXX Money Market Fund Wells Fargo Funds Trust USD \n",
"WMPXX Money Market Fund Wells Fargo Funds Trust USD \n",
"WNTXX National Tax-Free Money Market Fund Wells Fargo Funds Trust USD \n",
"WOTXX 100% Treasury Money Market Fund Wells Fargo Funds Trust USD \n",
"WTLXX Treasury Plus Money Market Fund Wells Fargo Funds Trust USD \n",
"WTPXX Treasury Plus Money Market Fund Wells Fargo Funds Trust USD \n",
"WTRXX 100% Treasury Money Market Fund Wells Fargo Funds Trust USD \n",
"\n",
" market exchange \n",
"symbol \n",
"GVIXX us_market NAS \n",
"MMIXX us_market NAS \n",
"NWGXX us_market NAS \n",
"NWIXX us_market NAS \n",
"NWMXX us_market NAS \n",
"NWTXX us_market NAS \n",
"PISXX us_market NAS \n",
"PIVXX us_market NAS \n",
"PRVXX us_market NAS \n",
"SHIXX us_market NAS \n",
"SHMXX us_market NAS \n",
"STGXX us_market NAS \n",
"WFAXX us_market NAS \n",
"WFFXX us_market NAS \n",
"WFGXX us_market NAS \n",
"WFIXX us_market NAS \n",
"WFJXX us_market NAS \n",
"WFNXX us_market NAS \n",
"WFQXX us_market NAS \n",
"WFTXX us_market NAS \n",
"WGAXX us_market NAS \n",
"WHTXX us_market NAS \n",
"WMOXX us_market NAS \n",
"WMPXX us_market NAS \n",
"WNTXX us_market NAS \n",
"WOTXX us_market NAS \n",
"WTLXX us_market NAS \n",
"WTPXX us_market NAS \n",
"WTRXX us_market NAS "
]
},
"execution_count": 35,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"moneymarkets.select(category=\"Wells Fargo Funds Trust\")"
]
},
{
"attachments": {},
"cell_type": "markdown",
"id": "eb07e811",
"metadata": {},
"source": [
"# Searching the database in detail"
]
},
{
"attachments": {},
"cell_type": "markdown",
"id": "09b9fdd4",
"metadata": {},
"source": [
"All asset classes have the capability to search each column with `search`, for example `equities.search()`. Through how this functionality is developed you can define multiple columns and search throughoutly. For example:"
]
},
{
"cell_type": "code",
"execution_count": 36,
"id": "ea871d79",
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"\n",
"\n",
"
\n",
" \n",
" \n",
" | \n",
" name | \n",
" summary | \n",
" currency | \n",
" sector | \n",
" industry_group | \n",
" industry | \n",
" exchange | \n",
" market | \n",
" country | \n",
" state | \n",
" city | \n",
" zipcode | \n",
" website | \n",
" market_cap | \n",
" isin | \n",
" cusip | \n",
" figi | \n",
" composite_figi | \n",
" shareclass_figi | \n",
"
\n",
" \n",
" symbol | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
"
\n",
" \n",
" \n",
" \n",
" AFRMF | \n",
" Alphaform AG | \n",
" Alphaform AG, together with its subsidiaries, ... | \n",
" USD | \n",
" Industrials | \n",
" Capital Goods | \n",
" Machinery | \n",
" PNK | \n",
" OTC Bulletin Board | \n",
" Germany | \n",
" NaN | \n",
" Feldkirchen | \n",
" 85622 | \n",
" NaN | \n",
" Nano Cap | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
"
\n",
" \n",
" AUUMF | \n",
" Aumann AG | \n",
" Aumann AG manufactures and sells specialized m... | \n",
" USD | \n",
" Industrials | \n",
" Capital Goods | \n",
" Machinery | \n",
" PNK | \n",
" OTC Bulletin Board | \n",
" Germany | \n",
" NaN | \n",
" Beelen | \n",
" 48361 | \n",
" http://www.aumann.com | \n",
" Micro Cap | \n",
" DE000A2DAM03 | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
"
\n",
" \n",
" BAMXF | \n",
" Bayerische Motoren Werke Aktiengesellschaft | \n",
" Bayerische Motoren Werke AG, together with its... | \n",
" USD | \n",
" Consumer Discretionary | \n",
" Automobiles & Components | \n",
" Automobiles | \n",
" PNK | \n",
" OTC Bulletin Board | \n",
" Germany | \n",
" NaN | \n",
" Munich | \n",
" 80788 | \n",
" http://www.bmwgroup.com | \n",
" Large Cap | \n",
" DE0005190037 | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
"
\n",
" \n",
" BASFY | \n",
" BASF SE | \n",
" BASF SE operates as a chemical company worldwi... | \n",
" USD | \n",
" Materials | \n",
" Materials | \n",
" Chemicals | \n",
" PNK | \n",
" OTC Bulletin Board | \n",
" Germany | \n",
" NaN | \n",
" Ludwigshafen am Rhein | \n",
" 67056 | \n",
" http://www.basf.com | \n",
" Large Cap | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
"
\n",
" \n",
" BDRFF | \n",
" Beiersdorf Aktiengesellschaft | \n",
" Beiersdorf Aktiengesellschaft engages in the m... | \n",
" USD | \n",
" Consumer Staples | \n",
" Household & Personal Products | \n",
" Household Products | \n",
" PNK | \n",
" OTC Bulletin Board | \n",
" Germany | \n",
" NaN | \n",
" Hamburg | \n",
" 20245 | \n",
" http://www.beiersdorf.com | \n",
" Large Cap | \n",
" US07724U1034 | \n",
" 07724U103 | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
"
\n",
" \n",
" BDRFY | \n",
" Beiersdorf Aktiengesellschaft | \n",
" Beiersdorf Aktiengesellschaft engages in the m... | \n",
" USD | \n",
" Consumer Staples | \n",
" Household & Personal Products | \n",
" Household Products | \n",
" PNK | \n",
" OTC Bulletin Board | \n",
" Germany | \n",
" NaN | \n",
" Hamburg | \n",
" 20245 | \n",
" http://www.beiersdorf.com | \n",
" Large Cap | \n",
" US07724U1034 | \n",
" 07724U103 | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
"
\n",
" \n",
" BFFAF | \n",
" BASF SE | \n",
" BASF SE operates as a chemical company worldwi... | \n",
" USD | \n",
" Materials | \n",
" Materials | \n",
" Chemicals | \n",
" PNK | \n",
" OTC Bulletin Board | \n",
" Germany | \n",
" NaN | \n",
" Ludwigshafen am Rhein | \n",
" 67056 | \n",
" http://www.basf.com | \n",
" Large Cap | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
"
\n",
" \n",
" BMWYY | \n",
" Bayerische Motoren Werke Aktiengesellschaft | \n",
" Bayerische Motoren Werke AG, together with its... | \n",
" USD | \n",
" Consumer Discretionary | \n",
" Automobiles & Components | \n",
" Automobiles | \n",
" PNK | \n",
" OTC Bulletin Board | \n",
" Germany | \n",
" NaN | \n",
" Munich | \n",
" 80788 | \n",
" http://www.bmwgroup.com | \n",
" Large Cap | \n",
" DE0005190037 | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
"
\n",
" \n",
" BYMOF | \n",
" Bayerische Motoren Werke Aktiengesellschaft | \n",
" Bayerische Motoren Werke AG, together with its... | \n",
" USD | \n",
" Consumer Discretionary | \n",
" Automobiles & Components | \n",
" Automobiles | \n",
" PNK | \n",
" OTC Bulletin Board | \n",
" Germany | \n",
" NaN | \n",
" Munich | \n",
" 80788 | \n",
" http://www.bmwgroup.com | \n",
" Large Cap | \n",
" DE0005190037 | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
"
\n",
" \n",
" COVTY | \n",
" Covestro AG | \n",
" Covestro AG develops, produces, and markets po... | \n",
" USD | \n",
" Materials | \n",
" Materials | \n",
" Chemicals | \n",
" PNK | \n",
" OTC Bulletin Board | \n",
" Germany | \n",
" NaN | \n",
" Leverkusen | \n",
" 51373 | \n",
" http://www.covestro.com | \n",
" Large Cap | \n",
" DE0006062144 | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
"
\n",
" \n",
" CTTAF | \n",
" Continental Aktiengesellschaft | \n",
" Continental Aktiengesellschaft develops produc... | \n",
" USD | \n",
" Consumer Discretionary | \n",
" Automobiles & Components | \n",
" Auto Components | \n",
" PNK | \n",
" OTC Bulletin Board | \n",
" Germany | \n",
" NaN | \n",
" Hanover | \n",
" 30165 | \n",
" http://www.continental.com | \n",
" Large Cap | \n",
" US2107712000 | \n",
" 210771200 | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
"
\n",
" \n",
" CTTAY | \n",
" Continental Aktiengesellschaft | \n",
" Continental Aktiengesellschaft develops produc... | \n",
" USD | \n",
" Consumer Discretionary | \n",
" Automobiles & Components | \n",
" Auto Components | \n",
" PNK | \n",
" OTC Bulletin Board | \n",
" Germany | \n",
" NaN | \n",
" Hanover | \n",
" 30165 | \n",
" http://www.continental.com | \n",
" Large Cap | \n",
" US2107712000 | \n",
" 210771200 | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
"
\n",
" \n",
" CVVTF | \n",
" Covestro AG | \n",
" Covestro AG develops, produces, and markets po... | \n",
" USD | \n",
" Materials | \n",
" Materials | \n",
" Chemicals | \n",
" PNK | \n",
" OTC Bulletin Board | \n",
" Germany | \n",
" NaN | \n",
" Leverkusen | \n",
" 51373 | \n",
" http://www.covestro.com | \n",
" Large Cap | \n",
" DE0006062144 | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
"
\n",
" \n",
" DDAIF | \n",
" Daimler AG | \n",
" Daimler AG, together its subsidiaries, develop... | \n",
" USD | \n",
" Consumer Discretionary | \n",
" Automobiles & Components | \n",
" Automobiles | \n",
" PNK | \n",
" OTC Bulletin Board | \n",
" Germany | \n",
" NaN | \n",
" Stuttgart | \n",
" 70372 | \n",
" http://www.daimler.com | \n",
" Large Cap | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
"
\n",
" \n",
" DMLRY | \n",
" Daimler AG | \n",
" Daimler AG, together its subsidiaries, develop... | \n",
" USD | \n",
" Consumer Discretionary | \n",
" Automobiles & Components | \n",
" Automobiles | \n",
" PNK | \n",
" OTC Bulletin Board | \n",
" Germany | \n",
" NaN | \n",
" Stuttgart | \n",
" 70372 | \n",
" http://www.daimler.com | \n",
" Large Cap | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
"
\n",
" \n",
" DUERF | \n",
" Durr Aktiengesellschaft | \n",
" Dürr Aktiengesellschaft, together with its ... | \n",
" USD | \n",
" Industrials | \n",
" Capital Goods | \n",
" Machinery | \n",
" PNK | \n",
" OTC Bulletin Board | \n",
" Germany | \n",
" NaN | \n",
" Bietigheim-Bissingen | \n",
" 74321 | \n",
" http://www.durr-group.com | \n",
" Mid Cap | \n",
" US2668881061 | \n",
" 266888106 | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
"
\n",
" \n",
" DURYY | \n",
" Durr Aktiengesellschaft | \n",
" Dürr Aktiengesellschaft, together with its ... | \n",
" USD | \n",
" Industrials | \n",
" Capital Goods | \n",
" Machinery | \n",
" PNK | \n",
" OTC Bulletin Board | \n",
" Germany | \n",
" NaN | \n",
" Bietigheim-Bissingen | \n",
" 74321 | \n",
" http://www.durr-group.com | \n",
" Mid Cap | \n",
" US2668881061 | \n",
" 266888106 | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
"
\n",
" \n",
" EGKLF | \n",
" ElringKlinger AG | \n",
" ElringKlinger AG develops, manufactures, and d... | \n",
" USD | \n",
" Consumer Discretionary | \n",
" Automobiles & Components | \n",
" Auto Components | \n",
" PNK | \n",
" OTC Bulletin Board | \n",
" Germany | \n",
" NaN | \n",
" Dettingen an der Erms | \n",
" 72581 | \n",
" http://www.elringklinger.com | \n",
" Small Cap | \n",
" US2901591022 | \n",
" 290159102 | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
"
\n",
" \n",
" ELLRY | \n",
" ElringKlinger AG | \n",
" ElringKlinger AG develops, manufactures, and d... | \n",
" USD | \n",
" Consumer Discretionary | \n",
" Automobiles & Components | \n",
" Auto Components | \n",
" PNK | \n",
" OTC Bulletin Board | \n",
" Germany | \n",
" NaN | \n",
" Dettingen an der Erms | \n",
" 72581 | \n",
" http://www.elringklinger.com | \n",
" Small Cap | \n",
" US2901591022 | \n",
" 290159102 | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
"
\n",
" \n",
" EVKIF | \n",
" Evonik Industries AG | \n",
" Evonik Industries AG engages in the specialty ... | \n",
" USD | \n",
" Materials | \n",
" Materials | \n",
" Chemicals | \n",
" PNK | \n",
" OTC Bulletin Board | \n",
" Germany | \n",
" NaN | \n",
" Essen | \n",
" 45128 | \n",
" http://corporate.evonik.com/en/ | \n",
" Large Cap | \n",
" US3005031097 | \n",
" 300503109 | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
"
\n",
" \n",
" EVKIY | \n",
" Evonik Industries AG | \n",
" Evonik Industries AG engages in the specialty ... | \n",
" USD | \n",
" Materials | \n",
" Materials | \n",
" Chemicals | \n",
" PNK | \n",
" OTC Bulletin Board | \n",
" Germany | \n",
" NaN | \n",
" Essen | \n",
" 45128 | \n",
" http://corporate.evonik.com/en/ | \n",
" Large Cap | \n",
" US3005031097 | \n",
" 300503109 | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
"
\n",
" \n",
" FUPBY | \n",
" Fuchs Petrolub SE | \n",
" Fuchs Petrolub SE develops, produces, and sell... | \n",
" USD | \n",
" Materials | \n",
" Materials | \n",
" Chemicals | \n",
" PNK | \n",
" OTC Bulletin Board | \n",
" Germany | \n",
" NaN | \n",
" Mannheim | \n",
" 68169 | \n",
" http://www.fuchs.com/group | \n",
" Mid Cap | \n",
" DE000A3E5D64 | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
"
\n",
" \n",
" FUPEF | \n",
" Fuchs Petrolub SE | \n",
" Fuchs Petrolub SE develops, produces, and sell... | \n",
" USD | \n",
" Materials | \n",
" Materials | \n",
" Chemicals | \n",
" PNK | \n",
" OTC Bulletin Board | \n",
" Germany | \n",
" NaN | \n",
" Mannheim | \n",
" 68169 | \n",
" http://www.fuchs.com/group | \n",
" Mid Cap | \n",
" DE000A3E5D64 | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
"
\n",
" \n",
" FUPPF | \n",
" Fuchs Petrolub SE | \n",
" Fuchs Petrolub SE develops, produces, and sell... | \n",
" USD | \n",
" Materials | \n",
" Materials | \n",
" Chemicals | \n",
" PNK | \n",
" OTC Bulletin Board | \n",
" Germany | \n",
" NaN | \n",
" Mannheim | \n",
" 68169 | \n",
" http://www.fuchs.com/group | \n",
" Mid Cap | \n",
" DE000A3E5D64 | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
"
\n",
" \n",
" HELKF | \n",
" Henkel AG & Co. KGaA | \n",
" Henkel AG & Co. KGaA, together with its subsid... | \n",
" USD | \n",
" Consumer Staples | \n",
" Household & Personal Products | \n",
" Household Products | \n",
" PNK | \n",
" OTC Bulletin Board | \n",
" Germany | \n",
" NaN | \n",
" Dusseldorf | \n",
" 40589 | \n",
" http://www.henkel.com | \n",
" Large Cap | \n",
" US42550U2087 | \n",
" 42550U208 | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
"
\n",
" \n",
" HENKY | \n",
" Henkel AG & Co. KGaA | \n",
" Henkel AG & Co. KGaA, together with its subsid... | \n",
" USD | \n",
" Consumer Staples | \n",
" Household & Personal Products | \n",
" Household Products | \n",
" PNK | \n",
" OTC Bulletin Board | \n",
" Germany | \n",
" NaN | \n",
" Dusseldorf | \n",
" 40589 | \n",
" http://www.henkel.com | \n",
" Large Cap | \n",
" US42550U2087 | \n",
" 42550U208 | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
"
\n",
" \n",
" HENOF | \n",
" Henkel AG & Co. KGaA | \n",
" Henkel AG & Co. KGaA, together with its subsid... | \n",
" USD | \n",
" Consumer Staples | \n",
" Household & Personal Products | \n",
" Household Products | \n",
" PNK | \n",
" OTC Bulletin Board | \n",
" Germany | \n",
" NaN | \n",
" Dusseldorf | \n",
" 40589 | \n",
" http://www.henkel.com | \n",
" Large Cap | \n",
" US42550U2087 | \n",
" 42550U208 | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
"
\n",
" \n",
" HENOY | \n",
" Henkel AG & Co. KGaA | \n",
" Henkel AG & Co. KGaA, together with its subsid... | \n",
" USD | \n",
" Consumer Staples | \n",
" Household & Personal Products | \n",
" Household Products | \n",
" PNK | \n",
" OTC Bulletin Board | \n",
" Germany | \n",
" NaN | \n",
" Dusseldorf | \n",
" 40589 | \n",
" http://www.henkel.com | \n",
" Large Cap | \n",
" US42550U2087 | \n",
" 42550U208 | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
"
\n",
" \n",
" HLKHF | \n",
" HELLA GmbH & Co. KGaA | \n",
" HELLA GmbH & Co. KGaA, together with its subsi... | \n",
" USD | \n",
" Consumer Discretionary | \n",
" Automobiles & Components | \n",
" Auto Components | \n",
" PNK | \n",
" OTC Bulletin Board | \n",
" Germany | \n",
" NaN | \n",
" Lippstadt | \n",
" 59552 | \n",
" http://www.hella.com | \n",
" Mid Cap | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
"
\n",
" \n",
" HLLGY | \n",
" HELLA GmbH & Co. KGaA | \n",
" HELLA GmbH & Co. KGaA, together with its subsi... | \n",
" USD | \n",
" Consumer Discretionary | \n",
" Automobiles & Components | \n",
" Auto Components | \n",
" PNK | \n",
" OTC Bulletin Board | \n",
" Germany | \n",
" NaN | \n",
" Lippstadt | \n",
" 59552 | \n",
" http://www.hella.com | \n",
" Mid Cap | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
"
\n",
" \n",
" IFNNF | \n",
" Infineon Technologies AG | \n",
" Infineon Technologies AG designs, develops, ma... | \n",
" USD | \n",
" Information Technology | \n",
" Semiconductors & Semiconductor Equipment | \n",
" Semiconductors & Semiconductor Equipment | \n",
" PNK | \n",
" OTC Bulletin Board | \n",
" Germany | \n",
" NaN | \n",
" Munich | \n",
" 85579 | \n",
" http://www.infineon.com | \n",
" Large Cap | \n",
" US45662N1037 | \n",
" 45662N103 | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
"
\n",
" \n",
" IFNNY | \n",
" Infineon Technologies AG | \n",
" Infineon Technologies AG designs, develops, ma... | \n",
" USD | \n",
" Information Technology | \n",
" Semiconductors & Semiconductor Equipment | \n",
" Semiconductors & Semiconductor Equipment | \n",
" PNK | \n",
" OTC Bulletin Board | \n",
" Germany | \n",
" NaN | \n",
" Munich | \n",
" 85579 | \n",
" http://www.infineon.com | \n",
" Large Cap | \n",
" US45662N1037 | \n",
" 45662N103 | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
"
\n",
" \n",
" KUKAF | \n",
" KUKA Aktiengesellschaft | \n",
" KUKA Aktiengesellschaft, an automation company... | \n",
" USD | \n",
" Industrials | \n",
" Capital Goods | \n",
" Machinery | \n",
" PNK | \n",
" OTC Bulletin Board | \n",
" Germany | \n",
" NaN | \n",
" Augsburg | \n",
" 86165 | \n",
" http://www.kuka.com | \n",
" Mid Cap | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
"
\n",
" \n",
" KUKAY | \n",
" KUKA Aktiengesellschaft | \n",
" KUKA Aktiengesellschaft, an automation company... | \n",
" USD | \n",
" Industrials | \n",
" Capital Goods | \n",
" Machinery | \n",
" PNK | \n",
" OTC Bulletin Board | \n",
" Germany | \n",
" NaN | \n",
" Augsburg | \n",
" 86165 | \n",
" http://www.kuka.com | \n",
" Mid Cap | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
"
\n",
" \n",
" LNNNY | \n",
" LEONI AG | \n",
" LEONI AG, together with its subsidiaries, prov... | \n",
" USD | \n",
" Industrials | \n",
" Capital Goods | \n",
" Electrical Equipment | \n",
" PNK | \n",
" OTC Bulletin Board | \n",
" Germany | \n",
" NaN | \n",
" Nuremberg | \n",
" 90402 | \n",
" http://www.leoni.com | \n",
" Small Cap | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
"
\n",
" \n",
" LNXSF | \n",
" LANXESS Aktiengesellschaft | \n",
" LANXESS Aktiengesellschaft, a specialty chemic... | \n",
" USD | \n",
" Materials | \n",
" Materials | \n",
" Chemicals | \n",
" PNK | \n",
" OTC Bulletin Board | \n",
" Germany | \n",
" NaN | \n",
" Cologne | \n",
" 50569 | \n",
" http://lanxess.com | \n",
" Mid Cap | \n",
" US5165571051 | \n",
" 516557105 | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
"
\n",
" \n",
" LNXSY | \n",
" LANXESS Aktiengesellschaft | \n",
" LANXESS Aktiengesellschaft, a specialty chemic... | \n",
" USD | \n",
" Materials | \n",
" Materials | \n",
" Chemicals | \n",
" PNK | \n",
" OTC Bulletin Board | \n",
" Germany | \n",
" NaN | \n",
" Cologne | \n",
" 50569 | \n",
" http://lanxess.com | \n",
" Mid Cap | \n",
" US5165571051 | \n",
" 516557105 | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
"
\n",
" \n",
" LPKFF | \n",
" LPKF Laser & Electronics AG | \n",
" LPKF Laser & Electronics AG, together with its... | \n",
" USD | \n",
" Industrials | \n",
" Capital Goods | \n",
" Machinery | \n",
" PNK | \n",
" OTC Bulletin Board | \n",
" Germany | \n",
" NaN | \n",
" Garbsen | \n",
" 30827 | \n",
" http://www.lpkf.com | \n",
" Small Cap | \n",
" DE0006450000 | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
"
\n",
" \n",
" MKGAF | \n",
" MERCK Kommanditgesellschaft auf Aktien | \n",
" MERCK Kommanditgesellschaft auf Aktien operate... | \n",
" USD | \n",
" Health Care | \n",
" Pharmaceuticals, Biotechnology & Life Sciences | \n",
" Pharmaceuticals | \n",
" PNK | \n",
" OTC Bulletin Board | \n",
" Germany | \n",
" NaN | \n",
" Darmstadt | \n",
" 64293 | \n",
" http://www.merckgroup.com | \n",
" Large Cap | \n",
" US5893392093 | \n",
" 589339209 | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
"
\n",
" \n",
" MKKGY | \n",
" MERCK Kommanditgesellschaft auf Aktien | \n",
" MERCK Kommanditgesellschaft auf Aktien operate... | \n",
" USD | \n",
" Health Care | \n",
" Pharmaceuticals, Biotechnology & Life Sciences | \n",
" Pharmaceuticals | \n",
" PNK | \n",
" OTC Bulletin Board | \n",
" Germany | \n",
" NaN | \n",
" Darmstadt | \n",
" 64293 | \n",
" http://www.merckgroup.com | \n",
" Large Cap | \n",
" US5893392093 | \n",
" 589339209 | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
"
\n",
" \n",
" NGRRF | \n",
" Nagarro SE | \n",
" Nagarro SE, a digital engineering company, pro... | \n",
" USD | \n",
" Information Technology | \n",
" Software & Services | \n",
" IT Services | \n",
" PNK | \n",
" OTC Bulletin Board | \n",
" Germany | \n",
" NaN | \n",
" Munich | \n",
" 81677 | \n",
" http://www.nagarro.com | \n",
" Small Cap | \n",
" DE000A3H2200 | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
"
\n",
" \n",
" OSAGF | \n",
" OSRAM Licht AG | \n",
" OSRAM Licht AG provides various lighting produ... | \n",
" USD | \n",
" Industrials | \n",
" Capital Goods | \n",
" Electrical Equipment | \n",
" PNK | \n",
" OTC Bulletin Board | \n",
" Germany | \n",
" NaN | \n",
" Munich | \n",
" 80807 | \n",
" http://www.osram-group.com | \n",
" Mid Cap | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
"
\n",
" \n",
" OSAGY | \n",
" OSRAM Licht AG | \n",
" OSRAM Licht AG provides various lighting produ... | \n",
" USD | \n",
" Industrials | \n",
" Capital Goods | \n",
" Electrical Equipment | \n",
" PNK | \n",
" OTC Bulletin Board | \n",
" Germany | \n",
" NaN | \n",
" Munich | \n",
" 80807 | \n",
" http://www.osram-group.com | \n",
" Mid Cap | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
"
\n",
" \n",
" PSSWF | \n",
" PSI Software AG | \n",
" PSI Software AG develops and sells software sy... | \n",
" USD | \n",
" Information Technology | \n",
" Software & Services | \n",
" Software | \n",
" PNK | \n",
" OTC Bulletin Board | \n",
" Germany | \n",
" NaN | \n",
" Berlin | \n",
" 10178 | \n",
" http://www.psi.de | \n",
" Small Cap | \n",
" DE000A0Z1JH9 | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
"
\n",
" \n",
" SCFLF | \n",
" Schaeffler AG | \n",
" Schaeffler AG, together with its subsidiaries,... | \n",
" USD | \n",
" Consumer Discretionary | \n",
" Automobiles & Components | \n",
" Auto Components | \n",
" PNK | \n",
" OTC Bulletin Board | \n",
" Germany | \n",
" NaN | \n",
" Herzogenaurach | \n",
" 91074 | \n",
" http://www.schaeffler.com | \n",
" Mid Cap | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
"
\n",
" \n",
" SFFLY | \n",
" Schaeffler AG | \n",
" Schaeffler AG, together with its subsidiaries,... | \n",
" USD | \n",
" Consumer Discretionary | \n",
" Automobiles & Components | \n",
" Auto Components | \n",
" PNK | \n",
" OTC Bulletin Board | \n",
" Germany | \n",
" NaN | \n",
" Herzogenaurach | \n",
" 91074 | \n",
" http://www.schaeffler.com | \n",
" Mid Cap | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
"
\n",
" \n",
" SGLFF | \n",
" SGL Carbon SE | \n",
" SGL Carbon SE engages in the manufacture and s... | \n",
" USD | \n",
" Materials | \n",
" Materials | \n",
" Chemicals | \n",
" PNK | \n",
" OTC Bulletin Board | \n",
" Germany | \n",
" NaN | \n",
" Wiesbaden | \n",
" 65201 | \n",
" http://www.sglcarbon.com | \n",
" Small Cap | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
"
\n",
" \n",
" SLGRF | \n",
" SLM Solutions Group AG | \n",
" SLM Solutions Group AG provides metal-based ad... | \n",
" USD | \n",
" Industrials | \n",
" Capital Goods | \n",
" Machinery | \n",
" PNK | \n",
" OTC Bulletin Board | \n",
" Germany | \n",
" NaN | \n",
" Lubeck | \n",
" 23560 | \n",
" http://www.slm-solutions.com | \n",
" Small Cap | \n",
" DE000A111338 | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
"
\n",
" \n",
" SZGPY | \n",
" Salzgitter AG | \n",
" Salzgitter AG, together with its subsidiaries,... | \n",
" USD | \n",
" Materials | \n",
" Materials | \n",
" Metals & Mining | \n",
" PNK | \n",
" OTC Bulletin Board | \n",
" Germany | \n",
" NaN | \n",
" Salzgitter | \n",
" 38239 | \n",
" http://www.salzgitter-ag.com | \n",
" Small Cap | \n",
" US7958422021 | \n",
" 795842202 | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
"
\n",
" \n",
" TKAMY | \n",
" thyssenkrupp AG | \n",
" thyssenkrupp AG operates in the areas of autom... | \n",
" USD | \n",
" Industrials | \n",
" Capital Goods | \n",
" Building Products | \n",
" PNK | \n",
" OTC Bulletin Board | \n",
" Germany | \n",
" NaN | \n",
" Essen | \n",
" 45143 | \n",
" http://www.thyssenkrupp.com | \n",
" Mid Cap | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
"
\n",
" \n",
" TYEKF | \n",
" thyssenkrupp AG | \n",
" thyssenkrupp AG operates in the areas of autom... | \n",
" USD | \n",
" Industrials | \n",
" Capital Goods | \n",
" Building Products | \n",
" PNK | \n",
" OTC Bulletin Board | \n",
" Germany | \n",
" NaN | \n",
" Essen | \n",
" 45143 | \n",
" http://www.thyssenkrupp.com | \n",
" Mid Cap | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
"
\n",
" \n",
" VIAO | \n",
" VIA optronics AG | \n",
" VIA optronics AG, through its subsidiary, VIA ... | \n",
" USD | \n",
" Information Technology | \n",
" Technology Hardware & Equipment | \n",
" Electronic Equipment, Instruments & Components | \n",
" NYQ | \n",
" New York Stock Exchange | \n",
" Germany | \n",
" NaN | \n",
" Nuremberg | \n",
" 90411 | \n",
" http://www.via-optronics.com | \n",
" Nano Cap | \n",
" US91823Y1091 | \n",
" 91823Y109 | \n",
" BBG00X5F6PX0 | \n",
" BBG00X5F6PS6 | \n",
" BBG00X5F6QP7 | \n",
"
\n",
" \n",
" VJET | \n",
" voxeljet AG | \n",
" voxeljet AG provides three-dimensional (3D) pr... | \n",
" USD | \n",
" Information Technology | \n",
" Technology Hardware & Equipment | \n",
" Technology Hardware, Storage & Peripherals | \n",
" NCM | \n",
" NASDAQ Capital Market | \n",
" Germany | \n",
" NaN | \n",
" Friedberg | \n",
" 86316 | \n",
" http://www.voxeljet.com | \n",
" Nano Cap | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
"
\n",
" \n",
" WKCMF | \n",
" Wacker Chemie AG | \n",
" Wacker Chemie AG provides chemical products wo... | \n",
" USD | \n",
" Materials | \n",
" Materials | \n",
" Chemicals | \n",
" PNK | \n",
" OTC Bulletin Board | \n",
" Germany | \n",
" NaN | \n",
" Munich | \n",
" 81737 | \n",
" http://www.wacker.com | \n",
" Mid Cap | \n",
" DE000WCH8881 | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
" NaN | \n",
"
\n",
" \n",
"
\n",
"
"
],
"text/plain": [
" name \\\n",
"symbol \n",
"AFRMF Alphaform AG \n",
"AUUMF Aumann AG \n",
"BAMXF Bayerische Motoren Werke Aktiengesellschaft \n",
"BASFY BASF SE \n",
"BDRFF Beiersdorf Aktiengesellschaft \n",
"BDRFY Beiersdorf Aktiengesellschaft \n",
"BFFAF BASF SE \n",
"BMWYY Bayerische Motoren Werke Aktiengesellschaft \n",
"BYMOF Bayerische Motoren Werke Aktiengesellschaft \n",
"COVTY Covestro AG \n",
"CTTAF Continental Aktiengesellschaft \n",
"CTTAY Continental Aktiengesellschaft \n",
"CVVTF Covestro AG \n",
"DDAIF Daimler AG \n",
"DMLRY Daimler AG \n",
"DUERF Durr Aktiengesellschaft \n",
"DURYY Durr Aktiengesellschaft \n",
"EGKLF ElringKlinger AG \n",
"ELLRY ElringKlinger AG \n",
"EVKIF Evonik Industries AG \n",
"EVKIY Evonik Industries AG \n",
"FUPBY Fuchs Petrolub SE \n",
"FUPEF Fuchs Petrolub SE \n",
"FUPPF Fuchs Petrolub SE \n",
"HELKF Henkel AG & Co. KGaA \n",
"HENKY Henkel AG & Co. KGaA \n",
"HENOF Henkel AG & Co. KGaA \n",
"HENOY Henkel AG & Co. KGaA \n",
"HLKHF HELLA GmbH & Co. KGaA \n",
"HLLGY HELLA GmbH & Co. KGaA \n",
"IFNNF Infineon Technologies AG \n",
"IFNNY Infineon Technologies AG \n",
"KUKAF KUKA Aktiengesellschaft \n",
"KUKAY KUKA Aktiengesellschaft \n",
"LNNNY LEONI AG \n",
"LNXSF LANXESS Aktiengesellschaft \n",
"LNXSY LANXESS Aktiengesellschaft \n",
"LPKFF LPKF Laser & Electronics AG \n",
"MKGAF MERCK Kommanditgesellschaft auf Aktien \n",
"MKKGY MERCK Kommanditgesellschaft auf Aktien \n",
"NGRRF Nagarro SE \n",
"OSAGF OSRAM Licht AG \n",
"OSAGY OSRAM Licht AG \n",
"PSSWF PSI Software AG \n",
"SCFLF Schaeffler AG \n",
"SFFLY Schaeffler AG \n",
"SGLFF SGL Carbon SE \n",
"SLGRF SLM Solutions Group AG \n",
"SZGPY Salzgitter AG \n",
"TKAMY thyssenkrupp AG \n",
"TYEKF thyssenkrupp AG \n",
"VIAO VIA optronics AG \n",
"VJET voxeljet AG \n",
"WKCMF Wacker Chemie AG \n",
"\n",
" summary currency \\\n",
"symbol \n",
"AFRMF Alphaform AG, together with its subsidiaries, ... USD \n",
"AUUMF Aumann AG manufactures and sells specialized m... USD \n",
"BAMXF Bayerische Motoren Werke AG, together with its... USD \n",
"BASFY BASF SE operates as a chemical company worldwi... USD \n",
"BDRFF Beiersdorf Aktiengesellschaft engages in the m... USD \n",
"BDRFY Beiersdorf Aktiengesellschaft engages in the m... USD \n",
"BFFAF BASF SE operates as a chemical company worldwi... USD \n",
"BMWYY Bayerische Motoren Werke AG, together with its... USD \n",
"BYMOF Bayerische Motoren Werke AG, together with its... USD \n",
"COVTY Covestro AG develops, produces, and markets po... USD \n",
"CTTAF Continental Aktiengesellschaft develops produc... USD \n",
"CTTAY Continental Aktiengesellschaft develops produc... USD \n",
"CVVTF Covestro AG develops, produces, and markets po... USD \n",
"DDAIF Daimler AG, together its subsidiaries, develop... USD \n",
"DMLRY Daimler AG, together its subsidiaries, develop... USD \n",
"DUERF Dürr Aktiengesellschaft, together with its ... USD \n",
"DURYY Dürr Aktiengesellschaft, together with its ... USD \n",
"EGKLF ElringKlinger AG develops, manufactures, and d... USD \n",
"ELLRY ElringKlinger AG develops, manufactures, and d... USD \n",
"EVKIF Evonik Industries AG engages in the specialty ... USD \n",
"EVKIY Evonik Industries AG engages in the specialty ... USD \n",
"FUPBY Fuchs Petrolub SE develops, produces, and sell... USD \n",
"FUPEF Fuchs Petrolub SE develops, produces, and sell... USD \n",
"FUPPF Fuchs Petrolub SE develops, produces, and sell... USD \n",
"HELKF Henkel AG & Co. KGaA, together with its subsid... USD \n",
"HENKY Henkel AG & Co. KGaA, together with its subsid... USD \n",
"HENOF Henkel AG & Co. KGaA, together with its subsid... USD \n",
"HENOY Henkel AG & Co. KGaA, together with its subsid... USD \n",
"HLKHF HELLA GmbH & Co. KGaA, together with its subsi... USD \n",
"HLLGY HELLA GmbH & Co. KGaA, together with its subsi... USD \n",
"IFNNF Infineon Technologies AG designs, develops, ma... USD \n",
"IFNNY Infineon Technologies AG designs, develops, ma... USD \n",
"KUKAF KUKA Aktiengesellschaft, an automation company... USD \n",
"KUKAY KUKA Aktiengesellschaft, an automation company... USD \n",
"LNNNY LEONI AG, together with its subsidiaries, prov... USD \n",
"LNXSF LANXESS Aktiengesellschaft, a specialty chemic... USD \n",
"LNXSY LANXESS Aktiengesellschaft, a specialty chemic... USD \n",
"LPKFF LPKF Laser & Electronics AG, together with its... USD \n",
"MKGAF MERCK Kommanditgesellschaft auf Aktien operate... USD \n",
"MKKGY MERCK Kommanditgesellschaft auf Aktien operate... USD \n",
"NGRRF Nagarro SE, a digital engineering company, pro... USD \n",
"OSAGF OSRAM Licht AG provides various lighting produ... USD \n",
"OSAGY OSRAM Licht AG provides various lighting produ... USD \n",
"PSSWF PSI Software AG develops and sells software sy... USD \n",
"SCFLF Schaeffler AG, together with its subsidiaries,... USD \n",
"SFFLY Schaeffler AG, together with its subsidiaries,... USD \n",
"SGLFF SGL Carbon SE engages in the manufacture and s... USD \n",
"SLGRF SLM Solutions Group AG provides metal-based ad... USD \n",
"SZGPY Salzgitter AG, together with its subsidiaries,... USD \n",
"TKAMY thyssenkrupp AG operates in the areas of autom... USD \n",
"TYEKF thyssenkrupp AG operates in the areas of autom... USD \n",
"VIAO VIA optronics AG, through its subsidiary, VIA ... USD \n",
"VJET voxeljet AG provides three-dimensional (3D) pr... USD \n",
"WKCMF Wacker Chemie AG provides chemical products wo... USD \n",
"\n",
" sector \\\n",
"symbol \n",
"AFRMF Industrials \n",
"AUUMF Industrials \n",
"BAMXF Consumer Discretionary \n",
"BASFY Materials \n",
"BDRFF Consumer Staples \n",
"BDRFY Consumer Staples \n",
"BFFAF Materials \n",
"BMWYY Consumer Discretionary \n",
"BYMOF Consumer Discretionary \n",
"COVTY Materials \n",
"CTTAF Consumer Discretionary \n",
"CTTAY Consumer Discretionary \n",
"CVVTF Materials \n",
"DDAIF Consumer Discretionary \n",
"DMLRY Consumer Discretionary \n",
"DUERF Industrials \n",
"DURYY Industrials \n",
"EGKLF Consumer Discretionary \n",
"ELLRY Consumer Discretionary \n",
"EVKIF Materials \n",
"EVKIY Materials \n",
"FUPBY Materials \n",
"FUPEF Materials \n",
"FUPPF Materials \n",
"HELKF Consumer Staples \n",
"HENKY Consumer Staples \n",
"HENOF Consumer Staples \n",
"HENOY Consumer Staples \n",
"HLKHF Consumer Discretionary \n",
"HLLGY Consumer Discretionary \n",
"IFNNF Information Technology \n",
"IFNNY Information Technology \n",
"KUKAF Industrials \n",
"KUKAY Industrials \n",
"LNNNY Industrials \n",
"LNXSF Materials \n",
"LNXSY Materials \n",
"LPKFF Industrials \n",
"MKGAF Health Care \n",
"MKKGY Health Care \n",
"NGRRF Information Technology \n",
"OSAGF Industrials \n",
"OSAGY Industrials \n",
"PSSWF Information Technology \n",
"SCFLF Consumer Discretionary \n",
"SFFLY Consumer Discretionary \n",
"SGLFF Materials \n",
"SLGRF Industrials \n",
"SZGPY Materials \n",
"TKAMY Industrials \n",
"TYEKF Industrials \n",
"VIAO Information Technology \n",
"VJET Information Technology \n",
"WKCMF Materials \n",
"\n",
" industry_group \\\n",
"symbol \n",
"AFRMF Capital Goods \n",
"AUUMF Capital Goods \n",
"BAMXF Automobiles & Components \n",
"BASFY Materials \n",
"BDRFF Household & Personal Products \n",
"BDRFY Household & Personal Products \n",
"BFFAF Materials \n",
"BMWYY Automobiles & Components \n",
"BYMOF Automobiles & Components \n",
"COVTY Materials \n",
"CTTAF Automobiles & Components \n",
"CTTAY Automobiles & Components \n",
"CVVTF Materials \n",
"DDAIF Automobiles & Components \n",
"DMLRY Automobiles & Components \n",
"DUERF Capital Goods \n",
"DURYY Capital Goods \n",
"EGKLF Automobiles & Components \n",
"ELLRY Automobiles & Components \n",
"EVKIF Materials \n",
"EVKIY Materials \n",
"FUPBY Materials \n",
"FUPEF Materials \n",
"FUPPF Materials \n",
"HELKF Household & Personal Products \n",
"HENKY Household & Personal Products \n",
"HENOF Household & Personal Products \n",
"HENOY Household & Personal Products \n",
"HLKHF Automobiles & Components \n",
"HLLGY Automobiles & Components \n",
"IFNNF Semiconductors & Semiconductor Equipment \n",
"IFNNY Semiconductors & Semiconductor Equipment \n",
"KUKAF Capital Goods \n",
"KUKAY Capital Goods \n",
"LNNNY Capital Goods \n",
"LNXSF Materials \n",
"LNXSY Materials \n",
"LPKFF Capital Goods \n",
"MKGAF Pharmaceuticals, Biotechnology & Life Sciences \n",
"MKKGY Pharmaceuticals, Biotechnology & Life Sciences \n",
"NGRRF Software & Services \n",
"OSAGF Capital Goods \n",
"OSAGY Capital Goods \n",
"PSSWF Software & Services \n",
"SCFLF Automobiles & Components \n",
"SFFLY Automobiles & Components \n",
"SGLFF Materials \n",
"SLGRF Capital Goods \n",
"SZGPY Materials \n",
"TKAMY Capital Goods \n",
"TYEKF Capital Goods \n",
"VIAO Technology Hardware & Equipment \n",
"VJET Technology Hardware & Equipment \n",
"WKCMF Materials \n",
"\n",
" industry exchange \\\n",
"symbol \n",
"AFRMF Machinery PNK \n",
"AUUMF Machinery PNK \n",
"BAMXF Automobiles PNK \n",
"BASFY Chemicals PNK \n",
"BDRFF Household Products PNK \n",
"BDRFY Household Products PNK \n",
"BFFAF Chemicals PNK \n",
"BMWYY Automobiles PNK \n",
"BYMOF Automobiles PNK \n",
"COVTY Chemicals PNK \n",
"CTTAF Auto Components PNK \n",
"CTTAY Auto Components PNK \n",
"CVVTF Chemicals PNK \n",
"DDAIF Automobiles PNK \n",
"DMLRY Automobiles PNK \n",
"DUERF Machinery PNK \n",
"DURYY Machinery PNK \n",
"EGKLF Auto Components PNK \n",
"ELLRY Auto Components PNK \n",
"EVKIF Chemicals PNK \n",
"EVKIY Chemicals PNK \n",
"FUPBY Chemicals PNK \n",
"FUPEF Chemicals PNK \n",
"FUPPF Chemicals PNK \n",
"HELKF Household Products PNK \n",
"HENKY Household Products PNK \n",
"HENOF Household Products PNK \n",
"HENOY Household Products PNK \n",
"HLKHF Auto Components PNK \n",
"HLLGY Auto Components PNK \n",
"IFNNF Semiconductors & Semiconductor Equipment PNK \n",
"IFNNY Semiconductors & Semiconductor Equipment PNK \n",
"KUKAF Machinery PNK \n",
"KUKAY Machinery PNK \n",
"LNNNY Electrical Equipment PNK \n",
"LNXSF Chemicals PNK \n",
"LNXSY Chemicals PNK \n",
"LPKFF Machinery PNK \n",
"MKGAF Pharmaceuticals PNK \n",
"MKKGY Pharmaceuticals PNK \n",
"NGRRF IT Services PNK \n",
"OSAGF Electrical Equipment PNK \n",
"OSAGY Electrical Equipment PNK \n",
"PSSWF Software PNK \n",
"SCFLF Auto Components PNK \n",
"SFFLY Auto Components PNK \n",
"SGLFF Chemicals PNK \n",
"SLGRF Machinery PNK \n",
"SZGPY Metals & Mining PNK \n",
"TKAMY Building Products PNK \n",
"TYEKF Building Products PNK \n",
"VIAO Electronic Equipment, Instruments & Components NYQ \n",
"VJET Technology Hardware, Storage & Peripherals NCM \n",
"WKCMF Chemicals PNK \n",
"\n",
" market country state city zipcode \\\n",
"symbol \n",
"AFRMF OTC Bulletin Board Germany NaN Feldkirchen 85622 \n",
"AUUMF OTC Bulletin Board Germany NaN Beelen 48361 \n",
"BAMXF OTC Bulletin Board Germany NaN Munich 80788 \n",
"BASFY OTC Bulletin Board Germany NaN Ludwigshafen am Rhein 67056 \n",
"BDRFF OTC Bulletin Board Germany NaN Hamburg 20245 \n",
"BDRFY OTC Bulletin Board Germany NaN Hamburg 20245 \n",
"BFFAF OTC Bulletin Board Germany NaN Ludwigshafen am Rhein 67056 \n",
"BMWYY OTC Bulletin Board Germany NaN Munich 80788 \n",
"BYMOF OTC Bulletin Board Germany NaN Munich 80788 \n",
"COVTY OTC Bulletin Board Germany NaN Leverkusen 51373 \n",
"CTTAF OTC Bulletin Board Germany NaN Hanover 30165 \n",
"CTTAY OTC Bulletin Board Germany NaN Hanover 30165 \n",
"CVVTF OTC Bulletin Board Germany NaN Leverkusen 51373 \n",
"DDAIF OTC Bulletin Board Germany NaN Stuttgart 70372 \n",
"DMLRY OTC Bulletin Board Germany NaN Stuttgart 70372 \n",
"DUERF OTC Bulletin Board Germany NaN Bietigheim-Bissingen 74321 \n",
"DURYY OTC Bulletin Board Germany NaN Bietigheim-Bissingen 74321 \n",
"EGKLF OTC Bulletin Board Germany NaN Dettingen an der Erms 72581 \n",
"ELLRY OTC Bulletin Board Germany NaN Dettingen an der Erms 72581 \n",
"EVKIF OTC Bulletin Board Germany NaN Essen 45128 \n",
"EVKIY OTC Bulletin Board Germany NaN Essen 45128 \n",
"FUPBY OTC Bulletin Board Germany NaN Mannheim 68169 \n",
"FUPEF OTC Bulletin Board Germany NaN Mannheim 68169 \n",
"FUPPF OTC Bulletin Board Germany NaN Mannheim 68169 \n",
"HELKF OTC Bulletin Board Germany NaN Dusseldorf 40589 \n",
"HENKY OTC Bulletin Board Germany NaN Dusseldorf 40589 \n",
"HENOF OTC Bulletin Board Germany NaN Dusseldorf 40589 \n",
"HENOY OTC Bulletin Board Germany NaN Dusseldorf 40589 \n",
"HLKHF OTC Bulletin Board Germany NaN Lippstadt 59552 \n",
"HLLGY OTC Bulletin Board Germany NaN Lippstadt 59552 \n",
"IFNNF OTC Bulletin Board Germany NaN Munich 85579 \n",
"IFNNY OTC Bulletin Board Germany NaN Munich 85579 \n",
"KUKAF OTC Bulletin Board Germany NaN Augsburg 86165 \n",
"KUKAY OTC Bulletin Board Germany NaN Augsburg 86165 \n",
"LNNNY OTC Bulletin Board Germany NaN Nuremberg 90402 \n",
"LNXSF OTC Bulletin Board Germany NaN Cologne 50569 \n",
"LNXSY OTC Bulletin Board Germany NaN Cologne 50569 \n",
"LPKFF OTC Bulletin Board Germany NaN Garbsen 30827 \n",
"MKGAF OTC Bulletin Board Germany NaN Darmstadt 64293 \n",
"MKKGY OTC Bulletin Board Germany NaN Darmstadt 64293 \n",
"NGRRF OTC Bulletin Board Germany NaN Munich 81677 \n",
"OSAGF OTC Bulletin Board Germany NaN Munich 80807 \n",
"OSAGY OTC Bulletin Board Germany NaN Munich 80807 \n",
"PSSWF OTC Bulletin Board Germany NaN Berlin 10178 \n",
"SCFLF OTC Bulletin Board Germany NaN Herzogenaurach 91074 \n",
"SFFLY OTC Bulletin Board Germany NaN Herzogenaurach 91074 \n",
"SGLFF OTC Bulletin Board Germany NaN Wiesbaden 65201 \n",
"SLGRF OTC Bulletin Board Germany NaN Lubeck 23560 \n",
"SZGPY OTC Bulletin Board Germany NaN Salzgitter 38239 \n",
"TKAMY OTC Bulletin Board Germany NaN Essen 45143 \n",
"TYEKF OTC Bulletin Board Germany NaN Essen 45143 \n",
"VIAO New York Stock Exchange Germany NaN Nuremberg 90411 \n",
"VJET NASDAQ Capital Market Germany NaN Friedberg 86316 \n",
"WKCMF OTC Bulletin Board Germany NaN Munich 81737 \n",
"\n",
" website market_cap isin cusip \\\n",
"symbol \n",
"AFRMF NaN Nano Cap NaN NaN \n",
"AUUMF http://www.aumann.com Micro Cap DE000A2DAM03 NaN \n",
"BAMXF http://www.bmwgroup.com Large Cap DE0005190037 NaN \n",
"BASFY http://www.basf.com Large Cap NaN NaN \n",
"BDRFF http://www.beiersdorf.com Large Cap US07724U1034 07724U103 \n",
"BDRFY http://www.beiersdorf.com Large Cap US07724U1034 07724U103 \n",
"BFFAF http://www.basf.com Large Cap NaN NaN \n",
"BMWYY http://www.bmwgroup.com Large Cap DE0005190037 NaN \n",
"BYMOF http://www.bmwgroup.com Large Cap DE0005190037 NaN \n",
"COVTY http://www.covestro.com Large Cap DE0006062144 NaN \n",
"CTTAF http://www.continental.com Large Cap US2107712000 210771200 \n",
"CTTAY http://www.continental.com Large Cap US2107712000 210771200 \n",
"CVVTF http://www.covestro.com Large Cap DE0006062144 NaN \n",
"DDAIF http://www.daimler.com Large Cap NaN NaN \n",
"DMLRY http://www.daimler.com Large Cap NaN NaN \n",
"DUERF http://www.durr-group.com Mid Cap US2668881061 266888106 \n",
"DURYY http://www.durr-group.com Mid Cap US2668881061 266888106 \n",
"EGKLF http://www.elringklinger.com Small Cap US2901591022 290159102 \n",
"ELLRY http://www.elringklinger.com Small Cap US2901591022 290159102 \n",
"EVKIF http://corporate.evonik.com/en/ Large Cap US3005031097 300503109 \n",
"EVKIY http://corporate.evonik.com/en/ Large Cap US3005031097 300503109 \n",
"FUPBY http://www.fuchs.com/group Mid Cap DE000A3E5D64 NaN \n",
"FUPEF http://www.fuchs.com/group Mid Cap DE000A3E5D64 NaN \n",
"FUPPF http://www.fuchs.com/group Mid Cap DE000A3E5D64 NaN \n",
"HELKF http://www.henkel.com Large Cap US42550U2087 42550U208 \n",
"HENKY http://www.henkel.com Large Cap US42550U2087 42550U208 \n",
"HENOF http://www.henkel.com Large Cap US42550U2087 42550U208 \n",
"HENOY http://www.henkel.com Large Cap US42550U2087 42550U208 \n",
"HLKHF http://www.hella.com Mid Cap NaN NaN \n",
"HLLGY http://www.hella.com Mid Cap NaN NaN \n",
"IFNNF http://www.infineon.com Large Cap US45662N1037 45662N103 \n",
"IFNNY http://www.infineon.com Large Cap US45662N1037 45662N103 \n",
"KUKAF http://www.kuka.com Mid Cap NaN NaN \n",
"KUKAY http://www.kuka.com Mid Cap NaN NaN \n",
"LNNNY http://www.leoni.com Small Cap NaN NaN \n",
"LNXSF http://lanxess.com Mid Cap US5165571051 516557105 \n",
"LNXSY http://lanxess.com Mid Cap US5165571051 516557105 \n",
"LPKFF http://www.lpkf.com Small Cap DE0006450000 NaN \n",
"MKGAF http://www.merckgroup.com Large Cap US5893392093 589339209 \n",
"MKKGY http://www.merckgroup.com Large Cap US5893392093 589339209 \n",
"NGRRF http://www.nagarro.com Small Cap DE000A3H2200 NaN \n",
"OSAGF http://www.osram-group.com Mid Cap NaN NaN \n",
"OSAGY http://www.osram-group.com Mid Cap NaN NaN \n",
"PSSWF http://www.psi.de Small Cap DE000A0Z1JH9 NaN \n",
"SCFLF http://www.schaeffler.com Mid Cap NaN NaN \n",
"SFFLY http://www.schaeffler.com Mid Cap NaN NaN \n",
"SGLFF http://www.sglcarbon.com Small Cap NaN NaN \n",
"SLGRF http://www.slm-solutions.com Small Cap DE000A111338 NaN \n",
"SZGPY http://www.salzgitter-ag.com Small Cap US7958422021 795842202 \n",
"TKAMY http://www.thyssenkrupp.com Mid Cap NaN NaN \n",
"TYEKF http://www.thyssenkrupp.com Mid Cap NaN NaN \n",
"VIAO http://www.via-optronics.com Nano Cap US91823Y1091 91823Y109 \n",
"VJET http://www.voxeljet.com Nano Cap NaN NaN \n",
"WKCMF http://www.wacker.com Mid Cap DE000WCH8881 NaN \n",
"\n",
" figi composite_figi shareclass_figi \n",
"symbol \n",
"AFRMF NaN NaN NaN \n",
"AUUMF NaN NaN NaN \n",
"BAMXF NaN NaN NaN \n",
"BASFY NaN NaN NaN \n",
"BDRFF NaN NaN NaN \n",
"BDRFY NaN NaN NaN \n",
"BFFAF NaN NaN NaN \n",
"BMWYY NaN NaN NaN \n",
"BYMOF NaN NaN NaN \n",
"COVTY NaN NaN NaN \n",
"CTTAF NaN NaN NaN \n",
"CTTAY NaN NaN NaN \n",
"CVVTF NaN NaN NaN \n",
"DDAIF NaN NaN NaN \n",
"DMLRY NaN NaN NaN \n",
"DUERF NaN NaN NaN \n",
"DURYY NaN NaN NaN \n",
"EGKLF NaN NaN NaN \n",
"ELLRY NaN NaN NaN \n",
"EVKIF NaN NaN NaN \n",
"EVKIY NaN NaN NaN \n",
"FUPBY NaN NaN NaN \n",
"FUPEF NaN NaN NaN \n",
"FUPPF NaN NaN NaN \n",
"HELKF NaN NaN NaN \n",
"HENKY NaN NaN NaN \n",
"HENOF NaN NaN NaN \n",
"HENOY NaN NaN NaN \n",
"HLKHF NaN NaN NaN \n",
"HLLGY NaN NaN NaN \n",
"IFNNF NaN NaN NaN \n",
"IFNNY NaN NaN NaN \n",
"KUKAF NaN NaN NaN \n",
"KUKAY NaN NaN NaN \n",
"LNNNY NaN NaN NaN \n",
"LNXSF NaN NaN NaN \n",
"LNXSY NaN NaN NaN \n",
"LPKFF NaN NaN NaN \n",
"MKGAF NaN NaN NaN \n",
"MKKGY NaN NaN NaN \n",
"NGRRF NaN NaN NaN \n",
"OSAGF NaN NaN NaN \n",
"OSAGY NaN NaN NaN \n",
"PSSWF NaN NaN NaN \n",
"SCFLF NaN NaN NaN \n",
"SFFLY NaN NaN NaN \n",
"SGLFF NaN NaN NaN \n",
"SLGRF NaN NaN NaN \n",
"SZGPY NaN NaN NaN \n",
"TKAMY NaN NaN NaN \n",
"TYEKF NaN NaN NaN \n",
"VIAO BBG00X5F6PX0 BBG00X5F6PS6 BBG00X5F6QP7 \n",
"VJET NaN NaN NaN \n",
"WKCMF NaN NaN NaN "
]
},
"execution_count": 36,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"# Collect all Equities\n",
"equities = fd.Equities()\n",
"\n",
"# Search Multiple Columns\n",
"equities.search(summary='automotive', currency='USD', country='Germany')"
]
},
{
"cell_type": "code",
"execution_count": 37,
"id": "922b0763",
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"\n",
"\n",
"
\n",
" \n",
" \n",
" | \n",
" name | \n",
" category | \n",
" currency | \n",
" market | \n",
" exchange | \n",
"
\n",
" \n",
" symbol | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
"
\n",
" \n",
" \n",
" \n",
" APGXX | \n",
" U.S. Treasury Fund | \n",
" Cavanal Hill Funds | \n",
" USD | \n",
" us_market | \n",
" NAS | \n",
"
\n",
" \n",
" APJXX | \n",
" U.S. Treasury Fund | \n",
" Cavanal Hill Funds | \n",
" USD | \n",
" us_market | \n",
" NAS | \n",
"
\n",
" \n",
" APKXX | \n",
" U.S. Treasury Fund | \n",
" Cavanal Hill Funds | \n",
" USD | \n",
" us_market | \n",
" NAS | \n",
"
\n",
" \n",
" APNXX | \n",
" U.S. Treasury Fund | \n",
" Cavanal Hill Funds | \n",
" USD | \n",
" us_market | \n",
" NAS | \n",
"
\n",
" \n",
" FDCXX | \n",
" Treasury Fund | \n",
" Fidelity Newbury Street Trust | \n",
" USD | \n",
" us_market | \n",
" NAS | \n",
"
\n",
" \n",
" FDUXX | \n",
" Treasury Fund | \n",
" Fidelity Newbury Street Trust | \n",
" USD | \n",
" us_market | \n",
" NAS | \n",
"
\n",
" \n",
" FSRXX | \n",
" Treasury Fund | \n",
" Fidelity Newbury Street Trust | \n",
" USD | \n",
" us_market | \n",
" NAS | \n",
"
\n",
" \n",
" FZFXX | \n",
" Treasury Fund | \n",
" Fidelity Newbury Street Trust | \n",
" USD | \n",
" us_market | \n",
" NAS | \n",
"
\n",
" \n",
" TRIXX | \n",
" Treasury Fund | \n",
" State Street Institutional Investment Trust | \n",
" USD | \n",
" us_market | \n",
" NAS | \n",
"
\n",
" \n",
" TRVXX | \n",
" Treasury Fund | \n",
" State Street Institutional Investment Trust | \n",
" USD | \n",
" us_market | \n",
" NAS | \n",
"
\n",
" \n",
"
\n",
"
"
],
"text/plain": [
" name category \\\n",
"symbol \n",
"APGXX U.S. Treasury Fund Cavanal Hill Funds \n",
"APJXX U.S. Treasury Fund Cavanal Hill Funds \n",
"APKXX U.S. Treasury Fund Cavanal Hill Funds \n",
"APNXX U.S. Treasury Fund Cavanal Hill Funds \n",
"FDCXX Treasury Fund Fidelity Newbury Street Trust \n",
"FDUXX Treasury Fund Fidelity Newbury Street Trust \n",
"FSRXX Treasury Fund Fidelity Newbury Street Trust \n",
"FZFXX Treasury Fund Fidelity Newbury Street Trust \n",
"TRIXX Treasury Fund State Street Institutional Investment Trust \n",
"TRVXX Treasury Fund State Street Institutional Investment Trust \n",
"\n",
" currency market exchange \n",
"symbol \n",
"APGXX USD us_market NAS \n",
"APJXX USD us_market NAS \n",
"APKXX USD us_market NAS \n",
"APNXX USD us_market NAS \n",
"FDCXX USD us_market NAS \n",
"FDUXX USD us_market NAS \n",
"FSRXX USD us_market NAS \n",
"FZFXX USD us_market NAS \n",
"TRIXX USD us_market NAS \n",
"TRVXX USD us_market NAS "
]
},
"execution_count": 37,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"# Collect all Moneymarkets\n",
"moneymarkets = fd.Moneymarkets()\n",
"\n",
"# Search Multiple Columns\n",
"moneymarkets.search(name=\"treasury fund\", market=\"us_market\")"
]
},
{
"cell_type": "code",
"execution_count": 38,
"id": "b32a8fbb",
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"\n",
"\n",
"
\n",
" \n",
" \n",
" | \n",
" name | \n",
" currency | \n",
" summary | \n",
" manager_name | \n",
" manager_bio | \n",
" category_group | \n",
" category | \n",
" family | \n",
" exchange | \n",
" market | \n",
"
\n",
" \n",
" symbol | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
"
\n",
" \n",
" \n",
" \n",
" ACASX | \n",
" Access Capital Community Investment Fund Class A | \n",
" USD | \n",
" The investment seeks to invest in geographical... | \n",
" Brian Svendahl | \n",
" Brian Svendahl oversees our fixed income resea... | \n",
" Fixed Income | \n",
" Bonds | \n",
" RBC Global Asset Management | \n",
" NAS | \n",
" us_market | \n",
"
\n",
" \n",
" ACATX | \n",
" Access Capital Community Investment Fund Class IS | \n",
" USD | \n",
" The investment seeks to invest in geographical... | \n",
" Brian Svendahl | \n",
" Brian Svendahl oversees our fixed income resea... | \n",
" Fixed Income | \n",
" Bonds | \n",
" RBC Global Asset Management | \n",
" NAS | \n",
" us_market | \n",
"
\n",
" \n",
" ACCSX | \n",
" Access Capital Community Investment Fund Insti... | \n",
" USD | \n",
" The investment seeks to invest in geographical... | \n",
" Brian Svendahl | \n",
" Brian Svendahl oversees our fixed income resea... | \n",
" Fixed Income | \n",
" Bonds | \n",
" RBC Global Asset Management | \n",
" NAS | \n",
" us_market | \n",
"
\n",
" \n",
" AHIFX | \n",
" American Funds American High-Income Trust Clas... | \n",
" USD | \n",
" The investment seeks to provide a high level o... | \n",
" David A. Daigle | \n",
" David A. Daigle is a fixed-income portfolio ma... | \n",
" Fixed Income | \n",
" Bonds | \n",
" American Investments | \n",
" NAS | \n",
" us_market | \n",
"
\n",
" \n",
" AHITX | \n",
" American Funds American High-Income Trust Class A | \n",
" USD | \n",
" The investment seeks to provide a high level o... | \n",
" David A. Daigle | \n",
" David A. Daigle is a fixed-income portfolio ma... | \n",
" Fixed Income | \n",
" Bonds | \n",
" American Investments | \n",
" NAS | \n",
" us_market | \n",
"
\n",
" \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
"
\n",
" \n",
" VUSCX | \n",
" Invesco Quality Income Fund Class C | \n",
" USD | \n",
" The investment seeks a high level of current i... | \n",
" Clint P. Dudley | \n",
" Clint Dudley is a Senior Portfolio Manager for... | \n",
" Fixed Income | \n",
" Bonds | \n",
" Invesco Asset Management | \n",
" NAS | \n",
" us_market | \n",
"
\n",
" \n",
" VUSIX | \n",
" Invesco Quality Income Fund Class Y | \n",
" USD | \n",
" The investment seeks a high level of current i... | \n",
" Clint P. Dudley | \n",
" Clint Dudley is a Senior Portfolio Manager for... | \n",
" Fixed Income | \n",
" Bonds | \n",
" Invesco Asset Management | \n",
" NAS | \n",
" us_market | \n",
"
\n",
" \n",
" VUSJX | \n",
" Invesco Quality Income Fund R5 Class | \n",
" USD | \n",
" The investment seeks a high level of current i... | \n",
" Clint P. Dudley | \n",
" Clint Dudley is a Senior Portfolio Manager for... | \n",
" Fixed Income | \n",
" Bonds | \n",
" Invesco Asset Management | \n",
" NAS | \n",
" us_market | \n",
"
\n",
" \n",
" VUSRX | \n",
" Invesco Quality Income Fund Class R | \n",
" USD | \n",
" The investment seeks a high level of current i... | \n",
" Clint P. Dudley | \n",
" Clint Dudley is a Senior Portfolio Manager for... | \n",
" Fixed Income | \n",
" Bonds | \n",
" Invesco Asset Management | \n",
" NAS | \n",
" us_market | \n",
"
\n",
" \n",
" VUSSX | \n",
" Invesco Quality Income Fund Class R6 | \n",
" USD | \n",
" The investment seeks a high level of current i... | \n",
" Clint P. Dudley | \n",
" Clint Dudley is a Senior Portfolio Manager for... | \n",
" Fixed Income | \n",
" Bonds | \n",
" Invesco Asset Management | \n",
" NAS | \n",
" us_market | \n",
"
\n",
" \n",
"
\n",
"
110 rows × 10 columns
\n",
"
"
],
"text/plain": [
" name currency \\\n",
"symbol \n",
"ACASX Access Capital Community Investment Fund Class A USD \n",
"ACATX Access Capital Community Investment Fund Class IS USD \n",
"ACCSX Access Capital Community Investment Fund Insti... USD \n",
"AHIFX American Funds American High-Income Trust Clas... USD \n",
"AHITX American Funds American High-Income Trust Class A USD \n",
"... ... ... \n",
"VUSCX Invesco Quality Income Fund Class C USD \n",
"VUSIX Invesco Quality Income Fund Class Y USD \n",
"VUSJX Invesco Quality Income Fund R5 Class USD \n",
"VUSRX Invesco Quality Income Fund Class R USD \n",
"VUSSX Invesco Quality Income Fund Class R6 USD \n",
"\n",
" summary manager_name \\\n",
"symbol \n",
"ACASX The investment seeks to invest in geographical... Brian Svendahl \n",
"ACATX The investment seeks to invest in geographical... Brian Svendahl \n",
"ACCSX The investment seeks to invest in geographical... Brian Svendahl \n",
"AHIFX The investment seeks to provide a high level o... David A. Daigle \n",
"AHITX The investment seeks to provide a high level o... David A. Daigle \n",
"... ... ... \n",
"VUSCX The investment seeks a high level of current i... Clint P. Dudley \n",
"VUSIX The investment seeks a high level of current i... Clint P. Dudley \n",
"VUSJX The investment seeks a high level of current i... Clint P. Dudley \n",
"VUSRX The investment seeks a high level of current i... Clint P. Dudley \n",
"VUSSX The investment seeks a high level of current i... Clint P. Dudley \n",
"\n",
" manager_bio category_group \\\n",
"symbol \n",
"ACASX Brian Svendahl oversees our fixed income resea... Fixed Income \n",
"ACATX Brian Svendahl oversees our fixed income resea... Fixed Income \n",
"ACCSX Brian Svendahl oversees our fixed income resea... Fixed Income \n",
"AHIFX David A. Daigle is a fixed-income portfolio ma... Fixed Income \n",
"AHITX David A. Daigle is a fixed-income portfolio ma... Fixed Income \n",
"... ... ... \n",
"VUSCX Clint Dudley is a Senior Portfolio Manager for... Fixed Income \n",
"VUSIX Clint Dudley is a Senior Portfolio Manager for... Fixed Income \n",
"VUSJX Clint Dudley is a Senior Portfolio Manager for... Fixed Income \n",
"VUSRX Clint Dudley is a Senior Portfolio Manager for... Fixed Income \n",
"VUSSX Clint Dudley is a Senior Portfolio Manager for... Fixed Income \n",
"\n",
" category family exchange market \n",
"symbol \n",
"ACASX Bonds RBC Global Asset Management NAS us_market \n",
"ACATX Bonds RBC Global Asset Management NAS us_market \n",
"ACCSX Bonds RBC Global Asset Management NAS us_market \n",
"AHIFX Bonds American Investments NAS us_market \n",
"AHITX Bonds American Investments NAS us_market \n",
"... ... ... ... ... \n",
"VUSCX Bonds Invesco Asset Management NAS us_market \n",
"VUSIX Bonds Invesco Asset Management NAS us_market \n",
"VUSJX Bonds Invesco Asset Management NAS us_market \n",
"VUSRX Bonds Invesco Asset Management NAS us_market \n",
"VUSSX Bonds Invesco Asset Management NAS us_market \n",
"\n",
"[110 rows x 10 columns]"
]
},
"execution_count": 38,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"# Collect all Funds\n",
"funds = fd.Funds()\n",
"\n",
"# Search Multiple Columns\n",
"funds.search(category_group=\"Fixed Income\", category=\"Bonds\", summary=\"United States\")"
]
}
],
"metadata": {
"kernelspec": {
"display_name": "Python 3 (ipykernel)",
"language": "python",
"name": "python3"
},
"language_info": {
"codemirror_mode": {
"name": "ipython",
"version": 3
},
"file_extension": ".py",
"mimetype": "text/x-python",
"name": "python",
"nbconvert_exporter": "python",
"pygments_lexer": "ipython3",
"version": "3.10.9"
},
"vscode": {
"interpreter": {
"hash": "100174a9203096c0c10fb537684ff280825ee9e252451beb8786068677204f06"
}
}
},
"nbformat": 4,
"nbformat_minor": 5
}