Private auction for KrsMurali (from ) on 2/9/2006 7:01:06 AM

The programme is to be completed using excel vb, it need to be able to down loads the ftse 100 from the net onto excel, and create a portfolio optimisation tool that uses the Mean Variance model. The program will need to be able to calculate the "Morkowitz Mean Variance Model" and plot the efficient frontier and a chart showing percentage of an assets invested in each stock. The maximum number of stocks is not to be greater then 20. This program will need mathermatical calculations in the for of sandard deviation etc. The programe will need to be completed fairly quickly. Due to the complexity being very simple i hope this will not be a problem? Are you good at maths and do you understand markowitz theory? ## Deliverables 1) Complete and fully-functional working program in executable form as well as complete source code of all work done. 2) An explanation of each line of code, explaining its purpose. 3) The program must be very simple, and be connected to a vb gui. ## Platform windows xp etc my computer is fairly new so should not be a problem.