My 2 cents in mysql database - NinjaTrader Programming | futures io social day trading
futures io futures trading


My 2 cents in mysql database
Updated: Views / Replies:2,975 / 5
Created: by iwannatoscript Attachments:0

Welcome to futures io.

(If you already have an account, login at the top of the page)

futures io is the largest futures trading community on the planet, with over 90,000 members. At futures io, our goal has always been and always will be to create a friendly, positive, forward-thinking community where members can openly share and discuss everything the world of trading has to offer. The community is one of the friendliest you will find on any subject, with members going out of their way to help others. Some of the primary differences between futures io and other trading sites revolve around the standards of our community. Those standards include a code of conduct for our members, as well as extremely high standards that govern which partners we do business with, and which products or services we recommend to our members.

At futures io, our focus is on quality education. No hype, gimmicks, or secret sauce. The truth is: trading is hard. To succeed, you need to surround yourself with the right support system, educational content, and trading mentors Ė all of which you can find on futures io, utilizing our social trading environment.

With futures io, you can find honest trading reviews on brokers, trading rooms, indicator packages, trading strategies, and much more. Our trading review process is highly moderated to ensure that only genuine users are allowed, so you donít need to worry about fake reviews.

We are fundamentally different than most other trading sites:
  • We are here to help. Just let us know what you need.
  • We work extremely hard to keep things positive in our community.
  • We do not tolerate rude behavior, trolling, or vendors advertising in posts.
  • We firmly believe in and encourage sharing. The holy grail is within you, we can help you find it.
  • We expect our members to participate and become a part of the community. Help yourself by helping others.

You'll need to register in order to view the content of the threads and start contributing to our community.  It's free and simple.

-- Big Mike, Site Administrator

Reply
 
Thread Tools Search this Thread
 

My 2 cents in mysql database

  #1 (permalink)
Member
Budapest
 
Futures Experience: Beginner
Platform: ninjatrader, multicharts, metatrader
 
Posts: 34 since Jun 2009
Thanks: 8 given, 2 received

My 2 cents in mysql database

Hi folks,

i'd like to store all data from all futures ( many that i can) and share with other guys,
could someone explain how to start collect data and share them?

Reply With Quote
 
  #2 (permalink)
Quick Summary
Quick Summary Post

Quick Summary is created and edited by users like you... Add FAQ's, Links and other Relevant Information by clicking the edit button in the lower right hand corner of this message.

 
  #3 (permalink)
Elite Member
Atlanta, Georgia
 
Futures Experience: Intermediate
Platform: NT
Broker/Data: DDT
Favorite Futures: ZN, ZB
 
cbritton's Avatar
 
Posts: 224 since Mar 2010
Thanks: 152 given, 237 received


One possible approach would be to load a database driver in a ninja script and write the data as it comes in (OnBarUpdate()) to a table in the database. I was looking at storing some information from a strategy into postgres (my preference), but not actual back tested data. I did some googleing and found a C#-postgres database driver, but I have not tried using it yet. Here's a writeup on getting started with that: Using PostgreSQL in your C# (.NET) application (An introduction) - CodeProject

Mysql is also popular. Here's a site: MySQL :: Open Connection using C#

Also, I'm not sure if NT will allow third party tools like a database driver, but it should be possible since it's C#.

I don't know what the finest granularity of data size you would need to store to effectively replay at different tick size/time intervals.

It's still an interesting project Good luck.

Reply With Quote
 
  #4 (permalink)
Member
Budapest
 
Futures Experience: Beginner
Platform: ninjatrader, multicharts, metatrader
 
Posts: 34 since Jun 2009
Thanks: 8 given, 2 received

Wow,

i see that the best datafeed and granularity is zenfire by mirus.

My idea was very simple.

I see that there is a project on this forum on database in mysql, i have a pc that i can use to store data, so i'd like to store data from datafeed and post the data evry day.

