I need to import transactions from my UK brokerage’s CSV file into PP. The brokerage operates in British pounds (so all PP accounts and all transaction amounts are in GBP), while all stocks are US-based and quoted in USD.
Since the brokerage handles currency conversion and gives me statements in GBP, I don’t have the original US prices or exchange rates used. After testing PP’s csv import, I realised that it uses whatever exchange rate I provide to calculate USD security prices only for charting transactions. These calculated prices only affect the chart display (green/red triangles) but don’t impact P/L calculations or performance statistics, even if the csv exchange rate is totally wrong.
My question: is it possible for PP to automatically calculate USD amounts/prices for transactions using exchange rates from its data provider rather than those from the CSV import file? If not, would there be any downside to using the same average exchange rate in csv file for all transactions? I am comfortable with transaction chart triangles being displayed within (say) 20% of their true price levels, but obviously I don’t want to have incorrect P/L calculations or other statistics…