Visualisation of market events

We quite often get asked whether we can help provide some data to help with themes being discussed within tutorials or seminars. The chart below is one such attempt. This shows the movement in the Japanese Nikkei 225 benchmark between that fateful Friday 11th March and Tuesday 22nd March. The index data was sourced from Thomson Reuters Tick History, associated Reuters news data can be sourced from the Sirca Global News database.

We used Tibco Spotfire to render the N225 tick data into a line chart, and have done a simple label overlay highlighting two of the tragic news stories from that week, along with some labels showing open and closing N225 rates.

It is obviously possible to associate all relevant news stories with the price data and to visualise this. In fact this is probably one of the most active areas of research at present and helps to illustrate the role which Sirca plays in helping academics to work across disparate data sets and to find new ways of surfacing interesting data and analytics.


Global News / Reuters / downloading

Thomson Reuters has supported Sirca’s mission to support academic research into the financial markets for many years. The most recent extension of this support has meant that Sirca can provide academic members and subscribers with on-line access to a deep archive of Reuters news stories. This is of particular interest to academics who may be looking into the impact of breaking news stories on underlying asset prices.

Sirca’s global news archive provides access to Reuters news stories going back to 2003, complete with Reuters editorial tags, Thomson Reuters product meta data, millisecond time stamps, along with the headline and full news story.

This database is being used quite widely now amongst relevant Australia/NZ based academics. We are finding that some users are having problems downloading the full text of the news stories, these obviously being larger than the data associated with the other downloadable fields such as timestamp, headline, editorial tags etc. These problems manifest themselves as text overflowing into adjoining database cells, or text not appearing at all.

For basic downloads into Excel, follow these steps:

Download the required data in .CSV format. Open this file in Excel.

Make sure that the column containing the full text of the story is formatted as text, ie. highlight the columns headed “ACCUMULATED_STORY_TEXT” and “TAKE_TEXT”, (For Excel 2010, press and <1> and click on the “Number” tab, then highlight “Text” and press OK).

You will then need to make sure that the “Wrap text” box is checked under “Alignment” (For Excel 2010, press and <1> and click on the “Alignment” tab, then highlight the “Wrap text” box under “Text control”).

The full body of the news story should now obediently be contained within one cell, you can obviously check this by highlighting the cell.


The Global News database help file is a good resource. You can access this by clicking the “?” on the top right of the Global News user interface.