Get daily stock movement in %

Question

My goal is to get daily stock movement in % as follows in Google Sheets:

name  1JAN 2JAN 3JAN 4JAN 5JAN 
------------------------------
GOOG  1%   2%   1%   2%   1%  
BABA  2%   1%   3%   5%   6%

Can anyone pls advice. I am new to Google finance.

@Rob. Thanks for pointing out. Can you tell me what specific guideline does this question violates? — asdasd, Jan 05 '20 at 16:13
Clarify your specific problem or add additional details to highlight exactly what you need. Edit the question to limit it to a specific problem with enough detail to identify an adequate answer. https://stackoverflow.com/help/on-topic — Rob, Jan 05 '20 at 16:33

score 0 · Answer 1 · answered Jan 12 '20 at 22:42

How it works:

Input the desired dates and tickers. Tickers go across row 3.
Date will populate in 'getData' sheet. The formulas are made to be easily copy/pasted without any additional editing. Look at the change formula column C/F and feel free to edit the formula if this is not what you are looking for.
'reFormat' sheet will format your data according to your screenshot. Again the formulas are made to be easily copy/pasted or dragged across/down.

1 Answers1