Optimum Stock Portfolio App Development

Closed Posted 2 months ago Paid on delivery
Closed Paid on delivery

The assignment involves developing an application that will allow the users to

determine an optimum stock portfolio using a minimum portfolio variance model

based on the average annual returns and correlations of at least 5 stocks based on

stock data from at least the last 3 years.

You have the choice of giving the user a fixed selection of the stocks, allowing the

user to choose a stock based on their input of a ticker symbol, or allowing the user

to choose based on a list that your program provides. Once all the stocks are

chosen the program must download the stock price data from the chosen website

and analysis the data for the annual rate of returns and the needed correlations.

Please note for this assignment the annual returns of each stock can be calculated

as simply as using the opening price on Jan 1 and the closing price on Dec 31 of

each year.

Your Task

Develop an application that allows your user to input their stocks and returns a

portfolio optimization for the chosen stocks.

Your user is a moderately sophisticated investor but is not very sophisticated when

it comes to using computer applications. The user has requested that the

application show the number of each stock in the optimized portfolio based on the

stocks they have chosen. The investor is looking to hold a maximum of 750 stocks

in this portfolio. Assume your investor is starting with no stock holdings in this

portfolio. The investor also wants to know the cost of the portfolio including the

$29.99 cost that the website brokerage charges the investor per firm when stocks

are purchased. The investor is looking to make at least a 6% return on the portfolio

and is not a high-risk investor and as such they are looking to minimise the variance

of the portfolio.

You have been supplied with a basic optimization model to base your model and

application on. The file is BTMA 459 Portfolio Optimization Sample

Excel Macros Excel

Project ID: #38804357

About the project

6 proposals Remote project Active 1 mo ago

6 freelancers are bidding on average $211 for this job

schoudhary1553

Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 900 + Projects. I have 6 + years of the experience in same kind of projects. If you are look More

$180 CAD in 3 days
(549 Reviews)
8.5
Daksheshmahaur96

As an MIS Data Management and VBA Developer, I have the precise skills you need for this project. My advanced knowledge of Excel and experience in developing complex formulas and pivot tables are particularly relevant More

$140 CAD in 7 days
(28 Reviews)
3.9
Rehmantech

Hello bobnill28 Hello, I understand your requirements completely. Being a Full Stack Developer, I have rich experience 9 years and I am sure of my ability to complete your project according to your requirements, with More

$160 CAD in 4 days
(0 Reviews)
2.7
AdrianaG1818

I am an organized person. I like to deliver projects on time and demonstrate my professionalism I'm focused on what I'm doing and the result is on point

$140 CAD in 7 days
(0 Reviews)
0.0