How to Track Mutual Funds and Stock Portfolios Using Excel

Microsoft Excel, one of the best spreadsheet programs on the market, can track and filter almost any type of financial information with its wide variety of sorting and calculating tools. You can easily monitor your own mutual funds and stock portfolios using Excel. Instead of designing a complicated spreadsheet from scratch, simply download one of Microsoft's official Excel templates to get you started quickly. These Excel templates come with automatic formulas that allow you to conveniently track all of your investments in one file.

Print this article

Microsoft Excel

Instructions

- 1
  
  Go online to Microsoft's official website for downloading Office software templates. (See References section.)
- 2
  
  Scroll down the Web page to the bottom. Go to the "Search for templates by product" section.
- 3
  
  Enter "stock portfolio" in the "Search" field. Select the "All products" drop-down menu and choose "Excel." Click the "Go" button.
- 4
  
  Browse through the available mutual funds and stock portfolio templates for Excel. Choose the design and layout that closest matches your needs.
- 5
  
  Click the title of the Excel template you want to download. Select the "Download" button. Click the "Accept" button for Microsoft's online service agreement. Your stock and mutual funds Excel template will automatically begin downloading to your computer.
- 6
  
  Open your downloaded template in Microsoft Excel. Customize the wording, column headers, fields, colors, and fonts to suit your purposes.
- 7
  
  Enter the data and information for your stocks, mutual funds and other investments into the appropriate Excel fields. Go to "File" in the top main menu, and click "Save as." Save the file to an easy-to-remember location on your computer.
- 8
  
  Update your stock and mutual funds data in your Excel file every day. Review your data and track your investments at the end of the month or fiscal quarter.

Tips & Warnings

Check the star rating on each template to determine the most popular ones and those with the best feedback.

Suggest item

Microsoft: Download Office Software Templates

Comments

How to Calculate the Future Value of an Investment Using Excel
Using Microsoft Excel to calculate the future value of a potential investment is a relatively simple task once you have learned the...
How to Monitor Stock Prices in Microsoft Excel
Whether you have a large stock portfolio or own a few shares of stock, monitoring the performance of your investments can be...
How to Use Excel To Calculate Investment Portfolio Returns
Calculating investment returns can be simple using Excel. Use these steps to compute the time-weighted internal rate of return (TWIRR) of your...
How to Calculate a Return on an Investment in Excel
A smart business person knows the importance of doing regular return on investment (ROI) calculations. It is a way to measure the...
How to Track Stocks in Excel
Microsoft Excel is an ideal place to track your stocks due to its calculation capabilities. When tracking stocks, it is important to...
How to Use Excel to Keep Track of Freelance Jobs
Keeping track of your freelance jobs, both the ones that you apply for and the ones that you have accepted can be...
How to Track Weekly Employee Excel Spreadsheets
Creating a spreadsheet for your place of business can help you keep track of weekly employee attendance. Employees and supervisors often need...
How to Track Mutual Funds in Stock Purchases
Despite its periodic wild swings, the stock market can still be an excellent place to invest. Many investors find that having at...
How to Use Excel to Calculate Your ROI
Active investors must continually track the return on investment (ROI) for each of their transactions. The ROI for any particular investment is...
How to Use Excel to Create Performance Appraisals
Performance appraisals are a common occurrence in corporate settings. Their frequency often requires that pre-formatted templates are available for employees ...
How to Use Excel's ACCRINT Function
Excel's ACCRINT function calculates accrued interest on an investment that pays a periodic interest. This function's name stands for "ACCRued INTerest" and...
How to Use Microsoft Excel to Track Cattle Ranching
Using a spreadsheet application such as Microsoft Excel can be beneficial for many businesses. It has a wide range of functions, and...
How to Keep Records on Stock & Mutual Fund Purchases
If you invest in mutual funds, it is important to keep accurate records of every purchase and sale. Keeping your records accurate...
How to Set Up Spreadsheets for Stock Certificates
Spreadsheet programs like Microsoft Excel provide an excellent resource stock market investors can use to track their purchases, sales, taxes and dividends....
How to Start a Stock Portfolio
A stock portfolio is a compilation of stock holdings that reflects the investor's choices of stocks. A stock portfolio can be as...
How to Compute Loss & Gain in the Stock Market
Despite its periodic ups and downs, the stock market can still be a good place to invest. Even so, it is important...
Importance of Microsoft Excel
Investopedia, a Forbes digital company, heralds Excel as an invaluable tool for portfolio managers, traders and accountants. The digital magazine proclaims that...
How to Monitor Stock Prices in Microsoft Excel
In order to monitor stock prices in Excel, a spreadsheet needs to be created that outlines the names of companies and significant...
How to Track Mutual Fund Performance
No matter if you are already a seasoned investor or if you are just getting your feet wet in the investment world,...
How to Make a Portfolio & Link to a Resume
The practice of building an online portfolio and linking a resume to it is becoming increasingly popular for a couple of reasons....

How to Track Mutual Funds and Stock Portfolios Using Excel

Other People Are Reading

Things You'll Need

Instructions

Tips & Warnings

References

More Like This

Comments

You May Also Like

Related Ads

Kid-Approved iPad Apps by Mom.me

You May Like