[GNC] Yahoo JSON - throwing unauthorized error

Bruce Schuck bschuck at asgard-systems.com
Sun May 7 21:02:26 EDT 2023


To the maintainers of the Wiki, would this be something perhaps helpful 
to include in the section about stocks and commodities?

I can also add 'xmlstarlet' commands as an alternative to manually 
editing the file.

- Bruce S.

On 05/07/23 15:12:21 EDT Bruce Schuck bschuck at asgard-systems.com wrote:

 > Last time I switched en-masse (alphavantage to yahoo_json) I manually
 > edited my foobar.gnucash file. Worked like a charm.

** Create a backup ** of foobar.gnucash before following these steps.
Replace 'vim' with your preferred editor.

~$ cp <pathtofile>/foobar.gnucash /tmp/foobar.gnucash.gz
~$ cd /tmp
/tmp $ gunzip foobar.gnucash
/tmp $ vim foobar.gnucash

In vim, change lines

<cmdty:quote_source>alphavantage</cmdty:quote_source>

to

<cmdty:quote_source>yahoo_json</cmdty:quote_source>

Save and exit

/tmp $ gzip foobar.gnucash
/tmp $ cp foobar.gnucash.gz <pathtofile>/foobar.gnucash

 > Run GnuCash, confirm quote sources for a random few securities.

 > There is also a handy tool for editing XML files on the fly,
 > xmlstarlet. It can also be used to modify the uncompressed
 > .gnucash file.

- Bruce S.


More information about the gnucash-user mailing list