View Single Post
  #18   Report Post  
Posted to microsoft.public.excel.worksheet.functions
IPerlovsky IPerlovsky is offline
external usenet poster
 
Posts: 32
Default Extracting a numbers from a text string

Yes, price, benchmark yield, and bond yield will always be before spread and
it will occasionally have a guarantor name that will not have a space.

--
iperlovsky


"Duke Carey" wrote:

After the second date value, will you ALWAYS have separate numbers
representing price, benchmark yield, and bond yield, and frequently but not
always have a guarantor name, too? Any chance the guarantor name will have
spaces?


"IPerlovsky" wrote:

You are correct. I am looking for spread. The difference between what you
call YTM and YTC, which are actually the benchmark yield and the bond's yield.

--
iperlovsky