Excel Portfolio Optimisation Template

Creating an Excel Template for Portfolio Optimisation of financial investments with reweighting of capital allocation.

The Portfolio Optimisation template should be able to identify the optimal capital weightings for a portfolio of financial investments that gives the highest return for the lowest risk based on the return risk profile and correlation between individual investments. Specifics about the template are as follows:


1. Inputs of historical data for the analysis should be supported by options to specify absolute prices or returns, number of current units held and a tool to download long time periods of financial market data for securities.

2. Function to include capital amount to starting portfolio weightings.


1. Optimisation option should include the setting of minimum and maximum constraints for weightings in the optimal portfolio.

2. Sharpe ratio is to be included for risk analysis options for overall volatility.

3. Sortino ratio for downside risk or semi-deviation.

4. Omega ratio for gain or loss.


1. Results should be displayed with weighting charts and return distributions.

2. Results should also indicate acquisition and liquidation actions required.

3. Technical analysis should also be provided with back tested total return from signal trading and automatic optimisation of technical parameters.

Important points:

1. OPTIONAL: The inclusion of the Monte Carlo simulation which calculates the probability of attaining the specific target return.

2. Several pictures have been attached as a reference to the layout of the template.

3. An incentive payment of USD 10 will be provided if the Monte Carlo simulation can be included in the template.

Lastly, If you have read through all the way, please start your reply with "good day". Thank you.

Skills: Accounting, Data Processing, Excel, Finance, Templates

See more: portfolio optimisation excel, portfolio optimisation template, trading portfolio excel template, excel template financial portfolio, portfolio excel template, template prices, signal financial, ratio in accounting, profile portfolio, prices template, gain capital, excel for data analysis, data analysis with excel, can 0 be a probability, automatic data processing, accounting is important, accounting for investments, ratio analysis , market technical analysis, securities, risk analysis, optimisation, omega, monte, Financial data analysis

About the Employer:
( 0 reviews ) Manchester, United Kingdom

Project ID: #4312754

6 freelancers are bidding on average $244 for this job


Please see PM

$950 USD in 10 days
(12 Reviews)

good day - have done quantitative analyst in the past.

$300 USD in 7 days
(1 Review)

I am an economist graduate from Athens University of Business and Economics with over 6years experience in accounting, business and financial analysis, and excel.I am certificated from Economic Chamber of Greece in r More

$60 USD in 15 days
(2 Reviews)

Good Day I am a postgraduate student in Finance from Newcastle university. Currently I am a partly qualified actuary from the UK body, the Institute and Faculty of Actuaries. You requests make perfect sense to m More

$60 USD in 15 days
(0 Reviews)

good day- I am a quantitative financial analyst with 3 years work experience and a master degree in finance (quantitative concentration). I have done very very similar projects before and I believe I can take care of t More

$60 USD in 15 days
(0 Reviews)

Hello, I have the set of skills needed for this project hope to work for you thank you

$31 USD in 1 day
(0 Reviews)