Trading database Excel changes for PostGres on Mac OSX El Capitan
Walkthru and code of Karen Super Trader strategy with CSharp Postgres SQL IQFeed Interactive Brokers
Here i Visual Studio 2013 solution projects
PostGreSQL database SQL for AK47
Here is the PostgresSQL entire DDL (data definition language) which will create all structures for tables for my initial AK-47 database. This was created using ‘Export Tables’ out of RazorSQL
I use this tool since it can run on Windows, Linux, and Mac OSX
My PostGres SQL Trading Database DDL Schema
Here is the current and first version of it to be loaded into PostGreSQL trading ddl postgres sql
This is the needed for my entire trading ut this will be tweaked to make it efficient. It is a lazy persons person for testing at the current moment.
You should use a dcent low cost front client like RazorSQL to interface with PostGres http://razorsql.com/
Video links thread on Online Meetup LIVE Event: NOSQL vs SQL database smackdown, which one for what?
There are so many databases usedbut what for what reason. I really want to investigate this with others online. If you are interested in our poll on this on popularity, please, visit:
This should also cover the experience with pros and cons of operating systems as well including Windows, Linux, or Mac OSX.
When? Dec 15 at 7 PM EST
This will be delivered online via Goto Meeting. Also note as will there will no playback other than for Quant Elite members after this LIVE event.
Files for PostGreSQL SQL database to generate long and short of spread trading idea
Here are the files used including SQL and Excel as explained here
How I converted FinancialDemo SQL database from SQL Server 2012 to SQL Server 2014 CTP2
This was a pain!
NOTE: That this is nowhere and is suggested for LIVE trading. It is not optimized for it but useful testing trading strategies in development. I will post a final database scheme as we get close to launch live trading day
Other Limitations of SQL Server 2014:
Your SQL Server 2014 cannot reside with any other SQL Server install on the same system. See
Note: I had to convert all table primary key ids from SQL data type int to bigint to accomodate .NET C# long type as I am using DateTime.Now.Ticks to store as a unique id. Not smart I know but quick and dirty fix! Proper fix will be needed with official release of SQL Server 2014 and before going into live trading. The reason for is this that IDENTITY(1,1) is not supported in SQL Server CTP2 for Optimized In Memory tables. I know that sucks already.
Limitations listed in comment:
Download this MSSQL14FinanceDemoscript
Also, visit for the update C# Watcher for IQFeed which is updated to insert into SQL Server 2014 CTP