[GNC] Importing stock prices from a CSV file

[Ove Grunnér]

Hi,

if it helps,

this is what an import file can look like when importing stock prices.
the name space for stocks is the same name space you see in the security
editor
Menu -> Tools:Security Editor.

So if you call the namespace for a stock e.g. NASDAQ when you create the
stock, then that will be the name space you need when importing stock
prices.

file example
Account_Name,Rate,Balance Currency,Date,Name Space
ALV.DE,207.95,EUR,2023-06-10,Euronext
AMZN,123.43,USD,2023-06-10,NASDAQ
ASML.AS,666.6,EUR,2023-06-10,Euronext
AZN.ST,1598,SEK,2023-06-10,StockholmsBorsen
BAS.DE,46.02,EUR,2023-06-10,Euronext
CA.PA,26.52,EUR,2023-06-10,Euronext




Kind Regards,

Ove.






On Sat, 30 Sept 2023 at 22:31, flywire <flywire0 at gmail.com> wrote:

> The process works but the Price Import Assistant Summary description and
> poor user interface labels are confusing. I use csv import all the time but
> this is so bad I can't understand it.
>
> [the minimum columns] are Date, Amount, From Namespace, From Symbol and
> Currency To. If all entries are for the same Commodity / Currency then you
> can select them and then the columns will be Date and Amount...
>
> Examples are "FTSE","RR.L","21/11/2016",5.345,"GBP” and
> CURRENCY:USD;2016-11-21;1.56;GBP
>
> Isn't FTSE an index and what is the .L ? So currency can be prefixed with
> CURRENCY: ?
>
> I don't understand the data (except date and amount) which means I can't
> understand the column format example. It would be a lot clearer if the
> columns were in the same order as the description, and even better with a
> header line, so the data didn't have to be understood to understand
> the columns.
>
> I still have no idea what the file would look like when all entries are
> the same commodity...
>
> Surely this process should support the default currency like elsewhere in
> GnuCash and the column names are absurd.
>
> Thanks Ken. That link had a nice clear example but it will not work now
> without the From Namespace (coder jargon for Stock Exchange).
>
> I just tested with the following CSV:
> AAPL,23/8/2018,USD,255.37
> ABF.L,23/8/2018,GBP,25
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at 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.
>