Heatmaps: Application in the stock market

This is an example of the application of Heatmaps in the stock market. This tools aims to identify
stocks with uptrend behavior (bullish trend) in the NYSE.

---

Stocks Charts Application using HighCharts

Using Highcharts.com, it is possible to display charts for your favorite stocks so you can have the opportunity to zoom in or zoom out, see the trend and add additional features.

---

Moving Chart Scatter Diagram through time using D3

This chart displays the evolution of two metrics through the time.

---

R - QlikView Integration

QlikView lacks of statistic tools to perform advanced analysis such as regression analysis, multivariate analysis, inference tests, predictive analytics, etc. There is a plug in which integrates QV and R. R is an open source programming tools for statistical computing and graphics (http://www.r-project.org). The integration is made through a COM interface. Three packages must be installed first previous to any analysis:

 1. statconnDCOM Server (http://rcom.univie.ac.at/download.html#statconnDCOM)

2. Rcom: is an R package allowing to have R and another program running at the same time and let them communicate.

 3. rscproxy is an R package which is required for Rcom and for the statconn (D)COM Server.

Once these three packages are installed, a VBS script can be used to call R and perform analysis. Open the macro edit module (CTRL+M) and make sure that “System Access” and “Allow System Access” are selected.

Finally, this is the vbs macro in QlikView. Click on the image to enlarge and see the content of the script.