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,…
What is the T.DIST.RT Function? The T.DIST.RT Function is categorized under Excel Statistical functions. It will calculate the right-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, T.DIST.RT is used in portfolio risk analysis. It…
What is the GETPIVOTDATA Function? The GETPIVOTDATA Function is categorized under Excel Lookup and Reference functions. The function helps to extract data from specified fields in an Excel Pivot Table. The Pivot Table is used often in financial analysis to facilitate deeper analysis of given data. The function helps extract, group, or add data from…
What Is the Excel FV Function? The FV Function Excel formula is categorized under Financial functions. This function helps calculate the future value of an investment. As a financial analyst, the FV function helps calculate the future value of investments made by a business, assuming periodic, constant payments with a constant interest rate. It is…
What is the Excel CEILING Function? The Excel CEILING function is categorized under Math and Trigonometry functions. The function will return a number that is rounded up to a supplied number that is away from zero to the nearest multiple of a given number. MS Excel 2016 handles both positive and negative arguments. The function…
What are Interest Rate Futures? Interest rate futures are futures contracts based on interest-bearing financial instruments. This futures contract can be cash-settled or it can involve the delivery of the underlying security. Like other futures, this is an agreement for the long position to receive the interest earned on a notional amount and the short…
