Import BRVM prices into Excel, Google Sheets or Power BI
Two public CSV files, no account or key: the latest session of every share and the history of each share. Addresses, steps, refresh and formats.
Which addresses should I use?
For the latest session of every listed share: https://brvmdata.com/telechargements/actions-derniere-seance.csv. For one share's history: https://brvmdata.com/telechargements/actions/<symbol>.csv, replacing <symbol> with the lower-case BRVM symbol (https://brvmdata.com/telechargements/actions/snts.csv for Sonatel).
The first file has one row per share (48 in the bulletin of 19 November 2026), the second one row per session with a trade. The large quote tables on the Data page weigh several megabytes: no need to reload them to follow a few prices.
- Latest session, every share (CSV):
https://brvmdata.com/telechargements/actions-derniere-seance.csv - The same in JSON:
https://brvmdata.com/telechargements/actions-derniere-seance.json - One share's history (CSV):
https://brvmdata.com/telechargements/actions/<symbol>.csv
How do I import prices into Google Sheets?
In an empty cell, type =IMPORTDATA("https://brvmdata.com/telechargements/actions-derniere-seance.csv"): the sheet fills with the header, then one row per share.
For Sonatel's history, the formula is the second one below. If your sheet uses a decimal comma and numbers stay left-aligned as text, switch it to a decimal-point locale (File > Settings > Locale, for example United Kingdom).
=IMPORTDATA("https://brvmdata.com/telechargements/actions-derniere-seance.csv")
=IMPORTDATA("https://brvmdata.com/telechargements/actions/snts.csv")How do I import prices into Excel?
In Excel for Windows (Microsoft 365 or Excel 2016 and later), choose Data > From Web, paste the CSV file address and confirm: Power Query shows a preview, which you load into a sheet.
- Data > From Web.
- Choose Basic, paste the file address, then OK.
- On the first connection, choose Anonymous access, then Connect.
- In the preview, check the file origin (65001: Unicode UTF-8) and the delimiter (comma), then Load, or Transform Data to set the column types.
How do I import prices into Power BI?
In Power BI Desktop, choose Get Data > Web, paste the CSV file address, confirm, then Load.
- Home > Get Data > Web.
- Choose Basic, paste the file address, then OK; on the first connection, choose Anonymous.
- In the preview, Load, or Transform Data to set the column types with a locale (see below).
How do I keep the prices up to date?
Refresh the query: the files are regenerated at every data update, at most four times a day (after 07:30, 17:15, 19:45 and 22:45 UTC), at the same address.
Excel: Data > Refresh All; the query properties can also refresh when the file opens or every N minutes. Power BI Desktop: Home > Refresh. Google Sheets reloads IMPORTDATA by itself, at its own pace. Refreshing once an hour is more than enough.
Why are some numbers or dates not recognised?
The files use a decimal point, no thousands separator, ISO dates (YYYY-MM-DD) and UTF-8; software set to a decimal comma may read them as text.
In Power Query (Excel and Power BI), right-click the column header > Change Type > Using Locale, then choose the type (decimal number, date) and English (United States). An empty cell means a missing value, never zero.
What do the columns contain?
The latest session gives, per share, the close (close_xof), the day's change, volume, value traded, change since 1 January, P/E, net yield, last dividend and market capitalisation; the basis column says whether prices come from the official bulletin or a provisional session.
The history gives close_xof, the price as published, and adj_close_xof, adjusted for splits as on the charts, with volume, value and source (boc: official bulletin; bfin: session database; intraday: closing screen). The full dictionary is on the Latest session and Per-share history dataset pages.
Can I reuse this data, and how do I cite it?
Access is free, but this is not a redistribution licence: each source's terms are set out in the terms of use.
Cite the original source and brvmdata with the session date, for example: "BRVM, official bulletin of 19 November 2026; data formatted by brvmdata.com (https://brvmdata.com/telechargements/actions-derniere-seance.csv), accessed on <date>". A basis=provisional row is cited as provisional, before the official bulletin.
The guide · How the BRVM works · Buying shares on the BRVM · BRVM trading hours · Reading the Official Quotation Bulletin · Understanding BRVM dividends · WAEMU Treasury bills and bonds · P/E ratio and dividend yield · Understanding BRVM indices · Glossary · Import BRVM prices into Excel, Google Sheets or Power BI
Documentary content, not investment advice or a recommendation. Official sources checked on 15 November 2026.