[GNC] Can Finance::Quote look up bond prices by CUSIP?

peterb peterb at gmail.com
Mon Jun 8 14:40:13 EDT 2020


Following up on this: I definitely am unable to look up any bonds by CUSIP
at Alphavantage.  I've spot-checked a number of the other sources listed
via gnc-fq-dump and so far have had no luck, so I'd love it if someone
knows what source to use.

To give a specific example: 34540TWD0 is the cusip for a Ford Motor Credit
bond maturing in 2025 (you can look that up here:
https://www.empirasign.com/findabond/34540TWD0/).  But none of the
Finance::Quote sources I've looked at so far can resolve that.  Anyone have
any ideas?

(This is clearly an issue with Finance::Quote and not GnuCash proper, but
I'm hoping someone else has had this issue and found a solution!)

-Peter

On Thu, Jun 4, 2020 at 5:43 AM Chris Good <goodchris96 at gmail.com> wrote:

> Message: 7
> Date: Wed, 3 Jun 2020 10:52:18 -0400
> From: peterb <peterb at gmail.com>
> To: gnucash-user at gnucash.org
> Subject: [GNC] Can Finance::Quote look up bond prices by CUSIP?
> Message-ID:
>         <
> CAMVDBj7dLfyUs+fJyZ0n-9hyGRR-ZpsaBPTqnGgYbjZmBStORw at mail.gmail.com>
> Content-Type: text/plain; charset="UTF-8"
>
> Can Finance::Quote be used to look up bond prices? If so, how can I
> configure the security in GnuCash to get this done?
>
> A related question is how can I use it to fetch currency prices.
>
> Thanks!
>
> -Peter
>
> Hi Peter,
>
> Yes to CUSIP.
> Please see
>
> https://wiki.gnucash.org/wiki/Online_Quotes#Finding_the_right_Source_and_Sym
> bol
>
> If you have stocks in different currencies (I think this works by checking
> the currency of the parent account as stocks have their own
> commodity/currency being the stock symbol usually), when you do 'Get
> Quotes'
> in the Price Database, GnuCash will also get any currency conversions
> necessary, and they are visible in the Price Database window.
>
> See https://wiki.gnucash.org/wiki/Online_Quotes#Helper_Scripts for
> gnc-fq-dump commands for getting currency conversion rates.
>
> They is plenty of other info in the FAQ, see
> https://wiki.gnucash.org/wiki/FAQ
>
> If you cannot get the prices or currency conversion rates you want, please
> tell us in this mailing list which specific stocks or currencies you are
> after.
>
> Regards, Chris Good
>
>


More information about the gnucash-user mailing list