I’ve been using PP for some time now. The currency for my cash account is GBP and the securities I hold are priced in a number of currencies including GBX.
Recently I set up a new XML file with the idea that this replicates most of the contents of my existing PP file. Using the CSV Export Routine (as is available from the drop-down menu) I was able to generate a CSV file for each securities and cash account.
I had no problem importing the CSV file for the securities account into the new XML file. However I’m unable to perform the import process for the cash account, since some of the transactions that feature in this aren’t priced in my base currency (GBP) – as a result the import routine is aborted and the message ‘Exchange Rate of Gross Vale is missing’ is displayed.
I’ve referred to the manual which features a very useful section on importing dividends from a csv file, highlighting that a number of details are needed to import foreign dividends: the currency gross amount (the type of foreign currency), the gross Amount (of the foreign currency), and the exchange rate. Yet, none of this information is contained in the cash account csv files generated by PP.
I had hoped that I could get this information from the main pane instead, but no joy – it isn’t provided here.
I’m hoping someone can help with this - any thoughts and/or suggestions will be appreciated