How to import data
I have been unable to find an explanation of how to import data to be displayed in charts. When I try using Import, nothing happens. When importing into a database table or a spreadsheet there is usually a wizard which allows the user to specify the format of the data file (tab, comma, etc. delimited, fieldnames in the first line or not, etc.); I've not found anything like that in q4d.
Below is a list of tab separated sample data; I can convert it to whatever format is necessary for q4d to understand how to import but I can't find any information on that either.
The data list contains five columns. The first is a symbol (it can repeat), the second and third columns are the start and end bar numbers of an interval; the fourth and fifth columns are the start and end datetimes corresponding to the aforementioned bars. I also have raw ratio data from which the interval information was extracted.
I would like to create ribbon charts from four text files containing data in the interval format below and one with the ratio data. I would also like to rotate the charts to view them from different angles and align them to visually compare them over time.
How would I do this?
1 0 1 2007-06-25T16:15:00 2007-06-26T16:15:00