Get stock quotes for specified date

[David T.]

John,

It may be that Stefan refers to https://wiki.gnucash.org/wiki/Stocks/get_prices <https://wiki.gnucash.org/wiki/Stocks/get_prices>. As you note, it uses Finance::QuoteHist instead of F::Q. Finance::QuoteHist does still work with the sources you mention, although I cannot comment about the wiki script, since I do not have Python bindings enabled on my Mac.

Cheers,
David

> On Dec 10, 2016, at 3:32 AM, John Ralls <jralls at ceridwen.us> wrote:
> 
> 
>> On Dec 9, 2016, at 1:30 PM, Stefan Söffing <soeffing at gmx.de> wrote:
>> 
>> All,
>> 
>> the price editor currently is able to retrieve today's stock quote for
>> the price db. Sometimes it can be useful to retrieve stock quotes for a
>> specified historic date, e.g. to update the prices for the last day of
>> the financial year as a basis for reporting using the "Nearest in time"
>> price source.
>> 
>> I'd like to suggn time"
>> price source.
>> 
>> I'd like to suggest to add this feature by introducing a new pop-up
>> window with a date selector to the "Get Quotes" button (similar to the
>> "remove old" pop-up). I understand that there is an example script
>> delivered with GnuCash to serve a similar purpose, i.e. retrieving a
>> series of quotes over a given time-period, so obviously the
>> Finance::Quote part is able to handle historic data as well.
>> 
>> If this is considered a worthwhile enhancement I'd be happy to assist in
>> implementation. Unfortunately, however, I figured out that the relevant
>> part is scripted in Scheme. While I do have some (long-forgotten)
>> experience with C, that scm language thing looks quite cryptic to me.
>> Nevertheless if someone was willing to adapt the scheme part I'd like to
>> try my best in supporting the C development part as much as possible...
>> 
>> Thanks for listening.
> 
> Stefan,
> 
> Sorry, you're misinformed. There is no such example script and Finance::Quote [1] is able to retrieve only the latest price. There is in CPAN a package called Finance::QuoteHist [2], but it hasn't been maintained since 2013 and so is unlikely to work as-is. Note as well that it has only two modules, Yahoo and Google, far fewer that Finance::Quote gnc-fq-helper, a perl applet, would need to be modified to optionally call QuoteHist instead of Quote when a date is provided and to format the results for quotes.scm. The latter would need only a change to pass the selected date to gnc-fq-helper. The UI changes would be in C, to src/gnome/dialog-price-edit-db.c, and in XML, to src/gnome/gtkbuilder/dialog-price.glade.
> 
> Regards,
> John Ralls
> 
> [1] http://search.cpan.org/~ecocode/Finance-Quote-1.38/lib/Finance/Quote.pm
> [2] http://search.cpan.org/~msisk/Finance-QuoteHist-1.20/lib/Finance/QuoteHist.pm
> _______________________________________________
> gnucash-devel mailing list
> gnucash-devel at gnucash.or