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

2017-11-13 Thread David Carlson 
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

2017-11-13 Thread D via gnucash-user 
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

2017-11-13 Thread gnucash3 
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.

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

2017-11-13 Thread David Carlson 
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.