I am not a programmer, so my is only an idea, i don't have the knowledge to use mysql.

I ask if is there a video tutorial on this forum but nothing.

I see also that bigmike wants to jump on multicharts, so would be nice if is it possible to use one databe for 2 trading paltform.

Anothe poiu is to kake rollover and long data for futures automatic way.

Bye

Reply With Quote
 
  #5 (permalink)
Elite Member
Atlanta, Georgia
 
Futures Experience: Intermediate
Platform: NT
Broker/Data: DDT
Favorite Futures: ZN, ZB
 
cbritton's Avatar
 
Posts: 224 since Mar 2010
Thanks: 152 given, 237 received

Another approach is to take the existing historical data files and insert them into database tables via bulk insert (for postgres anyways). I have not looked at the format for the data, but I don't think that massaging the data for inserts should not be difficult (for me anyways. I have experience with this sort of thing ).

Now getting data into NT from the db will require some work. From this post on the NT forum, NTDataFeeder pulls in data from a file and plays it back to NT:

External data feeder that read from NT export files and esignal replay file - NinjaTrader Support Forum

The idea would be to rework this tool a bit to instead pull data from the database.

This thread on the NT forum points to the API for the data feed that would need to be used (see post #5):

API/Data feed question - NinjaTrader Support Forum

If the source code is available for NTDataFeeder, then that's even better

This opens up a range of other possibilities as well. For example, special instruments can be created just for simulated data created using the monte carlo....


Regards,
C

Reply With Quote
 
  #6 (permalink)
Member
Budapest
 
Futures Experience: Beginner
Platform: ninjatrader, multicharts, metatrader
 
Posts: 34 since Jun 2009
Thanks: 8 given, 2 received

Oh, great stuff.
I think more in easy way.

If evryday i have my ninjatrader open and market analyzer ready with all instrument, futures, stock... that i like, are the stored in the database?

How could i fill the gap of one week if i am going to holiday?

When there is a rollover day about futures how could manage the database in right way, to have a long chart of many years without bad spike or databroken?

Each trader should have a database of at least 8 years to test strategy.
This data should be load on ninja and afther maintain database.
It seems a not important work this but for algotrader is it foundamental.
Another point is that all this process should be simple and not a waste of time.

So all kiss idea and practical are accepted.

Sorry i am not a programmer, but a trader and i am learning now how to do this, but i try to help the other and give good ideas.

Bye

Reply With Quote

Reply



futures io > > > > > My 2 cents in mysql database

Thread Tools Search this Thread
Search this Thread:

Advanced Search



Upcoming Webinars and Events (4:30PM ET unless noted)

Linda Bradford Raschke: Reading The Tape

Elite only

Adam Grimes: TBA

Elite only

NinjaTrader: TBA

January

Ran Aroussi: TBA

Elite only
     

Similar Threads
Thread Thread Starter Forum Replies Last Post
GomRecorder with MySQL backend Big Mike The Elite Circle 25 October 14th, 2012 05:46 PM
Tick Database Storage MXASJ Platforms and Indicators 40 July 20th, 2012 01:30 PM
Gas Prices Expected to Drop 50 Cents by Summer Quick Summary News and Current Events 0 May 8th, 2011 08:10 PM
Database for NT bomberone1 NinjaTrader Programming 6 April 29th, 2011 10:11 AM
mysql db writer tortexal NinjaTrader Programming 2 November 27th, 2009 11:59 AM


All times are GMT -4. The time now is 02:52 AM.

Copyright © 2017 by futures io, s.a., Av Ricardo J. Alfaro, Century Tower, Panama, +507 833-9432, info@futures.io
All information is for educational use only and is not investment advice.
There is a substantial risk of loss in trading commodity futures, stocks, options and foreign exchange products. Past performance is not indicative of future results.
no new posts
Page generated 2017-12-12 in 0.11 seconds with 19 queries on phoenix via your IP 54.90.207.75