Please help with an excel formula

%3CLINGO-SUB%20id%3D%22lingo-sub-1329619%22%20slang%3D%22en-US%22%3EPlease%20help%20with%20an%20excel%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1329619%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3ESo%20I%20have%20a%20dataset%20of%20monthly%20stock%20returns%20from%20January%202000%20until%20today%20for%20six%20different%20stock%20indices.%20At%20the%20bottom%20of%20the%20page%2C%20I%20want%20to%20show%20the%20yearly%20return%20for%20each%20year%20as%20a%20percentage%20change%20from%20the%20previous%20year%20(i.e.%20I%20want%20to%20create%20a%20table%20with%20one%20column%20having%20'2001'%2C%20'2002'%20and%20the%20other%20column%20having%20'8%25'%2C%20'-4%25'%20etc.%20What%20command%20would%20I%20use%3F%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EI%20want%20to%20calculate%20the%20percentage%20change%20from%20december%2031st%20of%20year%20n%20to%20december%2031st%20of%20year%20n%2B1%20for%20every%20single%20year%20for%20the%20stocks%20in%20image%201%20and%20place%20it%20in%20the%20table%20format%20of%20image%202.%20Is%20there%20a%20command%20that%20would%20let%20me%20do%20this%2C%20as%20well%20as%20dragging%20it%20down%20so%20that%20it%20works%20for%20all%20years%3F%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1329619%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20mobile%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Visitor

So I have a dataset of monthly stock returns from January 2000 until today for six different stock indices. At the bottom of the page, I want to show the yearly return for each year as a percentage change from the previous year (i.e. I want to create a table with one column having '2001', '2002' and the other column having '8%', '-4%' etc. What command would I use?

 

I want to calculate the percentage change from december 31st of year n to december 31st of year n+1 for every single year for the stocks in image 1 and place it in the table format of image 2. Is there a command that would let me do this, as well as dragging it down so that it works for all years?

 

0 Replies