Store real time data from NT in mysql

October 25th, 2011, 06:23 PM

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

October 26th, 2011, 06:51 AM

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

October 26th, 2011, 11:30 AM

Check your concurrent connection limit in mysql.

Mike

October 28th, 2011, 08:39 AM

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.

October 28th, 2011, 11:05 PM

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.

October 31st, 2011, 05:31 AM

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.

October 31st, 2011, 04:13 PM

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

November 2nd, 2011, 03:59 PM

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

November 2nd, 2011, 05:17 PM

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.

November 2nd, 2011, 05:34 PM

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.

Store real time data from NT in mysql

Discussion in NinjaTrader

Store real time data from NT in mysql