Add a new column in the "Stock Performance" section to display the currency conversion return for stocks where transactions involve a different currency from the stock's quoted currency.
Details:
In scenarios where transactions are conducted in a currency different from the stock's quoted currency (e.g., purchasing a stock quoted in USD but the transaction is in EUR), the currency fluctuations can significantly impact the overall performance. Currently, this aspect is not displayed in the stock performance section, leading to an incomplete view of the portfolio’s performance.
Currently this can be tracked by booking a separate FX transaction (e.g EURUSD).
New Column:
Add a column titled "Currency Conversion Return" in the "Stock Performance" table.
This column should compute the P&L impact of currency conversion based on the historical FX rate at the transaction date compared to the current FX rate for each stock.
Leave a Comment