Skip to content

Instantly share code, notes, and snippets.

@arademaker

arademaker/report.md

Last active July 11, 2025 15:56
Show Gist options
  • Save arademaker/4449d42f29215f372c92255cfcc71e3e to your computer and use it in GitHub Desktop.
Save arademaker/4449d42f29215f372c92255cfcc71e3e to your computer and use it in GitHub Desktop.
Download ZIP
análise BBAS preço justo usando Bazin
Raw
report.md

Análise preço justo BBAS3 usando Bazin

fontes de dados

Fontes historico de dividendos

  1. https://www.dadosdemercado.com.br/acoes/bbas3/dividendos
  2. https://playinvest.com.br/dividendos/bbas3
  3. https://finance.yahoo.com/quote/BBAS3.SA/history/?filter=div&period1=946900800&period2=1752245123&frequency=1mo
  4. https://www.fundamentus.com.br/proventos.php?papel=BBAS3&tipo=2

dados do link 1

tipo valor registro ex pagamento
JCP 0.090447 02/06/2025 03/06/2025 12/06/2025
JCP 0.334258 02/06/2025 03/06/2025 12/06/2025
Dividendo 0.003545 11/03/2025 12/03/2025 20/03/2025
Dividendo 0.008931 11/03/2025 12/03/2025 20/03/2025
JCP 0.149351 11/03/2025 12/03/2025 21/03/2025
JCP 0.342592 11/03/2025 12/03/2025 20/03/2025
Dividendo 0.136002 11/03/2025 12/03/2025 20/03/2025
JCP 0.176490 11/12/2024 12/12/2024 27/12/2024
JCP 0.483300 25/11/2024 26/11/2024 06/12/2024
JCP 0.186602 11/09/2024 12/09/2024 27/09/2024
JCP 0.314481 21/08/2024 22/08/2024 30/08/2024
Dividendo 0.002707 21/08/2024 22/08/2024 30/08/2024
Dividendo 0.151861 21/08/2024 22/08/2024 30/08/2024
Dividendo 0.005606 21/08/2024 22/08/2024 30/08/2024
JCP 0.204240 13/06/2024 14/06/2024 28/06/2024
JCP 0.293161 11/06/2024 12/06/2024 21/06/2024
Dividendo 0.164786 11/06/2024 12/06/2024 21/06/2024
JCP 0.205018 11/03/2024 12/03/2024 27/03/2024
Dividendo 0.110409 21/02/2024 22/02/2024 29/02/2024
Dividendo 0.007412 21/02/2024 22/02/2024 29/02/2024
JCP 0.306818 21/02/2024 22/02/2024 29/02/2024
JCP 0.171153 11/12/2023 12/12/2023 28/12/2023
JCP 0.343111 21/11/2023 22/11/2023 30/11/2023
Dividendo 0.050994 21/11/2023 22/11/2023 30/11/2023
JCP 0.167099 11/09/2023 12/09/2023 29/09/2023
Dividendo 0.071861 21/08/2023 22/08/2023 30/08/2023
JCP 0.327328 21/08/2023 22/08/2023 30/08/2023
Dividendo 0.001562 21/08/2023 22/08/2023 30/08/2023
Dividendo 0.007114 21/08/2023 22/08/2023 30/08/2023
JCP 0.169316 12/06/2023 13/06/2023 30/06/2023
JCP 0.327210 01/06/2023 02/06/2023 12/06/2023
Dividendo 0.061504 01/06/2023 02/06/2023 12/06/2023
JCP 0.176018 13/03/2023 14/03/2023 31/03/2023
Dividendo 0.117746 23/02/2023 24/02/2023 03/03/2023
JCP 0.286766 23/02/2023 24/02/2023 03/03/2023
Dividendo 0.006330 23/02/2023 24/02/2023 03/03/2023
Dividendo 0.002599 23/02/2023 24/02/2023 03/03/2023
JCP 0.172763 12/12/2022 13/12/2022 29/12/2022
Dividendo 0.085103 21/11/2022 22/11/2022 30/11/2022
JCP 0.317239 21/11/2022 22/11/2022 30/11/2022
JCP 0.136868 12/09/2022 13/09/2022 30/09/2022
Dividendo 0.100095 22/08/2022 23/08/2022 31/08/2022
Dividendo 0.006319 22/08/2022 23/08/2022 31/08/2022
JCP 0.285339 22/08/2022 23/08/2022 31/08/2022
Dividendo 0.002217 22/08/2022 23/08/2022 31/08/2022
JCP 0.125142 13/06/2022 14/06/2022 30/06/2022
Dividendo 0.077674 23/05/2022 24/05/2022 31/05/2022
JCP 0.258862 23/05/2022 24/05/2022 31/05/2022
JCP 0.105314 14/03/2022 15/03/2022 31/03/2022
Dividendo 0.177911 02/03/2022 03/03/2022 11/03/2022
Dividendo 0.004119 02/03/2022 03/03/2022 11/03/2022
JCP 0.227103 02/03/2022 03/03/2022 11/03/2022
Dividendo 0.003227 02/03/2022 03/03/2022 11/03/2022
JCP 0.087496 13/12/2021 14/12/2021 30/12/2021
JCP 0.196852 22/11/2021 23/11/2021 30/11/2021
JCP 0.092370 13/09/2021 14/09/2021 30/09/2021
JCP 0.172794 23/08/2021 24/08/2021 31/08/2021
Dividendo 0.001350 23/08/2021 24/08/2021 31/08/2021
JCP 0.084260 11/06/2021 14/06/2021 30/06/2021
Dividendo 0.037167 21/05/2021 24/05/2021 28/05/2021
JCP 0.170056 21/05/2021 24/05/2021 28/05/2021
JCP 0.072857 11/03/2021 12/03/2021 31/03/2021
Dividendo 0.000666 22/02/2021 23/02/2021 03/03/2021
JCP 0.217265 22/02/2021 23/02/2021 03/03/2021
JCP 0.058492 11/12/2020 14/12/2020 30/12/2020
JCP 0.097387 16/11/2020 17/11/2020 27/11/2020
JCP 0.051431 11/09/2020 14/09/2020 30/09/2020
Dividendo 0.000784 21/08/2020 24/08/2020 31/08/2020
JCP 0.220310 21/08/2020 24/08/2020 31/08/2020
JCP 0.090710 11/03/2020 12/03/2020 31/03/2020
JCP 0.219441 21/02/2020 26/02/2020 05/03/2020
JCP 0.088087 11/12/2019 12/12/2019 30/12/2019
JCP 0.182521 21/11/2019 22/11/2019 29/11/2019
JCP 0.116478 11/09/2019 12/09/2019 30/09/2019
JCP 0.223078 21/08/2019 22/08/2019 30/08/2019
JCP 0.085527 11/06/2019 12/06/2019 28/06/2019
JCP 0.207420 21/05/2019 22/05/2019 31/05/2019
JCP 0.078062 11/03/2019 12/03/2019 29/03/2019
Dividendo 0.003260 21/02/2019 22/02/2019 07/03/2019
JCP 0.292684 21/02/2019 22/02/2019 07/03/2019

