Share via

Are there symbols for bond yields to us with stockhistory function ?

Anonymous
2025-03-02T22:21:35+00:00

Excel- Stockhistory function- Are there symbols for bond yields ?

last last last
Yesterday week month Year
US Treasury 2Y 2/28/2025 22:05 $ 100.26 US2Y 4.07% 0.02 4.27% 4.19% 4.19%
US Treasury 5Y 2/28/2025 22:05 $   99.95 US5Y 4.08% 0.06 4.34% 4.32% 4.32%
Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2025-03-03T03:43:22+00:00

Hi Craig,

Welcome to Microsoft Community.

No, the STOCKHISTORY function does not have the symbols to query bond yields. Bond prices are not transparent, priced infrequently, and sometimes updated with minor data only after long periods. Moreover, most transactions occur over the counter, making it difficult to obtain yield information. The stock data provider LSEG Data & Analytics, which collaborates with Microsoft, has no immediate plans to use new technologies to predict bond prices either.

You may consider some third-party Excel add-ins to query bond yields, such as Cbonds from the Excel Add-in Store: 

Hope the information I've shared above will help you find a better direction. If you have any other questions or want to share more context, please let me know in your reply!

Best Regards,

Thomas C - MSFT | Microsoft Community Support Specialist

Was this answer helpful?

0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2025-03-03T14:41:48+00:00

    Thanks for your response. The US Treasury Department puts out good historical data, but I have not found a method to incorporate it into my functions.

    Was this answer helpful?

    0 comments