I just did a gnc-fq-dump for one of my investments and the date reported
within the data was 2021-04-23, which makes sense, since it's a mutual fund
that had its price updated yesterday (Friday) evening. However, when I do a
price update in GnuCash it takes that quote and assigns it a date for
age: 7
> Date: Sat, 24 Apr 2021 08:57:21 -0400
> From: Jack Frillman
> To: David Carlson
> Cc: Gnucash Users
> Subject: Re: [GNC] Mutual fund quotes in the U. S.
> Message-ID: <1bc5ad5a-508d-d272-20ad-bf4951122...@me.com>
> Content-Type: text/plain; charset=utf-8;
I'd imagine one could do something like this with a Perl script that uses
another script, like the Yahoo JSON one, to get the price, then "adjusts"
the date based upon the time of day, etc.
You'd have to do a bit of searching to figure out how to add your own module
to the quoting functions of
It can get the prices for both stocks and mutual funds. The lookup is
done by ticker symbol.
GNUC's csv price importer requires a date to be present in the csv file
so I'm not sure what you are asking in your second question.
Below is a sample of a couple of lines from the csv file. It's has
Jack,
Your scripts offer an opportunity to massage the data, if needed. Out of
curiosity, can you import both stock prices and mutual fund prices? And
can you keep the timestamps in your CSV files?
On Fri, Apr 23, 2021 at 8:55 PM Jack Frillman wrote:
> It may be doing what I'm doing and
It may be doing what I'm doing and making the date of the closing price
as the day the script is run.
I don't run it using cron. I run it manually and if I forget a day I
don't worry about it.
I just run one of these two commands from the terminal.
getquotes -y <-- gets the prices from
I am not sufficiently comfortable with BASH, Chron jobs, etc to be willing
to set up an outside utility to do that. I manually download prices inside
the GnuCash price database using Yahoo as JSON as the source. If I forget
to do it in the late evening I sometimes try to do it in the morning
I'm not sure what you are using to updated the your prices but I wrote a
python script & a bash script that get the quotes and put them into a
csv file for importing into GNUCash and I don't have that date issue. I
run the scrips in the evening when the markets are closed.
On 4/23/21 8:59 PM,
I noticed recently that if I download mutual fund prices after about 7 AM
central daylight time the prices are saved in GnuCash with todays date even
though they are still yesterday's closing NAV until sometime after the
markets close. To reliably get the correct price posted on the correct
date