Dados B3 › Spreadsheet
Dados B3 spreadsheet: fundamentals in Google Sheets with one formula
A Google spreadsheet with the =DADOSB3() function. You type the stock, REIT (FII) or ETF ticker and the field name. The cell brings the number from our database: ROE, P/E, dividend yield, next payout and more than 30 fields.
The price does not come from Dados B3: in the template it comes from Google itself, through the =GOOGLEFINANCE function. Nothing here is investment advice.
Start in 3 steps
- Open the spreadsheet template and click Make a copy. The copy is yours, in your Google account. If a yellow bar says some formulas are trying to send and receive data from third parties, click Allow access: that is what lets the spreadsheet show each asset logo.
- In the Dados B3 › Minha chave menu, paste your key. The free key takes a minute, no card: get a free key. The key is stored in the spreadsheet script, never in a cell.
- Use it. Type
=DADOSB3("PETR4", "roe")in a cell, or point to a whole column of tickers.
Examples
| Formula | What it returns |
|---|---|
=DADOSB3("PETR4", "roe") | ROE from the latest annual statement |
=DADOSB3(A2:A31, "dy_12m") | the whole column at once (a single request) |
=DADOSB3(A2:A31, B1:H1) | the whole table: tickers in rows, fields in the header |
=DADOSB3("WEGE3", "pl", "2019-06-30") | the P/E as known on 2019-06-30 |
=DADOSB3("SELIC") | today's Selic target (also IPCA, DOLAR, EURO...) |
=GOOGLEFINANCE("BVMF:PETR4") | the price, from Google |
In a Portuguese-language spreadsheet the separator is a semicolon (;).
Why it is different
- One column, one request. The function sends the whole column at once. A portfolio with 300 assets does not freeze.
- The key is not on display. It lives in the script, not in a cell someone can copy.
- A missing number says why. Instead of a blank cell: "FII não tem P/L" (a REIT has no P/E), "balanço ainda não saiu" (statement not out yet), "código não encontrado" (ticker not found).
- A past date. With a date, you get the statement that was already at the CVM on that day.
- The ticker the way you write it. petr4, PETR4.SA, BVMF:PETR4, PETR4F and old tickers are understood.
What comes ready in the template
- Capa (cover): portfolio value, change in the month, 12-month payouts, portfolio by sector and the payouts of the next 30 days.
- Carteira (portfolio): quantity, Google price, weight and each asset fundamentals.
- Dividendos (payouts): what your portfolio receives this month, with the payment date.
- Comparador (comparison): several assets side by side, on the same fields.
- Histórico 10 anos (10-year history): one asset's numbers in each year.
- Filtro de ações (stock filter): a list of stocks filtered by the criteria you choose. It is a filter example, not a recommendation.
The fields
Percentages come as fractions (0.25 = 25%): format the column as %. R$ amounts are gross, before tax.
Profile
| Field | What it is | Applies to | Takes a date |
|---|---|---|---|
nome | Name. Company or fund name. | Stock, REIT (FII), ETF | no |
tipo | Type. Stock, REIT (FII) or ETF. | Stock, REIT (FII), ETF | no |
setor | Sector. Stock sector; FII segment. | Stock, REIT (FII) | no |
cnpj | CNPJ. Company or fund tax ID (CNPJ). | Stock, REIT (FII), ETF | no |
pagina | Page. Address of the asset page on dadosb3.com. | Stock, REIT (FII), ETF | no |
logo | Logo. Address of the logo (64×64 PNG) on dadosb3.com: the company's, from the website it declares to CVM; for REITs (FIIs) and ETFs, the fund manager's, from the website it declares to CVM. Use with =IMAGE(). | Stock, REIT (FII), ETF | no |
link_cvm | CVM link. Link to the latest annual statement (DFP) on the CVM website. | Stock | yes |
indice | Index. Index the ETF tracks. | ETF | no |
gestor | Manager. ETF manager. | ETF | no |
Statements (latest year)
| Field | What it is | Applies to | Takes a date |
|---|---|---|---|
ano_balanco | Statement year. Fiscal year of the annual statement used below. | Stock | yes |
roe | ROE. Controlling net income ÷ equity. | Stock | yes |
roic | ROIC. Return on invested capital. | Stock | yes |
roa | ROA. Net income ÷ total assets. | Stock | yes |
margem_bruta | Gross margin. Gross profit ÷ revenue. | Stock | yes |
margem_ebit | EBIT margin. Operating result ÷ revenue. | Stock | yes |
margem_liquida | Net margin. Total net income ÷ revenue. | Stock | yes |
divida_liquida_ebitda | Net debt/EBITDA. Net debt ÷ EBITDA. | Stock | yes |
liquidez_corrente | Current ratio. Current assets ÷ current liabilities. | Stock | yes |
crescimento_receita | Revenue growth (1 year). Revenue of the year ÷ previous year − 1. | Stock | yes |
cagr_receita_5a | Revenue CAGR (5 years). Average yearly revenue growth over 5 years. | Stock | yes |
piotroski | Piotroski. Score from 0 to 9 on Piotroski's nine tests. | Stock | yes |
ebitda | EBITDA. EBITDA for the year, in R$. | Stock | yes |
divida_liquida | Net debt. Gross debt − cash, in R$. | Stock | yes |
Multiples
| Field | What it is | Applies to | Takes a date |
|---|---|---|---|
pl | P/E. Market value ÷ last 12 months earnings (the page's 12-month P/E card). | Stock | yes |
pvp | P/B. Stock: market value ÷ equity of the latest quarter. FII: price ÷ book value per unit. | Stock, REIT (FII) | yes |
ev_ebitda | EV/EBITDA. EV ÷ EBITDA, priced on the first session after the annual statement was filed. | Stock | yes |
fcf_yield | FCF yield. Free cash flow ÷ market value, on the same date as EV/EBITDA. | Stock | yes |
lpa | EPS. Earnings per share of the latest year. | Stock | no |
vpa | BVPS. Book value per share of the latest year. | Stock | no |
vp_cota | Book value per unit. Book value per unit in the latest report. | REIT (FII) | no |
Payouts
| Field | What it is | Applies to | Takes a date |
|---|---|---|---|
dy_12m | 12-month dividend yield. Last 12 months payouts ÷ price. | Stock, REIT (FII) | no |
proventos_12m | 12-month payouts (R$). Sum per share (or unit) over the last 12 months, gross. | Stock, REIT (FII) | no |
ultimo_provento | Latest payout (R$). R$ per share (or unit) of the latest record date, gross. | Stock, REIT (FII), ETF | yes |
ultima_data_com | Latest record date. Record date of the latest payout. | Stock, REIT (FII), ETF | yes |
proximo_provento | Next payout (R$). R$ per share (or unit) of the next announced payment, gross. | Stock, REIT (FII), ETF | yes |
proximo_pagamento | Next payment date. Date of the next announced payment. | Stock, REIT (FII), ETF | yes |
proxima_data_com | Record date of the next payment. Record date of the next announced payment. | Stock, REIT (FII), ETF | yes |
Economic indicators
Type the code instead of a ticker. The field is valor (the default) or data (the date of the value). Source: Central Bank and IBGE.
| Code | What it is |
|---|---|
SELIC | Selic target (Copom), a year |
SELIC_EFETIVA | Effective Selic, a year |
IPCA | IPCA, 12-month change |
IPCA_MES | IPCA, monthly change |
DOLAR | US dollar PTAX closing, ask |
DOLAR_COMPRA | US dollar PTAX closing, bid |
EURO | Euro PTAX closing, ask |
PIB | GDP, four-quarter change |
DESEMPREGO | Unemployment rate (PNAD) |
Limits
The spreadsheet uses your key's quota. Free: 200 calls a day, no card. Pro ($9.90/month): 10,000 calls a day.
Each request uses 1 call per 100 cells (ticker × field), at least 1. A 30-asset portfolio with 10 fields uses 3. The spreadsheet keeps each number for up to 6 hours and does not ask again in that time. Up to 300 tickers and 20 fields per request; larger ranges are split automatically.
Past dates
With a date (YYYY-MM-DD), the statement is the latest the CVM had received on that day, and the P/E and P/B use the price of the first session after filing. The figure is the version published today: if the company restated it later, the restated one applies. Dividend yield, EPS and BVPS only exist for today.
For developers
The function calls this API route, with your key:
curl -H "X-API-Key: SUA_CHAVE" "https://dadosb3.com/planilha/dados?codigos=PETR4,ITUB4,HGLG11&campo=roe,dy_12m"Numbers on this page are live. Data version 2026-11-03-delistadas-proventos-cvm · page generated 2026-11-03 23:34 UTC. If this does not match /saude, you are reading a cached copy.
Sources: CVM (open data, ODbL) and B3 (COTAHIST). Not affiliated with B3 or the CVM. Not investment advice.
Numbers on this page are live. Data version 2026-11-03-delistadas-proventos-cvm · page generated 2026-11-03 23:34 UTC. If this does not match /saude, you are reading a cached copy.