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

learn more… | top users | synonyms

5
votes
1answer
186 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
1answer
136 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. ...
5
votes
0answers
520 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 ...
4
votes
3answers
368 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
409 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
1answer
288 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
3answers
633 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
0answers
142 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 ...
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 ...
4
votes
1answer
2k views

Why use a column database for tick/bar data?

I often hear that column-oriented databases are the best choice method for storing time series data in finance applications. Especially by people selling expensive column-oriented databases. Yet, at ...
3
votes
4answers
4k 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 ...
3
votes
4answers
736 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
2k 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
899 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
359 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
277 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 ...
3
votes
2answers
292 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
460 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
5answers
204 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 ...
3
votes
1answer
172 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
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 :)). ...
3
votes
1answer
182 views

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

DB has some sample Level 2 market data: ...
3
votes
1answer
957 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
358 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
347 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
318 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
478 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
3answers
2k 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 ...
2
votes
1answer
123 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 ...
2
votes
2answers
194 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
127 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
135 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
118 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
2answers
160 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
67 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 ...
2
votes
1answer
66 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?
2
votes
1answer
622 views

Ordering of CME Level 2 FIX Market data?

The following link contains a file containing CME Level 2 FIX Market/Orderbook data for Corn futures: ftp://ftp.cmegroup.com/datamine_sample_data/md/mdff_cbt_20130714-20130715_7813_0.zip However, ...
2
votes
2answers
210 views

How to synchronize put and call option-data?

I recently retrieved a large amount of European option data, for call and put prices, from OptionMetrics. Doing so for the same time period I get a file consisting of 62558 rows of call prices & ...
2
votes
1answer
158 views

Historical data on short rates

I would like to backtest a short-equity strategy. I'm looking for historical data on the availability of shares and cost to short certain stocks. Does anyone know of such data being available ...
2
votes
0answers
41 views

Time between end of use of ticker symbol by one company and beginning of use by another?

I have a CRSP stock dataset that goes up to december 2013. I'm trying to append yahoo finance data to it in order to bring it up to the current day. However, there are ticker symbols that once ...
2
votes
0answers
33 views

what kind of test for volatility and where find the data

I am working on a model for stochastic volatility. In short, the model try to capture that the volatility goes up suddenly after a shock (war, policy, financial events, etc) and then goes down slowly, ...
2
votes
0answers
175 views

Can a higher P/E ratio be beneficial under certain circumstances? [closed]

I am new to investing. I understand that the P/E ratio along with other data can be used to determine whether a stock may or may not be undervalued. Are there situations where a HIGH P/E is actually ...
2
votes
0answers
623 views

Hobbyist Quants [closed]

I'm interested in investing some money in the stock market, and I have the math background that will make following the math used in quantitative finance possible (with some work). What are the ...
2
votes
1answer
439 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 ...
1
vote
2answers
1k 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 ...
1
vote
3answers
1k views

Is there a Bloomberg field for a bonds (upcoming) coupon dates?

For a specific bond I need to calculate the time until each of the upcoming cash flow payments (for obvious reasons). So I wondered if there is a field (bulk data) that gives me all the dates of the ...
1
vote
2answers
278 views

Is it statistically valid to ignore “irrelevant” stock prices during backtesting?

As an amateur trader, I have reasonable success with my current end-of-day trading systems. All my systems are based on at least ONE year of "in-sample" data for backtesting, followed by 6-months of ...
1
vote
3answers
139 views

How to pull an exhaustive list of securities traded globally, on bloomberg?

I need to extract an exhaustive list of securities with CUSIPs and ISINs on bloomberg. This data needs to be on a global level. Can someone help with the formulae on bloomberg please? Cheers, G
1
vote
3answers
753 views

Data sources for financials of global equities

I looked through the master list of data sources but could not find any data sources for financial data of global equities. An example would be the balance sheet of, say, ...