The Portfolio Tracker spreadsheet does not natively support multiple currencies.

To manage currencies/foreign exchange in the spreadsheet, you can:

1. Use one workbook and enter everything in USD only (i.e., do the conversions yourself before entering)

2. Use multiple workbooks, one for each currency

3. Add the Fx conversions to the spreadsheet yourself. You can mostly do this just on the Transactions tab. If you do take the time to do this, let us know!