Announcement

Collapse
No announcement yet.

Partner 728x90

Collapse

Last Tick Hourly Historical Data Bulk Export into Excel

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

    Last Tick Hourly Historical Data Bulk Export into Excel

    Hi Guys,

    I want to be able to download Hourly Tick Data, but I have to click on each Hour, then have data load, and then click export so I can save data in Excel.
    Is there any other way that I can download all these tick data for each day (end of day) in just one Excel sheet. I'm looking for a way to cut down on time spent behind monitor.

    Thank you all,
    Alex


    Click image for larger version

Name:	Capture.PNG
Views:	17
Size:	118.9 KB
ID:	1212574
    Attached Files

    #2
    Hello AlexCA1,

    Thank you for your post.

    Unfortunately, it is not possible to export the entire day directly into an excel file.

    However there is a possible workaround we may use using the Export function on the Load Tab and then importing the Text file into Excel.

    Below I have included steps on how to accomplish this:
    • Navigate to the Load Tab in the Historical Data window
    • Expand the 'Export' section
    • Select the Instrument, Interval, and Date range
    • Click 'Export'
    • Save the .txt file to a specified location on your computer
    • Open Excel > Create a Blank Sheet > DATA tab
    • Select 'From Text/CSV' in the top left corner
    • Select the .txt file > Import > Ensure the Semi Colon is select as the Delimiter > Load
    • You may then rename the Column headings to match the data for each column
      • I have provided a link to our NinjaTrader Help Guide on the Tick format for the .txt file: Data Formats
    I have also included a publicly available link on this Excel function for reference as well:Please let me know if I may be of any further assistance.
    Spencer F.NinjaTrader Customer Service

    Comment

    Latest Posts

    Collapse

    Topics Statistics Last Post
    Started by iceman2020, Today, 06:52 AM
    0 responses
    1 view
    0 likes
    Last Post iceman2020  
    Started by MattyU12, 09-30-2022, 07:50 PM
    1 response
    38 views
    0 likes
    Last Post NinjaTrader_Jason  
    Started by RobotSyndicate, 07-16-2022, 06:28 AM
    2 responses
    60 views
    0 likes
    Last Post RobotSyndicate  
    Started by tarikmedjber, Today, 03:45 AM
    1 response
    27 views
    0 likes
    Last Post tarikmedjber  
    Started by ironwarriorsale, Today, 03:33 AM
    0 responses
    17 views
    0 likes
    Last Post ironwarriorsale  
    Working...
    X