[–] Text Size [+]
TreasuryDirect (Logo)

Auction Query Help

The Auction Results Query has several features to make it easy for you to display and save data in different ways. The functionality provided is similar to features found in spreadsheet software.

Sorting

If you move your cursor into the column label block, you'll find an arrow on the right. Click on that arrow and you'll see a menu offering the choices "Sort ascending", "Sort descending", and "Remove Sort".

Filtering

Certain fields have a "Select Filter" box below the column heading. Clicking on the arrow in that box displays the choices you can filter on, or select all. For the other fields that don't have the "select filter", you can type in part or all of the value you want to filter on and the table will redisplay showing only that data.

For example, you can type in part or all of a CUSIP number and the table will redisplay to show only those records that fit the criteria you entered. In the Security term field, if you type "13-week" in the blank box below "Security Term", the table will redisplay to show only 13-week securities.

You can also select the "remove filter" button below the table to remove any filtering you have applied.

Date Function

For the date fields such as auction date, issue date, or maturity date, you can select a single date or a date range to display information for those dates. To select a single date, click on the calendar icon in the box below the column heading and double click on the date. The calendar icon will close and then the date you chose will display in the box below the column heading.

If you want a range of dates, click on the calendar icon, single click on the first date and then with the calendar still open click on the second date. The calendar icon will close and the date range will display in the box below the column heading. Data for the selected date range will display in the table.

Show/Hide Columns

You'll see a "show/hide" button below the table. When you select that button, a box opens with the columns listed either checked or unchecked. The "Select all columns" checks all of the columns so that all columns display. The "Unselect all columns" unchecks all the columns so that none of the columns display.

You can also manually select or unselect the columns you wish to display or hide.

Paging

You can move between pages of the table by using the right and left arrow at the bottom of the table or by entering the page number in the "Go to page:" block. You can also change the number of rows that display by selecting the arrow in the box next to "Show rows:" and select 100, 250, 500, or 1000. To the right of the "Show Rows:" box you can see what rows are available in the table out of the total number of records.

You can use the scroll bar below the table to move left and right among the columns.

Exporting Data

You can export the data from the table to these file formats:

  • CSV - Comma Separated Values
  • JSON - JavaScript Object Notation
  • TSV - Tab Separated Values
  • XML - Extensible Markup Language

Select the button above the table that has the appropriate acronym for the format you want to use. The File Download box will appear - chose open or save. If you choose save, you can use the standard "Save As" dialog box to save your file.