Bac Bo statistics site, dashboard or spreadsheet
From a no-code Google Sheet to a site with live results: how to pull Bac Bo data through the API, protect your key, use caching and pick a plan.
Published on October 18, 2026 · 4 min read
Bac Bo statistics sites attract a lot of traffic, especially from people searching for "live bac bo results" and "bac bo history", and they are a great business for affiliates. At the same time, plenty of people just want a Bac Bo spreadsheet to analyse at their own pace. In this guide we cover both paths with the Bac Bo Live API: first a Google Sheet that updates itself, with no server, and then a site with live results.
Path 1: a Google Sheets spreadsheet
Google Sheets has Apps Script, which runs JavaScript inside Google itself and can call an API with a header — something formulas like IMPORTDATA cannot do.
- Create a spreadsheet and rename the first tab to Bac Bo.
- Open Extensions > Apps Script and paste the code below.
- In Project settings > Script properties, create the property
LYNX_KEYwith your key. That way it is not visible to anyone who opens the spreadsheet. - Run the
updateBacBofunction once and authorise access. - In Triggers, create a time-based trigger to run the function every minute.
Code.gs
function updateBacBo() {
const key = PropertiesService.getScriptProperties().getProperty("LYNX_KEY");
const response = UrlFetchApp.fetch("https://api.lynxmetrics.com/v1/bacbo-live/results?limit=250", {
headers: { "x-api-key": key },
});
const rounds = JSON.parse(response.getContentText()).data;
const rows = rounds.map((r) => [
new Date(r.settledAt),
r.outcome,
r.data.player.dice.join("+"),
r.data.player.score,
r.data.banker.dice.join("+"),
r.data.banker.score,
r.data.multiplier || "",
]);
const tab = SpreadsheetApp.getActive().getSheetByName("Bac Bo");
tab.clearContents();
tab.getRange(1, 1, 1, 7).setValues([["End", "Outcome", "Player dice", "Player total", "Banker dice", "Banker total", "Tie"]]);
tab.getRange(2, 1, rows.length, 7).setValues(rows);
}With the rounds in the tab, the rest is ordinary formulas. For example, =COUNTIF(B:B,"tie")/COUNTA(B2:B) gives the tie percentage over the last 250 rounds, and a column chart over column G shows the multipliers. The date column appears in the spreadsheet's time zone, which you set in File > Settings.
To keep more than 250 rounds, replace clearContents with logic that only appends new ones, using the after parameter with the last row's id, as explained in Bac Bo history.
Path 2: a site with live results
Rule number one: the key stays on the server
Never put the API key in JavaScript that runs in the browser. Any visitor could open the developer tools, copy the key and use your limit. The right way is for the browser to talk to your server, and your server to talk to the API. The article on API security has more detail.
The server, with caching
A thousand visitors looking at the page should not become a thousand requests to the API. A few seconds of caching solves it: the server fetches the rounds at most once every 3 seconds and serves the same response to everyone.
server.mjs
import http from "node:http";
const API = "https://api.lynxmetrics.com/v1/bacbo-live";
let cache = { at: 0, body: "{}" };
async function rounds() {
if (Date.now() - cache.at > 3000) {
const response = await fetch(API + "/results?limit=100", { headers: { "x-api-key": process.env.LYNX_KEY } });
if (response.ok) cache = { at: Date.now(), body: await response.text() };
}
return cache.body;
}
http
.createServer(async (request, response) => {
if (request.url === "/bacbo.json") {
response.writeHead(200, { "Content-Type": "application/json" });
response.end(await rounds());
return;
}
response.writeHead(404);
response.end();
})
.listen(3000);With that, the server makes at most 20 requests a minute, no matter how many people are on the site. If you use Next.js, PHP or another framework, the idea is the same: one route on your server with a short cache. For a site that needs each round the instant it is stored, the server can hold the stream open instead, as explained in Bac Bo results in real time.
The page
In the browser, the page fetches /bacbo.json every 5 seconds and redraws the list:
async function update() {
const { data } = await (await fetch("/bacbo.json")).json();
document.querySelector("#rounds").innerHTML = data
.slice(0, 20)
.map((r) => "<li>" + r.outcome + " " + r.data.player.score + " x " + r.data.banker.score + "</li>")
.join("");
}
update();
setInterval(update, 5000);For the bead charts, use the code in Bead Road and Big Road. For the percentages, call /stats the same way, also cached.
Which plan to choose
| Use | Recommended plan | Why |
|---|---|---|
| A personal spreadsheet | Pro, R$ 21.90 a month | One request a minute and 7 days of history are enough |
| A small site with caching | Pro | 20 requests a minute sits well below the limit of 60 |
| A site with long history and period filters | Business, R$ 49.90 a month | Full history, up to 1,000 rounds per request and 400 requests a minute |
| Several sites or clients | One project per site | Each project has its own keys and its own limit |
Ideas to make your site stand out
- Show the whole day's history, not just the last few rounds. It is what people look for and almost nobody has.
- Publish records: longest streak, longest stretch without a tie, how many 88x in the week.
- Explain the rules and the odds, with links to the articles on how Bac Bo works and odds and RTP.
- Make clear it is a data site, for over-18s, and that the history does not predict the next round.
Frequently asked questions
- Can I pull Bac Bo results into Excel or Google Sheets?
Yes. In Google Sheets, a short Apps Script calls the API with your key and fills the spreadsheet every minute. In Excel, Power Query also accepts a header on the query, or you import a CSV generated from the API.
- Can I put the API key in my site's JavaScript?
No. Any visitor could copy the key. The browser should talk to your server, and only the server calls the API, preferably with a few seconds of caching.
- Which plan should I use for a Bac Bo statistics site?
A small site with caching runs fine on Pro, at R$ 21.90 a month. To show long history and period filters, Business, at R$ 49.90 a month, gives access to the full history and 400 requests a minute.
For adults 18 and over only. LynxMetrics is not affiliated with Evolution or with the casinos that offer Bac Bo Live, and it only sells data and stats, never predictions or betting tips, because every round is random and past results do not predict the next one.
Read also
- Bac Bo API: live results in JSON, with a free trial
How to use the Bac Bo results API: what each round contains, examples in Python and Node, the stream, history, pricing and a free 2-hour trial.
- Bac Bo results in real time: ~4 seconds per round
How to receive every Bac Bo Live round the moment it is stored: the measured delay, the 8s heads-up before the result, and ready-to-run Python code.
- Bac Bo Telegram bot: build one with Python, step by step
A complete tutorial for building a Bac Bo Telegram bot: BotFather, live results from the API, messages that never repeat, Discord, and where to host it 24/7.