[GNC] "Get Quotes" from the price database feedback

Kalpesh Patel kalpesh.patel at usa.net
Fri Jan 20 23:14:05 EST 2023


Since I needed a multi-purpose historical quote downloader, I had written up a python script that downloads them and write out in to various formats.  

 

Attached is the source code which required yahoo_fin and lxml python modules to work correctly. It can be provided with two options in fixed order, the first is the file name to read the tickers symbols from and second is number of days of historical quotes to download. 

 

From: Fred Tydeman <tydeman.fred at gmail.com> 
Sent: Tuesday, January 10, 2023 10:54 AM
To: Kalpesh Patel <kalpesh.patel at usa.net>
Cc: Geoff <cleanoutmyshed at gmail.com>; gnucash-user at gnucash.org
Subject: Re: [GNC] "Get Quotes" from the price database feedback

 

Have you considered using a Google spreadsheet along with:

 

GOOGLEFINANCE("NASDAQ:GOOG", "price", DATE(2014,1,1), DATE(2014,12,31), "DAILY")

GOOGLEFINANCE("NASDAQ:GOOG","price",TODAY()-30,TODAY())

It lets you get the prices on a range of dates.

 

-------------- next part --------------
A non-text attachment was scrubbed...
Name: get_historic_quotes.py
Type: text/x-python
Size: 4171 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20230120/31e1e922/attachment.py>


More information about the gnucash-user mailing list