How to sum a specific number of observations through an entire dataset

1 次查看（过去 30 天）
Anders
Anders 2012-12-27
评论： Mutia Rahmadini 2021-10-2
Hi!
Im totally new to Matlab, but not new to programming. Im in the process of create a buy/sell signal on a collection of logarithmic returns on equity. To create the signal I need to sum up the log returns for n periods (from 2 to 15) and if the sum is positive=buy (vice versa). So my question is how can I do it? Have tried to search for an answer but havent found one. (Been introduced to symsum etc, but didnt manage to get it to work)
to give an example, this is 15 of my log returns;
  • -0,003486069
  • -0,00047011
  • -0,00163133
  • -0,000500125
  • -0,007125325
  • 0,000619808
  • 0,015115188
  • -0,000310048
  • 0,00494774
  • -0,010040235
  • 0,001798382
  • 0,006518707
  • -0,014322073
  • 0,000809672
  • 0,004320653
Since there is 15 returns, using n=10, I should end up with 5 different sums for the last 5 periods.
Any help is much appreciated!

请先登录，再回答此问题。

采纳的回答

Roger Stafford
Roger Stafford 2012-12-27
Use cumsum. If your "log returns" are called 'LR', do this:
c = cumsum(LR);
s = c(n+1:15)-c(1:15-n);
For n = 10 that would give s the five sums, 2 to 11, 3 to 12, 4 to 13, 5 to 14, and 6 to 15.
Roger Stafford
  3 个评论
显示 1更早的评论
Image Analyst
Image Analyst 2021-10-1
Why do you think 'freq_list' should exist? It's not there (yet). You need to define it somehow, like read in data from a file or something.
Mutia Rahmadini
Mutia Rahmadini 2021-10-2
how sir? btw i have a data frquency and power from csv file. and what should i do with the range i made (freq_list)? i want to sum the data that is in range only (low frequency, high frequency, and ratio)
please help me with the coding. i am a new for matlab.

请先登录，再进行评论。

更多回答（1 个）

Image Analyst
Image Analyst 2012-12-27
To get all 6 sums, if you have 15 elements and a sliding window of 10 elements and you want the sum of each window, use conv():
m = [...
-0.003486069
-0.00047011
-0.00163133
-0.000500125
-0.007125325
0.000619808
0.015115188
-0.000310048
0.00494774
-0.010040235
0.001798382
0.006518707
-0.014322073
0.000809672
0.004320653]
numElementsToSum = 10; % Change to whatever you want
mSum = conv(m, ones(numElementsToSum, 1), 'valid')
Results:
mSum =
-0.002880506
0.002403945
0.009392762
-0.003297981
-0.001988184
0.009457794
For n = 10 that would give s the six sums, 1 to 10, 2 to 11, 3 to 12, 4 to 13, 5 to 14, and 6 to 15.

类别

在 Help Center 和 File Exchange 中查找有关 Financial Toolbox 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by