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

learn more… | top users | synonyms

1
vote
1answer
22 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, ...
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 ...
1
vote
0answers
33 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
20 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 ...
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 ...
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
0answers
22 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 ...
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 ...
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 ...
1
vote
0answers
19 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: ...
1
vote
0answers
36 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 ...
1
vote
1answer
412 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
0answers
26 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
55 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? ...
1
vote
0answers
71 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: ...
1
vote
0answers
64 views

Convertible bonds market data

My question is twofold. First, what are the key informations used to describe a convertible bond market ? I'm thinking about market size, conversion rate, appropriate index, ... Second, where to ...
1
vote
0answers
44 views

Historical list of Primary Dealers in Europe

I would be interested in a list of all the banks and financial institutions that have been Primary Dealers in the European Union from the 1980s until today. For a current list you can check this pdf ...
1
vote
1answer
102 views

Need weighted global stock index data (components / weights)

To implement a portfolio generator, I require a set of suitable stocks. Ideally it would use the components of the MSCI World Index and use the index weights for the probability of picking a stock ...
1
vote
0answers
215 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
1answer
364 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
292 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
0answers
223 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 ...
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 ...
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 ...
0
votes
2answers
164 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
2answers
66 views

What does this options' data mean?

I've got myself some data on SPX optons which looks like this: ...
0
votes
2answers
49 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 ...
0
votes
1answer
424 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?
0
votes
1answer
80 views

Difference between Tick data and NASDAQ ITCH VIEW [closed]

Could any one explain the difference
0
votes
2answers
162 views

float64 to store price data: is precision sufficient?

I am looking to store equity price data in a hdf5 table. The use will be purely as a historical archive, not as day-to-day data source. Options One option would be to store base10 significand and ...
0
votes
1answer
56 views

Data on banks’ leverage

Does someone know free resources to estimate the leverage of the banking and financial sector at an aggregate level? In particular I would be interested in something like Federal Reserve’s Flow of ...
0
votes
1answer
129 views

Finding historical data for indices [duplicate]

Where can I find historical data for option prices on a given index ? Ideally I'd like to find for a period of several months 1) historical prices on options on a given index 2) historical prices on ...
0
votes
3answers
798 views

Databases for storing and querying high frequency tick-level data?

My firm is looking for an out-of-the-box database system to store and query high-frequency tick data. What are the best options? It seems that kdb+ is the market leader in this field.
0
votes
1answer
152 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
1answer
49 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 ...
0
votes
2answers
88 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 ...
0
votes
4answers
98 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 ...
0
votes
1answer
43 views

Calculating or finding info about the value of a market? for example Cloud Storage [closed]

I am assembling a pitch which will aim towards investors by the end of this year/beginning of next year, and I need to gather information such as how much the Cloud Storage market is worth and how ...
0
votes
1answer
57 views

biggest rally data collection

Where can I find data for biggest rally(price rally) in a day? If this sort of information is not readily available, how could I produce/transform such data?
0
votes
2answers
51 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 ...
0
votes
1answer
263 views

News on ETF sector performance

I am interested to find historical news (if any) associated with intraday volatility burst in a particular ETFs like ishares IYF (Financials). So say that between 12:00 - 12:10pm, the ETF IYF's stock ...
0
votes
1answer
367 views

Source of Quandl Open Data

I am interested in Quandl Open Data, from Quandl.com These data are also denoted as Wiki Data since it relies on users to flag errors. In particular on their website, they say: This new data ...
0
votes
1answer
148 views

Where can I find historical data for volatility estimation?

I'm trying to estimate volatility following Shreve book, so I need observations of $f(t_j,t_j+\tau_k)$ and $f(t_j+\delta,t_j+\tau_k)$, where $t_J<t_{J-1}<\dots<0$ and $\tau_k$ are relative ...
0
votes
1answer
305 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 ...
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 ...
0
votes
0answers
78 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 ...
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 ...
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 ...