1
$\begingroup$

I have a spot currency exchange account where the base currency is USD and where I can deposit and/or withdraw money from the account in any currency at any point in time. I can also exchange any currency to another at the market spot rate.

What is the best performance measurement to calculate the daily rate of return given that I can deposit/withdraw at any time, and can partially or completely trade an investment in one currency into another?

I have been looking at the time-weighted return (TWR), Modified Dietz method, and the IRR. However, I am not entirely sure which (if any) is the best way to calculate a daily rate of return series.

$\endgroup$
0
$\begingroup$

I think the best way to handle this is to pretend that your account is a Mutual Fund or other collective investment vehicle that is in principle available for others to invest (even though in practice, for now, you are the only investor).

This means keeping track of two things, the number of "shares" outstanding and the Net Asset Value per share on a daily basis. (The NAV should be expressed in your "base currency", which is the currency you use on a daily basis to buy food, pay taxes, etc.).

The initial number of shares can be arbitrary (such as 10000 shares).

On any day in which you invest additional funds, at the close of business you compute the NAV/sh by valuing all securities in the portfolio (other thn the incoming cash) and dividing by the (previous) number of shares outstanding. You then issue yourself new shares in the amount of your investment divided by the NAV. You update the number of shares outstanding.

Vice versa when you withdraw money from the account you decrease the number of shares outstanding.

To compute returns between any two times of cash inflow/outflow (or two periods of complete portfolio valuation) you use the percentage change in NAV. For longer periods you can link the returns by the usual geometric linking formula.

This method will give you a perfectly accurate Time Weighted rate of return. On problem is that it is a lot of work, especially if you want daily NAVs. The other method you mention, the modified Dietz method could be used as an approximation if you think the full NAV method is too labor intensive. For example you could value the portfolio only on a monthly or quarterly basis. So it depends how much work you want to do.

$\endgroup$

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.