Announcement

Collapse
No announcement yet.

Partner 728x90

Collapse

Link To Excel

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

    Link To Excel

    There have been many previous posts regarding getting historical and real time quote data into excel - like a DDE. However, Ninja does not suppprt this.

    Does anyone know of a standardized off-the-shelf excel spreadsheet package with the necessary codes already in place to enable this and live trading to occur?

    Many of us mortals are fairly proficiient at Excel but not the programming bits. I am sure this must have been "developed" before.

    Thanks Richard

    #2
    Hello,

    Well, you CAN read excel via the stream-reader:
    http://www.ninjatrader-support2.com/...ead.php?t=3476

    But I'm not sure that is what you want.

    Last edited by mountainclimber; 05-07-2010, 10:35 AM.

    Comment


      #3
      Thanks

      Well I am looking to be in excel to "drag" specific historical data out of Ninja. For example I may want to pull historical 15 min data for a week for a group of say 20 stocks. Another example is I may want to pull a live snapshot of of prices every 15 mins into excel .

      The dates / times and symbol list would be set in cells in excel .

      I am not sure if stram-reader can do this or how it integrates into excel and can be driven b

      Comment


        #4
        Hello,

        You can do this with a system based off of StreamWriter and some VBA code, both of which I have worked with extensively.

        Comment


          #5
          for dde you can try this http://ndde.codeplex.com/

          a dde connection between NT (it being the server) and excel can be made.

          Comment


            #6
            do you have any sample code which can plot data from excel in real time.
            i am searching solution desperately from long time.
            you seems to be my hope.

            Comment


              #7
              Originally posted by bukkan View Post
              for dde you can try this http://ndde.codeplex.com/

              a dde connection between NT (it being the server) and excel can be made.
              Has anyone tried DDE between NT and Spreadsheet lately?

              Comment

              Latest Posts

              Collapse

              Topics Statistics Last Post
              Started by t.kelly4149, Today, 05:36 PM
              1 response
              5 views
              0 likes
              Last Post bltdavid  
              Started by SilverSurfer1, Today, 06:29 PM
              0 responses
              13 views
              0 likes
              Last Post SilverSurfer1  
              Started by trader3000a, Today, 01:06 PM
              1 response
              9 views
              0 likes
              Last Post NinjaTrader_ShawnB  
              Started by marcus2300, Today, 11:45 AM
              3 responses
              30 views
              0 likes
              Last Post marcus2300  
              Started by pel11, Today, 11:06 AM
              0 responses
              12 views
              0 likes
              Last Post pel11
              by pel11
               
              Working...
              X