What is the Put-Call Ratio (PCR)? The put-call ratio (PCR) is an indicator used by investors to gauge the outlook of the market. The ratio uses the volume of puts and calls over a determined time period on a market index to determine market sentiment. It can additionally be used for individual securities by looking…
What is Roy’s Safety-first Criterion? Roy’s safety-first criterion is a risk management technique used by investors to compare and choose a portfolio based on the criterion that the probability of a portfolio’s return dropping below a threshold level return is reduced. In Roy’s safety-first criterion, the optimal portfolio is one that minimizes the probability of…
What is a Zero-Coupon Bond? A zero-coupon bond is a bond that pays no interest and trades at a discount to its face value. It is also called a pure discount bond or deep discount bond. U.S. Treasury bills are an example of a zero-coupon bond. Understanding Zero-Coupon Bonds As a zero-coupon bond does not…
What is the Expiration Date? The expiration date, in derivatives trading, refers to the date on which options or futures contracts expire. In other words, the expiration date is the last day that a derivative contract is valid. On the date of expiration, the derivative contract is settled between the buyer and seller. What are…
What is the DATEVALUE Function? The DATEVALUE Function is categorized under Excel Date/Time functions. When doing financial analysis, we often need to import files from another source, which can be in PDF, text, or csv file format. The DATEVALUE function helps convert dates imported from external sources that are in text format to a proper…
The DATEDIF function in Excel calculates the difference between two dates in days, months, or years. Its syntax is =DATEDIF(start_date, end_date, unit) with units like “Y” for years, “M” for months, and “D” for days. It also offers specialized calculations for differences in days ignoring months and years (“MD”), months ignoring days and years (“YM”),…
The COLUMNS Function The COLUMNS Function is an Excel Lookup/Reference function. It is useful for looking up and providing the number of columns in a given reference or array. The COLUMNS function, after specifying an Excel range, will return the number of columns that are contained within that range. Formula =COLUMNS(array) The COLUMNS function in…
What is the EXACT Function? The EXACT Function is categorized under Excel TEXT functions. The function helps to test if two or more than two supplied text strings or values are exactly equal and, if so, returns TRUE. Otherwise, it returns FALSE. The EXACT function is case-sensitive. In financial analysis, we often need to compare…
What is the FALSE Function? The FALSE Function is categorized under Excel Logical functions. The function returns the logical value FALSE. It is as good as typing FALSE in an Excel sheet. When doing financial analysis, this function becomes useful when we use it with the TRUE function. For example, we can use it if…
