[GNC] Retrieving Quotes for Specific Securities without Toggling 'Get Online Quotes'

[Matthew Clay]

Dear David C. and David T.,

Thanks for the advice --- I didn't know that I could get prices with Google
and then import them via a csv file. I only care to update prices monthly,
so this should work well for me.

As for why I asked, I was trying to think of a way to get around the 25
quote limit of Alpha Vantage, since Alpha Vantage was the only quote source
that worked robustly for me when I tested my gnucash file on a newer Ubuntu
system (24.04.2 LTS). I wanted to get quotes in batches of 25 over, say the
weekend, without having to open up the gnucash GUI and toggle "Get Online
Quotes" for each batch of securities.

Sincerely,
Matthew

On Fri, Jun 6, 2025 at 12:39 AM sunfish62 at yahoo.com <sunfish62 at yahoo.com>
wrote:

> You can import prices as an option on the File->Import menu.
>
> It is relatively easy (for example) to create a spreadsheet in Google
> which has live price lookups, which can then be used to import prices into
> GnuCash.
>
> I don't know whether other spreadsheet apps have the same price lookup
> functions or not.
>
> I agree with David C., though. It seems like a lot of work for a minor
> gain in storage.  Perhaps you could explain why you want this?
>
> David T.
> On Jun 6, 2025, at 6:14 AM, David Carlson <david.carlson.417 at gmail.com>
> wrote:
>>
>> The only concern that I can think of from having prices saved in your file
>> that you don't plan to use would be a somewhat inflated file size.  If your
>> usage pattern would benefit substantially from saving only a few prices
>> regularly, it might pay to gather the prices that you want externally then
>> importing them into manually into GnuCash in a csv file.
>>
>>
>>
>> On Thu, Jun 5, 2025 at 9:24 PM Matthew Clay <mpclay at gmail.com> wrote:
>>
>>  Dear gnucash community,
>>>
>>>  From what I can tell, using either the "Get Quotes" button in the Price
>>>  Database or the command
>>>
>>>  gnucash-cli --quotes get <file>.gnucash
>>>
>>>  retrieves quotes for all securities that have the "Get Online Quotes"
>>>  option enabled. Is it possible to update quotes for a subset of securities
>>>  without having to toggle the "Get Online Quotes" for each one? Maybe
>>>  something like
>>>
>>>  gnucash-cli --quotes get <file>.gnucash AAPL AMZN
>>>
>>>  to just get the quotes for Apple and Amazon, and nothing else.
>>>
>>>  If this isn't possible, can quotes retrieved with commands like
>>>
>>>  gnucash-cli --quotes dump yahooweb AAPL
>>>
>>>  be saved to text files and later imported into a gnucash file?
>>>
>>>  Thanks,
>>>  Matthew
>>> ------------------------------
>>>
>>>  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.
>>
>>
>>
>>