Categories: ForexQuant Development

How to create Forex tick historical database in free MYSQL for Windows, Linux, or Apple Mac OSX

I have successfully built a historical tick database for forex. It contains nearly 300 million records of millisecond ticks. I have done all this is using MYSQL since it can be easily ported over to Linux from Windows if I need to. Oracle is too expensive as MYSQL Is free. Also, Microsoft SQL Server is quite speedy but is based on Windows only. I do however see some lag using Windows so I have to remember this issue for future implementation possibly. This database also includes 14 major currency pairs as well for the tick history as well. The forex tick data period is from the spring of 2009 to fall of 2011.

I have also loaded my forex data from comma separated value (CSV) files. I have created a C# program to load the database into MYSQL. Lastly, I have created a SQL file from MYSQLDUMP which enables you create your database and table, and then populate the table with forex tick data.
I will be posting all these resources soon in a Membership download area that you will be required to join if you want access to these resources.

Join here when I announce the resources are ready for download.

NOTE I now post my TRADING ALERTS into my personal FACEBOOK ACCOUNT and TWITTER. Don't worry as I don't post stupid cat videos or what I eat!

caustic

Hi i there My name is Bryan Downing. I am part of a company called QuantLabs.Net This is specifically a company with a high profile blog about technology, trading, financial, investment, quant, etc. It posts things on how to do job interviews with large companies like Morgan Stanley, Bloomberg, Citibank, and IBM. It also posts different unique tips and tricks on Java, C++, or C programming. It posts about different techniques in learning about Matlab and building models or strategies. There is a lot here if you are into venturing into the financial world like quant or technical analysis. It also discusses the future generation of trading and programming Specialties: C++, Java, C#, Matlab, quant, models, strategies, technical analysis, linux, windows P.S. I have been known to be the worst typist. Do not be offended by it as I like to bang stuff out and put priorty of what I do over typing. Maybe one day I can get a full time copy editor to help out. Do note I prefer videos as they are much easier to produce so check out my many video at youtube.com/quantlabs