• If this is your first visit, you will have to register before you can post. To view messages, please scroll below and select the forum that you would like to visits. Questions? Be sure to check out the Forum FAQ.

Announcement

Collapse
No announcement yet.

Partner 728x90

Collapse

Export trades

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

    Export trades

    Hello, how can I export my trades from Ninja for each trade, I need data in format: date/time, quantity, profit loss, trade ID

    Thanks

    #2
    Hello U0000999,

    Thank you for your post.

    Glad to assist. Any of the Control Center tabs or Trade Performance grids may be exported to Excel. This is done via right click > Export...

    This Trade Performance Display > Trades shows these items. You may right click > Select Properties to remove any unneeded columns.

    Let us know if we may assist further.
    Eric B.NinjaTrader Customer Service

    Comment


      #3
      Is it possible to generate reports automatically and save to Excel file at a specific time?

      Comment


        #4
        In general, this would be possible via custom NinjaScript. Here is the relevant help guide section:

        https://ninjatrader.com/support/help...o_write_to.htm

        Can you elaborate on exactly what you're wanting to accomplish automatically?
        Patrick G.NinjaTrader Customer Service

        Comment


          #5
          Every hour I need to export previous trades: date/time, Number of trade, contract, profit loss, quantity of contracts

          Comment


            #6
            May be there is some solution, which is already made. That's much better

            Comment


              #7
              Hello U0000999,

              Thanks for your reply.

              As NinjaTrader_EricB advised, this information is directly available in the New>Trade Performance which can be easily exported to excel. If you are not familiar with the Trade Performance report I would encourage you to take a look at it, especially the "Trades" display. Here is a link to the help guide on Trade Performance: https://ninjatrader.com/support/helpGuides/nt8/en-us/?trade_performance.htm You could manually run the report hourly if you wish or need to. It may also be possible to use an external program, such as Autoit, to run this for you automatically (I am unsure but is an option you can investigate, AutoIt and programs like it will run a sequence of repetitive key strokes).

              As NinjaTrader_PatrickG advised you can use the streamwriter function to output the data of interest to a text file that can then be imported into excel as you wish. Here are links to the methods and properties to obtain the information of interest:
              https://ninjatrader.com/support/help...-us/?trade.htm
              https://ninjatrader.com/support/help...erformance.htm
              https://ninjatrader.com/support/help...ancevalues.htm

              If you would like this created for you, we can provide references to 3rd party programmers who can meet your needs.
              Paul H.NinjaTrader Customer Service

              Comment

              Latest Posts

              Collapse

              Topics Statistics Last Post
              Started by chrismcdermut, Today, 01:46 PM
              3 responses
              17 views
              0 likes
              Last Post MojoJojo  
              Started by Bricolico, Today, 09:28 PM
              0 responses
              5 views
              0 likes
              Last Post Bricolico  
              Started by Tradwell385, Today, 08:51 PM
              0 responses
              7 views
              0 likes
              Last Post Tradwell385  
              Started by dvcpro4, Today, 07:08 PM
              0 responses
              19 views
              0 likes
              Last Post dvcpro4
              by dvcpro4
               
              Started by pennywise, Today, 06:40 PM
              0 responses
              8 views
              0 likes
              Last Post pennywise  
              Working...
              X