How to find out which securities need to be switched from Yahoo to Alphavantage

David Carlson david.carlson.417 at gmail.com
Mon Nov 13 12:45:25 EST 2017


Ouch!!
David T, I vaguely recall that either you or someone you were discussing
price retrieval with about a year or two ago developed a way to find and
purge old prices from a file in a more selective way than the current purge
function works.
Is that documented somewhere?

Parenthetically, I also found a note in this haystack from Erik Colson
indicating that as of this time vanguard, nasdaq and nyse prices are not
retrieved by the alphavantage module, and a lot of my currently owned
securities are traded on nasdaq, so that is another gotcha to watch out for.

David C

On Mon, Nov 13, 2017 at 11:20 AM, D <sunfish62 at yahoo.com> wrote:

> See below.
>
> On November 13, 2017, at 9:02 PM, David Carlson <
> david.carlson.417 at gmail.com> wrote:
>
> >I have been using GnuCash for many years and there are many securities in
> >my file that I no longer own, but I may or may not have discontinued
> >downloading their prices.  In trying to get my Alphavantage source
> working,
> >it appears that it does not work if there is a mix of some securities
> >changed and many not changed.
> >1. Do I have to find all of them and change all before it will work?
>
> Unfortunately, yes.
>
> >2. If so, is there an easy way to find them all?
>
> Not really. I tried using the sql back end to change things  (through
> direct manipulation in the tables, which is NOT recommended), but the
> result was not successful. The sources were changed, but retrieval failed.
> I didn't feel like exploring further, so I went back to my original file
> and changed them manually.
>
> >3. If not,what troubleshooting steps will help figure out why it is not
> >working yet?
>
> I went through all my securities and changed them all. Then I ran get
> quotes, and checked the errors, which were inevitably omissions on my part.
> Rinse and repeat until you don't get errors.
>
> Perhaps it would be advisable to take this opportunity to clean out the
> older securities and turn off retrieval for them. Those lookups take time,
> the prices take space, and it doesn't really serve your accounting any real
> purpose to keep retrieving them.
>
> David T.
>
> >David C
> >_______________________________________________
> >gnucash-user mailing list
> >gnucash-user at gnucash.org
> >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.
>


More information about the gnucash-user mailing list