How to find out which securities need to be switched from Yahoo to Alphavantage
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? 2. If so, is there an easy way to find them all? 3. If not,what troubleshooting steps will help figure out why it is not working yet? David C ___ gnucash-user mailing list gnucash-user@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.
Re: How to find out which securities need to be switched from Yahoo to Alphavantage
Ah, this was the problem for me as well. I found an ancient Templeton fund that hadn't been switched over. The actual bug here (and I have written it before on this mailing list) is that the error message that Gnucash provides is useless. It needs to contain more information about what failed. And contain a link to the wiki. Otherwise this mailing list gets slammed with yahoos like me asking the same questions over and over. Also, Alphavantage doesn't have VMGP (Vanguard Moderate Growth Portfolio). But it works! Yay! On Mon, Nov 13, 2017 at 10:01:30AM -0600, David Carlson 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? > > 2. If so, is there an easy way to find them all? > > 3. If not,what troubleshooting steps will help figure out why it is not > working yet? > > David C > ___ > gnucash-user mailing list > gnucash-user@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. -- Brian M. Sutin, Ph.D.Electro-Optical Systems Engineering Skewray Research/1307 Diamond Ave/South Pasadena CA 91030 USA/(909) 293-0026 ___ gnucash-user mailing list gnucash-user@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.
Re: How to find out which securities need to be switched from Yahoo to Alphavantage
See below. On November 13, 2017, at 9:02 PM, David Carlson 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@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. ___ gnucash-user mailing list gnucash-user@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.
Re: How to find out which securities need to be switched from Yahoo to Alphavantage
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 wrote: > See below. > > On November 13, 2017, at 9:02 PM, David Carlson < > david.carlson@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@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. > ___ gnucash-user mailing list gnucash-user@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.
Re: How to find out which securities need to be switched from Yahoo to Alphavantage
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 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 wrote: > >See below. > >On November 13, 2017, at 9:02 PM, David Carlson >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@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. > ___ gnucash-user mailing list gnucash-user@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.