Pivot Table

%3CLINGO-SUB%20id%3D%22lingo-sub-2744335%22%20slang%3D%22en-US%22%3EPivot%20Table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2744335%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20to%20create%20Pivot%20table%20and%20analyze%20monthly%26nbsp%3B%3CSPAN%3Eaverage%20and%20standard%20deviation%20of%20stock%20price%3F%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2744335%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2744435%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20Table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2744435%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1153762%22%20target%3D%22_blank%22%3E%40pdurante%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EStart%20with%20a%20table%20that%20records%20the%20monthly%20prices%20of%20the%20stocks%20in%20question.%20Do%20you%20have%20that%20starting%20point%3F%20Once%20you%20have%20the%20data--and%20it%20could%20be%20daily%20prices%2C%20which%20will%20get%20averaged%20into%20monthly--the%20Pivot%20Table%20aspect%20is%20straight%20forward.%20Go%20to%20YouTube%20for%20videos%20on%20setting%20up%20Pivot%20Tables.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere's%20a%20starter%20for%20you.%20You%20may%20want%20to%20play%20around%20with%20the%20Pivot%20Table%20layout.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

How to create Pivot table and analyze monthly average and standard deviation of stock price?

1 Reply

@pdurante 

 

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.