examples.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "83014ba8",
   "metadata": {},
   "source": [
    "<p align=\"center\">\n",
    "    <img src=\"https://user-images.githubusercontent.com/46355364/220746807-669cdbc1-ac67-404c-b0bb-4a3d67d9931f.jpg\" alt=\"Logo\">\n",
    "</center>\n",
    "<p align=\"center\">\n",
    "    <a href=\"https://www.buymeacoffee.com/jerbouma\">\n",
    "        <img src=\"https://img.shields.io/badge/Buy%20Me%20A%20Coffee-Donate-brightgreen?logo=buymeacoffee\" alt=\"Logo\">\n",
    "    </a>\n",
    "    <a href=\"https://github.com/JerBouma/FinanceDatabase/issues\">\n",
    "        <img src=\"https://img.shields.io/github/issues/jerbouma/financedatabase\" alt=\"Logo\">\n",
    "    </a>\n",
    "     <a href=\"https://github.com/JerBouma/FinanceDatabase/pulls\">\n",
    "        <img src=\"https://img.shields.io/github/issues-pr/JerBouma/FinanceDatabase?color=yellow\" alt=\"Logo\">\n",
    "    </a>\n",
    "    <a href=\"https://pypi.org/project/financedatabase/\">\n",
    "        <img src=\"https://img.shields.io/pypi/v/FinanceDatabase\" alt=\"Logo\">\n",
    "    </a>\n",
    "    <a href=\"https://pypi.org/project/financedatabase/\">\n",
    "        <img src=\"https://img.shields.io/pypi/dm/FinanceDatabase\" alt=\"Logo\">\n",
    "    </a>\n",
    "</center>\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 [yfinance](https://github.com/ranaroussi/yfinance) or [FundamentalAnalysis](https://github.com/JerBouma/FundamentalAnalysis). 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"
   ]
  },
  {
   "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)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "3a2a1a46",
   "metadata": {},
   "source": [
    "# Installation\n",
    "The package `financedatabase` allows you to select specific json files as well as search through collected data with a specific query.\n",
    "\n",
    "You can install the package with the following steps:\n",
    "1. `pip install financedatabase`\n",
    "    - Alternatively, download the 'Searcher' directory.\n",
    "2. (within Python) `import financedatabase as fd`"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "e847b00b",
   "metadata": {},
   "outputs": [],
   "source": [
    "import financedatabase as fd\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "f38d4843",
   "metadata": {},
   "source": [
    "# Quickstart"
   ]
  },
  {
   "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_consumer_electronics = equities.select(\n",
    "    country=\"United States\", industry=\"Consumer Electronics\"\n",
    ")\n",
    "\n",
    "# Search specific fields from the database\n",
    "equities_uk_biotech = equities.search(\n",
    "    country=\"United Kingdom\", summary=\"biotech\", exchange=\"LSE\"\n",
    ")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "9cb7fe0a",
   "metadata": {},
   "source": [
    "# Understanding the available options"
   ]
  },
  {
   "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",
       "        '√É¬úmraniye', '√É¬úr√É¬ºmqi', '√Ö¬†iauliai'], 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\")"
   ]
  },
  {
   "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()"
   ]
  },
  {
   "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\")"
   ]
  },
  {
   "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\")"
   ]
  },
  {
   "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\")"
   ]
  },
  {
   "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\")"
   ]
  },
  {
   "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",
      "    Description\n",
      "    ----\n",
      "    Returns all options for the selection provided.\n",
      "    \n",
      "    Input\n",
      "    ----\n",
      "    selection (string)\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 (string, default is None)\n",
      "        If filled, gives all data for a specific country.\n",
      "    sector (string, default is None)\n",
      "        If filled, gives all data for a specific sector.\n",
      "    industry_group (string, default is None)\n",
      "        If filled, gives all data for a specific industry group.\n",
      "    industry (string, default is None)\n",
      "        If filled, gives all data for a specific industry.\n",
      "    Output\n",
      "    ----\n",
      "    options (pd.Series)\n",
      "        Returns a series with all options for the selection provided.\n",
      "\n"
     ]
    }
   ],
   "source": [
    "help(equities.options)"
   ]
  },
  {
   "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\")"
   ]
  },
  {
   "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\")"
   ]
  },
  {
   "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\")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "3048a2f2",
   "metadata": {},
   "source": [
    "# Collecting information from the database"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "872918b0",
   "metadata": {},
   "source": [
    "## Equities"
   ]
  },
  {
   "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": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>name</th>\n",
       "      <th>summary</th>\n",
       "      <th>currency</th>\n",
       "      <th>sector</th>\n",
       "      <th>industry_group</th>\n",
       "      <th>industry</th>\n",
       "      <th>exchange</th>\n",
       "      <th>market</th>\n",
       "      <th>country</th>\n",
       "      <th>state</th>\n",
       "      <th>city</th>\n",
       "      <th>zipcode</th>\n",
       "      <th>website</th>\n",
       "      <th>market_cap</th>\n",
       "      <th>isin</th>\n",
       "      <th>cusip</th>\n",
       "      <th>figi</th>\n",
       "      <th>composite_figi</th>\n",
       "      <th>shareclass_figi</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>symbol</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>A</th>\n",
       "      <td>Agilent Technologies, Inc.</td>\n",
       "      <td>Agilent Technologies, Inc. provides applicatio...</td>\n",
       "      <td>USD</td>\n",
       "      <td>Health Care</td>\n",
       "      <td>Pharmaceuticals, Biotechnology &amp; Life Sciences</td>\n",
       "      <td>Biotechnology</td>\n",
       "      <td>NYQ</td>\n",
       "      <td>New York Stock Exchange</td>\n",
       "      <td>United States</td>\n",
       "      <td>CA</td>\n",
       "      <td>Santa Clara</td>\n",
       "      <td>95051</td>\n",
       "      <td>http://www.agilent.com</td>\n",
       "      <td>Large Cap</td>\n",
       "      <td>US00846U1016</td>\n",
       "      <td>00846U101</td>\n",
       "      <td>BBG000C2V541</td>\n",
       "      <td>BBG000C2V3D6</td>\n",
       "      <td>BBG001SCTQY4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AA</th>\n",
       "      <td>Alcoa Corporation</td>\n",
       "      <td>Alcoa Corporation, together with its subsidiar...</td>\n",
       "      <td>USD</td>\n",
       "      <td>Materials</td>\n",
       "      <td>Materials</td>\n",
       "      <td>Metals &amp; Mining</td>\n",
       "      <td>NYQ</td>\n",
       "      <td>New York Stock Exchange</td>\n",
       "      <td>United States</td>\n",
       "      <td>PA</td>\n",
       "      <td>Pittsburgh</td>\n",
       "      <td>15212-5858</td>\n",
       "      <td>http://www.alcoa.com</td>\n",
       "      <td>Mid Cap</td>\n",
       "      <td>US0138721065</td>\n",
       "      <td>13872106</td>\n",
       "      <td>BBG00B3T3HK5</td>\n",
       "      <td>BBG00B3T3HD3</td>\n",
       "      <td>BBG00B3T3HF1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AAALF</th>\n",
       "      <td>Aareal Bank AG</td>\n",
       "      <td>Aareal Bank AG, together with its subsidiaries...</td>\n",
       "      <td>USD</td>\n",
       "      <td>Financials</td>\n",
       "      <td>Banks</td>\n",
       "      <td>Banks</td>\n",
       "      <td>PNK</td>\n",
       "      <td>OTC Bulletin Board</td>\n",
       "      <td>Germany</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Wiesbaden</td>\n",
       "      <td>65189</td>\n",
       "      <td>http://www.aareal-bank.com</td>\n",
       "      <td>Small Cap</td>\n",
       "      <td>US00254K1088</td>\n",
       "      <td>00254K108</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AAALY</th>\n",
       "      <td>Aareal Bank AG</td>\n",
       "      <td>Aareal Bank AG, together with its subsidiaries...</td>\n",
       "      <td>USD</td>\n",
       "      <td>Financials</td>\n",
       "      <td>Banks</td>\n",
       "      <td>Banks</td>\n",
       "      <td>PNK</td>\n",
       "      <td>OTC Bulletin Board</td>\n",
       "      <td>Germany</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Wiesbaden</td>\n",
       "      <td>65189</td>\n",
       "      <td>http://www.aareal-bank.com</td>\n",
       "      <td>Small Cap</td>\n",
       "      <td>US00254K1088</td>\n",
       "      <td>00254K108</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AABB</th>\n",
       "      <td>Asia Broadband, Inc.</td>\n",
       "      <td>Asia Broadband Inc., through its subsidiary, A...</td>\n",
       "      <td>USD</td>\n",
       "      <td>Materials</td>\n",
       "      <td>Materials</td>\n",
       "      <td>Metals &amp; Mining</td>\n",
       "      <td>PNK</td>\n",
       "      <td>OTC Bulletin Board</td>\n",
       "      <td>United States</td>\n",
       "      <td>NV</td>\n",
       "      <td>Las Vegas</td>\n",
       "      <td>89135</td>\n",
       "      <td>http://www.asiabroadbandinc.com</td>\n",
       "      <td>Micro Cap</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ZYXI</th>\n",
       "      <td>Zynex, Inc.</td>\n",
       "      <td>Zynex, Inc., through its subsidiaries, designs...</td>\n",
       "      <td>USD</td>\n",
       "      <td>Health Care</td>\n",
       "      <td>Health Care Equipment &amp; Services</td>\n",
       "      <td>Health Care Technology</td>\n",
       "      <td>NCM</td>\n",
       "      <td>NASDAQ Capital Market</td>\n",
       "      <td>United States</td>\n",
       "      <td>CO</td>\n",
       "      <td>Englewood</td>\n",
       "      <td>80112</td>\n",
       "      <td>http://www.zynex.com</td>\n",
       "      <td>Small Cap</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ZZHGF</th>\n",
       "      <td>ZhongAn Online P &amp; C Insurance Co., Ltd.</td>\n",
       "      <td>ZhongAn Online P &amp; C Insurance Co., Ltd., an i...</td>\n",
       "      <td>USD</td>\n",
       "      <td>Financials</td>\n",
       "      <td>Insurance</td>\n",
       "      <td>Insurance</td>\n",
       "      <td>PNK</td>\n",
       "      <td>OTC Bulletin Board</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Shanghai</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://www.zhongan.com</td>\n",
       "      <td>Mid Cap</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ZZHGY</th>\n",
       "      <td>ZhongAn Online P &amp; C Insurance Co., Ltd.</td>\n",
       "      <td>ZhongAn Online P &amp; C Insurance Co., Ltd., an i...</td>\n",
       "      <td>USD</td>\n",
       "      <td>Financials</td>\n",
       "      <td>Insurance</td>\n",
       "      <td>Insurance</td>\n",
       "      <td>PNK</td>\n",
       "      <td>OTC Bulletin Board</td>\n",
       "      <td>China</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Shanghai</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://www.zhongan.com</td>\n",
       "      <td>Mid Cap</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ZZLL</th>\n",
       "      <td>ZZLL Information Technology, Inc.</td>\n",
       "      <td>ZZLL Information Technology, Inc., through its...</td>\n",
       "      <td>USD</td>\n",
       "      <td>Communication Services</td>\n",
       "      <td>Telecommunication Services</td>\n",
       "      <td>Diversified Telecommunication Services</td>\n",
       "      <td>PNK</td>\n",
       "      <td>OTC Bulletin Board</td>\n",
       "      <td>Hong Kong</td>\n",
       "      <td>NaN</td>\n",
       "      <td>North Point</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://www.zzlliti.com</td>\n",
       "      <td>Nano Cap</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ZZZOF</th>\n",
       "      <td>one</td>\n",
       "      <td>one does not have significant operations. It i...</td>\n",
       "      <td>USD</td>\n",
       "      <td>Financials</td>\n",
       "      <td>Diversified Financials</td>\n",
       "      <td>Diversified Financial Services</td>\n",
       "      <td>PNK</td>\n",
       "      <td>OTC Bulletin Board</td>\n",
       "      <td>United States</td>\n",
       "      <td>CA</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>94129</td>\n",
       "      <td>http://www.a-star.co</td>\n",
       "      <td>Small Cap</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>20073 rows × 19 columns</p>\n",
       "</div>"
      ],
      "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",
       "ZYXI                                 Zynex, Inc.   \n",
       "ZZHGF   ZhongAn Online P & C Insurance Co., Ltd.   \n",
       "ZZHGY   ZhongAn Online P & C Insurance Co., Ltd.   \n",
       "ZZLL           ZZLL Information Technology, Inc.   \n",
       "ZZZOF                                        one   \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",
       "ZYXI    Zynex, Inc., through its subsidiaries, designs...      USD   \n",
       "ZZHGF   ZhongAn Online P & C Insurance Co., Ltd., an i...      USD   \n",
       "ZZHGY   ZhongAn Online P & C Insurance Co., Ltd., an i...      USD   \n",
       "ZZLL    ZZLL Information Technology, Inc., through its...      USD   \n",
       "ZZZOF   one does not have significant operations. It i...      USD   \n",
       "\n",
       "                        sector  \\\n",
       "symbol                           \n",
       "A                  Health Care   \n",
       "AA                   Materials   \n",
       "AAALF               Financials   \n",
       "AAALY               Financials   \n",
       "AABB                 Materials   \n",
       "...                        ...   \n",
       "ZYXI               Health Care   \n",
       "ZZHGF               Financials   \n",
       "ZZHGY               Financials   \n",
       "ZZLL    Communication Services   \n",
       "ZZZOF               Financials   \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",
       "ZYXI                  Health Care Equipment & Services   \n",
       "ZZHGF                                        Insurance   \n",
       "ZZHGY                                        Insurance   \n",
       "ZZLL                        Telecommunication Services   \n",
       "ZZZOF                           Diversified Financials   \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",
       "ZYXI                    Health Care Technology      NCM   \n",
       "ZZHGF                                Insurance      PNK   \n",
       "ZZHGY                                Insurance      PNK   \n",
       "ZZLL    Diversified Telecommunication Services      PNK   \n",
       "ZZZOF           Diversified Financial Services      PNK   \n",
       "\n",
       "                         market        country state           city  \\\n",
       "symbol                                                                \n",
       "A       New York Stock Exchange  United States    CA    Santa Clara   \n",
       "AA      New York Stock Exchange  United States    PA     Pittsburgh   \n",
       "AAALF        OTC Bulletin Board        Germany   NaN      Wiesbaden   \n",
       "AAALY        OTC Bulletin Board        Germany   NaN      Wiesbaden   \n",
       "AABB         OTC Bulletin Board  United States    NV      Las Vegas   \n",
       "...                         ...            ...   ...            ...   \n",
       "ZYXI      NASDAQ Capital Market  United States    CO      Englewood   \n",
       "ZZHGF        OTC Bulletin Board          China   NaN       Shanghai   \n",
       "ZZHGY        OTC Bulletin Board          China   NaN       Shanghai   \n",
       "ZZLL         OTC Bulletin Board      Hong Kong   NaN    North Point   \n",
       "ZZZOF        OTC Bulletin Board  United States    CA  San Francisco   \n",
       "\n",
       "           zipcode                          website market_cap          isin  \\\n",
       "symbol                                                                         \n",
       "A            95051           http://www.agilent.com  Large Cap  US00846U1016   \n",
       "AA      15212-5858             http://www.alcoa.com    Mid Cap  US0138721065   \n",
       "AAALF        65189       http://www.aareal-bank.com  Small Cap  US00254K1088   \n",
       "AAALY        65189       http://www.aareal-bank.com  Small Cap  US00254K1088   \n",
       "AABB         89135  http://www.asiabroadbandinc.com  Micro Cap           NaN   \n",
       "...            ...                              ...        ...           ...   \n",
       "ZYXI         80112             http://www.zynex.com  Small Cap           NaN   \n",
       "ZZHGF          NaN           http://www.zhongan.com    Mid Cap           NaN   \n",
       "ZZHGY          NaN           http://www.zhongan.com    Mid Cap           NaN   \n",
       "ZZLL           NaN           http://www.zzlliti.com   Nano Cap           NaN   \n",
       "ZZZOF        94129             http://www.a-star.co  Small Cap           NaN   \n",
       "\n",
       "            cusip          figi composite_figi shareclass_figi  \n",
       "symbol                                                          \n",
       "A       00846U101  BBG000C2V541   BBG000C2V3D6    BBG001SCTQY4  \n",
       "AA       13872106  BBG00B3T3HK5   BBG00B3T3HD3    BBG00B3T3HF1  \n",
       "AAALF   00254K108           NaN            NaN             NaN  \n",
       "AAALY   00254K108           NaN            NaN             NaN  \n",
       "AABB          NaN           NaN            NaN             NaN  \n",
       "...           ...           ...            ...             ...  \n",
       "ZYXI          NaN           NaN            NaN             NaN  \n",
       "ZZHGF         NaN           NaN            NaN             NaN  \n",
       "ZZHGY         NaN           NaN            NaN             NaN  \n",
       "ZZLL          NaN           NaN            NaN             NaN  \n",
       "ZZZOF         NaN           NaN            NaN             NaN  \n",
       "\n",
       "[20073 rows x 19 columns]"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "equities = fd.Equities()\n",
    "\n",
    "equities.select()"
   ]
  },
  {
   "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",
      "    Description\n",
      "    ----\n",
      "    Returns all equities when no input is given and has the option to give\n",
      "    a specific set of symbols for the country, sector and/or industry provided.\n",
      "    \n",
      "    The data depends on the combination of inputs. For example Country + Sector\n",
      "    gives all symbols for a specific sector in a specific country.\n",
      "    \n",
      "    Input\n",
      "    ----\n",
      "    country (string, default is None)\n",
      "        If filled, gives all data for a specific country.\n",
      "    sector (string, default is None)\n",
      "        If filled, gives all data for a specific sector.\n",
      "    industry_group (string, default is None)\n",
      "        If filled, gives all data for a specific industry group.\n",
      "    industry (string, default is None)\n",
      "        If filled, gives all data for a specific industry.\n",
      "    exclude_exchanges (boolean, default is True):\n",
      "        Whether you want to exclude exchanges from the search. If False,\n",
      "        you will receive multiple times the product from different exchanges.\n",
      "    capitalize (boolean, default is True):\n",
      "        Whether country, sector and industry needs to be capitalized. By default\n",
      "        the values always are capitalized as that is also how it is represented\n",
      "        in the csv files.\n",
      "    base_url (string, default is GitHub location)\n",
      "        The possibility to enter your own location if desired.\n",
      "    use_local_location (string, default False)\n",
      "        The possibility to select a local location (i.e. based on Windows path)\n",
      "    \n",
      "    Output\n",
      "    ----\n",
      "    equities_df (pd.DataFrame)\n",
      "        Returns a dictionary with a selection or all data based on the input.\n",
      "\n"
     ]
    }
   ],
   "source": [
    "help(equities.select)"
   ]
  },
  {
   "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": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>name</th>\n",
       "      <th>currency</th>\n",
       "      <th>summary</th>\n",
       "      <th>category_group</th>\n",
       "      <th>category</th>\n",
       "      <th>family</th>\n",
       "      <th>exchange</th>\n",
       "      <th>market</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>symbol</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>AGNG</th>\n",
       "      <td>Global X Aging Population ETF</td>\n",
       "      <td>USD</td>\n",
       "      <td>The investment seeks results that correspond g...</td>\n",
       "      <td>Health Care</td>\n",
       "      <td>Health Care</td>\n",
       "      <td>Global X Funds</td>\n",
       "      <td>NMS</td>\n",
       "      <td>us_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BBC</th>\n",
       "      <td>Virtus LifeSci Biotech Clinical Trials ETF</td>\n",
       "      <td>USD</td>\n",
       "      <td>The investment seeks investment results that c...</td>\n",
       "      <td>Health Care</td>\n",
       "      <td>Health Care</td>\n",
       "      <td>Virtus</td>\n",
       "      <td>PCX</td>\n",
       "      <td>us_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BBH</th>\n",
       "      <td>VanEck Vectors Biotech ETF</td>\n",
       "      <td>USD</td>\n",
       "      <td>The investment seeks to replicate as closely a...</td>\n",
       "      <td>Health Care</td>\n",
       "      <td>Health Care</td>\n",
       "      <td>VanEck Asset Management</td>\n",
       "      <td>NMS</td>\n",
       "      <td>us_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BBP</th>\n",
       "      <td>Virtus LifeSci Biotech Products ETF</td>\n",
       "      <td>USD</td>\n",
       "      <td>The investment seeks investment results that c...</td>\n",
       "      <td>Health Care</td>\n",
       "      <td>Health Care</td>\n",
       "      <td>Virtus</td>\n",
       "      <td>PCX</td>\n",
       "      <td>us_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CNCR</th>\n",
       "      <td>Loncar Cancer Immunotherapy ETF</td>\n",
       "      <td>USD</td>\n",
       "      <td>The investment seeks to track the total return...</td>\n",
       "      <td>Health Care</td>\n",
       "      <td>Health Care</td>\n",
       "      <td>Loncar Investments</td>\n",
       "      <td>NGM</td>\n",
       "      <td>us_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FBT</th>\n",
       "      <td>First Trust NYSE Arca Biotechnology Index Fund</td>\n",
       "      <td>USD</td>\n",
       "      <td>The investment seeks investment results that c...</td>\n",
       "      <td>Health Care</td>\n",
       "      <td>Health Care</td>\n",
       "      <td>First Trust Advisors</td>\n",
       "      <td>PCX</td>\n",
       "      <td>us_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>IBB</th>\n",
       "      <td>iShares Nasdaq Biotechnology ETF</td>\n",
       "      <td>USD</td>\n",
       "      <td>The investment seeks to track the investment r...</td>\n",
       "      <td>Health Care</td>\n",
       "      <td>Health Care</td>\n",
       "      <td>BlackRock Asset Management</td>\n",
       "      <td>NMS</td>\n",
       "      <td>us_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>IBBJ</th>\n",
       "      <td>Defiance Nasdaq Junior Biotechnology ETF</td>\n",
       "      <td>USD</td>\n",
       "      <td>The investment seeks to track the total return...</td>\n",
       "      <td>Health Care</td>\n",
       "      <td>Health Care</td>\n",
       "      <td>Defiance ETFs</td>\n",
       "      <td>NGM</td>\n",
       "      <td>us_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>IBBQ</th>\n",
       "      <td>Invesco Nasdaq Biotechnology ETF</td>\n",
       "      <td>USD</td>\n",
       "      <td>The investment seeks to track the investment r...</td>\n",
       "      <td>Health Care</td>\n",
       "      <td>Health Care</td>\n",
       "      <td>Invesco Investment Management</td>\n",
       "      <td>NMS</td>\n",
       "      <td>us_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>IEIH</th>\n",
       "      <td>iShares Evolved U.S. Innovative Healthcare ETF</td>\n",
       "      <td>USD</td>\n",
       "      <td>The investment seeks to provide access to U.S....</td>\n",
       "      <td>Health Care</td>\n",
       "      <td>Health Care</td>\n",
       "      <td>BlackRock Asset Management</td>\n",
       "      <td>BTS</td>\n",
       "      <td>us_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PBE</th>\n",
       "      <td>Invesco Dynamic Biotechnology &amp; Genome ETF</td>\n",
       "      <td>USD</td>\n",
       "      <td>The investment seeks to track the investment r...</td>\n",
       "      <td>Health Care</td>\n",
       "      <td>Health Care</td>\n",
       "      <td>Invesco Investment Management</td>\n",
       "      <td>PCX</td>\n",
       "      <td>us_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SBIO</th>\n",
       "      <td>ALPS Medical Breakthroughs ETF</td>\n",
       "      <td>USD</td>\n",
       "      <td>The investment seeks investment results that c...</td>\n",
       "      <td>Health Care</td>\n",
       "      <td>Health Care</td>\n",
       "      <td>ALPS ETF Trust</td>\n",
       "      <td>PCX</td>\n",
       "      <td>us_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>XBI</th>\n",
       "      <td>SPDR S&amp;P Biotech ETF</td>\n",
       "      <td>USD</td>\n",
       "      <td>The investment seeks to provide investment res...</td>\n",
       "      <td>Health Care</td>\n",
       "      <td>Health Care</td>\n",
       "      <td>State Street Global Advisors</td>\n",
       "      <td>PCX</td>\n",
       "      <td>us_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>XLV</th>\n",
       "      <td>Health Care Select Sector SPDR Fund</td>\n",
       "      <td>USD</td>\n",
       "      <td>The investment seeks investment results that, ...</td>\n",
       "      <td>Health Care</td>\n",
       "      <td>Health Care</td>\n",
       "      <td>State Street Global Advisors</td>\n",
       "      <td>PCX</td>\n",
       "      <td>us_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BBH.SN</th>\n",
       "      <td>VanEck Vectors Biotech ETF</td>\n",
       "      <td>NaN</td>\n",
       "      <td>The investment seeks to replicate as closely a...</td>\n",
       "      <td>Health Care</td>\n",
       "      <td>Health Care</td>\n",
       "      <td>VanEck Asset Management</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                  name currency  \\\n",
       "symbol                                                            \n",
       "AGNG                     Global X Aging Population ETF      USD   \n",
       "BBC         Virtus LifeSci Biotech Clinical Trials ETF      USD   \n",
       "BBH                         VanEck Vectors Biotech ETF      USD   \n",
       "BBP                Virtus LifeSci Biotech Products ETF      USD   \n",
       "CNCR                   Loncar Cancer Immunotherapy ETF      USD   \n",
       "FBT     First Trust NYSE Arca Biotechnology Index Fund      USD   \n",
       "IBB                   iShares Nasdaq Biotechnology ETF      USD   \n",
       "IBBJ          Defiance Nasdaq Junior Biotechnology ETF      USD   \n",
       "IBBQ                  Invesco Nasdaq Biotechnology ETF      USD   \n",
       "IEIH    iShares Evolved U.S. Innovative Healthcare ETF      USD   \n",
       "PBE         Invesco Dynamic Biotechnology & Genome ETF      USD   \n",
       "SBIO                    ALPS Medical Breakthroughs ETF      USD   \n",
       "XBI                               SPDR S&P Biotech ETF      USD   \n",
       "XLV                Health Care Select Sector SPDR Fund      USD   \n",
       "BBH.SN                      VanEck Vectors Biotech ETF      NaN   \n",
       "\n",
       "                                                  summary category_group  \\\n",
       "symbol                                                                     \n",
       "AGNG    The investment seeks results that correspond g...    Health Care   \n",
       "BBC     The investment seeks investment results that c...    Health Care   \n",
       "BBH     The investment seeks to replicate as closely a...    Health Care   \n",
       "BBP     The investment seeks investment results that c...    Health Care   \n",
       "CNCR    The investment seeks to track the total return...    Health Care   \n",
       "FBT     The investment seeks investment results that c...    Health Care   \n",
       "IBB     The investment seeks to track the investment r...    Health Care   \n",
       "IBBJ    The investment seeks to track the total return...    Health Care   \n",
       "IBBQ    The investment seeks to track the investment r...    Health Care   \n",
       "IEIH    The investment seeks to provide access to U.S....    Health Care   \n",
       "PBE     The investment seeks to track the investment r...    Health Care   \n",
       "SBIO    The investment seeks investment results that c...    Health Care   \n",
       "XBI     The investment seeks to provide investment res...    Health Care   \n",
       "XLV     The investment seeks investment results that, ...    Health Care   \n",
       "BBH.SN  The investment seeks to replicate as closely a...    Health Care   \n",
       "\n",
       "           category                         family exchange     market  \n",
       "symbol                                                                  \n",
       "AGNG    Health Care                 Global X Funds      NMS  us_market  \n",
       "BBC     Health Care                         Virtus      PCX  us_market  \n",
       "BBH     Health Care        VanEck Asset Management      NMS  us_market  \n",
       "BBP     Health Care                         Virtus      PCX  us_market  \n",
       "CNCR    Health Care             Loncar Investments      NGM  us_market  \n",
       "FBT     Health Care           First Trust Advisors      PCX  us_market  \n",
       "IBB     Health Care     BlackRock Asset Management      NMS  us_market  \n",
       "IBBJ    Health Care                  Defiance ETFs      NGM  us_market  \n",
       "IBBQ    Health Care  Invesco Investment Management      NMS  us_market  \n",
       "IEIH    Health Care     BlackRock Asset Management      BTS  us_market  \n",
       "PBE     Health Care  Invesco Investment Management      PCX  us_market  \n",
       "SBIO    Health Care                 ALPS ETF Trust      PCX  us_market  \n",
       "XBI     Health Care   State Street Global Advisors      PCX  us_market  \n",
       "XLV     Health Care   State Street Global Advisors      PCX  us_market  \n",
       "BBH.SN  Health Care        VanEck Asset Management      NaN        NaN  "
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "etfs = fd.ETFs()\n",
    "\n",
    "etfs.search(category=\"Health\", summary=\"biotech\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "0ab58cd3",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>name</th>\n",
       "      <th>summary</th>\n",
       "      <th>currency</th>\n",
       "      <th>sector</th>\n",
       "      <th>industry_group</th>\n",
       "      <th>industry</th>\n",
       "      <th>exchange</th>\n",
       "      <th>market</th>\n",
       "      <th>country</th>\n",
       "      <th>state</th>\n",
       "      <th>city</th>\n",
       "      <th>zipcode</th>\n",
       "      <th>website</th>\n",
       "      <th>market_cap</th>\n",
       "      <th>isin</th>\n",
       "      <th>cusip</th>\n",
       "      <th>figi</th>\n",
       "      <th>composite_figi</th>\n",
       "      <th>shareclass_figi</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>symbol</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0A4Q.L</th>\n",
       "      <td>QuickLogic Corporation</td>\n",
       "      <td>QuickLogic Corporation, a semiconductor compan...</td>\n",
       "      <td>USD</td>\n",
       "      <td>Information Technology</td>\n",
       "      <td>Semiconductors &amp; Semiconductor Equipment</td>\n",
       "      <td>Semiconductors &amp; Semiconductor Equipment</td>\n",
       "      <td>LSE</td>\n",
       "      <td>London Stock Exchange (international)</td>\n",
       "      <td>United States</td>\n",
       "      <td>CA</td>\n",
       "      <td>San Jose</td>\n",
       "      <td>95131</td>\n",
       "      <td>http://www.quicklogic.com</td>\n",
       "      <td>Micro Cap</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0HS2.L</th>\n",
       "      <td>Cadence Design Systems, Inc.</td>\n",
       "      <td>Cadence Design Systems, Inc. provides software...</td>\n",
       "      <td>USD</td>\n",
       "      <td>Information Technology</td>\n",
       "      <td>Software &amp; Services</td>\n",
       "      <td>Software</td>\n",
       "      <td>LSE</td>\n",
       "      <td>London Stock Exchange (international)</td>\n",
       "      <td>United States</td>\n",
       "      <td>CA</td>\n",
       "      <td>San Jose</td>\n",
       "      <td>95134</td>\n",
       "      <td>http://www.cadence.com</td>\n",
       "      <td>Large Cap</td>\n",
       "      <td>US1273871087</td>\n",
       "      <td>127387108</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0IH3.L</th>\n",
       "      <td>Energous Corporation</td>\n",
       "      <td>Energous Corporation develops wire-free chargi...</td>\n",
       "      <td>USD</td>\n",
       "      <td>Information Technology</td>\n",
       "      <td>Technology Hardware &amp; Equipment</td>\n",
       "      <td>Electronic Equipment, Instruments &amp; Components</td>\n",
       "      <td>LSE</td>\n",
       "      <td>London Stock Exchange (international)</td>\n",
       "      <td>United States</td>\n",
       "      <td>CA</td>\n",
       "      <td>San Jose</td>\n",
       "      <td>95134</td>\n",
       "      <td>http://www.energous.com</td>\n",
       "      <td>Micro Cap</td>\n",
       "      <td>US29272C1036</td>\n",
       "      <td>29272C103</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0JVV.L</th>\n",
       "      <td>Lumentum Holdings Inc.</td>\n",
       "      <td>Lumentum Holdings Inc. manufactures and sells ...</td>\n",
       "      <td>USD</td>\n",
       "      <td>Information Technology</td>\n",
       "      <td>Technology Hardware &amp; Equipment</td>\n",
       "      <td>Communications Equipment</td>\n",
       "      <td>LSE</td>\n",
       "      <td>London Stock Exchange (international)</td>\n",
       "      <td>United States</td>\n",
       "      <td>CA</td>\n",
       "      <td>San Jose</td>\n",
       "      <td>95131</td>\n",
       "      <td>http://www.lumentum.com</td>\n",
       "      <td>Mid Cap</td>\n",
       "      <td>GB00BLD4ZP54</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0K9O.L</th>\n",
       "      <td>Nutanix, Inc.</td>\n",
       "      <td>Nutanix, Inc. develops and provides an enterpr...</td>\n",
       "      <td>USD</td>\n",
       "      <td>Information Technology</td>\n",
       "      <td>Software &amp; Services</td>\n",
       "      <td>Software</td>\n",
       "      <td>LSE</td>\n",
       "      <td>London Stock Exchange (international)</td>\n",
       "      <td>United States</td>\n",
       "      <td>CA</td>\n",
       "      <td>San Jose</td>\n",
       "      <td>95110</td>\n",
       "      <td>http://www.nutanix.com</td>\n",
       "      <td>Mid Cap</td>\n",
       "      <td>US67059N1081</td>\n",
       "      <td>67059N108</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>XLNX.VI</th>\n",
       "      <td>Xilinx, Inc.</td>\n",
       "      <td>Xilinx, Inc. designs and develops programmable...</td>\n",
       "      <td>EUR</td>\n",
       "      <td>Information Technology</td>\n",
       "      <td>Semiconductors &amp; Semiconductor Equipment</td>\n",
       "      <td>Semiconductors &amp; Semiconductor Equipment</td>\n",
       "      <td>VIE</td>\n",
       "      <td>Vienna Stock Exchange</td>\n",
       "      <td>United States</td>\n",
       "      <td>CA</td>\n",
       "      <td>San Jose</td>\n",
       "      <td>95124</td>\n",
       "      <td>http://www.xilinx.com</td>\n",
       "      <td>Large Cap</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>XPER</th>\n",
       "      <td>Xperi Holding Corporation</td>\n",
       "      <td>Xperi Holding Corporation, together with its s...</td>\n",
       "      <td>USD</td>\n",
       "      <td>Information Technology</td>\n",
       "      <td>Semiconductors &amp; Semiconductor Equipment</td>\n",
       "      <td>Semiconductors &amp; Semiconductor Equipment</td>\n",
       "      <td>NMS</td>\n",
       "      <td>NASDAQ Global Select</td>\n",
       "      <td>United States</td>\n",
       "      <td>CA</td>\n",
       "      <td>San Jose</td>\n",
       "      <td>95134</td>\n",
       "      <td>http://www.xperi.com</td>\n",
       "      <td>Mid Cap</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>YTY.V</th>\n",
       "      <td>Wi2Wi Corporation</td>\n",
       "      <td>Wi2Wi Corporation designs, integrates, and man...</td>\n",
       "      <td>CAD</td>\n",
       "      <td>Information Technology</td>\n",
       "      <td>Technology Hardware &amp; Equipment</td>\n",
       "      <td>Communications Equipment</td>\n",
       "      <td>VAN</td>\n",
       "      <td>TSX Venture Exchange</td>\n",
       "      <td>United States</td>\n",
       "      <td>CA</td>\n",
       "      <td>San Jose</td>\n",
       "      <td>95131</td>\n",
       "      <td>http://www.wi2wi.com</td>\n",
       "      <td>Nano Cap</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ZS</th>\n",
       "      <td>Zscaler, Inc.</td>\n",
       "      <td>Zscaler, Inc. operates as a cloud security com...</td>\n",
       "      <td>USD</td>\n",
       "      <td>Information Technology</td>\n",
       "      <td>Software &amp; Services</td>\n",
       "      <td>Software</td>\n",
       "      <td>NMS</td>\n",
       "      <td>NASDAQ Global Select</td>\n",
       "      <td>United States</td>\n",
       "      <td>CA</td>\n",
       "      <td>San Jose</td>\n",
       "      <td>95134</td>\n",
       "      <td>http://www.zscaler.com</td>\n",
       "      <td>Large Cap</td>\n",
       "      <td>US98980G1022</td>\n",
       "      <td>98980G102</td>\n",
       "      <td>BBG00K4MD5L3</td>\n",
       "      <td>BBG003338H34</td>\n",
       "      <td>BBG003338H61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ZS.MX</th>\n",
       "      <td>Zscaler, Inc.</td>\n",
       "      <td>Zscaler, Inc. operates as a cloud security com...</td>\n",
       "      <td>MXN</td>\n",
       "      <td>Information Technology</td>\n",
       "      <td>Software &amp; Services</td>\n",
       "      <td>Software</td>\n",
       "      <td>MEX</td>\n",
       "      <td>Mexico Stock Exchange</td>\n",
       "      <td>United States</td>\n",
       "      <td>CA</td>\n",
       "      <td>San Jose</td>\n",
       "      <td>95134</td>\n",
       "      <td>http://www.zscaler.com</td>\n",
       "      <td>Large Cap</td>\n",
       "      <td>US98980G1022</td>\n",
       "      <td>98980G102</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>152 rows × 19 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                 name  \\\n",
       "symbol                                  \n",
       "0A4Q.L         QuickLogic Corporation   \n",
       "0HS2.L   Cadence Design Systems, Inc.   \n",
       "0IH3.L           Energous Corporation   \n",
       "0JVV.L         Lumentum Holdings Inc.   \n",
       "0K9O.L                  Nutanix, Inc.   \n",
       "...                               ...   \n",
       "XLNX.VI                  Xilinx, Inc.   \n",
       "XPER        Xperi Holding Corporation   \n",
       "YTY.V               Wi2Wi Corporation   \n",
       "ZS                      Zscaler, Inc.   \n",
       "ZS.MX                   Zscaler, Inc.   \n",
       "\n",
       "                                                   summary currency  \\\n",
       "symbol                                                                \n",
       "0A4Q.L   QuickLogic Corporation, a semiconductor compan...      USD   \n",
       "0HS2.L   Cadence Design Systems, Inc. provides software...      USD   \n",
       "0IH3.L   Energous Corporation develops wire-free chargi...      USD   \n",
       "0JVV.L   Lumentum Holdings Inc. manufactures and sells ...      USD   \n",
       "0K9O.L   Nutanix, Inc. develops and provides an enterpr...      USD   \n",
       "...                                                    ...      ...   \n",
       "XLNX.VI  Xilinx, Inc. designs and develops programmable...      EUR   \n",
       "XPER     Xperi Holding Corporation, together with its s...      USD   \n",
       "YTY.V    Wi2Wi Corporation designs, integrates, and man...      CAD   \n",
       "ZS       Zscaler, Inc. operates as a cloud security com...      USD   \n",
       "ZS.MX    Zscaler, Inc. operates as a cloud security com...      MXN   \n",
       "\n",
       "                         sector                            industry_group  \\\n",
       "symbol                                                                      \n",
       "0A4Q.L   Information Technology  Semiconductors & Semiconductor Equipment   \n",
       "0HS2.L   Information Technology                       Software & Services   \n",
       "0IH3.L   Information Technology           Technology Hardware & Equipment   \n",
       "0JVV.L   Information Technology           Technology Hardware & Equipment   \n",
       "0K9O.L   Information Technology                       Software & Services   \n",
       "...                         ...                                       ...   \n",
       "XLNX.VI  Information Technology  Semiconductors & Semiconductor Equipment   \n",
       "XPER     Information Technology  Semiconductors & Semiconductor Equipment   \n",
       "YTY.V    Information Technology           Technology Hardware & Equipment   \n",
       "ZS       Information Technology                       Software & Services   \n",
       "ZS.MX    Information Technology                       Software & Services   \n",
       "\n",
       "                                               industry exchange  \\\n",
       "symbol                                                             \n",
       "0A4Q.L         Semiconductors & Semiconductor Equipment      LSE   \n",
       "0HS2.L                                         Software      LSE   \n",
       "0IH3.L   Electronic Equipment, Instruments & Components      LSE   \n",
       "0JVV.L                         Communications Equipment      LSE   \n",
       "0K9O.L                                         Software      LSE   \n",
       "...                                                 ...      ...   \n",
       "XLNX.VI        Semiconductors & Semiconductor Equipment      VIE   \n",
       "XPER           Semiconductors & Semiconductor Equipment      NMS   \n",
       "YTY.V                          Communications Equipment      VAN   \n",
       "ZS                                             Software      NMS   \n",
       "ZS.MX                                          Software      MEX   \n",
       "\n",
       "                                        market        country state      city  \\\n",
       "symbol                                                                          \n",
       "0A4Q.L   London Stock Exchange (international)  United States    CA  San Jose   \n",
       "0HS2.L   London Stock Exchange (international)  United States    CA  San Jose   \n",
       "0IH3.L   London Stock Exchange (international)  United States    CA  San Jose   \n",
       "0JVV.L   London Stock Exchange (international)  United States    CA  San Jose   \n",
       "0K9O.L   London Stock Exchange (international)  United States    CA  San Jose   \n",
       "...                                        ...            ...   ...       ...   \n",
       "XLNX.VI                  Vienna Stock Exchange  United States    CA  San Jose   \n",
       "XPER                      NASDAQ Global Select  United States    CA  San Jose   \n",
       "YTY.V                     TSX Venture Exchange  United States    CA  San Jose   \n",
       "ZS                        NASDAQ Global Select  United States    CA  San Jose   \n",
       "ZS.MX                    Mexico Stock Exchange  United States    CA  San Jose   \n",
       "\n",
       "        zipcode                    website market_cap          isin  \\\n",
       "symbol                                                                \n",
       "0A4Q.L    95131  http://www.quicklogic.com  Micro Cap           NaN   \n",
       "0HS2.L    95134     http://www.cadence.com  Large Cap  US1273871087   \n",
       "0IH3.L    95134    http://www.energous.com  Micro Cap  US29272C1036   \n",
       "0JVV.L    95131    http://www.lumentum.com    Mid Cap  GB00BLD4ZP54   \n",
       "0K9O.L    95110     http://www.nutanix.com    Mid Cap  US67059N1081   \n",
       "...         ...                        ...        ...           ...   \n",
       "XLNX.VI   95124      http://www.xilinx.com  Large Cap           NaN   \n",
       "XPER      95134       http://www.xperi.com    Mid Cap           NaN   \n",
       "YTY.V     95131       http://www.wi2wi.com   Nano Cap           NaN   \n",
       "ZS        95134     http://www.zscaler.com  Large Cap  US98980G1022   \n",
       "ZS.MX     95134     http://www.zscaler.com  Large Cap  US98980G1022   \n",
       "\n",
       "             cusip          figi composite_figi shareclass_figi  \n",
       "symbol                                                           \n",
       "0A4Q.L         NaN           NaN            NaN             NaN  \n",
       "0HS2.L   127387108           NaN            NaN             NaN  \n",
       "0IH3.L   29272C103           NaN            NaN             NaN  \n",
       "0JVV.L         NaN           NaN            NaN             NaN  \n",
       "0K9O.L   67059N108           NaN            NaN             NaN  \n",
       "...            ...           ...            ...             ...  \n",
       "XLNX.VI        NaN           NaN            NaN             NaN  \n",
       "XPER           NaN           NaN            NaN             NaN  \n",
       "YTY.V          NaN           NaN            NaN             NaN  \n",
       "ZS       98980G102  BBG00K4MD5L3   BBG003338H34    BBG003338H61  \n",
       "ZS.MX    98980G102           NaN            NaN             NaN  \n",
       "\n",
       "[152 rows x 19 columns]"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "equities = fd.Equities()\n",
    "\n",
    "equities.search(sector=\"Technology\", city=\"San Jose\")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "35eaae54",
   "metadata": {},
   "source": [
    "## ETFs"
   ]
  },
  {
   "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": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>name</th>\n",
       "      <th>currency</th>\n",
       "      <th>summary</th>\n",
       "      <th>category_group</th>\n",
       "      <th>category</th>\n",
       "      <th>family</th>\n",
       "      <th>exchange</th>\n",
       "      <th>market</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>symbol</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>^ACWI</th>\n",
       "      <td>ISHARES TRUST</td>\n",
       "      <td>USD</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NIM</td>\n",
       "      <td>us_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>^ADFI-IV</th>\n",
       "      <td>NFIELD DYNAMIC FIXED INCOME ETF</td>\n",
       "      <td>USD</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ASE</td>\n",
       "      <td>us_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>^ADRE</th>\n",
       "      <td>INVESCO ACTIVELY M</td>\n",
       "      <td>USD</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NIM</td>\n",
       "      <td>us_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>^ARB-EU</th>\n",
       "      <td>ALTSHARES MERGER ARBITRAGE ETF</td>\n",
       "      <td>USD</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ASE</td>\n",
       "      <td>us_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>^ARB-IV</th>\n",
       "      <td>ALTSHARES MERGER ARBITRAGE ETF</td>\n",
       "      <td>USD</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ASE</td>\n",
       "      <td>us_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>VGFPF</th>\n",
       "      <td>Vanguard Funds Public Limited Company - Vangua...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>VFDEF</th>\n",
       "      <td>Vanguard Funds Public Limited Company - Vangua...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WSDMF</th>\n",
       "      <td>WisdomTree Issuer ICAV - WisdomTree Europe Equ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WDSSF</th>\n",
       "      <td>WisdomTree Issuer ICAV - WisdomTree US Quality...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ZKBHF</th>\n",
       "      <td>ZKB Gold ETF</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2860 rows × 8 columns</p>\n",
       "</div>"
      ],
      "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()"
   ]
  },
  {
   "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",
      "    Description\n",
      "    ----\n",
      "    Returns all etfs when no input is given and has the option to give\n",
      "    a specific set of symbols for the category and/or family provided.\n",
      "    \n",
      "    The data depends on the combination of inputs. For example Category + Family\n",
      "    gives all symbols for a specific category for a specific family.\n",
      "    \n",
      "    Input\n",
      "    ----\n",
      "    category (string, default is None)\n",
      "        If filled, gives all data for a specific category.\n",
      "    family (string, default is None)\n",
      "        If filled, gives all data for a specific family.\n",
      "    exclude_exchanges (boolean, default is True):\n",
      "        Whether you want to exclude exchanges from the search. If False,\n",
      "        you will receive multiple times the product from different exchanges.\n",
      "    capitalize (boolean, default is True):\n",
      "        Whether country, sector and industry needs to be capitalized. By default\n",
      "        the values always are capitalized as that is also how it is represented\n",
      "        in the csv files.\n",
      "    base_url (string, default is GitHub location)\n",
      "        The possibility to enter your own location if desired.\n",
      "    use_local_location (string, default False)\n",
      "        The possibility to select a local location (i.e. based on Windows path)\n",
      "    \n",
      "    Output\n",
      "    ----\n",
      "    etfs_df (pd.DataFrame)\n",
      "        Returns a dictionary with a selection or all data based on the input.\n",
      "\n"
     ]
    }
   ],
   "source": [
    "help(etfs.select)"
   ]
  },
  {
   "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": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>name</th>\n",
       "      <th>currency</th>\n",
       "      <th>summary</th>\n",
       "      <th>category_group</th>\n",
       "      <th>category</th>\n",
       "      <th>family</th>\n",
       "      <th>exchange</th>\n",
       "      <th>market</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>symbol</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>AFK</th>\n",
       "      <td>VanEck Vectors Africa Index ETF</td>\n",
       "      <td>USD</td>\n",
       "      <td>The investment seeks to replicate as closely a...</td>\n",
       "      <td>Equities</td>\n",
       "      <td>Developed Markets</td>\n",
       "      <td>VanEck Asset Management</td>\n",
       "      <td>PCX</td>\n",
       "      <td>us_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AGT</th>\n",
       "      <td>iShares MSCI Argentina and Global Exposure ETF</td>\n",
       "      <td>USD</td>\n",
       "      <td>The investment seeks to track the investment r...</td>\n",
       "      <td>Equities</td>\n",
       "      <td>Developed Markets</td>\n",
       "      <td>BlackRock Asset Management</td>\n",
       "      <td>BTS</td>\n",
       "      <td>us_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ARGT</th>\n",
       "      <td>Global X MSCI Argentina ETF</td>\n",
       "      <td>USD</td>\n",
       "      <td>The investment seeks to provide investment res...</td>\n",
       "      <td>Equities</td>\n",
       "      <td>Developed Markets</td>\n",
       "      <td>Global X Funds</td>\n",
       "      <td>PCX</td>\n",
       "      <td>us_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AVMU</th>\n",
       "      <td>Avantis Core Municipal Fixed Income ETF</td>\n",
       "      <td>USD</td>\n",
       "      <td>The investment seeks current income that is ex...</td>\n",
       "      <td>Fixed Income</td>\n",
       "      <td>Developed Markets</td>\n",
       "      <td>Avantis Investors</td>\n",
       "      <td>PCX</td>\n",
       "      <td>us_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BBEU</th>\n",
       "      <td>JPMorgan BetaBuilders Europe ETF</td>\n",
       "      <td>USD</td>\n",
       "      <td>The investment seeks investment results that c...</td>\n",
       "      <td>Equities</td>\n",
       "      <td>Developed Markets</td>\n",
       "      <td>JPMorgan Asset Management</td>\n",
       "      <td>BTS</td>\n",
       "      <td>us_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>XMPT</th>\n",
       "      <td>VanEck Vectors CEF Municipal Income ETF</td>\n",
       "      <td>USD</td>\n",
       "      <td>The investment seeks to replicate as closely a...</td>\n",
       "      <td>Fixed Income</td>\n",
       "      <td>Developed Markets</td>\n",
       "      <td>VanEck Asset Management</td>\n",
       "      <td>BTS</td>\n",
       "      <td>us_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ZCAN</th>\n",
       "      <td>SPDR Solactive Canada ETF</td>\n",
       "      <td>USD</td>\n",
       "      <td>The investment seeks to track the performance ...</td>\n",
       "      <td>Equities</td>\n",
       "      <td>Developed Markets</td>\n",
       "      <td>State Street Global Advisors</td>\n",
       "      <td>PCX</td>\n",
       "      <td>us_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ZDEU</th>\n",
       "      <td>SPDR Solactive Germany ETF</td>\n",
       "      <td>USD</td>\n",
       "      <td>The investment seeks to track the performance ...</td>\n",
       "      <td>Equities</td>\n",
       "      <td>Developed Markets</td>\n",
       "      <td>State Street Global Advisors</td>\n",
       "      <td>PCX</td>\n",
       "      <td>us_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ZGBR</th>\n",
       "      <td>SPDR Solactive United Kingdom ETF</td>\n",
       "      <td>USD</td>\n",
       "      <td>The investment seeks to track the performance ...</td>\n",
       "      <td>Equities</td>\n",
       "      <td>Developed Markets</td>\n",
       "      <td>State Street Global Advisors</td>\n",
       "      <td>PCX</td>\n",
       "      <td>us_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ZJPN</th>\n",
       "      <td>SPDR Solactive Japan ETF</td>\n",
       "      <td>USD</td>\n",
       "      <td>The investment seeks to track the performance ...</td>\n",
       "      <td>Equities</td>\n",
       "      <td>Developed Markets</td>\n",
       "      <td>State Street Global Advisors</td>\n",
       "      <td>PCX</td>\n",
       "      <td>us_market</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>169 rows × 8 columns</p>\n",
       "</div>"
      ],
      "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\")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "86b5d8b2",
   "metadata": {},
   "source": [
    "## Funds"
   ]
  },
  {
   "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": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>name</th>\n",
       "      <th>currency</th>\n",
       "      <th>summary</th>\n",
       "      <th>manager_name</th>\n",
       "      <th>manager_bio</th>\n",
       "      <th>category_group</th>\n",
       "      <th>category</th>\n",
       "      <th>family</th>\n",
       "      <th>exchange</th>\n",
       "      <th>market</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>symbol</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>AAAAX</th>\n",
       "      <td>DWS RREEF Real Assets Fund - Class A</td>\n",
       "      <td>USD</td>\n",
       "      <td>The investment seeks total return in excess of...</td>\n",
       "      <td>John  Vojticek</td>\n",
       "      <td>Co-Head of Liquid Real Assets / Chief Investme...</td>\n",
       "      <td>Equities</td>\n",
       "      <td>World</td>\n",
       "      <td>DWS</td>\n",
       "      <td>NAS</td>\n",
       "      <td>us_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AAACX</th>\n",
       "      <td>A3 Alternative Credit Fund</td>\n",
       "      <td>USD</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NAS</td>\n",
       "      <td>us_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AAAEX</th>\n",
       "      <td>Virtus AllianzGI Health Sciences Fund Class P</td>\n",
       "      <td>USD</td>\n",
       "      <td>The investment seeks long-term capital appreci...</td>\n",
       "      <td>Peter  Pirsch</td>\n",
       "      <td>Mr. Pirsch is a senior portfolio manager, a se...</td>\n",
       "      <td>Equities</td>\n",
       "      <td>Health Care</td>\n",
       "      <td>Virtus</td>\n",
       "      <td>NAS</td>\n",
       "      <td>us_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AAAFX</th>\n",
       "      <td>American Century One Choice Blend+ 2015 Portfo...</td>\n",
       "      <td>USD</td>\n",
       "      <td>The investment seeks the highest total return ...</td>\n",
       "      <td>Scott A. Wilson</td>\n",
       "      <td>Mr. Wilson, Vice President and Portfolio Manag...</td>\n",
       "      <td>Equities</td>\n",
       "      <td>Target Date</td>\n",
       "      <td>American Investments</td>\n",
       "      <td>NAS</td>\n",
       "      <td>us_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AAAGX</th>\n",
       "      <td>Thrivent Large Cap Growth Fund Class A</td>\n",
       "      <td>USD</td>\n",
       "      <td>The investment seeks long-term capital appreci...</td>\n",
       "      <td>Lauri  Brunner</td>\n",
       "      <td>Ms. Brunner has been with Thrivent Financial s...</td>\n",
       "      <td>Equities</td>\n",
       "      <td>Factors</td>\n",
       "      <td>Thrivent Funds</td>\n",
       "      <td>NAS</td>\n",
       "      <td>us_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ZVNBX</th>\n",
       "      <td>Zevenbergen Growth Fund Investor Class</td>\n",
       "      <td>USD</td>\n",
       "      <td>The investment seeks long-term capital appreci...</td>\n",
       "      <td>Joseph  Dennison</td>\n",
       "      <td>Mr. Dennison joined ZCI in 2011.√Ç¬†√Ç¬† In hi...</td>\n",
       "      <td>Equities</td>\n",
       "      <td>Factors</td>\n",
       "      <td>Zevenbergen Capital Investments</td>\n",
       "      <td>NAS</td>\n",
       "      <td>us_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ZVNIX</th>\n",
       "      <td>Zevenbergen Growth Fund Institutional Class</td>\n",
       "      <td>USD</td>\n",
       "      <td>The investment seeks long-term capital appreci...</td>\n",
       "      <td>Joseph  Dennison</td>\n",
       "      <td>Mr. Dennison joined ZCI in 2011.√Ç¬†√Ç¬† In hi...</td>\n",
       "      <td>Equities</td>\n",
       "      <td>Factors</td>\n",
       "      <td>Zevenbergen Capital Investments</td>\n",
       "      <td>NAS</td>\n",
       "      <td>us_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ZVZZCNX</th>\n",
       "      <td>Nasdaq NextShares Test Instrume</td>\n",
       "      <td>USD</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NAS</td>\n",
       "      <td>us_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ZZZAX</th>\n",
       "      <td>Test Demand Deposit Account - T</td>\n",
       "      <td>USD</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NAS</td>\n",
       "      <td>us_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ZZZZIX</th>\n",
       "      <td>Nasdaq Test - AIP Managed Futur</td>\n",
       "      <td>USD</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NAS</td>\n",
       "      <td>us_market</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>31440 rows × 10 columns</p>\n",
       "</div>"
      ],
      "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()"
   ]
  },
  {
   "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",
      "    Description\n",
      "    ----\n",
      "    Returns all funds when no input is given and has the option to give\n",
      "    a specific set of symbols for the category and/or family provided.\n",
      "    \n",
      "    The data depends on the combination of inputs. For example Category + Family\n",
      "    gives all symbols for a specific category for a specific family.\n",
      "    \n",
      "    Input\n",
      "    ----\n",
      "    category_group (string, default is None)\n",
      "        If filled, gives all data for a specific category group.\n",
      "    category (string, default is None)\n",
      "        If filled, gives all data for a specific category.\n",
      "    family (string, default is None)\n",
      "        If filled, gives all data for a specific family.\n",
      "    exclude_exchanges (boolean, default is True):\n",
      "        Whether you want to exclude exchanges from the search. If False,\n",
      "        you will receive multiple times the product from different exchanges.\n",
      "    capitalize (boolean, default is True):\n",
      "        Whether country, sector and industry needs to be capitalized. By default\n",
      "        the values always are capitalized as that is also how it is represented\n",
      "        in the csv files.\n",
      "    base_url (string, default is GitHub location)\n",
      "        The possibility to enter your own location if desired.\n",
      "    use_local_location (string, default False)\n",
      "        The possibility to select a local location (i.e. based on Windows path)\n",
      "    \n",
      "    Output\n",
      "    ----\n",
      "    funds_df (pd.DataFrame)\n",
      "        Returns a dictionary with a selection or all data based on the input.\n",
      "\n"
     ]
    }
   ],
   "source": [
    "help(funds.select)"
   ]
  },
  {
   "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": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>name</th>\n",
       "      <th>currency</th>\n",
       "      <th>summary</th>\n",
       "      <th>manager_name</th>\n",
       "      <th>manager_bio</th>\n",
       "      <th>category_group</th>\n",
       "      <th>category</th>\n",
       "      <th>family</th>\n",
       "      <th>exchange</th>\n",
       "      <th>market</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>symbol</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>AACFX</th>\n",
       "      <td>Invesco Greater China Fund Class A</td>\n",
       "      <td>USD</td>\n",
       "      <td>The investment seeks long-term growth of capit...</td>\n",
       "      <td>Mike  Shiao</td>\n",
       "      <td>Mike Shiao has 25 years of investment experien...</td>\n",
       "      <td>Equities</td>\n",
       "      <td>China</td>\n",
       "      <td>Invesco Asset Management</td>\n",
       "      <td>NAS</td>\n",
       "      <td>us_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ACEAX</th>\n",
       "      <td>AB All China Equity Portfolio Class A</td>\n",
       "      <td>USD</td>\n",
       "      <td>The investment seeks long-term growth of capit...</td>\n",
       "      <td>Stuart  Rae</td>\n",
       "      <td>Stuart Rae has been Chief Investment Officer o...</td>\n",
       "      <td>Equities</td>\n",
       "      <td>China</td>\n",
       "      <td>AllianceBernstein</td>\n",
       "      <td>NAS</td>\n",
       "      <td>us_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ACEYX</th>\n",
       "      <td>AB All China Equity Portfolio Advisor Class</td>\n",
       "      <td>USD</td>\n",
       "      <td>The investment seeks long-term growth of capit...</td>\n",
       "      <td>Stuart  Rae</td>\n",
       "      <td>Stuart Rae has been Chief Investment Officer o...</td>\n",
       "      <td>Equities</td>\n",
       "      <td>China</td>\n",
       "      <td>AllianceBernstein</td>\n",
       "      <td>NAS</td>\n",
       "      <td>us_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AMCYX</th>\n",
       "      <td>Invesco Greater China Fund Class Y</td>\n",
       "      <td>USD</td>\n",
       "      <td>The investment seeks long-term growth of capit...</td>\n",
       "      <td>Mike  Shiao</td>\n",
       "      <td>Mike Shiao has 25 years of investment experien...</td>\n",
       "      <td>Equities</td>\n",
       "      <td>China</td>\n",
       "      <td>Invesco Asset Management</td>\n",
       "      <td>NAS</td>\n",
       "      <td>us_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BCAKX</th>\n",
       "      <td>Baillie Gifford China A Shares Fund Class K</td>\n",
       "      <td>USD</td>\n",
       "      <td>The investment seeks capital appreciation.  Th...</td>\n",
       "      <td>Sophie  Earnshaw</td>\n",
       "      <td>Sophie Earnshaw, CFA, Portfolio Manager, joine...</td>\n",
       "      <td>Equities</td>\n",
       "      <td>China</td>\n",
       "      <td>Baillie Gifford Funds</td>\n",
       "      <td>NAS</td>\n",
       "      <td>us_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>USCOX</th>\n",
       "      <td>U.S. Global Investors China Region Fund Invest...</td>\n",
       "      <td>USD</td>\n",
       "      <td>The investment seeks long-term growth of capit...</td>\n",
       "      <td>Frank  Holmes</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Equities</td>\n",
       "      <td>China</td>\n",
       "      <td>U.S. Global Investors</td>\n",
       "      <td>NAS</td>\n",
       "      <td>us_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WAGCX</th>\n",
       "      <td>Wasatch Greater China Fund Investor Class Shares</td>\n",
       "      <td>USD</td>\n",
       "      <td>The investment seeks long-term growth of capit...</td>\n",
       "      <td>Kevin I. Huerta Unger</td>\n",
       "      <td>Kevin Unger, CFA has been an associate portfol...</td>\n",
       "      <td>Equities</td>\n",
       "      <td>China</td>\n",
       "      <td>Wasatch</td>\n",
       "      <td>NAS</td>\n",
       "      <td>us_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WCMCX</th>\n",
       "      <td>WCM China Quality Growth Fund Institutional Cl...</td>\n",
       "      <td>USD</td>\n",
       "      <td>The investment seeks long-term capital appreci...</td>\n",
       "      <td>Michael Z. Tian</td>\n",
       "      <td>As Business Analyst, Michael√¢¬Ä¬ôs primary re...</td>\n",
       "      <td>Equities</td>\n",
       "      <td>China</td>\n",
       "      <td>WCM Investment Management</td>\n",
       "      <td>NAS</td>\n",
       "      <td>us_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WCQGX</th>\n",
       "      <td>WCM China Quality Growth Fund Investor Class S...</td>\n",
       "      <td>USD</td>\n",
       "      <td>The investment seeks long-term capital appreci...</td>\n",
       "      <td>Michael Z. Tian</td>\n",
       "      <td>As Business Analyst, Michael√¢¬Ä¬ôs primary re...</td>\n",
       "      <td>Equities</td>\n",
       "      <td>China</td>\n",
       "      <td>WCM Investment Management</td>\n",
       "      <td>NAS</td>\n",
       "      <td>us_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WGGCX</th>\n",
       "      <td>Wasatch Greater China Fund Institutional Class...</td>\n",
       "      <td>USD</td>\n",
       "      <td>The investment seeks long-term growth of capit...</td>\n",
       "      <td>Kevin I. Huerta Unger</td>\n",
       "      <td>Kevin Unger, CFA has been an associate portfol...</td>\n",
       "      <td>Equities</td>\n",
       "      <td>China</td>\n",
       "      <td>Wasatch</td>\n",
       "      <td>NAS</td>\n",
       "      <td>us_market</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>79 rows × 10 columns</p>\n",
       "</div>"
      ],
      "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\")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "5f5e775d",
   "metadata": {},
   "source": [
    "## Indices"
   ]
  },
  {
   "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": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>name</th>\n",
       "      <th>currency</th>\n",
       "      <th>market</th>\n",
       "      <th>exchange</th>\n",
       "      <th>exchange timezone</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>symbol</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>GBKX</th>\n",
       "      <td>KBW Nasdaq Global Bank Index</td>\n",
       "      <td>NaN</td>\n",
       "      <td>us_market</td>\n",
       "      <td>NIM</td>\n",
       "      <td>EDT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GBKXN</th>\n",
       "      <td>KBW Nasdaq Global Bank Net Total Return Index</td>\n",
       "      <td>NaN</td>\n",
       "      <td>us_market</td>\n",
       "      <td>NIM</td>\n",
       "      <td>EDT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GBKXT</th>\n",
       "      <td>KBW Nasdaq Global Bank Total Return Index</td>\n",
       "      <td>NaN</td>\n",
       "      <td>us_market</td>\n",
       "      <td>NIM</td>\n",
       "      <td>EDT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>^A1BSC</th>\n",
       "      <td>Dow Jones Americas Basic Materi</td>\n",
       "      <td>USD</td>\n",
       "      <td>us_market</td>\n",
       "      <td>DJI</td>\n",
       "      <td>EDT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>^A1CYC</th>\n",
       "      <td>Dow Jones Americas Consumer Ser</td>\n",
       "      <td>USD</td>\n",
       "      <td>us_market</td>\n",
       "      <td>DJI</td>\n",
       "      <td>EDT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>^ZSL-EU</th>\n",
       "      <td>ProShares UltraShort Silver (Es</td>\n",
       "      <td>USD</td>\n",
       "      <td>us_market</td>\n",
       "      <td>ASE</td>\n",
       "      <td>EDT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>^ZSL-IV</th>\n",
       "      <td>ProShares UltraShort Silver (In</td>\n",
       "      <td>USD</td>\n",
       "      <td>us_market</td>\n",
       "      <td>ASE</td>\n",
       "      <td>EDT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>^ZSL-NV</th>\n",
       "      <td>ProShares UltraShort Silver (Ne</td>\n",
       "      <td>USD</td>\n",
       "      <td>us_market</td>\n",
       "      <td>ASE</td>\n",
       "      <td>EDT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>^ZSL-TC</th>\n",
       "      <td>ProShares UltraShort Silver (To</td>\n",
       "      <td>USD</td>\n",
       "      <td>us_market</td>\n",
       "      <td>ASE</td>\n",
       "      <td>EDT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>^ZVZZT-624</th>\n",
       "      <td>ZVZZT.624 Test Symbol</td>\n",
       "      <td>USD</td>\n",
       "      <td>us_market</td>\n",
       "      <td>NYS</td>\n",
       "      <td>EDT</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>62140 rows × 5 columns</p>\n",
       "</div>"
      ],
      "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()"
   ]
  },
  {
   "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",
      "    Description\n",
      "    ----\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",
      "    Input\n",
      "    ----\n",
      "    currency (string, default is None)\n",
      "        If filled, gives all data for a specific currency.\n",
      "    capitalize (boolean, default is True):\n",
      "        Whether the currency needs to be capitalized. By default the values\n",
      "        always are capitalized as that is also how it is represented in the csv files.\n",
      "    exclude_exchanges (boolean, default is True):\n",
      "        Whether you want to exclude exchanges from the search. If False,\n",
      "        you will receive multiple times the product from different exchanges.\n",
      "    base_url (string, default is GitHub location)\n",
      "        The possibility to enter your own location if desired.\n",
      "    use_local_location (string, default False)\n",
      "        The possibility to select a local location (i.e. based on Windows path)\n",
      "    \n",
      "    Output\n",
      "    ----\n",
      "    indices_df (pd.DataFrame)\n",
      "        Returns a dictionary with a selection or all data based on the input.\n",
      "\n"
     ]
    }
   ],
   "source": [
    "help(indices.select)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "b6679da8",
   "metadata": {},
   "source": [
    "## Currencies"
   ]
  },
  {
   "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": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>name</th>\n",
       "      <th>base_currency</th>\n",
       "      <th>quote_currency</th>\n",
       "      <th>exchange</th>\n",
       "      <th>market</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>symbol</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>AED=X</th>\n",
       "      <td>USD/AED</td>\n",
       "      <td>USD</td>\n",
       "      <td>AED</td>\n",
       "      <td>CCY</td>\n",
       "      <td>ccy_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AEDAUD=X</th>\n",
       "      <td>AED/AUD</td>\n",
       "      <td>AED</td>\n",
       "      <td>AUD</td>\n",
       "      <td>CCY</td>\n",
       "      <td>ccy_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AEDBRX=X</th>\n",
       "      <td>AED/BRX</td>\n",
       "      <td>AED</td>\n",
       "      <td>BRX</td>\n",
       "      <td>CCY</td>\n",
       "      <td>ccy_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AEDCAD=X</th>\n",
       "      <td>AED/CAD</td>\n",
       "      <td>AED</td>\n",
       "      <td>CAD</td>\n",
       "      <td>CCY</td>\n",
       "      <td>ccy_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AEDCHF=X</th>\n",
       "      <td>AED/CHF</td>\n",
       "      <td>AED</td>\n",
       "      <td>CHF</td>\n",
       "      <td>CCY</td>\n",
       "      <td>ccy_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ZMWEUR=X</th>\n",
       "      <td>ZMW/EUR</td>\n",
       "      <td>ZMW</td>\n",
       "      <td>EUR</td>\n",
       "      <td>CCY</td>\n",
       "      <td>ccy_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ZMWGBP=X</th>\n",
       "      <td>ZMW/GBP</td>\n",
       "      <td>ZMW</td>\n",
       "      <td>GBP</td>\n",
       "      <td>CCY</td>\n",
       "      <td>ccy_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ZMWJPY=X</th>\n",
       "      <td>ZMW/JPY</td>\n",
       "      <td>ZMW</td>\n",
       "      <td>JPY</td>\n",
       "      <td>CCY</td>\n",
       "      <td>ccy_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ZMWUSD=X</th>\n",
       "      <td>ZMW/USD</td>\n",
       "      <td>ZMW</td>\n",
       "      <td>USD</td>\n",
       "      <td>CCY</td>\n",
       "      <td>ccy_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ZMWZAR=X</th>\n",
       "      <td>ZMW/ZAR</td>\n",
       "      <td>ZMW</td>\n",
       "      <td>ZAR</td>\n",
       "      <td>CCY</td>\n",
       "      <td>ccy_market</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2556 rows × 5 columns</p>\n",
       "</div>"
      ],
      "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()"
   ]
  },
  {
   "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",
      "    Description\n",
      "    ----\n",
      "    Returns all currencies when no input is given and has the option to give\n",
      "    a specific combination of currencies based on the from or to currency defined.\n",
      "    \n",
      "    Input\n",
      "    ----\n",
      "    base_currency (string, default is None)\n",
      "        If filled, gives all data for the base currency.\n",
      "    quote_currency\n",
      "        If filled, gives all data for the quote currency.\n",
      "    capitalize (boolean, default is True):\n",
      "        Whether the currency needs to be capitalized. By default the values\n",
      "        always are capitalized as that is also how it is represented in the csv files.\n",
      "    base_url (string, default is GitHub location)\n",
      "        The possibility to enter your own location if desired.\n",
      "    use_local_location (string, default False)\n",
      "        The possibility to select a local location (i.e. based on Windows path)\n",
      "    \n",
      "    Output\n",
      "    ----\n",
      "    currencies_df (pd.DataFrame)\n",
      "        Returns a dictionary with a selection or all data based on the input.\n",
      "\n"
     ]
    }
   ],
   "source": [
    "# Help Window\n",
    "help(currencies.select)"
   ]
  },
  {
   "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": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>name</th>\n",
       "      <th>base_currency</th>\n",
       "      <th>quote_currency</th>\n",
       "      <th>exchange</th>\n",
       "      <th>market</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>symbol</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>AEDAUD=X</th>\n",
       "      <td>AED/AUD</td>\n",
       "      <td>AED</td>\n",
       "      <td>AUD</td>\n",
       "      <td>CCY</td>\n",
       "      <td>ccy_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AEDBRX=X</th>\n",
       "      <td>AED/BRX</td>\n",
       "      <td>AED</td>\n",
       "      <td>BRX</td>\n",
       "      <td>CCY</td>\n",
       "      <td>ccy_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AEDCAD=X</th>\n",
       "      <td>AED/CAD</td>\n",
       "      <td>AED</td>\n",
       "      <td>CAD</td>\n",
       "      <td>CCY</td>\n",
       "      <td>ccy_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AEDCHF=X</th>\n",
       "      <td>AED/CHF</td>\n",
       "      <td>AED</td>\n",
       "      <td>CHF</td>\n",
       "      <td>CCY</td>\n",
       "      <td>ccy_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AEDEUR=X</th>\n",
       "      <td>AED/EUR</td>\n",
       "      <td>AED</td>\n",
       "      <td>EUR</td>\n",
       "      <td>CCY</td>\n",
       "      <td>ccy_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AEDGBP=X</th>\n",
       "      <td>AED/GBP</td>\n",
       "      <td>AED</td>\n",
       "      <td>GBP</td>\n",
       "      <td>CCY</td>\n",
       "      <td>ccy_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AEDHKD=X</th>\n",
       "      <td>AED/HKD</td>\n",
       "      <td>AED</td>\n",
       "      <td>HKD</td>\n",
       "      <td>CCY</td>\n",
       "      <td>ccy_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AEDINR=X</th>\n",
       "      <td>AED/INR</td>\n",
       "      <td>AED</td>\n",
       "      <td>INR</td>\n",
       "      <td>CCY</td>\n",
       "      <td>ccy_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AEDJPY=X</th>\n",
       "      <td>AED/JPY</td>\n",
       "      <td>AED</td>\n",
       "      <td>JPY</td>\n",
       "      <td>CCY</td>\n",
       "      <td>ccy_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AEDKRW=X</th>\n",
       "      <td>AED/KRW</td>\n",
       "      <td>AED</td>\n",
       "      <td>KRW</td>\n",
       "      <td>CCY</td>\n",
       "      <td>ccy_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AEDKWD=X</th>\n",
       "      <td>AED/KWD</td>\n",
       "      <td>AED</td>\n",
       "      <td>KWD</td>\n",
       "      <td>CCY</td>\n",
       "      <td>ccy_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AEDLKR=X</th>\n",
       "      <td>AED/LKR</td>\n",
       "      <td>AED</td>\n",
       "      <td>LKR</td>\n",
       "      <td>CCY</td>\n",
       "      <td>ccy_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AEDMAD=X</th>\n",
       "      <td>AED/MAD</td>\n",
       "      <td>AED</td>\n",
       "      <td>MAD</td>\n",
       "      <td>CCY</td>\n",
       "      <td>ccy_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AEDMUR=X</th>\n",
       "      <td>AED/MUR</td>\n",
       "      <td>AED</td>\n",
       "      <td>MUR</td>\n",
       "      <td>CCY</td>\n",
       "      <td>ccy_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AEDMYX=X</th>\n",
       "      <td>AED/MYX</td>\n",
       "      <td>AED</td>\n",
       "      <td>MYX</td>\n",
       "      <td>CCY</td>\n",
       "      <td>ccy_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AEDNOK=X</th>\n",
       "      <td>AED/NOK</td>\n",
       "      <td>AED</td>\n",
       "      <td>NOK</td>\n",
       "      <td>CCY</td>\n",
       "      <td>ccy_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AEDNZD=X</th>\n",
       "      <td>AED/NZD</td>\n",
       "      <td>AED</td>\n",
       "      <td>NZD</td>\n",
       "      <td>CCY</td>\n",
       "      <td>ccy_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AEDOMR=X</th>\n",
       "      <td>AED/OMR</td>\n",
       "      <td>AED</td>\n",
       "      <td>OMR</td>\n",
       "      <td>CCY</td>\n",
       "      <td>ccy_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AEDPKR=X</th>\n",
       "      <td>AED/PKR</td>\n",
       "      <td>AED</td>\n",
       "      <td>PKR</td>\n",
       "      <td>CCY</td>\n",
       "      <td>ccy_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AEDQAR=X</th>\n",
       "      <td>AED/QAR</td>\n",
       "      <td>AED</td>\n",
       "      <td>QAR</td>\n",
       "      <td>CCY</td>\n",
       "      <td>ccy_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AEDSAR=X</th>\n",
       "      <td>AED/SAR</td>\n",
       "      <td>AED</td>\n",
       "      <td>SAR</td>\n",
       "      <td>CCY</td>\n",
       "      <td>ccy_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AEDSEK=X</th>\n",
       "      <td>AED/SEK</td>\n",
       "      <td>AED</td>\n",
       "      <td>SEK</td>\n",
       "      <td>CCY</td>\n",
       "      <td>ccy_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AEDSGD=X</th>\n",
       "      <td>AED/SGD</td>\n",
       "      <td>AED</td>\n",
       "      <td>SGD</td>\n",
       "      <td>CCY</td>\n",
       "      <td>ccy_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AEDTHX=X</th>\n",
       "      <td>AED/THX</td>\n",
       "      <td>AED</td>\n",
       "      <td>THX</td>\n",
       "      <td>CCY</td>\n",
       "      <td>ccy_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AEDTRY=X</th>\n",
       "      <td>AED/TRY</td>\n",
       "      <td>AED</td>\n",
       "      <td>TRY</td>\n",
       "      <td>CCY</td>\n",
       "      <td>ccy_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AEDUSD=X</th>\n",
       "      <td>AED/USD</td>\n",
       "      <td>AED</td>\n",
       "      <td>USD</td>\n",
       "      <td>CCY</td>\n",
       "      <td>ccy_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AEDXDR=X</th>\n",
       "      <td>AED/XDR</td>\n",
       "      <td>AED</td>\n",
       "      <td>XDR</td>\n",
       "      <td>CCY</td>\n",
       "      <td>ccy_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AEDZAR=X</th>\n",
       "      <td>AED/ZAR</td>\n",
       "      <td>AED</td>\n",
       "      <td>ZAR</td>\n",
       "      <td>CCY</td>\n",
       "      <td>ccy_market</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "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\")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "065b35a2",
   "metadata": {},
   "source": [
    "## Cryptocurrencies"
   ]
  },
  {
   "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": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>name</th>\n",
       "      <th>cryptocurrency</th>\n",
       "      <th>currency</th>\n",
       "      <th>summary</th>\n",
       "      <th>exchange</th>\n",
       "      <th>market</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>symbol</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>AAVE-CAD</th>\n",
       "      <td>Aave CAD</td>\n",
       "      <td>AAVE</td>\n",
       "      <td>CAD</td>\n",
       "      <td>Aave (AAVE) is a cryptocurrency and operates o...</td>\n",
       "      <td>CCC</td>\n",
       "      <td>ccc_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AAVE-CNY</th>\n",
       "      <td>Aave CNY</td>\n",
       "      <td>AAVE</td>\n",
       "      <td>CNY</td>\n",
       "      <td>Aave (AAVE) is a cryptocurrency and operates o...</td>\n",
       "      <td>CCC</td>\n",
       "      <td>ccc_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AAVE-ETH</th>\n",
       "      <td>Aave ETH</td>\n",
       "      <td>AAVE</td>\n",
       "      <td>ETH</td>\n",
       "      <td>Aave (AAVE) is a cryptocurrency and operates o...</td>\n",
       "      <td>CCC</td>\n",
       "      <td>ccc_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AAVE-EUR</th>\n",
       "      <td>Aave EUR</td>\n",
       "      <td>AAVE</td>\n",
       "      <td>EUR</td>\n",
       "      <td>Aave (AAVE) is a cryptocurrency and operates o...</td>\n",
       "      <td>CCC</td>\n",
       "      <td>ccc_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AAVE-GBP</th>\n",
       "      <td>Aave GBP</td>\n",
       "      <td>AAVE</td>\n",
       "      <td>GBP</td>\n",
       "      <td>Aave (AAVE) is a cryptocurrency and operates o...</td>\n",
       "      <td>CCC</td>\n",
       "      <td>ccc_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ZYN-INR</th>\n",
       "      <td>Zynecoin INR</td>\n",
       "      <td>ZYN</td>\n",
       "      <td>INR</td>\n",
       "      <td>Zynecoin (ZYN) is a cryptocurrency . Users are...</td>\n",
       "      <td>CCC</td>\n",
       "      <td>ccc_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ZYN-JPY</th>\n",
       "      <td>Zynecoin JPY</td>\n",
       "      <td>ZYN</td>\n",
       "      <td>JPY</td>\n",
       "      <td>Zynecoin (ZYN) is a cryptocurrency . Users are...</td>\n",
       "      <td>CCC</td>\n",
       "      <td>ccc_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ZYN-KRW</th>\n",
       "      <td>Zynecoin KRW</td>\n",
       "      <td>ZYN</td>\n",
       "      <td>KRW</td>\n",
       "      <td>Zynecoin (ZYN) is a cryptocurrency . Users are...</td>\n",
       "      <td>CCC</td>\n",
       "      <td>ccc_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ZYN-RUB</th>\n",
       "      <td>Zynecoin RUB</td>\n",
       "      <td>ZYN</td>\n",
       "      <td>RUB</td>\n",
       "      <td>Zynecoin (ZYN) is a cryptocurrency . Users are...</td>\n",
       "      <td>CCC</td>\n",
       "      <td>ccc_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ZYN-USD</th>\n",
       "      <td>Zynecoin USD</td>\n",
       "      <td>ZYN</td>\n",
       "      <td>USD</td>\n",
       "      <td>Zynecoin (ZYN) is a cryptocurrency . Users are...</td>\n",
       "      <td>CCC</td>\n",
       "      <td>ccc_market</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3367 rows × 6 columns</p>\n",
       "</div>"
      ],
      "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()"
   ]
  },
  {
   "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",
      "    Description\n",
      "    ----\n",
      "    Returns all cryptos when no input is given and has the option to give\n",
      "    a specific combination of cryptos based on the crypto defined.\n",
      "    \n",
      "    \n",
      "    Input\n",
      "    ----\n",
      "    crypto (string, default is None)\n",
      "        If filled, gives all data for a specific crypto.\n",
      "    capitalize (boolean, default is True):\n",
      "        Whether the crypto needs to be capitalized. By default the values\n",
      "        always are capitalized as that is also how it is represented in the csv files.\n",
      "    base_url (string, default is GitHub location)\n",
      "        The possibility to enter your own location if desired.\n",
      "    use_local_location (string, default False)\n",
      "        The possibility to select a local location (i.e. based on Windows path)\n",
      "    \n",
      "    Output\n",
      "    ----\n",
      "    cryptos_df (pd.DataFrame)\n",
      "        Returns a dictionary with a selection or all data based on the input.\n",
      "\n"
     ]
    }
   ],
   "source": [
    "help(cryptos.select)"
   ]
  },
  {
   "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": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>name</th>\n",
       "      <th>cryptocurrency</th>\n",
       "      <th>currency</th>\n",
       "      <th>summary</th>\n",
       "      <th>exchange</th>\n",
       "      <th>market</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>symbol</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>ETH-BTC</th>\n",
       "      <td>Ethereum BTC</td>\n",
       "      <td>ETH</td>\n",
       "      <td>BTC</td>\n",
       "      <td>Ethereum (ETH) is a cryptocurrency . Users are...</td>\n",
       "      <td>CCC</td>\n",
       "      <td>ccc_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ETH-CAD</th>\n",
       "      <td>Ethereum CAD</td>\n",
       "      <td>ETH</td>\n",
       "      <td>CAD</td>\n",
       "      <td>Ethereum (ETH) is a cryptocurrency . Users are...</td>\n",
       "      <td>CCC</td>\n",
       "      <td>ccc_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ETH-EUR</th>\n",
       "      <td>Ethereum EUR</td>\n",
       "      <td>ETH</td>\n",
       "      <td>EUR</td>\n",
       "      <td>Ethereum (ETH) is a cryptocurrency . Users are...</td>\n",
       "      <td>CCC</td>\n",
       "      <td>ccc_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ETH-GBP</th>\n",
       "      <td>Ethereum GBP</td>\n",
       "      <td>ETH</td>\n",
       "      <td>GBP</td>\n",
       "      <td>Ethereum (ETH) is a cryptocurrency . Users are...</td>\n",
       "      <td>CCC</td>\n",
       "      <td>ccc_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ETH-USD</th>\n",
       "      <td>Ethereum USD</td>\n",
       "      <td>ETH</td>\n",
       "      <td>USD</td>\n",
       "      <td>Ethereum (ETH) is a cryptocurrency . Users are...</td>\n",
       "      <td>CCC</td>\n",
       "      <td>ccc_market</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "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\")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "df9c87c5",
   "metadata": {},
   "source": [
    "## Moneymarkets"
   ]
  },
  {
   "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": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>name</th>\n",
       "      <th>category</th>\n",
       "      <th>currency</th>\n",
       "      <th>market</th>\n",
       "      <th>exchange</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>symbol</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>AABXX</th>\n",
       "      <td>SEI Daily Income Trust Government Fund</td>\n",
       "      <td>NaN</td>\n",
       "      <td>USD</td>\n",
       "      <td>us_market</td>\n",
       "      <td>NAS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AAFXX</th>\n",
       "      <td>American Funds U.S. Government</td>\n",
       "      <td>NaN</td>\n",
       "      <td>USD</td>\n",
       "      <td>us_market</td>\n",
       "      <td>NAS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AALXX</th>\n",
       "      <td>Thrivent Money Market Fund</td>\n",
       "      <td>Thrivent Mutual Funds</td>\n",
       "      <td>USD</td>\n",
       "      <td>us_market</td>\n",
       "      <td>NAS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AAOXX</th>\n",
       "      <td>American Beacon U.S. Government Money Market S...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>USD</td>\n",
       "      <td>us_market</td>\n",
       "      <td>NAS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AARXX</th>\n",
       "      <td>AARP Money Market Fund</td>\n",
       "      <td>NaN</td>\n",
       "      <td>USD</td>\n",
       "      <td>us_market</td>\n",
       "      <td>NAS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WRNXX</th>\n",
       "      <td>Ivy Government Money Market Fund</td>\n",
       "      <td>Ivy Funds</td>\n",
       "      <td>USD</td>\n",
       "      <td>us_market</td>\n",
       "      <td>NAS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WTLXX</th>\n",
       "      <td>Treasury Plus Money Market Fund</td>\n",
       "      <td>Wells Fargo Funds Trust</td>\n",
       "      <td>USD</td>\n",
       "      <td>us_market</td>\n",
       "      <td>NAS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WTPXX</th>\n",
       "      <td>Treasury Plus Money Market Fund</td>\n",
       "      <td>Wells Fargo Funds Trust</td>\n",
       "      <td>USD</td>\n",
       "      <td>us_market</td>\n",
       "      <td>NAS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WTRXX</th>\n",
       "      <td>100% Treasury Money Market Fund</td>\n",
       "      <td>Wells Fargo Funds Trust</td>\n",
       "      <td>USD</td>\n",
       "      <td>us_market</td>\n",
       "      <td>NAS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WUCXX</th>\n",
       "      <td>Municipal Cash Management Money Market Fund</td>\n",
       "      <td>Wells Fargo Advantage Money Market Funds</td>\n",
       "      <td>USD</td>\n",
       "      <td>us_market</td>\n",
       "      <td>NAS</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1364 rows × 5 columns</p>\n",
       "</div>"
      ],
      "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()"
   ]
  },
  {
   "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",
      "    Description\n",
      "    ----\n",
      "    Returns all moneymarkets when no input is given and has the option to give\n",
      "    a specific combination of moneymarkets based on the currency defined.\n",
      "    \n",
      "    Input\n",
      "    ----\n",
      "    category (string, default is None)\n",
      "        If filled, gives all data for a specific category.\n",
      "    capitalize (boolean, default is True):\n",
      "        Whether the currency needs to be capitalized. By default the values\n",
      "        always are capitalized as that is also how it is represented in the csv files.\n",
      "    exclude_exchanges (boolean, default is True):\n",
      "        Whether you want to exclude exchanges from the search. If False,\n",
      "        you will receive multiple times the product from different exchanges.\n",
      "    base_url (string, default is GitHub location)\n",
      "        The possibility to enter your own location if desired.\n",
      "    use_local_location (string, default False)\n",
      "        The possibility to select a local location (i.e. based on Windows path)\n",
      "    \n",
      "    Output\n",
      "    ----\n",
      "    indices_df (pd.DataFrame)\n",
      "        Returns a dictionary 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": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>name</th>\n",
       "      <th>category</th>\n",
       "      <th>currency</th>\n",
       "      <th>market</th>\n",
       "      <th>exchange</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>symbol</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>GVIXX</th>\n",
       "      <td>Government Money Market Fund</td>\n",
       "      <td>Wells Fargo Funds Trust</td>\n",
       "      <td>USD</td>\n",
       "      <td>us_market</td>\n",
       "      <td>NAS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MMIXX</th>\n",
       "      <td>National Tax-Free Money Market Fund</td>\n",
       "      <td>Wells Fargo Funds Trust</td>\n",
       "      <td>USD</td>\n",
       "      <td>us_market</td>\n",
       "      <td>NAS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NWGXX</th>\n",
       "      <td>Government Money Market Fund</td>\n",
       "      <td>Wells Fargo Funds Trust</td>\n",
       "      <td>USD</td>\n",
       "      <td>us_market</td>\n",
       "      <td>NAS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NWIXX</th>\n",
       "      <td>Cash Investment Money Market Fund</td>\n",
       "      <td>Wells Fargo Funds Trust</td>\n",
       "      <td>USD</td>\n",
       "      <td>us_market</td>\n",
       "      <td>NAS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NWMXX</th>\n",
       "      <td>National Tax-Free Money Market Fund</td>\n",
       "      <td>Wells Fargo Funds Trust</td>\n",
       "      <td>USD</td>\n",
       "      <td>us_market</td>\n",
       "      <td>NAS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NWTXX</th>\n",
       "      <td>100% Treasury Money Market Fund</td>\n",
       "      <td>Wells Fargo Funds Trust</td>\n",
       "      <td>USD</td>\n",
       "      <td>us_market</td>\n",
       "      <td>NAS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PISXX</th>\n",
       "      <td>Treasury Plus Money Market Fund</td>\n",
       "      <td>Wells Fargo Funds Trust</td>\n",
       "      <td>USD</td>\n",
       "      <td>us_market</td>\n",
       "      <td>NAS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PIVXX</th>\n",
       "      <td>Treasury Plus Money Market Fund</td>\n",
       "      <td>Wells Fargo Funds Trust</td>\n",
       "      <td>USD</td>\n",
       "      <td>us_market</td>\n",
       "      <td>NAS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PRVXX</th>\n",
       "      <td>Treasury Plus Money Market Fund</td>\n",
       "      <td>Wells Fargo Funds Trust</td>\n",
       "      <td>USD</td>\n",
       "      <td>us_market</td>\n",
       "      <td>NAS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SHIXX</th>\n",
       "      <td>Heritage Money Market Fund</td>\n",
       "      <td>Wells Fargo Funds Trust</td>\n",
       "      <td>USD</td>\n",
       "      <td>us_market</td>\n",
       "      <td>NAS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SHMXX</th>\n",
       "      <td>Heritage Money Market Fund</td>\n",
       "      <td>Wells Fargo Funds Trust</td>\n",
       "      <td>USD</td>\n",
       "      <td>us_market</td>\n",
       "      <td>NAS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>STGXX</th>\n",
       "      <td>Money Market Fund</td>\n",
       "      <td>Wells Fargo Funds Trust</td>\n",
       "      <td>USD</td>\n",
       "      <td>us_market</td>\n",
       "      <td>NAS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WFAXX</th>\n",
       "      <td>Cash Investment Money Market Fund</td>\n",
       "      <td>Wells Fargo Funds Trust</td>\n",
       "      <td>USD</td>\n",
       "      <td>us_market</td>\n",
       "      <td>NAS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WFFXX</th>\n",
       "      <td>Government Money Market Fund</td>\n",
       "      <td>Wells Fargo Funds Trust</td>\n",
       "      <td>USD</td>\n",
       "      <td>us_market</td>\n",
       "      <td>NAS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WFGXX</th>\n",
       "      <td>Government Money Market Fund</td>\n",
       "      <td>Wells Fargo Funds Trust</td>\n",
       "      <td>USD</td>\n",
       "      <td>us_market</td>\n",
       "      <td>NAS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WFIXX</th>\n",
       "      <td>Cash Investment Money Market Fund</td>\n",
       "      <td>Wells Fargo Funds Trust</td>\n",
       "      <td>USD</td>\n",
       "      <td>us_market</td>\n",
       "      <td>NAS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WFJXX</th>\n",
       "      <td>Heritage Money Market Fund</td>\n",
       "      <td>Wells Fargo Funds Trust</td>\n",
       "      <td>USD</td>\n",
       "      <td>us_market</td>\n",
       "      <td>NAS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WFNXX</th>\n",
       "      <td>National Tax-Free Money Market Fund</td>\n",
       "      <td>Wells Fargo Funds Trust</td>\n",
       "      <td>USD</td>\n",
       "      <td>us_market</td>\n",
       "      <td>NAS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WFQXX</th>\n",
       "      <td>Cash Investment Money Market Fund</td>\n",
       "      <td>Wells Fargo Funds Trust</td>\n",
       "      <td>USD</td>\n",
       "      <td>us_market</td>\n",
       "      <td>NAS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WFTXX</th>\n",
       "      <td>100% Treasury Money Market Fund</td>\n",
       "      <td>Wells Fargo Funds Trust</td>\n",
       "      <td>USD</td>\n",
       "      <td>us_market</td>\n",
       "      <td>NAS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WGAXX</th>\n",
       "      <td>Government Money Market Fund</td>\n",
       "      <td>Wells Fargo Funds Trust</td>\n",
       "      <td>USD</td>\n",
       "      <td>us_market</td>\n",
       "      <td>NAS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WHTXX</th>\n",
       "      <td>Heritage Money Market Fund</td>\n",
       "      <td>Wells Fargo Funds Trust</td>\n",
       "      <td>USD</td>\n",
       "      <td>us_market</td>\n",
       "      <td>NAS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WMOXX</th>\n",
       "      <td>Money Market Fund</td>\n",
       "      <td>Wells Fargo Funds Trust</td>\n",
       "      <td>USD</td>\n",
       "      <td>us_market</td>\n",
       "      <td>NAS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WMPXX</th>\n",
       "      <td>Money Market Fund</td>\n",
       "      <td>Wells Fargo Funds Trust</td>\n",
       "      <td>USD</td>\n",
       "      <td>us_market</td>\n",
       "      <td>NAS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WNTXX</th>\n",
       "      <td>National Tax-Free Money Market Fund</td>\n",
       "      <td>Wells Fargo Funds Trust</td>\n",
       "      <td>USD</td>\n",
       "      <td>us_market</td>\n",
       "      <td>NAS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WOTXX</th>\n",
       "      <td>100% Treasury Money Market Fund</td>\n",
       "      <td>Wells Fargo Funds Trust</td>\n",
       "      <td>USD</td>\n",
       "      <td>us_market</td>\n",
       "      <td>NAS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WTLXX</th>\n",
       "      <td>Treasury Plus Money Market Fund</td>\n",
       "      <td>Wells Fargo Funds Trust</td>\n",
       "      <td>USD</td>\n",
       "      <td>us_market</td>\n",
       "      <td>NAS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WTPXX</th>\n",
       "      <td>Treasury Plus Money Market Fund</td>\n",
       "      <td>Wells Fargo Funds Trust</td>\n",
       "      <td>USD</td>\n",
       "      <td>us_market</td>\n",
       "      <td>NAS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WTRXX</th>\n",
       "      <td>100% Treasury Money Market Fund</td>\n",
       "      <td>Wells Fargo Funds Trust</td>\n",
       "      <td>USD</td>\n",
       "      <td>us_market</td>\n",
       "      <td>NAS</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "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\")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "eb07e811",
   "metadata": {},
   "source": [
    "# Searching the database in detail"
   ]
  },
  {
   "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": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>name</th>\n",
       "      <th>summary</th>\n",
       "      <th>currency</th>\n",
       "      <th>sector</th>\n",
       "      <th>industry_group</th>\n",
       "      <th>industry</th>\n",
       "      <th>exchange</th>\n",
       "      <th>market</th>\n",
       "      <th>country</th>\n",
       "      <th>state</th>\n",
       "      <th>city</th>\n",
       "      <th>zipcode</th>\n",
       "      <th>website</th>\n",
       "      <th>market_cap</th>\n",
       "      <th>isin</th>\n",
       "      <th>cusip</th>\n",
       "      <th>figi</th>\n",
       "      <th>composite_figi</th>\n",
       "      <th>shareclass_figi</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>symbol</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0E4J.L</th>\n",
       "      <td>Delticom AG</td>\n",
       "      <td>Delticom AG, together with its subsidiaries, o...</td>\n",
       "      <td>EUR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>LSE</td>\n",
       "      <td>London Stock Exchange (international)</td>\n",
       "      <td>Germany</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Hanover</td>\n",
       "      <td>30169</td>\n",
       "      <td>http://www.delti.com</td>\n",
       "      <td>Micro Cap</td>\n",
       "      <td>DE0005146807</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0G73.L</th>\n",
       "      <td>Softing AG</td>\n",
       "      <td>Softing AG develops software, hardware, and sy...</td>\n",
       "      <td>EUR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>LSE</td>\n",
       "      <td>London Stock Exchange (international)</td>\n",
       "      <td>Germany</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Haar</td>\n",
       "      <td>85540</td>\n",
       "      <td>http://company.softing.com/de</td>\n",
       "      <td>Micro Cap</td>\n",
       "      <td>DE0005178008</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0J9O.L</th>\n",
       "      <td>Manz AG</td>\n",
       "      <td>Manz AG engages in the manufacture and sale of...</td>\n",
       "      <td>EUR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>LSE</td>\n",
       "      <td>London Stock Exchange (international)</td>\n",
       "      <td>Germany</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Reutlingen</td>\n",
       "      <td>72768</td>\n",
       "      <td>http://www.manz.com</td>\n",
       "      <td>Small Cap</td>\n",
       "      <td>DE000A0JQ5U3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0MG5.IL</th>\n",
       "      <td>ElringKlinger AG</td>\n",
       "      <td>ElringKlinger AG develops, manufactures, and d...</td>\n",
       "      <td>EUR</td>\n",
       "      <td>Consumer Discretionary</td>\n",
       "      <td>Automobiles &amp; Components</td>\n",
       "      <td>Auto Components</td>\n",
       "      <td>IOB</td>\n",
       "      <td>London Stock Exchange (OTC and ITR)</td>\n",
       "      <td>Germany</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dettingen an der Erms</td>\n",
       "      <td>72581</td>\n",
       "      <td>http://www.elringklinger.com</td>\n",
       "      <td>Small Cap</td>\n",
       "      <td>US2901591022</td>\n",
       "      <td>290159102</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0N5I.L</th>\n",
       "      <td>adesso SE</td>\n",
       "      <td>adesso SE operates as an IT service provider f...</td>\n",
       "      <td>EUR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>LSE</td>\n",
       "      <td>London Stock Exchange (international)</td>\n",
       "      <td>Germany</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dortmund</td>\n",
       "      <td>44269</td>\n",
       "      <td>http://www.adesso.de</td>\n",
       "      <td>Small Cap</td>\n",
       "      <td>DE000A0Z23Q5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ZIL2.HA</th>\n",
       "      <td>ElringKlinger AG</td>\n",
       "      <td>ElringKlinger AG develops, manufactures, and d...</td>\n",
       "      <td>EUR</td>\n",
       "      <td>Consumer Discretionary</td>\n",
       "      <td>Automobiles &amp; Components</td>\n",
       "      <td>Auto Components</td>\n",
       "      <td>HAN</td>\n",
       "      <td>Hanover Stock Exchange</td>\n",
       "      <td>Germany</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dettingen an der Erms</td>\n",
       "      <td>72581</td>\n",
       "      <td>http://www.elringklinger.com</td>\n",
       "      <td>Small Cap</td>\n",
       "      <td>US2901591022</td>\n",
       "      <td>290159102</td>\n",
       "      <td>BBG000PK8T87</td>\n",
       "      <td>BBG000PK8MG3</td>\n",
       "      <td>BBG001SK7Q25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ZIL2.HM</th>\n",
       "      <td>ElringKlinger AG</td>\n",
       "      <td>ElringKlinger AG develops, manufactures, and d...</td>\n",
       "      <td>EUR</td>\n",
       "      <td>Consumer Discretionary</td>\n",
       "      <td>Automobiles &amp; Components</td>\n",
       "      <td>Auto Components</td>\n",
       "      <td>HAM</td>\n",
       "      <td>Hamburg Stock Exchange</td>\n",
       "      <td>Germany</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dettingen an der Erms</td>\n",
       "      <td>72581</td>\n",
       "      <td>http://www.elringklinger.com</td>\n",
       "      <td>Small Cap</td>\n",
       "      <td>US2901591022</td>\n",
       "      <td>290159102</td>\n",
       "      <td>BBG000PK8TG8</td>\n",
       "      <td>BBG000PK8MG3</td>\n",
       "      <td>BBG001SK7Q25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ZIL2.MU</th>\n",
       "      <td>ElringKlinger AG</td>\n",
       "      <td>ElringKlinger AG develops, manufactures, and d...</td>\n",
       "      <td>EUR</td>\n",
       "      <td>Consumer Discretionary</td>\n",
       "      <td>Automobiles &amp; Components</td>\n",
       "      <td>Auto Components</td>\n",
       "      <td>MUN</td>\n",
       "      <td>Munich Stock Exchange</td>\n",
       "      <td>Germany</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dettingen an der Erms</td>\n",
       "      <td>72581</td>\n",
       "      <td>http://www.elringklinger.com</td>\n",
       "      <td>Small Cap</td>\n",
       "      <td>US2901591022</td>\n",
       "      <td>290159102</td>\n",
       "      <td>BBG000PK8R72</td>\n",
       "      <td>BBG000PK8MG3</td>\n",
       "      <td>BBG001SK7Q25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ZIL2.SG</th>\n",
       "      <td>ElringKlinger AG</td>\n",
       "      <td>ElringKlinger AG develops, manufactures, and d...</td>\n",
       "      <td>EUR</td>\n",
       "      <td>Consumer Discretionary</td>\n",
       "      <td>Automobiles &amp; Components</td>\n",
       "      <td>Auto Components</td>\n",
       "      <td>STU</td>\n",
       "      <td>Stuttgart Stock Exchange</td>\n",
       "      <td>Germany</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dettingen an der Erms</td>\n",
       "      <td>72581</td>\n",
       "      <td>http://www.elringklinger.com</td>\n",
       "      <td>Small Cap</td>\n",
       "      <td>US2901591022</td>\n",
       "      <td>290159102</td>\n",
       "      <td>BBG000PK8QW6</td>\n",
       "      <td>BBG000PK8MG3</td>\n",
       "      <td>BBG001SK7Q25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ZIL2.VI</th>\n",
       "      <td>ElringKlinger AG</td>\n",
       "      <td>ElringKlinger AG develops, manufactures, and d...</td>\n",
       "      <td>EUR</td>\n",
       "      <td>Consumer Discretionary</td>\n",
       "      <td>Automobiles &amp; Components</td>\n",
       "      <td>Auto Components</td>\n",
       "      <td>VIE</td>\n",
       "      <td>Vienna Stock Exchange</td>\n",
       "      <td>Germany</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dettingen an der Erms</td>\n",
       "      <td>72581</td>\n",
       "      <td>http://www.elringklinger.com</td>\n",
       "      <td>Small Cap</td>\n",
       "      <td>US2901591022</td>\n",
       "      <td>290159102</td>\n",
       "      <td>BBG00HMXTXD7</td>\n",
       "      <td>BBG00HMXTXC8</td>\n",
       "      <td>BBG001SK7Q25</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>320 rows × 19 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                     name                                            summary  \\\n",
       "symbol                                                                         \n",
       "0E4J.L        Delticom AG  Delticom AG, together with its subsidiaries, o...   \n",
       "0G73.L         Softing AG  Softing AG develops software, hardware, and sy...   \n",
       "0J9O.L            Manz AG  Manz AG engages in the manufacture and sale of...   \n",
       "0MG5.IL  ElringKlinger AG  ElringKlinger AG develops, manufactures, and d...   \n",
       "0N5I.L          adesso SE  adesso SE operates as an IT service provider f...   \n",
       "...                   ...                                                ...   \n",
       "ZIL2.HA  ElringKlinger AG  ElringKlinger AG develops, manufactures, and d...   \n",
       "ZIL2.HM  ElringKlinger AG  ElringKlinger AG develops, manufactures, and d...   \n",
       "ZIL2.MU  ElringKlinger AG  ElringKlinger AG develops, manufactures, and d...   \n",
       "ZIL2.SG  ElringKlinger AG  ElringKlinger AG develops, manufactures, and d...   \n",
       "ZIL2.VI  ElringKlinger AG  ElringKlinger AG develops, manufactures, and d...   \n",
       "\n",
       "        currency                  sector            industry_group  \\\n",
       "symbol                                                               \n",
       "0E4J.L       EUR                     NaN                       NaN   \n",
       "0G73.L       EUR                     NaN                       NaN   \n",
       "0J9O.L       EUR                     NaN                       NaN   \n",
       "0MG5.IL      EUR  Consumer Discretionary  Automobiles & Components   \n",
       "0N5I.L       EUR                     NaN                       NaN   \n",
       "...          ...                     ...                       ...   \n",
       "ZIL2.HA      EUR  Consumer Discretionary  Automobiles & Components   \n",
       "ZIL2.HM      EUR  Consumer Discretionary  Automobiles & Components   \n",
       "ZIL2.MU      EUR  Consumer Discretionary  Automobiles & Components   \n",
       "ZIL2.SG      EUR  Consumer Discretionary  Automobiles & Components   \n",
       "ZIL2.VI      EUR  Consumer Discretionary  Automobiles & Components   \n",
       "\n",
       "                industry exchange                                 market  \\\n",
       "symbol                                                                     \n",
       "0E4J.L               NaN      LSE  London Stock Exchange (international)   \n",
       "0G73.L               NaN      LSE  London Stock Exchange (international)   \n",
       "0J9O.L               NaN      LSE  London Stock Exchange (international)   \n",
       "0MG5.IL  Auto Components      IOB    London Stock Exchange (OTC and ITR)   \n",
       "0N5I.L               NaN      LSE  London Stock Exchange (international)   \n",
       "...                  ...      ...                                    ...   \n",
       "ZIL2.HA  Auto Components      HAN                 Hanover Stock Exchange   \n",
       "ZIL2.HM  Auto Components      HAM                 Hamburg Stock Exchange   \n",
       "ZIL2.MU  Auto Components      MUN                  Munich Stock Exchange   \n",
       "ZIL2.SG  Auto Components      STU               Stuttgart Stock Exchange   \n",
       "ZIL2.VI  Auto Components      VIE                  Vienna Stock Exchange   \n",
       "\n",
       "         country state                   city zipcode  \\\n",
       "symbol                                                  \n",
       "0E4J.L   Germany   NaN                Hanover   30169   \n",
       "0G73.L   Germany   NaN                   Haar   85540   \n",
       "0J9O.L   Germany   NaN             Reutlingen   72768   \n",
       "0MG5.IL  Germany   NaN  Dettingen an der Erms   72581   \n",
       "0N5I.L   Germany   NaN               Dortmund   44269   \n",
       "...          ...   ...                    ...     ...   \n",
       "ZIL2.HA  Germany   NaN  Dettingen an der Erms   72581   \n",
       "ZIL2.HM  Germany   NaN  Dettingen an der Erms   72581   \n",
       "ZIL2.MU  Germany   NaN  Dettingen an der Erms   72581   \n",
       "ZIL2.SG  Germany   NaN  Dettingen an der Erms   72581   \n",
       "ZIL2.VI  Germany   NaN  Dettingen an der Erms   72581   \n",
       "\n",
       "                               website market_cap          isin      cusip  \\\n",
       "symbol                                                                       \n",
       "0E4J.L            http://www.delti.com  Micro Cap  DE0005146807        NaN   \n",
       "0G73.L   http://company.softing.com/de  Micro Cap  DE0005178008        NaN   \n",
       "0J9O.L             http://www.manz.com  Small Cap  DE000A0JQ5U3        NaN   \n",
       "0MG5.IL   http://www.elringklinger.com  Small Cap  US2901591022  290159102   \n",
       "0N5I.L            http://www.adesso.de  Small Cap  DE000A0Z23Q5        NaN   \n",
       "...                                ...        ...           ...        ...   \n",
       "ZIL2.HA   http://www.elringklinger.com  Small Cap  US2901591022  290159102   \n",
       "ZIL2.HM   http://www.elringklinger.com  Small Cap  US2901591022  290159102   \n",
       "ZIL2.MU   http://www.elringklinger.com  Small Cap  US2901591022  290159102   \n",
       "ZIL2.SG   http://www.elringklinger.com  Small Cap  US2901591022  290159102   \n",
       "ZIL2.VI   http://www.elringklinger.com  Small Cap  US2901591022  290159102   \n",
       "\n",
       "                 figi composite_figi shareclass_figi  \n",
       "symbol                                                \n",
       "0E4J.L            NaN            NaN             NaN  \n",
       "0G73.L            NaN            NaN             NaN  \n",
       "0J9O.L            NaN            NaN             NaN  \n",
       "0MG5.IL           NaN            NaN             NaN  \n",
       "0N5I.L            NaN            NaN             NaN  \n",
       "...               ...            ...             ...  \n",
       "ZIL2.HA  BBG000PK8T87   BBG000PK8MG3    BBG001SK7Q25  \n",
       "ZIL2.HM  BBG000PK8TG8   BBG000PK8MG3    BBG001SK7Q25  \n",
       "ZIL2.MU  BBG000PK8R72   BBG000PK8MG3    BBG001SK7Q25  \n",
       "ZIL2.SG  BBG000PK8QW6   BBG000PK8MG3    BBG001SK7Q25  \n",
       "ZIL2.VI  BBG00HMXTXD7   BBG00HMXTXC8    BBG001SK7Q25  \n",
       "\n",
       "[320 rows x 19 columns]"
      ]
     },
     "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=\"EUR\", country=\"Germany\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "id": "922b0763",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>name</th>\n",
       "      <th>category</th>\n",
       "      <th>currency</th>\n",
       "      <th>market</th>\n",
       "      <th>exchange</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>symbol</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>APGXX</th>\n",
       "      <td>U.S. Treasury Fund</td>\n",
       "      <td>Cavanal Hill Funds</td>\n",
       "      <td>USD</td>\n",
       "      <td>us_market</td>\n",
       "      <td>NAS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>APJXX</th>\n",
       "      <td>U.S. Treasury Fund</td>\n",
       "      <td>Cavanal Hill Funds</td>\n",
       "      <td>USD</td>\n",
       "      <td>us_market</td>\n",
       "      <td>NAS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>APKXX</th>\n",
       "      <td>U.S. Treasury Fund</td>\n",
       "      <td>Cavanal Hill Funds</td>\n",
       "      <td>USD</td>\n",
       "      <td>us_market</td>\n",
       "      <td>NAS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>APNXX</th>\n",
       "      <td>U.S. Treasury Fund</td>\n",
       "      <td>Cavanal Hill Funds</td>\n",
       "      <td>USD</td>\n",
       "      <td>us_market</td>\n",
       "      <td>NAS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FDCXX</th>\n",
       "      <td>Treasury Fund</td>\n",
       "      <td>Fidelity Newbury Street Trust</td>\n",
       "      <td>USD</td>\n",
       "      <td>us_market</td>\n",
       "      <td>NAS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FDUXX</th>\n",
       "      <td>Treasury Fund</td>\n",
       "      <td>Fidelity Newbury Street Trust</td>\n",
       "      <td>USD</td>\n",
       "      <td>us_market</td>\n",
       "      <td>NAS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FSRXX</th>\n",
       "      <td>Treasury Fund</td>\n",
       "      <td>Fidelity Newbury Street Trust</td>\n",
       "      <td>USD</td>\n",
       "      <td>us_market</td>\n",
       "      <td>NAS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FZFXX</th>\n",
       "      <td>Treasury Fund</td>\n",
       "      <td>Fidelity Newbury Street Trust</td>\n",
       "      <td>USD</td>\n",
       "      <td>us_market</td>\n",
       "      <td>NAS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TRIXX</th>\n",
       "      <td>Treasury Fund</td>\n",
       "      <td>State Street Institutional Investment Trust</td>\n",
       "      <td>USD</td>\n",
       "      <td>us_market</td>\n",
       "      <td>NAS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TRVXX</th>\n",
       "      <td>Treasury Fund</td>\n",
       "      <td>State Street Institutional Investment Trust</td>\n",
       "      <td>USD</td>\n",
       "      <td>us_market</td>\n",
       "      <td>NAS</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "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": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>name</th>\n",
       "      <th>currency</th>\n",
       "      <th>summary</th>\n",
       "      <th>manager_name</th>\n",
       "      <th>manager_bio</th>\n",
       "      <th>category_group</th>\n",
       "      <th>category</th>\n",
       "      <th>family</th>\n",
       "      <th>exchange</th>\n",
       "      <th>market</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>symbol</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>ACASX</th>\n",
       "      <td>Access Capital Community Investment Fund Class A</td>\n",
       "      <td>USD</td>\n",
       "      <td>The investment seeks to invest in geographical...</td>\n",
       "      <td>Brian  Svendahl</td>\n",
       "      <td>Brian Svendahl oversees our fixed income resea...</td>\n",
       "      <td>Fixed Income</td>\n",
       "      <td>Bonds</td>\n",
       "      <td>RBC Global Asset Management</td>\n",
       "      <td>NAS</td>\n",
       "      <td>us_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ACATX</th>\n",
       "      <td>Access Capital Community Investment Fund Class IS</td>\n",
       "      <td>USD</td>\n",
       "      <td>The investment seeks to invest in geographical...</td>\n",
       "      <td>Brian  Svendahl</td>\n",
       "      <td>Brian Svendahl oversees our fixed income resea...</td>\n",
       "      <td>Fixed Income</td>\n",
       "      <td>Bonds</td>\n",
       "      <td>RBC Global Asset Management</td>\n",
       "      <td>NAS</td>\n",
       "      <td>us_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ACCSX</th>\n",
       "      <td>Access Capital Community Investment Fund Insti...</td>\n",
       "      <td>USD</td>\n",
       "      <td>The investment seeks to invest in geographical...</td>\n",
       "      <td>Brian  Svendahl</td>\n",
       "      <td>Brian Svendahl oversees our fixed income resea...</td>\n",
       "      <td>Fixed Income</td>\n",
       "      <td>Bonds</td>\n",
       "      <td>RBC Global Asset Management</td>\n",
       "      <td>NAS</td>\n",
       "      <td>us_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AHIFX</th>\n",
       "      <td>American Funds American High-Income Trust Clas...</td>\n",
       "      <td>USD</td>\n",
       "      <td>The investment seeks to provide a high level o...</td>\n",
       "      <td>David A. Daigle</td>\n",
       "      <td>David A. Daigle is a fixed-income portfolio ma...</td>\n",
       "      <td>Fixed Income</td>\n",
       "      <td>Bonds</td>\n",
       "      <td>American Investments</td>\n",
       "      <td>NAS</td>\n",
       "      <td>us_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AHITX</th>\n",
       "      <td>American Funds American High-Income Trust Class A</td>\n",
       "      <td>USD</td>\n",
       "      <td>The investment seeks to provide a high level o...</td>\n",
       "      <td>David A. Daigle</td>\n",
       "      <td>David A. Daigle is a fixed-income portfolio ma...</td>\n",
       "      <td>Fixed Income</td>\n",
       "      <td>Bonds</td>\n",
       "      <td>American Investments</td>\n",
       "      <td>NAS</td>\n",
       "      <td>us_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>VUSCX</th>\n",
       "      <td>Invesco Quality Income Fund Class C</td>\n",
       "      <td>USD</td>\n",
       "      <td>The investment seeks a high level of current i...</td>\n",
       "      <td>Clint P. Dudley</td>\n",
       "      <td>Clint Dudley is a Senior Portfolio Manager for...</td>\n",
       "      <td>Fixed Income</td>\n",
       "      <td>Bonds</td>\n",
       "      <td>Invesco Asset Management</td>\n",
       "      <td>NAS</td>\n",
       "      <td>us_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>VUSIX</th>\n",
       "      <td>Invesco Quality Income Fund Class Y</td>\n",
       "      <td>USD</td>\n",
       "      <td>The investment seeks a high level of current i...</td>\n",
       "      <td>Clint P. Dudley</td>\n",
       "      <td>Clint Dudley is a Senior Portfolio Manager for...</td>\n",
       "      <td>Fixed Income</td>\n",
       "      <td>Bonds</td>\n",
       "      <td>Invesco Asset Management</td>\n",
       "      <td>NAS</td>\n",
       "      <td>us_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>VUSJX</th>\n",
       "      <td>Invesco Quality Income Fund R5 Class</td>\n",
       "      <td>USD</td>\n",
       "      <td>The investment seeks a high level of current i...</td>\n",
       "      <td>Clint P. Dudley</td>\n",
       "      <td>Clint Dudley is a Senior Portfolio Manager for...</td>\n",
       "      <td>Fixed Income</td>\n",
       "      <td>Bonds</td>\n",
       "      <td>Invesco Asset Management</td>\n",
       "      <td>NAS</td>\n",
       "      <td>us_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>VUSRX</th>\n",
       "      <td>Invesco Quality Income Fund Class R</td>\n",
       "      <td>USD</td>\n",
       "      <td>The investment seeks a high level of current i...</td>\n",
       "      <td>Clint P. Dudley</td>\n",
       "      <td>Clint Dudley is a Senior Portfolio Manager for...</td>\n",
       "      <td>Fixed Income</td>\n",
       "      <td>Bonds</td>\n",
       "      <td>Invesco Asset Management</td>\n",
       "      <td>NAS</td>\n",
       "      <td>us_market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>VUSSX</th>\n",
       "      <td>Invesco Quality Income Fund Class R6</td>\n",
       "      <td>USD</td>\n",
       "      <td>The investment seeks a high level of current i...</td>\n",
       "      <td>Clint P. Dudley</td>\n",
       "      <td>Clint Dudley is a Senior Portfolio Manager for...</td>\n",
       "      <td>Fixed Income</td>\n",
       "      <td>Bonds</td>\n",
       "      <td>Invesco Asset Management</td>\n",
       "      <td>NAS</td>\n",
       "      <td>us_market</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>110 rows × 10 columns</p>\n",
       "</div>"
      ],
      "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
}