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

learn more… | top users | synonyms

10
votes
5answers
4k views

Best way to store hourly/daily options data for research purposes

There are quite a few discussions here about storage, but I can't find quite what I'm looking for. I'm in need to design a database to store (mostly) option data (strikes, premiums bid / ask, etc.). ...
1
vote
1answer
28 views

Old CBOE SPX options data: listing and expdate issue

I can't figure out the logic behind SPX option data for 2008-2009 years. First, all traditional SPX options have exp_date on the third Saturday of each month. How can it be? Why not Friday? Second, ...
2
votes
2answers
136 views
+50

Options Data Sources

I am using Option Metrics to study a couple of things related to options. However, Option Metrics is quite limited in terms of scope (mainly it's US equities). I was wondering two things: 1) Are ...
4
votes
1answer
612 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 ...
0
votes
0answers
17 views

Comparison of quality across different fundamentals data sources?

There are a variety of different mechanisms and rules used by each fundamentals data provider to standardize and report company fundamentals. For example, the transformation of reported statements to ...
3
votes
1answer
78 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 ...
1
vote
1answer
366 views

CME historical option data provider

Is there any other historical end-of-day CME option data provider rather then CME DataMine? I've searched all the internet and found only CBOE traded options.
176
votes
26answers
118k views

What data sources are available online?

What sources of financial and economic data are available online? Which ones are free or cheap? What has your experience been like with these data sources?
1
vote
1answer
21 views

Difference between CRSP equal weighted and composite index

I am a bit confused about the overall CRSP total market return index and the equal weighted index. I know that the value weighted index places a weight on each firm by their respective market values ...
2
votes
3answers
78 views

List of TSX stocks with their sector and industry

Is there a website that offers free download or API where I can get an up-to-date list of all securities listed on the TSX along with their sector/industry? I could scrape individual screens for each ...
3
votes
1answer
42 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
1answer
60 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 ...
0
votes
3answers
160 views

Where can I find best end of day option data?

Looking for accurate end of day option data. Preferably with Greeks. Any recommendations?
1
vote
3answers
433 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
0answers
29 views

Intraday return and volatility figures some sense check

Some questions about intraday returns and volatility figures. It is with the objective of sense checking. Firstly, for Security A, I am calculating the five minute interval return numbers over 29500 ...
3
votes
2answers
123 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 ...
25
votes
5answers
8k views

What is a good broker for HFT?

Currently I trade trough IB. I run my HFT strategies (100 roundtrips per hour) but I think that latency is killing me and my profits are shrinking. I need the fastest possible brokers out there which ...
2
votes
3answers
157 views

Candlesticks: timestamp on open versus close

It seems there is not a universal rule on how should the timestamps of candlestick data be set. I have the impression that using a timestamp on open is more common (i.e.: a 1-Minute candle with a ...
1
vote
0answers
34 views

What is a good statistical test on stock prices to indicate a company's value has changed?

My current test is to take monthly proportional price changes for stock XYZ and subtract out the proportional changes of the S&P500. Then compare the mean of a sample of XYZ-S&P (e.g. trailing ...
1
vote
1answer
48 views

Example Security Giving Stock Dividends?

I'm looking for a security that has some stock dividends. Any suggestion? There are plenty of websites explaining what is a stock dividend or plenty referencing companies with cash dividends but all ...
0
votes
2answers
67 views

What does this options' data mean?

I've got myself some data on SPX optons which looks like this: ...
0
votes
0answers
80 views

Closing prices for options written on S&P 500

I would like to find closing prices for all options written on S&P 500. I tried OptionMetrics from Wharton School but unfortunately you only find bid and ask prices. Is there any other database ...
2
votes
2answers
157 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 ...
0
votes
0answers
18 views

Are Morningstar performance prices split & dividend adjusted?

I was looking at the close prices of Morningstar and I could not figure out whether they are split and dividend adjusted or just split adjusted. Example : ...
0
votes
0answers
8 views

Video Metadata Backtest

If you were to Backtest data extracted from video feeds, let's say for commodities. How many years/hours of video would you desire? The video repository is currently harvested going back 5 years and ...
1
vote
0answers
26 views

Feedback on Video Metadata Extraction

I've developed/patented a metadata extraction methodology, which we've used to build a variety of alternative datasets for funds. One of the more difficult issues in this field, is getting useful ...
14
votes
4answers
6k views

Free intra-day equity data source

Are there any free data source for historical US equity data? Yahoo finance has daily prices but I'm looking for something more granular and goes back 2 or more years (doesn't have to be close to tick ...
7
votes
3answers
1k views

Free/cheap source of structured historical quarterly filings?

What is a good place to acquire cheap/free historical quarterly filings data for US Companies? Specifically, I'm interested in the consolidated financial statements. The data should be well-structured ...
1
vote
0answers
35 views

Problem with overlapping data when testing futures market efficiency

In my case non-overlapping data would represent the scenario where futures prices (3 months) do not correspond to the futures spot prices in terms of delivery date. For example, futures settlement ...
1
vote
1answer
32 views

YOY Comparison?

I have 2 numbers: Average monthly sales volume for 2015 (Jan to Dec): 1,000 Average monthly sales volume for 2016 YTD (Jan and Feb): 1,200 If I want to compare these 2 numbers with a % change, is ...
1
vote
1answer
28 views

CRSP common stock only

How can I download exchange data for only common stocks (excl mutual funds, ETF, etc) on the NYSE, NASDAQ, and AMEX? I can't find a list of tickers or anything. Does anyone know a method? And does ...
3
votes
0answers
48 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?
0
votes
0answers
30 views

White's reality check p-value

I am running a hypothesis test based on White's reality check p-value. I am getting a weird result for my univariate time series of returns. In essence, I am following a code on MATlab to run the test ...
3
votes
1answer
78 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 ...
1
vote
0answers
23 views

Data on interest rate differentials (lending on own vs. foreign currency)

I'm looking for data on (inner country) interest rate differentials between lending in own and foreign currency. Is there any data publicly available? If yes, where? If not, which non-free sources are ...
2
votes
0answers
94 views

Equity Index Announcement Data

Does anyone know of a data source that provides announcements of future index events (adds/drops/re-balances), specifically for equity indexes? I know these are mostly available somewhere on each ...
1
vote
1answer
88 views

Historical book value data for S&P 500

In Graham's Intelligent Investor, he calculates a metric Earning/book value. I would like to calculate the same ratio in modern times (1960-2015) but am having trouble finding this data. I have found ...
1
vote
1answer
42 views

Bid and Ask Data for european stocks

I am working on something to analyze European stocks and I need some historical data on bid and ask prices. Ideally I would like something like CRSP database for US stocks. Is there some similar ...
3
votes
1answer
80 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 ...
4
votes
2answers
243 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 ...
5
votes
2answers
555 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 ...
1
vote
0answers
37 views

Where can I find bonds time series?

I want to study dependence and correlation between bonds and CDS. I have already found a large CDS database of time series there: www.datagrapple.com I am looking for such a similar database (with an ...
0
votes
1answer
154 views

Transforming daily simple returns into weekly

I am trying to transform daily simple returns into weekly returns. I am using the following R code: ...
0
votes
0answers
34 views

BLS v2 API took 20+ minutes to publish data where is immediate data available?

First, I should state that I built a Java program that uses HTTP Components to keep in sync with server time for my broker. Once 7:29:59 comes around the program ...
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?
1
vote
0answers
73 views

Match different option high frequency databases

I downloaded the “E-mini S&P 500 (Dollar) Options for 1/10/11” Top-of-Book (BBO) data. If you are interested you may download the data from the following link (approx. 80MB zipped and 1GB ...
2
votes
0answers
58 views

Data source for a corporate bond yield curve?

Yield curves are a valuable tool for economic analysis. It is particularly interesting to analyse the difference between Government Debt yields and Corporate Debt yields (credit spreads). This gives ...
60
votes
13answers
12k views

Innovative ways of visualizing financial data

Finance is drowning in a deluge of data. Humans are not very good at comprehending large amounts of data. One way out may be visualization. Traditional ways of visualizing patterns, complexities and ...
0
votes
1answer
53 views

List of US Indices [duplicate]

I need to do symbology translations between two financial systems. One part of this is to identify a symbol that is an index in one system so that I can prepend a character to it when I send it to the ...
0
votes
0answers
45 views

UK company data from Datastream: FBRIT+DEAKUK versus WSCOPEUK?

I'm working on a paper investigates the existence of a profitability premium in the UK starting in 1970. (Novy-Marx, 2013) The core methodology is creating Fama and French portfolios, testing the ...