Re: [GNC] F::Q XAU & XAG quotes not retrieving for 2 years

2023-10-12 Thread Adrien Monteleone
Thanks. I'm not sure I want to get that deep into it. Yes, they were created as 'currencies' and can't be changed. I'll just manually enter prices periodically. It is only two of them. Regards, Adrien On 10/12/23 8:55 PM, Ken Farley wrote: My guess would be that it's because they were created

Re: [GNC] F::Q XAU & XAG quotes not retrieving for 2 years

2023-10-12 Thread Ken Farley
My guess would be that it's because they were created as a "currency" and can't be changed? I don't use any currencies as investments, so I don't have any experience with this kind of thing. If there is a way you can specify the source of the quotes (i.e. not Alphavantage), you could take the

Re: [GNC] F::Q XAU & XAG quotes not retrieving for 2 years

2023-10-05 Thread Adrien Monteleone
Thanks, but I already tried to edit them. I can't change the symbol for lookup (it is greyed out) and the source is simply 'currency' and no other options. When I created entirely new securities using the symbols you provided, I was able to edit everything including setting the source. It l

Re: [GNC] F::Q XAU & XAG quotes not retrieving for 2 years

2023-10-05 Thread Ken Farley
Oh I don't think you have to do anything terribly complicated. I've had mutual funds change their trading symbols in the past, and it was as simple as editing the security via Tools-> Security Editor Changing all the perinent information for the affected securities. Gnucash uses that info, no

Re: [GNC] F::Q XAU & XAG quotes not retrieving for 2 years

2023-10-05 Thread Adrien Monteleone
Thanks Ken, I was able to add those two in a 'Precious Metals' namespace, that indeed works. But now how to integrate that with my existing XAU/XAG denominated accounts? I'm guessing I'll have to make new ones with those symbols for commodity, then delete the old accounts and let GnuCash move

Re: [GNC] F::Q XAU & XAG quotes not retrieving for 2 years

2023-10-04 Thread Ken Farley
Yahoo seems to use "GC=F" as the symbol for Gold. I am able to get the price of gold as shown in the following output from gnc-fq-dump --> gnc-fq-dump yahoo_json GC=F Finance::Quote fields Gnucash uses:     symbol: GC=F <=== required   date: 10/04/2023   <=== recomme

Re: [GNC] F::Q XAU & XAG quotes not retrieving for 2 years

2023-10-02 Thread Adrien Monteleone
Hmm... Seems that as of F::Q 1.53, Alphavantage mucked with getting CURRENCY_EXCHANGE_RATE with the free API, so F::Q switched to a FX_DAILY request that doesn't include Crypto or Precious Metals, but there is a note (in the Github Issues) that Aphavantage then reversed their decision so now pr

[GNC] F::Q XAU & XAG quotes not retrieving for 2 years

2023-10-02 Thread Adrien Monteleone
This has been on my back burner for some time, but I decided to tackle it for a spell tonight. I haven't been able to retrieve an XAG quote since June 2020, and an XAU quote since December 2020. I've updated F::Q, and tried running GnuCash with debug logging, but can't seem to find anything