Announcement

Collapse
No announcement yet.

Partner 728x90

Collapse

Ninjascript to SQL file

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

    Ninjascript to SQL file

    My attempt at connecting SQL to NT, its a bit slow on collecting data from SQL and plotting bars.

    Any improvements please post

    Thanks

    Neil
    Attached Files

    #2
    tinkerz, as the author of the "mysql database code sample" script that sends information the other way (from NT to a SQL DB), I would just like to say this is very appreciated and I'm sure some people will find it very useful. Thank you.
    AustinNinjaTrader Customer Service

    Comment


      #3
      What is the difference between (Historical==false) (Historical==true) when executing each bar, the SQL code, which i know you dont support is very fast in real time, but very slow in historical mode.

      I assumed that in historical==true, you call each bar once, but is something else loaded once realtime is enacted, it seems very odd for historical to be so slow, that there must be a different process going on.

      Comment


        #4
        tinkerz,

        I am not sure what you mean exactly. Historical bars are processed once, that is correct. As far as other things for the bar, nothing else happens historically. Real-time depends on your CalculateOnBarClose setting. Remember that in real-time you are just doing one operation at a time as data comes in. In historical you have all the historical bars operations stacked up so it could take some time to go through and finish processing the whole queue.
        Josh P.NinjaTrader Customer Service

        Comment


          #5
          Ok thanks, is there a way then...

          of entering all of the data into a dataseries in historical mode at the point where historical ends, or the bar before and realtime starts, so there is only one calculation before plotting, rather than ever bar importing and calculating

          thanks

          neil

          Comment


            #6
            tinkerz,

            If I understood you correctly, no there is no way you can just tell it to not process bars. If the bars are there it will process it the first time you start up the indicator. What is available is if you don't want any historical calculations to filter it with "if (Historical) return;".
            Josh P.NinjaTrader Customer Service

            Comment

            Latest Posts

            Collapse

            Topics Statistics Last Post
            Started by sinpeople, Today, 04:38 AM
            0 responses
            10 views
            0 likes
            Last Post sinpeople  
            Started by Futurestrader00, Yesterday, 06:14 PM
            1 response
            17 views
            0 likes
            Last Post cincai
            by cincai
             
            Started by ballston, Today, 06:32 AM
            0 responses
            4 views
            0 likes
            Last Post ballston  
            Started by Danila, Today, 04:38 AM
            2 responses
            7 views
            0 likes
            Last Post Danila
            by Danila
             
            Started by kiffgj, Today, 04:23 AM
            0 responses
            8 views
            0 likes
            Last Post kiffgj
            by kiffgj
             
            Working...
            X