Topic: Assorted Instruments
- How do the FINCAD commodity swap functions work?
- What are freight derivatives?
- What is the 'level of accuracy' field in the aaCDO_std functions?
- What is the volatility of the CDS spread?
- How do FINCAD CDS models compare to Bloomberg?
- What are the Numerical Integration Methods used?
Topic: FINCAD XL
- Why doesn't my spreadsheet using FINCAD XL's Remote Functions calculate on my colleague's machine?
- How can I load FINCAD XL every time I start Microsoft Excel?
- Why do my function and math reference pages come up as empty screens after I install FINCAD XL?
- How do I create a name range for a dynamic list?
- Why do I receive the message "not a valid NT image" when I run FINCAD XL?
- Why did I get #VALUE as a result when I went into the finder and pasted an example of the function aaXxxxxx_xx and entered XX as the underlying price?
- How do I open the 'FC switches worksheet'?
- After upgrading to Version 9 my spreadsheet stopped working. Why?
- How can I disable error handling at startup?
- How do I edit a nested IF function?
- Can I repair damaged Microsoft Excel files?
- Does FINCAD support a 64-bit system?
- Can FINCAD XL or FINCAD Developer be used in a MAC environment?
- What is CrypKey and what folders and permissions does CrypKey need access to?
Topic: Interest Rates
- In aaCalibrationSwaption_LMM, why do the output values for beta1 and beta2 lie outside the user-input ranges for beta1 and beta2?
- How do I value an interest rate cap with a barrier?
- How do I create a forward starting curve?
- In the LMM model what is the difference between the two "approximation types"?
- How do I value an overnight index swap (OIS) with FINCAD?
- How do I convert discount factors back to par bond and swap yields?
- How do I calculate a par swap rate for a cross-currency swap or an amortizing swap?
- How do I build a discount curve from spot rates only?
- How do I price a swaption on a forward starting swap?
- Is it possible to have a floating leg of a swap which is discounted using a different curve than the reference rate?
- In the asset swap functions, if I choose to use yield, what is the compounding basis for this inputted yield?
- What is a the difference between CDOR and CLIBOR?
- What are the parameter ranges for multi-factor calibration?
- What is the OAS input for callable capped floaters?
- What is a "roll down" and "carry" of a swap?
- What method is used to solve for the OAS?
- What should the parameter ranges be for LMM calibration?
Topic: Fixed Income
- What functions do I use: if a bond is ex-dividend prior to its dated date, and if a bond has a redemption value different than its principal?
- What function do I use to calculate the present value of a bond using zero coupon pricing rather than yield to maturity?
- Why do some of the bond accrual methods have "EOM" after them?
- I am using a bond cash flow function but only see the result in one cell. How do you see all of the cash flows?
- How do I calculate a money market yield for a bond?
- How can I value fixed and floating rate perpetuities?
- How do I calculate the value of a bond using a discount curve?
- What is the difference between aaBond, aaBond2, aaBond3 and aaBond4?
- Why do you need a convexity adjustment when using Eurodollar futures in the bootstrapping process of an interest rate curve?
- What is the methodology used by FINCAD when it comes to valuing callable bonds?
- How do I price a callable BMA bond using OAS?
Topic: Options
- Why do the output prices of American and European options differ?
- How do I price foreign exchange options using FINCAD?
- What are the definitions of the greeks from the option models? (delta, gamma etc)
- How do I value an option on an equity index?
- How do I output delta for FINCAD Monte Carlo option functions?
- How do I value an equity option that the dealer calls a "split premium option"?
- How do I value an option on an equity index?
- Why can we set holding cost equal to risk free rate for futures?
- How is the expected life for ESO's calculated?
- How is a Theta in aaBS_dcf() calculated?
- How do I price warrants on dilutive stocks?
- What is the relationship between sampling frequency and time steps in Asian MC?
Topic: Utilities
- How do I generate and adjust a list of dates?
- What are the arguments dated date, date of first coupon and date of last coupon used for?
- What are the formulas underlying the FINCAD functions which convert rates to discount factors (and vice versa)?
- How do I create switch functions like those in FINCAD XL's 'pasted examples' or templates?
- How do I call FINCAD functions from Microsoft® Excel VBA code instead of pasting the function onto a spreadsheet?
- How do I output an array of statistics?
- How can I convert discount factors back to par bond and swap yields?
- How can I include any additional currency to the curve tab of the Bloomberg-enabled workbooks?
- What are the common causes of # VALUE! error message?
- What are the different interpolation methods?
- What is the basic risk management coverage offered by FINCAD?
- What is the proper use of the hl (holidays) argument in the aaSwap_crv function?
- Why do I get odd results when I use the linear spot rates interpolation method?
- What is the function aaDisplayArray used for?