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

[John Ralls]

It's actually not an "issue" with either. Like GnuCash, Finance::Quote is a Free, all-volunteer project and the fact that it doesn't meet your personal needs is your problem and nobody else's.

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. The only other free site for bond prices at all was https://finra-markets.morningstar.com/BondCenter/, but while it claims to search by cusip it wasn't able to find yours. I did eventually find that by searching for Ford, sorting the results by maturity, and binary-searching until I found it. They give F4955773 as the symbol, FWIW.

Your best option seems to be to write a F::Q scraper module for empirasign.com.

Regards,
John Ralls


> 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.