Menu
  • Option Hydra
  • Training
  • Premium
  • Courses
  • Library

Marketcalls

Simply Intelligent Technical Analysis and Trading Strategies

  • Software
    • Amibroker
    • NinjaTrader 7
    • Ninjatrader 8
    • Option Action
    • Market Analyst
    • Metatrader
    • Python
    • Datafeed
  • Market Profile
    • Orderflow
  • Markets
  • Commodities
  • Forex
  • Economy
    • Banking
  • Webinars
  • Trading Lessons
    • Algo Trading
    • Infographic
    • Video
You are here: Home / Amibroker / Export Amibroker Database to Ninjatrader EOD or 1min ASCII format

Export Amibroker Database to Ninjatrader EOD or 1min ASCII format

June 22, 2017 by Rajandran 12 Comments

If you are a Amibroker user and recently testing with Ninjatrader 7 or have plans to migrate your EOD or 1min database to Ninjatrader then probably you need to aware about Ninjatrader ASCII format for EOD and 1min data and import procedure to migrate your dataset.

To be noted Ninjatrader 1minute format is in GMT time zone format. so one have to ensure converting IST or any other time zone format to GMT time zone. Amibroker AFL code presented here supports converting from IST time zone to GMT time zone. The AFL also avails the functionality to export both Daily and Minute bars in ASCII format as shown below

Ninjatrader 1minute Format
Minute Bars Format
Each bar must be on its own line and fields must be separated by semicolon (;). Only 1 minute bars can be imported.

The format is:
yyyyMMdd HHmmss;open price;high price;low price;close price;volume

Sample data:

20170522 034559;157.15;158.00;157.15;157.90;469000
20170522 034659;158.05;158.05;157.20;157.30;290500
20170522 034759;157.40;157.80;157.25;157.40;357000
20170522 034859;157.40;157.45;156.90;157.00;262500

Ninjatrader Daily Format
Daily Bars Format
Each bar must be on its own line and fields must be separated by semicolon (;). Only 1 day bars can be imported.

The format is:
yyyyMMdd;open price;high price;low price;close price;volume

Sample data:

20170612;1377.25;1377.25;1377.25;1377.25;86
20170613;1377.25;1377.25;1377.25;1377.25;27
20170614;1377.25;1377.25;1377.25;1377.25;24
20170615;1377.50;1377.50;1377.25;1377.25;82

Amibroker AFL File to Export Amibroker Database to Ninjatrader ASCII format

Steps to Export Ninjatrader 7 ASCII format

1)Copy/Download Ninjatrader ASCII.afl and Save into Amibroker/formulas/Basic Charts or any other custom folders of your choice.

2)Goto C: Drive ->Create Folders amidata and create sub-folders named Daily and Minute inside amidata folder.

2) Open Amibroker and open the Database you want to import.

3)Goto New Analysis (Auto analysis for older version). Select the symbol or list of symbols(Filter -> Watchlist) need to be imported

4)Open the Parameter Box and Select the Daily or Minute Bars as shown in the video

5)Goto Settings -> Select the Period as 1minute / Daily timeframe which needs to be import into Ninjatrader 7 ASCII .txt format

6)Now Press Explore button. Ninjatrader 7 ASCII format gets exported to the relevant sub-folders inside amidata

7)Now Open Ninjatrader 7 Control Center -> goto Historical Data Manager

8)Now Press Start Import button – > Now Select the exported Ninjatrader 7 ASCII file and press open button

9)Bingo you are done. You will get a alert Historical data imported successfully message from the data manager.

10)Now open the charts from the control center and enjoy!

Related Readings and Observations

  • Tradezilla – Online Mentorship Program for TradersTradezilla – Online Mentorship Program for Traders Tradezilla is India's first ever exclusive and intensive ever online trading mentorship program for budding traders. Event will focus on providing quality information to Traders, […]
  • Why Algo Traders Stay Away From Traditional Trading Platforms?Why Algo Traders Stay Away From Traditional Trading Platforms? The so called Quant or Algo traders prefers to stay mostly away from Traditional trading platforms like Amibroker, Ninjatrader, Metatrader, Metastock, Tradestation etc. Do you know why?
  • Now Globaldatafeed Offers Realtime Datafeed for MCX MarketsNow Globaldatafeed Offers Realtime Datafeed for MCX Markets Globaldatafeed announces the launches much awaited product ‘Realtime Data Services for MCX’ today for Trading Softwares like AmiBroker, MetaStock, Advanced Get, NinjaTrader, Ensign & […]
  • [Online Workshop] Trading Strategies for Active Traders[Online Workshop] Trading Strategies for Active Traders Learn the nuances of trading/investing strategies, the art of chart reading and picking up high probability trades. It is an educational workshop for active traders focused on how to pick […]
  • Nifty Futures – Market Profile Outlook September SeriesNifty Futures – Market Profile Outlook September Series Nifty Futures went into sideways mode for the last 5 trading weeks in a high volatile fashion between 10800-11200 majority of the time and been sliding down continuously for the 9 trading […]
  • How to Estimate the VWAP based settlement Close like a Pro using Amibroker?How to Estimate the VWAP based settlement Close like a Pro using Amibroker? A lot of money could be saved/earned if you are weekly option buyer/option seller out there especially if you trade the last 30minute of the trade when comes to Indian Markets.

Filed Under: Amibroker, Ninjatrader Tagged With: Amibroker, Amibroker Database Export, Export ASCII format, NinjaTrader

About Rajandran

