Connecting to SQL or other database

[bluelou]

I'm looking to have an NT7 strategy read parameter values from either a MySQL or PostgresSQL database. Also, I may want to write values from NT7 to a database at some point.

Questions:
Is there anything in NT7 that will prevent or cause problems with a strategy reading/writing to a database?

Are there any known instances of NT users deploying databases to read/write values?

[NinjaTrader_Lance]

Hello,

I have seen some developers do this with their own strategies or indicators. Unfortunately it's not something we provide support for or that I have any available documentation on.

You might consider asking your question here as well: http://ninjatrader.com/support/forum...ad.php?t=22435

Additionally you could contact one of our consultants to see if they can provide you with additional help on creating a script like this: http://www.ninjatrader.com/partners....pt-Consultants

Let me know if I can be of further assistance.

[bluelou]

Lance,
If you could clarify a bit further...Is there any part of NT that would prohibit a strategy from reading parameter values from an external database such as MySQL or should I expect behavior like I would see with native C# code?

Hello,

I have seen some developers do this with their own strategies or indicators. Unfortunately it's not something we provide support for or that I have any available documentation on.

You might consider asking your question here as well: http://ninjatrader.com/support/forum...ad.php?t=22435

Additionally you could contact one of our consultants to see if they can provide you with additional help on creating a script like this: http://www.ninjatrader.com/partners....pt-Consultants

Let me know if I can be of further assistance.

[NinjaTrader_Lance]

The one problem I would see you running into is the fact that Initialize() can be called multiple times which could lead to your DB file having multiple access calls. Beyond that, the behavior should be the same as C#, however this is unsupported so I cannot say for sure one way or the other.

[bluelou]

Okay, thx for the warning abt Initialize() calls.

[NinjaTrader_Lance]

Happy to provide you with what I can. If you want to further test the Initialize() calls you can add some Print() statements to it and then open indicator/strategy windows to test for different times it may be called. (refreshing NinjaScript on charts, enabling strategies, opening indicator window, etc)

(output window found by going to tools -> output window)