Info

This question is closed. Reopen it to edit or answer.

Choice of data structure (numeric & date/time)

1 view (last 30 days)
F. Bondeau
F. Bondeau on 26 Jun 2017
Closed: MATLAB Answer Bot on 20 Aug 2021
Which datastructure for this type of data:
Time/date| Open|High|Low|Close|Volume 19.06.201700:00:00.000|142.247|142.247|142.247|142.247|4.734.399.915
So 6 columns and (in)finite amount of rows.
I’m struggling with the date/time (how to apply it to a specific column) and with the decimals.
I’m thinking about storing it as a cell array but it takes a lot of memory and it’s a little bit circuitous.
I will be using the data for stock analyzing/applying under the econometrics toolbox.
I've used MATlab in a course called Numerical Mathematics but only for calculations so I'm fairly new to data analysis.
I thank you in advance!

Answers (1)

Steven Lord
Steven Lord on 26 Jun 2017
If you're using release R2016b or later, consider using a timetable to store your data. If you're reading your data from a file, the first example on the "Create Timetables" topic page will be of use to you.

Community Treasure Hunt

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

Start Hunting!