Announcement

Collapse

Looking for a User App or Add-On built by the NinjaTrader community?

Visit NinjaTrader EcoSystem and our free User App Share!

Have a question for the NinjaScript developer community? Open a new thread in our NinjaScript File Sharing Discussion Forum!
See more
See less

Partner 728x90

Collapse

Dionysus New Year Present – Ninja & Excel

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

    #91
    The following link will demonstrate "How to add a reference"

    MatthewNinjaTrader Product Management

    Comment


      #92
      Bertrand:
      I am almost at the end of the process... but i have "Error on calling 'OnBarUpdate' method for indicator 'BigMikeExcel' on bar 0: Old format or invalid type library. (Exception from HRESULT: 0x80028018 (TYPE_E_INVDATAREAD))"

      Do you have any idea how to solve it??
      Thank you very much!!
      FVJ
      Attached Files

      Comment


        #93
        What exactly are you trying to export?
        I wrote an export strategy (its on BMT), maybe its good enoth for you.

        Comment


          #94
          Thank you let me look for it at BTM...

          Comment


            #95
            Did you find the way to insert rows in the excel sheet? I want also the latest data at the top of the sheet...

            Comment


              #96
              Nest2nt7

              hi

              is there any possibilities form NEST to NT7 using RTD ??

              can any one share the setup procedure ?

              Comment


                #97
                Import data from Excel

                First of all, a big thank you to BigMike, the original poster of the scripts back in 2009 that allows NT to export data to Excel. Once you find the elusive Microsoft.Office.Iteropt.Exel.dll file it all works fine. By the way, probably everybody knows by now, but the easiest way to find this file is to use command line or 'cmd', no hidden files there.

                My question now is how to do the reverse, import similar data from Excel to NT. Has anyone done this before with Excel? I know you can do this with .txt file, but it is an extra step to convert from Excel to .txt and add the semicolon in each field, especially when all I want to import is already in Excel.

                Mmilan

                Comment


                  #98
                  Originally posted by mmilan View Post

                  My question now is how to do the reverse, import similar data from Excel to NT. Has anyone done this before with Excel? I know you can do this with .txt file, but it is an extra step to convert from Excel to .txt and add the semicolon in each field, especially when all I want to import is already in Excel.

                  Mmilan
                  Find the file import specs in the NT help.
                  Move the columns around.
                  I'm not sure which version of Excel you have. . But you can change the delimiter. You'll have to Google that. It's more complicated in the recent versions.

                  You could always convert coma delimited in note pad afterwards.

                  Comment


                    #99
                    Thanks for your response sledge. My Excel version is 2007. Looking at NT help for importing specs I only find how to import historical data from .txt and from TradeStation, nothing related to .xls, that's why I started looking into the BigMike's exporting script to see if I can use Excel workbook to import data into NT.

                    Mmilan

                    Comment


                      Originally posted by mmilan View Post
                      Thanks for your response sledge. My Excel version is 2007. Looking at NT help for importing specs I only find how to import historical data from .txt and from TradeStation, nothing related to .xls, that's why I started looking into the BigMike's exporting script to see if I can use Excel workbook to import data into NT.

                      Mmilan
                      Export from excel as a .CSV (comma separated file)

                      it'll make everything in a .csv

                      column1,column2,column3
                      column1,column2,column3
                      column1,column2,column3
                      column1,column2,column3

                      just rename it to .txt

                      Comment


                        sledge,
                        That worked. Requires a few extra steps than a load directly from Excel but it works. Thank you for your help.

                        Mmilan.

                        Comment


                          Did you get your answer? I am in the same step...
                          If so... please share...
                          Best regards

                          Comment


                            Indicator not showing in "indicator box" but the script is there...

                            The script is in the custom indicators folder and the file was copied and pasted in .cs format (BigMike.cs) - However, the custom indicator does not load as an option in the selection box (all the preloaded indicators are there) . Any help would be greatly appreciated, (cheers to an easy fix). Thanks in advance...
                            Last edited by thomaskrawczyk; 07-20-2014, 02:40 AM. Reason: Clarify

                            Comment


                              I will reply to my own post, as I have figured out the problem.. Turns out if any indicators in the custom folder have complile errors none of the indicators will be able to open. I deleted the files that contained the errors. The file BigMike.cs was then in the indicator box AND worked perfectly as it updated Excel with live quotes. Over and out...

                              Comment


                                Read from Excel

                                I have the data streaming to excel via "BigMikeExcel" indicator posted in this thread but I can't figure out how to simply read a cell from excel into a strategy. I couldn't find an example anywhere so please let me know if anyone has changed the code from writing to reading.

                                Comment

                                Latest Posts

                                Collapse

                                Topics Statistics Last Post
                                Started by NinjaCustomer, 03-13-2019, 05:40 AM
                                5 responses
                                194 views
                                0 likes
                                Last Post octaviogarcia  
                                Started by Oracletrades, 02-21-2020, 01:37 PM
                                11 responses
                                2,036 views
                                0 likes
                                Last Post Ttrade12  
                                Started by crewtrades, Today, 10:50 AM
                                2 responses
                                9 views
                                0 likes
                                Last Post crewtrades  
                                Started by Ttrade12, Yesterday, 01:06 PM
                                3 responses
                                13 views
                                0 likes
                                Last Post Ttrade12  
                                Started by samish18, Today, 05:11 PM
                                0 responses
                                1 view
                                0 likes
                                Last Post samish18  
                                Working...
                                X