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 argusthome, 03-08-2026, 10:06 AM
    0 responses
    64 views
    0 likes
    Last Post argusthome  
    Started by NabilKhattabi, 03-06-2026, 11:18 AM
    0 responses
    41 views
    0 likes
    Last Post NabilKhattabi  
    Started by Deep42, 03-06-2026, 12:28 AM
    0 responses
    22 views
    0 likes
    Last Post Deep42
    by Deep42
     
    Started by TheRealMorford, 03-05-2026, 06:15 PM
    0 responses
    25 views
    0 likes
    Last Post TheRealMorford  
    Started by Mindset, 02-28-2026, 06:16 AM
    0 responses
    52 views
    0 likes
    Last Post Mindset
    by Mindset
     
    Working...
    X