Simple Indicator Not Working

[tradinginzen]

I'm trying to put in a new simple indicator, but I can't seem to get it to fire.

My initialize function is as follows:

        protected override void Initialize()
        {
            Overlay                = true;
            this.DrawOnPricePanel = true;
            
            this.GetData();
        }

the "GetData" function simply looks up prices from a local database on my laptop and draws horizontal lines from it, like this:

//yearly pivot
DrawHorizontalLine(pivotLevel, false, pivotPrice, Color.Black, DashStyle.Solid, 2);

However, nothing happens at all. I put a System.Windows.Forms.MessageBox("Test"); call in my Initialize function, and no message box. Am I missing something simple?

[tradinginzen]

One note... I did add a reference to System.Data at

C:\Windows\Microsoft.NET\assembly\GAC_32\System.Da ta\v4.0_4.0.0.0__b77a5c561934e089\System.Data.dll

Maybe this is causing issues?

[tradinginzen]

that appears to be the issue.

I used

C:\Windows\Microsoft.NET\Framework\v2.0.50727\Syst em.Data.dll

instead and it works

[NinjaTrader_RyanM1]

Hello TradingZen,

This is more C# related so unfortunately we are unable to support your database access. We support documented NinjaScript in the help guide and the reference samples on these forums.

One of our members shared a code snippet for accessing a mysql database and this might be a good place to start.

http://www.ninjatrader.com/support/forum/showthread.php?t=10296

For a message box, you need the appropriate Using statement added to the indicators that use it. This is also outside our scope of support, but you should be able to use message boxes by first adding.

using System.Windows.Forms;

It's not advisable to call a message box from the indicators Initialize() method as Initialize is called for all scripts, not just one. If there's anything you want called only once for a particular indicator, you should use OnStartUp() method for this. This method is new for version 7.

[tradinginzen]

thanks - actually the messagebox is there just to test. I'm also noticing that exceptions are suppressed - is there a way to see the exceptions generated?

[tradinginzen]

...my reasoning is that I don't see any errors, it just stops running.

for example:

for(int i = 0; i < this.m_dtPivotPrices.Rows.Count; i++)
{
     DataRow row = this.m_dtPivotPrices.Rows[i];
                    
     string pivotLevel = row["PivotLevel"].ToString();
     int pivotWeight = (int)row["PivotWeight"];
     double pivotPrice = (double)(decimal)row["PivotPrice"];
                    
     switch(pivotWeight)
     {
          case 1: //daily
          {
               Color colorToUse = Color.Black;
               DashStyle dashStyleToUse = DashStyle.DashDot;

               //..
               DrawHorizontalLine(pivotLevel, false, pivotPrice, colorToUse, dashStyleToUse, 1);
               System.Windows.Forms.MessageBox.Show("draw daily");

I never get to the "draw daily" message, it fails on the DrawHorizontalLine call but I have no message as to why.

[NinjaTrader_RyanM1]

You should see exceptions noted on the log tab of the control center.

You can work from this reference sample for help trying and catching exceptions.
Using Try-Catch Blocks

[tradinginzen]

perfect, thanks!!