SmartQuant Discussion

Automated Quantitative Strategy Development, SmartQuant Product Discussion and Technical Support Forums
It is currently Sun Sep 24, 2017 6:11 am

All times are UTC + 3 hours




Post new topic Reply to topic  [ 5 posts ] 
Author Message
PostPosted: Mon Feb 06, 2017 9:39 pm 
Offline

Joined: Tue Oct 13, 2009 12:19 pm
Posts: 195
Dear all,

I tried to import daily csv data.

I exported it from my testing computer via OQ. The format was like this:
DateTime,Open,High,Low,Close,Volume,OpenInt
2017-01-03 23:59:59.999,225.04,225.83,223.8837,225.24,91366522,0

When I imported, I tried to use the right date time values, for the first colum, but no matter what I tried, even if added a comma in the date time field, so that I would have two fields:
2017-01-03,23:59:59.999,....
the date time information was only imported into the time field. Never anything in the date field.

Can you please fix this?

Regards
Mike


Top
 Profile  
 
PostPosted: Fri Feb 10, 2017 11:00 am 
Offline

Joined: Wed May 05, 2010 9:49 pm
Posts: 367
for values like 2017-01-03 23:59:59.999
DateTime format is:
yyyy-MM-dd HH:mm:ss.fff


Top
 Profile  
 
PostPosted: Thu Feb 16, 2017 8:48 pm 
Offline

Joined: Tue Oct 13, 2009 12:19 pm
Posts: 195
thx. I know that, but it does not change the result for the import. It does not take the time value in.

Please try attached if that works for you.

Regards
Mike


Attachments:
SPY.Bar Time Day.zip [282 Bytes]
Downloaded 23 times
Top
 Profile  
 
PostPosted: Fri Feb 17, 2017 10:42 am 
Offline

Joined: Wed May 05, 2010 9:49 pm
Posts: 367
mikembb wrote:
thx. I know that, but it does not change the result for the import. It does not take the time value in.

Please try attached if that works for you.

Regards
Mike


Imported properly:
Attachment:
ImportSettings.png
ImportSettings.png [ 43.8 KiB | Viewed 510 times ]

Attachment:
Data.png
Data.png [ 18.96 KiB | Viewed 510 times ]


Top
 Profile  
 
PostPosted: Fri Feb 17, 2017 12:44 pm 
Offline

Joined: Tue Oct 13, 2009 12:19 pm
Posts: 195
ok, thx.

I thought the date field also needs to be populated when looking at the data.

Regards
Mike


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 5 posts ] 

All times are UTC + 3 hours


Who is online

Users browsing this forum: No registered users and 4 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB® Forum Software © phpBB Group