Rajandran is a Full time trader and founder of Marketcalls & Co-Founder of Traderscafe, trades mostly using discretionary Trading Concepts like Market Profile, Trading sentimental analysis, building timing models, algorithmic trading models. Instructs professional traders, full time traders & aspiring full time traders. Rajandran attended college in the Chennai where he earned a BE in Electronics and Communications. Rajandran has a broad understanding of trading softwares like Amibroker, Ninjatrader, Esignal, Metastock, Motivewave, Market Analyst(Optuma),Metatrader,Tradingivew,Python and understands individual needs of traders and investors utilizing a wide range of methodologies.

Comments

  1. GANGESH KUMAR says

    June 22, 2017 at 12:18 pm

    Hi Sir
    i have one indicator of NT7/ MT4 that can automatically copy data from live market & save at your desired location with desired format(tic, csv) , one can import this data in any software but historically only

    is there any way so that one can populate live data after setting local hard disk as a server

    Reply
    • Rajandran says

      June 22, 2017 at 1:34 pm

      You can do that with some simple tweaks. Should not be a big deal.

      Reply
      • GANGESH KUMAR says

        June 29, 2017 at 11:34 am

        i think above solution will works with one symbol one time
        can i import historical data in batch/group.
        lets say we have historical data in desired ninja trader format but in various folder . is it possible to import all data within different folder

        Reply
  2. atin shah says

    September 23, 2017 at 2:53 am

    Respective Sir,

    Mr. Rajandran

    Using AmiBroker Easy Quote Downloader -- 3.12

    but now not updating anything in AmiBroker…………

    Having any server issues or deactivated the Third Party Services…….

    Please Help…….

    Atin Shah

    Reply
    • Rajandran says

      October 1, 2017 at 11:01 am

      Upgrade to the latest version of Amiquote Downloader.

      Reply
  3. Deepak says

    October 28, 2017 at 1:26 pm

    Hi Rajendran,Thanks for the Afl.I see a difference in the candlesticks of imported data in Ninja trader and amibroker charts .Are you getting the same

    Reply
  4. e_djur says

    April 22, 2018 at 7:22 pm

    I have discovered how to toggle between two databases. EOD toggle to intra. In one instance. File/Recent Databases/klick your choice.

    Reply
  5. Indrajit Chakraborty says

    May 16, 2018 at 2:02 pm

    Can you please update it for Ninjatrader 8?

    Reply
  6. Yashodhan says

    September 15, 2018 at 5:55 pm

    Hi Rajandran,

    How can we do it reverse?
    If I have NT8 subscription, I want export data of several symbols and import it in Amibroker for analysis.

    I can see data is written in C:\Users\abc\Documents\NinjaTrader 8\db\minute folder but dnt know how to import it in Amibroker.

    Thanks in advance.

    Regards,
    Yashodhan

    Reply
  7. Bhavesh says

    September 20, 2018 at 10:37 pm

    The above AFL code was very good, i am using it with NT8 ,

    The above code was exporting data of whole database , if once i feel whole database in NT, than i need only fresh days database, which is not exporting like From Date (Time) -- To Date (Time)

    if i want only Last week data than it is not possible , every time it was exporting whole database

    it is humble request to modify this code to export data for particular Date & Time

    Regards,
    Bhavesh

    Reply
  8. ajay says

    July 24, 2019 at 12:41 pm

    hello rajendra , thanks for sharing ur knowledge. i have tried exact way as u told , but i am getting an error “Unable to import file -- Instrument is not supported by repository.”

    can you help regarding this. thanks. waiting for reply.

    Reply
  9. Sagar says

    October 21, 2019 at 10:34 am

    Kindly modify the AFL to export a certain period data instead of whole data of any symbol, I tried changing date periods in analyser but it export entire data. Thanks in advance

    Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Email Newsletter

Sign up to receive email updates on latest trading strategies , analysis & financial market updates

We Respect Your Privacy

Premium Access

Username:
Password:
Remember Me
Lost your password?

Tools For Traders

  • Marketcalls Android App
  • MCX Signals
  • Intraday Signals
  • International Commodities
  • OI Tracker
  • Participation OI
  • Your Broker
  • Market Sentiment Analysis

Amibroker Updates

Code Snippet: ATM Call and ATM Put calculation from Spot Prices: Amibroker AFL

December 10, 2019 By Rajandran Leave a Comment

Volatile Phases – Colorful ADX Amibroker AFL Code

November 16, 2019 By Rajandran 4 Comments

Amibroker Technical Analysis Workshop – Bangalore

November 1, 2019 By Rajandran 2 Comments

How to Send Alerts from Amibroker to Telegram Channel using Telgram API

June 12, 2019 By Rajandran 15 Comments

How to Estimate the VWAP based settlement Close like a Pro using Amibroker?

June 9, 2019 By Rajandran Leave a Comment

  • Facebook
  • Google+
  • LinkedIn
  • RSS
  • Twitter
  • YouTube

Metatrader Updates

MetaTrader 5 Demo Servers Now Available for BSE Currency Markets

March 20, 2018 By Rajandran 8 Comments

ChartIQ – WebTrader for MT4

December 4, 2017 By Rajandran 5 Comments

Metatrader 4 – Web Platform Overview

October 29, 2015 By Rajandran 9 Comments

William VIX FIX Indicator for Metatrader 4

May 16, 2015 By Rajandran 9 Comments

How to Install Custom MQL4 indicators in Metatrader

November 14, 2014 By Rajandran 7 Comments


About | Contact Us | Terms and Conditions | Privacy Policy | Support Policy | Privacy Policy | Refund Policy | Disclaimer


© Copyright 2018 Marketcalls Financial Services Pvt Ltd · All Rights Reserved · And Our Sitemap · All Logos & Trademark Belongs To Their Respective Owners·

Data and information is provided for informational purposes only, and is not intended for trading purposes. Neither marketcalls.in website nor any of its promoters shall be liable for any errors or delays in the content, or for any actions taken in reliance thereon.