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 <[email protected]> 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 <[email protected]> wrote: > >See below. > >On November 13, 2017, at 9:02 PM, David Carlson <[email protected]> >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 >>[email protected] >>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. > _______________________________________________ gnucash-user mailing list [email protected] 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.
