mysql database code sample

[auspiv]

Taddypole, you need to re-compile the script in the editor (with the F5 key) and then you should be able to add it to charts.

[Taddypole]

Thank you auspiv,

I've made it to the next step but now I'm getting a Compile error.
I think its looking for System.Data.dll.

I tried putting this dll in the Bin directory under NinjaTrader 7 under the Program directoy but that didn't help.

Where would System.Data.dll go?

Thank you,
taddypole...

[Taddypole]

Never mind.
Found the solution.
While in the editor, just right click on the code and select references.
you can then navigate to the assembly to be referenced.

taddypole...

[javaj]

I just wanted to revive this thread again.

And thanks auspiv & ctrlbrk for putting this together, its working great. I just wanted to let everyone know that I have this working in NT 6.5 and 7. 6.5 compiles just fine, but with NT 7 I needed to change in lines 48 from int to long and line 50 from...

public EurUsdRow(double myPrice, int myVolume, string myMarketMaker)

to

public EurUsdRow(double myPrice, long myVolume, string myMarketMaker)

It looks like 6.5 ignored it and 7 made me change it, so I hope that helps anyone who runs into compile errors...

[danjurgens]

I'm doing DB storage of tick data, not with mysql though. See http://www.bigmiketrading.com/ninjat...b-backend.html

[Justin300]

How to connect NinjaTrader7 --> MySQL --> R(2.12)

Hi,
Posted an example of how to connect NinjaTrader7 --> MySQL --> R(2.12) on Big Mike Trading. http://www.bigmiketrading.com/matlab...html#post91701

Thanks to auspiv, decus, ctrlbrk for pointing me in the right direction.

Good Luck,

Justin300

[cedricf]

Hello there, I would like to add a database to a custom strategy. Can anyone please help me with it? I have been having problems getting it to work because there seems to be a compile error that is hindering me to add mysql.

DO you guys think that mysql is a good option or do you have any ideas you could suggest?

[bascher]

Hallo cedricf and all,
I am new to that intention to store the data in mysql. When I compile the script there occur a compile error and I have problems with the NEW from LadderRow method [rows.Insert(e.Position, new LadderRow(e.Price, e.Volume, e.MarketMaker));] and the e.Volume in line 131 and 146 regarding to convert. Please help me.
Thank you in advance.
Benjamin

[d.allen101]

Is anyone having trouble with .NET 4.0? I can't seem to get NT 7 64-bit to recognize the MySql.Data.dll. I've added it to the NT/bin/Custom directory, referenced it my indicator, added it to my indicator i.e. (using MySql.Data.MySqlClient).

It compiles fine but intellisense is not recognizing it and if I create a MySql connection object or command object and attempt to use it in my indicator my indicator won't run correctly. absolutely nothing happens. It appears to blocking my indicator from doing anything!

Can someone please provide insight/solution on this problem?

Thanks in advance,
-DA

[TraderSU]

Well, pardon me if someone already mentioned it but i had a php-cron job for maintaining historical date in MySQL. I was doing delta refresh every-night and full refresh every saturday.

MySQL supports inserting thousands of rows using single SQL. My full refresh job was extremely efficient because I was inserting 10 years of EoD data in on shot. I started with Oracle DB but finally settled on MySQL only because of this awesome feature.

I assume similar technique can rescue you here. Keep data in memory using some collection object and use INSERT after every 2000 ticks. Consider using some messaging (say ActiveMQ) if you can spare one+ machine for this setup.

INSERT DELAYED has totally different use-case and won't help here.

Great thread ;-)

Cheers,
- Su

[sledge]

Are you claiming Oracle does not? What version of oracle were you using, 7? 8?

Bulk Load in Oracle did not work?

Well, pardon me if someone already mentioned it but i had a php-cron job for maintaining historical date in MySQL. I was doing delta refresh every-night and full refresh every saturday.

MySQL supports inserting thousands of rows using single SQL. My full refresh job was extremely efficient because I was inserting 10 years of EoD data in on shot. I started with Oracle DB but finally settled on MySQL only because of this awesome feature.

I assume similar technique can rescue you here. Keep data in memory using some collection object and use INSERT after every 2000 ticks. Consider using some messaging (say ActiveMQ) if you can spare one+ machine for this setup.

INSERT DELAYED has totally different use-case and won't help here.

Great thread ;-)

Cheers,
- Su

[saabas]

Hello,

Ninja compiler gives me error: \ Ninja Trader\bin\Custom\mysql.data.dll could not be found. The file is in thad directory. What am I missing here, could anybody help?

[NinjaTrader_Jesse]

Hello saabas,
It looks like Taddypole had had this same message and it was resolved by changing / adding the reference in the ninjascript editor

Have you referenced the DLL by doing the following?

Right click in the code section of the NinjaScript editor.
In the context menu click on 'References'
In the Reference dialog add the reference to the DLL

This is a link to the part of the thread where he had solved this.

http://www.ninjatrader.com/support/forum/showthread.php?p=155502#poststop

Please let me know if I may be of further assistance.

[andrei.reiand]

Hello saabas,
It looks like Taddypole had had this same message and it was resolved by changing / adding the reference in the ninjascript editor

Have you referenced the DLL by doing the following?

Right click in the code section of the NinjaScript editor.
In the context menu click on 'References'
In the Reference dialog add the reference to the DLL

This is a link to the part of the thread where he had solved this.

http://www.ninjatrader.com/support/forum/showthread.php?p=155502#poststop

Please let me know if I may be of further assistance.

Hi Jesse,

Is there any example of interaction from NT8 to a database (mysql / mssql) ?

Thanks

[NinjaTrader_Jesse]

Hello,

Unfortunately not, NinjaTrader its self does not provide samples for third party libraries as there are too many variables to account for regarding that topic.

Instead, if you locate any C# mysql tutorials or examples online using a search, these will likely apply to NinjaTrader as well.

As long as the dll's .net version matches the NT version you are using, I.E. NT7 requires .net 3.5 or less dlls where NT8 can support up to .net 4.5, it is possible to reference the dll and utilize its code. Also if there are 32 or 64 bit versions, you would need to match that with the version of NT you are running.

Also you would need to place whatever required dlls the mysql has in the custom folder and reference them accordingly and then start testing the code required to use the dll piece by piece in an indicator.

Often you will need to check the output window and log regarding external dll errors.

I look forward to being of further assistance.