Tuesday, September 22, 2009

Where and How to Analyze Treasury Auction Results

Following An Introduction to Treasury Auctions and The Recent Treasury Auction Brouhaha, I have received several requests from readers on where to obtain the relevant auction data and how to calculate the yield, bid-to-cover ratio and percentage of indirect bidders. It would be nice if there were an archived table of all this information, but the table of results for recent Treasury Note auctions omits both the bid-to-cover ratio and percentage of indirect bidders.

As best as I can determine, anyone seeking to capture the history of auctions for a particular bond needs to do so manually. I will quickly walk through how this can be done. First, start by selecting a particular security in the Search by Security Type list at the page with the title Treasury Marketable Security Offering Announcement Press Releases. Selecting the 2-Year Notes will bring up a page with all the data grouped by calendar year. Clicking on 2009 brings you to 2009 Treasury Security Auction Press Releases: 2-Year Notes. On this page, each auction date has three rows associated with it: Announcement; Prelim. Noncomp. Results; and Auction Results.

By selecting the PDF version of the 9/22 auction results, I can pull up today’s auction data. The yield to focus on is the High Yield, which was 1.034% for today’s auction. At the very bottom left, the press release notes the bid-to-cover ratio of 3.23 and provides the source data for the numerator and denominator. Finally, the percentage of indirect bidders is not calculated in the press release, but can be easily computed by dividing the Indirect Bidder – Accepted number by the Total Competitive – Accepted number. Today, that translated into an indirect bidder percentage of 45.2%.

Of course the best way to analyze the numbers is to watch and see how the market reacts to the prices and yields not just for the bond in question, but across the entire yield curve. In evaluating bid-to-cover ratios and the percentage of indirect bidders, analysts tend to compare the current auction to the most recent auction of the same security and to an average of the past 10-12 auctions of that security.

For two superb blogs with a bond focus, I continue to recommend:

[source: TreasuryDirect]

2 comments:

ngbstl said...

Also for lazier individuals fyi ZeroHedge always posts pertinent auction data promptly (e.g. today's @ http://www.zerohedge.com/article/43-billion-2-year-auctions-closes-1034-high-yield)

Noppenbd said...

Econoday posts auction data with some historical data as well:

http://mam.econoday.com/byweek.asp

DISCLAIMER: "VIX®" is a trademark of Chicago Board Options Exchange, Incorporated. Chicago Board Options Exchange, Incorporated is not affiliated with this website or this website's owner's or operators. CBOE assumes no responsibility for the accuracy or completeness or any other aspect of any content posted on this website by its operator or any third party. All content on this site is provided for informational and entertainment purposes only and is not intended as advice to buy or sell any securities. Stocks are difficult to trade; options are even harder. When it comes to VIX derivatives, don't fall into the trap of thinking that just because you can ride a horse, you can ride an alligator. Please do your own homework and accept full responsibility for any investment decisions you make. No content on this site can be used for commercial purposes without the prior written permission of the author. Copyright © 2007-2013 Bill Luby. All rights reserved.
 
Web Analytics