[GNC] Importing CSV exchange rate prices

[Andrew Beattie]

Hi all

I’m successfully importing stock prices in multiple currencies into gnucash, but can’t seem to find a way to import exchange rates.  I’ve tried setting namespace to “Currencies” which is what’s used in the price editor, but the import routine highlights any line with namespace Currencies in red and says not all fields could be parsed.  

Is it possible to import exchange rates in this way - I’ve down quite a bit of googling on it and not found an solution.

Many thanks

Andrew

PS - Here’s an example of the contents of a CSV file where the first two lines of data are parsed and imported, but the third fails as above.

Namespace	Security	Date	Currency	Price
LSEETF	FTSE Dev Eur	31/10/2024	GBP	33.12
NASDAQ	NVDA	31/10/2024	USD	135.40
Currencies	USD	31/10/2024	GBP	0.77