in Search

Excel Intraday Sheet

Last post 03-22-2008, 14:17 by Pyradius. 2 replies.
Sort Posts: Previous Next
  •  03-20-2008, 3:17 26729

    Excel Intraday Sheet

    Hi, I'm not able to load the following Excel sheet. Where is the mistake? Thank you!

     

    TICKER  PER   DATE   TIME   OPEN    HIGH   LOW    CLOSE
    US_EU  I  08/30/07  00:00:00   1.367500    1.367430   1.367450    1.367440
    US_EU  I  08/30/07 00:01:00   1.367400    1.367300   1.367400    1.367300
    US_EU  I  08/30/07 00:02:00   1.367350    1.367250   1.367250    1.367350
    US_EU  I  08/30/07 00:03:00   1.367350    1.367250   1.367350    1.367300


    Alberto
  •  03-22-2008, 5:05 26732 in reply to 26729

    Re: Excel Intraday Sheet

    ok I solved, there was a problem in the time format.

    Now I correctly see the file in Downloader but I'm not able to open the file from Metastock.
    When I try to open the file with FILE / OPEN in Metastock I dont'see it in the folder.
    I selected the option "view all files" but I only see .DAT files.

    Thank you.



    Alberto
  •  03-22-2008, 14:17 26733 in reply to 26732

    Re: Excel Intraday Sheet

    Which version of MetaStock are you using?  An End-of-Day MetaStock will never be able to open an Intraday security file.
View as RSS news feed in XML