Java connection pool party implementation
How to make multi connections into something to serve something up
http://www.codeproject.com/Tips/1082280/Connection-Pool-Implementation
Join my FREE newsletter to see if I use Java for my automated trading
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!
Hi there
Wow. I got past some tough challenges lately.
What is below is a ‘silent movie’ showcasing the steps needed to get Matlab to connect to a SQL Server database, query a database table, and create the results within the Matlab workspace. Kind of cool.
Demo of Matlab 2012 and SQL Server 2012 connection via Java JDBC
https://quantlabs.net/blog/2013/09/demo-of-matlab-2012-and-sql-server-2012-connection-via-java-jdbc/
I have for a private video for QuantLabs.net Premium Members which shows how easy it is to generate a script from within the SQL Server Management Studio.
I just posted First version high speed automated trading platform database schema with SQL Server T-SQL script
https://quantlabs.net/blog/2013/09/i-just-posted-first-version-high-speed-automated-trading-platform-database-schema-with-sql-server-t-sql-script/
Just for fun showing the evil uses of R:
Evil uses for R with this Meetup: What Can R Tell Us About The Size Of Women?
Oops. I also posted a 45 minute private video on a complete source walkthrough on how to use the complete Complex Engine Processing (CEP) of SQL Server’s StreamInsight. It will save you many weeks for lost time of frustration. Don’t forget, it is videos like this where you will never see again as I remove public access. Now it is time to fill the gaps in this upcoming custom high speed automated trading system I am working on. So I will be implementing these new fixes into the platform. As always:
–> JOIN TO GET IMMEDIATE ACCESS TO THIS VDIEO <–
There are many other benefits listed here by joing my QuantLabs.net Premium Membership.
Thanks Bryan
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!
Demo of Matlab 2012 and SQL Server 2012 connection via Java JDBC
Note video startsat 0:30 (blame video editing software)
I have finally got this working in the video. Do note it is silent due to a new sever in play.
Note you need to activate the SQL Server services, usage of SQL Server Management Studio, and connect in Matlab via JDBC.
Matlab code came from
http://stackoverflow.com/questions/6593485/how-to-connect-to-microsoft-sql-server-2008-mssql-from-matlab
I used the Database Toolbox option with code of:
conn = database('', '','', ...
'com.microsoft.sqlserver.jdbc.SQLServerDriver', ...
'jdbc:sqlserver://:;database=');
curs = exec(conn, 'select * from ');
curs = fetch(curs);
curs.Data
close(curs)
close(conn)
Follow me on how I will proceed with this through my FREE newsletter
Considering free open source R, Java, Hadoop, with direct LMAX connection for HFT with helpful links
I have been exploring various options versus my open source HFT platform with Matlab. It seems there might be some complication from a clustering point of view with expensive licensing on Matlab and Windows products. As a result, I have looked around for new options and Hadoops always popped up. Also, Matlab does not integrate too well with Hadoop so my next option was for R for analytics and prototyping. I have lots to learn with R if I go this option. I know Java so I am ok there. Java RTS could be a good option here but can always involve a C++ platform if need be but this is still undecided.
Another challenge was the broker but after seeing LMAX in UK , I was convinced that this might be the broker since they are market neutral. This might be the way to go in terms of a a high frequency trading stack. Remember this is all true open source as well which mean it is free!
Here are some links to help get you started:
Linux but will use CentOS for the distribution with Hadoop:
http://vimeo.com/8615628 <– he uses Arch but makes valid points on it
Hadoop:
http://stackoverflow.com/questions/7053837/video-tutorial-for-hadoop
There are quite a few Youtube demos to show the power and quickness of this.
R with Hadoop (RHadoop):
http://www.r-bloggers.com/big-data-analytics-with-r-and-hadoop/
ActiveQuant could be a good option for an API as well.
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!Oanda very expensive for API connection fee with Java or C++ for forex trading
Here is my conversation chat about it with Oanda.
Please wait for an agent to respond.
You are now chatting with ‘OANDA’
OANDA: Thank you for choosing OANDA. How may I help you?
me” hi
me” i talked yest
me” yesterday with someone about your api
me” it supports C++ right?
me” can this be used to execute trades on your platform ?
me” that is the only technical question
OANDA: Yes it does.
OANDA: YOu can find more about it here.
OANDA: API http://fxtrade.oanda.com/trade-forex/api/
me” ok thanks
me” also, what is the minimum i need to an account to get started with this api and have access?
me” never mind i got that
OANDA: It needs a min bal of 600$
me” your link helps thanks
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!
What are my Canadian broker connection options for bar ticks data feed? Our junk government regulators like to hold us hostage to work with old fossil minded Canadian banks
Being from Ontario really limits me thanks to our narrow minded government regulators. I may move!!
For Sterling within Canada:
This is a list of contacts at Canadian brokers.
Title Trading
World Trade Securities
Questrade
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!
