Importing 60-Minute ASCII data
Author: VaFrie
Creation Date: 4/7/2013 10:26 AM
profile picture

VaFrie

#1
Hi,

I have a question regarding intraday data. I just downloaded the hourly data set from Stooq for the DAX (ASCII TextFile). I put the File into the data folder and wanted to add it to my data sets in wealth lab.

When Wealth lab asks me to chose a bar scale I cant chose the option hourly. Minute and daily are choosable but not hourly. Why is that?

profile picture

VaFrie

#2
Oh nevermind... 60min = 1 hour

FAIL
profile picture

VaFrie

#3
But I get the error message in the next step. I attached the image of my settings and an image of the text file. Could you tell me what I did wrong?
profile picture

Eugene

#4
Date format: yyyy-MM-dd
Time format: HH:mm:ss (not H:)
Ignore first lines in file: 1
profile picture

VaFrie

#5
Thx for your answer. Unfortunately I still have some problems (still error). I guess it is because the open interest (which is always 0) is not seperated from the date by comma? I tried to solve this by replacing all ",0" by "," and remove open interest from the list but it stil doesnt work. The error always states that there is a problem with the time :(

Btw. you said the time format should be: HH:mm:ss

But I can only chose hh:mm:ss tt

Does that make any difference?

Best regards
profile picture

Eugene

#6
QUOTE:
Unfortunately I still have some problems (still error). I guess it is because the open interest (which is always 0) is not seperated from the date by comma?


No, it's highly unlikely. Rather something with your text editor. As I said, typing in HH:mm:ss will fix it.

QUOTE:
But I can only chose hh:mm:ss tt


You can type in anything. This is a text field that can accept any values (see below) in order to adjust to any format imaginable.

QUOTE:
Does that make any difference?


Yes it does. The time here can not be represented as "H" and therefore will give an error.

For more, check out the User Guide > Data > Data Manager > Create New DataSet > Data Providers > ASCII > note on Date Format. The hyperlink to MSDN will give an idea how flexible is the ASCII provider.
This website uses cookies to improve your experience. We'll assume you're ok with that, but you can opt-out if you wish (Read more).