...
In most cases we use pricing data as provided by Bloomberg. Currently we take a single snapshot every business day at around 5.30am Singapore time (just after the last US exchanges closes). In future we intend to use streaming data.
For most of the securities we price, price data is available from Bloomberg. For securities where a price is not provided by Bloomberg (e.g. most privately owned securities, a lot of hedge funds, real estate and other non financial assets, most OTC derivatives etc.) we use the last available price from the relevant statement (from the bank, and for non financial assets like real estate and art collections, from the user). We are working on a feature where users will be able to switch exclusively to statement as a price source, even if Bloomberg data is available (as some users have requested this ease of reconciliation with their accounting statements which usually run on bank valuations).
In case of bonds, we take both clean price and dirty price (which is clean price + accrued interest) from the data feed. Therefore, by implication, the accrued interest on a bond is calculated only till the last available price date (i.e. we do not manually calculate and keep adding accrued interest to bonds that are illiquid and there no price data)
Unless otherwise specified, we value off trade date (and not settlement date). In the menu Portfolio->Holdings there is a toggle to switch between Trade Date and Settlement Date snapshots.
All end of day calculations are done after the pricing data has been downloaded.
Portfolio >
...
Allocation
This screen is showing the allocation of assets in the portfolio.
...
All values are converted to base currency of the user.
All percentages in the donut charts are relative to the Total Assets,not the Net Worth, as Liabilities are excluded.
...
This chart shows the historical performance of two datapointsdata points: 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 This is intended to be a measure of risk and only shows the 'risky assets', i.e. assets where the price is expected to move (this includes all traded securities and all non financial assets).
All risky assets are counted at the market value as of the relevant date. The intention of this graph is to show whether risky assets were being added or reduced over the time period in question. This measure is somewhat crude because it does not attempt to give a 'risk weight' to each asset (e.g. US Treasuries and a High Yield Junk Bond will get a weight equal to their market value in this graph)
Total Amount Invested ignores assets which are not considered 'risky' i.e. all cash and all deposits. It also ignores 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.
...
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 market value of the position based on the price.compared to the settlement amount paid for it. In most cases this is
Profit till date for all securities except bonds = Quantity x (current_price - average_purchase_price)
In case bonds where we consider accrued interest and the formula becomes
Profit till date for all securities except bonds = Quantity x (current_dirty_price - average_purchase_dirty_price)
All coupon flows are excluded. This only covers the current positions relative to it's average purchase price
...
Coupons and dividends are included on the basis of actual entry in the relevant bank account (i.e. in case there was a tax deduction and a smaller amount was paid into the account, we only consider that smaller amount which was actually credited)
Current market value includes accrued interest for bonds, i.e. dirty price is used.
...
Realized moneys for transactions fully or partially closing out a position where the trade date of such closing out is in the relevant period. Currently we do not calculate partial close of position in this amount.
The starting value will be assumed as the average purchase price of such position - not the price at the beginning of the relevant period.
...