What is the best methodology for modelling with several currencies in the account and securities with different currency denominations in a portfolio?
I'm happy to play around with the details but could really do with advice on the general approach from a blotter expert.
Apologies if this has been covered elsewhere. I searched and couldn't find it.
Example: A universe of 5 stocks in USD and 5 stocks in EUR. Create a strategy that trades the 5 highest % EUR returns in last 3 months (i.e. USD stock return is both stock and fx return).
An account in blotter has only one currency.
A portfolio also has only one summary currency.
instruments each have a currency.
A portfolio may hold instruments in any currency, but the portfolio summary will only be marked in the summary currency.
An account may hold many portfolios.
Given your example, it is likely that you would want separate portfolios for your EUR and USD instruments, and mark the account in whatever currency is convenient for the account.