Excel Portfolio Tracker

[ChrisF]

Hey everyone,

I have created a Portfolio/Investment Tracker in Excel and thought I would share it here.

Before explaining everything, I should mention a couple of things first:

• It requires a premium subscription to Microsoft Office 365. (There are ways to get it for free, such as if you are a student)
• Due to the fact that many months and long hours were put into learning Excel and creating this workbook, I’ve listed it on Etsy for a reasonable amount and that is why it’s not for free.

With that said, let me explain everything.

P.s If you have any questions, feel free to leave a comment below.

How it works

1. Portfolio’s Currency is selected
2. History is inputted either with a CSV file (T212 format works) or manually
3. Each investment’s information is specified (Asset Class, Region, Sector, etc.)
4. All data are then calculated automatically based on the above information.

Supported Investments

• Stocks
• Cryptocurrencies
• Bonds
• ETFs
• REITs

Supported Currencies
(For all Portfolio and Individual Investments)

• EUR
• USD
• GBP
• CAD
• CHF
• AUD
• NZD
• GBX (Only for Individual Investments)

17 Tabs/Sheets
(almost all w/Automatic calculations)

Main Features - Video

►Dashboard

• Portfolio Value and Returns
• Customizable Notifications
• Daily Changes
• Portfolio chart of Past 12 Months
  
  

►Portfolio

• Total Portfolio Info (Value, Cash, Forecasted Growth etc.)
• Info for each holding (Allocation, Value, Quantity, Price, Total Return, Invested Amount etc.)
  
  

► Desired Portfolio
The portfolio allocation you would like to have

• Capital Allocation, Forecasted Growth
• Current Allocation of Investments
• Rebalancing Required
  
  

►Pies
Use Pies to bundle investments (e.g. all ETFs in a Pie)

• Track up to 3 Pies
• Current allocation within Pies, Rebalancing Required
  
  

►Allocation

• Allocation of Current and Desired Portfolio
• Allocation across each Category (Sectors, Asset Classes, etc.)
  
  

► Tickers Info (Manual Input)

• Specifying basic info for each Investment
  
  

►Crypto Portfolio

• Holdings Value, Total Return, Forecasted Growth
• All current crypto holdings and their Info (Value, Quantity, Price, Total Return, Market Cap, Supply etc.)
• Market Data of the Top 10 Cryptos (by Market Cap)
• Compare Cryptos
  
  

►Transactions/Trades/Dividends History

• Inputting portfolio’s history (Transactions, Trades, Dividends)
  
  

►Returns

• Returns Data for Portfolio and Holdings:
• Capital, Currency, and Dividend Gain
• CAGR
• Annual Return for current year
• Benchmark Tracking through Chart
• Returns per Category (Sectors, Asset Classes, etc.)
  
  

►Dividends

• Expected Dividends by Month
• Upcoming Payments for this month and next 12 months
• Dividend Data for Portfolio and Holdings:
• Yield
• Yield on Cost
• Dividends Received etc.
  
  

►Calculators

• Future Portfolio Value
• Years to Reach Goal
• Annual Return to Reach Goal
• Amount Invested to live off Dividends
• CAGR
• Discounted Cash Flow (DCF)
• Live Currency Converter
  
  

►Valuation

• Valuation Data for Portfolio and Holdings:
• PE, Beta, PEG
  
  

►Screener

• Screener for all Tickers ever traded based on criteria
  
  

►Annual Reports - PDF Example

• Reports for the past 10 years
• Performance Data for Portfolio and Holdings
• 1Y Performance
• Total Return etc.
• Export A4 PDF report
  
  

►Watchlist

• Up to 10 Tickers to track
• Set-up Price Alerts and receive notifications in Dashboard
• Compare Stocks
  
  

►Customization and Info

• Possibility to edit:
• Sectors
• FX Rates
• Notifications to receive
  
  

►Guide

• Guide on how to use the workbook
  
  

[Dougal1984]

Looks good, but did you not already post this the other day?

Excel Portfolio Tracker

Hey everyone, I have created a Portfolio/Investment Tracker in Excel and thought I would share it here. Before explaining everything, I should mention a couple of things first: It requires a premium subscription to Microsoft Office 365. (There are ways to get it for free, such as if you are a student) Due to the fact that many months and long hours were put into learning Excel and creating this workbook, I’ve listed it on Etsy for a reasonable amount and that is why it’s not for free. With …

Portfolio Tracker App

If you don’t mind using Excel, I’m using a workbook that I created (which took more than 6 months to complete ). I wanted something as simple as possible to use, yet advanced in the information it provides, but couldn’t find any platform to give me all the info I need. So, I’ve decided to create my own lol. You choose your portfolio’s currency, you add your Transactions, Trades, and Dividends, and some info for each ticker, and you are good to go. I’ve also used the T212 CSV format…

It will get confusing to gather feedback if you post on multiple threads.

[ChrisF]

Thank you for your comment, and yes, you are right regarding the feedback.

I did post this on multiple threads, where either the main topic or the discussion was regarding tools to track a Portfolio, as I believed people within would find this helpful. However, after mentioning it in different threads, I created this post in order to explain this tool further in detail and provide all the information here.

[Ron74]

How about updates and fixes, how do you provide these?

[ChrisF]

Hey Ron, thank you for your comment.

• All the feedback provided by the users, either this is regarding some issue with the workbook or requests for new features, is being noted, and new versions are created.

• Once the new version is tested and working properly, it is then sent to all the users through email.

The email address where the user wishes to receive the updated versions is provided during the purchase:

[pintas]

Hi,
I believe it can be a nice tracker. There is any way we can try a few days?

[ChrisF]

Hey!

Currently, there is no option available for a trial period, as this is a digital download.

Although, as it would be a good option to have before the purchase, I may create a free trial version in the future (the same workbook with only some of the features).

If a trial version is created, I can let you know if you want.