What are ODD financial functions in power bi DAX

This recipe explains what are ODD financial functions in power bi DAX

Recipe Objective - What are ODD financial functions in Power BI DAX?

ODDFPRICE - Returns the price per $100 face value of security having an odd (short or long) first period.

ODDFYIELD - Returns a security's yield with an odd (short or long) first period.

ODDLPRICE - Returns the price per $100 face value of security having an odd (short or long) last coupon period.

ODDLYIELD - Returns a security's yield with an odd (short or long) last period.

Syntax of ODDFPRICE -

ODDFPRICE(Settlement, Maturity, Issue, First_coupon, Rate, Yld, Redemption, Frequency, [Basis])

Parameters -

Settlement - The security's settlement date.

Maturity - The security's maturity date.

Issue - The security's issue date.

First_coupon - The security's first coupon date.

Rate - The security's interest rate.

Yld - The security's annual yield.

Redemption - The security's redemption value per $100 face value.

Frequency - The number of coupon payments per year. For annual payments, frequency = 1; for semiannual, frequency = 2; for quarterly, frequency = 4.

Returns the price per $100 face value.

Syntax of ODDFYIELD -

ODDFYIELD(Settlement, Maturity, Issue, First_coupon, Rate, Pr, Redemption, Frequency, [Basis])

Parameters -

Settlement - The security's settlement date.

Maturity - The security's maturity date.

Issue - The security's issue date.

First_coupon - The security's first coupon date.

Rate - The security's interest rate.

Pr - The security's price.

Redemption - The security's redemption value per $100 face value.

Frequency - The number of coupon payments per year. For annual payments, frequency = 1; for semiannual, frequency = 2; for quarterly, frequency = 4.

Returns the security's yield.

In this way, we can use ODD financial functions in Power BI DAX.

What Users are saying..

profile image

Ray han

Tech Leader | Stanford / Yale University
linkedin profile url

I think that they are fantastic. I attended Yale and Stanford and have worked at Honeywell,Oracle, and Arthur Andersen(Accenture) in the US. I have taken Big Data and Hadoop,NoSQL, Spark, Hadoop... Read More

Relevant Projects

Hands-On Approach to Regression Discontinuity Design Python
In this machine learning project, you will learn to implement Regression Discontinuity Design Example in Python to determine the effect of age on Mortality Rate in Python.

Build Portfolio Optimization Machine Learning Models in R
Machine Learning Project for Financial Risk Modelling and Portfolio Optimization with R- Build a machine learning model in R to develop a strategy for building a portfolio for maximized returns.

PyTorch Project to Build a LSTM Text Classification Model
In this PyTorch Project you will learn how to build an LSTM Text Classification model for Classifying the Reviews of an App .

Skip Gram Model Python Implementation for Word Embeddings
Skip-Gram Model word2vec Example -Learn how to implement the skip gram algorithm in NLP for word embeddings on a set of documents.

Abstractive Text Summarization using Transformers-BART Model
Deep Learning Project to implement an Abstractive Text Summarizer using Google's Transformers-BART Model to generate news article headlines.

Detectron2 Object Detection and Segmentation Example Python
Object Detection using Detectron2 - Build a Dectectron2 model to detect the zones and inhibitions in antibiogram images.

Predictive Analytics Project for Working Capital Optimization
In this Predictive Analytics Project, you will build a model to accurately forecast the timing of customer and supplier payments for optimizing working capital.

Deploying Machine Learning Models with Flask for Beginners
In this MLOps on GCP project you will learn to deploy a sales forecasting ML Model using Flask.

FEAST Feature Store Example for Scaling Machine Learning
FEAST Feature Store Example- Learn to use FEAST Feature Store to manage, store, and discover features for customer churn prediction machine learning project.

End-to-End Snowflake Healthcare Analytics Project on AWS-1
In this Snowflake Healthcare Analytics Project, you will leverage Snowflake on AWS to predict patient length of stay (LOS) in hospitals. The prediction of LOS can help in efficient resource allocation, lower the risk of staff/visitor infections, and improve overall hospital functioning.