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

learn more… | top users | synonyms

1
vote
1answer
318 views

SEC 13F Security List has incorrect CUSIP numbers?

I'm building database of 13F sec.gov forms with 13F security lists (http://www.sec.gov/divisions/investment/13flists.htm). Along with integrity checks. I implemented CUSIP digit check algorithm to ...
1
vote
1answer
140 views

Best sources for worldwide balance sheet data?

I’m interested in databases with quarterly balance sheet data of the financial sector. I’m aware of the following datasets: -Compustat -Compustat Global -Bankscope Can someone point out other ...
1
vote
1answer
137 views

Company rank within an industry

I'm looking at the list of companies in the S&P 500 Pure Value Index. For each firm, I want to obtain the dividend yield industry percentile rank and the PEG ratio industry percentile rank. I've ...
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 ...
1
vote
2answers
427 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
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 ...
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 ...
1
vote
0answers
26 views

Where to find historical time series data for number of new investor accounts

I am examining the impact of investor sentiment on the probability of stock market crises. I am constructing a composite measure of investor sentiment according to the methodology used in this paper ...
1
vote
0answers
36 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 ...
1
vote
0answers
27 views

Data collection [duplicate]

I am looking for historical data (hopefully from 1995-2016, otherwise as much as available during that time frame) on a number of variables for 8 different stock market indexes. The indexes are ...
1
vote
0answers
37 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
37 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
25 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
27 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
37 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
35 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
24 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
40 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
74 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)...
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: https://www.philadelphiafed.org/...
1
vote
0answers
39 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)...
1
vote
1answer
553 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
28 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
57 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
82 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
67 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
47 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
165 views

Difference in weekly and monthly data

I am confused about the following: I checked daily and weekly prices for Exxon (and also GE). But the values for Open, Low, High, Close, Vol., Adj. Close for both data streams seem to differ from each ...
1
vote
1answer
108 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
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 ...
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
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 ...
1
vote
1answer
29 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
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 ...
0
votes
2answers
74 views

What does this options' data mean?

I've got myself some data on SPX optons which looks like this: ...
0
votes
2answers
52 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
2answers
176 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
441 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
2answers
63 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
1answer
87 views

Difference between Tick data and NASDAQ ITCH VIEW [closed]

Could any one explain the difference
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
137 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
840 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
202 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
2answers
108 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
99 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
52 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 ...