Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [data]

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

3
votes
1answer
301 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 ...
3
votes
3answers
660 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
55 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
77 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 ...
3
votes
1answer
107 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 ...
0
votes
2answers
87 views

What does this options' data mean?

I've got myself some data on SPX optons which looks like this: ...
1
vote
1answer
307 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 ...
3
votes
5answers
4k 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 ...
1
vote
0answers
33 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 ...
2
votes
3answers
346 views

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 ...
1
vote
0answers
74 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
39 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 ...
2
votes
2answers
494 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
1answer
331 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
2answers
1k views

Where can I find best end of day option data? [duplicate]

Looking for accurate end of day option data. Preferably with Greeks. Any recommendations?
1
vote
0answers
49 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 ...
3
votes
1answer
203 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 ...
2
votes
0answers
117 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
370 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 ...
1
vote
0answers
105 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
3k 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: ...
6
votes
2answers
3k 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 ...
1
vote
1answer
1k 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
0answers
52 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 ...
2
votes
0answers
283 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 ...
3
votes
3answers
2k 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
0answers
126 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 unzipped)...
0
votes
1answer
67 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
2answers
316 views

Handling upcoming corporate actions for equity portfolio

I have an equity statarb strategy developed using CRSP daily data. The strategy is always invested (long or short) in around 400 stocks. The ...
-1
votes
1answer
133 views

Where can I find data source for structural models?

I am starting a project to implement the Black-Merton-Scholes model from this book in R. However, I am looking for, ideally free, data sources. Still I have access to a Bloomberg terminal. Can you ...
1
vote
0answers
25 views

Sample data of quarterly (annualized) real GDP growth

I am looking for a database that provides me the quarterly (annualized) real GDP growth (quarter t and t-1) of US, Germany and England. For the US data i went here: https://www.philadelphiafed.org/...
1
vote
1answer
157 views

Interest rate models

I'm studying by myself how to model interest rates. Is there any database in which I can find accurate data for indices like Libor, Euribor, Eonia etc?
0
votes
2answers
62 views

Definitive way of figuring out companies with multiple classes of stocks

Is there a definitive way of mapping tickers to companies for companies with multiple listed tickers? For example, GOOG and GOOGL are both Google (or now Alphabet), or BRK.A and BRK.B are both ...
2
votes
1answer
103 views

Exactly what data is available in XBRL, and how far back does it go?

What data is available from the SEC in XBRL format? Is it just 10-Qs and 10-Ks, or other filings as well? When did XBRL become mandatory for all filers (or is it still not?)
1
vote
0answers
56 views

What are the best sources for fundamental financial data? (not yahoo or google, neiter SEC counts as good) [duplicate]

I'm looking for a source for fundamental financial data, where I can download financial statements into excel. The source should provide the exact figures shown in the annual reports (not standardized)...
0
votes
0answers
160 views

How to use Chow Lin method?

Can someone give me a simple explanation of how exactly this method works. If I have a dataset of say 10 quarters (dependent variable); how should the independent variable (say monthly data) be ...
4
votes
1answer
141 views

Vendor data aggregation for Options on Futures

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 ...
5
votes
2answers
634 views

Where do quants get historical FOMC meetings events for backtesting?

Is there any usual/best practice to fetch historical fomc meetings events online?
2
votes
1answer
4k views

Calculate and plot historical volatility with Python

I have downloaded historical data for FTSE from 1984 to now. What I would like to do is to graph volatility as a function of time. What I have written is: ...
1
vote
2answers
685 views

Original Fundamental Accounting Data (Not Ratios)

Where do I get original fundamental accounting data from income statement, balance sheet and cash flow statement, like Sales/Revenue, Gross Income, EBIT, Operating Income, Cash & Short Term ...
0
votes
2answers
800 views

Ledoit-Wolf Shrinkage estimator not giving positive definite covariance matrix

I used ten year daily data for 407 stocks and computed the daily and monthly covariance matrices. Since I have more variables than observations for the monthly matrix, I wasn't surprised to find the ...
1
vote
0answers
37 views

Historical UK Gilt 2-year and 5-year data

Data on the Medium (approx. 5-years) and Short (approx. 2-years) futures contract listed on ICE only goes back to 2009. Is anyone able to point me towards where I can get a longer time series, perhaps ...
1
vote
1answer
93 views

what are database for downloading Spatial Data?

I am trying to find a good database for Spatial Data. What are the examples of this kind of data? IS it always related to geography? Any Spatial data related to finance, economics and statistics? ...
3
votes
2answers
353 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 ...
3
votes
4answers
628 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. ...
-1
votes
1answer
84 views

Long-Term Government Bond Yields

On the Federal Reserve of St. Louis FRED website we can find the 10-year government bond yields: https://research.stlouisfed.org/fred2/data/IRLTLT01USM156N.txt. I chose monthly frequency and percent ...
0
votes
4answers
129 views

How can one get broker order data?

Is there any chance to get order data from any broker with a label from which account it came from? The accounts can be anonymized, i just need to identify an account's orders sent. Any help will ...
2
votes
1answer
158 views

Acquiring large sets of price series

Selling and delivering real-time data seems to be the focus of practically all large data vendors, but I am more interested in acquiring large sets of historical daily data covering, say, 5.000 ...
1
vote
0answers
169 views

ISM PMI data - sector trend through ranking and seasonal decomposition

I have monthly data for each of the 18 sectors in the ISM PMI. Each datapoint shows the trend of a sector: growing, contracting or neutral. It also tells the strength of that trend with a number: "...
7
votes
3answers
4k 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 ...