Last Tick Hourly Historical Data Bulk Export into Excel

[AlexCA01]

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

[NinjaTrader_Spencer]

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:

• Import or export text (.txt or .csv) file

Please let me know if I may be of any further assistance.