• 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

perfroming Calcluations on columns

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

    perfroming Calcluations on columns

    I'm trying to convert some excel spreadsheets into the Market Analyzer which will streamline my pre-trade morning preparations for the day. The Excel spreadsheet updates the closing price on 60 instruments and then performs some statistical analysis on the columns that then go into conditional formatting to highlight my targets for the day.

    Market Analyzer is running fine and matching the columns data closely (not an exact match to excel) and now I want to find both the Average and StdDev.of one of the columns and dynamically set the conditional value in Market Analyzer based on these values.

    Is there a way to do this?

    #2
    It would be possible, but it would take custom programming.

    There are many NinjaScript methods for calculating an average of a data series. There is also a StdDev method which should help you perform this.

    However in order to plot the calculation in a Market Analyzer column, you must calculate it as a plot, or expose these values another way. Please see our Reference Sample on Exposing indicator values that are not plots - http://www.ninjatrader.com/support/f...ead.php?t=4991
    MatthewNinjaTrader Product Management

    Comment


      #3
      Originally posted by BBenski View Post
      I'm trying to convert some excel spreadsheets into the Market Analyzer which will streamline my pre-trade morning preparations for the day. The Excel spreadsheet updates the closing price on 60 instruments and then performs some statistical analysis on the columns that then go into conditional formatting to highlight my targets for the day.

      Market Analyzer is running fine and matching the columns data closely (not an exact match to excel) and now I want to find both the Average and StdDev.of one of the columns and dynamically set the conditional value in Market Analyzer based on these values.

      Is there a way to do this?
      Are the instruments columns or rows?

      Comment

      Latest Posts

      Collapse

      Topics Statistics Last Post
      Started by ct, Today, 05:31 AM
      1 response
      2 views
      0 likes
      Last Post NinjaTrader_PatrickG  
      Started by pstrusi, Today, 02:21 AM
      0 responses
      6 views
      0 likes
      Last Post pstrusi
      by pstrusi
       
      Started by indy73, Yesterday, 10:52 PM
      1 response
      9 views
      0 likes
      Last Post NinjaTrader_EricB  
      Started by priceisking, 05-13-2019, 08:30 AM
      6 responses
      40 views
      0 likes
      Last Post Harry
      by Harry
       
      Started by pjsmith, Today, 12:43 AM
      1 response
      6 views
      0 likes
      Last Post NinjaTrader_ChrisSch  
      Working...
      X