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

[D]

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.