• 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

Import Historical Data .CSV?

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

    Import Historical Data .CSV?

    Hey there,

    So I got a .csv file with historical data.
    the file looks like this:

    Code:
    time,close,high,low,open,volumeFrom,volumeTo
    1529726040,466.22,466.24,465.98,466.02,238.09,114910.72
    1529726100,466.49,466.51,466.22,466.24,152.48,72515.5
    1529726160,466.62,466.62,466.6,466.6,55.39,27631.81
    1529726220,466.45,466.62,466.4,466.62,56.3,29188.74
    1529726280,466.45,466.54,466.42,466.45,70.93,36575.85
    1529726340,466.49,466.49,466.45,466.45,104.04,51452.59
    the timestamp is UNIX/EPOCH.

    How would import this historical data into ninjatrader7?

    Do i need the format ".last" instead of ".csv"?

    If so, how can I easily convert a .csv file into a .last file?

    Is there another way to import this historical data into nt7?
    Last edited by SpaceGrey; 06-24-2018, 09:08 AM.

    #2
    Hello SpaceGrey,

    You will need to change the format of the file contents to:
    yyyyMMdd HHmmss;open price;high price;low price;close price;volume
    20061023 004400;1377.25;1377.25;1377.25;1377.25;86

    And the file name to Instrument.Last.txt or Instrument.Last.cvs.

    Below is a public link to the help guide. Please see the section 'Understanding import file and data formats'.
    https://ninjatrader.com/support/help.../importing.htm
    Chelsea B.NinjaTrader Customer Service

    Comment

    Latest Posts

    Collapse

    Topics Statistics Last Post
    Started by Botan626, Today, 04:43 AM
    0 responses
    2 views
    0 likes
    Last Post Botan626  
    Started by xsgex, Yesterday, 09:46 PM
    0 responses
    3 views
    0 likes
    Last Post xsgex
    by xsgex
     
    Started by Steve L, Yesterday, 09:36 PM
    0 responses
    4 views
    0 likes
    Last Post Steve L
    by Steve L
     
    Started by krugman25, Yesterday, 09:34 PM
    0 responses
    4 views
    0 likes
    Last Post krugman25  
    Started by indy73, Yesterday, 04:42 PM
    0 responses
    15 views
    0 likes
    Last Post indy73
    by indy73
     
    Working...
    X