[GNC] Importing CSV exchange rate prices

[Jim DeLaHunt]

Andrew:

On 2024-11-02 05:27, Andrew Beattie wrote:
> 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.

Simple, just look in the GnuCash tutorial and guide, section 9.6. 
Setting Share Price 
<https://gnucash.org/viewdoc.phtml?rev=5&lang=C&doc=guide>... oh, 
nothing there about importing prices.

Ah well, at least the GnuCash wiki has an article "CSV Import/Export", 
with section 1.3 "Importing Prices" 
<https://wiki.gnucash.org/wiki/CSV_Import/Export#Importing_Prices>... 
oh, that section is empty.

Well, I know that I used to import currency exchange rates from my 
currency to a couple of other major currencies in the past, but I don't 
have notes at hand about exactly how I did it.

You are using the menu item File… Import… Import prices from a CSV 
file…, right?

The first page of the price import assistant has an example currency 
import table:
CURRENCY;USD:2016-11-21;1.56;GBP

Do your CSV file lines have those columns? Do the instructions on that 
page help?

If you do figure something out, I encourage you to write instructions in 
the above Wiki page on CSV Import/Export. Whatever you can contribute, 
it will be better than literally nothing.

Best regards,
      —Jim DeLaHunt