dados do link 2

d1 pago d2 tipo
02/06/2025 0.0904 12/06/2025 JCP
02/06/2025 0.3343 12/06/2025 JCP
11/03/2025 0.1494 21/03/2025 JCP
11/03/2025 0.3426 20/03/2025 JCP
11/03/2025 0.1360 20/03/2025 DIV
11/12/2024 0.1765 27/12/2024 JCP
25/11/2024 0.4833 06/12/2024 JCP
11/09/2024 0.1866 27/09/2024 JCP
21/08/2024 0.3201 30/08/2024 JCP
21/08/2024 0.1546 30/08/2024 DIV
13/06/2024 0.2042 28/06/2024 JCP
11/06/2024 0.2932 21/06/2024 JCP
11/06/2024 0.1648 21/06/2024 DIV
11/03/2024 0.2050 27/03/2024 JCP
21/02/2024 0.3123 29/02/2024 JCP
21/02/2024 0.1124 29/02/2024 DIV
11/12/2023 0.1712 28/12/2023 JCP
21/11/2023 0.3431 30/11/2023 JCP
21/11/2023 0.0510 30/11/2023 DIV
11/09/2023 0.1671 29/09/2023 JCP
21/08/2023 0.3333 30/08/2023 JCP
21/08/2023 0.0732 30/08/2023 DIV
12/06/2023 0.1693 30/06/2023 JCP
01/06/2023 0.3272 12/06/2023 JCP
01/06/2023 0.0615 12/06/2023 DIV
13/03/2023 0.1760 31/03/2023 JCP
23/02/2023 0.2931 03/03/2023 JCP
23/02/2023 0.1203 03/03/2023 DIV
13/12/2022 0.1728 29/12/2022 JCP
21/11/2022 0.3172 30/11/2022 JCP
21/11/2022 0.0851 30/11/2022 DIV
12/09/2022 0.1369 30/09/2022 JCP
22/08/2022 0.2917 31/08/2022 JCP
22/08/2022 0.1023 31/08/2022 DIV
13/06/2022 0.1251 30/06/2022 JCP
23/05/2022 0.2589 31/05/2022 JCP
23/05/2022 0.0777 31/05/2022 DIV
14/03/2022 0.1053 31/03/2022 JCP
02/03/2022 0.1811 11/03/2022 DIV
02/03/2022 0.2312 11/03/2022 JCP
13/12/2021 0.0875 30/12/2021 JCP
22/11/2021 0.1969 30/11/2021 JCP
13/09/2021 0.0924 30/09/2021 JCP
23/08/2021 0.1741 31/08/2021 JCP
11/06/2021 0.0843 30/06/2021 JCP
21/05/2021 0.1701 28/05/2021 JCP
21/05/2021 0.0372 28/05/2021 DIV
11/03/2021 0.0729 31/03/2021 JCP
22/02/2021 0.2179 03/03/2021 JCP
11/12/2020 0.0585 30/12/2020 JCP
16/11/2020 0.0974 27/11/2020 JCP
11/09/2020 0.0514 30/09/2020 JCP
21/08/2020 0.2211 31/08/2020 JCP
11/03/2020 0.0907 31/03/2020 JCP
21/02/2020 0.2194 05/03/2020 JCP
11/12/2019 0.0881 30/12/2019 JCP
21/11/2019 0.1825 29/11/2019 JCP
11/09/2019 0.1165 30/09/2019 JCP
21/08/2019 0.2231 30/08/2019 JCP
11/06/2019 0.0855 28/06/2019 JCP

