• 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

Exporting Price and Indicator Data from chart

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

    Exporting Price and Indicator Data from chart

    Does anybody know how I can export both the price data and what every indicators I have on my chart to a text file so I can then import it into Excel.

    Thanks, Steven

    #2
    We have an "export mode" for our databox add-on that does this. Currently it's bar by bar based on a mouse click, but an upcoming version will have more flexibility. http://integratedtradingtech.com/

    VT
    Last edited by VTtrader; 01-01-2012, 12:30 AM.

    Comment


      #3
      Thanks for the reply VTtrader...but I need to be able to export all of the data loaded on the chart at once.

      Does anyone else know how I can do this...

      Thanks

      Comment


        #4
        StevenV,

        You would need to do this yourself using custom indicators/ etc.

        Here are some reference samples :

        http://www.ninjatrader.com/support/f...ead.php?t=3475

        http://www.ninjatrader.com/support/f...ead.php?t=3477

        Please let me know if I may assist further.
        Adam P.NinjaTrader Customer Service

        Comment


          #5
          Originally posted by StevenV View Post
          Thanks for the reply VTtrader...but I need to be able to export all of the data loaded on the chart at once.

          Does anyone else know how I can do this...

          Thanks
          You will need to use a StreamWriter to write your data to a file.

          OHLC values come from the respective DataSeries. For the indicator values, you will have to iterate through the ChartControl.Indicators[] array, and output their values.

          Comment


            #6
            Hi Koganam,

            I am not a programmer and do not know how to do this. Do you anybody who can do this quickly?

            Thanks, Steven

            Comment


              #7
              Hi,

              I also would be interested in getting an app that could dump all the data (OHLC and custom indicator values) off a chart into a text or csv file.

              Cheers
              Chris

              Comment


                #8
                Hey Koganam,

                By any chance have you expanded this idea to create an export indicator for separate analysis?

                Comment


                  #9
                  Originally posted by stockgoblin View Post
                  Hey Koganam,

                  By any chance have you expanded this idea to create an export indicator for separate analysis?
                  Unfortunately no: all I did was explain the concept of how to go about it.
                  Last edited by koganam; 05-03-2013, 03:35 PM. Reason: Corrected spelling.

                  Comment


                    #10
                    Hey Kog,

                    Ninjatrader_Matthew and I completed one today and now I can export batch instruments in Weekly timeframe through the Market Analyzer. Saves me hours and hours. Kick ass.

                    Thanks anyway!

                    Comment


                      #11
                      Originally posted by stockgoblin View Post
                      Hey Koganam,

                      By any chance have you expanded this idea to create an export indicator for separate analysis?
                      I did it. I put it in BMT strategy download.

                      Baruch

                      Comment


                        #12
                        Originally posted by stockgoblin View Post
                        Hey Kog,

                        Ninjatrader_Matthew and I completed one today and now I can export batch instruments in Weekly timeframe through the Market Analyzer. Saves me hours and hours. Kick ass.

                        Thanks anyway!
                        How did you do that? Thanks.

                        Comment


                          #13
                          Just seen this thread.

                          All I can add is that I've exported a lot of data (price and indicator levels) from NT to Excel through the expedient of printing to the Output Window, via Notepad and Word (to change things like paragraphs (^p in Word 'Replace') into tabs (^t in Word 'Replace'), then into Excel.

                          The analysis Excel can then undertake far exceeds anything NT can do on its own, for someone who knows quite a bit about Excel and is not a Master of NT.
                          Last edited by arbuthnot; 03-11-2015, 06:01 PM.

                          Comment


                            #14
                            Originally posted by arbuthnot View Post
                            Just seen this thread.

                            All I can add is that I've exported a lot of data (price and indicator levels) from NT to Excel through the expedient of printing to the Output Window, via Notepad and Word (to change things like paragraphs (^p in Word 'Replace') into tabs (^t in Word 'Replace'), then into Excel.

                            The analysis Excel can then undertake far exceeds anything NT can do on its own.
                            Thanks for that.How did you get the indicators values to the Output Window?

                            Comment


                              #15
                              Originally posted by Farmer George View Post
                              Thanks for that.How did you get the indicators values to the Output Window?
                              Hi George

                              I've just tested this so I know it works:

                              This is example of a line of code (for either inds or strats) that prints to the output window the EMA at each bar close:

                              Code:
                              Print(EMA(14)[0]);
                              This may output to many decimal places. These can be shortened using the ROUND function in Excel, which can truncate to as many decimal places as you wish.

                              Comment

                              Latest Posts

                              Collapse

                              Topics Statistics Last Post
                              Started by simjs, Yesterday, 08:11 PM
                              0 responses
                              3 views
                              0 likes
                              Last Post simjs
                              by simjs
                               
                              Started by mrlucky1x, Yesterday, 06:01 PM
                              0 responses
                              3 views
                              0 likes
                              Last Post mrlucky1x  
                              Started by dedouglas, Yesterday, 03:17 PM
                              1 response
                              9 views
                              0 likes
                              Last Post NinjaTrader_Jesse  
                              Started by Jugado, Yesterday, 02:22 PM
                              2 responses
                              30 views
                              0 likes
                              Last Post Jugado
                              by Jugado
                               
                              Started by login_dejavu, 04-21-2019, 04:58 AM
                              2 responses
                              24 views
                              0 likes
                              Last Post login_dejavu  
                              Working...
                              X