How to Track Mutual Funds in Google Sheets (2024)

Google Sheets is an online cloud-based service that allows users to create, edit and collaborate on spreadsheets online and offline.

I covered Google Sheets in a previous Spreadsheet Corner article, Alternatives to Excel. I also created a stock portfolio tracker using Google Sheets. In this article, I illustrate how to use the Google Finance capabilities within Google Sheets to access mutual fund data.

Google Sheets is available through Google Drive, a file storage and synchronization service created by Google. It allows users to store files in the cloud, share files and edit documents, spreadsheets and presentations with collaborators. Additionally, applications are available that allow you to access your spreadsheet through your tablet or smartphone. Google Drive and its Docs, Sheets and Slides programs work with the two most recent versions of the browsers Chrome, Firefox, Safari and Internet Explorer. You need to make sure cookies and JavaScript are turned on for your browser.

You’ll need to upgrade to a newer browser version to access all your files in Drive. In terms of operating systems, Google Drive currently works with Windows XP and above, Lion 10.7 (for Mac) and above. It doesn’t work with Linux operating systems, but Google suggests that Linux users can use Google Drive on the Web at or through the Google Drive application.For an updated list of accepted browsers and operating systems, go to Google’s help page on System Requirements and Browsers.

Google Finance is a function within Google Sheets that retrieves current or historical security information. Mutual fund prices are provided by Morningstar and mutual fund data is delayed to end-of-day. More information regarding data provided by Google Finance can be found at the Google Finance Data Listing and Disclaimers page.

Creating a Google Drive Account

Figure 1. Google Apps Menu Button

To use the Google Finance function within Google Sheets, you will need to create a Google Drive account, if you don’t have one. If you currently have an email address that ends with “,” you already have a Google Drive account.

To access Google Drive, you can go to and use your Gmail account information to log in. An alternative option is to log into your Gmail account and click the “cube-like” Google apps menu button toward the upper right-hand corner of the page, as shown in Figure 1.

Figure 2. Google Drive Icon

Then select the Google Drive symbol, as shown in Figure 2.

To create a spreadsheet, select “new” on the left-hand side of the page, then select Google Sheets.

Using Google Finance

The syntax for the Google Finance function is:

=GOOGLEFINANCE(ticker, [attribute], [start_date], [num_days/end_date], [interval])

The only two required fields are the ticker and attribute inputs; these are required to be input for the function to work properly. If you don’t specify an attribute, Google Finance will use price as a default. Using only the required inputs, your formula would look similar to this:

=GOOGLEFINANCE(ticker, attribute)

An attribute can be current data such as price, volume or market capitalization. A list of attributes is available at the function help page.

You have to type the attribute name exactly as it appears on the syntax list of the function help page, or the formula will not recognize what you are asking it to retrieve. On the list of attributes, there are several that are specific to mutual funds:

  • “closeyest”- The previous day’s closing price
  • “date”- The date at which the net asset value was reported
  • “returnytd”- The year-to-date return
  • “netassets”- The net assets
  • "change"- The change in the most recently reported net asset value and the one immediately prior
  • "changepct"- The percentage change in the net asset value
  • "yieldpct"- The distribution yield, the sum of the prior 12 months’ income distributions (stock dividends and fixed income interest payments) and net asset value gains divided by the previous month’s net asset value number
  • "returnday"- One-day total return
  • "return1"- One-week total return
  • "return4"- Four-week total return
  • "return13”- 13-week total return
  • "return52"- 52-week (annual) total return
  • "return156"- 156-week (three-year) total return
  • "return260"- 260-week (five-year) total return
  • "incomedividend"- The amount of the most recent cash distribution
  • "incomedividenddate"- The date of the most recent cash distribution
  • "capitalgain"- The amount of the most recent capital gain distribution
  • "morningstarrating"- The Morningstar star rating
  • "expenseratio"- The fund’s expense ratio

For example, if you wanted to be able to view a particular expense ratio for a mutual fund, you would type the following formula into Google Sheets:

=GOOGLEFINANCE("VFINX", "expenseratio")

Attributes must be enclosed in parenthesis, as well as the ticker symbol.

The Spreadsheet

