From fc5ea9d9cc9c7ab262ed14b988393f258fdbddd8 Mon Sep 17 00:00:00 2001
From: Igor Radovanovic <74266147+IgorWounds@users.noreply.github.com>
Date: Mon, 27 Nov 2023 23:39:42 +0100
Subject: Notebooks
---
examples/financialStatements.ipynb | 750 +-------------
examples/findSymbols.ipynb | 1180 +---------------------
examples/loadHistoricalPriceData.ipynb | 1713 +-------------------------------
3 files changed, 71 insertions(+), 3572 deletions(-)
diff --git a/examples/financialStatements.ipynb b/examples/financialStatements.ipynb
index 12db7e4874c..15859f43159 100644
--- a/examples/financialStatements.ipynb
+++ b/examples/financialStatements.ipynb
@@ -38,82 +38,9 @@
},
{
"cell_type": "code",
- "execution_count": 1,
+ "execution_count": null,
"metadata": {},
- "outputs": [
- {
- "data": {
- "text/html": [
- "
\n",
- "\n",
- "
\n",
- " \n",
- " \n",
- " | \n",
- " yfinance | \n",
- " fmp | \n",
- " intrinio | \n",
- " polygon | \n",
- "
\n",
- " \n",
- " \n",
- " \n",
- " 0 | \n",
- " 42779000000 | \n",
- " 42779000000 | \n",
- " 42779000000 | \n",
- " 42779000000 | \n",
- "
\n",
- " \n",
- " 1 | \n",
- " 51248000000 | \n",
- " 51248000000 | \n",
- " 51248000000 | \n",
- " 51248000000 | \n",
- "
\n",
- " \n",
- " 2 | \n",
- " 53811000000 | \n",
- " 53811000000 | \n",
- " 53811000000 | \n",
- " 53811000000 | \n",
- "
\n",
- " \n",
- " 3 | \n",
- " 53335000000 | \n",
- " 53335000000 | \n",
- " 53335000000 | \n",
- " 53335000000 | \n",
- "
\n",
- " \n",
- "
\n",
- "
"
- ],
- "text/plain": [
- " yfinance fmp intrinio polygon\n",
- "0 42779000000 42779000000 42779000000 42779000000\n",
- "1 51248000000 51248000000 51248000000 51248000000\n",
- "2 53811000000 53811000000 53811000000 53811000000\n",
- "3 53335000000 53335000000 53335000000 53335000000"
- ]
- },
- "execution_count": 1,
- "metadata": {},
- "output_type": "execute_result"
- }
- ],
+ "outputs": [],
"source": [
"from openbb import obb\n",
"import pandas as pd\n",
@@ -158,32 +85,9 @@
},
{
"cell_type": "code",
- "execution_count": 2,
+ "execution_count": null,
"metadata": {},
- "outputs": [
- {
- "data": {
- "text/plain": [
- "date\n",
- "1986-07-31 1168.816\n",
- "Name: weighted_average_shares_outstanding, dtype: float64"
- ]
- },
- "metadata": {},
- "output_type": "display_data"
- },
- {
- "data": {
- "text/plain": [
- "date\n",
- "2023-10-31 461.6\n",
- "Name: weighted_average_shares_outstanding, dtype: float64"
- ]
- },
- "metadata": {},
- "output_type": "display_data"
- }
- ],
+ "outputs": [],
"source": [
"data = (\n",
" obb.equity.fundamental.income(\"TGT\", provider=\"fmp\", limit=150, period=\"quarter\")\n",
@@ -206,28 +110,9 @@
},
{
"cell_type": "code",
- "execution_count": 3,
+ "execution_count": null,
"metadata": {},
- "outputs": [
- {
- "data": {
- "text/plain": [
- "-0.12226659060657907"
- ]
- },
- "metadata": {},
- "output_type": "display_data"
- },
- {
- "data": {
- "text/plain": [
- "-1.3000000000000114"
- ]
- },
- "metadata": {},
- "output_type": "display_data"
- }
- ],
+ "outputs": [],
"source": [
"display(shares.pct_change(20).iloc[-1])\n",
"\n",
@@ -243,20 +128,9 @@
},
{
"cell_type": "code",
- "execution_count": 4,
+ "execution_count": null,
"metadata": {},
- "outputs": [
- {
- "data": {
- "text/plain": [
- "187.55"
- ]
- },
- "execution_count": 4,
- "metadata": {},
- "output_type": "execute_result"
- }
- ],
+ "outputs": [],
"source": [
"price = (\n",
" obb.equity.price.historical(\"TGT\", start_date=\"2022-10-01\", provider=\"fmp\")\n",
@@ -277,25 +151,9 @@
},
{
"cell_type": "code",
- "execution_count": 5,
+ "execution_count": null,
"metadata": {},
- "outputs": [
- {
- "data": {
- "text/plain": [
- "date\n",
- "2023-01-28 -1.079731\n",
- "2023-04-29 -1.078325\n",
- "2023-07-29 -1.081023\n",
- "2023-10-31 -1.098354\n",
- "Name: div_per_share, dtype: float64"
- ]
- },
- "execution_count": 5,
- "metadata": {},
- "output_type": "execute_result"
- }
- ],
+ "outputs": [],
"source": [
"dividends = (\n",
" obb.equity.fundamental.cash(\"TGT\", provider=\"fmp\", limit=150, period=\"quarter\")\n",
@@ -317,25 +175,9 @@
},
{
"cell_type": "code",
- "execution_count": 6,
+ "execution_count": null,
"metadata": {},
- "outputs": [
- {
- "data": {
- "text/plain": [
- "date\n",
- "2022-11-15 1.08\n",
- "2023-02-14 1.08\n",
- "2023-05-16 1.08\n",
- "2023-08-15 1.10\n",
- "Name: dividend, dtype: float64"
- ]
- },
- "execution_count": 6,
- "metadata": {},
- "output_type": "execute_result"
- }
- ],
+ "outputs": [],
"source": [
"(\n",
" obb.equity.fundamental.dividends(\"TGT\", provider=\"fmp\")\n",
@@ -361,264 +203,9 @@
},
{
"cell_type": "code",
- "execution_count": 7,
+ "execution_count": null,
"metadata": {},
- "outputs": [
- {
- "data": {
- "text/html": [
- "\n",
- "\n",
- "
\n",
- " \n",
- " \n",
- " | \n",
- " id | \n",
- " name | \n",
- " tag | \n",
- " statement_code | \n",
- " statement_type | \n",
- " parent_name | \n",
- " sequence | \n",
- " factor | \n",
- " transaction | \n",
- " type | \n",
- " unit | \n",
- "
\n",
- " \n",
- " \n",
- " \n",
- " 0 | \n",
- " tag_BgkbWy | \n",
- " Market Capitalization | \n",
- " marketcap | \n",
- " calculations | \n",
- " industrial | \n",
- " None | \n",
- " NaN | \n",
- " None | \n",
- " None | \n",
- " valuation | \n",
- " usd | \n",
- "
\n",
- " \n",
- " 1 | \n",
- " tag_kylOqz | \n",
- " Market Capitalization | \n",
- " marketcap | \n",
- " calculations | \n",
- " financial | \n",
- " None | \n",
- " NaN | \n",
- " None | \n",
- " None | \n",
- " valuation | \n",
- " usd | \n",
- "
\n",
- " \n",
- " 2 | \n",
- " tag_XLRlqy | \n",
- " Market Sector | \n",
- " market_sector | \n",
- " current | \n",
- " None | \n",
- " None | \n",
- " NaN | \n",
- " None | \n",
- " None | \n",
- " security | \n",
- " string | \n",
- "
\n",
- " \n",
- " 3 | \n",
- " tag_2gBA8y | \n",
- " Market Category | \n",
- " market_category | \n",
- " current | \n",
- " None | \n",
- " None | \n",
- " NaN | \n",
- " None | \n",
- " None | \n",
- " security | \n",
- " string | \n",
- "
\n",
- " \n",
- " 4 | \n",
- " tag_DzonXe | \n",
- " Marketing Expense | \n",
- " marketingexpense | \n",
- " income_statement | \n",
- " industrial | \n",
- " totaloperatingexpenses | \n",
- " 9.0 | \n",
- " + | \n",
- " debit | \n",
- " income_statement_metric | \n",
- " usd | \n",
- "
\n",
- " \n",
- " ... | \n",
- " ... | \n",
- " ... | \n",
- " ... | \n",
- " ... | \n",
- " ... | \n",
- " ... | \n",
- " ... | \n",
- " ... | \n",
- " ... | \n",
- " ... | \n",
- " ... | \n",
- "
\n",
- " \n",
- " 95 | \n",
- " tag_nzJAmX | \n",
- " Total Long-Term Debt | \n",
- " ltdebtandcapleases | \n",
- " calculations | \n",
- " financial | \n",
- " None | \n",
- " NaN | \n",
- " None | \n",
- " None | \n",
- " metric | \n",
- " usd | \n",
- "
\n",
- " \n",
- " 96 | \n",
- " tag_9XaL5g | \n",
- " Other Net Changes in Cash | \n",
- " othernetchangesincash | \n",
- " cash_flow_statement | \n",
- " industrial | \n",
- " netchangeincash | \n",
- " 33.0 | \n",
- " + | \n",
- " debit | \n",
- " cash_flow_statement_metric | \n",
- " usd | \n",
- "
\n",
- " \n",
- " 97 | \n",
- " tag_5X7p6z | \n",
- " Other Net Changes in Cash | \n",
- " othernetchangesincash | \n",
- " cash_flow_statement | \n",
- " financial | \n",
- " netchangeincash | \n",
- " 37.0 | \n",
- " + | \n",
- " debit | \n",
- " cash_flow_statement_metric | \n",
- " usd | \n",
- "
\n",
- " \n",
- " 98 | \n",
- " tag_qzEwng | \n",
- " Changes in Operating Assets and Liabilities, net | \n",
- " increasedecreaseinoperatingcapital | \n",
- " cash_flow_statement | \n",
- " financial | \n",
- " netcashfromcontinuingoperatingactivities | \n",
- " 8.0 | \n",
- " + | \n",
- " debit | \n",
- " cash_flow_statement_metric | \n",
- " usd | \n",
- "
\n",
- " \n",
- " 99 | \n",
- " tag_pgVB2g | \n",
- " Changes in Operating Assets and Liabilities, net | \n",
- " increasedecreaseinoperatingcapital | \n",
- " cash_flow_statement | \n",
- " industrial | \n",
- " netcashfromcontinuingoperatingactivities | \n",
- " 7.0 | \n",
- " + | \n",
- " debit | \n",
- " cash_flow_statement_metric | \n",
- " usd | \n",
- "
\n",
- " \n",
- "
\n",
- "
100 rows × 11 columns
\n",
- "
"
- ],
- "text/plain": [
- " id name \\\n",
- "0 tag_BgkbWy Market Capitalization \n",
- "1 tag_kylOqz Market Capitalization \n",
- "2 tag_XLRlqy Market Sector \n",
- "3 tag_2gBA8y Market Category \n",
- "4 tag_DzonXe Marketing Expense \n",
- ".. ... ... \n",
- "95 tag_nzJAmX Total Long-Term Debt \n",
- "96 tag_9XaL5g Other Net Changes in Cash \n",
- "97 tag_5X7p6z Other Net Changes in Cash \n",
- "98 tag_qzEwng Changes in Operating Assets and Liabilities, net \n",
- "99 tag_pgVB2g Changes in Operating Assets and Liabilities, net \n",
- "\n",
- " tag statement_code statement_type \\\n",
- "0 marketcap calculations industrial \n",
- "1 marketcap calculations financial \n",
- "2 market_sector current None \n",
- "3 market_category current None \n",
- "4 marketingexpense income_statement industrial \n",
- ".. ... ... ... \n",
- "95 ltdebtandcapleases calculations financial \n",
- "96 othernetchangesincash cash_flow_statement industrial \n",
- "97 othernetchangesincash cash_flow_statement financial \n",
- "98 increasedecreaseinoperatingcapital cash_flow_statement financial \n",
- "99 increasedecreaseinoperatingcapital cash_flow_statement industrial \n",
- "\n",
- " parent_name sequence factor transaction \\\n",
- "0 None NaN None None \n",
- "1 None NaN None None \n",
- "2 None NaN None None \n",
- "3 None NaN None None \n",
- "4 totaloperatingexpenses 9.0 + debit \n",
- ".. ... ... ... ... \n",
- "95 None NaN None None \n",
- "96 netchangeincash 33.0 + debit \n",
- "97 netchangeincash 37.0 + debit \n",
- "98 netcashfromcontinuingoperatingactivities 8.0 + debit \n",
- "99 netcashfromcontinuingoperatingactivities 7.0 + debit \n",
- "\n",
- " type unit \n",
- "0 valuation usd \n",
- "1 valuation usd \n",
- "2 security string \n",
- "3 security string \n",
- "4 income_statement_metric usd \n",
- ".. ... ... \n",
- "95 metric usd \n",
- "96 cash_flow_statement_metric usd \n",
- "97 cash_flow_statement_metric usd \n",
- "98 cash_flow_statement_metric usd \n",
- "99 cash_flow_statement_metric usd \n",
- "\n",
- "[100 rows x 11 columns]"
- ]
- },
- "execution_count": 7,
- "metadata": {},
- "output_type": "execute_result"
- }
- ],
+ "outputs": [],
"source": [
"(\n",
" obb.equity.fundamental.search_financial_attributes(\"marketcap\")\n",
@@ -635,77 +222,9 @@
},
{
"cell_type": "code",
- "execution_count": 8,
+ "execution_count": null,
"metadata": {},
- "outputs": [
- {
- "data": {
- "text/html": [
- "\n",
- "\n",
- "
\n",
- " \n",
- " \n",
- " | \n",
- " value | \n",
- "
\n",
- " \n",
- " date | \n",
- " | \n",
- "
\n",
- " \n",
- " \n",
- " \n",
- " 2022-12-31 | \n",
- " 6.692963e+10 | \n",
- "
\n",
- " \n",
- " 2023-03-31 | \n",
- " 7.502370e+10 | \n",
- "
\n",
- " \n",
- " 2023-06-30 | \n",
- " 5.991695e+10 | \n",
- "
\n",
- " \n",
- " 2023-09-30 | \n",
- " 5.061437e+10 | \n",
- "
\n",
- " \n",
- " 2023-11-22 | \n",
- " 6.049500e+10 | \n",
- "
\n",
- " \n",
- "
\n",
- "
"
- ],
- "text/plain": [
- " value\n",
- "date \n",
- "2022-12-31 6.692963e+10\n",
- "2023-03-31 7.502370e+10\n",
- "2023-06-30 5.991695e+10\n",
- "2023-09-30 5.061437e+10\n",
- "2023-11-22 6.049500e+10"
- ]
- },
- "execution_count": 8,
- "metadata": {},
- "output_type": "execute_result"
- }
- ],
+ "outputs": [],
"source": [
"marketcap = (\n",
" obb.equity.fundamental.financial_attributes(symbol=\"TGT\", tag = \"marketcap\", period=\"quarter\")\n",
@@ -724,20 +243,9 @@
},
{
"cell_type": "code",
- "execution_count": 9,
+ "execution_count": null,
"metadata": {},
- "outputs": [
- {
- "data": {
- "text/plain": [
- "-0.24376733082703084"
- ]
- },
- "execution_count": 9,
- "metadata": {},
- "output_type": "execute_result"
- }
- ],
+ "outputs": [],
"source": [
"(\n",
" (marketcap.loc[\"2023-09-30\"] - marketcap.loc[\"2022-12-31\"])/marketcap.loc[\"2022-12-31\"]\n",
@@ -761,28 +269,9 @@
},
{
"cell_type": "code",
- "execution_count": 28,
+ "execution_count": null,
"metadata": {},
- "outputs": [
- {
- "data": {
- "text/plain": [
- "'Current Quick Ratio: 0.2701'"
- ]
- },
- "metadata": {},
- "output_type": "display_data"
- },
- {
- "data": {
- "text/plain": [
- "'Median Quick Ratio: 0.5844'"
- ]
- },
- "metadata": {},
- "output_type": "display_data"
- }
- ],
+ "outputs": [],
"source": [
"ratios = (\n",
" obb.equity.fundamental.ratios(\"TGT\", limit=50, provider=\"fmp\")\n",
@@ -806,204 +295,9 @@
},
{
"cell_type": "code",
- "execution_count": 26,
+ "execution_count": null,
"metadata": {},
- "outputs": [
- {
- "data": {
- "text/html": [
- "\n",
- "\n",
- "
\n",
- " \n",
- " \n",
- " calendar_year | \n",
- " 2023 | \n",
- " 2022 | \n",
- " 2021 | \n",
- " 2020 | \n",
- " 2019 | \n",
- " 2018 | \n",
- " 2017 | \n",
- " 2016 | \n",
- " 2015 | \n",
- " 2014 | \n",
- "
\n",
- " \n",
- " \n",
- " \n",
- " Costco Wholesale Corporation | \n",
- " 0.027922 | \n",
- " 0.014860 | \n",
- " 0.026582 | \n",
- " 0.039351 | \n",
- " 0.025906 | \n",
- " 0.027438 | \n",
- " 0.060884 | \n",
- " 0.008941 | \n",
- " 0.030741 | \n",
- " 0.037483 | \n",
- "
\n",
- " \n",
- " BJ's Wholesale Club Holdings, Inc. | \n",
- " NaN | \n",
- " 0.044709 | \n",
- " 0.067213 | \n",
- " 0.113551 | \n",
- " 0.056630 | \n",
- " 0.091107 | \n",
- " 0.026186 | \n",
- " 0.065871 | \n",
- " 0.016947 | \n",
- " NaN | \n",
- "
\n",
- " \n",
- " Dollar Tree, Inc. | \n",
- " NaN | \n",
- " 0.010756 | \n",
- " 0.013957 | \n",
- " 0.075627 | \n",
- " 0.040338 | \n",
- " 0.041252 | \n",
- " 0.034069 | \n",
- " 0.063465 | \n",
- " 0.016602 | \n",
- " 0.041047 | \n",
- "
\n",
- " \n",
- " Dollar General Corporation | \n",
- " NaN | \n",
- " 0.008256 | \n",
- " 0.037507 | \n",
- " 0.058973 | \n",
- " 0.036922 | \n",
- " 0.046197 | \n",
- " 0.042609 | \n",
- " 0.050776 | \n",
- " 0.039524 | \n",
- " 0.046052 | \n",
- "
\n",
- " \n",
- " Walmart Inc. | \n",
- " 0.031243 | \n",
- " 0.028372 | \n",
- " 0.065462 | \n",
- " 0.044591 | \n",
- " 0.062023 | \n",
- " 0.057275 | \n",
- " 0.101038 | \n",
- " 0.073506 | \n",
- " 0.059712 | \n",
- " 0.041544 | \n",
- "
\n",
- " \n",
- " Big Lots, Inc. | \n",
- " NaN | \n",
- " -0.550469 | \n",
- " 0.025262 | \n",
- " 0.115757 | \n",
- " 0.069464 | \n",
- " -0.111853 | \n",
- " 0.037219 | \n",
- " 0.100721 | \n",
- " 0.110443 | \n",
- " 0.089253 | \n",
- "
\n",
- " \n",
- " Macy's, Inc. | \n",
- " NaN | \n",
- " 0.050473 | \n",
- " 0.270980 | \n",
- " 0.039111 | \n",
- " 0.091301 | \n",
- " 0.101426 | \n",
- " 0.155761 | \n",
- " 0.098993 | \n",
- " 0.065634 | \n",
- " 0.072322 | \n",
- "
\n",
- " \n",
- " Kohl's Corporation | \n",
- " NaN | \n",
- " -0.143961 | \n",
- " 0.189677 | \n",
- " 0.147968 | \n",
- " 0.119492 | \n",
- " 0.139799 | \n",
- " 0.096137 | \n",
- " 0.198790 | \n",
- " 0.081652 | \n",
- " 0.110697 | \n",
- "
\n",
- " \n",
- " The TJX Companies, Inc. | \n",
- " 0.027159 | \n",
- " 0.023497 | \n",
- " 0.051769 | \n",
- " 0.040167 | \n",
- " 0.048827 | \n",
- " 0.039935 | \n",
- " 0.053697 | \n",
- " 0.043328 | \n",
- " 0.046442 | \n",
- " 0.040643 | \n",
- "
\n",
- " \n",
- "
\n",
- "
"
- ],
- "text/plain": [
- "calendar_year 2023 2022 2021 2020 \\\n",
- "Costco Wholesale Corporation 0.027922 0.014860 0.026582 0.039351 \n",
- "BJ's Wholesale Club Holdings, Inc. NaN 0.044709 0.067213 0.113551 \n",
- "Dollar Tree, Inc. NaN 0.010756 0.013957 0.075627 \n",
- "Dollar General Corporation NaN 0.008256 0.037507 0.058973 \n",
- "Walmart Inc. 0.031243 0.028372 0.065462 0.044591 \n",
- "Big Lots, Inc. NaN -0.550469 0.025262 0.115757 \n",
- "Macy's, Inc. NaN 0.050473 0.270980 0.039111 \n",
- "Kohl's Corporation NaN -0.143961 0.189677 0.147968 \n",
- "The TJX Companies, Inc. 0.027159 0.023497 0.051769 0.040167 \n",
- "\n",
- "calendar_year 2019 2018 2017 2016 \\\n",
- "Costco Wholesale Corporation 0.025906 0.027438 0.060884 0.008941 \n",
- "BJ's Wholesale Club Holdings, Inc. 0.056630 0.091107 0.026186 0.065871 \n",
- "Dollar Tree, Inc. 0.040338 0.041252 0.034069 0.063465 \n",
- "Dollar General Corporation 0.036922 0.046197 0.042609 0.050776 \n",
- "Walmart Inc. 0.062023 0.057275 0.101038 0.073506 \n",
- "Big Lots, Inc. 0.069464 -0.111853 0.037219 0.100721 \n",
- "Macy's, Inc. 0.091301 0.101426 0.155761 0.098993 \n",
- "Kohl's Corporation 0.119492 0.139799 0.096137 0.198790 \n",
- "The TJX Companies, Inc. 0.048827 0.039935 0.053697 0.043328 \n",
- "\n",
- "calendar_year 2015 2014 \n",
- "Costco Wholesale Corporation 0.030741 0.037483 \n",
- "BJ's Wholesale Club Holdings, Inc. 0.016947 NaN \n",
- "Dollar Tree, Inc. 0.016602 0.041047 \n",
- "Dollar General Corporation 0.039524 0.046052 \n",
- "Walmart Inc. 0.059712 0.041544 \n",
- "Big Lots, Inc. 0.110443 0.089253 \n",
- "Macy's, Inc. 0.065634 0.072322 \n",
- "Kohl's Corporation 0.081652 0.110697 \n",
- "The TJX Companies, Inc. 0.046442 0.040643 "
- ]
- },
- "execution_count": 26,
- "metadata": {},
- "output_type": "execute_result"
- }
- ],
+ "outputs": [],
"source": [
"# List of other retail chains\n",
"tickers = [\"COST\", \"BJ\", \"DLTR\", \"DG\", \"WMT\", \"BIG\", \"M\", \"KSS\", \"TJX\"]\n",
diff --git a/examples/findSymbols.ipynb b/examples/findSymbols.ipynb
index 1a4eeb196fd..3e26d5896de 100644
--- a/examples/findSymbols.ipynb
+++ b/examples/findSymbols.ipynb
@@ -16,7 +16,7 @@
},
{
"cell_type": "code",
- "execution_count": 1,
+ "execution_count": null,
"metadata": {},
"outputs": [],
"source": [
@@ -40,20 +40,9 @@
},
{
"cell_type": "code",
- "execution_count": 2,
+ "execution_count": null,
"metadata": {},
- "outputs": [
- {
- "data": {
- "text/plain": [
- "10840"
- ]
- },
- "execution_count": 2,
- "metadata": {},
- "output_type": "execute_result"
- }
- ],
+ "outputs": [],
"source": [
"all_companies = obb.equity.search(\"\", provider=\"sec\")\n",
"\n",
@@ -69,119 +58,9 @@
},
{
"cell_type": "code",
- "execution_count": 3,
+ "execution_count": null,
"metadata": {},
- "outputs": [
- {
- "data": {
- "text/html": [
- "\n",
- "\n",
- "
\n",
- " \n",
- " \n",
- " | \n",
- " symbol | \n",
- " name | \n",
- " cik | \n",
- "
\n",
- " \n",
- " \n",
- " \n",
- " 0 | \n",
- " AAPL | \n",
- " Apple Inc. | \n",
- " 320193 | \n",
- "
\n",
- " \n",
- " 1 | \n",
- " MSFT | \n",
- " MICROSOFT CORP | \n",
- " 789019 | \n",
- "
\n",
- " \n",
- " 2 | \n",
- " GOOGL | \n",
- " Alphabet Inc. | \n",
- " 1652044 | \n",
- "
\n",
- " \n",
- " 3 | \n",
- " AMZN | \n",
- " AMAZON COM INC | \n",
- " 1018724 | \n",
- "
\n",
- " \n",
- " 4 | \n",
- " NVDA | \n",
- " NVIDIA CORP | \n",
- " 1045810 | \n",
- "
\n",
- " \n",
- " 5 | \n",
- " META | \n",
- " Meta Platforms, Inc. | \n",
- " 1326801 | \n",
- "
\n",
- " \n",
- " 6 | \n",
- " BRK-B | \n",
- " BERKSHIRE HATHAWAY INC | \n",
- " 1067983 | \n",
- "
\n",
- " \n",
- " 7 | \n",
- " TSLA | \n",
- " Tesla, Inc. | \n",
- " 1318605 | \n",
- "
\n",
- " \n",
- " 8 | \n",
- " LLY | \n",
- " ELI LILLY & Co | \n",
- " 59478 | \n",
- "
\n",
- " \n",
- " 9 | \n",
- " V | \n",
- " VISA INC. | \n",
- " 1403161 | \n",
- "
\n",
- " \n",
- "
\n",
- "
"
- ],
- "text/plain": [
- " symbol name cik\n",
- "0 AAPL Apple Inc. 320193\n",
- "1 MSFT MICROSOFT CORP 789019\n",
- "2 GOOGL Alphabet Inc. 1652044\n",
- "3 AMZN AMAZON COM INC 1018724\n",
- "4 NVDA NVIDIA CORP 1045810\n",
- "5 META Meta Platforms, Inc. 1326801\n",
- "6 BRK-B BERKSHIRE HATHAWAY INC 1067983\n",
- "7 TSLA Tesla, Inc. 1318605\n",
- "8 LLY ELI LILLY & Co 59478\n",
- "9 V VISA INC. 1403161"
- ]
- },
- "execution_count": 3,
- "metadata": {},
- "output_type": "execute_result"
- }
- ],
+ "outputs": [],
"source": [
"all_companies.to_df().head(10)\n"
]
@@ -197,96 +76,9 @@
},
{
"cell_type": "code",
- "execution_count": 4,
+ "execution_count": null,
"metadata": {},
- "outputs": [
- {
- "data": {
- "text/html": [
- "\n",
- "\n",
- "
\n",
- " \n",
- " \n",
- " | \n",
- " name | \n",
- " cik | \n",
- "
\n",
- " \n",
- " \n",
- " \n",
- " 0 | \n",
- " BERKSHIRE HATHAWAY ENERGY CO | \n",
- " 0001081316 | \n",
- "
\n",
- " \n",
- " 1 | \n",
- " BERKSHIRE HATHAWAY FINANCE CORP | \n",
- " 0001274791 | \n",
- "
\n",
- " \n",
- " 2 | \n",
- " BERKSHIRE HATHAWAY HOMESTATE INSURANCE CO. | \n",
- " 0000829771 | \n",
- "
\n",
- " \n",
- " 3 | \n",
- " BERKSHIRE HATHAWAY INC /DE/ | \n",
- " 0000109694 | \n",
- "
\n",
- " \n",
- " 4 | \n",
- " BERKSHIRE HATHAWAY INC/DE | \n",
- " 0000109694 | \n",
- "
\n",
- " \n",
- " 5 | \n",
- " BERKSHIRE HATHAWAY INC | \n",
- " 0001067983 | \n",
- "
\n",
- " \n",
- " 6 | \n",
- " BERKSHIRE HATHAWAY LIFE INSURANCE CO OF NEBRASKA | \n",
- " 0001015867 | \n",
- "
\n",
- " \n",
- " 7 | \n",
- " LMZ & BERKSHIRE HATHAWAY CO | \n",
- " 0001652795 | \n",
- "
\n",
- " \n",
- "
\n",
- "
"
- ],
- "text/plain": [
- " name cik\n",
- "0 BERKSHIRE HATHAWAY ENERGY CO 0001081316\n",
- "1 BERKSHIRE HATHAWAY FINANCE CORP 0001274791\n",
- "2 BERKSHIRE HATHAWAY HOMESTATE INSURANCE CO. 0000829771\n",
- "3 BERKSHIRE HATHAWAY INC /DE/ 0000109694\n",
- "4 BERKSHIRE HATHAWAY INC/DE 0000109694\n",
- "5 BERKSHIRE HATHAWAY INC 0001067983\n",
- "6 BERKSHIRE HATHAWAY LIFE INSURANCE CO OF NEBRASKA 0001015867\n",
- "7 LMZ & BERKSHIRE HATHAWAY CO 0001652795"
- ]
- },
- "execution_count": 4,
- "metadata": {},
- "output_type": "execute_result"
- }
- ],
+ "outputs": [],
"source": [
"instututions = obb.regulators.sec.institutions_search(\"Berkshire Hathaway\").to_df()\n",
"instututions\n"
@@ -303,36 +95,9 @@
},
{
"cell_type": "code",
- "execution_count": 11,
+ "execution_count": null,
"metadata": {},
- "outputs": [
- {
- "data": {
- "text/plain": [
- "type 13F-NT\n",
- "link https://www.sec.gov/Archives/edgar/data/000082...\n",
- "report_date 2023-09-30\n",
- "accepted_date 2023-11-14 16:15:06+00:00\n",
- "act 34\n",
- "items \n",
- "primary_doc_description \n",
- "primary_doc xslForm13F_X02/primary_doc.xml\n",
- "accession_number 0000950123-23-010929\n",
- "file_number 028-02226\n",
- "film_number 231406391\n",
- "is_inline_xbrl 0\n",
- "is_xbrl 0\n",
- "size 2960\n",
- "complete_submission_url https://www.sec.gov/Archives/edgar/data/000082...\n",
- "filing_detail_url https://www.sec.gov/Archives/edgar/data/000082...\n",
- "Name: 2023-11-14 00:00:00, dtype: object"
- ]
- },
- "execution_count": 11,
- "metadata": {},
- "output_type": "execute_result"
- }
- ],
+ "outputs": [],
"source": [
"homestate_filings = obb.equity.fundamental.filings(cik=\"0000829771\", provider=\"sec\")\n",
"\n",
@@ -348,36 +113,9 @@
},
{
"cell_type": "code",
- "execution_count": 13,
+ "execution_count": null,
"metadata": {},
- "outputs": [
- {
- "data": {
- "text/plain": [
- "type 4\n",
- "link https://www.sec.gov/Archives/edgar/data/000032...\n",
- "report_date 2023-11-10\n",
- "accepted_date 2023-11-14 18:31:09+00:00\n",
- "act \n",
- "items \n",
- "primary_doc_description FORM 4\n",
- "primary_doc xslF345X05/wk-form4_1700004649.xml\n",
- "accession_number 0000320193-23-000109\n",
- "file_number \n",
- "film_number \n",
- "is_inline_xbrl 0\n",
- "is_xbrl 0\n",
- "size 5066\n",
- "complete_submission_url https://www.sec.gov/Archives/edgar/data/000032...\n",
- "filing_detail_url https://www.sec.gov/Archives/edgar/data/000032...\n",
- "Name: 2023-11-14 00:00:00, dtype: object"
- ]
- },
- "execution_count": 13,
- "metadata": {},
- "output_type": "execute_result"
- }
- ],
+ "outputs": [],
"source": [
"aapl_filings = obb.equity.fundamental.filings(\"AAPL\", type=\"4\", provider=\"sec\")\n",
"\n",
@@ -397,180 +135,9 @@
},
{
"cell_type": "code",
- "execution_count": 16,
+ "execution_count": null,
"metadata": {},
- "outputs": [
- {
- "data": {
- "text/plain": [
- "1822"
- ]
- },
- "metadata": {},
- "output_type": "display_data"
- },
- {
- "data": {
- "text/html": [
- "\n",
- "\n",
- "
\n",
- " \n",
- " \n",
- " | \n",
- " symbol | \n",
- " name | \n",
- " market_cap | \n",
- " sector | \n",
- " industry | \n",
- " beta | \n",
- " price | \n",
- " last_annual_dividend | \n",
- " volume | \n",
- " exchange | \n",
- " exchange_name | \n",
- " country | \n",
- " is_etf | \n",
- " actively_trading | \n",
- "
\n",
- " \n",
- " \n",
- " \n",
- " 0 | \n",
- " RELIANCE.NS | \n",
- " Reliance Industries Limited | \n",
- " 15895961017165 | \n",
- " Energy | \n",
- " Oil & Gas Refining & Marketing | \n",
- " 0.721409 | \n",
- " 2349.35 | \n",
- " 9 | \n",
- " 2244671 | \n",
- " NSE | \n",
- " National Stock Exchange of India | \n",
- " IN | \n",
- " False | \n",
- " True | \n",
- "
\n",
- " \n",
- " 1 | \n",
- " TCS.NS | \n",
- " Tata Consultancy Services Limited | \n",
- " 12878392323686 | \n",
- " Technology | \n",
- " Information Technology Services | \n",
- " 0.528 | \n",
- " 3519.6 | \n",
- " 36 | \n",
- " 1473232 | \n",
- " NSE | \n",
- " National Stock Exchange of India | \n",
- " IN | \n",
- " False | \n",
- " True | \n",
- "
\n",
- " \n",
- " 2 | \n",
- " HDFCBANK.NS | \n",
- " HDFC Bank Limited | \n",
- " 11345550050918 | \n",
- " Financial Services | \n",
- " Banks—Regional | \n",
- " 0.714285 | \n",
- " 1505.2 | \n",
- " 19 | \n",
- " 9665132 | \n",
- " NSE | \n",
- " National Stock Exchange of India | \n",
- " IN | \n",
- " False | \n",
- " True | \n",
- "
\n",
- " \n",
- " 3 | \n",
- " ICICIBANK.NS | \n",
- " ICICI Bank Limited | \n",
- " 6456176076595 | \n",
- " Financial Services | \n",
- " Banks—Regional | \n",
- " 0.808 | \n",
- " 921.45 | \n",
- " 8 | \n",
- " 10561389 | \n",
- " NSE | \n",
- " National Stock Exchange of India | \n",
- " IN | \n",
- " False | \n",
- " True | \n",
- "
\n",
- " \n",
- " 4 | \n",
- " INFY.NS | \n",
- " Infosys Limited | \n",
- " 5945857635942 | \n",
- " Technology | \n",
- " Information Technology Services | \n",
- " 0.596 | \n",
- " 1436.6 | \n",
- " 36 | \n",
- " 3584088 | \n",
- " NSE | \n",
- " National Stock Exchange of India | \n",
- " IN | \n",
- " False | \n",
- " True | \n",
- "
\n",
- " \n",
- "
\n",
- "
"
- ],
- "text/plain": [
- " symbol name market_cap \\\n",
- "0 RELIANCE.NS Reliance Industries Limited 15895961017165 \n",
- "1 TCS.NS Tata Consultancy Services Limited 12878392323686 \n",
- "2 HDFCBANK.NS HDFC Bank Limited 11345550050918 \n",
- "3 ICICIBANK.NS ICICI Bank Limited 6456176076595 \n",
- "4 INFY.NS Infosys Limited 5945857635942 \n",
- "\n",
- " sector industry beta price \\\n",
- "0 Energy Oil & Gas Refining & Marketing 0.721409 2349.35 \n",
- "1 Technology Information Technology Services 0.528 3519.6 \n",
- "2 Financial Services Banks—Regional 0.714285 1505.2 \n",
- "3 Financial Services Banks—Regional 0.808 921.45 \n",
- "4 Technology Information Technology Services 0.596 1436.6 \n",
- "\n",
- " last_annual_dividend volume exchange exchange_name \\\n",
- "0 9 2244671 NSE National Stock Exchange of India \n",
- "1 36 1473232 NSE National Stock Exchange of India \n",
- "2 19 9665132 NSE National Stock Exchange of India \n",
- "3 8 10561389 NSE National Stock Exchange of India \n",
- "4 36 3584088 NSE National Stock Exchange of India \n",
- "\n",
- " country is_etf actively_trading \n",
- "0 IN False True \n",
- "1 IN False True \n",
- "2 IN False True \n",
- "3 IN False True \n",
- "4 IN False True "
- ]
- },
- "execution_count": 16,
- "metadata": {},
- "output_type": "execute_result"
- }
- ],
+ "outputs": [],
"source": [
"results = obb.equity.screener(country=\"IN\", provider=\"fmp\").to_df()\n",
"display(len(results))\n",
@@ -586,180 +153,9 @@
},
{
"cell_type": "code",
- "execution_count": 17,
+ "execution_count": null,
"metadata": {},
- "outputs": [
- {
- "data": {
- "text/plain": [
- "190"
- ]
- },
- "metadata": {},
- "output_type": "display_data"
- },
- {
- "data": {
- "text/html": [
- "\n",
- "\n",
- "
\n",
- " \n",
- " \n",
- " | \n",
- " symbol | \n",
- " name | \n",
- " market_cap | \n",
- " sector | \n",
- " industry | \n",
- " beta | \n",
- " price | \n",
- " last_annual_dividend | \n",
- " volume | \n",
- " exchange | \n",
- " exchange_name | \n",
- " country | \n",
- " is_etf | \n",
- " actively_trading | \n",
- "
\n",
- " \n",
- " \n",
- " \n",
- " 0 | \n",
- " HDFCBANK.NS | \n",
- " HDFC Bank Limited | \n",
- " 11345550050918 | \n",
- " Financial Services | \n",
- " Banks—Regional | \n",
- " 0.714285 | \n",
- " 1505.2 | \n",
- " 19.0 | \n",
- " 9665132 | \n",
- " NSE | \n",
- " National Stock Exchange of India | \n",
- " IN | \n",
- " False | \n",
- " True | \n",
- "
\n",
- " \n",
- " 1 | \n",
- " ICICIBANK.NS | \n",
- " ICICI Bank Limited | \n",
- " 6456176076595 | \n",
- " Financial Services | \n",
- " Banks—Regional | \n",
- " 0.808 | \n",
- " 921.45 | \n",
- " 8.0 | \n",
- " 10561389 | \n",
- " NSE | \n",
- " National Stock Exchange of India | \n",
- " IN | \n",
- " False | \n",
- " True | \n",
- "
\n",
- " \n",
- " 2 | \n",
- " SBIN.NS | \n",
- " State Bank of India | \n",
- " 5031248625920 | \n",
- " Financial Services | \n",
- " Banks—Regional | \n",
- " 0.74 | \n",
- " 563.75 | \n",
- " 11.3 | \n",
- " 12710950 | \n",
- " NSE | \n",
- " National Stock Exchange of India | \n",
- " IN | \n",
- " False | \n",
- " True | \n",
- "
\n",
- " \n",
- " 3 | \n",
- " BAJFINANCE.NS | \n",
- " Bajaj Finance Limited | \n",
- " 4282998873754 | \n",
- " Financial Services | \n",
- " Credit Services | \n",
- " 0.947 | \n",
- " 7068.6 | \n",
- " 30.0 | \n",
- " 1901753 | \n",
- " NSE | \n",
- " National Stock Exchange of India | \n",
- " IN | \n",
- " False | \n",
- " True | \n",
- "
\n",
- " \n",
- " 4 | \n",
- " LICI.NS | \n",
- " Life Insurance Corporation of India | \n",
- " 3870900117504 | \n",
- " Financial Services | \n",
- " Insurance—Life | \n",
- " <NA> | \n",
- " 612.0 | \n",
- " 3.0 | \n",
- " 500820 | \n",
- " NSE | \n",
- " National Stock Exchange of India | \n",
- " IN | \n",
- " False | \n",
- " True | \n",
- "
\n",
- " \n",
- "
\n",
- "
"
- ],
- "text/plain": [
- " symbol name market_cap \\\n",
- "0 HDFCBANK.NS HDFC Bank Limited 11345550050918 \n",
- "1 ICICIBANK.NS ICICI Bank Limited 6456176076595 \n",
- "2 SBIN.NS State Bank of India 5031248625920 \n",
- "3 BAJFINANCE.NS Bajaj Finance Limited 4282998873754 \n",
- "4 LICI.NS Life Insurance Corporation of India 3870900117504 \n",
- "\n",
- " sector industry beta price \\\n",
- "0 Financial Services Banks—Regional 0.714285 1505.2 \n",
- "1 Financial Services Banks—Regional 0.808 921.45 \n",
- "2 Financial Services Banks—Regional 0.74 563.75 \n",
- "3 Financial Services Credit Services 0.947 7068.6 \n",
- "4 Financial Services Insurance—Life 612.0 \n",
- "\n",
- " last_annual_dividend volume exchange exchange_name \\\n",
- "0 19.0 9665132 NSE National Stock Exchange of India \n",
- "1 8.0 10561389 NSE National Stock Exchange of India \n",
- "2 11.3 12710950 NSE National Stock Exchange of India \n",
- "3 30.0 1901753 NSE National Stock Exchange of India \n",
- "4 3.0 500820 NSE National Stock Exchange of India \n",
- "\n",
- " country is_etf actively_trading \n",
- "0 IN False True \n",
- "1 IN False True \n",
- "2 IN False True \n",
- "3 IN False True \n",
- "4 IN False True "
- ]
- },
- "execution_count": 17,
- "metadata": {},
- "output_type": "execute_result"
- }
- ],
+ "outputs": [],
"source": [
"sector_results = obb.equity.screener(country=\"IN\", sector=\"Financial Services\", provider=\"fmp\").to_df()\n",
"display(len(sector_results))\n",
@@ -775,180 +171,9 @@
},
{
"cell_type": "code",
- "execution_count": 20,
+ "execution_count": null,
"metadata": {},
- "outputs": [
- {
- "data": {
- "text/plain": [
- "119"
- ]
- },
- "metadata": {},
- "output_type": "display_data"
- },
- {
- "data": {
- "text/html": [
- "\n",
- "\n",
- "
\n",
- " \n",
- " \n",
- " | \n",
- " symbol | \n",
- " name | \n",
- " market_cap | \n",
- " sector | \n",
- " industry | \n",
- " beta | \n",
- " price | \n",
- " last_annual_dividend | \n",
- " volume | \n",
- " exchange | \n",
- " exchange_name | \n",
- " country | \n",
- " is_etf | \n",
- " actively_trading | \n",
- "
\n",
- " \n",
- " \n",
- " \n",
- " 0 | \n",
- " PAGEIND.NS | \n",
- " Page Industries Limited | \n",
- " 418555116755 | \n",
- " Consumer Cyclical | \n",
- " Apparel Manufacturing | \n",
- " 0.462 | \n",
- " 37525.45 | \n",
- " 300.0 | \n",
- " 11199 | \n",
- " NSE | \n",
- " National Stock Exchange of India | \n",
- " IN | \n",
- " False | \n",
- " True | \n",
- "
\n",
- " \n",
- " 1 | \n",
- " KPRMILL.NS | \n",
- " K.P.R. Mill Limited | \n",
- " 284132900800 | \n",
- " Consumer Cyclical | \n",
- " Apparel Manufacturing | \n",
- " 0.689 | \n",
- " 831.25 | \n",
- " 4.15 | \n",
- " 342210 | \n",
- " NSE | \n",
- " National Stock Exchange of India | \n",
- " IN | \n",
- " False | \n",
- " True | \n",
- "
\n",
- " \n",
- " 2 | \n",
- " ABFRL.NS | \n",
- " Aditya Birla Fashion and Retail Limited | \n",
- " 203500974285 | \n",
- " Consumer Cyclical | \n",
- " Apparel Manufacturing | \n",
- " 0.152 | \n",
- " 214.4 | \n",
- " <NA> | \n",
- " 1363689 | \n",
- " NSE | \n",
- " National Stock Exchange of India | \n",
- " IN | \n",
- " False | \n",
- " True | \n",
- "
\n",
- " \n",
- " 3 | \n",
- " TRIDENT.NS | \n",
- " Trident Limited | \n",
- " 189060118374 | \n",
- " Consumer Cyclical | \n",
- " Textile Manufacturing | \n",
- " 0.532 | \n",
- " 37.1 | \n",
- " 0.36 | \n",
- " 7863777 | \n",
- " NSE | \n",
- " National Stock Exchange of India | \n",
- " IN | \n",
- " False | \n",
- " True | \n",
- "
\n",
- " \n",
- " 4 | \n",
- " WELSPUNIND.NS | \n",
- " Welspun India Limited | \n",
- " 157481652339 | \n",
- " Consumer Cyclical | \n",
- " Textile Manufacturing | \n",
- " 0.423 | \n",
- " 162.05 | \n",
- " 0.1 | \n",
- " 3348644 | \n",
- " NSE | \n",
- " National Stock Exchange of India | \n",
- " IN | \n",
- " False | \n",
- " True | \n",
- "
\n",
- " \n",
- "
\n",
- "
"
- ],
- "text/plain": [
- " symbol name market_cap \\\n",
- "0 PAGEIND.NS Page Industries Limited 418555116755 \n",
- "1 KPRMILL.NS K.P.R. Mill Limited 284132900800 \n",
- "2 ABFRL.NS Aditya Birla Fashion and Retail Limited 203500974285 \n",
- "3 TRIDENT.NS Trident Limited 189060118374 \n",
- "4 WELSPUNIND.NS Welspun India Limited 157481652339 \n",
- "\n",
- " sector industry beta price \\\n",
- "0 Consumer Cyclical Apparel Manufacturing 0.462 37525.45 \n",
- "1 Consumer Cyclical Apparel Manufacturing 0.689 831.25 \n",
- "2 Consumer Cyclical Apparel Manufacturing 0.152 214.4 \n",
- "3 Consumer Cyclical Textile Manufacturing 0.532 37.1 \n",
- "4 Consumer Cyclical Textile Manufacturing 0.423 162.05 \n",
- "\n",
- " last_annual_dividend volume exchange exchange_name \\\n",
- "0 300.0 11199 NSE National Stock Exchange of India \n",
- "1 4.15 342210 NSE National Stock Exchange of India \n",
- "2 1363689 NSE National Stock Exchange of India \n",
- "3 0.36 7863777 NSE National Stock Exchange of India \n",
- "4 0.1 3348644 NSE National Stock Exchange of India \n",
- "\n",
- " country is_etf actively_trading \n",
- "0 IN False True \n",
- "1 IN False True \n",
- "2 IN False True \n",
- "3 IN False True \n",
- "4 IN False True "
- ]
- },
- "execution_count": 20,
- "metadata": {},
- "output_type": "execute_result"
- }
- ],
+ "outputs": [],
"source": [
"industry_results = obb.equity.screener(country=\"IN\", industry=\"manufacturing\").to_df()\n",
"display(len(industry_results))\n",
@@ -966,148 +191,9 @@
},
{
"cell_type": "code",
- "execution_count": 22,
+ "execution_count": null,
"metadata": {},
- "outputs": [
- {
- "data": {
- "text/plain": [
- "4"
- ]
- },
- "metadata": {},
- "output_type": "display_data"
- },
- {
- "data": {
- "text/html": [
- "\n",
- "\n",
- "
\n",
- " \n",
- " \n",
- " | \n",
- " symbol | \n",
- " name | \n",
- " market_cap | \n",
- " sector | \n",
- " industry | \n",
- " beta | \n",
- " price | \n",
- " volume | \n",
- " exchange | \n",
- " exchange_name | \n",
- " country | \n",
- " is_etf | \n",
- " actively_trading | \n",
- "
\n",
- " \n",
- " \n",
- " \n",
- " 0 | \n",
- " AMBO | \n",
- " Ambow Education Holding Ltd. | \n",
- " 4314134 | \n",
- " Consumer Defensive | \n",
- " Education & Training Services | \n",
- " 0.448 | \n",
- " 0.1521 | \n",
- " 54634 | \n",
- " AMEX | \n",
- " American Stock Exchange | \n",
- " CN | \n",
- " False | \n",
- " True | \n",
- "
\n",
- " \n",
- " 1 | \n",
- " ITP | \n",
- " IT Tech Packaging, Inc. | \n",
- " 2922131 | \n",
- " Basic Materials | \n",
- " Paper & Paper Products | \n",
- " -0.1 | \n",
- " 0.2903 | \n",
- " 17827 | \n",
- " AMEX | \n",
- " American Stock Exchange | \n",
- " CN | \n",
- " False | \n",
- " True | \n",
- "
\n",
- " \n",
- " 2 | \n",
- " DXF | \n",
- " Dunxin Financial Holdings Limited | \n",
- " 1232011 | \n",
- " Financial Services | \n",
- " Credit Services | \n",
- " 1.632 | \n",
- " 0.31 | \n",
- " 259614 | \n",
- " AMEX | \n",
- " American Stock Exchange | \n",
- " CN | \n",
- " False | \n",
- " True | \n",
- "
\n",
- " \n",
- " 3 | \n",
- " CPHI | \n",
- " China Pharma Holdings, Inc. | \n",
- " 1084973 | \n",
- " Healthcare | \n",