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

[peterb]

Closing the loop (and making this my last comment on the thread, since it's
firmly not-gnucash), It looks like the closest thing that ever existed to
an off-the-shelf solution for this is the fidelityfixed module for F::Q,
which was intended to look up US bond prices (there's discussion of it on
finance-quote-devel); sadly, as near as I can tell, Fidelity has since
stopped providing the endpoint for this to the general public.  I'll look
into whether there's a reasonable way to get F::Q to log in to a Fidelity
account to retrieve it, but that's clearly beyond the scope of this thread.

Thanks for the suggestions, everyone!

-p

On Mon, Jun 8, 2020 at 5:35 PM John Ralls <jralls at ceridwen.us> wrote:

> After searching for a bit the only site I found that offers free bond
> lookup by cusp at all is the empirasign.com that you found.
> > On Jun 8, 2020, at 11:40 AM, peterb <peterb at gmail.com> wrote:
> >
> > 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
> >>
> >>
> > _______________________________________________
> > gnucash-user mailing list
> > gnucash-user at gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -----
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
>
>