Last seen: Jan 27, 2026
You are saying that coupon rate that I will receive on maturity will vary depending upon issue date. Function assumes a standard redemption value as $...
Velouria, for basis argument of the function for basis of either 0 or 4, convention is 30/360. Which means day count of 30 for one month and day count...
This function is for the security that pays interest rate on maturity date. Hence all the cash flow is fixed that is principal we pay and return we re...
Thank you so much Anders and thanks for the formula in column AY too. It works well. I will definitely look forward to learn Power Query in the future...
There are two tables viz JAN and CASH01. Each have their second column as 'DATE'. The dates in both column can be same if I execute trades in both the...
I have attached the file. I have tried with some formula but it doesn't work in older versions of Excel because of two different columns. Can you plea...