Friday, January 04, 2008
Chart the Yield Curve Using Yahoo! Finance Data
The U.S. Treasury yield curve is of tremendous importance in the financial world, so those of us who teach finance often find it desirable to show a chart of the current yield curve. I’ve used many sources over the years, but my favorite disappeared a few years ago. The data is readily available, so creating your own yield curve isn’t that difficult. It is a bit of a hassle, though. In this post I’m going to show how you can create a “live” U.S. Treasury yield curve using Excel’s Web Query feature and data from Yahoo! Finance.
If you go to the Yahoo! Finance Bonds Center you will see a
Posted by Tim on 01/04 at 03:50 PM in
Bonds
in
Charts
in
Functions
in
String Functions
in
Find
in
left
in
mid
in
Value
in
Web Query
Comments (8) • Permalink • Tell-a-Friend
Comments (8) • Permalink • Tell-a-Friend
Page 1 of 1 pages
