Excel Functions in EAC ToolsExcel Functions in EAC Tools\Interest rate functionsInterest rate functions\Treasury rates\TRate101

TRate101

TRate101 returns the 10-year Treasury rate for a given month/year (first business day in month). These rates are published by the Federal Reserve and also by the U.S. Department of the Treasury. 10-year Treasury rates are downloaded using this text string.

Syntax

TRate101 (Year, [Month])

Parameter Name

Description

Year

Year (not before June 1969); a 4 digit number;
or if a date (m/d/y) is entered, and the Month is missing, then the Year = y, and the Month = m

Month

Month (not before June 1969)
Optional, not used if Year is entered as a date (m/d/y), in which case Month must be blank