Geometric mean for a specific time intervals
4 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Hi all,
say that I have a matrix (NX2) where the first column's elements are the number of seconds (since midnight) and the second column is stock returns associated to associated to the seconds. How can I use the function geomean and compute the geometric returns for a specific time interval? Say the geomean returns at every minute interval? The problem is that I might have say 4 stock returns in some specific minute interval and sometime 10 returns in another interval. If I extract all the trades by minutes, the numbers of returns registered in each minute interval will not be the same. Thank you!
2 Kommentare
Akzeptierte Antwort
Andrei Bobrov
am 1 Jun. 2012
data = [(1:130)', randi(100,130,1)];
out = accumarray(ceil(data(:,1)/60),data(:,2),[],@geomean,NaN);
0 Kommentare
Weitere Antworten (1)
Siehe auch
Kategorien
Mehr zu Multirate Signal Processing finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!