There is no common format for storing time series. Accordingly it is impossible for a program like NOW to read and interpret all possible formats correctly. Therefor it may be necessary to convert the "raw data" into the format as required by NOW, first. Note: in all cases feel free to contact DSI’s support team for assistance.
date, “Commodity Prices Gold”, “Commodity Prices Platinum”, “Commodity Prices Silver”
The first row is reserved for the header information – “date” followed by the time series codes/descriptions, each separated from the previous by “,”, “;” or tab. NOW imports time series for monthly, quarterly and annual data. So it is necessary to serve NOW with the correct “date” format:
monthly data: yyyy-mm (mm: 01, 02, 03, …, 12)
quarterly data: yyyy-01 (1st quarter)
yyyy-04 (2nd quarter)
yyyy-07 (3rd quarter)
yyyy-10 (4th quarter)
annual data: yyyy
The time series formats, e.g. decimal characters “,” or “.”, are interpreted automatically.
The source comes with more than one header line: delete the redundant title rows and keep the row that defines the time series in the corresponding columns..
The source shows another “data” format than indicated above: replace it by the valid format.
The source provides the time series in rows: transpose the source into columns first, and sort them e.g. with Excel by using transpose- or pivot-functionalities.