dados do link 3

Para os dados do Yahoo tive que compiar o HTML da tabela (Chrome Dev Extension), limpar com o `tidy` e converter para org usando `pandoc`.

date dividend
Jun 3, 2025 0.090447
Dec 12, 2024 0.176491
Nov 26, 2024 0.483304
Sep 12, 2024 0.186602
Aug 22, 2024 0.474655
Jun 14, 2024 0.20424
Jun 12, 2024 0.457947
Mar 12, 2024 0.205018
Dec 12, 2023 0.171153
Sep 12, 2023 0.167099
Aug 22, 2023 0.073423
Jun 13, 2023 0.169316
Jun 2, 2023 0.32721
Mar 14, 2023 0.176018
Feb 24, 2023 0.413441
Dec 13, 2022 0.172763
Nov 22, 2022 0.085103
Sep 13, 2022 0.136868
Aug 23, 2022 0.291658
Jun 14, 2022 0.125143
May 24, 2022 0.077674
Mar 15, 2022 0.105314
Mar 3, 2022 0.412361
Dec 14, 2021 0.087496
Nov 23, 2021 0.196852
Sep 14, 2021 0.09237
Aug 24, 2021 0.174144
Jun 14, 2021 0.08426
May 24, 2021 0.207223
Mar 12, 2021 0.072857
Feb 23, 2021 0.217932
Dec 14, 2020 0.058492
Nov 17, 2020 0.097387
Sep 14, 2020 0.051431
Aug 24, 2020 0.220994
Mar 12, 2020 0.09071
Feb 26, 2020 0.219441
Dec 12, 2019 0.088087
Nov 22, 2019 0.182521
Sep 12, 2019 0.116478
Aug 22, 2019 0.223078
Jun 12, 2019 0.085527
May 22, 2019 0.207419
Mar 12, 2019 0.078062
Feb 22, 2019 0.295944
Dec 12, 2018 0.062835
Nov 22, 2018 0.208447
Sep 12, 2018 0.042746
Jun 12, 2018 0.038602
Mar 13, 2018 0.040855
Mar 2, 2018 0.122835
Dec 12, 2017 0.041299
Nov 22, 2017 0.111619
Sep 12, 2017 0.038146
Aug 22, 2017 0.102152
Jun 13, 2017 0.039287
May 23, 2017 0.09147
Mar 14, 2017 0.036058
Mar 2, 2017 0.012954
Dec 13, 2016 0.038466
Nov 22, 2016 0.054936
Sep 13, 2016 0.063326
Aug 23, 2016 0.069983
Jun 14, 2016 0.068878
May 24, 2016 0.066842
Mar 14, 2016 0.049143
Mar 3, 2016 0.045284
Dec 14, 2015 0.137246
Nov 24, 2015 0.085403
Sep 14, 2015 0.133039
Aug 24, 2015 0.07052
Jun 12, 2015 0.144947
May 22, 2015 0.225569
Mar 24, 2015 0.188496
Feb 20, 2015 0.0456
Dec 12, 2014 0.169975
Nov 17, 2014 0.027859
Sep 12, 2014 0.168261
Aug 20, 2014 0.03939
Jun 13, 2014 0.160521
May 20, 2014 0.040609
Mar 12, 2014 0.157319
Feb 14, 2014 0.066078
Dec 12, 2013 0.154643
Nov 22, 2013 0.033308
Sep 12, 2013 0.156886
Aug 23, 2013 0.390436
Jun 12, 2013 0.140991
May 22, 2013 0.049105
Mar 12, 2013 0.132464
Mar 4, 2013 0.13066
Dec 13, 2012 0.148589
Nov 19, 2012 0.053466
Sep 12, 2012 0.142911
Aug 22, 2012 0.062033
Jun 22, 2012 0.14912
May 11, 2012 0.031655
Mar 23, 2012 0.14664
Feb 22, 2012 0.078498
Dec 22, 2011 0.140221
Nov 18, 2011 0.062943
Sep 22, 2011 0.139091
Aug 19, 2011 0.106038
May 20, 2011 0.078481
Feb 22, 2011 0.16309
Nov 23, 2010 0.065712
Sep 23, 2010 0.100122
Aug 19, 2010 0.100325
May 25, 2010 0.103933
May 24, 2010 0.086456
Feb 26, 2010 0.234099
Dec 22, 2009 0.094522
Nov 13, 2009 0.061449
Sep 22, 2009 0.092699
Aug 14, 2009 0.095437
Jun 23, 2009 0.090111
May 15, 2008 0.112108

