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:	26
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 ラリー, 11-22-2022, 04:57 AM
    11 responses
    67 views
    0 likes
    Last Post NinjaTrader_Emily  
    Started by sesplin, Yesterday, 07:53 PM
    2 responses
    13 views
    0 likes
    Last Post sesplin
    by sesplin
     
    Started by pezram, 09-28-2022, 11:27 AM
    7 responses
    57 views
    0 likes
    Last Post NinjaTrader_ChristopherJ  
    Started by Germanvibe, 11-23-2022, 09:22 PM
    1 response
    277 views
    0 likes
    Last Post NinjaTrader_ChristopherD  
    Started by Irukandji, Today, 05:29 AM
    1 response
    4 views
    0 likes
    Last Post NinjaTrader_ChristianN  
    Working...
    X