Hallo everybody,

can somebody point me in the right direction.
Thank you in advance

Best regards
Benjamin

bascher 

Hallo everybody, can somebody point me in the right direction. Thank you in advance Best regards Benjamin

GomRecorder with MySQL backend Just throwing this out there.... It seems like Gomi has given us the tools needed to create a tick storage database, and I am happy to create a public MySQL db that can be shared with all Elite Members... Just a thought, to combine GomRecorder + a MySQL …

How to connect NinjaTrader7 --> MySQL --> R(2.12) Hi, Just wanted to share a short example demonstrating how to connect NinjaTrader7 --> MySQL --> R(2.12). The example is just trivial, pulling a vector of closing values from NT7 into R, but it demonstrates the power. Assumes NT7, MySQL, MySQL Connector/Net, …

mysql db writer Mike, stumbled upon you post and code on the NT forum NinjaTrader Support Forum - View Single Post - mysql database code sample ( how can i debug it? apparently it's not trying to or failing to connect to the mysql db on the lan and subsequently …

Tick Database Storage Have any of you gone through the process of building a tick database? The deeper I look into it the harder it seems to implement as a one-man show. I basically need the database to update from Ninja, IQFeed, or csv files, and then have that data available …

Tick Data Storage This is for Futures data. Anyone who post please post the timezone, and the dates the data is good for. I have found the continuous contract in IQfeed mirrors the monthly contract for now i am collecting monthly also on all contracts. but may just collect …

Mike

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

bascher 

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

Your price has a comma in it. Change to decimal.

Mike

Hallo Mike,

I tried it all day but I dontīt know how to solve it. Please help me to fix it.

Benjamin

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

Try this:
Insert Into data1 (date, time, lastprice, volume) Values ('20111018', '1509312430', '1.3724', '4646000')

I patched it with:

string ePrice;
ePrice = e.Price.ToString();
ePrice = ePrice.Replace(",", ".");

Benjamin

Can it be possible that there is a restriction in storing data from NT in MySql?
I get the data from IB in NT and want to save them in Mysql but this works only for 3 instruments.
What can I do?

bascher 

but this works only for 3 instruments.

What do you mean?

Mike

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.