The stock portfolio tracker you need

And it's free. Just fire it up in Excel.
Portfolio tracker for stocks and investments

You might be thinking…

Why would I want another investment portfolio tracking tool? Why would one portfolio tracker be any different from the other, and what’s wrong with just using the free tool provided by my broker?

Many think of investing as a simple buy-and-sell process. You buy a security and sell it later at a higher price. Hence, you wouldn’t need much of a calculation to figure out the return on two simple transactions, would you? Just take the percent change from the buy and sell price.

Now consider the following, much more realistic scenario:

  1. You buy 1,000 shares of The Walt Disney Company.
  2. The stock price goes down and you add to your position to decrease your average cost.
  3. You receive a dividend from the company.
  4. You buy more shares.
  5. You sell a fraction of your shares.
  6. The company does a stock split.
  7. You want to buy more shares but you don’t have enough cash in your brokerage account.
  8. You inject enough cash to increase your desired position.
  9. You buy the shares.
  10. The stock price rises above your estimation of fair value and you sell all your shares.

Instead of two simple transactions, this investment now involves nine. Now, what is your average cost for the number of shares you sold at transaction 5 and 9? What is the yield on your cost and not the current market price? What is your total return given the dividend received? Because you injected additional capital to your portfolio at transaction 7, what is the money-weighted return? How much of your return have you realized until transaction 8?

I simply couldn’t find an appropriate transaction-based portfolio tracker out there that could handle these kinds of questions. So I decided to create one myself.

I wanted four things out of the tool I was set to create:

  1. It should be really simple to use.
  2. It should require as little user inputs as possible.
  3. It should be powerful enough to answer all of the above questions.
  4. It should help me track my investment decisions.

I believe the Portfolio Tracker accomplishes these objectives very clearly. All you have to do is enter any transaction and incoming/outgoing cash flow to your portfolio and the rest is up to the Portfolio Tracker.

Oliver Sung from Junto Investments

As a bonus, I have added our Decision Log template in the Portfolio Tracker. You simply fill out the Decision Log and click ‘print’ to either print or save a copy of your decision. This is a very powerful tool to track your decisions and improve your thinking.

I hope you will find the Portfolio Tracker as useful as we do. If you find any errors, problems, or have any tips for improvement, please write to me at oliver@junto.investments. I would love your feedback.

Cordially,
Oliver Sung
Research Analyst

Simply enter transactions per line
Supports multiple currencies.
Transactions tab of the portfolio tracker
Register cash flows, injections, and withdrawals
Automatically calculate your true money-weighted return.
Keep track of your holdings, yields, and performance
Including your closed positions.
Portfolio holdings tab of the portfolio tracker
Overview tab of the portfolio tracker
Get a clutter-free overview of your holdings and cash allocation
See your money-weighted return over time.
Track your decisions and improve your thinking
Save a decision log for each investment.

It's the complete tool to track your transactions, flows, performance, and decisions.

Get the free stock portfolio tracker now.