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

(Last Updated On: November 30, 2011)

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!
share this recipe:

Still hungry? Here’s more

Are you interested in:


FREE 2 Hour Video! 


As you know with the crazy restrictive emergency laws being introduced in the last week, many moving their savings out of FIAT banks into cryptocurrency trading.

Here are some questions to get your started:

  • Create your own ‘bank’ anonymously with crypto
  • In the future, draw off your crypto saving with a Visa debit card
  • Trade using a European de-central exchange to trade perpetual contracts and other high performing coins
(All your info is kept private nor released!  Don’t forget to check to click your promo or spam inbox after the confirmation email is sent) 

Create your own  PRIVATE Bank