G sheets can't find my ticker

Investing and Markets 📈
1

Hey everyone, I have created a spread sheet to track my investments over time. I’m using g sheets and unfortunately the googlefinance function cannot find the right ticker for Softcat (LSE:SCT). It keeps displaying N/A. Any ideas?

2

Try =GOOGLEFINANCE("LON:SCT", "price")

3

Try LON:SCT

4

It works, thank you!

5

Thanks Jimmy that sorted it!

1 Like