Re: [GNC] Finance::Quote enters previous day's price as today's

2020-06-28 Thread Matthew Forbis via gnucash-user
Colin, For some reason the original email you sent through to the list in reply didn't make it to my email inbox, I just happened to see it referenced in a different email.  For your benefit and everyone else, where is the powershell script I am using to retrieve quotes from Alphavantage for

Re: [GNC] Finance::Quote enters previous day's price as today's

2020-06-25 Thread Colin
Given these complexities and limitations, I will probably just import price history CSVs periodically. That avoids the possibility of populating the price database with faulty data. It looks like yfinance is super simple to use in Python. I'll just create a script to create a CSV with it and

Re: [GNC] Finance::Quote enters previous day's price as today's

2020-06-24 Thread David Carlson
Frank, good points. I was on a smartphone and not trying to be 100% accurate (reigning in the spell checker is already more than I can handle). I think GnuCash does differentiate at least some of those types and maybe save one of each, but I was not able to test. David Carlson On Wed, Jun 24,

Re: [GNC] Finance::Quote enters previous day's price as today's

2020-06-24 Thread Frank H. Ellenberger
Am 23.06.20 um 22:10 schrieb David Carlson: > I am not sure that this is your problem or not, but I have found that I > need to wait several hours after the markets have closed before downloading > mutual fund prices. It seems to take hours for some of them to get posted > at Yahoo.com. One way

Re: [GNC] Finance::Quote enters previous day's price as today's

2020-06-24 Thread David Reiser via gnucash-user
> On Jun 24, 2020, at 3:00 AM, Colin Arndt wrote: > > Interesting. It still sounds like a bug report is in order if it’s storing an > incorrect price after normal user interaction with the feature. The bug is > that it’s storing a new price for the day before there is a new price for the >

Re: [GNC] Finance::Quote enters previous day's price as today's

2020-06-23 Thread Robin Chattopadhyay
Dave R. is correct to call out the timing as a source of the issue. Just to add some additional background, I work in the financial services industry and a component part of my team's work is to ingest prices from 200+ mutual fund companies, covering tens of thousands of mutual fund prices. The

Re: [GNC] Finance::Quote enters previous day's price as today's

2020-06-23 Thread David Reiser via gnucash-user
> On Jun 23, 2020, at 4:10 PM, David Carlson > wrote: > > I am not sure that this is your problem or not, but I have found that I > need to wait several hours after the markets have closed before downloading > mutual fund prices. It seems to take hours for some of them to get posted > at

Re: [GNC] Finance::Quote enters previous day's price as today's

2020-06-23 Thread Matthew Forbis via gnucash-user
I've actually found that sometimes it's easier to retrieve quotes and import through the CSV importer instead of trying to add price quotes on a cron job.  If you have already set up and alphavantage account, I've found that with a little powershell, I can easily retrieve the historical prices

Re: [GNC] Finance::Quote enters previous day's price as today's

2020-06-23 Thread David Carlson
I am not sure that this is your problem or not, but I have found that I need to wait several hours after the markets have closed before downloading mutual fund prices. It seems to take hours for some of them to get posted at Yahoo.com. One way to check would be to see what Yahoo.com is reporting

[GNC] Finance::Quote enters previous day's price as today's

2020-06-23 Thread Colin
First off, I just installed GnuCash a couple weeks ago, after trying a few other options and finding they simply weren't mature enough or feature-complete enough for what I need. I can't say thank you enough to everyone who's developed this program, everyone who continues to develop it and