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

learn more… | top users | synonyms

1
vote
1answer
37 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 ...
2
votes
1answer
714 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, ...
1
vote
1answer
176 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 ...
6
votes
4answers
9k 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 ...
0
votes
2answers
168 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 ...
1
vote
0answers
236 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 ...
7
votes
3answers
10k views

Are public historical time series available for ratings of sovereign debt?

The nice list of free online data sources Data sources online does not mention any data from ratings agencies. Are historical time series available for sovereign credit ratings (other than as ...
1
vote
2answers
467 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
3answers
1k 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, ...
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 ...
31
votes
6answers
46k views

Where to download list of all common stocks traded on NYSE, NASDAQ and AMEX?

I have a very basic data question: how to get a list of all common stocks traded on NYSE, NASDAQ and AMEX? I would need to be able to get the approximate list of common stocks as is available in ...
1
vote
1answer
658 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 ...
11
votes
5answers
6k views

Earnings and valuation data sources online

Are there any free/cheap sources for historical data on company earnings and valuations? I can get historical price data from Google and Yahoo, and it looks like I can get about five years of ...
0
votes
1answer
212 views

Where can I find monthly/weekly historical data for gold and silver [duplicate]

Preferably in monthly or weekly denomination, for at least 20 years. Preferably in Excel format, but csv, or other format is fine too. I try to google but couldn't find anything, maybe I just wasn't ...
7
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 ...
14
votes
3answers
5k views

Free market data (delayed or snapshot)

I know there are similar questions but I don't think there are any identical ones. Basically, I'm looking for one of these two things. Delayed market data feed. A tick by tick feed, but delayed by ...
-2
votes
2answers
815 views

Market Data For Project

I'm looking to find a service that will allow me to download historical data on stocks, bonds, options, futures, indices, etc and also to pick up new files either on a daily or weekly basis. I've been ...
0
votes
0answers
66 views

Need 24 hours a day real time/slightly delayed prices of futures contracts on US and non-US [duplicate]

I'm looking for a data provider to get real-time/slightly delayed data for futures contracts on US and non-US indexes 24 hours a day. Can you recommend anything for a person, who can't afford ...
3
votes
2answers
439 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 key-...
1
vote
3answers
3k 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 ...
0
votes
1answer
313 views

adjusted close prices on SP500

When I look at the adjusted close prices of SP500, for example, I notice that the numbers are always significantly below the actual closing. In the explanation of what adjusted prices are, one gets ...
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: http://deutsche-boerse.com/mda/dispatch/en/listcontent/gdb_navigation/mda/200_market_data/650_historical_market_data/35_enbs_hist_data_xetra/...
0
votes
1answer
439 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?
3
votes
1answer
257 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 ...
0
votes
0answers
855 views

fetch from yahoo! finance database - varying number of ticks

To test a model with real-life data, I used the fetch-function in matlab to connect to the database of yahoo! finance. My code to try and get 7 different assets' returns is the following: ...
1
vote
0answers
294 views

Fluid dynamics for order book depth modelling

Would someone be able to give me an idea what type of fluid dynamics I could look at for modelling the order book? My background is more signals-related maths (correlation, covariance, fourier etc). ...
1
vote
2answers
426 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 ...
25
votes
8answers
19k views

How should I store tick data?

How should I store tick data? For example, if I have an IB trading account, how should I download and store the tick data directly to my computer? Which software should I use?
7
votes
2answers
2k views

Non-SQL methods for high-frequency accounting?

Does anyone know of any prior art for non-SQL data structures for high-frequency accounting, whether client, broker, or exchange-side? I'm thinking specifically of the problem of booking individual ...
3
votes
1answer
587 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. ...
2
votes
2answers
250 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 & ...
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 http://www.google....
3
votes
1answer
486 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 I'...
7
votes
0answers
640 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 ...
1
vote
0answers
226 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 ...
12
votes
2answers
744 views

Effective Euro-USD (EURUSD) Exchange Rate Prior to Euro's Existence

Motivation: I am running a quantitative analysis that requires long-term, exchange rate data. Problem: Does anyone have methods for dealing with the EURUSD exchange rate prior to the Euro's existence?...
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 ...
6
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 ...
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.
7
votes
4answers
5k views

Analyzing tick data

What are some of the commonly used techniques to analyze tick data? I am looking at tick data to see how the quotes/ mid-price evolves due to certain events in the market. Since tick data is ...
2
votes
1answer
171 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 anywhere?...
-2
votes
1answer
744 views

Is it possible to “steal” financial data on publicly traded companies off the internet? Legally, I mean, what is the truth about “data” as a property

What constitutes "stealing" when it comes to publicly posted financial data? I think there are three instances of this that we can individually vet: a.) you physically broke into a location or ...
1
vote
1answer
96 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 ...
3
votes
1answer
339 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 ...
4
votes
3answers
439 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 ...
1
vote
1answer
142 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
258 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. ...
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 ...
13
votes
2answers
780 views

Why is the ratio of Hi-Low range to Open-Close range close to 2?

I tried it in several symbols and timeframes with the same result: $$\frac {mean(HIGH-LOW)}{mean(|CLOSE-OPEN|)}$$ ...
8
votes
3answers
1k views

Why isn't all market data free?

I am hoping any answers can be threaded somewhere between "don't be naive" and starting a quasi-political flame. Transparency is suppose to be good for markets and also a social good. The market ...