This document explains methodology of calculation for the Canopy website.
Market Data
Pricing data is provided by Bloomberg.
At 5.30am Singapore time (just after the last US exchanges closed) all End-of-Day price data for the previous day is downloaded.
All stored calculations will be done after this data has been made available.
All current information on the website relies on this latest available pricing information.
Whenever securities do not have daily prices available the calculations will revert to the last available price - however dated this may be.
Portfolio > Holdings
This screen is showing the allocation of assets in the portfolio.
This is based on the latest available price for the chosen date. The standard date setting is today.
All values are converted to base currency of the user.
All percentages are relative to the Total Assets, not the Net Worth, as Liabilities are excluded.
Portfolio > Performance > Profit / Loss
This chart shows the historical performance of two datapoints: The total amount invested and profit.
Total Amount Invested
relates to all Securities and are a simple measure of how in the market the accounts are. This excludes all cash and all loans.
Profit
is the absolute gain (or loss) in the account at current market values. This therefore includes realized as well as unrealized items.
Profit = Market Value - Net Fund Flow
where
Market Value = sum of all assets at latest price converted at latest FX rate into Base Currency
Net Fund Flow= sum of all Money Inflows or Outflows (or when security transfer, the monetary equivalent) converted to Base Currency at the timing of such flow.
Portfolio > Performance > Portfolio
each stacked item represents the market value of each category at the latest price and converted at the latest FX rate into Base Currency.
The Money Flow line here represents the same as Net Fund Flow mentioned earlier.
When all stacks are selected they will total up to the Net Worth of the Account.
All stacks less the Money Flow line are equal to the Profit line in the earlier page.
Portfolio > Performance > NAV
NAV is the Net Asset Value of the account expressed on a base of 100.
Net Asset Value
NAV0 = 100
NAVt =NAVt-1 * (1 + Net Worth Percent changet)
Net Worth Percent changet = (absolute change in Net Wortht - Net Fund Flowt) / Net Wortht-1
Net Wortht = market value of all assets and liabilities at latest price on t, converted to Base Currency on t
Net Wortht-1 = market value of all assets and liabilities at latest price on t-1, converted to Base Currency on t-1
absolute change in Net Wortht = Net Wortht - Net Wortht-1
Net Fund Flow = Sum of all money inflow, money outflow or security transfer free of payment in/out on t, converted to Base Currency on t
Security transfers free of payment will be marked at prevailing market price on the price of the transfer if no price has been supplied at the transaction level. If a price has been provided, such price will be used.
Portfolio > Holdings
Profit Till Date
The change in the value of the position based on the price.
All coupon flows are excluded. This only covers the current positions relative to it's average purchase price
Security Screen
Profit Till Now
The total life to date realized and unrealized profits or loss on this position.
Actual settled amounts are used for purchase and sale transactions.
Coupons and dividends are included.
Current market value includes accrued interest for bonds, i.e. dirty price is used.
All items are added up in contract currency (i.e. currency of the money flow) and converted to base currency at the current fx rate
Explainer > Realized Earnings
Coupons received
Sum of all payments marked as Coupon for which trade date of such payment is in the relevant period, converted to base currency at the fx rate on the last day of the period.
Dividends received
Sum of all payments marked as Dividend for which trade date of such payment is in the relevant period, converted to base currency at the fx rate on the last day of the period.
Profit from trades closed out
Realized moneys for transactions fully or partially closing out a position where the trade date of such closing out is in the relevant period.
The starting value will be assumed the average purchase price of such position - not the price at the beginning of the relevant period.
Deposit Interest
Sum of all payments marked as Interest or DepositInterest for which trade date of such payment is in the relevant period, converted to base currency at the fx rate on the last day of the period.
Loan costs
Sum of all payments marked as LoanInterest for which trade date of such payment is in the relevant period, converted to base currency at the fx rate on the last day of the period.
Miscellaneous income
Sum of all payments marked as MiscIncome or MiscExpense for which trade date of such payment is in the relevant period, converted to base currency at the fx rate on the last day of the period.
Explainer > Unrealized Earnings
Coupons accrued but not received
Profit on outstanding positions
Forex impact on cash items
Explainer > Net Fund Flow