Questions about handling, obtaining, generating, or analyzing all types of financial or economic data.

learn more… | top users | synonyms

6
votes
1answer
201 views

Reliable Economic Data on China

Trying to develop a new strategy, but I need to find reliable economic data on China. It's well known that the official figures there don't tell you everything (to put it nicely), so I was wondering ...
6
votes
1answer
429 views

NASDAQ TotalView ITCH order reference number number characteristics

I am building a custom hash implementation for storing NASDAQ ITCH order messages. Obviously this is keyed on the order reference number and I am wondering if these numbers are sequential, random or ...
6
votes
1answer
142 views

Availability of machine-readable OCC Infomemos?

Does anyone know of a source of machine-readable (XML,etc) OCC Infomemos? The PDF files available below contain all the information I want, but are a pain to parse. ...
6
votes
0answers
203 views

What is the most convenient data structure for backtesting a model of futures options prices?

I have an empirical model for the dynamics of futures prices in a particular market that I have implemented using a long series of the front five contracts. (I account for the roll in my model.) I ...
6
votes
0answers
631 views

option chain data visualization, sunburst

I think option chains are not represented in the best way. With more and more options products coming out and trading on the various exchanges, I see vendors struggling to keep up with a good way to ...
5
votes
2answers
599 views

Why the difference between SPY and ^GSPC?

Look at SPY vs ^GSPC -- the difference seems bigger than can be explained by the ETF fees. Is it only because of SPY re-invests dividends quarterly or something else? Since ...
5
votes
2answers
153 views

Where do quants get historical FOMC meetings events for backtesting?

Is there any usual/best practice to fetch historical fomc meetings events online?
5
votes
1answer
1k views

Automated 10-K XBRL data grab using the SEC file structure

I would like to write a program that takes as input a list of CIK/year/quarter entries. The program should iterate through the list and, for each entry, grab XBRL financial data from the SEC website ...
5
votes
2answers
1k views

Mass Market Data Source

My current project requires large amounts of historical and real-time market data (1m or 5m bars for various products, mostly US futures for as far back as available). This data will be analyzed by ...
5
votes
3answers
4k views

How to detect and adjust for stock splits? [duplicate]

I am using a large daily data panel for over 250 companies and over several years. I am concerned about adjusting for stock splits. Is there any program in SAS to detect stock splits? How do I adjust ...
4
votes
3answers
432 views

How do you handle Calendars in a .NET quant system?

I have developed an analytic platform in .NET, but I now have to tackle the problem of data cleaning which first starts by finding holes in time series, before actually looking to find inconsistent ...
4
votes
3answers
701 views

Algorithm to detect the aggressor side of a trade

Most of the exchanges provide aggressor side property of trades (e.g. Tag=5797 AggressorSide on CME) in their raw data. But many data providers do not provide this information via their datafeed ...
4
votes
3answers
3k views

Monthly data for popular indices (constituents).

Trying to be concise: I am interested in the most popular indices (SP500, FTSE100, DAX30, CAC40, SMI30, etc). For each index I want to know its constituents in a monthly basis. For each constituent ...
4
votes
2answers
303 views

Which indices to use for an equity vs. fixed-income portfolio simulation?

I want to backtest several basic optimization methods (e.g. MVO, "most-diversified portfolio"), and I want to do this on a basket of different asset indexes. To start with, I want to simulate a 60/40 ...
4
votes
2answers
275 views

Data exported from Capital IQ, FactSet, Bloomberg, Compustat

I'm looking for reliable data on US equity fundamentals, but not sure which vendor provides these features: Unlimited data export Coverage of disbanded entities (bankruptcies, M&A) Financial ...
4
votes
5answers
467 views

CAC40 components historical data

I'm looking for historical data of the CAC40 components. I looked at these previously asked questions: What data sources are available online? Finding historical data for indices as well as Yahoo ...
4
votes
1answer
368 views

time in time series database - UTC or local

I strictly store UTC time stamps inside time series files or databases, mainly to allow processing several time series together. Timezone information is kept with each time series file or item, so ...
4
votes
1answer
1k views

How do I backtest a convertible bond arbitrage strategy in R/Matlab?

Since no one was able to answer my previous question, I am going to try to backtest a modern convertible bond arbitrage strategy myself (perhaps I'll report the results back here, if you're lucky :)). ...
4
votes
1answer
170 views

Opensource marketdata reference data for retail market

I'm not sure if this is the correct place to post this - but here goes: I have been working on a project for the last few years, during which I have come up with a set of components with the ...
4
votes
3answers
840 views

Where to find historical stock news and other events?

So, I am working on a strategy that has pin-pointed some very interesting events in the form of extremely low volatility. The phenomena spans the past few years and a wide variety of symbols. Now, to ...
4
votes
1answer
626 views

Open source equity/bond index data

I have been using the tseries package of R (get.hist.quote) to get historical quotes for various indices from yahoo finance. I am interested in DAX, VDAX, EB.REXX ...
4
votes
0answers
112 views

single channel for multiple feeds of news? [closed]

I subscribe to various blogs and twitter feeds which I use to parse for keywords. Many times these subscriptions do not include topics which are of the primary concern. Are there multiplex channels ...
3
votes
4answers
1k views

Bloomberg alternatives for fixed income data

