Example_Usasage.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Processing CD_CVM: 23264\n",
      "Successfully executed the SQL query on the table 'ist' for the following CVM codes: [23264]\n",
      "Successfully executed the SQL query on the table 'bs' for the following CVM codes: [23264]\n",
      "Successfully executed the SQL query on the table 'cf' for the following CVM codes: [23264]\n",
      "Starting get_financial_prediction...\n",
      "Target years determined: [2019, 2020, 2021, 2022, 2023]\n",
      "Prompts created.\n",
      "Sending prompt for year 2019...\n",
      "Response from OpenAI API for year 2019: generations=[[ChatGeneration(text='Panel A ||| Trend Analysis: Over the past five years leading up to 2018, earnings have displayed significant volatility. There was steady growth from 2013 to 2016, peaking in 2016 at approximately 13,083,397. However, in 2017, earnings sharply declined to 7,850,504 before rebounding in 2018 to 11,377,427. The fluctuations are influenced by underlying operational performance and tax expenses, notably the significant tax burden in 2017, which likely contributed to the drop that year.\\n\\nPanel B ||| Ratio Analysis: Financial ratios over the past five years reveal a mixed picture. The current ratio has shown improving liquidity from 2017 to 2018. Meanwhile, the leverage ratio increased slightly due to rising total liabilities compared to equity, reflecting higher financial risk. Profit margins have been under pressure, reflected in the swing of earnings and operational margins due to volatile expenses and finance costs. Asset turnover showed improvement until 2018, indicating efficient asset use despite earnings volatility.\\n\\nPanel C ||| Rationale: Considering the mixed trend in earnings with recent recovery and moderate growth in sales, future earnings are expected to stabilize but may not exceed prior highs owing to leverage and possible finance cost constraints. The notable improvement from 2017 to 2018 suggests resilience, but the potential for disruptions remains. Thus, a cautious outlook is forecasted for 2019.\\n\\nDirection ||| increase  \\nMagnitude ||| moderate  \\nConfidence ||| 0.65', generation_info={'finish_reason': 'stop', 'logprobs': None}, message=AIMessage(content='Panel A ||| Trend Analysis: Over the past five years leading up to 2018, earnings have displayed significant volatility. There was steady growth from 2013 to 2016, peaking in 2016 at approximately 13,083,397. However, in 2017, earnings sharply declined to 7,850,504 before rebounding in 2018 to 11,377,427. The fluctuations are influenced by underlying operational performance and tax expenses, notably the significant tax burden in 2017, which likely contributed to the drop that year.\\n\\nPanel B ||| Ratio Analysis: Financial ratios over the past five years reveal a mixed picture. The current ratio has shown improving liquidity from 2017 to 2018. Meanwhile, the leverage ratio increased slightly due to rising total liabilities compared to equity, reflecting higher financial risk. Profit margins have been under pressure, reflected in the swing of earnings and operational margins due to volatile expenses and finance costs. Asset turnover showed improvement until 2018, indicating efficient asset use despite earnings volatility.\\n\\nPanel C ||| Rationale: Considering the mixed trend in earnings with recent recovery and moderate growth in sales, future earnings are expected to stabilize but may not exceed prior highs owing to leverage and possible finance cost constraints. The notable improvement from 2017 to 2018 suggests resilience, but the potential for disruptions remains. Thus, a cautious outlook is forecasted for 2019.\\n\\nDirection ||| increase  \\nMagnitude ||| moderate  \\nConfidence ||| 0.65', additional_kwargs={'refusal': None}, response_metadata={'token_usage': {'completion_tokens': 307, 'prompt_tokens': 19976, 'total_tokens': 20283, 'completion_tokens_details': {'audio_tokens': None, 'reasoning_tokens': 0}, 'prompt_tokens_details': {'audio_tokens': None, 'cached_tokens': 0}}, 'model_name': 'gpt-4o-2024-08-06', 'system_fingerprint': 'fp_a7d06e42a7', 'finish_reason': 'stop', 'logprobs': None}, id='run-c28b7094-5c4d-49e6-8443-29f12af6b9cf-0', usage_metadata={'input_tokens': 19976, 'output_tokens': 307, 'total_tokens': 20283, 'input_token_details': {'cache_read': 0}, 'output_token_details': {'reasoning': 0}}))]] llm_output={'token_usage': {'completion_tokens': 307, 'prompt_tokens': 19976, 'total_tokens': 20283, 'completion_tokens_details': {'audio_tokens': None, 'reasoning_tokens': 0}, 'prompt_tokens_details': {'audio_tokens': None, 'cached_tokens': 0}}, 'model_name': 'gpt-4o', 'system_fingerprint': 'fp_a7d06e42a7'} run=[RunInfo(run_id=UUID('c28b7094-5c4d-49e6-8443-29f12af6b9cf'))] type='LLMResult'\n",
      "Sending prompt for year 2020...\n",
      "Response from OpenAI API for year 2020: generations=[[ChatGeneration(text='Panel A ||| Trend Analysis: Over the five-year period preceding 2019, the earnings have shown some volatility. In 2013, earnings stood at 11.35 billion, rising annually until 2016, reaching 13.08 billion. However, in 2017 there was a notable decrease to 7.85 billion, followed by a recovery in 2018 to 11.38 billion and modest growth to 12.19 billion in 2019. Revenue has shown an upward trend, growing consistently from 34.79 billion in 2013 to 52.60 billion in 2019. Operational costs and expenses have also risen, impacting net income.\\n\\nPanel B ||| Ratio Analysis: The gross margin has fluctuated but remained relatively stable around 45%-55% over the period. The operating margin peaked in 2015 but decreased by 2019, possibly due to a rise in operational expenses. The net profit margin reflects volatility, dipping in 2017 then recovering by 2019. A trend of increasing total assets without a proportionate increase in net income suggests a potential decrease in asset efficiency. The debt-to-equity ratio indicates moderate leveraging, but with consistent increases in liabilities over time.\\n\\nPanel C ||| Rationale: Despite continuous revenue growth, earnings volatility indicates sensitivity to operational efficiencies and cost management. The five-year trend and ratio analysis suggest the company faces challenges in converting revenue growth into sustained earnings improvements. Given the stabilization in revenue and earnings recovery post-2017 dip, it is reasonable to predict earnings will continue to grow modestly. However, increased costs and operational expenses may dampen the magnitude of this growth.\\n\\nDirection ||| increase\\nMagnitude ||| moderate\\nConfidence ||| 0.75', generation_info={'finish_reason': 'stop', 'logprobs': None}, message=AIMessage(content='Panel A ||| Trend Analysis: Over the five-year period preceding 2019, the earnings have shown some volatility. In 2013, earnings stood at 11.35 billion, rising annually until 2016, reaching 13.08 billion. However, in 2017 there was a notable decrease to 7.85 billion, followed by a recovery in 2018 to 11.38 billion and modest growth to 12.19 billion in 2019. Revenue has shown an upward trend, growing consistently from 34.79 billion in 2013 to 52.60 billion in 2019. Operational costs and expenses have also risen, impacting net income.\\n\\nPanel B ||| Ratio Analysis: The gross margin has fluctuated but remained relatively stable around 45%-55% over the period. The operating margin peaked in 2015 but decreased by 2019, possibly due to a rise in operational expenses. The net profit margin reflects volatility, dipping in 2017 then recovering by 2019. A trend of increasing total assets without a proportionate increase in net income suggests a potential decrease in asset efficiency. The debt-to-equity ratio indicates moderate leveraging, but with consistent increases in liabilities over time.\\n\\nPanel C ||| Rationale: Despite continuous revenue growth, earnings volatility indicates sensitivity to operational efficiencies and cost management. The five-year trend and ratio analysis suggest the company faces challenges in converting revenue growth into sustained earnings improvements. Given the stabilization in revenue and earnings recovery post-2017 dip, it is reasonable to predict earnings will continue to grow modestly. However, increased costs and operational expenses may dampen the magnitude of this growth.\\n\\nDirection ||| increase\\nMagnitude ||| moderate\\nConfidence ||| 0.75', additional_kwargs={'refusal': None}, response_metadata={'token_usage': {'completion_tokens': 355, 'prompt_tokens': 22716, 'total_tokens': 23071, 'completion_tokens_details': {'audio_tokens': None, 'reasoning_tokens': 0}, 'prompt_tokens_details': {'audio_tokens': None, 'cached_tokens': 0}}, 'model_name': 'gpt-4o-2024-08-06', 'system_fingerprint': 'fp_a7d06e42a7', 'finish_reason': 'stop', 'logprobs': None}, id='run-e8b0ab5f-af50-4fac-b7cc-223705dee39a-0', usage_metadata={'input_tokens': 22716, 'output_tokens': 355, 'total_tokens': 23071, 'input_token_details': {'cache_read': 0}, 'output_token_details': {'reasoning': 0}}))]] llm_output={'token_usage': {'completion_tokens': 355, 'prompt_tokens': 22716, 'total_tokens': 23071, 'completion_tokens_details': {'audio_tokens': None, 'reasoning_tokens': 0}, 'prompt_tokens_details': {'audio_tokens': None, 'cached_tokens': 0}}, 'model_name': 'gpt-4o', 'system_fingerprint': 'fp_a7d06e42a7'} run=[RunInfo(run_id=UUID('e8b0ab5f-af50-4fac-b7cc-223705dee39a'))] type='LLMResult'\n",
      "Sending prompt for year 2021...\n",
      "Response from OpenAI API for year 2021: generations=[[ChatGeneration(text=\"Panel A ||| The earnings over the years from 2013 to 2020 have overall shown a generally stable but slightly fluctuating trajectory. The earnings were at their lowest in 2017 due to a noteworthy drop, marking a substantial decrease, but recovered by 2018 and have since maintained a consistently stable pattern with marginal annual changes. The period from 2018 to 2020 shows relatively consistent earnings, hovering around the 11.3 to 12.1 billion mark, indicating profitability stability after the slump in 2017.\\n\\nPanel B ||| The Gross Margin ranged from approximately 66% to 54% between 2013 and 2020, depicting a gradual decline, mainly due to a higher rate of increase in the cost of goods sold compared to sales. Operating Margin showed a declining trend, particularly steep in 2017, aligned with the dramatic earnings drop. The Current Ratio improved steadily over the years, from 1.18 in 2013 to 1.06 in 2020, indicating better liquidity positions in recent years. The Debt to Equity Ratio remained relatively stable following slight fluctuations, indicating prudent financial management post-2018. The Return on Equity was generally stable but with a noticeable decline in 2017, recovering afterward.\\n\\nPanel C ||| Based on historical trends, earnings have demonstrated resilience, barring the abrupt downturn in 2017, mostly maintaining recovery and stability post-2017. The company's ability to maintain financial ratios, particularly liquidity and leveraging through adept fiscal strategies, suggests an ability to manage costs effectively. Given the historical trend of gradual revenue growth and stable financial indicators, we anticipate earnings will sustain their current trajectory, leaning towards a mild uptrend bolstered by a consistent operational framework and stable market positioning.\\n\\nDirection ||| increase\\n\\nMagnitude ||| small\\n\\nConfidence ||| 0.75\", generation_info={'finish_reason': 'stop', 'logprobs': None}, message=AIMessage(content=\"Panel A ||| The earnings over the years from 2013 to 2020 have overall shown a generally stable but slightly fluctuating trajectory. The earnings were at their lowest in 2017 due to a noteworthy drop, marking a substantial decrease, but recovered by 2018 and have since maintained a consistently stable pattern with marginal annual changes. The period from 2018 to 2020 shows relatively consistent earnings, hovering around the 11.3 to 12.1 billion mark, indicating profitability stability after the slump in 2017.\\n\\nPanel B ||| The Gross Margin ranged from approximately 66% to 54% between 2013 and 2020, depicting a gradual decline, mainly due to a higher rate of increase in the cost of goods sold compared to sales. Operating Margin showed a declining trend, particularly steep in 2017, aligned with the dramatic earnings drop. The Current Ratio improved steadily over the years, from 1.18 in 2013 to 1.06 in 2020, indicating better liquidity positions in recent years. The Debt to Equity Ratio remained relatively stable following slight fluctuations, indicating prudent financial management post-2018. The Return on Equity was generally stable but with a noticeable decline in 2017, recovering afterward.\\n\\nPanel C ||| Based on historical trends, earnings have demonstrated resilience, barring the abrupt downturn in 2017, mostly maintaining recovery and stability post-2017. The company's ability to maintain financial ratios, particularly liquidity and leveraging through adept fiscal strategies, suggests an ability to manage costs effectively. Given the historical trend of gradual revenue growth and stable financial indicators, we anticipate earnings will sustain their current trajectory, leaning towards a mild uptrend bolstered by a consistent operational framework and stable market positioning.\\n\\nDirection ||| increase\\n\\nMagnitude ||| small\\n\\nConfidence ||| 0.75\", additional_kwargs={'refusal': None}, response_metadata={'token_usage': {'completion_tokens': 373, 'prompt_tokens': 25468, 'total_tokens': 25841, 'completion_tokens_details': {'audio_tokens': None, 'reasoning_tokens': 0}, 'prompt_tokens_details': {'audio_tokens': None, 'cached_tokens': 0}}, 'model_name': 'gpt-4o-2024-08-06', 'system_fingerprint': 'fp_45c6de4934', 'finish_reason': 'stop', 'logprobs': None}, id='run-7727a32c-df69-49b0-882f-55e5bc88a70b-0', usage_metadata={'input_tokens': 25468, 'output_tokens': 373, 'total_tokens': 25841, 'input_token_details': {'cache_read': 0}, 'output_token_details': {'reasoning': 0}}))]] llm_output={'token_usage': {'completion_tokens': 373, 'prompt_tokens': 25468, 'total_tokens': 25841, 'completion_tokens_details': {'audio_tokens': None, 'reasoning_tokens': 0}, 'prompt_tokens_details': {'audio_tokens': None, 'cached_tokens': 0}}, 'model_name': 'gpt-4o', 'system_fingerprint': 'fp_45c6de4934'} run=[RunInfo(run_id=UUID('7727a32c-df69-49b0-882f-55e5bc88a70b'))] type='LLMResult'\n",
      "Sending prompt for year 2022...\n",
      "Response from OpenAI API for year 2022: generations=[[ChatGeneration(text='Panel A ||| Trend Analysis: Over the past five years, the earnings have shown stability with some fluctuation. In 2017, earnings significantly decreased to 7,850,504, which was an anomaly compared to other years where earnings consistently hovered around 11 to 13 billion. By 2021, earnings rose to 13,122,582, indicating a return to more robust performance. The overall trend suggests a recovery and stability trajectory post-2017 downturn.\\n\\nPanel B ||| Ratio Analysis: The Gross Margin reflects relative stability, increasing from 58% in 2019 to approximately 51% in 2021, suggesting efficient cost management. The Operating Margin has been reasonably stable, with a slight increase to about 28% in 2021, which implies disciplined operational control. The Debt-to-Equity Ratio suggests growing leverage but remains manageable, reflecting an ability to sustain debt levels without excessive risk.\\n\\nPanel C ||| Rationale: The analyses show that after a dip in 2017, the company has recovered its earnings strength, supported by stable gross and operating margins and effective cost management, which is fundamental for sustaining performance. In the context of historical performance, the company is positioned to experience continued stability or moderate growth in earnings.\\n\\nDirection ||| increase\\nMagnitude ||| moderate\\nConfidence ||| 0.75', generation_info={'finish_reason': 'stop', 'logprobs': None}, message=AIMessage(content='Panel A ||| Trend Analysis: Over the past five years, the earnings have shown stability with some fluctuation. In 2017, earnings significantly decreased to 7,850,504, which was an anomaly compared to other years where earnings consistently hovered around 11 to 13 billion. By 2021, earnings rose to 13,122,582, indicating a return to more robust performance. The overall trend suggests a recovery and stability trajectory post-2017 downturn.\\n\\nPanel B ||| Ratio Analysis: The Gross Margin reflects relative stability, increasing from 58% in 2019 to approximately 51% in 2021, suggesting efficient cost management. The Operating Margin has been reasonably stable, with a slight increase to about 28% in 2021, which implies disciplined operational control. The Debt-to-Equity Ratio suggests growing leverage but remains manageable, reflecting an ability to sustain debt levels without excessive risk.\\n\\nPanel C ||| Rationale: The analyses show that after a dip in 2017, the company has recovered its earnings strength, supported by stable gross and operating margins and effective cost management, which is fundamental for sustaining performance. In the context of historical performance, the company is positioned to experience continued stability or moderate growth in earnings.\\n\\nDirection ||| increase\\nMagnitude ||| moderate\\nConfidence ||| 0.75', additional_kwargs={'refusal': None}, response_metadata={'token_usage': {'completion_tokens': 272, 'prompt_tokens': 28219, 'total_tokens': 28491, 'completion_tokens_details': {'audio_tokens': None, 'reasoning_tokens': 0}, 'prompt_tokens_details': {'audio_tokens': None, 'cached_tokens': 0}}, 'model_name': 'gpt-4o-2024-08-06', 'system_fingerprint': 'fp_a7d06e42a7', 'finish_reason': 'stop', 'logprobs': None}, id='run-cc111792-0412-43ed-830b-062b34734d2f-0', usage_metadata={'input_tokens': 28219, 'output_tokens': 272, 'total_tokens': 28491, 'input_token_details': {'cache_read': 0}, 'output_token_details': {'reasoning': 0}}))]] llm_output={'token_usage': {'completion_tokens': 272, 'prompt_tokens': 28219, 'total_tokens': 28491, 'completion_tokens_details': {'audio_tokens': None, 'reasoning_tokens': 0}, 'prompt_tokens_details': {'audio_tokens': None, 'cached_tokens': 0}}, 'model_name': 'gpt-4o', 'system_fingerprint': 'fp_a7d06e42a7'} run=[RunInfo(run_id=UUID('cc111792-0412-43ed-830b-062b34734d2f'))] type='LLMResult'\n",
      "Sending prompt for year 2023...\n",
      "Response from OpenAI API for year 2023: generations=[[ChatGeneration(text='Panel A ||| Trend Analysis: Over the past five years, earnings have demonstrated consistent growth, recovering from a dip in 2017 when earnings were 7,850,504. In 2018, earnings increased to 11,377,427, followed by continued growth through 2019 at 12,188,332, 2020 at 11,731,909, 2021 at 13,122,582, and reached 14,891,291 by 2022. The trajectory suggests a steady and positive growth pattern, underpinned by increasing sales and effective cost controls.\\n\\nPanel B ||| Ratio Analysis: The current ratio has been stable, moving from 1.19 in 2018 to around 0.93 in 2022, indicating a reasonable liquidity position. The net profit margin has gradually improved over these years, indicating efficiency in converting revenue into net earnings. Return on Equity (ROE) has also increased slightly from 2018 onwards, reaching better returns, reflecting enhanced operational efficiency and income generation from equity, which supports future earnings expansion.\\n\\nPanel C ||| Rationale: The historical performance and financial health indicators suggest that earnings are on a consistent upward trajectory due to robust revenue growth, manageable cost structures, and improvements in profit margins. Coupled with a stable leverage profile and improved operational efficiency, it is reasonable to predict further earnings growth. The resilience shown in earnings growth in prior years, despite external pressures, supports a confident outlook for 2023.\\n\\nDirection ||| increase  \\nMagnitude ||| moderate  \\nConfidence ||| 0.80', generation_info={'finish_reason': 'stop', 'logprobs': None}, message=AIMessage(content='Panel A ||| Trend Analysis: Over the past five years, earnings have demonstrated consistent growth, recovering from a dip in 2017 when earnings were 7,850,504. In 2018, earnings increased to 11,377,427, followed by continued growth through 2019 at 12,188,332, 2020 at 11,731,909, 2021 at 13,122,582, and reached 14,891,291 by 2022. The trajectory suggests a steady and positive growth pattern, underpinned by increasing sales and effective cost controls.\\n\\nPanel B ||| Ratio Analysis: The current ratio has been stable, moving from 1.19 in 2018 to around 0.93 in 2022, indicating a reasonable liquidity position. The net profit margin has gradually improved over these years, indicating efficiency in converting revenue into net earnings. Return on Equity (ROE) has also increased slightly from 2018 onwards, reaching better returns, reflecting enhanced operational efficiency and income generation from equity, which supports future earnings expansion.\\n\\nPanel C ||| Rationale: The historical performance and financial health indicators suggest that earnings are on a consistent upward trajectory due to robust revenue growth, manageable cost structures, and improvements in profit margins. Coupled with a stable leverage profile and improved operational efficiency, it is reasonable to predict further earnings growth. The resilience shown in earnings growth in prior years, despite external pressures, supports a confident outlook for 2023.\\n\\nDirection ||| increase  \\nMagnitude ||| moderate  \\nConfidence ||| 0.80', additional_kwargs={'refusal': None}, response_metadata={'token_usage': {'completion_tokens': 322, 'prompt_tokens': 30964, 'total_tokens': 31286, 'completion_tokens_details': {'audio_tokens': None, 'reasoning_tokens': 0}, 'prompt_tokens_details': {'audio_tokens': None, 'cached_tokens': 0}}, 'model_name': 'gpt-4o-2024-08-06', 'system_fingerprint': 'fp_6b68a8204b', 'finish_reason': 'stop', 'logprobs': None}, id='run-fc3e08d1-e452-4c80-bd02-0ab82da414d0-0', usage_metadata={'input_tokens': 30964, 'output_tokens': 322, 'total_tokens': 31286, 'input_token_details': {'cache_read': 0}, 'output_token_details': {'reasoning': 0}}))]] llm_output={'token_usage': {'completion_tokens': 322, 'prompt_tokens': 30964, 'total_tokens': 31286, 'completion_tokens_details': {'audio_tokens': None, 'reasoning_tokens': 0}, 'prompt_tokens_details': {'audio_tokens': None, 'cached_tokens': 0}}, 'model_name': 'gpt-4o', 'system_fingerprint': 'fp_6b68a8204b'} run=[RunInfo(run_id=UUID('fc3e08d1-e452-4c80-bd02-0ab82da414d0'))] type='LLMResult'\n",
      "Predictions received.\n",
      "Processing CD_CVM: 24112\n",
      "Successfully executed the SQL query on the table 'ist' for the following CVM codes: [24112]\n",
      "Successfully executed the SQL query on the table 'bs' for the following CVM codes: [24112]\n",
      "Successfully executed the SQL query on the table 'cf' for the following CVM codes: [24112]\n",
      "Starting get_financial_prediction...\n",
      "Skipping year 2020 due to insufficient historical data.\n",
      "Skipping year 2019 due to insufficient historical data.\n",
      "Target years determined: [2021, 2022, 2023]\n",
      "Prompts created.\n",
      "Sending prompt for year 2021...\n",
      "Response from OpenAI API for year 2021: generations=[[ChatGeneration(text=\"Panel A ||| Over the past five years, earnings have exhibited significant volatility. Beginning with a loss in 2016, earnings turned positive in 2017 and 2018, reaching respective highs of 529,039 and 420,277. However, in 2019 and 2020, the company experienced substantial downturns, with earnings plummeting to -2,403,086 and -10,834,709, respectively. This marked decline was particularly steep in 2020, indicating underlying operational challenges or economic impacts.\\n\\nPanel B ||| Key financial ratios over the past five years paint a stark picture of the company's financial health. The gross margin showed a decline from 2016 to 2020, contributing to the observed earnings volatility. The current ratio was relatively stable, yet liquidity constraints might be implied by growing liabilities, especially visible in the worsening debt-to-equity ratio from 2019 onwards. This shift suggests increasing financial leverage and potential risk. Return on equity turned deeply negative in 2019 and 2020, reflecting significant losses.\\n\\nPanel C ||| The analyses point to a company facing substantial financial instability, particularly as of 2019 and 2020. The drastic shift to large losses in earnings indicates potential operational inefficiencies, heightened financial leverage, or external pressures impacting profitability. These observations suggest continued challenges for the target period, with recovery potentially contingent upon addressing underlying issues.\\n\\nDirection ||| decrease\\nMagnitude ||| moderate\\nConfidence ||| 0.70\", generation_info={'finish_reason': 'stop', 'logprobs': None}, message=AIMessage(content=\"Panel A ||| Over the past five years, earnings have exhibited significant volatility. Beginning with a loss in 2016, earnings turned positive in 2017 and 2018, reaching respective highs of 529,039 and 420,277. However, in 2019 and 2020, the company experienced substantial downturns, with earnings plummeting to -2,403,086 and -10,834,709, respectively. This marked decline was particularly steep in 2020, indicating underlying operational challenges or economic impacts.\\n\\nPanel B ||| Key financial ratios over the past five years paint a stark picture of the company's financial health. The gross margin showed a decline from 2016 to 2020, contributing to the observed earnings volatility. The current ratio was relatively stable, yet liquidity constraints might be implied by growing liabilities, especially visible in the worsening debt-to-equity ratio from 2019 onwards. This shift suggests increasing financial leverage and potential risk. Return on equity turned deeply negative in 2019 and 2020, reflecting significant losses.\\n\\nPanel C ||| The analyses point to a company facing substantial financial instability, particularly as of 2019 and 2020. The drastic shift to large losses in earnings indicates potential operational inefficiencies, heightened financial leverage, or external pressures impacting profitability. These observations suggest continued challenges for the target period, with recovery potentially contingent upon addressing underlying issues.\\n\\nDirection ||| decrease\\nMagnitude ||| moderate\\nConfidence ||| 0.70\", additional_kwargs={'refusal': None}, response_metadata={'token_usage': {'completion_tokens': 302, 'prompt_tokens': 16814, 'total_tokens': 17116, 'completion_tokens_details': {'audio_tokens': None, 'reasoning_tokens': 0}, 'prompt_tokens_details': {'audio_tokens': None, 'cached_tokens': 0}}, 'model_name': 'gpt-4o-2024-08-06', 'system_fingerprint': 'fp_45c6de4934', 'finish_reason': 'stop', 'logprobs': None}, id='run-b0baf74a-e35e-420c-902a-0071c3e08f9b-0', usage_metadata={'input_tokens': 16814, 'output_tokens': 302, 'total_tokens': 17116, 'input_token_details': {'cache_read': 0}, 'output_token_details': {'reasoning': 0}}))]] llm_output={'token_usage': {'completion_tokens': 302, 'prompt_tokens': 16814, 'total_tokens': 17116, 'completion_tokens_details': {'audio_tokens': None, 'reasoning_tokens': 0}, 'prompt_tokens_details': {'audio_tokens': None, 'cached_tokens': 0}}, 'model_name': 'gpt-4o', 'system_fingerprint': 'fp_45c6de4934'} run=[RunInfo(run_id=UUID('b0baf74a-e35e-420c-902a-0071c3e08f9b'))] type='LLMResult'\n",
      "Sending prompt for year 2022...\n",
      "Response from OpenAI API for year 2022: generations=[[ChatGeneration(text='Panel A ||| The recent trends in earnings show a significant fluctuation. Over the past five years, the earnings have been volatile, from a positive figure in 2017 of 529,039 to substantial losses of -2,403,086 in 2019, reaching -10,834,709 in 2020, and slightly improving to a still negative -4,213,208 in 2021. This indicates some volatility and potentially significant challenges faced by the company in maintaining consistent profitability.\\n\\nPanel B ||| Examining liquidity ratios, the current ratio improved from 0.53 in 2016 to 0.50 in 2021, but the ratio indicates persistent liquidity issues. The debt-to-equity ratio has been increasingly negative, particularly alarming with an increase from negative values in the past years to a value still markedly negative in recent years, suggesting high financial leverage and potentially risky capital structure. The gross margin fluctuated but showed some recovery in 2021 at 18.6%, signaling some improvement in production efficiency or pricing strategy.\\n\\nPanel C ||| The recurring negative earnings from continuing operations indicate systemic operational challenges possibly due to high debt levels and related financial costs, as suggested by the worsening debt-to-equity ratio and financial leverage. Revenue volatility combined with negative net income trends points to significant operating performance challenges. Unless these structural issues are addressed thoroughly, predicting a continued decrease in earnings remains justified.\\n\\nDirection ||| decrease  \\nMagnitude ||| moderate  \\nConfidence ||| 0.70', generation_info={'finish_reason': 'stop', 'logprobs': None}, message=AIMessage(content='Panel A ||| The recent trends in earnings show a significant fluctuation. Over the past five years, the earnings have been volatile, from a positive figure in 2017 of 529,039 to substantial losses of -2,403,086 in 2019, reaching -10,834,709 in 2020, and slightly improving to a still negative -4,213,208 in 2021. This indicates some volatility and potentially significant challenges faced by the company in maintaining consistent profitability.\\n\\nPanel B ||| Examining liquidity ratios, the current ratio improved from 0.53 in 2016 to 0.50 in 2021, but the ratio indicates persistent liquidity issues. The debt-to-equity ratio has been increasingly negative, particularly alarming with an increase from negative values in the past years to a value still markedly negative in recent years, suggesting high financial leverage and potentially risky capital structure. The gross margin fluctuated but showed some recovery in 2021 at 18.6%, signaling some improvement in production efficiency or pricing strategy.\\n\\nPanel C ||| The recurring negative earnings from continuing operations indicate systemic operational challenges possibly due to high debt levels and related financial costs, as suggested by the worsening debt-to-equity ratio and financial leverage. Revenue volatility combined with negative net income trends points to significant operating performance challenges. Unless these structural issues are addressed thoroughly, predicting a continued decrease in earnings remains justified.\\n\\nDirection ||| decrease  \\nMagnitude ||| moderate  \\nConfidence ||| 0.70', additional_kwargs={'refusal': None}, response_metadata={'token_usage': {'completion_tokens': 303, 'prompt_tokens': 19506, 'total_tokens': 19809, 'completion_tokens_details': {'audio_tokens': None, 'reasoning_tokens': 0}, 'prompt_tokens_details': {'audio_tokens': None, 'cached_tokens': 0}}, 'model_name': 'gpt-4o-2024-08-06', 'system_fingerprint': 'fp_a7d06e42a7', 'finish_reason': 'stop', 'logprobs': None}, id='run-95c7f7c2-122c-4c64-95f9-ef3705d13e0a-0', usage_metadata={'input_tokens': 19506, 'output_tokens': 303, 'total_tokens': 19809, 'input_token_details': {'cache_read': 0}, 'output_token_details': {'reasoning': 0}}))]] llm_output={'token_usage': {'completion_tokens': 303, 'prompt_tokens': 19506, 'total_tokens': 19809, 'completion_tokens_details': {'audio_tokens': None, 'reasoning_tokens': 0}, 'prompt_tokens_details': {'audio_tokens': None, 'cached_tokens': 0}}, 'model_name': 'gpt-4o', 'system_fingerprint': 'fp_a7d06e42a7'} run=[RunInfo(run_id=UUID('95c7f7c2-122c-4c64-95f9-ef3705d13e0a'))] type='LLMResult'\n",
      "Sending prompt for year 2023...\n",
      "Response from OpenAI API for year 2023: generations=[[ChatGeneration(text='Panel A ||| From 2016 to 2022, earnings showed significant volatility. The company recorded positive earnings in 2017 and 2018, but large losses in the following years, particularly a massive negative earnings of -10.8 million in 2020. However, earnings improved drastically in 2022 with a substantial reduction in losses to -722 thousand. The revenue growth rebounded strongly in 2022, signaling potential operational recovery.\\nPanel B ||| The liquidity ratio (current assets over current liabilities) has shown varied performance with a declining trend from 1.25 in 2016 to about 0.32 in 2022. The company’s leverage, as indicated by the debt ratio (total liabilities to total assets), increased over time, reaching around 1 in recent years, suggesting high gearing but improved operating efficiency in 2022. Operating margin, calculated as operating income over revenue, improved to 9% in 2022, suggesting cost management improvements.\\nPanel C ||| The analysis of past earnings and balance sheet ratios indicates potential for continued recovery in 2023. Earnings volatility reflects restructuring efforts or recovery processes. The improvement in 2022 earnings, alongside strong revenue growth and operating margin, supports a positive outlook. However, high leverage remains a risk factor but may drive higher earnings through favorable interest rate environments or operational scaling.\\nDirection ||| increase\\nMagnitude ||| moderate\\nConfidence ||| 0.75', generation_info={'finish_reason': 'stop', 'logprobs': None}, message=AIMessage(content='Panel A ||| From 2016 to 2022, earnings showed significant volatility. The company recorded positive earnings in 2017 and 2018, but large losses in the following years, particularly a massive negative earnings of -10.8 million in 2020. However, earnings improved drastically in 2022 with a substantial reduction in losses to -722 thousand. The revenue growth rebounded strongly in 2022, signaling potential operational recovery.\\nPanel B ||| The liquidity ratio (current assets over current liabilities) has shown varied performance with a declining trend from 1.25 in 2016 to about 0.32 in 2022. The company’s leverage, as indicated by the debt ratio (total liabilities to total assets), increased over time, reaching around 1 in recent years, suggesting high gearing but improved operating efficiency in 2022. Operating margin, calculated as operating income over revenue, improved to 9% in 2022, suggesting cost management improvements.\\nPanel C ||| The analysis of past earnings and balance sheet ratios indicates potential for continued recovery in 2023. Earnings volatility reflects restructuring efforts or recovery processes. The improvement in 2022 earnings, alongside strong revenue growth and operating margin, supports a positive outlook. However, high leverage remains a risk factor but may drive higher earnings through favorable interest rate environments or operational scaling.\\nDirection ||| increase\\nMagnitude ||| moderate\\nConfidence ||| 0.75', additional_kwargs={'refusal': None}, response_metadata={'token_usage': {'completion_tokens': 293, 'prompt_tokens': 22194, 'total_tokens': 22487, 'completion_tokens_details': {'audio_tokens': None, 'reasoning_tokens': 0}, 'prompt_tokens_details': {'audio_tokens': None, 'cached_tokens': 0}}, 'model_name': 'gpt-4o-2024-08-06', 'system_fingerprint': 'fp_6b68a8204b', 'finish_reason': 'stop', 'logprobs': None}, id='run-7b33257d-5eae-48d7-80c0-b72dd0dbffdd-0', usage_metadata={'input_tokens': 22194, 'output_tokens': 293, 'total_tokens': 22487, 'input_token_details': {'cache_read': 0}, 'output_token_details': {'reasoning': 0}}))]] llm_output={'token_usage': {'completion_tokens': 293, 'prompt_tokens': 22194, 'total_tokens': 22487, 'completion_tokens_details': {'audio_tokens': None, 'reasoning_tokens': 0}, 'prompt_tokens_details': {'audio_tokens': None, 'cached_tokens': 0}}, 'model_name': 'gpt-4o', 'system_fingerprint': 'fp_6b68a8204b'} run=[RunInfo(run_id=UUID('7b33257d-5eae-48d7-80c0-b72dd0dbffdd'))] type='LLMResult'\n",
      "Predictions received.\n",
      "   Year                                            Panel A  \\\n",
      "0  2019  Trend Analysis: Over the past five years leadi...   \n",
      "1  2020  Trend Analysis: Over the five-year period prec...   \n",
      "2  2021  The earnings over the years from 2013 to 2020 ...   \n",
      "3  2022  Trend Analysis: Over the past five years, the ...   \n",
      "4  2023  Trend Analysis: Over the past five years, earn...   \n",
      "5  2021  Over the past five years, earnings have exhibi...   \n",
      "6  2022  The recent trends in earnings show a significa...   \n",
      "7  2023  From 2016 to 2022, earnings showed significant...   \n",
      "\n",
      "                                             Panel B  \\\n",
      "0  Ratio Analysis: Financial ratios over the past...   \n",
      "1  Ratio Analysis: The gross margin has fluctuate...   \n",
      "2  The Gross Margin ranged from approximately 66%...   \n",
      "3  Ratio Analysis: The Gross Margin reflects rela...   \n",
      "4  Ratio Analysis: The current ratio has been sta...   \n",
      "5  Key financial ratios over the past five years ...   \n",
      "6  Examining liquidity ratios, the current ratio ...   \n",
      "7  The liquidity ratio (current assets over curre...   \n",
      "\n",
      "                                             Panel C  Prediction Direction  \\\n",
      "0  Rationale: Considering the mixed trend in earn...                     1   \n",
      "1  Rationale: Despite continuous revenue growth, ...                     1   \n",
      "2  Based on historical trends, earnings have demo...                     1   \n",
      "3  Rationale: The analyses show that after a dip ...                     1   \n",
      "4  Rationale: The historical performance and fina...                     1   \n",
      "5  The analyses point to a company facing substan...                    -1   \n",
      "6  The recurring negative earnings from continuin...                    -1   \n",
      "7  The analysis of past earnings and balance shee...                     1   \n",
      "\n",
      "  Magnitude  Confidence  Completion Tokens  Prompt Tokens Model Name  CD_CVM  \n",
      "0  moderate        0.65                307          19976     gpt-4o   23264  \n",
      "1  moderate        0.75                355          22716     gpt-4o   23264  \n",
      "2     small        0.75                373          25468     gpt-4o   23264  \n",
      "3  moderate        0.75                272          28219     gpt-4o   23264  \n",
      "4  moderate        0.80                322          30964     gpt-4o   23264  \n",
      "5  moderate        0.70                302          16814     gpt-4o   24112  \n",
      "6  moderate        0.70                303          19506     gpt-4o   24112  \n",
      "7  moderate        0.75                293          22194     gpt-4o   24112  \n"
     ]
    }
   ],
   "source": [
    "from call import *\n",
    "ambev_code = 23264\n",
    "azul_code = 24112\n",
    "\n",
    "predictions = get_financial_prediction_list([ambev_code, azul_code], n_years=5)\n",
    "print(predictions)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'Rationale: Considering the mixed trend in earnings with recent recovery and moderate growth in sales, future earnings are expected to stabilize but may not exceed prior highs owing to leverage and possible finance cost constraints. The notable improvement from 2017 to 2018 suggests resilience, but the potential for disruptions remains. Thus, a cautious outlook is forecasted for 2019.  Direction ||| increase   Magnitude ||| moderate   Confidence ||| 0.65'"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "predictions.iloc[0,3]\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": ".venv",
   "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.13.0"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}