[GNC] importing prices from csv

[D.]

Every stock has a Namespace in Gnucash. "NYSE"  "NASDAQ" are examples. 

I have an online spreadsheet into which I can paste my Advanced Portfolio data, and then a second worksheet in the file compiles the prices for the result set, which can be cut and pasted locally for import. 


-------- Original Message --------
From: George Riner <georgeriner at mycogeo.com>
Sent: Wed Mar 16 19:47:26 EDT 2022
To: Gnucash Users <gnucash-user at gnucash.org>
Subject: Re: [GNC] importing prices from csv

Thanks.

One question... I don't know what is "the entry from Gnucash" ? err... 
what entry from Gnucash?

:George

On 3/16/2022 2:59 PM, D. wrote:
> I am able to import prices from csv with a four column source:
>
> Ticker,  Namespace, Price,  Date
>
> Namespace is the entry from Gnucash.
> ------------------------------------------------------------------------
> *From:* George Riner
> *Sent:* Wed Mar 16 11:36:14 EDT 2022
> *To:* gnucash-user at gnucash.org
> *Subject:* [GNC] importing prices from csv
>
> My specs:
>
> Platform: Windows 10 (64-bit) build 19044.1586 (32Gb RAM)
> Gnucash: 4.9+(2021-12-18) Enaaglish
> Finance Quote: 1.51a
> I live and work in California, USA.
>
> I've been trying to use the "Import Prices from a CSV file..." tool.
> I've got a CSV with symbols ('ticker symbols'?) and prices, and it
> includes the name of the fund that the ticker symbol is for.
> It has a 'date' column for the date of the fund price.
> It has a column for 'Amount' that is the price of that fund.  The prices
> are in USD.
>
> I set "Currency To" to "USD (US Dollar)" in the drop down above the
> panel where it shows the rows of the CSV
>
> But I'm stumped what "Commodity From" is supposed to be. The CSV has
> prices (in USD) for various different funds - are funds commodities? If
> I pick "USD (US Dollar)" for Commodity From, the error is "Commodity
>   From can not be the same as 'Currency To'". Looking through the list
> offered in the 'Commodity From' drop down, I see all sorts of currencies
> and securities I've entered through the Security Editor.  What am I
> supposed to pick?
>
> :George
> California, USA
>
> ------------------------------------------------------------------------
>
> 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
> If you are using Nabble or Gmane, please seehttps://wiki.gnucash.org/wiki/Mailing_Lists  for more information.
> -----
> 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 at gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.