I am looking for a (hopefully significantly cheaper) alternative to bloomberg - primarily for fixed income data. Perhaps some survice that has a more modular fee structure (so that I only have to pay ...
3
votes
2answers
1k views

Tick data collection

I am new to this. I am confused on what consists of a tick data. I have a trading platform in which I could collect data of exchange traded product like futures and stocks. While I am intending to ...
3
votes
2answers
231 views

How to get Stock Fundamental time series data?

I need key Stock Fundamentals like in http://finance.yahoo.com/q/ks?s=KO+Key+Statistics But that page shows only the last quarter data, I need to analyze how that data has changed over past years. ...
3
votes
1answer
230 views

Does Nelson-Siegel require adjustments to yield curve input data?

I am attempting to gain a better understanding of the limitations of the Nelson-Siegel model as described in Estimating the Yield Curve Using the Nelson-Siegel Model. As I have been playing around ...
3
votes
1answer
489 views

mortgage prepayment model

I am trying to develop my own MBS prepayment model. I am confused by the terms SMM and CPR. Are they estimates/models in themselves or are they ACTUAL data for the MBS pool. where can I find actual ...
3
votes
2answers
429 views

FIX/FAST packet analyzer

I have a network dump of market data in the FIX/FAST format (transported over UDP). Are there standard pieces of software (similar to Wireshark) that will parse and allow for inspection of the ...
3
votes
3answers
571 views

Loading HF stock data into excel

Are there any free, open source VBA addins or R packages that can be linked using the yahoo finance/Google finance/other data sources api to continuously download intraday data into excel or R? ...
3
votes
1answer
255 views

Measuring and proxies for leverage in the financial system

It can be argued that the leverage - reflected by how much collateral people or firms need to put down to borrow and might lose if they fail to pay the loan back - used in the financial system is one ...
3
votes
1answer
80 views

Information on Weather Derivatives

I am looking for relevant information on the organization of the Weather Derivatives market. How is it organized? How information is shared? Where can we find historical database? I am aware of the ...
3
votes
2answers
129 views

Understanding Quandl Futures Data

I'm interested in learning how to adjust my own futures contracts for analysis. Unfortunately my quantitative classes didn't really go into this, and I would like to learn it on my own. The methods ...
3
votes
1answer
195 views

Deutsche Börse sample Level 2 data, how to view in Windows?

DB has some sample Level 2 market data: ...
3
votes
1answer
1k views

Get intraday data of SAP with google Finance

According to this link I try to get intraday data of SAP listed at Xetra. Intraday data with timestep of 1 second would be great. I do not understand parts of the command, I try ...
3
votes
1answer
476 views

Where can I get historical ticker change database?

There's 30 days worth of data at http://www.otcmarkets.com/marketActivity/symbol-changes - but I'm really looking for the past 10 years, or 5 years if only that is possible. Any dice? The closest ...
3
votes
1answer
69 views

Where can I find historical DJIA closing prices?

Not sure if this is the best site for this question, it's pretty finance specific so I think it fits. In Correlation Risk Modeling and Management, Meissner refers to a study he performed on the ...
3
votes
2answers
2k views

Historical Data on $/yen forward exchange rates

Would anyone happen to know where I can find historical forward exchange rate data between the yen and dollar?
3
votes
1answer
84 views

Sovereign Credit Rating

I am working on the determinants of sovereign credit rating. I am looking for the historical rating data-set for euro-zone ...
3
votes
2answers
77 views

Finding Credit Risk Population Data

Are there any free or relatively cheap sources of aggregate data on credit risk for specific geographic regions, ages, and so on?
3
votes
1answer
572 views

What is lagged interest rate?

I am trying to reproduce a plot in "Statistics and Data engineering for Financial Engineering" by D. Ruppert. The author uses the risk free returns data available in the Ecdat package in R. ...
3
votes
1answer
338 views

Should I use SSAS to store Tick and bar data?

I have been looking for a low cost solution to effectively store and query tick and bar data. Databases like kdb+ and Streambase are too expensive for me. Building a custom solution with SSAS (Sql ...
3
votes
0answers
49 views

Where can I find ETF fund flow data?

I know mutual fund data can easily be found on CRSP or Thomson Reuters, but where can I find solid ETF data, specifically their flows?
3
votes
1answer
87 views

Vendor data aggregation for Options on Futres

Have anyone managed to automate data consolidation between Reuters and Bloomberg for Options on Futures? Are there any common attributes that these vendors share in this particular asset class that ...
3
votes
0answers
702 views

What is a good site to download historical stock 'events' such as earnings releases? [duplicate]

Possible Duplicate: What data sources are available online? Earnings and valuation data sources online I'd like to backtest some strategies involving earnings release surprises, as well ...
3
votes
1answer
47 views

Where to find Investment home bias data & Historical country weight in World MSCI

I need the following data and struggles to find it, maybe some of you can help me. Note: I'm a student and in our university ain't Bloomberg nor Reuters. Investment home bias, e.g in 2012 US ...
2
votes
2answers
5k views

How can I export intraday frequency data from Bloomberg and (how) is this procedure different than for lower frequencies?

For a research project, I would like to work with some intraday asset prices. I have already successfully exported the corresponding data at daily frequency, using the Excel API, but somehow this ...
2
votes
3answers
238 views

Hedge fund database with daily data

I am looking for a hedge fund database that provides returns daily. Is there any data provider that gives daily data?
2
votes
2answers
250 views

Intraday Data - Stylized Facts?

Can someone give an overview or literature on Intraday Data Stylized Facts? In particular for equity market returns or exchange rates.
2
votes
1answer
162 views

Where can I buy historic raw order by order data for Euronext market?

I cannot find any vendor that sell the full depth order by order data historically. I called Euronext and for some sick reason they "have the data" but "do not sell it". Do you guys know where I can ...
2
votes
2answers
1k views

Data feed API that uses REST?

Is there a data feed provider that has a REST (http) API? Preferably real-time and historical, at least for US equities.