Having difficulty filtering data and extracting some information from data.
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
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 commentaires
Réponses (1)
Sean de Wolski
le 15 Avr 2013
Modifié(e) : Sean de Wolski
le 15 Avr 2013
Use datevec on your date string to idenitfy the year. Then use logical indexing to discard everything that is not in 2008.
doc datevec
0 commentaires
Voir également
Catégories
En savoir plus sur Financial Toolbox dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!