• 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 Tinacaro, Yesterday, 11:52 PM
            0 responses
            1 view
            0 likes
            Last Post Tinacaro  
            Started by dierezer, Yesterday, 11:38 PM
            0 responses
            2 views
            0 likes
            Last Post dierezer  
            Started by hbustami, Yesterday, 11:35 PM
            1 response
            11 views
            0 likes
            Last Post hbustami  
            Started by bmccoard, Yesterday, 06:48 PM
            1 response
            15 views
            0 likes
            Last Post NinjaTrader_ChrisSch  
            Started by Sorcerysoft, Yesterday, 10:32 PM
            0 responses
            5 views
            0 likes
            Last Post Sorcerysoft  
            Working...
            X