dados do link 4

data valor tipo datapagamento
02/06/2025 0.3343 JRS CAP PROPRIO 12/06/2025
02/06/2025 0.0904 JRS CAP PROPRIO 12/06/2025
11/03/2025 0.3426 JRS CAP PROPRIO 20/03/2025
11/03/2025 0.1494 JRS CAP PROPRIO 21/03/2025
11/03/2025 0.1360 DIVIDENDO 20/03/2025
11/12/2024 0.1765 JRS CAP PROPRIO 27/12/2024
25/11/2024 0.4833 JRS CAP PROPRIO 06/12/2024
11/09/2024 0.1866 JRS CAP PROPRIO 27/09/2024
21/08/2024 0.3145 JRS CAP PROPRIO 30/08/2024
21/08/2024 0.1519 DIVIDENDO 30/08/2024
13/06/2024 0.2042 JRS CAP PROPRIO 28/06/2024
11/06/2024 0.2932 JRS CAP PROPRIO 21/06/2024
11/06/2024 0.1648 DIVIDENDO 21/06/2024
11/03/2024 0.4100 JRS CAP PROPRIO 27/03/2024
21/02/2024 0.6136 JRS CAP PROPRIO 29/02/2024
21/02/2024 0.2208 DIVIDENDO 29/02/2024
11/12/2023 0.3423 JRS CAP PROPRIO 28/12/2023
21/11/2023 0.6862 JRS CAP PROPRIO 30/11/2023
21/11/2023 0.1020 DIVIDENDO 30/11/2023
11/09/2023 0.3342 JRS CAP PROPRIO 29/09/2023
21/08/2023 0.6547 JRS CAP PROPRIO 30/08/2023
21/08/2023 0.1437 DIVIDENDO 30/08/2023
12/06/2023 0.3386 JRS CAP PROPRIO 30/06/2023
01/06/2023 0.6544 JRS CAP PROPRIO 12/06/2023
01/06/2023 0.1230 DIVIDENDO 12/06/2023
13/03/2023 0.3520 JRS CAP PROPRIO 31/03/2023
23/02/2023 0.5735 JRS CAP PROPRIO 03/03/2023
23/02/2023 0.2355 DIVIDENDO 03/03/2023
12/12/2022 0.3455 JRS CAP PROPRIO 29/12/2022
21/11/2022 0.6345 JRS CAP PROPRIO 30/11/2022
21/11/2022 0.1702 DIVIDENDO 30/11/2022
12/09/2022 0.2737 JRS CAP PROPRIO 30/09/2022
22/08/2022 0.5707 JRS CAP PROPRIO 31/08/2022
22/08/2022 0.2002 DIVIDENDO 31/08/2022
13/06/2022 0.2503 JRS CAP PROPRIO 30/06/2022
23/05/2022 0.5177 JRS CAP PROPRIO 31/05/2022
23/05/2022 0.1553 DIVIDENDO 31/05/2022
14/03/2022 0.2106 JRS CAP PROPRIO 31/03/2022
02/03/2022 0.4542 JRS CAP PROPRIO 11/03/2022
02/03/2022 0.3558 DIVIDENDO 11/03/2022
13/12/2021 0.1750 JRS CAP PROPRIO 30/12/2021
22/11/2021 0.3937 JRS CAP PROPRIO 30/11/2021
13/09/2021 0.1847 JRS CAP PROPRIO 30/09/2021
23/08/2021 0.3456 JRS CAP PROPRIO 31/08/2021
11/06/2021 0.1685 JRS CAP PROPRIO 30/06/2021
21/05/2021 0.3401 JRS CAP PROPRIO 28/05/2021
21/05/2021 0.0743 DIVIDENDO 28/05/2021
11/03/2021 0.1457 JRS CAP PROPRIO 31/03/2021
22/02/2021 0.4345 JRS CAP PROPRIO 03/03/2021
11/12/2020 0.1170 JRS CAP PROPRIO 30/12/2020
16/11/2020 0.1948 JRS CAP PROPRIO 27/11/2020
11/09/2020 0.1029 JRS CAP PROPRIO 30/09/2020
21/08/2020 0.4406 JRS CAP PROPRIO 31/08/2020
11/03/2020 0.1814 JRS CAP PROPRIO 31/03/2020
21/02/2020 0.4357 JRS CAP PROPRIO 05/03/2020
11/12/2019 0.1762 JRS CAP PROPRIO 30/12/2019
21/11/2019 0.3650 JRS CAP PROPRIO 29/11/2019
11/09/2019 0.2330 JRS CAP PROPRIO 30/09/2019
21/08/2019 0.4414 JRS CAP PROPRIO 30/08/2019
11/06/2019 0.1711 JRS CAP PROPRIO 28/06/2019
21/05/2019 0.4148 JRS CAP PROPRIO 31/05/2019
11/03/2019 0.1561 JRS CAP PROPRIO 29/03/2019
21/02/2019 0.5854 JRS CAP PROPRIO 07/03/2019

