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

Robin Chattopadhyay robinraymn at gmail.com
Tue Jun 23 19:34:56 EDT 2020


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 best practice in the mutual fund industry calls for prices to be
available by 9:00 PM Eastern Time. However, in my experience, several
factors can influence how quickly prices are calculated: (1) market
volatility for the day can really mess with prices for equity funds, (2)
prices are often delayed during dividend/cap gain payment season, the worst
is in December, but can also affect price delivery in March, June, and
September, (3) industry-wide issues, there are only a handful of companies
that do fund accounting, so when one of them has an issue, it can cause
problems across the industry, (4) fund companies often publish corrected
prices on the same day, it's possible that Alphavantage has a different
price than Yahoo, for example, depending on how quickly they (or their
vendor) is ingesting updated prices.

My cron job for updating prices doesn't run until 5:00 AM. There are
additional reasons for this, but I wouldn't set up an automated price
update until 2:00 AM Eastern at the earliest for the best chance of getting
the most up-to-date mutual fund prices.

Robin

On Tue, Jun 23, 2020 at 5:40 PM David Reiser via gnucash-user <
gnucash-user at gnucash.org> wrote:

>
> > On Jun 23, 2020, at 4:10 PM, David Carlson <david.carlson.417 at gmail.com>
> 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 Yahoo.com. One way to check would be to see what Yahoo.com is
> reporting
> > early after hours vs later.
> >
> > GnuCash only keeps one downloaded price per day, and repeated prices are
> > discarded.  If you see that is what is happening, you might file a RFE to
> > keep the last price reported instead of the first.
> >
> >
> On my test today, gnucash did save the most recent downloaded price for
> today, not the first.
>
> Fund prices can get weird, depending on data feed and intermediaries.
> Yahoo as JSON was reporting an 8am price for today that was slightly
> different from yesterday’s close for all three of these Vanguard funds.
> Alphavantage, as of 6:30pm today (Tuesday) was still reporting Friday’s
> price for these funds.
>
> Yahoo got today’s closing NAV for VTIAX and VWELX at 5:39 pm (EDT). The
> VTSAX price didn’t update until 6:00pm.
>
>
>
> >
> > .
> >
> > On Tue, Jun 23, 2020 at 2:19 PM Colin <lumicanis at gmail.com> wrote:
> >
> >> 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 everyone who provides support here. It's an incredible
> accomplishment!
> >>
> >> I have an issue with Finance::Quote. It brings in prices for my three
> >> Vanguard funds when I run the following command, and I've been planning
> on
> >> setting up a cron job for it:
> >> gnucash --add-price-quotes path/to/my/gnucash/file
> >> However, for one fund (VTSAX) it enters the prior day's price again as
> >> today's. This requires me to look it up and fix it manually. Its
> settings
> >> under Security editor are the same as the other two (VTIAX and VWELX).
> >> They're set to get online quotes from a single source, Alphavantage.
> >> Can anyone provide guidance on what may be going on here?
> >> Second question:
> >> I have a Raspberry Pi and it would make sense to run the cron job there
> >> since it's always up. I also use Syncthing for syncing files between
> >> devices. However, the latest version in their repo's is GnuCash 3.4 and
> >> Finance::Quote 1.47. Would this introduce problems to have the Pi
> update my
> >> GnuCash file with price quotes?
> >>
> >> Thank you,
> >> Colin
>
>
> --
> Dave Reiser
> dbreiser at icloud.com
>
>
>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


More information about the gnucash-user mailing list