Thanks Catalin. Code works fine. The file you have attached is corrupted but I executed the code in my file and it has worked like wonders. Thanks aga...
I posted this topic on Techcommunity forum and guess what formula guru Peter Bartholomew himself explained me the concept of Thunks. Below is the link...
Yes Riny it works without harming integrity of the entered data. It's cool. You did very well. Thank you very much. I appreciate your help.
You seems to be right that I can copy paste the values from the query and then delete it. Can you tell me the exact steps after the table is loaded to...
Power query will permanently reside in the file resulting into duplicate data being inserted into the file only for the purpose of cleaning primordial...
Hallo Mynda. Thanx for addressing the issue. Do you mean that some of the entered numbers are in text format? You are correct that there are some n...
I have understood the basis part. 0 and 4 assign 30 day count to each month and 360 to a year no matter what is real day count of a month and year. Th...
Velouria you are right. I studied the formula. They use issue date for deriving both maturity and settlement values. I thought input price in the form...
This page really contains the formulas used by various functions and how they perform the calculation. I will read it and will post the reply later in...
For basis of 0/4 each subsequent 30 day completion will be considered as completion of 1 month and each subsequent 360 days from start date will be co...
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...