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 <flywi...@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@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. > _______________________________________________ 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.
