Questions tagged [data]

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

Filter by
Sorted by
Tagged with
1
vote
2answers
813 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.
1
vote
0answers
166 views

Is there a public SQL database for all US stocks?

I would like to search through all US stocks (via SQL or another technology), and filter them by certain parameters (similar to a stock screener, but through an API rather than a user interface). Is ...
0
votes
2answers
2k 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?
0
votes
2answers
378 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 ...
2
votes
1answer
456 views

OTC Market Data

I am currently doing research on the OTC Markets (OTCQB, OTCQX). As far as I know, the only data available is end of day. The research will require tick level data. This leads me to two questions: ...
-1
votes
1answer
103 views

Financial statement and stock market data [duplicate]

How is it possible to have access to Datastream, Bloomberg, Wrds database? Is there another free database with long historical data? In fact, I need long time series data belonging to NYSE and NASADAQ ...
3
votes
1answer
354 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 ...
4
votes
2answers
19k 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 ...
14
votes
5answers
7k 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.). ...
2
votes
1answer
98 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
1answer
113 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 ...
1
vote
3answers
4k 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
114 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
381 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 ...
33
votes
5answers
12k 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 ...
3
votes
3answers
813 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
60 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
79 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
87 views

What does this options' data mean?

I've got myself some data on SPX optons which looks like this: ...
1
vote
0answers
34 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 ...
1
vote
0answers
93 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
1answer
228 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
54 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
118 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
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
1answer
465 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
145 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 ...
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
0answers
110 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: ...
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 ...
3
votes
2answers
106 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
0answers
306 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 ...
0
votes
1answer
69 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
70 views

Importing daily data: '-1' in volume column

I am working on importing some daily data from a public data source as csv format. The csv convention of the file seems to be that if data is not available for a field, a single white space is used ...
4
votes
1answer
879 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 ...
2
votes
1answer
496 views

Empirical copula

I am trying to find the empirical copula linking two random variables $X$ and $Y$. I have some data available but it's limited with respect to the variable $Y$ and I am not convinced it's enough data ...
-1
votes
1answer
135 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/...
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
208 views

Online database of ETF & Mutual Fund Fees?

Is there any online data source of ETF and/or mutual fund fees? Free or paid is fine, although hopefully there's something out there cheaper than Bloomberg
1
vote
0answers
58 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
186 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 ...
21
votes
3answers
7k views

data on historical stock price of bankrupt companies

does anybody know a site where I can download historical data on stocks including companies that have gone bankrupt such as lehman brothers? it appears that bankrupt companies no longer appear in the ...
6
votes
2answers
927 views

Where do quants get historical FOMC meetings events for backtesting?

Is there any usual/best practice to fetch historical fomc meetings events online?
3
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
960 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
40 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
95 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? ...