• 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 to excel

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

    Exporting to excel

    Hello,

    Is it possible to export the following 7 columns of Real time data into excel for 5 symbols simultaneously. And the version of NT to be used is 6.5 :
    1. Trade time
    2. Last Traded Price
    3. Last Traded volume
    4. Bid size
    5. Bid rate
    6. Ask size
    7. Ask Rate

    Please guide me how to do it.

    #2
    Hi rocky9281,

    Thanks for the post. This project is beyond what we could provide support for, but hopefully this information below could get you started. I would recommend using version 7 for this but you're welcome to try on 6.5.

    Please see community member Dionysus post here for help creating NinjaTrader > Excel DDE link:
    http://www.ninjatrader.com/support/f...407#post212407

    The market analyzer columns are not editable indicators, so you will need some way to work with the script files outside of NinjaTrader, like visual studio or a text editor. You will find these files here:
    Documents\NinjaTrader 7\bin\custom\market analyzer.

    Good luck!
    Ryan M.NinjaTrader Customer Service

    Comment


      #3
      Indicator value export

      Hello. Please help to issue task - export value of indicator for several instruments to Excel. Or if it possible - on one window in NT7.
      Example
      <Instrument> <Indicator> <periods> <value>

      Comment


        #4
        alexstox,

        You can look into this sample here for help using NinjaScript to write to a file.
        http://www.ninjatrader.com/support/f...ead.php?t=3475

        One of our members has also put together this nice guide on integrating NT with Excel:
        http://www.ninjatrader.com/support/f...407#post212407
        Ryan M.NinjaTrader Customer Service

        Comment


          #5
          And any ideas to output those info to NT window? Because it's hard for me to understand fro, that example how to add 5 futures names and indicator values for it.
          <instrument> <open> <indicator value>

          For example, can I add indicator value to MarketAnalyzer window?

          Why MarketAnalyzer window has no data? Even historical with Kinetick EOD?

          Or maybe there are some possibilities to plot in DataBox?
          Last edited by alexstox; 04-25-2012, 11:07 AM.

          Comment


            #6
            Market Analyzer is a real time quote sheet. You can use it to display indicator plots, and all the built in market analyzer columns. It is not designed for historical data.

            You can send information to the output window with Print() commands. More information on this is available here:
            http://www.ninjatrader.com/support/f...ead.php?t=3418
            Ryan M.NinjaTrader Customer Service

            Comment


              #7
              how to import excel rt data of indian market from Nest or odin to nt7 and backfill too...?

              Request guidence from members...

              Comment


                #8
                but the link provided is dead ... for DDE

                Comment


                  #9
                  You refer to the link Ryan shared in post #4? This seems to be working alright for me here.
                  BertrandNinjaTrader Customer Service

                  Comment


                    #10
                    If you use Excel for trading and market data analysis - you might be interested in looking at another Excel tool - IB Excel Trader. It let's you trade directly from Excel, and you can build your own algorithm using formulas and VBA macros

                    http://www.tradinggeeks.net/download...-excel-trader/

                    Comment


                      #11
                      Originally posted by schematics View Post
                      If you use Excel for trading and market data analysis - you might be interested in looking at another Excel tool - IB Excel Trader. It let's you trade directly from Excel, and you can build your own algorithm using formulas and VBA macros

                      http://www.tradinggeeks.net/download...-excel-trader/
                      I downloaded this program last Wednesday. I've been trying to get it to work ever since. I cannot get past the first "Compile error". I'm getting help from Interactive Brokers, ExcelForum, and stackOverflow. I haven't had a reply from TradingGeeks since Friday.

                      Are you actually using this program? If you are, I would be most grateful if you could answer a few questions.

                      Comment

                      Latest Posts

                      Collapse

                      Topics Statistics Last Post
                      Started by lavalampmj, Today, 05:25 PM
                      0 responses
                      3 views
                      0 likes
                      Last Post lavalampmj  
                      Started by Antares66, Today, 05:19 PM
                      0 responses
                      2 views
                      0 likes
                      Last Post Antares66  
                      Started by jmneto, Today, 05:18 PM
                      0 responses
                      4 views
                      0 likes
                      Last Post jmneto
                      by jmneto
                       
                      Started by Bobbyj78, Today, 02:21 PM
                      2 responses
                      14 views
                      0 likes
                      Last Post bltdavid  
                      Started by EnveousColnago, Today, 02:10 PM
                      1 response
                      8 views
                      0 likes
                      Last Post NinjaTrader_Ariana  
                      Working...
                      X