Announcement

Collapse
No announcement yet.

Partner 728x90

Collapse

Exporting data indicator to Excel

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

    Exporting data indicator to Excel

    Hello, first excuse me for my English,
    I would like to export data from the swing Price Action Indicator of NT to Excel:
    in particular, the coordinates of the three points that form the wave ABC for points A, B, C price and corresponding time.
    Then I would have the entry point corresponding to the close of the candle designated by the arrow of the input signal; the price of the VWAP of the SD4, sd3 bottom and up, the ATR 14 and volume.
    I tried by myself I know it's possible to do but it is a little more complex for the coordinates of ABC points.

    thank's.

    #2
    Hello,

    Thank you for your note.

    Exporting to Excel is not supported with NinjaTrader.

    However, you would need to include a reference to the Microsoft.Interop.Excel.Dll in the script.
    This will allow you to open a new workbook or existing one and write data to it.

    Let me know if I can be of further assistance.
    Cal H.NinjaTrader Customer Service

    Comment


      #3
      Originally posted by NinjaTrader_Cal View Post
      Hello,

      Thank you for your note.

      Exporting to Excel is not supported with NinjaTrader.

      However, you would need to include a reference to the Microsoft.Interop.Excel.Dll in the script.
      This will allow you to open a new workbook or existing one and write data to it.

      Let me know if I can be of further assistance.
      yes I did it, but then I do not know how to process to write the data that i want to export in excel.
      Is there a video training to do that or something else?

      Comment


        #4
        Hello,

        You can view the link below on how to use this with in C# programming -
        http://msdn.microsoft.com/en-us/libr...(v=vs.80).aspx
        Cal H.NinjaTrader Customer Service

        Comment


          #5
          Hello, first excuse me for my English,
          I would like to export data from the swing Price Action Indicator of NT to Excel:
          in particular, the coordinates of the three points that form the wave ABC for points A, B, C price and corresponding time.
          Then I would have the entry point corresponding to the close of the candle designated by the arrow of the input signal; the price of the VWAP of the SD4, sd3 bottom and up, the ATR 14 and volume.
          I tried by myself I know it's possible to do but it is a little more complex for the coordinates of ABC points.

          thank's.
          Hi gravdigaz6

          I've often taken data over from Ninja into Excel without doing any formal 'exporting' as such.

          What I do is 'print' the data I need into the Output Window and then copy it over into an Excel worksheet.

          What you'll have is just one column, which may be a mixture of three different columns of data. (For example, you may have: Open[0], Close[0], and EMA (20)[0].)

          You 'extract' the different lines of data by using an Excel function such as LOOKUP function. More precisely:

          in col A, put the whole numbers: 1,2,3...

          in col B, paste the data

          in col C, a function like: =LOOKUP(3*$A2-2,$A:$A,$B:$B)

          in col D, a function like: =LOOKUP(3*$A2-1,$A:$A,$B:$B)

          in col E, a function like: =LOOKUP(3*$A2,$A:$A,$B:$B)

          This will split the data into the number of columns you require.

          You may be a world-class Excel expert, but if you need any further help, please let me know!

          Hope it all works out.

          Comment


            #6
            or you can use my strategy:
            https://www.bigmiketrading.com/downl...load.html?view

            Comment


              #7
              Is this the same code that dinoysus has been distributing? I have had trouble getting that to work....

              Comment

              Latest Posts

              Collapse

              Topics Statistics Last Post
              Started by asmmbillah, Today, 08:13 AM
              0 responses
              1 view
              0 likes
              Last Post asmmbillah  
              Started by Bionian, Today, 07:07 AM
              1 response
              4 views
              0 likes
              Last Post NinjaTrader_Jason  
              Started by averoos, Today, 05:33 AM
              0 responses
              5 views
              0 likes
              Last Post averoos
              by averoos
               
              Started by RobotSyndicate, Today, 04:27 AM
              0 responses
              4 views
              0 likes
              Last Post RobotSyndicate  
              Started by Ray12345, Today, 04:10 AM
              0 responses
              5 views
              0 likes
              Last Post Ray12345  
              Working...
              X