• 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

Stream Data to Excel or LibreOffice

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

    Stream Data to Excel or LibreOffice

    Hi,

    What are my best options to stream instrument live data to Excel or LibreOffice? At this stage, a stream with instrument data (OHLC + Volume) is enough but I would also like to get open/pending positions into Excel / LibreOffice, if possible.

    br,
    Chris

    #2
    Hello suroot,

    Thank you for your post.

    You could use StreamWriter to write to an external file. We have an example at the following link: http://ninjatrader.com/support/forum...ead.php?t=3475

    However, we do not have a direct interface to an external application such as Excel.

    Please let me know if you have any questions.
    Patrick H.NinjaTrader Customer Service

    Comment


      #3
      Hi,

      Thanks for your reply! This should work just fine!

      br,
      Chris

      Comment


        #4
        Hi again,

        With what tools and how are you guys reading the output in real time? I've tried to open the .txt file in LibreOffice and Excel and able to get the outputted data correctly. I however would like to have the stream in real time in Calc/Excel, so that I can do probability calculations etc.

        How have you accomplished this?

        br,
        Chris

        Comment


          #5
          Hello suroot,

          Thank you for your response.

          We would not have a direct interface to Excel or LibreOffice.

          Please let me know if you have any questions.
          Patrick H.NinjaTrader Customer Service

          Comment


            #6
            Originally posted by suroot View Post
            Hi again,

            With what tools and how are you guys reading the output in real time? I've tried to open the .txt file in LibreOffice and Excel and able to get the outputted data correctly. I however would like to have the stream in real time in Calc/Excel, so that I can do probability calculations etc.

            How have you accomplished this?

            br,
            Chris
            Create an external data connection in Excel to the text file you output from NT.

            Comment

            Latest Posts

            Collapse

            Topics Statistics Last Post
            Started by ballboy11, Today, 05:22 PM
            0 responses
            3 views
            0 likes
            Last Post ballboy11  
            Started by ballboy11, Today, 04:33 PM
            2 responses
            4 views
            0 likes
            Last Post ballboy11  
            Started by dedouglas, Today, 03:16 PM
            1 response
            7 views
            0 likes
            Last Post NinjaTrader_ChelseaB  
            Started by TradeMyth, Today, 02:45 PM
            3 responses
            26 views
            0 likes
            Last Post NinjaTrader_ChelseaB  
            Started by Ticnician, Today, 01:46 PM
            1 response
            9 views
            0 likes
            Last Post NinjaTrader_Jim  
            Working...
            X