CI’s Mutual Fund Watchlist With Google Sheets contains only one tab: Watchlist (Figure 3). Cells highlighted in yellow require manual input, while everything else will be calculated accordingly. CI’s Mutual Fund Watchlist with Google Sheets will appear when you click thislink.

Figure 3. CI’s Mutual Fund Watchlist With Google Sheets

In order to have your own copy that you can edit, you have several options. The first one requires you to sign in to Google, then click File, and Make a Copy. You will then officially have your own copy of the Watchlist. To access the spreadsheet at a later date, sign into Google and click the grid-like menu icon in the top right-hand corner of your page (Figure 1). This will show you choices such as: Calendar, Finance, Maps, News, Gmail and Drive. Click “Drive.” This is where you will be able to access your copy of the spreadsheet.

If you do not have a Google account, once you click the Google spreadsheet link above to open the file, click File, Download As. You will see several options including: Microsoft Excel, OpenDocument format, PDF document, comma-separated values (CSV), tab-separated values(TSV), or web page. Based on your preference, click any of these options to download your own copy of the CI Mutual Fund Watchlist and save to a location of your choosing.

This is a basic mutual fund watchlist designed to demonstrate using Google Finance functions within Google Sheets. As you become familiar with using Google Finance functions, you can add data of interest to you and reorganize the sheet to your preference.

The following two sections review some basic spreadsheet conventions that will be helpful to understand as you work with Google Sheets.

Cell References

You can reference specific fund ticker symbols or attributes by referencing specific cells within your spreadsheet. Cell references do not take quotation marks in the formula. For example, let’s say that the ticker symbol VFINX is in cell A4 in your spreadsheet. You would enter the following formula:

=GOOGLEFINANCE(A4, "expenseratio")

Here you are still pointing to the particular stock ticker; however, you are specifying a cell as opposed to directly naming the ticker in the formula. Why is this useful? Using cell references is helpful if you are creating something similar to a watchlist and will often be changing the ticker symbols you are following. By referencing cell A4 in your formulas, you can pull in information on any ticker you put in that cell instead of having to replace the ticker in each formula.

You can also create an “absolute cell reference.” Absolute cell references are used when you wish to copy or move formulas elsewhere on the worksheet, but you want the formula to consistently refer to a particular cell. Relative cell references, like in the example used above, change when a formula is copied to another cell, whereas absolute cell references remain constant. There are advantages to using both types of cell references.

For example, if you input the formula =(C1+D1) into cell B1, then click on cell B1 and “drag” the formula down, the calculation will repeat itself, except that the cells it references will change to the respective row number. So if you drag the (C1+D1) formula from B1 down to B10, the formula in cell B2 would be:


Google Finance (and Excel) assumes that you want to change the cells that are used in the formula when you copy it. This can be very helpful if you need to repeat the same calculation across multiple rows and columns. Figure 4 shows the formulas using relative cell references in column B. Figure 5 shows the results of the calculations adding the figures in column C and column D in column B for each row.

Figure 4. Copying a Formula With Relative Cell References

Figure 5. Results Using Relative Cell References

If instead you wanted to use an absolute cell reference in cell B1, it would look like this:


The dollar signs in front of the cell references instructs the spreadsheet that this is an “absolute” reference. Now when you drag cell B1 formula ($C$1+$D$1) down to cell B10, cell B2 has the formula:


The formula and specific cells used in the calculation stay constant. Figure 6 shows the formulas using absolute cell references in column B. Figure 7 shows how the results of the calculations differ from those in Figure 5, since all column B formulas are adding cells C1 and D1.

Figure 6. Copying a Formula With Absolute Cell References

Figure 7. Results Using Absolute Cell References

The dollar sign in front of the column reference as well as the row reference means that the column and row must stay constant even if the formula is moved. If you were to put a dollar sign only in front of the C in the formula above ($C1), the row reference number would still change when you dragged the formula down.

These concepts will help you not only in Google Sheets but also in Excel.

IF Function

The IF function is used throughout the spreadsheet.

The IF function is defined as:

=IF(logical_text, [value_if_true], [value_if_false])

If the logical text is determined to be true, then the “value if true” will result. If the logical text is determined to be false, then the “value if false” will result. In this case, if the referenced cell is blank (“ “), a blank should appear in the destination cell, and if the referenced cell is not blank, the formula after the final comma should be calculated in the destination cell.

