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
_______________________________________________
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.