Thanks for your tip, jomni!

<t>Yes! Thanks guys! It finally works!!!mrowell:Just like you said, my default date format is in UK standard - d/m/yI have to either 1) change the date in excel file to comfor the UK format or 2)change the default date format in W2K (mine is W2K Professional, shouldbe the same in XP) to let the form...

saliq:I try your method and it does not work.Thesee:I try your method too and still not working.bhutes:Cell E4 gives me #Value! after I key in =value(b4). Any other suggestion? I actually did speficy the cell format in the column B is date, not text.

Hi guys,Here are the excel files in a zip. Pls take a look and let me know what goes wrong!Thanks!

<t>Your idea of using bootstrapping technique to find the tield curve is correct. However, this passage does not allow you to conlude this statement.What it says here is that there are two issues with the yield curve. The first one is thefact that the on-the-run issues can be financed at cheaper rat...

Do you mean you want to find out the formula of calculatingthe return on captital for buying bonds and buy protections?Can you be more specific?

<t>friesenjung & APD:I try to attach the files for you guys but I get a message saying .xls and .doc file are not allowed to be uploaded.Anyway to get around this?gilipman:I use Office 2000, so I think it is Excel 2000 as well.DavidJN:I am not aware of this problem. Could you let me know where s...

<t>Hello,I bump into a problem with this Excel function: =Yearfrac(Today's Date, Maturity Date)I put 9/18/2003 in cell B3 and put 10/16/2003 in cell B4.And I put =yearfrac(B3, B4) and Excel returns #Value! to me.I take a look the Help section and I cannot figure what goes wrong >_<Pls help me!Thanks...

Hi Vijaypotukuchi,Thanks for your reply. I did search for vault but not much information came up. Vault has detail description about research analyst and i-banking though.But still, at least I get something from your tip! Thanks!Well, yeah, I think most people here are quant-oriented...

<t>Greetings everyone,Very often I come across the job title "institutional equity sales", and I just wonder what doesa person with such position do. I suppose the institutional investors are parties like mutual fund, pension plan, orinsurance companies. Are these "institutional equity sales" trying...

Well, I am also taking L2 this summer...Now stuck at the new 4 sections of accting >_<

quantstudent19,Thanks for your helpful tips!

daveangel,You are right, sorry for my mistakes. Should be Lehman... :-(I will made correction for my previous post. From your 2nd point, it seems there is no difference between the IBanker division and equities division.

<t>Hello everyone,Today as I browse Lehman's corp page, I see that within the equities division, there is a subgroup called sales and trading.Can anyone who has worked in LB share your thoughs about this group? Do people in this particular group promotenew IPOs or they are just like equity/bond/deri...

<r>Hi everyone,I recently apply for a company, and I am asked to take an online ability screening test writtenby SHL Solutions. (website: <URL url="http://www.shl.com">www.shl.com</URL>) Has anyone experienced the test before?I go to the corp page and it looks like there are two sections: numerial a...