Instructions

Choose $4$ different stocks from any publicly listed companies

Find the closing prices for these stocks on September $20,2024$ as the purchase price, and September $26,2024$ as the current price

Use these stock prices to complete the following tasks

Task $1$: Collect Stock Prices Data and Create Vectors

Choose $4$ different stocks and note their ticker symbols $($e$.$g$.,$ AAPL for Apple, MSFT for Microsoft, etc.$).$

Use an online source $($such as Yahoo Finance or Google Finance$)$ to find the closing prices of these stocks on the following dates:

Purchase price: Closing price on September $20,2024.$

Current price: Closing price on September $26,2024.$

Create three vectors:

stock$\_$tickers: Stock ticker symbols $($e$.$g$.,$AAPL$,$MSFT$,$GOOG$,$AMZN$).$

purchase$\_$prices: The closing prices on September $20,2024.$

current$\_$prices: The closing prices on September $26,2024.$

# write your code

Task $2$: Write a Function to Calculate Returns and Use a Loop

Define a function CalculateReturn$($current$\_$price, purchase$\_$price$)$ that

Takes the current price and purchase price as inputs

Calculate the percentage return using the formula:

Percentage Return$=$Current Price$$Purchase PricePurchase Price$\backslash$times $100$

Use a for loop to apply this function to each stock and create a new vector returns that stores the percentage return for each stock.

Task $3$: DataFrame

Create a DataFrame portfolio$\_$df with the following columns:

Stock: Stock ticker symbols.

Purchase$\_$Price: Purchase prices from Task $1.$

Current$\_$Price: Current prices from Task $1.$

Return: The percentage return from Task $2.$

Use the ifelse$()$ function to create a new column Trade$\_$Decision based on the following conditions:

$$Sell$$ if the return is greater than $3\%.$

$$Sell$$ if the return is less than $-1\%.$

$$Hold$$ otherwise.

Task $4$:Calculate Realized Profit$/$Loss Based on Trade Decisions

Bouns Points: Vectorize the calculation for Task$4$

Loop through the portfolio and check the trade decision. If the decision is $$Sell$,$ calculate the realized profit for that stock:

Realized Profit$/$Loss$=$Current Price$$Purchase Price

Sum the realized profits$/$losses for all stocks.

Print the total realized profit$/$loss for the portfolio.