ashchan / returns

Track your multiple investment or portfolios and calculate returns in one place.

Portfolio Returns

Portfolio Returns is a financial app for macOS that helps you track your multiple investment or portfolios in one place.

It's inspired by return spreadsheet built by Bogleheads forum member longinvest. To learn more about how it computes returns, see Bogleheads wiki page Calculating personal returns.

Features

• Track your multiple investment or portfolios in one place.
• Compute investor return (money-weighted return, internal rate of return).
• Compute portfolio return (time-weighted return, comparable return).
• Show portfolio returns for 1 month, 3 months, 6 months, year-to-date (YTD) and 1 year.
• Show portfolio returns for 3 years and up to 50 years.
• Calculate and show growth of $10,000 chart.
• Import and export portfolios as JSON.

Download

Requires macOS 11 Big Sur or later.

Usage

1. Create a portfolio.
2. Add one or more accounts.
3. At the close of the last day of each month, add total contributions, total withdrawals and account balance to each account.
4. Sleep well. Do not watch your portfolio. Let it perform.

System Requirements

Portfolio Returns is developed and built with SwiftUI. To use this app, be sure your Mac is running macOS 11 Big Sur or later.

License

Portfolio Returns is available under the MIT license. See the LICENSE file for more info.

returns's Issues

Calculations View

Implement this calculations view, with those hidden balance columns:

1mo/3mo - 50yr, flow, count and internal rate of return will be implemented as another future task.

Demo video (in Chinese localization)

Portfolio.Returns.Demo.mp4

Auto generate missing months

Run (if performance is not a concern this could be done on every launch) and generate missing months and most recent month (empty) record.

Calculate Investor return (MWR)

POWER(1+IRR(Cash flows,0.01),Min(12, total months))-1

• Implement IRR function
• Generate monthly cash flows

Calculate Portfolio return (TWR)

Compute the following returns:

• 3 months
• 6 months
• YTD
• 1 year
• 3 years
• 5 years
• 10 years
• 15 years
• 20 years
• ...

Do not allow multiple windows

• Remove File - New Window menu item
• Add Window - Main Window (CMD + 0) menu item

Portfolio Accounts Total Pie Chart

Display overview of accounts balance under the same portfolio.

Calculations View - 1mo/3mo - 50yr, flow, count and internal rate of return

Add these returns to calculations view when #16 is complete.

Growth chart not update after portfolio start date changed

v1.0 Submission

• Meta data, screenshots and description etc
• Submit
• #52
• Tag v1.0

Example portfolio

User can generate a sample with one click to see how the app works.

Extract balance data out of portfolio/account

Aside from close date balance, withdrawals and contributions (thus flows) should also be included.

issue: Account page: cell board doesn't move when dragging

Sidebar selection management

App icon

Replace spacenation/swiftui-charts with danielgindi/Charts

Apparently a more powerful charts lib is needed.

Note: no need to polish the growth chart for now.

Portfolio Overview view layout

Polish the UI

10,000 return?

The app seems to assume some sort of 10,000 investment baseline. I highly doubt this at first glance random number will help. For me, I do know that it gives me incorrect calculations for 1+ years of return.

Let's make a way to disable that?

Credit original returns spreadsheet and author

https://www.bogleheads.org/forum/viewtopic.php?p=6362210#p6362210

Import/export JSON for backup/restore

TODO

• export
• import
• localization

• Since CloudKit sync will not be implemented this would be the option to move data cross devices
• It also allows to do regular backups to avoid data loss

Note CSV import might not be easy to do. The original excel/gdoc files don't have a good CSV output.

Instead of CSV, the format would be JSON to simply represent CoreData data.

After editing the balance column and pressing the Enter key, focus the next row balance column

This allows to input many months' records quickly.

Portfolio Growth Chart

$10,000 growth chart

Create none-SwiftUI cell views to make table view more performant

Current SwiftUI views for cell are too laggy.

Chinese localization

Big Sur issues fix

• Portfolio toolbar configure button now showing up (folder.badge.gearshape not supported?) #49
• Welcome view markdown text not rendered #50
• Delete confirm dialog appears twice #51
• [ ] Others?

Fix timezone handling

Use current calendar will break if user switches timezone.

Individual account performance

Hey! The app looks great, thanks for spending time to develop it!

Is there a way to track the individual performance of an account, in addition to the overall? Much useful feature.

Welcome view (initial view)

It displays when there's no portfolio selected.

Idea: put descriptive texts such as usage, introduction to the excel doc, etc.

Refine sidebar

Use section to represent a portfolio.
See if selection color can be customized.

Fix Calculations table column localizations for English