Best Way To Track Investments


Mutual Fund Investment Trackers

How to Track Your Investments | A Demo of the Best Investment Tracking App

Investing into mutual funds is one of the most popular investing options. A common mutual funds tracking problem is finding the tracking application that has data about ALL your mutual funds. Even missing just a single mutual fund data would make the investment portfolio trackerâs mission unfulfilled. Check our mutual funds investment trackers post where we focus on identifying mutual funds, how are they different from other investment funds, how to track them, etc.

What Is A Stock Portfolio Tracker

First, what are we talking about when we ask for the best stock portfolio trackers? We want a tool that can collect all of our investments and give us an understanding of how it is performing. Much like personal finance apps, we want it to be as seamless as possible and give us the ability to quickly analyze our holdings in a variety of ways.

As we list the best options below, we take into account the cost of the subscription , as well as the speed and usability of the platform.

Saving The Google Sheets Stock Spreadsheet


  • DO NOT request to share the spreadsheet. Just make a copy yourself. See below.
  • Yellow cells are where you manually enter data.
  • Aqua colored cells are formulas so do not overwrite.

To save a copy into your own account, do the following:

  • Sign into your Google Docs account
  • Click this link to open Stock Tracking Spreadsheet
  • Go to File > Make a Copy
  • Rename and press OK to save to your account
  • While youre at it, you can also get more spreadsheets and checklists by registering your email with Old School Value.

    But before we get deep into portfolio tracking, fill in your information below and Ill immediately send you the best free investment checklists and more investment resources to help boost your investing.

    Also Check: Using Va Home Loan For Investment Property

    How We Chose The Best Personal Finance Software

    To come up with our list of the best personal finance software, we researched and reviewed several personal finance applications based on criteria important to the consumer. We chose our top eight personal finance software after considering factors like price, variety of features, the types of financial goals they help you meet, company reputation, and more. We did not evaluate all options in the market.

    Start Using A Trading Journal

    The Best Free Investment Tracking Spreadsheet

    A trading journal is a log in which you keep track of what trades you make, your reasons for making them, and their outcomes. It can be as uncomplicated as writing everything down in a dollar-store binder, or it can involve using in-depth software.

    Trading journals are particularly popular with traders who focus on complicated trades, such as those on the foreign exchange market . But anyone who wants to play the stock or options markets can benefit.

    Now, one of the biggest misconceptions about a trading journal is that you use it just to log which trades you made and whether or not you profit. That’s not the point.

    The point of a trading journal is to help yourself become a better trader. It’s not about giving yourself a pat on the back when you do something right. It’s about learning from both your successes and your mistakes. It’s about analyzing what you’ve done so that you can perform better in the future.

    Further Reading: How to trade stocks

    Also Check: Canadian Investing In Us Real Estate

    Xirr Function For Calculating Annualized Return

    This spreadsheet uses the XIRR function to calculate the internal rate of return for a series of cash flows. In this case we are using it to calculate the annualized compounded rate of return.

    The spreadsheet also calculates a running XIRR value and a 6-period XIRR value . These formulas are fairly complex because they are array formulas that use nested IF functions . The 6-period XIRR function will get messed up if you delete rows from the table.

    Note: If you are only entering information from your monthly statement, you may not be capturing the actual date that investments are made because in this spreadsheet the XIRR assumes that amounts invested in column B are invested on the date specified in column A.

    How To Track Stocks

    This article was co-authored by wikiHow Staff. Our trained team of editors and researchers validate articles for accuracy and comprehensiveness. wikiHow’s Content Management Team carefully monitors the work from our editorial staff to ensure that each article is backed by trusted research and meets our high quality standards.There are 10 references cited in this article, which can be found at the bottom of the page. This article has been viewed 77,690 times.Learn more…

    The ability to track stocks effectively can increase a trader’s chances of profiting from prevailing economic and corporate conditions. Daily fluctuations in a stock can turn profits into losses at a moments notice, and vice versa. Closely tracking stocks can mitigate risk and increase profit potential. In order to track stocks properly, youll need to know what each category represents and how its relevant to that stock. The primary tools for stock tracking are Internet sites that provide daily stock quotes. However, if you dont have access to the Internet at a given time or place, you can use almost any newspapers financial section to get the previous days stock activity. This article walks you through the process of tracking stocks.

    You May Like: Merrill Edge Guided Investing Fees

    Best For Spreadsheet Management: Tiller Money

    Tiller Money

    If you’re a visual person that appreciates a well-crafted spreadsheet, Tiller might be the financial tool you’ve been looking for to manage your accounts in one place.

    • High-level view of all your accounts

    • Relatively low cost

    • Spreadsheet tracking may be too complicated for some users

    Tiller Money lets you see all your money in one place by automatically updating your checking, credit card, loan, investment, and other account data into a customizable Google Sheet or Excel template. You can choose from templates that organize your data for you or customize your spreadsheet to suit your needs. It’ll also send you daily emails with a summary of your recent transactions and balances.

    The service costs $79 per year or $6.58 per month, but you can take advantage of the 30-day free trial to decide if it’s right for you.

    Best For Habit Building: Ynab

    The BEST Way to Track Your Investments (Works Great With Dividends)


    You Need a Budget, or YNAB, offers tutorials and tools that can help you learn better budgeting and financial habits.

    • Helpful tutorials designed to keep you motivated

    • Detailed budgeting and spending reports

    • No investment tracking

    YNAB is a personal finance software designed to help you improve your financial literacy as you manage your monthly budget. As you create your budget and manage your daily finances, the software provides you with tutorials that will help you tackle some of the tougher financial topics. If youve been struggling with bad financial habits, YNAB can help you break those through a few basic financial management rules.

    The software automatically links to your bank account, integrating your spending information for analysis and budget tracking. You can keep tabs on how youre tracking toward your monthly budget and take action if youre overspending. But it doesnt include any investment tracking capabilities.

    YNAB offers a 34-day free trial that allows you to use the software while you decide whether its right for your personal finance goals. The full software is $14.99 monthly or $98.99 annually.

    You May Like: Mutual Funds That Invest In Startups

    Learn How To Diversify And Mitigate Risk

    Besides the portfolio tracker spreadsheet, youll also get a free copy of our How to Diversify Your Portfolio and Mitigate Risk Guide.

    The guide will teach you how to build and diversify your portfolio to protect your investments from the risk associated with having your fund invested in just one asset class.

    In this guide, we will show you how to build three types of portfolios based on level of risk:

    • A conservative portfolio puts more emphasis on capital preservation rather than appreciation.
    • A moderate portfolio offers returns over a longer horizon while keeping the risk at a moderate level.
    • An aggressive portfolio is designed to maximize your return over a long time but at a much higher risk.

    We will explain which of these portfolios is best suited to help you achieve your goals and also how to allocate your assets.

    What Is A Stock Tracking App

    A stock tracking app can accomplish the main goal of keeping tabs on the stock market. Beyond that, the app should be able to provide a glimpse at your own portfolio.

    Of course, the functionality of each stock tracking app will vary. But you can seek out the app that suits your needs. For example, if you are seeking an in-depth analysis of your funds, Morningstar could be the best fit. But a quick peek at your portfolios value could be accomplished with MoneyPatrol.

    Also Check: Home Loan Investment Bank Customer Service

    What To Look For In A Dividend Tracker

    There are several key features to look for in a good dividend tracker. Here’s what to consider when finding a quality product.

    PriceA reasonable price for a dividend tracker will depend entirely on your needs. If you’re only tracking a small portfolio of dividends stocks, it’s likely that a free tracker will work for you.

    But if you have many dividend stocks, a paid or premium service may be worth it. You may even earn more dividends, as a good tracker can increase your dividend yields and the performance of your dividend portfolio long term.

    Tracking Multiple AccountsIt would be nice if our entire portfolio was visible on just app or platform, but life tends to be messier.

    Between taxable accounts and retirement accounts like IRAs and 401s, and the accounts of family members, a good tracker should be able to handle multiple accounts.

    Dividend CalculatorsDividend calculators help project the future values of your portfolio with reinvested dividends, as well as changes to your portfolio yield due to payouts or proposed changes in company holdings.

    Stock AlertsGood decision-making involves knowing when dividends are projected to increase, decrease, or be eliminated altogether. Luckily, many dividend trackers will give you real-time stock alerts so you can act accordingly.

    Webull: Best App For Watching Stock Market Activity

    Investment Tracking Spreadsheet Excel within Investment Tracking ...
    • Available via desktop, Apple iOS and Android App on Google Play.

    Webull is an amazing option for intermediate to advanced investors, especially those who actively trade. There is no account minimum and stock trading is free.

    The app provides live market data and you can customize your homepage to show what countries and regions youre most interested in and the stocks youre tracking.

    Users have access to extensive charting, advanced orders, technical indicators, and advanced quotes. Unlike many other apps, Webull allows options trading as well as cryptocurrency trading.

    Currently, Webull has a partnership with Nasdaq that gives clients premier level two market data. After a three-month free trial, Level 2 Advance costs $1.99 per month and provides comprehensive data.

    This service allows you access to the complete depth-of-book with Nasdaqs best 30+ offers and bids so you can see orders being placed in real time. You can access the book by individual orders or price levels.

    You can also access the Net Order Imbalance Indicator data before the official market open and close.

    Webull allows for real-time data tracking and price movements. Because of its free service offering, we recommend Webull as the best app for watching stock market activity for any level of investor. They even offer free stocks for signing up.

    Learn more about the app in our Webull review.

    • Mutual funds
    • Bonds
    • Cryptocurrency on TradeStation Crypto

    Recommended Reading: How Much Do You Invest In Crypto

    Investment Software Vs Personal Finance Apps

    Before jumping-in head first into our look at the best ones, theres an important distinction to be made between personal finance software and investment management software.

    Investment tracking apps are mainly dedicated to managing and optimizing your investments. They are different to personal finance tools which are more focused on budgeting and getting your finances in order.

    Of course, many personal finance apps also do investment tracking but weve found that they are nowhere near as effective as dedicated wealth management software which is what weve focused on here.

    If youre also interested in budgeting applications on Mac, we recommend taking a look at some of our selection of the best personal finance software for Mac users .

    Its also important to be aware that these are not day trading tools. The investment apps reviewed here are designed to be used for investing over the long term, not buying and selling stocks every day.

    You May Also Like:

    When it comes to investment tracking, few apps cover more angles than Personal Capital.

    Personal Capital is 100% focused on investment management and does it extremely effectively.

    Personal Capital uses a unique business model that only charges you a commission if you choose to consult with one of its financial advisors.

    The app itself is completely free to use for as long as you want and can instantly optimize investments. Heres some of the things that we liked the most about Personal Capital:

    Stock Tracking Spreadsheet Must

    Again, my needs are simple.

    • Enter transactions into a single column without splitting up different transactions
    • Spreadsheet should be able to automatically update how many shares Im holding for any company
    • Account for dividends
    • Account for splits

    I dont do options so I have no need for such transactions.

    I am not an expert in options, so for that, it will be best for you to take this and edit it to match your own needs.

    Also Check: Is It A Good Idea To Invest In Gold

    Personal Capital: Best Portfolio Management Software

    • Available via desktop, Apple iOS and Android App on Google Play.

    Personal Capital has 3.1 million users. Some of those use the Free Financial Dashboard version, while others use the Wealth Management service.

    The Free Financial Dashboard makes it easy for people to add all their financial accounts in one place, including credit cards, savings, checking, loans, and tax-advantaged investment accounts.

    It also provides an Investment Checkup tool to assess your portfolio risk, analyze past performance and get a target allocation for your portfolio.

    You can use these recommendations to adjust your portfolio to improve your investment performance.

    You can use Personal Capitals free Investment Checkup tool to identify overweight and underweight stock sector investments and to assess your diversification.

    Further, you can compare your portfolio to the S& P 500 and Personal Capitals Smart Weighting Recommendation, which bases holdings on equal weightings across sectors instead of by market cap weightings.

    From there, you can use the Investment Checkup tool to dissect costs you pay in your accounts and fund fees you may pay annually.

    Personal Capital also pairs this service with Wealth Management services.

    Personal Capitals Wealth Management Services

    The Wealth Management plan is preferred by those who want more of a full investment service. This service provides both automated tools and human management.

    Why Subscribe to Seeking Alpha?

    Free Portfolio Tracker Spreadsheet Template Example

    How to track stocks with StockEdge scans?

    Check out this example portfolio tracker spreadsheet weve created to track indexes, stocks, and mutual funds.

    This template is designed to work best with spreadsheets automated by Tiller Money. You can try Tiller Money completely free for 30 days.

    How to get the tracker

    First, copy this example sheet into your Tiller Money-powered Google Sheet:

  • Open your Tiller spreadsheet.
  • Open the example portfolio tracker.
  • Right-click the Portfolio tab at the bottom and choose Copy to.
  • Paste the URL for your Tiller spreadsheet in the bottom of the Copy To window that pops up.
  • Do the same for the Detail tab.
  • Using the Portfolio Tracker Example sheet

    Customizing your Portfolio Tracker:

  • On the Portfolio sheet update the Symbols in Column A to use your own.
  • Update the Shares and the Date for any stocks and funds you have.
  • Add rows as necessary above and below for each type and copy/update the existing formulas into the new rows until youve filled in everything you want to track.
  • Customizing Your Detail Sheet

  • Navigate to the Detail sheet
  • Edit the GoogleFinance formula in cell A1
  • Update the Stock symbol from GOOG to a symbol of your choice.
  • Change the date range using YYYY-M-D format per the example.
  • Duplicate the sheet and update for as many stocks as youd like to track the daily closing price.
  • Update the chart data range to make sure its including all days youve pulled in.
  • Troubleshooting

    You May Like: Mortgage Rates For Investment Property Nj

    Top Portfolio Trackers In 2022

    Here are some portfolio trackers this year that you may want to consider taking for a test drive.

  • Personal Capital Personal Capital offers a portfolio tracker that surveys your risk profile and helps keep your asset allocation in line with your objectives. Youll receive alerts whenever your holdings deviate from your desired portfolio balance and recommendations for adjusting your asset allocation to improve portfolio performance. The personal finance tool offers numerous features beyond portfolio tracking. Its a one-stop-shop for reviewing your entire financial life. Well review other features in the next section.
  • Delta Investment Tracker This tracker provides live price updates to a wide range of stocks, bonds, mutual funds, ETFs futures, options and cryptocurrencies so you arent caught by surprise. It offers an overview of your total portfolio balance at any given point in time as well as your current market positions and value, percent change and unrealized capital gains.
  • SigFig Pro Tracker One big benefit of this portfolio tracker is that it automatically analyzes your portfolio to determine if you are overexposed to any particular industry or company. If so, it will suggest the proper asset allocation to optimize your portfolios performance. It also searches for hidden fees that might be eating into your investment returns.
  • What Is Personal Finance Software

    Personal finance software is any application that helps with all aspects of your personal finances. You can choose different software for different goals. Some software is ideal for budgeting, others are good for investing, and others are right for debt tracking and savings goals. Its designed to make managing and tracking your finances easier and more efficient and helps you set up systems that work for you.

    Recommended Reading: How Do The Ultra Wealthy Invest


    More like this

    Best Real Estate Investing Advice

    There Is...

    Series 65 Registered Investment Advisor

    Who Needs...

    Merrill Edge Self Directed Investment Account

    Merrill Edge...

    Investment Account Sign Up Bonus

    Acorns $25...