notebook.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "ename": "Exception",
     "evalue": "Token inválido ou ação não encontrada",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mException\u001b[0m                                 Traceback (most recent call last)",
      "\u001b[1;32m/Users/cesarvargas/dev/oplab_notebook/notebook.ipynb Cell 1'\u001b[0m in \u001b[0;36m<module>\u001b[0;34m\u001b[0m\n\u001b[1;32m     <a href='vscode-notebook-cell:/Users/cesarvargas/dev/oplab_notebook/notebook.ipynb#ch0000000?line=11'>12</a>\u001b[0m response \u001b[39m=\u001b[39m requests\u001b[39m.\u001b[39mget(\u001b[39m'\u001b[39m\u001b[39mhttps://api.oplab.com.br/v3/market/stocks/\u001b[39m\u001b[39m%s\u001b[39;00m\u001b[39m?with_financials=\u001b[39m\u001b[39m%s\u001b[39;00m\u001b[39m'\u001b[39m \u001b[39m%\u001b[39m (symbol, \u001b[39m'\u001b[39m\u001b[39m,\u001b[39m\u001b[39m'\u001b[39m\u001b[39m.\u001b[39mjoin(info)), headers \u001b[39m=\u001b[39m {\u001b[39m'\u001b[39m\u001b[39maccess-token\u001b[39m\u001b[39m'\u001b[39m: token, \u001b[39m'\u001b[39m\u001b[39maccept\u001b[39m\u001b[39m'\u001b[39m: \u001b[39m'\u001b[39m\u001b[39mapplication/json\u001b[39m\u001b[39m'\u001b[39m})\n\u001b[1;32m     <a href='vscode-notebook-cell:/Users/cesarvargas/dev/oplab_notebook/notebook.ipynb#ch0000000?line=13'>14</a>\u001b[0m \u001b[39mif\u001b[39;00m response\u001b[39m.\u001b[39mstatus_code \u001b[39m!=\u001b[39m \u001b[39m200\u001b[39m:\n\u001b[0;32m---> <a href='vscode-notebook-cell:/Users/cesarvargas/dev/oplab_notebook/notebook.ipynb#ch0000000?line=14'>15</a>\u001b[0m   \u001b[39mraise\u001b[39;00m(\u001b[39mException\u001b[39;00m(\u001b[39m'\u001b[39m\u001b[39mToken inválido ou ação não encontrada\u001b[39m\u001b[39m'\u001b[39m))\n\u001b[1;32m     <a href='vscode-notebook-cell:/Users/cesarvargas/dev/oplab_notebook/notebook.ipynb#ch0000000?line=16'>17</a>\u001b[0m financial \u001b[39m=\u001b[39m response\u001b[39m.\u001b[39mjson()[\u001b[39m'\u001b[39m\u001b[39mfinancial\u001b[39m\u001b[39m'\u001b[39m]\n\u001b[1;32m     <a href='vscode-notebook-cell:/Users/cesarvargas/dev/oplab_notebook/notebook.ipynb#ch0000000?line=17'>18</a>\u001b[0m date \u001b[39m=\u001b[39m \u001b[39m'\u001b[39m\u001b[39m2021-09-30\u001b[39m\u001b[39m'\u001b[39m\n",
      "\u001b[0;31mException\u001b[0m: Token inválido ou ação não encontrada"
     ]
    }
   ],
   "source": [
    "import requests\n",
    "import json\n",
    "import pandas as pd\n",
    "\n",
    "def pretty(res):\n",
    "  return json.dumps(res, indent=4, sort_keys=True, ensure_ascii=False)\n",
    "\n",
    "symbol = input('Digite o código da ação: ')\n",
    "info = ['dividends', 'fundamentals', 'bpa', 'bpp', 'dfc', 'dre', 'name', 'sector', 'cnpj', 'close', 'stocks']\n",
    "token = input('Digite o token: ')\n",
    "\n",
    "response = requests.get('https://api.oplab.com.br/v3/market/stocks/%s?with_financials=%s' % (symbol, ','.join(info)), headers = {'access-token': token, 'accept': 'application/json'})\n",
    "\n",
    "if response.status_code != 200:\n",
    "  raise(Exception('Token inválido ou ação não encontrada'))\n",
    "  \n",
    "financial = response.json()['financial']\n",
    "date = '2021-09-30'\n",
    "\n",
    "l = { k: financial[k] if type(financial[k]) is str else financial[k].get(date, financial[k]) for k in info }\n",
    "\n",
    "print(pretty(l['fundamentals']))\n",
    "pl = l['bpp']['2_03']['value']\n",
    "vpa = pl/l['stocks']['total']\n",
    "vp = pl\n",
    "price_on = l['close']['on']\n",
    "price_pn = l['close']['pn']\n",
    "stocks_pn = l['stocks']['pn']\n",
    "stocks_on = l['stocks']['on']\n",
    "price = (price_on * stocks_on + price_pn * stocks_pn) / (stocks_on + stocks_pn)\n",
    "p_over_vpa = price/vpa\n",
    "\n",
    "\n",
    "table = pd.DataFrame([[\n",
    "  None,\n",
    "  pl,\n",
    "  vpa,\n",
    "  vp,\n",
    "  p_over_vpa,\n",
    "  l['fundamentals']['market_cap'],\n",
    "  l['fundamentals']['ev'],\n",
    "  None,\n",
    "  l['fundamentals']['ebit'],\n",
    "  None,\n",
    "  l['bpa']['1_01']['value'],\n",
    "  l['bpp']['2_01']['value'],\n",
    "  None,\n",
    "  l['fundamentals']['ev_over_ebit'],\n",
    "\n",
    "  ]], columns=[\n",
    "    'Dividend Yield', \n",
    "    'PL',\n",
    "    'VPA',\n",
    "    'VP',\n",
    "    'P/VPA',\n",
    "    'Valor de Mercado',\n",
    "    'EV',\n",
    "    'EBITDA',\n",
    "    'EBIT',\n",
    "    'Capital de Giro',\n",
    "    'Ativo Circulante',\n",
    "    'Passivo Circulante',\n",
    "    'EV/EBITDA',\n",
    "    'EV/EBIT',\n",
    "    # 'P/EBIT',\n",
    "    # 'P/EBITDA'\n",
    "    # 'P/Capital de Giro',\n",
    "    # 'P/Ativo Circulante',\n",
    "    # 'P/Ativo Total',\n",
    "    # 'LPA',\n",
    "    # 'P/SR'\n",
    "    # 'Dívida Líquida',\n",
    "    # 'Dívida Líquida/PL',\n",
    "    # 'Dívida Líquida/EBITDA',\n",
    "    # 'Dívida Líquida/EBIT',\n",
    "    # 'PL/Ativo Total',\n",
    "    # 'Passivo Total/Ativo Total',\n",
    "    # 'Índice de Liquidez Corrente',\n",
    "    # 'Margem Bruta',\n",
    "    # 'Margem EBITDA',\n",
    "    # 'Margem EBIT',\n",
    "    # 'Margem Líquida',\n",
    "    # 'ROE',\n",
    "    # 'ROA',\n",
    "    # 'ROIC',\n",
    "    # 'DRE',\n",
    "    # 'ROE/EBITDA',\n",
    "    ])\n",
    "print(table)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "interpreter": {
   "hash": "2248e0e0a89e6a1f0292b079d869fa8044c1304d4c35539044760349b27c43e8"
  },
  "kernelspec": {
   "display_name": "Python 3.9.8 ('oplab-notebook-66B5ZHN6-py3.9')",
   "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.9.8"
  },
  "orig_nbformat": 4
 },
 "nbformat": 4,
 "nbformat_minor": 2
}