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

learn more… | top users | synonyms

5
votes
1answer
135 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
342 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
306 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
1answer
235 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
943 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
0answers
106 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
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
742 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
279 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
232 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
148 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
1answer
112 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
3answers
553 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 ...
3
votes
1answer
166 views

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

DB has some sample Level 2 market data: ...
3
votes
1answer
245 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
948 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
173 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
289 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
306 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
4answers
2k 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 ...
2
votes
3answers
421 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, ...
2
votes
2answers
283 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? ...
2
votes
1answer
152 views

Components of an index in a specific date

Objective: Get a list of all the companies that were ever part of an index (e.g.: FTSE100) in a given period of time (scale: years/decades). Method I have in mind: 1) Create an empty list k. 2) Get ...
2
votes
1answer
48 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
516 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
162 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
471 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 ...
2
votes
1answer
139 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
184 views

Data feed that shows individual orders

Does anyone know how I can obtain time and sales data for a stock? Lots of feeds provide the total volume but I would like to see the breakdown of what buy/sell orders made up the day's volume. I ...
2
votes
0answers
122 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
0answers
171 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
1answer
332 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 ...
2
votes
3answers
1k 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 ...
1
vote
3answers
351 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
472 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.
1
vote
2answers
216 views

Bloomberg Alternative for Quant Fund

Is there an alternative to Bloomberg for someone who only needs historical data (stocks, futures, indices) as well as what Bloomberg calls 'reference data' - i.e. what is the multiplier of ESU4, what ...
1
vote
1answer
124 views

Brent Crude Data

I am trying to locate historical volatility data (5+ years) for Brent Crude? Does anyone know where I might be able to source such data?
1
vote
1answer
237 views

Normalized data

I am new to this. I trained and tested my data using SVM in Matlab with the autoscale option true => the data would be normalized with unit SD. Let's say the training data have the price around 200. ...
1
vote
1answer
77 views

Direct exchange data via a Vendor

I am considering the option between using direct exchange connections vs using a vendor like Bloomberg for market data. I am interested in daily data and potentially tick by tickdata. Initially I am ...
1
vote
1answer
178 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 ...
1
vote
2answers
206 views

BSYM for historical tickers

When looking through Bloomberg's BSYM data ADR and Common Stock data (5/2/13), I was able to find the ticker symbol 'V' associated with Visa but was unable to find any record for Vivendi, which I ...
1
vote
1answer
88 views

Generating Return Streams for stress testing

There is never enough market data for testing. And sampling from user defined distribution is a hotly debated subject as which distribution does the market really go with? There are many ways to ...
1
vote
0answers
7 views

FTSE AIM Components From 2000, 2001, … 2013

From where can I get a list of historical component lists for the FTSE AIM Index as well as other indices? I see that there is a page for data sources here, but that page does not contain what I am ...
1
vote
0answers
48 views

What is the algorithm for the Fama-Bliss instrument selection?

Fama-Bliss discount bonds are defined through a straight forward calculation (Famma, Bliss 1987). For the purposes of a project I need to derive forward rates, yields &c. for periods not included ...
1
vote
0answers
761 views

Historical S&P 500 Stock Weights [closed]

I'm looking for histocial weights of S&P 500 constituents. I have access to a Bloomberg terminal. Any thoughts on how/where I might calculate/find these data? P.S. I'm looking for as much data as ...
1
vote
0answers
587 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 ...
0
votes
2answers
97 views

Sharpe Ratio and time spent in loss

Is it possible to express, given an annualized Sharpe Ratio value, what is an expected maximum/average time spent in a draw-down or something in this manner? E.g. with SR of 10, you'd expect to spend ...
0
votes
1answer
96 views

where can i get data for foreign exchange order flow

I need data for my thesis research on liquidity of foriegn exchange for order flow (aggregated daily) per currency traded for a period over the last 10-15 years. help!!
0
votes
1answer
125 views

Where does CME store Security IDs for FIX messages?

Where does CME store Security IDs for FIX messages? I cannot find them anywhere? So given Security ID XX I can go and work out what product this actually is?