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

learn more… | top users | synonyms

5
votes
5answers
855 views

Free data on swap options

I am trying to analyze valuation methods for swaptions. Does anyone know of free example data for these OTC-traded securities?
5
votes
4answers
7k views

Data source for historical Share Outstanding totals for individual stocks?

Data is normally adjusted for splits/reverse splits, etc. The current shares outstanding is usually available. Is there a data repository that captures the shares outstanding for any point in the ...
5
votes
2answers
416 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
149 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
3answers
1k views

Generate tick data from candlestick

Is there software (or Python / R / ... scripts) to generate (pseudo) tick data from candlestick data. I have candlestick data (CSV format) from monthly timeframe (MN) to minute timeframe (M1) but ...
5
votes
1answer
193 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 ...
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 ...
5
votes
1answer
140 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. ...
4
votes
3answers
411 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
622 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
2answers
297 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
5answers
397 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
341 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
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 ...
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
150 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
770 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
577 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
111 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
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 ...
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
1answer
198 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
451 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
384 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
538 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
233 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
57 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

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 ...
3
votes
1answer
192 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
443 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
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
498 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
331 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
654 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 ...
2
votes
2answers
4k 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
226 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
239 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
152 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.
2
votes
2answers
190 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. ...
2
votes
2answers
166 views

Transforming Variables in Regression

I have a very simple problem that hopefully someone could help me with or at least point me in the right direction. I am testing to see which factors affect index returns the most and would like to ...
2
votes
2answers
133 views

How to obtain a log of all trades done on the Nasdaq or other major US exchange?

I'm looking to do a research paper on the impact of high frequency algo-trading on individual firms. In order to do that I need to be able to determine firms that have been high frequency traded. My ...
2
votes
1answer
85 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 ...
2
votes
2answers
170 views

What are the proper metrics to look at for checking discrepancies in these two time series

I am obtaining bid/ask price and volume market data from two different sources for the same ticker and for the same day and checking to see that at time intervals X they are "roughly the same". The ...
2
votes
1answer
115 views

Source for real-time tick data (stock price, etc.) updated every second?

For educational purposes, I'm looking for a source for now's real-time tick data for stock prices, or FOREX, etc., with a 1 second precision. Is there such free data feed? If not, could such data be ...
2
votes
1answer
126 views

Online database of ETF & Mutual Fund Fees?

Is there any online data source of ETF and/or mutual fund fees? Free or paid is fine, although hopefully there's something out there cheaper than Bloomberg
2
votes
2answers
1k 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?