Algorithms for merging tick data and data analysis for Indian financial market
AbstractThis paper discusses the problem of ‘merging’ financial tick data available from data sources such as Bloomberg, NSE, and Thomson Reuters etc. Different derivative securities are traded on the exchange with different frequencies in each unit of time such as second or minute in intraday trading , therefore, it is difficult to form ‘ordered pairs’, which are essential for any financial analysis, of tick data representing the simultaneous trades of the different derivative securities. Merging refers to the conversion of intraday tick data of different securities of varying frequencies, as provided by data sources, into the form in which the tick data of all traded derivative securities have same frequency, so that it is possible to form ordered pairs of data (in every unit time period) in such a way that the original nature of the data is preserved. The four merging algorithms: Truncation, Weighted mean, median and all-combinations algorithm are compared with Dropdown algorithm, which is being used widely by the trading firms. Using NSE intraday tick data for various trading days, it is found that ‘Truncation’ and ‘Weighted Mean’ algorithms are more efficient merging algorithms.
Download InfoIf you experience problems downloading a file, check if you have the proper application to view it first. In case of further problems read the IDEAS help page. Note that these files are not on the IDEAS site. Please be patient as the files may be large.
Bibliographic InfoPaper provided by University Library of Munich, Germany in its series MPRA Paper with number 32058.
Date of creation: 03 Jul 2011
Date of revision:
tick data; merging algorithm; minute data; financial market; derivative securities; high frequency financial data; intraday trading;
Find related papers by JEL classification:
- D53 - Microeconomics - - General Equilibrium and Disequilibrium - - - Financial Markets
- C15 - Mathematical and Quantitative Methods - - Econometric and Statistical Methods and Methodology: General - - - Statistical Simulation Methods: General
- C61 - Mathematical and Quantitative Methods - - Mathematical Methods; Programming Models; Mathematical and Simulation Modeling - - - Optimization Techniques; Programming Models; Dynamic Analysis
- C8 - Mathematical and Quantitative Methods - - Data Collection and Data Estimation Methodology; Computer Programs
This paper has been announced in the following NEP Reports:
You can help add them by filling out this form.
For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: (Ekkehart Schlicht).
If references are entirely missing, you can add them using this form.