{ "cells": [ { "attachments": {}, "cell_type": "markdown", "id": "83014ba8", "metadata": {}, "source": [ "
\n", " \n", "\n", "\n", "[![GitHub Sponsors](https://img.shields.io/badge/Sponsor_this_Project-grey?logo=github)](https://github.com/sponsors/JerBouma)\n", "[![Documentation](https://img.shields.io/badge/Documentation-grey?logo=readme)](https://www.jeroenbouma.com/projects/financedatabase)\n", "[![Supported Python Versions](https://img.shields.io/pypi/pyversions/financedatabase)](https://pypi.org/project/financedatabase/)\n", "[![PYPI Version](https://img.shields.io/pypi/v/financedatabase)](https://pypi.org/project/financedatabase/)\n", "[![PYPI Downloads](https://static.pepy.tech/badge/financedatabase/month)](https://pepy.tech/project/financedatabase)\n", "\n", "The **FinanceDatabase** serves the role of providing anyone with any type of financial product categorisation entirely for free. To be able to achieve this, the FinanceDatabase relies on involvement from the community to add, edit and remove tickers over time. This is made easy enough that anyone, even with a lack of coding experience can contribute because of the usage of CSV files that can be manually edited. I'd like to invite you to go to the **[Contributing Guidelines](https://github.com/JerBouma/FinanceDatabase/blob/main/CONTRIBUTING.md)** to understand how you can help. Thank you!\n", "\n", "As a private investor, the sheer amount of information that can be found on the internet is rather daunting. Trying to \n", "understand what type of companies or ETFs are available is incredibly challenging with there being millions of\n", "companies and derivatives available on the market. Sure, the most traded companies and ETFs can quickly be found\n", "simply because they are known to the public (for example, Microsoft, Tesla, S&P500 ETF or an All-World ETF). However, \n", "what else is out there is often unknown.\n", "\n", "**This database tries to solve that**. It features 300.000+ symbols containing Equities, ETFs, Funds, Indices, \n", "Currencies, Cryptocurrencies and Money Markets. It therefore allows you to obtain a broad overview of sectors,\n", "industries, types of investments and much more.\n", "\n", "The aim of this database is explicitly _not_ to provide up-to-date fundamentals or stock data as those can be obtained \n", "with ease (with the help of this database) by using the [FinanceToolkit](https://github.com/JerBouma/FinanceToolkit). Instead, it gives insights into the products \n", "that exist in each country, industry and sector and gives the most essential information about each product. With \n", "this information, you can analyse specific areas of the financial world and/or find a product that is hard to find.\n" ] }, { "attachments": {}, "cell_type": "markdown", "id": "3a2a1a46", "metadata": {}, "source": [ "# Installation\n", "To install the FinanceDatabase it simply requires the following:\n", "\n", "```\n", "pip install financedatabase -U\n", "```\n", "\n", "Then within Python use:\n", "\n", "```python\n", "import financedatabase as fd\n", "```" ] }, { "cell_type": "code", "execution_count": 1, "id": "e847b00b", "metadata": {}, "outputs": [], "source": [ "import financedatabase as fd" ] }, { "attachments": {}, "cell_type": "markdown", "id": "d45b268e", "metadata": {}, "source": [ "Let's start off by obtaining the Equities dataset from the Finance Database." ] }, { "cell_type": "code", "execution_count": 2, "id": "6e0271f5", "metadata": {}, "outputs": [], "source": [ "equities = fd.Equities()" ] }, { "cell_type": "markdown", "id": "36a499bb", "metadata": {}, "source": [ "I want to see how many public companies exist in each sector in the Netherlands. Here, I can obtain all stocks that are located in the Netherlands with `country='Netherlands'`. I also include all exchanges by setting `exclude_exchanges=False`. This will give me all stocks that are listed on all exchanges. This is relevant because some stocks are listed on exchanges that are not the American exchanges which the parameter defaults to." ] }, { "cell_type": "code", "execution_count": 3, "id": "3036a48b", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", " | name | \n", "summary | \n", "currency | \n", "sector | \n", "industry_group | \n", "industry | \n", "exchange | \n", "market | \n", "country | \n", "state | \n", "city | \n", "zipcode | \n", "website | \n", "market_cap | \n", "isin | \n", "cusip | \n", "figi | \n", "composite_figi | \n", "shareclass_figi | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
symbol | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
09B.F | \n", "lastminute.com N.V. | \n", "lastminute.com N.V. operates in the online tra... | \n", "EUR | \n", "Consumer Discretionary | \n", "Consumer Services | \n", "Hotels, Restaurants & Leisure | \n", "FRA | \n", "Frankfurt Stock Exchange | \n", "Netherlands | \n", "NaN | \n", "Amsterdam | \n", "1097 JB | \n", "http://lmgroup.lastminute.com | \n", "Small Cap | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
0DI7.L | \n", "AFC Ajax NV | \n", "AFC Ajax NV operates a football club primarily... | \n", "EUR | \n", "NaN | \n", "NaN | \n", "NaN | \n", "LSE | \n", "London Stock Exchange (international) | \n", "Netherlands | \n", "NaN | \n", "Amsterdam | \n", "1101 AX | \n", "http://www.ajax.nl | \n", "Micro Cap | \n", "NL0000018034 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
0DLI.L | \n", "Amsterdam Commodities N.V. | \n", "Amsterdam Commodities N.V., together with its ... | \n", "EUR | \n", "NaN | \n", "NaN | \n", "NaN | \n", "LSE | \n", "London Stock Exchange (international) | \n", "Netherlands | \n", "NaN | \n", "Rotterdam | \n", "3011 DD | \n", "http://www.acomo.nl | \n", "Small Cap | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
0DQK.L | \n", "Beter Bed Holding N.V. | \n", "Beter Bed Holding N.V. operates as a retail- a... | \n", "EUR | \n", "NaN | \n", "NaN | \n", "NaN | \n", "LSE | \n", "London Stock Exchange (international) | \n", "Netherlands | \n", "NaN | \n", "Uden | \n", "5405 AR | \n", "http://www.beterbedholding.com | \n", "Micro Cap | \n", "NL0000339703 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
0E2F.L | \n", "Ctac N.V. | \n", "Ctac N.V. provides business and cloud integrat... | \n", "EUR | \n", "NaN | \n", "NaN | \n", "NaN | \n", "LSE | \n", "London Stock Exchange (international) | \n", "Netherlands | \n", "NaN | \n", "'s-Hertogenbosch | \n", "5216 TZ | \n", "http://www.ctac.nl | \n", "Micro Cap | \n", "NL0000345577 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
YDX.F | \n", "Yandex N.V. | \n", "Yandex N.V., an internet and technology compan... | \n", "EUR | \n", "Communication Services | \n", "Telecommunication Services | \n", "Diversified Telecommunication Services | \n", "FRA | \n", "Frankfurt Stock Exchange | \n", "Netherlands | \n", "NaN | \n", "Schiphol | \n", "1118 BG | \n", "http://ir.yandex.com | \n", "Large Cap | \n", "NL0009805522 | \n", "NaN | \n", "BBG001QCG273 | \n", "BBG001QCG264 | \n", "BBG001TBY593 | \n", "
YDX.MU | \n", "Yandex N.V. | \n", "Yandex N.V., an internet and technology compan... | \n", "EUR | \n", "Communication Services | \n", "Telecommunication Services | \n", "Diversified Telecommunication Services | \n", "MUN | \n", "Munich Stock Exchange | \n", "Netherlands | \n", "NaN | \n", "Schiphol | \n", "1118 BG | \n", "http://ir.yandex.com | \n", "Large Cap | \n", "NL0009805522 | \n", "NaN | \n", "BBG001QCG2C7 | \n", "BBG001QCG264 | \n", "BBG001TBY593 | \n", "
YDX.SG | \n", "Yandex N.V. | \n", "Yandex N.V., an internet and technology compan... | \n", "EUR | \n", "Communication Services | \n", "Telecommunication Services | \n", "Diversified Telecommunication Services | \n", "STU | \n", "Stuttgart Stock Exchange | \n", "Netherlands | \n", "NaN | \n", "Schiphol | \n", "1118 BG | \n", "http://ir.yandex.com | \n", "Large Cap | \n", "NL0009805522 | \n", "NaN | \n", "BBG001QCG2B8 | \n", "BBG001QCG264 | \n", "BBG001TBY593 | \n", "
YNDX | \n", "Yandex N.V. | \n", "Yandex N.V., an internet and technology compan... | \n", "USD | \n", "Communication Services | \n", "Telecommunication Services | \n", "Diversified Telecommunication Services | \n", "NMS | \n", "NASDAQ Global Select | \n", "Netherlands | \n", "NaN | \n", "Schiphol | \n", "1118 BG | \n", "http://ir.yandex.com | \n", "Large Cap | \n", "NL0009805522 | \n", "NaN | \n", "BBG001NVJ7H9 | \n", "BBG001NVJ6W4 | \n", "BBG001TBY593 | \n", "
YNDX.ME | \n", "Yandex N.V. | \n", "Yandex N.V., an internet and technology compan... | \n", "RUB | \n", "Communication Services | \n", "Telecommunication Services | \n", "Diversified Telecommunication Services | \n", "MCX | \n", "Moscow Exchange - MICEX | \n", "Netherlands | \n", "NaN | \n", "Schiphol | \n", "1118 BG | \n", "http://ir.yandex.com | \n", "Large Cap | \n", "NL0009805522 | \n", "NaN | \n", "BBG006L8G4J9 | \n", "BBG006L8G4H1 | \n", "BBG001TBY593 | \n", "
556 rows × 19 columns
\n", "\n", " | name | \n", "
---|---|
sector | \n", "\n", " |
Communication Services | \n", "10 | \n", "
Consumer Discretionary | \n", "22 | \n", "
Consumer Staples | \n", "12 | \n", "
Energy | \n", "6 | \n", "
Financials | \n", "17 | \n", "
Health Care | \n", "16 | \n", "
Industrials | \n", "19 | \n", "
Information Technology | \n", "23 | \n", "
Materials | \n", "9 | \n", "
Real Estate | \n", "9 | \n", "
Utilities | \n", "3 | \n", "
\n", " | name | \n", "summary | \n", "currency | \n", "sector | \n", "industry_group | \n", "industry | \n", "exchange | \n", "market | \n", "country | \n", "state | \n", "city | \n", "zipcode | \n", "website | \n", "market_cap | \n", "isin | \n", "cusip | \n", "figi | \n", "composite_figi | \n", "shareclass_figi | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
symbol | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
4IT.F | \n", "Intertrust N.V. | \n", "Intertrust N.V. provides corporate, fund, capi... | \n", "EUR | \n", "Financials | \n", "Diversified Financials | \n", "Capital Markets | \n", "FRA | \n", "Frankfurt Stock Exchange | \n", "Netherlands | \n", "NaN | \n", "Amsterdam | \n", "1000 AZ | \n", "http://www.intertrustgroup.com | \n", "Small Cap | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
4IT.SG | \n", "Intertrust N.V. | \n", "Intertrust N.V. provides corporate, fund, capi... | \n", "EUR | \n", "Financials | \n", "Diversified Financials | \n", "Capital Markets | \n", "STU | \n", "Stuttgart Stock Exchange | \n", "Netherlands | \n", "NaN | \n", "Amsterdam | \n", "1000 AZ | \n", "http://www.intertrustgroup.com | \n", "Small Cap | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
8FT.BE | \n", "Flow Traders N.V. | \n", "Flow Traders N.V. operates as a financial tech... | \n", "EUR | \n", "Financials | \n", "Diversified Financials | \n", "Capital Markets | \n", "BER | \n", "Berlin Stock Exchange | \n", "Netherlands | \n", "NaN | \n", "Amsterdam | \n", "1018 LL | \n", "http://www.flowtraders.com | \n", "Small Cap | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
8FT.F | \n", "Flow Traders N.V. | \n", "Flow Traders N.V. operates as a financial tech... | \n", "EUR | \n", "Financials | \n", "Diversified Financials | \n", "Capital Markets | \n", "FRA | \n", "Frankfurt Stock Exchange | \n", "Netherlands | \n", "NaN | \n", "Amsterdam | \n", "1018 LL | \n", "http://www.flowtraders.com | \n", "Small Cap | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
8FT.MU | \n", "Flow Traders N.V. | \n", "Flow Traders N.V. operates as a financial tech... | \n", "EUR | \n", "Financials | \n", "Diversified Financials | \n", "Capital Markets | \n", "MUN | \n", "Munich Stock Exchange | \n", "Netherlands | \n", "NaN | \n", "Amsterdam | \n", "1018 LL | \n", "http://www.flowtraders.com | \n", "Small Cap | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
RHCO | \n", "Readen Holding Corp. | \n", "Readen Holding Corp., through its subsidiaries... | \n", "USD | \n", "Financials | \n", "Diversified Financials | \n", "Capital Markets | \n", "PNK | \n", "OTC Bulletin Board | \n", "Netherlands | \n", "NaN | \n", "Kortenhoef | \n", "1241 LZ | \n", "http://www.readenholdingcorp.com | \n", "Nano Cap | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
VA3.F | \n", "Van Lanschot Kempen N.V. | \n", "Van Lanschot Kempen N.V. provides financial se... | \n", "EUR | \n", "Financials | \n", "Banks | \n", "Banks | \n", "FRA | \n", "Frankfurt Stock Exchange | \n", "Netherlands | \n", "NaN | \n", "a€˜s-Hertogenbosch | \n", "5211 JN | \n", "http://www.vanlanschotkempen.com | \n", "Small Cap | \n", "NL0000302636 | \n", "NaN | \n", "BBG000D4J540 | \n", "BBG000D4J452 | \n", "BBG001SCWG18 | \n", "
VA3.SG | \n", "Van Lanschot Kempen N.V. | \n", "Van Lanschot Kempen N.V. provides financial se... | \n", "EUR | \n", "Financials | \n", "Banks | \n", "Banks | \n", "STU | \n", "Stuttgart Stock Exchange | \n", "Netherlands | \n", "NaN | \n", "a€˜s-Hertogenbosch | \n", "5211 JN | \n", "http://www.vanlanschotkempen.com | \n", "Small Cap | \n", "NL0000302636 | \n", "NaN | \n", "BBG000D4J693 | \n", "BBG000D4J452 | \n", "BBG001SCWG18 | \n", "
VALUE.AS | \n", "Value8 N.V. | \n", "Value8 N.V. is a private equity firm specializ... | \n", "EUR | \n", "Financials | \n", "Diversified Financials | \n", "Capital Markets | \n", "AMS | \n", "Euronext Amsterdam | \n", "Netherlands | \n", "NaN | \n", "Bussum | \n", "1401 AB | \n", "http://www.value8.com | \n", "Micro Cap | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
VLK.AS | \n", "Van Lanschot Kempen N.V. | \n", "Van Lanschot Kempen N.V. provides financial se... | \n", "EUR | \n", "Financials | \n", "Banks | \n", "Banks | \n", "AMS | \n", "Euronext Amsterdam | \n", "Netherlands | \n", "NaN | \n", "a€˜s-Hertogenbosch | \n", "5211 JN | \n", "http://www.vanlanschotkempen.com | \n", "Small Cap | \n", "NL0000302636 | \n", "NaN | \n", "BBG000C34T83 | \n", "BBG000C34SD9 | \n", "BBG001SCWG18 | \n", "
64 rows × 19 columns
\n", "