bascher 

If I attach the indicator at 3 currencies it works fine and I can store all data but if I attach the indicator at another currency there happens nothing more than before.

Catch the SQL errors, maybe a connection limit.

Mike

That is the problem there occurs no error message. In the output window in NT the insert query for only three securities occurs. If I attach the indicator at another there happens nothing more everything is like before and the data can´t be stored in Mysql. I hope someone can help me.
Thank you in advance

Check your concurrent connection limit in mysql.

Mike

bascher 

Hallo, I have some problems to store the data in Mysql: MyInsertQuery: string myInsertQuery = String.Format("Insert INTO data1 (date, time, lastprice, volume) Values({0}, {1}, {2}, {3})", now_date_marketlast, now_time_marketlast, e.Price, e.Volume); My table in Mysql: CREATE TABLE `data1` ( `id_tick` int(16) NOT NULL auto_increment, `date` varchar(8) NOT NULL, `time` varchar(17) NOT NULL, `lastprice` float NOT NULL, `volume` int(8) NOT NULL, PRIMARY KEY (`id_tick`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=0 ; Output in Ninjatrader: Insert Into data1 (date, time, lastprice, volume) Values(20111018, 1509312430, 1,3724, 4646000) Error on calling 'OnMarketData' method for indicator 'NinjatraderMysql': Column count doesn´t match value count at row 1 Best regards Benjamin

I always put single quotes ' around my data fields in mysql even if it's a number. It works great.

bascher 

That is the problem there occurs no error message. In the output window in NT the insert query for only three securities occurs. If I attach the indicator at another there happens nothing more everything is like before and the data can´t be stored in Mysql. I hope someone can help me. Thank you in advance

Check the "Log" tab in the Control Center. if you have unhandled exceptions they will not show up in the Output window, rather, they will show up in the Log tab with yellow background color.

Thank you shodson. The Log tab told me tha the max number (3) of market depht requests has been reached 309:
Is there a way to evade that for instance to write the code in another way.

bascher 

Thank you shodson. The Log tab told me tha the max number (3) of market depht requests has been reached 309: Is there a way to evade that for instance to write the code in another way.

Would you post the exact error message please?

Mike

Max number (3) of market depht requests has been reached 309:

Maybe your IO subsystem gets overloaded and the adapter falls behind, and NinjaTrader tells you the queue is too long? Try faster discs - best a SSD - for the database.

bascher 

Max number (3) of market depht requests has been reached 309:

The error message is identical to an IB-api error message, are you using interactive brokers as datafeed?

If its interactive brokers datafeed, it means you can only receive market depth for 3 distinct symbols at a time.