Blog · Bac Bo Live

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.

  1. Create a spreadsheet and rename the first tab to Bac Bo.
  2. Open Extensions > Apps Script and paste the code below.
  3. In Project settings > Script properties, create the property LYNX_KEY with your key. That way it is not visible to anyone who opens the spreadsheet.
  4. Run the updateBacBo function once and authorise access.
  5. 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

UseRecommended planWhy
A personal spreadsheetPro, R$ 21.90 a monthOne request a minute and 7 days of history are enough
A small site with cachingPro20 requests a minute sits well below the limit of 60
A site with long history and period filtersBusiness, R$ 49.90 a monthFull history, up to 1,000 rounds per request and 400 requests a minute
Several sites or clientsOne project per siteEach 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