Importing Ducascopy Tick Data

Importing Ducascopy Tick Data

clonex
2018-04-05 07:26:04

Hi, any idea how to properly set (date and) time format in order to import ducascopy tick data?
I have a problem to set correct time field.

2003.05.05 00:00:05.536,1.12161,1.12177,14.40,35.70
2003.05.05 00:00:06.561,1.12166,1.12182,0.80,0.60
2003.05.05 00:00:14.085,1.12163,1.12183,0.80,60.50
2003.05.05 00:00:14.420,1.12173,1.12183,16.00,0.70
2003.05.05 00:00:15.110,1.1217,1.1219,14.90,33.50
2003.05.05 00:00:15.445,1.12182,1.12192,5.00,14.80
2003.05.05 00:00:29.536,1.12175,1.1219,7.00,24.70
2003.05.05 00:00:30.561,1.12185,1.122,49.80,23.20
2003.05.05 00:00:31.687,1.12176,1.12196,18.00,0.80
2003.05.05 00:00:32.712,1.12187,1.12207,23.10,0.60
2003.05.05 00:00:46.607,1.12184,1.12199,4.70,0.90
2003.05.05 00:00:47.632,1.12194,1.12209,13.60,2.40
2003.05.05 00:00:49.880,1.12191,1.12206,0.90,71.80
2003.05.05 00:00:50.905,1.12199,1.12214,62.80,19.20

QuantShare
2018-04-06 05:10:15

Use a "Custom" date type with the following format:
[Y].[M].[D] [h]:[m]:[s].[i]

clonex
2018-04-06 07:15:53

Hi thanks - it helps, however, I get An OutOfMemory exception when trying import 12,6 GB tick data file.
I'm using 64-bit QS and have 12 GB ram on my computer.

QuantShare
2018-04-07 09:39:01

Please contact support by email regarding this with additional information about the tick data files.

Get more messages

No more messages

Back


Trading Items Historical Tick Data for U.S. Stocks Historical Intraday Data for U.S. Stocks Commitments of Traders - Historical Data Index Investment Data for U.S. Futures Markets AAII Sentiment Survey - Historical Data	How-to Lessons How to export trading data to a CSV file How to backup your databases (EOD, Intraday, Tick and Custom) and... How to download historical EOD data for penny stocks How to import trading data from CSV files How to create trading rules based on Put and Call volume data
Related Forum Threads Real Time Tick Data How do I Import Tick Data from a CVS file Importing data Importing daily metastock data Conversion error importing data	Blog Posts 6 ways to download free intraday and tick data for the U.S. stock... 6 New Ways to Download Free Intraday Data for the U.S. Stock Mark... How to Automatically Import Local Data Into QuantShare 4 Links to Download Free Historical Stock Prices Data by Date Download historical EOD data for the stock, futures, ETF and Fore...