Re: [GNC] Importing historical stock prices to GnuCash in Windows
You may want to look at https://github.com/ka-patel/dl_quotes/tree/main/yfinance which is Python based... -Original Message- From: sunfis...@yahoo.com Sent: Friday, May 10, 2024 2:59 AM To: Leung Wing Cheong Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Importing historical stock prices to GnuCash in Windows Of course there is. The csv importer can handle any price data, including historical data, as long as you supply the proper dates along with the other data elements. The challenge is gathering that price data in the first place. It used to be possible to retrieve unlimited price quotes from a number of online sources, but those days are gone, sadly. At one point in the past, I used a perl module to retrieve monthly prices for all my commodities and put them into the GnuCash price history, but the module depended on Yahoo!, which no longer allows that level of data gathering. David T. On May 10, 2024, 6:17 AM, at 6:17 AM, Leung Wing Cheong wrote: >Hi, >Is there any way to import historical stock prices to GnuCash in >Windows? >Thanks, >Wing >___ >gnucash-user mailing list >gnucash-user@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. ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Importing historical stock prices to GnuCash in Windows
Further to the point, I've used Google Sheets financial functions to retrieve stock prices pretty quickly. Those functions can pull prices for any given date, so you could set some dates and import them that way. It's not ideal, but it could get things done in a pinch. David T. On May 10, 2024, 11:31 AM, at 11:31 AM, Leung Wing Cheong wrote: >Got it, many thanks! >Wing > >-Original Message- >From: sunfis...@yahoo.com >Sent: Friday, May 10, 2024 2:59 PM >To: Leung Wing Cheong >Cc: gnucash-user@gnucash.org >Subject: Re: [GNC] Importing historical stock prices to GnuCash in >Windows > >Of course there is. The csv importer can handle any price data, >including historical data, as long as you supply the proper dates along >with the other data elements. > >The challenge is gathering that price data in the first place. It used >to be possible to retrieve unlimited price quotes from a number of >online sources, but those days are gone, sadly. > >At one point in the past, I used a perl module to retrieve monthly >prices for all my commodities and put them into the GnuCash price >history, but the module depended on Yahoo!, which no longer allows that >level of data gathering. > >David T. > >On May 10, 2024, 6:17 AM, at 6:17 AM, Leung Wing Cheong > wrote: >>Hi, >>Is there any way to import historical stock prices to GnuCash in >>Windows? >>Thanks, >>Wing >>___ >>gnucash-user mailing list >>gnucash-user@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. ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Importing historical stock prices to GnuCash in Windows
Got it, many thanks! Wing -Original Message- From: sunfis...@yahoo.com Sent: Friday, May 10, 2024 2:59 PM To: Leung Wing Cheong Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Importing historical stock prices to GnuCash in Windows Of course there is. The csv importer can handle any price data, including historical data, as long as you supply the proper dates along with the other data elements. The challenge is gathering that price data in the first place. It used to be possible to retrieve unlimited price quotes from a number of online sources, but those days are gone, sadly. At one point in the past, I used a perl module to retrieve monthly prices for all my commodities and put them into the GnuCash price history, but the module depended on Yahoo!, which no longer allows that level of data gathering. David T. On May 10, 2024, 6:17 AM, at 6:17 AM, Leung Wing Cheong wrote: >Hi, >Is there any way to import historical stock prices to GnuCash in >Windows? >Thanks, >Wing >___ >gnucash-user mailing list >gnucash-user@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. ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Importing historical stock prices to GnuCash in Windows
Of course there is. The csv importer can handle any price data, including historical data, as long as you supply the proper dates along with the other data elements. The challenge is gathering that price data in the first place. It used to be possible to retrieve unlimited price quotes from a number of online sources, but those days are gone, sadly. At one point in the past, I used a perl module to retrieve monthly prices for all my commodities and put them into the GnuCash price history, but the module depended on Yahoo!, which no longer allows that level of data gathering. David T. On May 10, 2024, 6:17 AM, at 6:17 AM, Leung Wing Cheong wrote: >Hi, >Is there any way to import historical stock prices to GnuCash in >Windows? >Thanks, >Wing >___ >gnucash-user mailing list >gnucash-user@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. ___ gnucash-user mailing list gnucash-user@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.
[GNC] Importing historical stock prices to GnuCash in Windows
Hi, Is there any way to import historical stock prices to GnuCash in Windows? Thanks, Wing ___ gnucash-user mailing list gnucash-user@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.
