Loop Rate of Change with Negative Values

3 views (last 30 days)
IDN
IDN on 19 Jan 2022
Commented: IDN on 22 Jan 2022
Hello,
I would like to use a loop to calculate across a table a rate of change ( (Current Value - 4thValue) / 4th Value)).
I tried using "prcroc" but i doesnt work on negative values. Please see time series attached.
Thanks!

Accepted Answer

Mathieu NOE
Mathieu NOE on 20 Jan 2022
hello
I assumed that the time axis in your file is as folows : first (top value) is the oldest and last (bottom) is the newest
clc
clearvars
data = xlsread('VBC.xlsx');
% time axis supposed : first (top value) is the oldest and last (bottom) is the newest
% rate of change = (data(index) - data(index - 4))/data(index - 4)
RoC(1:4) = 0;
for ck = 5:numel(data)
RoC(ck) = (data(ck) - data(ck - 4))/data(ck - 4);
end
plot(RoC)

More Answers (0)

Products


Release

R2020a

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!