Syntax

INTRATE(buy_date, sell_date, buy_price, sell_price, [day_count_convention])

Arguments

The printed syntax lists 5 argument(s), in order:

  • buy_date
  • sell_date
  • buy_price
  • sell_price
  • ay_count_conventio optional

“optional” marks an argument Google prints in square brackets; “repeatable” marks one Google prints with “…”.

Description from Google Docs Editors Help

“Calculates the effective interest rate generated when an investment is purchased at one price and sold at another with no interest or dividends generated by the investment itself.”

Google’s help article for INTRATE →

Source: Google Docs Editors Help, “Google Sheets function list” (support.google.com/docs/table/25273), record record 98 of 516, data fetched 28 September 2026. Data month: September 2026.