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

 

[Phylo]

If the cTrader buy price is used on the Google Spread Sheet the Margins will match exactly (if - the cell formula is correct)

Google Spread Sheet Test Price Cell

Note: Test Price punched in at 4454.49 and not 4454.58 - the 0.01 error is irrelevant.

XAUUSD - Google Spread Sheet Calculator

However, using and above script internet source price and not the actual cTrader price results in a Margin discrepancy of about ~ $0.10 per 1 lot. So about ~ $1.00 on a Margin of $2,227.20 at a buy price of $4,454.49 for 10 Lots position.

• I consider the $0.10 discrepancy per 1 lot irrelevant - and well within acceptable marginal (pun intended) error calculation limits - as an on the fly dynamic calculation of Margin, Required Balance, Free Margin and above all RISK.

However, for the purist - there does appear to be an alternative using cTrader open API

 

[Phylo]

RISK

1. RISK is easier conceptualised as a numeral measure rather than a percentage measure.
2. Re the above: SL VLAUE = 1.25 % risk of FREE MARGIN - not - Balance (Free Margin = Balance - Magin)
3. From the numerical perspective the 1.25 % represents how many SL VALUES lost - immediately one after another - that would flatten FREE MARGIN.
4. Thus - 1.25 % represents a numerical SL Risk Value of 80. A multiple of 80 SL Values, lost one after the other, that would flatten FREE MARGIN.
5. So - 2nd line SL VALUE = 1,600 / 80 = 20, 3rd line SL VALUE = 3,200 / 80 = 40, 4th line SL VALUE = 6,400 / 80 = 80.

 

[Phylo]

 

[Phylo]

 

[Phylo]

XAUUSD - SPX500 - US30
Tue 1 Sep 2026
Blue line : 07:00 London summer time (EU-UK Open)
Yellow line : 13:30 London summer time (US open)

Sierra Chart - Period: Trades per Bar
Red and while candles are a general trend indication not a hard and set rule of trade signals.
PD = Price Difference

 

[Phylo]

Altcoin potential
Altcoin - (short for alternative coin) refers to any cryptocurrency other than Bitcoin (BTC).
ZEC stands for Zcash, a decentralized and open-source privacy-focused cryptocurrency launched in 2016,

ZECUSD
Buy: 80
Sell: 800

HYPOTHETICAL BUY AND HOLD CALCULATION - ALTERNATIVELY, NUMEROUS DIP BUYS OR BUY-SELL CYCLES OPPORTUNITIES ARE EVIDENT.
Percentage Profit: ((800 / 80) - 1) x 100 = 900 %
$ PnL: $1 >> ( 900 / 100 ) x $1 = 9 x $1 = $9.

1. $10 >> = $80​

2. $100 >> = $900​

3. $1,000 >> = $9,000​