Skip to content

Data Empower – The Data Matrix

Search for:
Log in

Menu

Close
  • Home
  • Shop
  • Excel
    • All Excel Functions List
  • PowerBI
  • SQL
  • Fabric
  • Google sheets
    • Google Sheets All functions alphabetical
  • About
  • Home
  • Shop
  • Excel
    • All Excel Functions List
  • PowerBI
  • SQL
  • Fabric
  • Google sheets
    • Google Sheets All functions alphabetical
  • About
Search for:
Log in

Tag: Bonds

  • Home
  • Bonds
XL Financial

ODDFPRICE Excel function

Written by Data Empower May 22, 2025

Calculates the price per $100 face value of a security with a non-standard first period.

Google sheets financial

PRICE Google Sheets function

Written by Data Empower May 18, 2025

Determines the value of a security that offers periodic interest payments, like a US Treasury Bond, according to anticipated yield.

Google sheets financial

MDURATION Google Sheets function

Written by Data Empower May 18, 2025

Determines the modified Macaulay duration of an investment that pays interest periodically, such as a U.S. Treasury Bond, according to anticipated yield.

Google sheets financial

COUPPCD Google Sheets function

Written by Data Empower May 18, 2025

Determines the final coupon or interest payment date preceding the settlement date.

Google sheets financial

COUPDAYSNC Google Sheets function

Written by Data Empower May 18, 2025

Determines the total number of days from the settlement date to the upcoming coupon or interest payment date.

Google sheets financial

COUPDAYBS Google Sheets function

Written by Data Empower May 18, 2025

Determines the number of days from the initial coupon or interest payment to the settlement date.

Follow me on Ganjing World!

Get the SQLBits T-Shirt now!

Copyright © 2025 Data Empower - The Data Matrix | Powered by BuddyX WordPress Theme