Demo of Download Euro Stat analyze Excel data in Python with source code
Demo of multiple Interactive Brokers TWS data using Java API pushed into NOSQL Redis
Demo of C program to pull data Redis source code
Source code for Download government data for trading idea generation
This has been posted for Quant Elite Members at this location. You can get full details on this Visual Studio 2013 (Ultimate) project here in C#. Details here on how to be a Quant Elite Member!
Detail on this project here
SnapshotFREDScan of a few markets down load with government data with a few USA sectors like oil
DId gold and it shows it is very weak Trading Idea Category Gold USA
This snapshot only show Professional Business Service has any growth will full expansion of employment:SnapshotFRED
This coud have been an interestign sector to scan Trading Idea Category Asset Management USA
Important resources for government data for long short automated trading with FREE Quandl Excel DotNet CSharp
Here are the links and tools you need to know
How to automate easily end of day historical data trading CSV files
This is using QCollector easily create these CSV from IQFeed
Old High Frequency Tick Data R Package exists with spreads, trade direction, statistics, volatility for forex and equity
This high frequency R package looks fantastic. It includes a lot of analysis on high frequency data where the number of observations could easily be 100K or way more. It contains so many juicy benefits including:
1. A very decent PDF sample is included. This can be quite rare as there are some real world examples including a few equity analysis and even foreign exchange trading pair.
2. A good section is described on duration which is part of high frequency data.
3. Many traders will always find spread results but again to see an R function do this is rare. On the provided equity example like Microsoft, this shows the spread between the bid and ask quotes. It is quite convenient. There is also an example provided with a foreign exchange pair as well between bid and ask quotes in multiples of ticks with a specified tick size. I never saw anything like this in Matlab.
4. There is a handy function which triggers a trading direction. Here you can analyze the dataset to know when to buy or sell based on this function. You can also specify the time lag as well.
5. There is a set of handy functions for standard statistic measurements like mean, standard deviation, etc. As well, you get associated plots like histograms as well as functions for calendar patterns.
6. There is a realized volatility function which is based on Anderson versus other volatility models like GARCH models, stochastic volatility models, or the volatility implied by options or other
Derivative prices. Also, there is another set of benefits quoted from the supplied PDF:
They prove that as the sampling frequency of returns approaches infinity,
realized volatility measures are asymptotically free of measurement error. For daily
volatility, they use 5-minute returns to construct daily realized volatilities. The 5-
minute horizon is short enough to have the underlying asymptotic work well, but long
enough to mitigate the autocorrelation distortion caused by market microstructure
All this sounds fine but you will find that this package is pretty old from 2003. This R package looks like it has been abandoned and needs a refresh so let me know what you think of this package’s potential. I want to note the conversion using the TAQ Load seems broken so capturing and converting data is not so easy.
Get your hands on it over at:
Compatible R in S+:
Get the data here: http://faculty.washington.edu/ezivot/ezresearch.htm