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

[Kalpesh Patel]

If you are somewhat  familiar with Python than take a look at https://github.com/ka-patel/dl_quotes GitHub repository to get quotes using command line in gnucash exportable format. Python is likely installed by default on your Ubuntu.

-----Original Message-----
From: Matthew Clay <mpclay at gmail.com> 
Sent: Friday, June 06, 2025 9:48 AM
To: sunfish62 at yahoo.com
Cc: David Carlson <david.carlson.417 at gmail.com>; Gnucash Users <gnucash-user at gnucash.org>
Subject: Re: [GNC] Retrieving Quotes for Specific Securities without Toggling 'Get Online Quotes'

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.
>>
>>
>>
>>