[GNC] Getting Quotes for Funds

[aeg]

 Thank you for the clarification. I clearly have more learning to do when time permits, but I do know more now than I did a week ago!
AlanG

    On Friday 21 November 2025 at 22:13:09 GMT, Kalpesh Patel <kalpesh.patel at usa.net> wrote:  
 
I should have been a bit more precise  - 'Type of quote source' or 'Edit security' was not referring to MorningstarUK site but to capabilities within GNUCASH’s security editor to configure which source to get the quote from for a specific commodity. It is found at the same place where you found “Single”, “Multiple”, etc . I don’t think you can register for a token with YH Finance API – assuming you are referring to Yahoo; its is likely other sources that Bruce mentioned here. Document is best source of nuance for each module to see which module requires an API key.. 

   

From: aeg <aeg21212-forum at yahoo.com> 
Sent: Friday, November 21, 2025 4:01 PM
To: gnucash-user at gnucash.org; 'Bruce Schuck' <bschuck at asgard-systems.com>; Kalpesh Patel <kalpesh.patel at usa.net>
Subject: Re: [GNC] Getting Quotes for Funds

  

Hi Kalpesh,

Thank you for your input.

I couldn't find 'Type of quote source' or 'Edit security' on the MorningstarUK site, and have yet to register on the YH Finance API site, but the latter looks promising so I'll register for that when I have a little more time.

  

AlanG

  

On Friday 21 November 2025 at 18:41:05 GMT, Kalpesh Patel <kalpesh.patel at usa.net> wrote:

FWIW, FinanceAPI and MorningstarUK source would be available in "Unknown" under "Type of quote source" in the "Edit security" property sheet. 

There are numerous modules available as a source so review all three 'Type of quote source' and clicking the down arrow next to it in that 'Edit security' property sheet to see what is available.

BTW, symbols for securities mentioned were checked against Yahoo and their long name were extremely close, hence recommendation since Yahoo provides them based on symbol. 


-----Original Message-----
From: aeg <aeg21212-forum at yahoo.com> 
Sent: Friday, November 21, 2025 5:36 AM
To: gnucash-user at gnucash.org; Bruce Schuck <bschuck at asgard-systems.com>
Subject: Re: [GNC] Getting Quotes for Funds

Thank you for your helpful follow-up.
I couldn't find FinanceAPI but did find information that looks promising on MorningstarUK, where I was able to download factsheets, and those provide the following details:
For the HSBC fund:ISIN  GB00B76WP695Bloomberg ticker  HSWIPCA LNSEDOL  B76WP69
and for the Vanguard fund:ISIN  GB00B3TYHH97Bloomberg ticker  VGLS60A
SEDOL  B3TYHH9
I haven't tried those yet in GnuCash as it seems to be working with different tickers, but with the HSBC ticker shown above I'm wondering whether the space within it has any significance, as most others I've seen and used have a .L at the end.
Regards,AlanG


    On Thursday 20 November 2025 at 22:54:53 GMT, Bruce Schuck <bschuck at asgard-systems.com> wrote:  

On 11/20/25 12:21, aeg wrote:

> In trying to set it up, I also found it difficult to find the
> correct ticker symbol to use, as different searches returned
> different results, and I'm now further puzzled that the Symbol shown
> in your examples below uses the ISIN code!
That can be a sticky wicket, and there is no easy answer. Especially 
true for things like funds and bonds. Using a US based source for funds, 
one has to find what suffix to add. For example, adding ".L" to the 
ISINs, the prices for those two funds can be retrieved from FinanceAPI 
(an API Token based source).

~$ gnucash-cli --quotes dump financeapi GB00B76WP695.L GB00B41XG308.L
Finance::Quote fields GnuCash uses:
    symbol: GB00B76WP695.L  <=== required
      date: 06/28/2019      <=== recommended
  currency: GBP            <=== required
      last: 1.7            <=\
        nav:                <=== one of these
      price:                <=/

Finance::Quote fields GnuCash uses:
    symbol: GB00B41XG308.L  <=== required
      date: 06/28/2019      <=== recommended
  currency: GBP            <=== required
      last: 195.45          <=\
        nav:                <=== one of these
      price:                <=/

In summary you will sometimes need to go to the websites the sources use 
and determine the proper symbol.

Currently FTFunds and MorningstarUK only allow ISINs to be used for lookups.

Thank you.