Wrong ticker pulling through to google sheets with API

🤝 Help
1

Hey Admin and anyone else clicking on this thrilling post..

AEI..LSE pulls through as ASEI.LSE for some reason into google sheets, is there a reason for this error?

2

Hey admins.

Just bumping this for a reply, thanks.

Have a wonderful Saturday.

3

ASEI.LSE was the company’s historical ticker before it changed to AEI.LSE in April 2022. Google Sheets’ via=GOOGLEFINANCE function often retains or redirects to older ticker symbols if its backend database hasn’t fully updated its primary reference for that entity.

Instead of AEI.LSE, use the format explicitly recommended by Google:
=GOOGLEFINANCE("LON:AEI", "price")

Check what name Google is associating with the ticker to see if it’s still using the old “Aberdeen Standard” branding:
=GOOGLEFINANCE("LON:AEI", "name")

4

No the API shows the wrong ticker, not Google sheets

5

If the API is returning the old ticker (ASEI.LSE) even though the listing is now AEI.LSE, it’s likely their instrument mapping still has the historical symbol as the “primary” alias.

Two things I’d try to narrow it down:

  • Pull the instrument by a stable identifier (ISIN / FIGI / internal instrumentId) if the endpoint supports it, then read the current symbol from that object rather than relying on a free-text ticker lookup.

  • If you’re doing ticker-based lookups, use an explicit exchange + symbol format and see whether the API exposes an “aliases / previousSymbols” field you can map.

As a quick sanity check when feeds disagree, I often cross-check with a separate source (especially for commodities/spot feeds) — e.g. for gold spot/melt math I use https://mygoldcalc.com to confirm the underlying price assumptions.

6

Hey Admin.

Can I please have an informed response on this matter?

Thank you