Announcement

Collapse
No announcement yet.

Partner 728x90

Collapse

excel spread sheet

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

    excel spread sheet

    hello all.

    can i import data from excel to ninja trader i'm using the free ver?
    if yes please direct me where i can read about it and learned how to do so.

    thanks.

    avi.

    #2
    Hello Avi,

    Unfortunately this is not supported. You can manually import historical data as per the instructions at the link below.
    http://www.ninjatrader.com/support/h.../importing.htm
    JasonNinjaTrader Customer Service

    Comment


      #3
      thanks , i read it all and try to import tick data but i got this eror "there is been error on importing historical data, please check the log."

      where can i find the log?

      the name of the fileis : $EURUSD.LAST

      the file look like this:
      20140501 000047;1.386930;0
      20140501 000049;1.386920;0
      20140501 000050;1.386930;0
      20140501 000107;1.386920;0
      20140501 000234;1.386910;0
      20140501 000339;1.386920;0
      20140501 000352;1.386900;0
      20140501 000353;1.386890;0
      20140501 000439;1.386870;0
      20140501 000440;1.386860;0
      20140501 000454;1.386870;0

      Comment


        #4
        Originally posted by 400396 View Post
        thanks , i read it all and try to import tick data but i got this eror "there is been error on importing historical data, please check the log."

        where can i find the log?

        the name of the fileis : $EURUSD.LAST

        the file look like this:
        20140501 000047;1.386930;0
        20140501 000049;1.386920;0
        20140501 000050;1.386930;0
        20140501 000107;1.386920;0
        20140501 000234;1.386910;0
        20140501 000339;1.386920;0
        20140501 000352;1.386900;0
        20140501 000353;1.386890;0
        20140501 000439;1.386870;0
        20140501 000440;1.386860;0
        20140501 000454;1.386870;0
        The log tab can be found in the ninja trader control center, it is the right most tab.

        Comment


          #5
          thanks i find the log and it said:
          "Unable to import file 'C:\Users\owner\Desktop\$EURUSD.LAST.txt'. Instrument is not supported by repository."

          i follow the instruction and i don't understand why i get this erorr, the file namr should be ok , and file should be ok too please see the example i send ,can some one can help me with this? what i'm doing wrong?

          thansk.

          avi.

          Comment


            #6
            Originally posted by 400396 View Post
            thanks i find the log and it said:
            "Unable to import file 'C:\Users\owner\Desktop\$EURUSD.LAST.txt'. Instrument is not supported by repository."

            i follow the instruction and i don't understand why i get this erorr, the file namr should be ok , and file should be ok too please see the example i send ,can some one can help me with this? what i'm doing wrong?

            thansk.

            avi.

            Importing Tips
            Please review the following before importing:

            • If you are importing historical data for a futures or forex instrument, the instrument MUST exist in the Instrument Manager. If it does not, you must add it first
            • Any data imported where the instrument does not exist in the Instrument Manager will automatically be imported as a "Stock" instrument type
            • Data points will be rounded to the instruments tick size as it is imported if the price is not evenly divisible by the instrument's tick size
            • Imported data, regardless of time zone, will be converted to the local time zone.

            Did you already have $EURUSD in your instrument manager list?

            Comment


              #7
              yes i have this symbol , i try to download to other symbol too with out any luck.
              Attached Files

              Comment


                #8
                Originally posted by 400396 View Post
                yes i have this symbol , i try to download to other symbol too with out any luck.
                While it shows up as an available instrument in the master list, I think you need to add it to the list column on the left. Below the instrument are two arrow icons, one pointing to the list column and the other pointing away, you need to click the one that points to the left and that will add EURUSD to your list. Once that is done, close the instrument manager and try the import again.

                Comment


                  #9
                  Hello 400396,

                  You will need to rename the text file to just EURUSD to import it into NinjaTrader. You would not need the $ symbol in front of it.
                  Cal H.NinjaTrader Customer Service

                  Comment


                    #10
                    i try that still not working

                    Comment


                      #11
                      i just used EURUSD in the file name and it work perfectly , thanks guys.

                      Comment

                      Latest Posts

                      Collapse

                      Topics Statistics Last Post
                      Started by TraderElegante, Today, 12:25 PM
                      2 responses
                      5 views
                      0 likes
                      Last Post TraderElegante  
                      Started by cliffhu, Today, 12:19 PM
                      1 response
                      8 views
                      0 likes
                      Last Post NinjaTrader_Jim  
                      Started by mattdowns1234, Today, 11:50 AM
                      1 response
                      12 views
                      0 likes
                      Last Post NinjaTrader_Kate  
                      Started by Impeesa, Today, 11:57 AM
                      1 response
                      1 view
                      0 likes
                      Last Post NinjaTrader_ChrisL  
                      Started by EquityTrader, Today, 09:59 AM
                      1 response
                      8 views
                      0 likes
                      Last Post NinjaTrader_Kate  
                      Working...
                      X