Separate names with a comma.
Yes - I tried that but nothing. I put it down to a dysfunctional work laptop. It works fine at home. Nice work on this solution, comfortably...
I can see your logic here, though cant get the formula to work for the life of me! ...unfortuanately this wouldnt work if you had a 3 (or more)...
Using the EXACT function instead of IF will shave off a few characters off the formula, though there must be a much shorter solution! Chris
I'll kick off with a not so elegant solution: =IF( LEN(SUBSTITUTE(LOWER(SUBSTITUTE(A1," ","")),"a",""))&...
A slight edit of this gives an even shorter solution: =8-WEEKDAY(DATE(A2,A1,1),12) Edit: Muppet beat me to it!
slightly shorter: =MOD(10-MOD(DATE(A2,A1,1)+1,7),7)+1 Sad to hear that these will stop. I normally don't contribute as great solutions are...
Has anyone else had webcam / audio issues? For my first attempt at CA3 my self evaluation presentation recorded fine, and I got the all clear...
I agree with both of you. I guess the alternative way of thinking is; rather than thinking in extreme movements of the underlying share price,...
Hi All, I've just got my feedback from Assignment X2 back. For Q7 iv, I suggested that the investor could borrow money to buy call options, but...
Thank you - I will try this again tonight. Thanks too r.e. implied volatility. I was thrown by the comment at the end of chapter 14.
I'm sure a tutor will weigh in with the correct, clearer, more thorough solution... but, as you have calculated the return on the market...
Are we required to derive the equation at the bottom of page 19 in this chapter - i.e. the one that shows the portfolio is risk free? I've tried...
Thank you Graham, I'd got to the second equation but couldn't see where to go from there. Very helpful.
Edit - I mean Q5.6 Hi, I understand the proof of the minimum variance formula (i.e. by differentiating Vp with respect to Xa). Are we required...
