# Track Prices of Stocks and Mutual Funds in Google Sheets

I maintain a Google speadsheet to track my investment portfolio comprising stocks and mutual funds, and needed to automate fetching prices.

Google Finance offers a simple way to do this, using the `GOOGLE_FINANCE` function.

There are [simple tutorials for doing this for stocks](https://support.google.com/docs/answer/3093281?hl=en).

You need to form the symbol attribute by combining the exchange symbol(NYSE, NASDAQ, etc) and ticker symbol (AMZN, GOOG, etc.).

For example, So NASDAQ:AMZN. The complete code to use to retrieve the prices is

```plaintext
=GOOGLEFINANCE("NASDAQ:AMZN")
```

If you don’t know the exchange symbol, just search for the stock on [Google Finance](https://www.google.com/finance/). The search bar will show the code to use as `[exchange]:[symbol]`.

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1672213739019/5522ede9-d9ab-4cd8-b7da-f8c5a4669e0b.png align="center")

**Note**: Ensure that there you don't include any spaces in the symbol. `NASDAQ:AMZN` should a single literal.

---

This also works for tracking mutual funds. For example, searching for on Google Finance UTI Nifty 50 Index Fund will return:

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1672213917559/bb6a49ca-6e4f-4791-90ba-bee79a81f9f5.png align="center")

So you would use the code as:

```plaintext
=GOOGLEFINANCE("MUTF_IN:UTI_NIFT_50_FGX2CX")
```