F::Q 1.40 uploaded

[David T.]

If I were going to try to change all my quote sources quickly, I would do it with SQL. 

!!!!! NOTE THAT THIS SUGGESTION IS NOT/NOT PROMOTED BY THE DEVELOPMENT TEAM BECAUSE IT CHANGES YOUR DATA FROM OUTSIDE THE GNUCASH API!!!!!!!!!!
 
!!!!!!! USE AT YOUR OWN RISK !!!!!!!!!!!!!!!!

1) Make a backup of the data file.
2) Save the data file in an SQL format.
3) Close GnuCash.
4) Open the data file in a database app.
5) Execute “UPDATE commodities SET quote_source = ‘alphavantage’ WHERE quote_source = ‘yahoo’;”
6) Reopen GnuCash.
7) Check that things still work.
8) Re-save into xml.

David


> On Nov 7, 2017, at 3:17 AM, brad <bradhaack at fastmail.us> wrote:
> 
> alphavantage works with the few funds that I tried.
> 
> Anybody have a quick way to change all quote sources from yahoo to alphavantage?
> 
> 
> On 11/05/2017 12:44 PM, Erik Colson wrote:
>> ...
>> Please note that while AlphaVantage does appear to offer quite a bunch
>> of quotes, it doesn't seem to support funds nor currencies.
>> 
>> best
>> --
>> erik colson
>> _______________________________________________
>> 
> 
> _______________________________________________
> 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.