Dark Theme
Light Theme
Trading Articles
Article Categories
Article Tools
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)
Updated November 4, 2011
Top Posters
looks_one
bascher
with 10 posts (0 thanks)
looks_two
Big Mike
with 7 posts (3 thanks)
looks_3
Lornz
with 2 posts (1 thanks)
looks_4
shodson
with 1 posts (2 thanks)
Best Posters
looks_one
ktrader
with 2 thanks per post
looks_two
shodson
with 2 thanks per post
looks_3
Lornz
with 0.5 thanks per post
looks_4
Big Mike
with 0.4 thanks per post
trending_up
10,893 views
thumb_up
8 thanks given
group
5 followers
forum
23 posts
attach_file
1 attachments
October 25th, 2011, 06:23 PM
Manta, Ecuador
Site Administrator Developer Swing Trader
Experience: Advanced
Platform: Custom solution
Broker: IBKR
Trading: Stocks & Futures
Frequency: Every few days
Duration: Weeks
Posts: 50,607 since Jun 2009
Thanks Given: 33,345
Thanks Received: 101,971
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
Can you help answer these questions from other members on NexusFi?
Best Threads (Most Thanked) in the last 7 days on NexusFi
October 26th, 2011, 06:51 AM
Germany
Experience: Beginner
Platform: NinjaTrader
Trading: DAX, EUR/USD
Posts: 18 since Aug 2010
Thanks Given: 16
Thanks Received: 2
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
Attached Files
Elite Membership required to download: NinjaTraderMySql.txt
October 26th, 2011, 11:30 AM
Manta, Ecuador
Site Administrator Developer Swing Trader
Experience: Advanced
Platform: Custom solution
Broker: IBKR
Trading: Stocks & Futures
Frequency: Every few days
Duration: Weeks
Posts: 50,607 since Jun 2009
Thanks Given: 33,345
Thanks Received: 101,971
Check your concurrent connection limit in mysql.
Mike
October 28th, 2011, 08:39 AM
LONG BEACH CA/US
Posts: 1 since Oct 2011
Thanks Given: 1
Thanks Received: 0
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
OC, California, USA
Quantoholic
Experience: Advanced
Platform: IB/TWS, NinjaTrader, ToS
Broker: IB, ToS, Kinetick
Trading: stocks, options, futures, VIX
Posts: 1,976 since Jun 2009
Thanks Given: 533
Thanks Received: 3,710
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
Germany
Experience: Beginner
Platform: NinjaTrader
Trading: DAX, EUR/USD
Posts: 18 since Aug 2010
Thanks Given: 16
Thanks Received: 2
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
Manta, Ecuador
Site Administrator Developer Swing Trader
Experience: Advanced
Platform: Custom solution
Broker: IBKR
Trading: Stocks & Futures
Frequency: Every few days
Duration: Weeks
Posts: 50,607 since Jun 2009
Thanks Given: 33,345
Thanks Received: 101,971
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
Germany
Experience: Beginner
Platform: NinjaTrader
Trading: DAX, EUR/USD
Posts: 18 since Aug 2010
Thanks Given: 16
Thanks Received: 2
Max number (3) of market depht requests has been reached 309:
November 2nd, 2011, 05:17 PM
Szczecin
Experience: Intermediate
Platform: Ninja, writing own now
Posts: 211 since Mar 2010
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
glostrup, denmark
Experience: Advanced
Platform: Custom platform
Broker: CQG
Trading: Futures, Options, Stocks
Posts: 249 since Aug 2011
Thanks Given: 152
Thanks Received: 275
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.
Last Updated on November 4, 2011