Welcome to NexusFi: the best trading community on the planet, with over 150,000 members Sign Up Now for Free
Genuine reviews from real traders, not fake reviews from stealth vendors
Quality education from leading professional traders
We are a friendly, helpful, and positive community
We do not tolerate rude behavior, trolling, or vendors advertising in posts
We are here to help, just let us know what you need
You'll need to register in order to view the content of the threads and start contributing to our community. It's free for basic access, or support us by becoming an Elite Member -- see if you qualify for a discount below.
-- Big Mike, Site Administrator
(If you already have an account, login at the top of the page)
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 …
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.
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 …
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
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?
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.
