Matlab query of PostGreSQL SQL database to generate long and short of spread trading idea

(Last Updated On: October 3, 2014)

Matlab query of PostGreSQL SQL database to generate long and short of spread trading idea

Hooray another milestone is upon us.

IMPORTANT: The limiting factor is that Yahoo could limit the number of queries I run using this method so I may be forced to used a pro susbcriber news data feed.

Wathc this video to understand howy you should be able to use database queries (and at the same generate your market metrics queries from Yahoo Finance) to sort the long and short. This should work in theory depending on the number of trading ideas I use and the number of assets requested within a certain market sector.

Join my FREE newsletter to see how this gets accomplished

NOTE: I have posted the SQL and original Excel file to get you started to save probably 6 hours of my own time researching this

whole process

Join here to get access

HOW DO YOU START A PROFITABLE TRADING BUSINESS? Read more NOW >>>

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!
This entry was posted in Matlab, Quant Analytics and tagged , , , , , , , , on by .

About 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