Treasury Security Information
Base URL:
http://www.treasurydirect.gov/TA_WS/
Security Endpoint
/securities/Cusip(9#)/Date(MM/DD/YYYY)
Parameters
Parameter | Values Allowed | Example | Description |
---|---|---|---|
callback | All alpha-numeric | myCallback | Used by JSONP to wrap function |
format | xhtml, json, jsonp | xhtml | Determines the format that will be returned in the response |
This URL returns data about a specific security identified by CUSIP and issue date.
Example
http://www.treasurydirect.gov/TA_WS/securities/912796CJ6/02/11/2014?format=xhtml
Announced Endpoint
/securities/announced
Parameters
Parameter | Values Allowed | Example | Description |
---|---|---|---|
callback | All alpha-numeric | myCallback | Used by JSONP to wrap function |
format | xhtml, json, jsonp | xhtml | Determines the format that will be returned in the response |
pagesize | Numeric only | 2 | Maximum number of results to return |
type | Bill, Note, Bond, CMB, TIPS, FRN | Bill | Used to only display securities of a particular type |
days | Numeric only | 7 | How many days ago you want results for? (Note: days=0 will give you today’s results only) |
reopening | Yes, No | Yes | Used to filter securities by reopening status |
This URL returns data about announced securities. Max 250 results. Ordered by announcement date (descending), auction date (descending), issue date (descending), security term length (ascending)
Example
http://www.treasurydirect.gov/TA_WS/securities/announced?format=html&type=FRN
Auctioned Endpoint
Parameters
Parameter | Values Allowed | Example | Description |
---|---|---|---|
callback | All alpha-numeric | myCallback | Used by JSONP to wrap function |
format | xhtml, json, jsonp | xhtml | Determines the format that will be returned in the response |
pagesize | Numeric only | 2 | Maximum number of results to return |
type | Bill, Note, Bond, CMB, TIPS, FRN | Bill | Used to only display securities of a particular type |
days | Numeric only | 7 | How many days ago you want results for? (Note: days=0 will give you today’s results only) |
reopening | Yes, No | Yes | Used to filter securities by reopening status |
This URL returns data about auctioned securities. Max 250 results. Ordered by auction date (descending), issue date (descending), security term length (ascending)
Example
http://www.treasurydirect.gov/TA_WS/securities/auctioned?format=html&type=FRN
Type Endpoint
/securities/Type(Bill,Note,Bond,CMB,TIPS,FRN)
Parameters
Parameter | Values Allowed | Example | Description |
---|---|---|---|
callback | All alpha-numeric | myCallback | Used by JSONP to wrap function |
format | xhtml, json, jsonp, rss | xhtml | Determines the format that will be returned in the response |
This URL returns data about securities of a particular type.
Example
http://www.treasurydirect.gov/TA_WS/securities/FRN?format=html
Search Endpoint
/securities/search
Parameters
Parameters | Values Allowed | Example | Description |
---|---|---|---|
cusip | 9-characters, alpha-numeric | 912796CJ6 | Cusip is represented by 9 character alpha-numeric value. |
startDate | Numeric date in format: MM/DD/YYYY | 01/01/1980 | Start date for date field designated by dateFieldName parameter. |
endDate | Numeric date in format: MM/DD/YYYY | 01/31/1980 | End date for date field designated by dateFieldName parameter. |
dateFieldName | All alpha-numeric | issueDate | Determines which date field to use for startDate and endDate |
callback | All alpha-numeric | myCallback | Used by JSONP to wrap function |
format | json, jsonp, rss, xhtml | xhtml | Determines the format that will be returned in the response |
pagesize | Numeric only | 2 | Maximum number of results to return; you must also include pagenum when using pagesize |
pagenum | Numeric only | 1 | The first page number to display results for; used in combination with pagesize |
type | Bill, Note, Bond, CMB, TIPS, FRN | Bill | Used to only display securities of a particular type |
days | Numeric only | 7 | How many days ago you want results for? (Note: days=0 will give you today’s results only) |
reopening | Yes, No | Yes | Used to filter securities by reopening status |
Notes:
- Accepts parameter names that match camel cased variable names, for example auctionDate=2013-05-25&interestRate=7.5
- When using variable names as parameters you can supply a value of notNull, for example auctionDate=notNull
- Dates accept a value of "today" without quotes, for example issueDate=today
This URL returns data based on the parameters passed. By default it will display all securities. The list of fields which can be used as parameter names is as follows (when passing parameters remember to make the first letter lower case):
Example
http://www.treasurydirect.gov/TA_WS/securities/search?cusip= 912796CH0&format=html+
Fields
1. Cusip 2. IssueDate 3. SecurityType 4. SecurityTerm 5. MaturityDate 6. InterestRate 7. RefCpiOnIssueDate 8. AnnouncementDate 9. AuctionDate 10. XmlFilenameCompetitiveResults 11. DatedDate 12. RefCpiOnDatedDate 13. AccruedInterestPer1000 14. AccruedInterestPer100 15. AdjustedAccruedInterestPer1000 16. AdjustedPrice 17. AllocationPercentage 18. AllocationPercentageDecimals 19. AnnouncedCusip 20. AuctionFormat 21. AverageMedianDiscountRate 22. AverageMedianInvestmentRate 23. AverageMedianPrice 24. AverageMedianDiscountMargin 25. AverageMedianYield 26. BackDated 27. BackDatedDate 28. BidToCoverRatio 29. CallDate 30. Callable 31. CalledDate 32. CashManagementBillCMB 33. ClosingTimeCompetitive 34. ClosingTimeNoncompetitive 35. CompetitiveAccepted 36. CompetitiveBidDecimals 37. CompetitiveTendered 38. CompetitiveTendersAccepted 39. CorpusCusip 40. CpiBaseReferencePeriod 41. CurrentlyOutstanding 42. DirectBidderAccepted 43. DirectBidderTendered 44. EstimatedAmountOfPubliclyHeldMaturingSecuritiesByType 45. FimaIncluded 46. FimaNoncompetitiveAccepted 47. FimaNoncompetitiveTendered 48. FirstInterestPeriod 49. FirstInterestPaymentDate 50. FloatingRate 51. FrnIndexDeterminationDate 52. FrnIndexDeterminationRate 53. HighDiscountRate 54. HighInvestmentRate 55. HighPrice 56. HighDiscountMargin 57. HighYield 58. IndexRatioOnIssueDate |
59. IndirectBidderAccepted 60. IndirectBidderTendered 61. InterestPaymentFrequency 62. LowDiscountRate 63. LowInvestmentRate 64. LowPrice 65. LowDiscountMargin 66. LowYield 67. MaturingDate 68. MaximumCompetitiveAward 69. MaximumNoncompetitiveAward 70. MaximumSingleBid 71. MinimumBidAmount 72. MinimumStripAmount 73. MinimumToIssue 74. MultiplesToBid 75. MultiplesToIssue 76. NlpExclusionAmount 77. NlpReportingThreshold 78. NoncompetitiveAccepted 79. NoncompetitiveTendersAccepted 80. OfferingAmount 81. OriginalCusip 82. OriginalDatedDate 83. OriginalIssueDate 84. OriginalSecurityTerm 85. PdfFilenameAnnouncement 86. PdfFilenameCompetitiveResults 87. PdfFilenameNoncompetitiveResults 88. PdfFilenameSpecialAnnouncement 89. PricePer100 90. PrimaryDealerAccepted 91. PrimaryDealerTendered 92. Reopening 93. SecurityTermDayMonth 94. SecurityTermWeekYear 95. Series 96. SomaAccepted 97. SomaHoldings 98. SomaIncluded 99. SomaTendered 100. Spread 101. StandardInterestPaymentPer1000 102. Strippable 103. Term 104. TiinConversionFactorPer1000 105. Tips 106. TotalAccepted 107. TotalTendered 108. TreasuryDirectAccepted 109. TreasuryDirectTendersAccepted 110. Type 111. UnadjustedAccruedInterestPer1000 112. UnadjustedPrice 113. UpdatedTimestamp 114. XmlFilenameAnnouncement 115. XmlFilenameSpecialAnnouncement 116. AuctionDateYear |
Sample JSON output
[{"cusip":"912796QQQ","issueDate":"2014-02-14T00:00:00","securityType":"Bill","securityTerm":"2-Day","maturityDate":"2014-02-19T00:00:00","interestRate":"","refCpiOnIssueDate":"","refCpiOnDatedDate":"","announcementDate":"2014-02-11T00:00:00","auctionDate":"2014-02-14T00:00:00","auctionDateYear":"2014","datedDate":"","accruedInterestPer1000":"","accruedInterestPer100":"","adjustedAccruedInterestPer1000":"","adjustedPrice":"","allocationPercentage":"31.680000","allocationPercentageDecimals":"2","announcedCusip":"","auctionFormat":"Single-Price","averageMedianDiscountRate":"0.000000","averageMedianInvestmentRate":"","averageMedianPrice":"","averageMedianDiscountMargin":"","averageMedianYield":"","backDated":"","backDatedDate":"","bidToCoverRatio":"3.050000","callDate":"","callable":"","calledDate":"","cashManagementBillCMB":"Yes","closingTimeCompetitive":"11:30 AM","closingTimeNoncompetitive":"11:00 AM","competitiveAccepted":"9897800000","competitiveBidDecimals":"3","competitiveTendered":"30424000000","competitiveTendersAccepted":"Yes","corpusCusip":"","cpiBaseReferencePeriod":"","currentlyOutstanding":"","directBidderAccepted":"1002000000","directBidderTendered":"1006000000","estimatedAmountOfPubliclyHeldMaturingSecuritiesByType":"","fimaIncluded":"Yes","fimaNoncompetitiveAccepted":"3000000","fimaNoncompetitiveTendered":"3000000","firstInterestPeriod":"","firstInterestPaymentDate":"","floatingRate":"No","frnIndexDeterminationDate":"","frnIndexDeterminationRate":"","highDiscountRate":"0.005000","highInvestmentRate":"0.005000","highPrice":"99.999931","highDiscountMargin":"","highYield":"","indexRatioOnIssueDate":"","indirectBidderAccepted":"5626600000","indirectBidderTendered":"22416000000","interestPaymentFrequency":"None","lowDiscountRate":"0.000000","lowInvestmentRate":"","lowPrice":"","lowDiscountMargin":"","lowYield":"","maturingDate":"2014-02-14T00:00:00","maximumCompetitiveAward":"3500000000","maximumNoncompetitiveAward":"5000000","maximumSingleBid":"3500000000","minimumBidAmount":"100","minimumStripAmount":"","minimumToIssue":"100","multiplesToBid":"100","multiplesToIssue":"100","nlpExclusionAmount":"0","nlpReportingThreshold":"3500000000","noncompetitiveAccepted":"100000000","noncompetitiveTendersAccepted":"Yes","offeringAmount":"10000000000","originalCusip":"","originalDatedDate":"","originalIssueDate":"","originalSecurityTerm":"2-Day","pdfFilenameAnnouncement":"A_20140124_3.pdf","pdfFilenameCompetitiveResults":"R_20140127_7.pdf","pdfFilenameNoncompetitiveResults":"","pdfFilenameSpecialAnnouncement":"","pricePer100":"99.999931","primaryDealerAccepted":"3269200000","primaryDealerTendered":"7002000000","reopening":"No","securityTermDayMonth":"2-Day","securityTermWeekYear":"0-Week","series":"","somaAccepted":"0","somaHoldings":"0","somaIncluded":"No","somaTendered":"0","spread":"","standardInterestPaymentPer1000":"","strippable":"","term":"","tiinConversionFactorPer1000":"","tips":"No","totalAccepted":"10000800000","totalTendered":"30527000000","treasuryDirectAccepted":"0","treasuryDirectTendersAccepted":"No","type":"CMB","unadjustedAccruedInterestPer1000":"","unadjustedPrice":"","updatedTimestamp":"2014-02-14T11:30:40","xmlFilenameAnnouncement":"A_20140214_2CMB 2day.xml","xmlFilenameCompetitiveResults":"R_20140127_7CMB2dayretry.xml","xmlFilenameSpecialAnnouncement":""}]
Sample XHTML output
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd"><html xmlns="
http://www.w3.org/1999/xhtml"><head><title>Securities</title></head><body><table border="1"><tr><th>Cusip</th><th>IssueDate</th><th>SecurityType</th><th>SecurityTerm</th><th>MaturityDate</th><th>InterestRate</th><th>RefCpiOnIssueDate</th><th>AnnouncementDate</th><th>AuctionDate</th><th>AuctionDateYear</th><th>DatedDate</th><th>RefCpiOnDatedDate</th><th>AccruedInterestPer1000</th><th>AccruedInterestPer100</th><th>AdjustedAccruedInterestPer1000</th><th>AdjustedPrice</th><th>AllocationPercentage</th><th>AllocationPercentageDecimals</th><th>AnnouncedCusip</th><th>AuctionFormat</th><th>AverageMedianDiscountRate</th><th>AverageMedianInvestmentRate</th><th>AverageMedianPrice</th><th>AverageMedianDiscountMargin</th><th>AverageMedianYield</th><th>BackDated</th><th>BackDatedDate</th><th>BidToCoverRatio</th><th>CallDate</th><th>Callable</th><th>CalledDate</th><th>CashManagementBillCMB</th><th>ClosingTimeCompetitive</th><th>ClosingTimeNoncompetitive</th><th>CompetitiveAccepted</th><th>CompetitiveBidDecimals</th><th>CompetitiveTendered</th><th>CompetitiveTendersAccepted</th><th>CorpusCusip</th><th>CpiBaseReferencePeriod</th><th>CurrentlyOutstanding</th><th>DirectBidderAccepted</th><th>DirectBidderTendered</th><th>EstimatedAmountOfPubliclyHeldMaturingSecuritiesByType</th><th>FimaIncluded</th><th>FimaNoncompetitiveAccepted</th><th>FimaNoncompetitiveTendered</th><th>FirstInterestPeriod</th><th>FirstInterestPaymentDate</th><th>FloatingRate</th><th>FrnIndexDeterminationDate</th><th>FrnIndexDeterminationRate</th><th>HighDiscountRate</th><th>HighInvestmentRate</th><th>HighPrice</th><th>HighDiscountMargin</th><th>HighYield</th><th>IndexRatioOnIssueDate</th><th>IndirectBidderAccepted</th><th>IndirectBidderTendered</th><th>InterestPaymentFrequency</th><th>LowDiscountRate</th><th>LowInvestmentRate</th><th>LowPrice</th><th>LowDiscountMargin</th><th>LowYield</th><th>MaturingDate</th><th>MaximumCompetitiveAward</th><th>MaximumNoncompetitiveAward</th><th>MaximumSingleBid</th><th>MinimumBidAmount</th><th>MinimumStripAmount</th><th>MinimumToIssue</th><th>MultiplesToBid</th><th>MultiplesToIssue</th><th>NlpExclusionAmount</th><th>NlpReportingThreshold</th><th>NoncompetitiveAccepted</th><th>NoncompetitiveTendersAccepted</th><th>OfferingAmount</th><th>OriginalCusip</th><th>OriginalDatedDate</th><th>OriginalIssueDate</th><th>OriginalSecurityTerm</th><th>PdfFilenameAnnouncement</th><th>PdfFilenameCompetitiveResults</th><th>PdfFilenameNoncompetitiveResults</th><th>PdfFilenameSpecialAnnouncement</th><th>PricePer100</th><th>PrimaryDealerAccepted</th><th>PrimaryDealerTendered</th><th>Reopening</th><th>SecurityTermDayMonth</th><th>SecurityTermWeekYear</th><th>Series</th><th>SomaAccepted</th><th>SomaHoldings</th><th>SomaIncluded</th><th>SomaTendered</th><th>Spread</th><th>StandardInterestPaymentPer1000</th><th>Strippable</th><th>Term</th><th>TiinConversionFactorPer1000</th><th>Tips</th><th>TotalAccepted</th><th>TotalTendered</th><th>TreasuryDirectAccepted</th><th>TreasuryDirectTendersAccepted</th><th>Type</th><th>UnadjustedAccruedInterestPer1000</th><th>UnadjustedPrice</th><th>XmlFilenameAnnouncement</th><th>XmlFilenameCompetitiveResults</th><th>XmlFilenameSpecialAnnouncement</th></tr><tr><td>912796QQQ</td><td>2014-02-14T00:00:00</td><td>Bill</td><td>2-Day</td><td>2014-02-19T00:00:00</td><td></td><td></td><td>2014-02-11T00:00:00</td><td>2014-02-14T00:00:00</td><td>2014</td><td></td><td></td><td></td><td></td><td></td><td></td><td>31.680000</td><td>2</td><td></td><td>Single-Price</td><td>0.000000</td><td></td><td></td><td></td><td></td><td></td><td></td><td>3.050000</td><td></td><td></td><td></td><td>Yes</td><td>11:30 AM</td><td>11:00 AM</td><td>9897800000</td><td>3</td><td>30424000000</td><td>Yes</td><td></td><td></td><td></td><td>1002000000</td><td>1006000000</td><td></td><td>Yes</td><td>3000000</td><td>3000000</td><td></td><td></td><td>No</td><td></td><td></td><td>0.005000</td><td>0.005000</td><td>99.999931</td><td></td><td></td><td></td><td>5626600000</td><td>22416000000</td><td>None</td><td>0.000000</td><td></td><td></td><td></td><td></td><td>2014-02-14T00:00:00</td><td>3500000000</td><td>5000000</td><td>3500000000</td><td>100</td><td></td><td>100</td><td>100</td><td>100</td><td>0</td><td>3500000000</td><td>100000000</td><td>Yes</td><td>10000000000</td><td></td><td></td><td></td><td>2-Day</td><td>A_20140124_3.pdf</td><td>R_20140127_7.pdf</td><td></td><td></td><td>99.999931</td><td>3269200000</td><td>7002000000</td><td>No</td><td>2-Day</td><td>0-Week</td><td></td><td>0</td><td>0</td><td>No</td><td>0</td><td></td><td></td><td></td><td></td><td></td><td>No</td><td>10000800000</td><td>30527000000</td><td>0</td><td>No</td><td>CMB</td><td></td><td></td><td>A_20140214_2CMB 2day.xml</td><td>R_20140127_7CMB2dayretry.xml</td><td></td></tr></table></body></html>