NexusFi: Find Your Edge


Home Menu

 





NT files into Excel


Discussion in NinjaTrader

Updated
    1. trending_up 1,369 views
    2. thumb_up 2 thanks given
    3. group 2 followers
    1. forum 4 posts
    2. attach_file 0 attachments




 
Search this Thread

NT files into Excel

  #1 (permalink)
 CFP462 
Phoenix Arizona
 
Experience: Beginner
Platform: NinjaTrader
Trading: Futures
Posts: 7 since Oct 2012
Thanks Given: 2
Thanks Received: 1

First off, I apologize if this information is already on here, I was unable to find it via the search function.

I was wondering if anyone knows how to convert NinjaTrader tick data into something I can use in Excel.

Thank You.
CFP

Started this thread Reply With Quote

Can you help answer these questions
from other members on NexusFi?
Pivot Indicator like the old SwingTemp by Big Mike
NinjaTrader
Better Renko Gaps
The Elite Circle
Exit Strategy
NinjaTrader
MC PL editor upgrade
MultiCharts
Trade idea based off three indicators.
Traders Hideout
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Spoo-nalysis ES e-mini futures S&P 500
29 thanks
Just another trading journal: PA, Wyckoff & Trends
25 thanks
Tao te Trade: way of the WLD
24 thanks
Bigger Wins or Fewer Losses?
22 thanks
GFIs1 1 DAX trade per day journal
17 thanks
  #2 (permalink)
 
Big Mike's Avatar
 Big Mike 
Manta, Ecuador
Site Administrator
Developer
Swing Trader
 
Experience: Advanced
Platform: Custom solution
Broker: IBKR
Trading: Stocks & Futures
Frequency: Every few days
Duration: Weeks
Posts: 50,442 since Jun 2009
Thanks Given: 33,215
Thanks Received: 101,603


CFP462 View Post
First off, I apologize if this information is already on here, I was unable to find it via the search function.

I was wondering if anyone knows how to convert NinjaTrader tick data into something I can use in Excel.

Thank You.
CFP

You can use any number of existing tools on futures.io (formerly BMT) or in download section (search "Export") to get data into OHLC format.

Or you can use any number of existing threads on futures.io (formerly BMT) where tick data exists and it is already in such format.

However, using Excel for this task is generally impossible due to Excel row limits.

Mike

We're here to help: just ask the community or contact our Help Desk

Quick Links: Change your Username or Register as a Vendor
Searching for trading reviews? Review this list
Lifetime Elite Membership: Sign-up for only $149 USD
Exclusive money saving offers from our Site Sponsors: Browse Offers
Report problems with the site: Using the NexusFi changelog thread
Follow me on Twitter Visit my NexusFi Trade Journal Reply With Quote
Thanked by:
  #3 (permalink)
 CFP462 
Phoenix Arizona
 
Experience: Beginner
Platform: NinjaTrader
Trading: Futures
Posts: 7 since Oct 2012
Thanks Given: 2
Thanks Received: 1


Thanks Mike! You always know how to steer a guy in the right direction.

And yes using Excel is not ideal, but I have yet to find a system that accurately builds exotic charts. I don't know why they all seem to get it wrong but anytime using Kagi or P&F I run into serious consistency issues. So if you know any software that does this correctly I would be happy to hear about it .

Started this thread Reply With Quote
  #4 (permalink)
 
Big Mike's Avatar
 Big Mike 
Manta, Ecuador
Site Administrator
Developer
Swing Trader
 
Experience: Advanced
Platform: Custom solution
Broker: IBKR
Trading: Stocks & Futures
Frequency: Every few days
Duration: Weeks
Posts: 50,442 since Jun 2009
Thanks Given: 33,215
Thanks Received: 101,603

I would imagine Sierra Chart, or build your own.

I'm not aware of any problems with Ninja. You might be describing a design flaw of the bar itself.

Sent from my LG Optimus G Pro

We're here to help: just ask the community or contact our Help Desk

Quick Links: Change your Username or Register as a Vendor
Searching for trading reviews? Review this list
Lifetime Elite Membership: Sign-up for only $149 USD
Exclusive money saving offers from our Site Sponsors: Browse Offers
Report problems with the site: Using the NexusFi changelog thread
Follow me on Twitter Visit my NexusFi Trade Journal Reply With Quote
  #5 (permalink)
 
NJAMC's Avatar
 NJAMC 
Atkinson, NH USA
Market Wizard
 
Experience: Intermediate
Platform: NinjaTrader 8/TensorFlow
Broker: NinjaTrader Brokerage
Trading: Futures, CL, ES, ZB
Posts: 1,970 since Dec 2010
Thanks Given: 3,037
Thanks Received: 2,395


CFP462 View Post
Thanks Mike! You always know how to steer a guy in the right direction.

And yes using Excel is not ideal, but I have yet to find a system that accurately builds exotic charts. I don't know why they all seem to get it wrong but anytime using Kagi or P&F I run into serious consistency issues. So if you know any software that does this correctly I would be happy to hear about it .

Hi @CFP462,

I assume you have already looked into the details of how those bar-types work? As you know the OHLC do not accurately reflect price action. These bar types are great to run strategies in historic mode because they will likely win big, this id because the data is filtered, since the price action moved above and below what is printed on the final chart, this might be tricking you.

If this could be what you are experiencing, I would search futures.io (formerly BMT) for more on exotic bar types as there are cautions associated with most/all of them from a back testing perspective.

Nil per os
-NJAMC [Generic Programmer]

LOM WIKI: NT-Local-Order-Manager-LOM-Guide
Artificial Bee Colony Optimization
Visit my NexusFi Trade Journal Reply With Quote




Last Updated on May 1, 2014


© 2024 NexusFi™, s.a., All Rights Reserved.
Av Ricardo J. Alfaro, Century Tower, Panama City, Panama, Ph: +507 833-9432 (Panama and Intl), +1 888-312-3001 (USA and Canada)
All information is for educational use only and is not investment advice. There is a substantial risk of loss in trading commodity futures, stocks, options and foreign exchange products. Past performance is not indicative of future results.
About Us - Contact Us - Site Rules, Acceptable Use, and Terms and Conditions - Privacy Policy - Downloads - Top
no new posts