I used this function throughout the spreadsheet so I could easily drag down formulas without error warnings appearing (it makes the spreadsheet appear “prettier,” not to mention easier to read). Some common Excel-related errors include: #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME? and #NULL!.


Google Sheets offers mutual fund data for individual investors who may be interested in tracking their portfolio using a cloud-based spreadsheet. While many of the data points offered are basic, they are still very useful. Best of all, it is free.

If any CI members create their own mutual fund (or stock) tracking portfolio using Google Sheets (or even a regular spreadsheet), please email us if you would be interested in sharing it with other subscribers:


B.W. from MA posted over 6 years ago:

I have used this spreadsheet to track my portfolio. The one thing that needs attention is that the updated values don't take place at the close of the market, the updated values occur after 10 PM EDT. This means that I don't get to evaluate my portfolio in the evening but in the morning before the market opens. Our corporate minders don't like us to trade on company time, therefore, it would be very useful to have this data update at an earlier time. Is this possible?

Jackie McClellan from IL posted over 6 years ago:

Unfortunately this would be an issue to take up with Google Sheets. I am not sure what their policy is on data updates. If you do reach out to them, please let us know what they say. I think this would be very helpful for other subscribers.

Robert Rude from VA posted over 6 years ago:

Maybe I missed it, but was there an earlier article on how to do this with Excel? Or do Excel and Google Finance not play well together? Also, does this spreadsheet design (through either Excel or Sheets) work with ETFs?

Jackie McClellan from IL posted over 6 years ago:

Robert,You are correct, Excel and Google Finance don't play well together. The "google finance" function only works in Google Sheets.They have some ETFs that are compatible but not really ETF-esk type data. This link will show you the attributes you can get using google finance: to answer your question - yes some ETFs work, but I couldn't find which ones are compatible and some of the attributes aren't applicable to ETFs.

SUDHIR M from IL posted over 2 years ago:

If we created a sheet that pulls historic prices and then calculates returns based on the prices, would we still need to account for the expense ratio? Said another way, do the prices already include the amount paid out as expenses?Thanks in advance!

You need to log in as a registered AAII user before commenting.
Create an account

Log In

How to Track Mutual Funds in Google Sheets (2024)


Does Googlefinance work with mutual funds? ›

Google Finance provides a simple way to search for financial security data (stocks, mutual funds, indexes, etc.), currency and cryptocurrency exchange rates ('Finance Data').

How do I keep track of investments in Google Sheets? ›

Using Google Finance to Track Stocks in Google Sheets. The function you'll use to obtain the stock data is GOOGLEFINANCE. So you'll select a cell, enter an equal sign followed directly by GOOGLEFINANCE and then include the ticker symbol and optional attributes.

How do I track all mutual funds in one place? ›

Best apps for tracking your investments in India
  1. myCams Mutual Fund App. myCAMS gives you a 360 view of your portfolio that is connected to your PAN. ...
  2. KfinKart. This multi-feature app allows a one-touch login. ...
  3. Money Control. ...
  4. Zerodha's Coin. ...
  5. ET Money. ...
  6. Groww.

How do you check if a mutual fund is doing well? ›

