Untitled-1.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "2024-06-24 19:13:27,670 - INFO - Connecting to database with URL: postgresql://postgres.trrwdbeylztbfswvrhlr:Theobaldo18$18@aws-0-sa-east-1.pooler.supabase.com:6543/postgres\n"
     ]
    }
   ],
   "source": [
    "from fetcherv6 import *\n",
    "from openaicall import *\n",
    "code = 2437"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "2024-06-24 18:00:12,454 - WARNING - Columns ['period_end'] not found in DataFrame\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Missing data for years: Index([2009], dtype='int64', name='reference_date')\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "2024-06-24 18:00:20,909 - INFO - HTTP Request: POST https://api.openai.com/v1/chat/completions \"HTTP/1.1 200 OK\"\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Processed year: 2015\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "2024-06-24 18:00:27,985 - INFO - HTTP Request: POST https://api.openai.com/v1/chat/completions \"HTTP/1.1 200 OK\"\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Processed year: 2016\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "2024-06-24 18:00:35,462 - INFO - HTTP Request: POST https://api.openai.com/v1/chat/completions \"HTTP/1.1 200 OK\"\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Processed year: 2017\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "2024-06-24 18:00:43,139 - INFO - HTTP Request: POST https://api.openai.com/v1/chat/completions \"HTTP/1.1 200 OK\"\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Processed year: 2018\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "2024-06-24 18:00:49,107 - INFO - HTTP Request: POST https://api.openai.com/v1/chat/completions \"HTTP/1.1 200 OK\"\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Processed year: 2019\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "2024-06-24 18:00:57,329 - INFO - HTTP Request: POST https://api.openai.com/v1/chat/completions \"HTTP/1.1 200 OK\"\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Processed year: 2020\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "2024-06-24 18:01:05,423 - INFO - HTTP Request: POST https://api.openai.com/v1/chat/completions \"HTTP/1.1 200 OK\"\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Processed year: 2021\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "2024-06-24 18:01:13,414 - INFO - HTTP Request: POST https://api.openai.com/v1/chat/completions \"HTTP/1.1 200 OK\"\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Processed year: 2022\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "2024-06-24 18:01:20,179 - INFO - HTTP Request: POST https://api.openai.com/v1/chat/completions \"HTTP/1.1 200 OK\"\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Processed year: 2023\n"
     ]
    }
   ],
   "source": [
    "from openaicall import get_predictions\n",
    "df = get_predictions(code)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "2024-06-24 20:14:39,608 - INFO - Connecting to database with URL: postgresql://postgres.trrwdbeylztbfswvrhlr:Theobaldo18$18@aws-0-sa-east-1.pooler.supabase.com:6543/postgres\n",
      "2024-06-24 20:14:45,876 - WARNING - Columns ['period_end'] not found in DataFrame\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Missing data for years: Index([2009], dtype='int64', name='reference_date')\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "2024-06-24 20:14:54,296 - INFO - HTTP Request: POST https://api.openai.com/v1/chat/completions \"HTTP/1.1 200 OK\"\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Processed year: 2015\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "2024-06-24 20:15:02,000 - INFO - HTTP Request: POST https://api.openai.com/v1/chat/completions \"HTTP/1.1 200 OK\"\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Processed year: 2016\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "2024-06-24 20:15:07,840 - INFO - HTTP Request: POST https://api.openai.com/v1/chat/completions \"HTTP/1.1 200 OK\"\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Processed year: 2017\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "2024-06-24 20:15:14,733 - INFO - HTTP Request: POST https://api.openai.com/v1/chat/completions \"HTTP/1.1 200 OK\"\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Processed year: 2018\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "2024-06-24 20:15:21,339 - INFO - HTTP Request: POST https://api.openai.com/v1/chat/completions \"HTTP/1.1 200 OK\"\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Processed year: 2019\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "2024-06-24 20:15:30,589 - INFO - HTTP Request: POST https://api.openai.com/v1/chat/completions \"HTTP/1.1 200 OK\"\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Processed year: 2020\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "2024-06-24 20:15:41,548 - INFO - HTTP Request: POST https://api.openai.com/v1/chat/completions \"HTTP/1.1 200 OK\"\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Processed year: 2021\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "2024-06-24 20:15:47,621 - INFO - HTTP Request: POST https://api.openai.com/v1/chat/completions \"HTTP/1.1 200 OK\"\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Processed year: 2022\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "2024-06-24 20:15:54,810 - INFO - HTTP Request: POST https://api.openai.com/v1/chat/completions \"HTTP/1.1 200 OK\"\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Processed year: 2023\n"
     ]
    }
   ],
   "source": [
    "from earnings_analysis import *\n",
    "fleury=21881\n",
    "df = get_predictions(fleury)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "2024-06-24 20:17:19,133 - WARNING - Columns ['period_end'] not found in DataFrame\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Missing data for years: Index([2011], dtype='int64', name='reference_date')\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "2024-06-24 20:17:26,100 - INFO - HTTP Request: POST https://api.openai.com/v1/chat/completions \"HTTP/1.1 200 OK\"\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Processed year: 2017\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "2024-06-24 20:17:32,425 - INFO - HTTP Request: POST https://api.openai.com/v1/chat/completions \"HTTP/1.1 200 OK\"\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Processed year: 2018\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "2024-06-24 20:17:37,954 - INFO - HTTP Request: POST https://api.openai.com/v1/chat/completions \"HTTP/1.1 200 OK\"\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Processed year: 2019\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "2024-06-24 20:17:43,791 - INFO - HTTP Request: POST https://api.openai.com/v1/chat/completions \"HTTP/1.1 200 OK\"\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Processed year: 2020\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "2024-06-24 20:17:51,928 - INFO - HTTP Request: POST https://api.openai.com/v1/chat/completions \"HTTP/1.1 200 OK\"\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Processed year: 2021\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "2024-06-24 20:17:57,819 - INFO - HTTP Request: POST https://api.openai.com/v1/chat/completions \"HTTP/1.1 200 OK\"\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Processed year: 2022\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "2024-06-24 20:18:02,962 - INFO - HTTP Request: POST https://api.openai.com/v1/chat/completions \"HTTP/1.1 200 OK\"\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Processed year: 2023\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "2024-06-24 20:18:04,015 - WARNING - Columns ['period_end'] not found in DataFrame\n",
      "2024-06-24 20:18:05,544 - INFO - Successfully fetched 2443 rows from the company table.\n",
      "2024-06-24 20:18:05,550 - INFO - Company name: Ambev\n",
      "2024-06-24 20:18:05,556 - INFO - Processing year: 2017\n",
      "2024-06-24 20:18:05,561 - INFO - Processing year: 2018\n",
      "2024-06-24 20:18:05,567 - INFO - Processing year: 2019\n",
      "2024-06-24 20:18:05,579 - INFO - Processing year: 2020\n",
      "2024-06-24 20:18:05,582 - INFO - Processing year: 2021\n",
      "2024-06-24 20:18:05,586 - INFO - Processing year: 2022\n",
      "2024-06-24 20:18:05,593 - INFO - Processing year: 2023\n",
      "2024-06-24 20:18:05,596 - INFO - Final DataFrame shape: (7, 7)\n",
      "2024-06-24 20:18:05,609 - INFO - Final DataFrame head:\n",
      "  Company Name  Year Actual Earnings Direction Predicted Earnings Direction  \\\n",
      "0        Ambev  2017                  decrease                     increase   \n",
      "1        Ambev  2018                  decrease                     decrease   \n",
      "2        Ambev  2019                  decrease                     increase   \n",
      "3        Ambev  2020                  decrease                     increase   \n",
      "4        Ambev  2021                  decrease                     increase   \n",
      "\n",
      "  Magnitude Confidence Score  \\\n",
      "0  moderate             0.75   \n",
      "1  moderate             0.75   \n",
      "2  moderate             0.75   \n",
      "3  moderate             0.75   \n",
      "4  moderate             0.75   \n",
      "\n",
      "                                Summary of Rationale  \n",
      "0  The company has shown a consistent increase in...  \n",
      "1  Analyzing the financial statements from 2013 t...  \n",
      "2  Analyzing the financial statements from 2014 t...  \n",
      "3  Analyzing the financial statements from 2015 t...  \n",
      "4  Analyzing the financial statements from 2016 t...  \n",
      "2024-06-24 20:18:05,640 - INFO - Analysis saved to Ambev_earnings_analysis.csv\n"
     ]
    },
    {
     "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>Company Name</th>\n",
       "      <th>Year</th>\n",
       "      <th>Actual Earnings Direction</th>\n",
       "      <th>Predicted Earnings Direction</th>\n",
       "      <th>Magnitude</th>\n",
       "      <th>Confidence Score</th>\n",
       "      <th>Summary of Rationale</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Ambev</td>\n",
       "      <td>2017</td>\n",
       "      <td>decrease</td>\n",
       "      <td>increase</td>\n",
       "      <td>moderate</td>\n",
       "      <td>0.75</td>\n",
       "      <td>The company has shown a consistent increase in...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Ambev</td>\n",
       "      <td>2018</td>\n",
       "      <td>decrease</td>\n",
       "      <td>decrease</td>\n",
       "      <td>moderate</td>\n",
       "      <td>0.75</td>\n",
       "      <td>Analyzing the financial statements from 2013 t...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Ambev</td>\n",
       "      <td>2019</td>\n",
       "      <td>decrease</td>\n",
       "      <td>increase</td>\n",
       "      <td>moderate</td>\n",
       "      <td>0.75</td>\n",
       "      <td>Analyzing the financial statements from 2014 t...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Ambev</td>\n",
       "      <td>2020</td>\n",
       "      <td>decrease</td>\n",
       "      <td>increase</td>\n",
       "      <td>moderate</td>\n",
       "      <td>0.75</td>\n",
       "      <td>Analyzing the financial statements from 2015 t...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Ambev</td>\n",
       "      <td>2021</td>\n",
       "      <td>decrease</td>\n",
       "      <td>increase</td>\n",
       "      <td>moderate</td>\n",
       "      <td>0.75</td>\n",
       "      <td>Analyzing the financial statements from 2016 t...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Ambev</td>\n",
       "      <td>2022</td>\n",
       "      <td>decrease</td>\n",
       "      <td>increase</td>\n",
       "      <td>moderate</td>\n",
       "      <td>0.75</td>\n",
       "      <td>The company has shown a consistent increase in...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Ambev</td>\n",
       "      <td>2023</td>\n",
       "      <td>decrease</td>\n",
       "      <td>increase</td>\n",
       "      <td>moderate</td>\n",
       "      <td>0.75</td>\n",
       "      <td>The company has shown a consistent increase in...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Company Name  Year Actual Earnings Direction Predicted Earnings Direction  \\\n",
       "0        Ambev  2017                  decrease                     increase   \n",
       "1        Ambev  2018                  decrease                     decrease   \n",
       "2        Ambev  2019                  decrease                     increase   \n",
       "3        Ambev  2020                  decrease                     increase   \n",
       "4        Ambev  2021                  decrease                     increase   \n",
       "5        Ambev  2022                  decrease                     increase   \n",
       "6        Ambev  2023                  decrease                     increase   \n",
       "\n",
       "  Magnitude Confidence Score  \\\n",
       "0  moderate             0.75   \n",
       "1  moderate             0.75   \n",
       "2  moderate             0.75   \n",
       "3  moderate             0.75   \n",
       "4  moderate             0.75   \n",
       "5  moderate             0.75   \n",
       "6  moderate             0.75   \n",
       "\n",
       "                                Summary of Rationale  \n",
       "0  The company has shown a consistent increase in...  \n",
       "1  Analyzing the financial statements from 2013 t...  \n",
       "2  Analyzing the financial statements from 2014 t...  \n",
       "3  Analyzing the financial statements from 2015 t...  \n",
       "4  Analyzing the financial statements from 2016 t...  \n",
       "5  The company has shown a consistent increase in...  \n",
       "6  The company has shown a consistent increase in...  "
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from earnings_analysis import *\n",
    "\n",
    "mag=22470\n",
    "ambev=23264\n",
    "analyze_earnings(ambev)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "companies = get_comp"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "ddmw-e8cxjo42-py3.12",
   "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.12.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}