Having difficulty filtering data and extracting some information from data.

1 回表示 (過去 30 日間)
Mate 2u
Mate 2u 2013 年 4 月 15 日
Dear all, I have a 1x3 Cell. In these 3 cells I have:
Column 1 (cell 600000 x 1), with dates in the form of mm/dd/yyyy
Column 2 (Single 600000 x 1), with prices.
Column 3 (uint16 600000 x 1) with trades.
I want to do the following:
1) Delete all entries which are not in 2008 (Delete the rest due to memory restrictions of making more matrixes/arrays)
2) Once I have all the data for 2008, I would like to store in a separate array the Last price for each day within 2008.
3) For 2008, I would like to store in a separate array the number of prices for everyday (there are uneven intervals).
4) Lastly for 2008, I would like to store in a seperate array the sum of trades everyday.
Therefore (2) and (3) will all be the same size.
  3 件のコメント
Mate 2u
Mate 2u 2013 年 4 月 15 日
Column 1: '09/10/2007' '09/10/2007' '09/10/2007'
Column 2: 12541 12541 12545
Column 3: 1 1 1
Mate 2u
Mate 2u 2013 年 4 月 15 日
segarray is our 1x3 cell with all the data
DateVector=datevec(segarray{1,1});
for i = 1:length(DateVector)
if DateVector(i,1) ~= 2008
segarray{1,1}(i,1)=[];
segarray{1,2}(i,1)=[];
segarray{1,3}(i,1)=[];
end
end
I thought this will solve 1) but no it doesn't.

サインインしてコメントする。

回答 (1 件)

Sean de Wolski
Sean de Wolski 2013 年 4 月 15 日
編集済み: Sean de Wolski 2013 年 4 月 15 日
Use datevec on your date string to idenitfy the year. Then use logical indexing to discard everything that is not in 2008.
doc datevec

カテゴリ

Help Center および File ExchangeFinancial Toolbox についてさらに検索

Community Treasure Hunt

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

Start Hunting!

Translated by