Skip to content

Instantly share code, notes, and snippets.

@arademaker

arademaker/report.org

Last active July 11, 2025 15:49
Show Gist options
  • Save arademaker/f28d975e5b6e5e2826aff9552644a0ec to your computer and use it in GitHub Desktop.
Save arademaker/f28d975e5b6e5e2826aff9552644a0ec to your computer and use it in GitHub Desktop.
Download ZIP
preço justo ação BB comparando diferentes fontes de dados para usar Método Bazin
Raw
report.org

Análise BBAS3

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

tipovalorregistroexpagamento
JCP0.09044702/06/202503/06/202512/06/2025
JCP0.33425802/06/202503/06/202512/06/2025
Dividendo0.00354511/03/202512/03/202520/03/2025
Dividendo0.00893111/03/202512/03/202520/03/2025
JCP0.14935111/03/202512/03/202521/03/2025
JCP0.34259211/03/202512/03/202520/03/2025
Dividendo0.13600211/03/202512/03/202520/03/2025
JCP0.17649011/12/202412/12/202427/12/2024
JCP0.48330025/11/202426/11/202406/12/2024
JCP0.18660211/09/202412/09/202427/09/2024
JCP0.31448121/08/202422/08/202430/08/2024
Dividendo0.00270721/08/202422/08/202430/08/2024
Dividendo0.15186121/08/202422/08/202430/08/2024
Dividendo0.00560621/08/202422/08/202430/08/2024
JCP0.20424013/06/202414/06/202428/06/2024
JCP0.29316111/06/202412/06/202421/06/2024
Dividendo0.16478611/06/202412/06/202421/06/2024
JCP0.20501811/03/202412/03/202427/03/2024
Dividendo0.11040921/02/202422/02/202429/02/2024
Dividendo0.00741221/02/202422/02/202429/02/2024
JCP0.30681821/02/202422/02/202429/02/2024
JCP0.17115311/12/202312/12/202328/12/2023
JCP0.34311121/11/202322/11/202330/11/2023
Dividendo0.05099421/11/202322/11/202330/11/2023
JCP0.16709911/09/202312/09/202329/09/2023
Dividendo0.07186121/08/202322/08/202330/08/2023
JCP0.32732821/08/202322/08/202330/08/2023
Dividendo0.00156221/08/202322/08/202330/08/2023
Dividendo0.00711421/08/202322/08/202330/08/2023
JCP0.16931612/06/202313/06/202330/06/2023
JCP0.32721001/06/202302/06/202312/06/2023
Dividendo0.06150401/06/202302/06/202312/06/2023
JCP0.17601813/03/202314/03/202331/03/2023
Dividendo0.11774623/02/202324/02/202303/03/2023
JCP0.28676623/02/202324/02/202303/03/2023
Dividendo0.00633023/02/202324/02/202303/03/2023
Dividendo0.00259923/02/202324/02/202303/03/2023
JCP0.17276312/12/202213/12/202229/12/2022
Dividendo0.08510321/11/202222/11/202230/11/2022
JCP0.31723921/11/202222/11/202230/11/2022
JCP0.13686812/09/202213/09/202230/09/2022
Dividendo0.10009522/08/202223/08/202231/08/2022
Dividendo0.00631922/08/202223/08/202231/08/2022
JCP0.28533922/08/202223/08/202231/08/2022
Dividendo0.00221722/08/202223/08/202231/08/2022
JCP0.12514213/06/202214/06/202230/06/2022
Dividendo0.07767423/05/202224/05/202231/05/2022
JCP0.25886223/05/202224/05/202231/05/2022
JCP0.10531414/03/202215/03/202231/03/2022
Dividendo0.17791102/03/202203/03/202211/03/2022
Dividendo0.00411902/03/202203/03/202211/03/2022
JCP0.22710302/03/202203/03/202211/03/2022
Dividendo0.00322702/03/202203/03/202211/03/2022
JCP0.08749613/12/202114/12/202130/12/2021
JCP0.19685222/11/202123/11/202130/11/2021
JCP0.09237013/09/202114/09/202130/09/2021
JCP0.17279423/08/202124/08/202131/08/2021
Dividendo0.00135023/08/202124/08/202131/08/2021
JCP0.08426011/06/202114/06/202130/06/2021
Dividendo0.03716721/05/202124/05/202128/05/2021
JCP0.17005621/05/202124/05/202128/05/2021
JCP0.07285711/03/202112/03/202131/03/2021
Dividendo0.00066622/02/202123/02/202103/03/2021
JCP0.21726522/02/202123/02/202103/03/2021
JCP0.05849211/12/202014/12/202030/12/2020
JCP0.09738716/11/202017/11/202027/11/2020
JCP0.05143111/09/202014/09/202030/09/2020
Dividendo0.00078421/08/202024/08/202031/08/2020
JCP0.22031021/08/202024/08/202031/08/2020
JCP0.09071011/03/202012/03/202031/03/2020
JCP0.21944121/02/202026/02/202005/03/2020
JCP0.08808711/12/201912/12/201930/12/2019
JCP0.18252121/11/201922/11/201929/11/2019
JCP0.11647811/09/201912/09/201930/09/2019
JCP0.22307821/08/201922/08/201930/08/2019
JCP0.08552711/06/201912/06/201928/06/2019
JCP0.20742021/05/201922/05/201931/05/2019
JCP0.07806211/03/201912/03/201929/03/2019
Dividendo0.00326021/02/201922/02/201907/03/2019
JCP0.29268421/02/201922/02/201907/03/2019

