Portfolio Tracker
Released in v0.2
Last updated
Released in v0.2
Last updated
Description: Visualize all your investments within one dashboard
Use Case: View your portfolio's historical performance, identify key metrics, and invest smarter
Page: /investment/portfolio
When you first enter, you will see an empty dashboard. Before you start, you will need to create a new portfolio.
As you can see from the top, there is also an option to import via CSV. Note that you will have to follow a specific format so make sure to download the template and use the format there.
Template Guidelines:
type - BUY or SELL only
ticker - <exchange:symbol> format. For example: NASDAQ:PLTR or SGX:D05
transactedAt - DD/MM/YYYY format
quantity - self-explanatory
cost - cost per share transacted
fees - self-explanatory
If there are any error transactions, you will be shown a table once all the data is processed, as well as the error reason for which each transaction failed. You can download the error entries and rectify the issues before resubmitting again.
The portfolio tracker will be updated daily to reflect the latest metrics and information. This includes re-ordering all the transactions if any new ones were added or existing ones were edited. It will also recalculate your overall portfolio's performance daily. This ensures that the portfolio tracker is updated and shows the correct numbers.
Under Portfolio Allocation, you can categorize your stocks into custom groups. Simply type in the name of the group and click the button next to it. You will then see a few things such as the current and target allocation for each group, as well as any unassigned stocks below.
To update these values, click the edit allocation button. You will be able to do a few things from here:
Update the target allocation for all your groups (must total 100%)
Delete any groups you don't want anymore
Assign stocks to a specific group by clicking the dropdown
Once you are done, simply click the save changes button to apply the changes made. Else, you can click the cancel button to revert any changes made.
Within each group, you can also assign a target allocation for each stock within the group. Note that this target allocation is calculated using the group's total value, not the entire portfolio's total value.
Released in v1.0
After inputting your first stock transaction, the Rebalance button will appear in the Portfolio Allocation section. Once you have assigned all stocks into respective groups and allocated a target % for each stock and group, you will be able to utilize the Rebalance feature. If you have not, within the modal, you will be prompted to fill up any missing data before you can utilize this feature.
In the modal, you will find all the target allocations you have assigned to each group and stock within the group itself.
Upon clicking on the rebalance button, you will be shown the changes that need to be made to help you achieve your target allocation. On default, the algorithm will do a mixture of buys and sells to help you achieve your target allocation. As you can see from the image above, it will tell you how much of each stock to buy/sell, indicated by the colour and the + or - symbol. You will then be able to see the value of the position and the end allocation after performing these transactions, which should match your target allocation.
Alternatively, you can check the box that states to "Rebalance with Buy trades only?" which will alter the algorithm to only utilize buy trades to help you achieve the target allocation instead. As you can see from the image above, it only indicates buy trades to help you achieve the target allocation you've set for each stock and for the overall group as well.
Notes:
The portfolio tracker and transactions will be updated daily at 8 AM SGT
Realized Profit/Loss is calculated using the average cost method rather than the FIFO/LILO/LIFO method
The average cost per share takes into account the realized profits/losses
Markets/Exchanges Supported: SGX, NASDAQ, NYSE
Further Updates/Improvements to come:
Historical data is being added slowly as it is difficult to aggregate and reconcile missing dates, holidays, and such
Support for Options transactions
More dashboard metrics such as portfolio yield, max drawdown, and annualized performance
