Excel ticker returning wrong price

Question

Hi, the ticker for XLON:GGP is returning the incorrect price.

In June 2025, the company was revalued and renamed but retained the same ticker reference.

The value shown by stocks in Excel is the old June value, not the current one.

The returned value is 16.0, the current value is 662.0.

How do I get this updated?

It is causing me no end of problems.

Answer 1

I am using Mac Excel.

I tried retyping the ticker, etc., as suggested, but there's no difference, I'm afraid. Therefore, could you walk me through how to clear the old data and select the right listing? I also have the same problem for the FTSE 100 index.

Thank you in advance.

Answer 2

Hi,

Thank you for sharing your question. I understand how disruptive it is when Excel’s Stocks data type returns an outdated price, especially when the company was revalued and renamed but retained the same ticker, and your spreadsheet depends on accurate market data.

The reason this usually happens is that Excel’s Stocks data type relies on a financial data provider, and sometimes when a company is restructured, renamed, or revalued, the provider may still reference the old underlying equity record until the mapping is fully updated. In cases like this, the ticker may appear correct, but Excel is pulling data from the previous listing history instead of the updated instrument. This is known behaviour when tickers remain the same but the underlying asset is replaced, and Microsoft notes that Excel may require a manual data refresh or re‑selection of the correct listing to resolve it.

The resolution is to convert the cell back to text, re‑enter the ticker, and then reconvert it to a Stock data type so Excel can re‑match it to the current instrument. If Excel still resolves to the old security, selecting Data > Stocks > Data Selector lets you manually choose the correct listing this forces Excel to update to the correct GGP profile that corresponds to the current price of around 662 GBX.  You may also need to refresh the entire data type connection using Data > Refresh All if Excel cached the old record.

Would you like me to walk you through how to clear the old data type, select the correct listing from the Data Selector panel, or verify that Excel is recognizing the right exchange and issuer?

Please feel free to follow up with which version of Excel you’re using (Windows, Mac, or Excel for the web) and whether the ticker resolves to “Greatland Resources,” so I can guide you through the exact steps to ensure your spreadsheet pulls the correct, updated price.

 

Best Regards,

Noel