To do the graph you would want to log the numbers by day and then graph them.
See https://answers.yahoo.com/question/index...
Okay so we have to use excel, select 5 stocks from the S&P 500 and watch them everyday. I am using yahoo finaince.
The criteria we use on excel are
Name of stock
Buy price
# of shares
Market price
Closing price
My question is specifically with # of shares. Is this how many shares I purchased? The thing is when I look at my classmates work i see something else.
Ie)
Buy price = 35.01
# of shares = 2285.0614
Market value = 80,000
Where the heck did he get # of shares? If you select the amount why is it a decimal?
The professor also said Please keep track of the daily performance of your portfolio and compare it to the return on the S&P 500. Your objective is to outperform the S&P 500 Index. You should keep a daily record and begin to graph the value of your portfolio relative to the SPY.
Can someone please explain this to me and how to do it?
