请问下,WLD5导入ASCII时与WLD3细节上有什么不同?

Discussion in 'Wealth-Lab Developer' started by boymail, Jan 9, 2010.

  1. 研究 WLD5 时,发现导入自己的 ASCII 数据文件出错,提示说:

    该字符串未被识别有效的 datatime

    感觉比较奇怪,因为在 3 下是一样的设置是可以的,到了 5 来就不行了?
    是不是有什么细节方面没有注意到?

    设置如下:
    Date(or Date With Time)
    Open
    High
    Low
    Close
    Volume
    Open Interest



    Date Format: yyyy-MM-dd H:mm
    Field Separator: Comma
    Decimal Separto: Period
    Thousands Separator: none
    Ignore First Line in file: 0
    Ignore Last Lines in File: 0
    Volume Multiple: 1
    Implied Decimals:0

    数据格式如下:
    2007-10-18 13:50,9224,9228,9214,9218,872,95798
    2007-10-18 13:55,9216,9218,9210,9216,1172,95626
    2007-10-18 14:00,9216,9228,9212,9226,1094,95396
    2007-10-18 14:05,9226,9234,9224,9232,1304,95676
    2007-10-18 14:10,9232,9232,9224,9232,982,95494
    2007-10-18 14:15,9230,9238,9230,9234,1050,95260
    2007-10-18 14:20,9234,9238,9230,9234,886,95312
    2007-10-18 14:25,9236,9238,9232,9236,1056,95404
    2007-10-18 14:30,9236,9246,9236,9244,1308,95056
    2007-10-18 14:35,9244,9246,9240,9242,1058,94818
    2007-10-18 14:40,9242,9242,9234,9238,1122,94614
    2007-10-18 14:45,9238,9264,9234,9264,2624,93714
    2007-10-18 14:50,9266,9272,9248,9252,2196,93600
    2007-10-18 14:55,9252,9254,9240,9240,1410,93478
    2007-10-18 15:00,9240,9250,9234,9244,1948,93186
    2007-10-19 09:05,9328,9352,9306,9350,8658,93708
    2007-10-19 09:10,9352,9366,9346,9346,5136,93944
    2007-10-19 09:15,9346,9348,9334,9336,3258,93926
     
  2. 试一下:
    Date Format: yyyy-mm-dd hh:mm
     
  3. 首先谢谢 hylt 的回复。
    这样试了不行,
    没办法,后来用 execel 打开ASCII 文件,把 datatime 那列改变格式
    yyyy-MM-dd H:mm,然后保存为 csv 文件,就OK了!
     
  4. 请问boymail:
    为什么我用你的数据后,在execel中分列后,数据可以显现。而我用execel自建数据保存为csv 文件,数据无法显现?
     
  5. 问题就在 H:mm 和 hh:mm上