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

[D]

I wrote a script to entirely replace your price history with monthly prices for the time you own a stock or mutual fund. It is available on github, but it's strictly unsanctioned, since it modifies the data file directly. I don't know whether the latest issues with F::Q affect it or not. Googling "new price history Gnucash" will lead you to the post I sent last year.

I am having no trouble with those exchanges. Alphavantage is working for me for: FUND, NASDAQ, NASDAQGS, NYSE, NYSEARCA, and OTC. 

To be clear, those are the types entered in the security entry. I have set the online source for all of these to Unknown:alphavantage without problem. My Vanguard funds are all set to Alphavantage without trouble.

David T.


On November 13, 2017, at 10:45 PM, David Carlson <david.carlson.417 at gmail.com> wrote:

>
>
>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.
>