Charts, charts and more charts

[Phylo]

XAUUSD
Fri 28 Aug 2026
Blue line : 07:00 London summer time (EU-UK Open)
Yellow line : 13:30 London summer time (US open)

Sierra Chart - Period: Ticks
Red and while candles are a general trend indication not a hard and set rule of trade signals.

cTrader Margin: 222.72 - buy price 4454.48 - 1 lot

Google Sheets cell XAUUSD dynamic live price formula
=GOOGLEFINANCE("CURRENCY:XAUUSD") ⛔ No longer reliable

Reliable option: Apps Script + a real gold API​

This is the only robust, production-grade solution.

Step 1 – Open Apps Script​

In your sheet:

1. Extensions → Apps Script
2. Delete any sample code.
3. Paste this:

function GOLD_SPOT_USD() {
  // Free endpoint: current gold spot in USD per troy ounce
  const url = "https://api.gold-api.com/price/XAU";

  const response = UrlFetchApp.fetch(url, { muteHttpExceptions: true });
  const code = response.getResponseCode();
  if (code !== 200) {
    throw new Error("Gold API error: " + code);
  }

  const data = JSON.parse(response.getContentText());
  // Most gold APIs return something like { price: 2650.12, ... }
  // Adjust field name if your chosen API differs.
  return data.price;
}

Save the script (Ctrl+S / Cmd+S) and refresh the sheet.

Step 2 - Use in your sheet​

In any cell: =GOLD_SPOT_USD()
Google Spread Sheet

• cTrader Margin: 222.72 - buy price 4454.48 - 1 lot
• Google Spread Sheet Margin: 222.82 - buy price 4456.40 - 1 lot (0.10 difference - well within acceptable calculation limits)

XAUUSD - Google Spread Sheet Calculator

Google Sheet Full Interactive Calculator