How to asci import file with date in this format YYYYMMDD

How to asci import file with date in this format YYYYMMDD

Back to threads

jgf
2012-09-09 16:52:58

ex. today 20120909
Tried custom [YYYY][MM][DD] not working
tried [Y][M][D]
result 209/09/0 0:0:0:0

QuantShare
2012-09-10 14:04:39

[Y][M][D] should work. You probably have extra spaces or formatting issue in your data.

Please send us a file sample at support@quantshare.com

jgf
2012-09-10 15:41:28

No i don't have, Copy pasted line:
4FUNMEDIA,20101130,17.20,17.20,15.50,15.94,24307
no spaces in here.
all other fields import just right
sending file to mentioned email for confirmation

QuantShare
2012-09-10 16:39:22

You cannot parse dates because you have set "20" under "Exclude". (Click on the "Exclude" button)

Get more messages

No more messages

Back


Trading Items EODData Daily Import Derivatives: Number of days until the expiration date Year to Date Excess Return Export Indicators Data with Filtering and Column Labels Support Days To Next Date	How-to Lessons How to import trading data from CSV files How to import your own list of stocks/symbols How to import trades into a portfolio How to create a chart with a black background How to export trading data to a CSV file
Related Forum Threads How do I Import Tick Data from a CVS file Custom Date Format When Importing Data from CSV Global Script For How To Export In MetaStock Format In Ascii Layo... How to import reconstructed global sovereign bonds How to import Bid, Ask and Trade ticks from CSV file?	Blog Posts How to Automatically Import Local Data Into QuantShare How to deal with StockTwits data How to Backtest an Intraday Stock Trading System with EOD Ranking How to Optimize a Trading System with Thousands of Billions of Co... Industry Analysis - How to Compare Stocks with their Industries