[GNC] Getting Quotes for Funds

[aeg]

 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.