Go to (opens in new tab) (Or look up funds via's free Fund Finder tool), type in a fund's name or symbol, and click on “performance.” Look for year-to-date or one-year returns. Thanks to the bull market, many stock funds have been doing well lately.

Can Google Sheets track mutual funds? ›

µFunds is a Google Sheets add-on that allows to import data of your mutual funds directly from Morningstar, only with their ISINs. µFunds is a Google Sheets add-on that allows to import data of your mutual funds directly from Morningstar, only with their ISINs.

Which app is best for mutual fund analysis? ›

Zerodha Coin Mutual Fund App
  • Top Features of PaisaBazaar the best app for mutual fund –
  • Android Rating – 4.4/5. ...
  • Top Features of Piggy best app for mutual fund –
  • Android Rating – 4.5/5. ...
  • Top Features of Cashrich best mutual fund app –
  • Android Rating – 4.2/5. ...
  • Top Features of Kfinkart best mutual funds app –

How do I create a financial tracker in Google Sheets? ›

Creating your own Google Sheets expense tracker.
Navigate to File -> New -> 'From template gallery'.
  1. This opens the Google Sheets Template gallery.
  2. Under the Personal section, select the 'Monthly Budget' thumbnail.
  3. This opens a new worksheet with the Monthly Budget template.

How do I create a progress tracker in Google Sheets? ›

Set up progress trackers:
  1. Open Sheets and select the column that you want to apply the formatting rules to.
  2. Select Format. Conditional formatting.
  3. Set up the rules. In this example, you assign a different color to tasks that are Complete, Not started, or In progress:

How do I create a real time tracker in Google Sheets? ›

A. Chrome Extensions and Integrations
  1. Install the Time Doctor desktop app and Chrome extension.
  2. Click on the timer button on the top of the Google Sheet to track time.
17 Nov 2021

Can Excel track mutual funds? ›

Excel is very good for keeping track of your investments.

Due to its grid nature, you can easily create a table of all the mutual fund holdings and monitor the latest NAVs (Net Asset Values) to see how your investments are doing.

Which app shows all mutual funds? ›

Fisdom is now updated with a brand-new experience of external portfolio tracking. With this feature, we are empowering you as an investor to conveniently track all of your mutual fund investments in one place, even if it was not done on Fisdom . All it takes are some simple steps from your end.

How can I keep track of direct mutual funds? ›

How to track direct mutual funds?
  1. Stock Broker's Platform- If you're investing in direct funds through stock brokers Zerodha, and 5paisa then you can track your investments in the platform itself. ...
  2. AMC Website- You can track your direct mutual fund investments on the AMC website.

What is the best measure of a mutual fund performance? ›

Sharpe Ratio

This measurement is useful because while one portfolio or security may generate higher returns than its peers, it is only a good investment if those higher returns do not come with too much additional risk. The greater an investment's Sharpe ratio, the better its risk-adjusted performance.

What is a realistic return on mutual funds? ›

Looking at the seven major categories of mutual funds above, the average annualized return for 2021 was 11.54%.

How do you evaluate MF performance? ›

How to Evaluate Mutual Fund Performance
  1. Benchmark. Benchmarking is the process of comparing the quality of a fund to a set of standards. ...
  2. Comparing to peers. ...
  3. Portfolio quality. ...
  4. Risk-Adjusted Returns. ...
  5. Fund manager's expertise. ...
  6. Define your investment objectives. ...
  7. Fund's Fee Structure.

Can I use Google Sheets for data analysis? ›

Get summaries and charts of your data with the click of a button in Sheets. It's kind of like having an expert in data analysis sitting next to you. In a spreadsheet, select a range of cells, columns, or rows. Otherwise, you'll get insights based on where your cursor is.

Is Google Sheets good for data analysis? ›

Spreadsheet software like Excel or Google Sheets are widely used tools for analyzing data. Google Sheets has some built-in quick analysis features that can help you get an overview of your data and some useful insights.

Can GoogleFinance be used in Excel? ›

Once you get the data into a Google Sheet, it can be automatically exported and grabbed by Excel. It's an indirect method but effective. Google's GoogleFinance() function returns a lot of information about many global stocks and indexes.

How do you Analyse data from a mutual fund? ›

Step 1: Determine the sector weights for both the fund and the index. Step 2: Calculate the contribution of each sector for the fund by multiplying the sector weight by the sector return. Repeat for the index. Step 3: Calculate the rate of return for the fund by adding the contribution of each sector together.

What is the best free portfolio tracker? ›

9 Best Stock Portfolio Tracker Apps & Software in 2022
  1. Seeking Alpha: The Best Stock Portfolio Tracker Overall. ...
  2. Personal Capital: The Best Free Stock Portfolio and Net Worth Tracker. ...
  3. Morningstar: The Best Stock Portfolio Tracker Runner-Up. ...
  4. Delta Tracker: The Best Crypto App Portfolio Tracker.
29 Nov 2022

Which site is best for mutual fund information? ›

Here are the best online brokers for mutual funds:
  • Fidelity Investments.
  • Charles Schwab.
  • E-Trade Financial.
  • Ally Invest.
  • The Vanguard Group.
  • TD Ameritrade.
  • Interactive Brokers.
  • Merrill Edge.
1 Dec 2022

Does Google have a finance tracker? ›

Find your financial insights

Open the Google Pay app . Tap Insights . At the top, you can find your financial insights. To find details about your insights, swipe through the available insights.

Can you do bookkeeping on Google Sheets? ›

Bkper is a simple and robust collaborative double-entry bookkeeping platform that turns Google Sheets into a powerful accounting tool, with functions to easily create Balance Sheet and Profit & Loss statements, and connections to 10,000+ banks and credit cards institutions worldwide.

Does Google Sheets have a ledger template? ›

All accounts have more or less the same fields, so you can use a simple ledger template that you can duplicate for each type of account. Note: A ledger template may also be called a balance sheet template.

How do I track goals in Google Sheets? ›

Here's how to set and track goals using Google Sheets.
You can build a weekly tracker below your goals by following these steps:
  1. Write the days of the week in rows.
  2. Add your goals as columns along the top.
  3. Insert checkboxes by highlighting the cells within and going to Insert and Checkbox.
5 Oct 2022

Does Google Sheets have change tracking? ›

If you want to track changes in a specific cell, Google Sheets has a built-in feature. This is how you can quickly access it. 1. Right-click on the cell you would like to track changes on and select the option “Show edit history” from the drop-down menu.

How do I add an activity dashboard in Google Sheets? ›

Drive and Docs.

Click Activity dashboard settings. Next to Users' view history, select an option that determines who can see a user's file views. On (recommended): File-viewing information will appear in the Activity dashboard unless users choose to hide their views.

How do I track a price in Google Sheets? ›

Use the GOOGLEFINANCE function
  1. In Sheets, open a spreadsheet.
  2. In an empty cell, type =GOOGLEFINANCE.
  3. In parenthesis, add any of the following, separated by a comma: A ticker symbol in quotation marks. (Optional) The attribute you want to show, such as price, in quotation marks. ...
  4. Press Enter.

How do I create a portfolio tracker in Excel? ›

You can use basic Excel knowledge to create rules, spot trends, and compare stocks with the stock data pulled into Excel.
  1. Step 1: New Workbook & Tickers. ...
  2. Step 2: Stock Data Types. ...
  3. Step 3: Stock Widget. ...
  4. Step 4: More Stock Info. ...
  5. Step 5: Personal Investment Info. ...
  6. Step 6: Rules for Sell/Hold. ...
  7. Step 7: Aggregating Returns & Equity.

How do I fetch mutual fund NAV in Excel? ›

How to use this mutual fund tracker Excel workbook?
  1. Download and save the file to a folder on your computer (do not leave it in the downloads folder)
  2. Open the file in Excel (you need Excel 2016 / Office 365 to use this file. ...
  3. If prompted, enable “External connections”
  4. Go to Data and click on Refresh all.
6 Jul 2018

Where can I get list of all mutual funds? ›

List of mutual fund companies in India
  • Axis Asset Management Company Ltd. ...
  • Aditya Birla Sun Life AMC Limited. ...
  • Baroda Asset Management India Limited. ...
  • BNP Paribas Asset Management India Private Limited. ...
  • BOI AXA Investment Managers Private Limited. ...
  • Canara Robeco Asset Management Company Limited.

How do you show mutual funds on a balance sheet? ›

In this instance, use the "cost method" to report investments: List the fair market value of your holding as "equity investments" on the balance sheet under "long-term assets." If you plan to sell the securities in less than one year, list your holding under "short-term assets." All mutual fund shares should be listed ...

How can I track my daily NAV of mutual fund? ›

There are three main sources that you can tap into to check an MF's historical NAV: Individual AMC websites. The Association of Mutual Funds of India (AMFI) NAV history page. ET Money.

How do I track all my investments? ›

How to keep track of your investments online? Are there any apps for tracking your portfolio?
  1. Money Control. Money Control is a financial portal owned by TV18. ...
  2. ET Money. ETMoney is an investment and spending tracker. ...
  3. INDmoney. ...
  4. TickerTape. ...
  5. Kuvera. ...
  6. Portfolio Tracker – Wealthy. ...
  7. Google Sheets. ...
  8. Microsoft Excel.
12 Apr 2022

How are mutual fund flows tracked? ›

You can find fund flow data within individual fund filings, or you can look at financial data aggregators, like Morningstar, that provide both data and commentary. Each year, Morningstar issues an Annual Global Fund Flows Report. It outlines where global funds are being allocated.

How can I track all SIP investments? ›

Once you start the SIP/STP or SWP transaction, you will be able to see all your future transactions in Portfolio -> Transaction -> Scheduled Transaction. After the SIP transaction is complete on the scheduled date, it will reflect in Portfolio -> Transactions -> History.

What mutual funds have google stock? ›

Top 10 Mutual Funds Holding Alphabet Inc
Mutual fundStakeTotal value ($)
Government Pension Fund - Global ...1.86%10,715,019,768
iShares Core S&P 500 ETF1.69%9,729,041,681
SPDR S&P 500 ETF Trust0.99%5,713,564,387
Fidelity 500 Index Fund0.96%5,507,637,142
6 more rows

Does Google Finance work with ETFs? ›

Using this add-on with the GOOGLEFINANCE function will give you a powerful analytical toolkit, not only mutual funds but also stocks, Exchange Traded Funds (ETFs), bonds, etc.

Which platform is best for mutual funds? ›

  • Coin by Zerodha. This is one of the simplest apps to make investments in mutual funds. ...
  • Groww. If you're just starting to make mutual fund investments, Groww is the app for you. ...
  • Paytm Money. ...
  • CashRich. ...
  • Kuvera. ...
  • ETMONEY. ...
  • Coin by Zerodha. ...
  • Groww.
20 Sept 2022

How does Google Finance track mutual funds? ›


This will fetch the latest NAV of the fund and then you can multiply the NAV value with the number of units this way you can get your funds value. This way you find all your mutual funds and stocks' current value and add them up.

What are the top 3 mutual funds? ›

Top 25 Mutual Funds
RankSymbolFund Name
1VSMPXVanguard Total Stock Market Index Fund;Institutional Plus
2VFIAXVanguard 500 Index Fund;Admiral
3FXAIXFidelity 500 Index Fund
4VTSAXVanguard Total Stock Market Index Fund;Admiral
21 more rows

Who is the biggest shareholder in Google? ›

Larry Page owns 39 million Alphabet shares, representing 196 million shareholder votes. The market value of Larry Page's stake in Alphabet was $114 billion as of December 2021. Larry Page founded Google in 1998 together with its co-founder SergeyBrin.

Does Warren Buffett Own ETFs? ›

Key Points. Buffett's Berkshire Hathaway portfolio includes two S&P 500 index ETFs -- SPY and VOO. Both ETFs have low costs and have delivered solid returns since inception.

How do I use Google Finance in sheets? ›

Use the GOOGLEFINANCE function
  1. In Sheets, open a spreadsheet.
  2. In an empty cell, type =GOOGLEFINANCE.
  3. In parenthesis, add any of the following, separated by a comma: A ticker symbol in quotation marks. (Optional) The attribute you want to show, such as price, in quotation marks. ...
  4. Press Enter.

What is the safest type of mutual fund? ›

Money market mutual funds = lowest returns, lowest risk

They are considered one of the safest investments you can make. Money market funds are used by investors who want to protect their retirement savings but still earn some interest — often between 1% and 3% a year.

What is the safest investment in mutual funds? ›

Here is the list of some of the recommended mutual fund schemes you can consider In:
Fund Name1 Year Return5 Year Return
ICICI Prudential Equity & Debt Fund8.11%10.65%
ICICI Prudential Balanced Advantage Fund12.79%10.37%
LIC MF Infrastructure Fund – Growth13%4%
HDFC Hybrid Equity Fund9.44%10.22%
64 more rows
24 Jun 2022

Top Articles
Latest Posts
Article information

Author: Prof. An Powlowski

Last Updated:

Views: 5774

Rating: 4.3 / 5 (64 voted)

Reviews: 95% of readers found this page helpful

Author information

Name: Prof. An Powlowski

Birthday: 1992-09-29

Address: Apt. 994 8891 Orval Hill, Brittnyburgh, AZ 41023-0398

Phone: +26417467956738

Job: District Marketing Strategist

Hobby: Embroidery, Bodybuilding, Motor sports, Amateur radio, Wood carving, Whittling, Air sports

Introduction: My name is Prof. An Powlowski, I am a charming, helpful, attractive, good, graceful, thoughtful, vast person who loves writing and wants to share my knowledge and understanding with you.