• If this is your first visit, you will have to register before you can post. To view messages, please scroll below and select the forum that you would like to visits. Questions? Be sure to check out the Forum FAQ.

Announcement

Collapse
No announcement yet.

Partner 728x90

Collapse

Exporting historical data

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    Exporting historical data

    20140102 130100;89.62;89.7;89.62;89.7;66
    20140102 130900;90;90;90;90;270
    20140102 131100;89.97;90;89.97;90;600
    20140102 131200;90;90;90;90;500
    20140102 132100;90.05;90.05;90.05;90.05;100
    20140102 133700;89.94;89.94;89.94;89.94;500
    20140102 134300;89.85;89.85;89.84;89.84;400
    20140102 135500;89.81;89.81;89.8;89.8;500
    20140102 135600;89.8;89.8;89.8;89.8;600
    above is an example of historical data from NT for a stock.

    I copy pasted in excel and delimted the columns using space and colon.

    now my question is; how do i edit the time stamps to see the actual time? i tried hhmmss as custom cell format but it gives me 12AM for all of them. any idea? thanks

    #2
    Hello calhawk01,

    Thank you for your post.

    I found an example under a Google search at the following link: http://www.extendoffice.com/document...dard-time.html
    Patrick H.NinjaTrader Customer Service

    Comment

    Latest Posts

    Collapse

    Topics Statistics Last Post
    Started by Sh00tHerMcGavin, Today, 07:39 PM
    0 responses
    3 views
    0 likes
    Last Post Sh00tHerMcGavin  
    Started by Mberg, Today, 05:13 PM
    0 responses
    1 view
    0 likes
    Last Post Mberg
    by Mberg
     
    Started by Barry Milan, Today, 01:33 PM
    2 responses
    10 views
    0 likes
    Last Post marcus2300  
    Started by NW Trader, Today, 03:42 PM
    2 responses
    8 views
    0 likes
    Last Post NW Trader  
    Started by ralett, Today, 01:42 PM
    1 response
    5 views
    0 likes
    Last Post NinjaTrader_ShawnB  
    Working...
    X