In article the task of creation of effective portfolios of securities arising in practical investment activities is considered. Theoretical calculations decisions, necessary for creation of algorithm, are analyzed. It is noted that a basis of calculations is calculation of risk and the expected profitability of both separate assets, and all portfolio in general. For creation of model eight issuers of securities and their real course profitability in ten months according to the Moscow exchange are used. The kovariatsion matrix and a vector of the average income by means of which two effective portfolios are calculated is constructed and the assessment of their profitability and risk is carried out. According to the obtained data the effective border is simulated and displayed graphically. All necessary operations are performed by means of MS Excel.

Keywords: efficient portfolio , portfolio theory , realized a lot of expected revenue , profitability , dispersion, risk , investment , securities , envelope curve , effective border