• 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

Extract to excel

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

    Extract to excel

    Hello,

    i have a question regarding possibility to extract certain info from a Strategy analyzer to excel. I know i can extract an entire grid to excel, but when im testing a big group of stocks like SP500, and i want to see Profit factors for long only or short only entries for each particular stock i cant do this unless i manually extract this data to excel. Do you maybe know an option to extract this data all at once?

    thanks

    #2
    Hi Bagzi,

    Thank you for your post.

    Unfortunately, you can only do this one at a time with the grid to excel for each instrument.

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

    Comment


      #3
      Hi there
      I have googled an excel processing program which supports to extract to excel.And here is the code:
      /// <summary>
      /// Extract a single page and form a new document
      /// </summary>
      /// <param name="filePath"></param>
      /// <param name="indx"></param>
      /// <returns></returns>
      public ExcelDocument GetOnePageDocument(String sourceFilePath, int index, String destnFilePath)
      {
      Excel Document Process.GetOnePageDocument(sourceFilePath, index, destnFilePath);
      }

      Hope to help you.

      Comment


        #4
        Hey Nana111, thanks for posting. I dont know C#, its all a pain in the but when i need to open code and fix it outside the wizard. Could u advise where should i put this code when i open the code viewer? I have Initialize and On bar update section. I would like to get all the trades that show up on the analyzer at once when testing multi instrument, not have to go to export instrument by instrument. Any idea how to achieve that?

        Comment


          #5
          Originally posted by Nana111 View Post
          Hi there
          I have googled an excel processing program which supports to extract to excel.And here is the code:
          /// <summary>
          /// Extract a single page and form a new document
          /// </summary>
          /// <param name="filePath"></param>
          /// <param name="indx"></param>
          /// <returns></returns>
          public ExcelDocument GetOnePageDocument(String sourceFilePath, int index, String destnFilePath)
          {
          Excel Document Process.GetOnePageDocument(sourceFilePath, index, destnFilePath);
          }

          Hope to help you.
          Hi Nana111, I am not familar with C# sharp code, I am a newbie for programming, and recently, I need to finish a small project about excel page exporting for my school work, can you offer me some visual basic codes? Thanks!

          Comment

          Latest Posts

          Collapse

          Topics Statistics Last Post
          Started by vpzdcv, Today, 02:31 AM
          0 responses
          7 views
          0 likes
          Last Post vpzdcv
          by vpzdcv
           
          Started by YevhenShynkarenko, Today, 01:22 AM
          0 responses
          14 views
          0 likes
          Last Post YevhenShynkarenko  
          Started by ttodua, Today, 12:52 AM
          0 responses
          6 views
          0 likes
          Last Post ttodua
          by ttodua
           
          Started by ttodua, Today, 12:50 AM
          0 responses
          5 views
          0 likes
          Last Post ttodua
          by ttodua
           
          Started by mulshah, Yesterday, 11:12 PM
          0 responses
          7 views
          0 likes
          Last Post mulshah
          by mulshah
           
          Working...
          X