Sep 12 2021 02:39 PM
How to create Pivot table and analyze monthly average and standard deviation of stock price?
Sep 12 2021 04:37 PM
Start with a table that records the monthly prices of the stocks in question. Do you have that starting point? Once you have the data--and it could be daily prices, which will get averaged into monthly--the Pivot Table aspect is straight forward. Go to YouTube for videos on setting up Pivot Tables.
Here's a starter for you. You may want to play around with the Pivot Table layout.