Announcement

Collapse
No announcement yet.

Partner 728x90

Collapse

Simple Import Errors

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

    Simple Import Errors

    Fellas-

    I'm not sure why I'm running into a wall with this but I'm trying to do a simple import of historical data into NT. In this case, it's the PE of the S&P 500 back a few years. It is simple daily data.

    I have created a file "SPXPE.last.txt", in what appears to be the correct format:

    19900131;11.7486
    19900201;11.655

    (yyyyMMdd, value)

    Each time I upload, the log tells me: SPXPE: Import field separator could not be identified. I have tried both to create a stock symbol for SPXPE and not creating one (i.e. letting NT create one on import). No success here. I can't believe I'm failing at this simple task.

    Do I need to add open/high/low/close/volume for this to work? Do I need to add filler semicolons where that info doesn't exist (i.e. 19900131;11.7486;;;

    #2
    Hello cgeorgan,

    Thanks for posting today.

    For Daily data, each bar must be on its own line and fields must be separated by semicolon. The format for these Daily data is as follows:
    yyyyMMdd;open price;high price;low price;close price;volume

    Sample data:
    20061023;1377.25;1377.25;1377.25;1377.25;86
    20061024;1377.25;1377.25;1377.25;1377.25;27
    20061025;1377.25;1377.25;1377.25;1377.25;24
    20061026;1377.50;1377.50;1377.25;1377.25;82

    Otherwise, it looks like your formatting of the file name is correct.

    More information on this topic can be found below:

    Comment

    Latest Posts

    Collapse

    Topics Statistics Last Post
    Started by CarlTrading, Yesterday, 11:51 AM
    0 responses
    12 views
    0 likes
    Last Post CarlTrading  
    Started by CarlTrading, Yesterday, 11:48 AM
    0 responses
    19 views
    0 likes
    Last Post CarlTrading  
    Started by CaptainJack, 03-25-2026, 09:53 PM
    0 responses
    16 views
    0 likes
    Last Post CaptainJack  
    Started by CaptainJack, 03-25-2026, 09:51 PM
    0 responses
    13 views
    0 likes
    Last Post CaptainJack  
    Started by Mindset, 03-23-2026, 11:13 AM
    0 responses
    18 views
    0 likes
    Last Post Mindset
    by Mindset
     
    Working...
    X