dados do link 2

d1pagod2tipo
02/06/20250.090412/06/2025JCP
02/06/20250.334312/06/2025JCP
11/03/20250.149421/03/2025JCP
11/03/20250.342620/03/2025JCP
11/03/20250.136020/03/2025DIV
11/12/20240.176527/12/2024JCP
25/11/20240.483306/12/2024JCP
11/09/20240.186627/09/2024JCP
21/08/20240.320130/08/2024JCP
21/08/20240.154630/08/2024DIV
13/06/20240.204228/06/2024JCP
11/06/20240.293221/06/2024JCP
11/06/20240.164821/06/2024DIV
11/03/20240.205027/03/2024JCP
21/02/20240.312329/02/2024JCP
21/02/20240.112429/02/2024DIV
11/12/20230.171228/12/2023JCP
21/11/20230.343130/11/2023JCP
21/11/20230.051030/11/2023DIV
11/09/20230.167129/09/2023JCP
21/08/20230.333330/08/2023JCP
21/08/20230.073230/08/2023DIV
12/06/20230.169330/06/2023JCP
01/06/20230.327212/06/2023JCP
01/06/20230.061512/06/2023DIV
13/03/20230.176031/03/2023JCP
23/02/20230.293103/03/2023JCP
23/02/20230.120303/03/2023DIV
13/12/20220.172829/12/2022JCP
21/11/20220.317230/11/2022JCP
21/11/20220.085130/11/2022DIV
12/09/20220.136930/09/2022JCP
22/08/20220.291731/08/2022JCP
22/08/20220.102331/08/2022DIV
13/06/20220.125130/06/2022JCP
23/05/20220.258931/05/2022JCP
23/05/20220.077731/05/2022DIV
14/03/20220.105331/03/2022JCP
02/03/20220.181111/03/2022DIV
02/03/20220.231211/03/2022JCP
13/12/20210.087530/12/2021JCP
22/11/20210.196930/11/2021JCP
13/09/20210.092430/09/2021JCP
23/08/20210.174131/08/2021JCP
11/06/20210.084330/06/2021JCP
21/05/20210.170128/05/2021JCP
21/05/20210.037228/05/2021DIV
11/03/20210.072931/03/2021JCP
22/02/20210.217903/03/2021JCP
11/12/20200.058530/12/2020JCP
16/11/20200.097427/11/2020JCP
11/09/20200.051430/09/2020JCP
21/08/20200.221131/08/2020JCP
11/03/20200.090731/03/2020JCP
21/02/20200.219405/03/2020JCP
11/12/20190.088130/12/2019JCP
21/11/20190.182529/11/2019JCP
11/09/20190.116530/09/2019JCP
21/08/20190.223130/08/2019JCP
11/06/20190.085528/06/2019JCP

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`.

datedividend
Jun 3, 20250.090447
Dec 12, 20240.176491
Nov 26, 20240.483304
Sep 12, 20240.186602
Aug 22, 20240.474655
Jun 14, 20240.20424
Jun 12, 20240.457947
Mar 12, 20240.205018
Dec 12, 20230.171153
Sep 12, 20230.167099
Aug 22, 20230.073423
Jun 13, 20230.169316
Jun 2, 20230.32721
Mar 14, 20230.176018
Feb 24, 20230.413441
Dec 13, 20220.172763
Nov 22, 20220.085103
Sep 13, 20220.136868
Aug 23, 20220.291658
Jun 14, 20220.125143
May 24, 20220.077674
Mar 15, 20220.105314
Mar 3, 20220.412361
Dec 14, 20210.087496
Nov 23, 20210.196852
Sep 14, 20210.09237
Aug 24, 20210.174144
Jun 14, 20210.08426
May 24, 20210.207223
Mar 12, 20210.072857
Feb 23, 20210.217932
Dec 14, 20200.058492
Nov 17, 20200.097387
Sep 14, 20200.051431
Aug 24, 20200.220994
Mar 12, 20200.09071
Feb 26, 20200.219441
Dec 12, 20190.088087
Nov 22, 20190.182521
Sep 12, 20190.116478
Aug 22, 20190.223078
Jun 12, 20190.085527
May 22, 20190.207419
Mar 12, 20190.078062
Feb 22, 20190.295944
Dec 12, 20180.062835
Nov 22, 20180.208447
Sep 12, 20180.042746
Jun 12, 20180.038602
Mar 13, 20180.040855
Mar 2, 20180.122835
Dec 12, 20170.041299
Nov 22, 20170.111619
Sep 12, 20170.038146
Aug 22, 20170.102152
Jun 13, 20170.039287
May 23, 20170.09147
Mar 14, 20170.036058
Mar 2, 20170.012954
Dec 13, 20160.038466
Nov 22, 20160.054936
Sep 13, 20160.063326
Aug 23, 20160.069983
Jun 14, 20160.068878
May 24, 20160.066842
Mar 14, 20160.049143
Mar 3, 20160.045284
Dec 14, 20150.137246
Nov 24, 20150.085403
Sep 14, 20150.133039
Aug 24, 20150.07052
Jun 12, 20150.144947
May 22, 20150.225569
Mar 24, 20150.188496
Feb 20, 20150.0456
Dec 12, 20140.169975
Nov 17, 20140.027859
Sep 12, 20140.168261
Aug 20, 20140.03939
Jun 13, 20140.160521
May 20, 20140.040609
Mar 12, 20140.157319
Feb 14, 20140.066078
Dec 12, 20130.154643
Nov 22, 20130.033308
Sep 12, 20130.156886
Aug 23, 20130.390436
Jun 12, 20130.140991
May 22, 20130.049105
Mar 12, 20130.132464
Mar 4, 20130.13066
Dec 13, 20120.148589
Nov 19, 20120.053466
Sep 12, 20120.142911
Aug 22, 20120.062033
Jun 22, 20120.14912
May 11, 20120.031655
Mar 23, 20120.14664
Feb 22, 20120.078498
Dec 22, 20110.140221
Nov 18, 20110.062943
Sep 22, 20110.139091
Aug 19, 20110.106038
May 20, 20110.078481
Feb 22, 20110.16309
Nov 23, 20100.065712
Sep 23, 20100.100122
Aug 19, 20100.100325
May 25, 20100.103933
May 24, 20100.086456
Feb 26, 20100.234099
Dec 22, 20090.094522
Nov 13, 20090.061449
Sep 22, 20090.092699
Aug 14, 20090.095437
Jun 23, 20090.090111
May 15, 20080.112108

dados do link 4

datavalortipodata_pagamento
02/06/20250.3343JRS CAP PROPRIO12/06/2025
02/06/20250.0904JRS CAP PROPRIO12/06/2025
11/03/20250.3426JRS CAP PROPRIO20/03/2025
11/03/20250.1494JRS CAP PROPRIO21/03/2025
11/03/20250.1360DIVIDENDO20/03/2025
11/12/20240.1765JRS CAP PROPRIO27/12/2024
25/11/20240.4833JRS CAP PROPRIO06/12/2024
11/09/20240.1866JRS CAP PROPRIO27/09/2024
21/08/20240.3145JRS CAP PROPRIO30/08/2024
21/08/20240.1519DIVIDENDO30/08/2024
13/06/20240.2042JRS CAP PROPRIO28/06/2024
11/06/20240.2932JRS CAP PROPRIO21/06/2024
11/06/20240.1648DIVIDENDO21/06/2024
11/03/20240.4100JRS CAP PROPRIO27/03/2024
21/02/20240.6136JRS CAP PROPRIO29/02/2024
21/02/20240.2208DIVIDENDO29/02/2024
11/12/20230.3423JRS CAP PROPRIO28/12/2023
21/11/20230.6862JRS CAP PROPRIO30/11/2023
21/11/20230.1020DIVIDENDO30/11/2023
11/09/20230.3342JRS CAP PROPRIO29/09/2023
21/08/20230.6547JRS CAP PROPRIO30/08/2023
21/08/20230.1437DIVIDENDO30/08/2023
12/06/20230.3386JRS CAP PROPRIO30/06/2023
01/06/20230.6544JRS CAP PROPRIO12/06/2023
01/06/20230.1230DIVIDENDO12/06/2023
13/03/20230.3520JRS CAP PROPRIO31/03/2023
23/02/20230.5735JRS CAP PROPRIO03/03/2023
23/02/20230.2355DIVIDENDO03/03/2023
12/12/20220.3455JRS CAP PROPRIO29/12/2022
21/11/20220.6345JRS CAP PROPRIO30/11/2022
21/11/20220.1702DIVIDENDO30/11/2022
12/09/20220.2737JRS CAP PROPRIO30/09/2022
22/08/20220.5707JRS CAP PROPRIO31/08/2022
22/08/20220.2002DIVIDENDO31/08/2022
13/06/20220.2503JRS CAP PROPRIO30/06/2022
23/05/20220.5177JRS CAP PROPRIO31/05/2022
23/05/20220.1553DIVIDENDO31/05/2022
14/03/20220.2106JRS CAP PROPRIO31/03/2022
02/03/20220.4542JRS CAP PROPRIO11/03/2022
02/03/20220.3558DIVIDENDO11/03/2022
13/12/20210.1750JRS CAP PROPRIO30/12/2021
22/11/20210.3937JRS CAP PROPRIO30/11/2021
13/09/20210.1847JRS CAP PROPRIO30/09/2021
23/08/20210.3456JRS CAP PROPRIO31/08/2021
11/06/20210.1685JRS CAP PROPRIO30/06/2021
21/05/20210.3401JRS CAP PROPRIO28/05/2021
21/05/20210.0743DIVIDENDO28/05/2021
11/03/20210.1457JRS CAP PROPRIO31/03/2021
22/02/20210.4345JRS CAP PROPRIO03/03/2021
11/12/20200.1170JRS CAP PROPRIO30/12/2020
16/11/20200.1948JRS CAP PROPRIO27/11/2020
11/09/20200.1029JRS CAP PROPRIO30/09/2020
21/08/20200.4406JRS CAP PROPRIO31/08/2020
11/03/20200.1814JRS CAP PROPRIO31/03/2020
21/02/20200.4357JRS CAP PROPRIO05/03/2020
11/12/20190.1762JRS CAP PROPRIO30/12/2019
21/11/20190.3650JRS CAP PROPRIO29/11/2019
11/09/20190.2330JRS CAP PROPRIO30/09/2019
21/08/20190.4414JRS CAP PROPRIO30/08/2019
11/06/20190.1711JRS CAP PROPRIO28/06/2019
21/05/20190.4148JRS CAP PROPRIO31/05/2019
11/03/20190.1561JRS CAP PROPRIO29/03/2019
21/02/20190.5854JRS CAP PROPRIO07/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