What is the ISERROR Excel Function? The ISERROR Excel Function is categorized under Information functions. The function will return TRUE if the given value is an error and FALSE if it is not. It works on errors – #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME? or #NULL. ISERROR is used in combination with the IF function…
What is the ISERR Excel Function? The ISERR Excel Function is categorized under Information functions. The function will return TRUE if the given value is an error (except N/A) and FALSE if it is not. It belongs to the IS group of functions, which includes ISERROR, IFERROR, etc. ISERR is used in combination with the…
Who are Strats? Strats refer to mathematicians, statisticians, computer scientists, and engineers who work in the financial services industry. In particular, strats are used to describe the mathematicians, statisticians, software developers, and engineers who work at investment banks in a front office role. The first strats team was set up within the strategies team at…
What is Shadow (Candlestick Wick)? In the world of finance and charting, a shadow is a line that makes up a candlestick pattern’s wick – the portion of the candlestick that represents price action outside of the candlestick body formed by the opening and closing prices of the period. Every candlestick chart must contain a…
What is Technical Decline? Technical decline is the downward price movement of a security that is caused by factors other than a fundamental change in the security’s value. The forces that power the downward movement relate to technical factors affecting the trading condition of the securities, but not the economic or fundamental factors that affect…
Using DOLLARDE for US Treasury Bonds Quotes The DOLLARDE Function is an Excel Financial function. It helps in converting a dollar value in fractional notation into a dollar value expressed in decimal notation. DOLLARDE will divide the fraction part of the value by an integer specified by the user. It is used in pricing US…
What is the Covariance Excel Function? The Covariance Excel function is categorized under Statistical functions. It calculates the joint variability of two random variables, given two sets of data. Suppose, as a financial analyst, that we wish to determine whether greater income accompanies greater levels of education in a population or not. In such a…
T Distribution and T Value Excel Function The T.DIST Function is categorized under Excel Statistical functions. It will calculate the T distribution. The T distribution is a continuous probability distribution that is frequently used in testing hypotheses on small sample data sets. This guide will show you how to use the T Distribution Excel formula…
What are Currency Futures Contracts? Currency futures contracts also referred to as foreign exchange futures or FX futures for short, are a type of futures contract to exchange a currency for another at a fixed exchange rate on a specific date in the future. Since the value of the contract is based on the underlying…
What is the T.INV Excel Function? The T.INV Excel Function is categorized under Statistical functions. It will calculate the left-tailed student’s t-distribution. The student’s t-distribution is a continuous probability distribution that is frequently used in testing hypotheses on small sample data sets. As a financial analyst, the T.INV function is used in portfolio risk analysis,…