analisando dados para calcular preço justo

Fonte da formula: https://varos.com.br/blog/artigo/metodo-bazin-calcule-o-preco-justo-de-acoes

usando dados link 1

temp <- as.Date(data$pagamento, format = "%d/%m/%Y")
data$ano <- format(temp, "%Y")
data <- subset(data, tipo == "Dividendo")
resumo <- aggregate(valor ~ ano, data = data, sum)
resumo
dano <- mean(resumo$valor)
pj <- dano / (6/100)
dano
pj
   ano    valor
1 2019 0.003260
2 2020 0.000784
3 2021 0.039183
4 2022 0.456665
5 2023 0.319710
6 2024 0.442781
7 2025 0.148478
[1] 0.2015516
[1] 3.359193

usando dados link 2

temp <- as.Date(data$d1, format = "%d/%m/%Y")
data$ano <- format(temp, "%Y")
data <- subset(data, tipo == "DIV")
resumo <- aggregate(pago ~ ano, data = data, sum)
resumo
dano <- mean(resumo$pago)
pj <- dano / (6/100)
dano
pj
:    ano   pago
: 1 2021 0.0372
: 2 2022 0.4462
: 3 2023 0.3060
: 4 2024 0.4318
: 5 2025 0.1360
[1] 0.27144
[1] 4.524

usando dados link 3

temp <- as.Date(data$date, format = "%b %d, %Y")
data$ano <- format(temp, "%Y")
data <- subset(data, ano >= 2019)
resumo <- aggregate(dividend ~ ano, data = data, sum)
resumo
dano <- mean(resumo$dividend)
pj <- dano / (6/100)
dano
pj
   ano dividend
1 2019 1.277116
2 2020 0.738455
3 2021 1.133134
4 2022 1.406884
5 2023 1.497660
6 2024 2.188257
7 2025 0.090447
[1] 1.190279
[1] 19.83798

usando dados link 4

temp <- as.Date(data$data, format = "%d/%m/%Y")
data$ano <- format(temp, "%Y")
data <- subset(data, tipo == "DIVIDENDO")
resumo <- aggregate(valor ~ ano, data = data, sum)
resumo
dano <- mean(resumo$valor)
pj <- dano / (6/100)
dano
pj
:    ano  valor
: 1 2021 0.0743
: 2 2022 0.8815
: 3 2023 0.6042
: 4 2024 0.5375
: 5 2025 0.1360
: [1] 0.4467
: [1] 7.445

observação

Fixado um valor médio anual, a conta do preço justo corresponde ao que consigo em https://www.calculadoradoinvestidor.com.br/app/preco-teto-bazin embora eu não confie nestes sites com anúncios.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment