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

learn more… | top users | synonyms

2
votes
3answers
160 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 ...
2
votes
2answers
178 views

Transforming Variables in Regression

I have a very simple problem that hopefully someone could help me with or at least point me in the right direction. I am testing to see which factors affect index returns the most and would like to ...
2
votes
2answers
138 views

How to obtain a log of all trades done on the Nasdaq or other major US exchange?

I'm looking to do a research paper on the impact of high frequency algo-trading on individual firms. In order to do that I need to be able to determine firms that have been high frequency traded. My ...
2
votes
2answers
174 views

What are the proper metrics to look at for checking discrepancies in these two time series

I am obtaining bid/ask price and volume market data from two different sources for the same ticker and for the same day and checking to see that at time intervals X they are "roughly the same". The ...
2
votes
2answers
165 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
1answer
130 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
2
votes
1answer
449 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 ...
2
votes
1answer
703 views

Ordering of CME Level 2 FIX Market data?

The following link contains a file containing CME Level 2 FIX Market/Orderbook data for Corn futures: ftp://ftp.cmegroup.com/datamine_sample_data/md/mdff_cbt_20130714-20130715_7813_0.zip However, ...
2
votes
2answers
247 views

How to synchronize put and call option-data?

I recently retrieved a large amount of European option data, for call and put prices, from OptionMetrics. Doing so for the same time period I get a file consisting of 62558 rows of call prices & ...
2
votes
1answer
170 views

Historical data on short rates

I would like to backtest a short-equity strategy. I'm looking for historical data on the availability of shares and cost to short certain stocks. Does anyone know of such data being available ...
2
votes
3answers
165 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 ...
2
votes
0answers
95 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 ...
2
votes
0answers
61 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 ...
2
votes
0answers
46 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?)
2
votes
1answer
130 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 ...
2
votes
0answers
45 views

Time between end of use of ticker symbol by one company and beginning of use by another?

I have a CRSP stock dataset that goes up to december 2013. I'm trying to append yahoo finance data to it in order to bring it up to the current day. However, there are ticker symbols that once ...
2
votes
0answers
38 views

what kind of test for volatility and where find the data

I am working on a model for stochastic volatility. In short, the model try to capture that the volatility goes up suddenly after a shock (war, policy, financial events, etc) and then goes down slowly, ...
2
votes
0answers
180 views

Can a higher P/E ratio be beneficial under certain circumstances? [closed]

I am new to investing. I understand that the P/E ratio along with other data can be used to determine whether a stock may or may not be undervalued. Are there situations where a HIGH P/E is actually ...
2
votes
0answers
1k views

Historical S&P 500 Stock Weights [closed]

I'm looking for histocial weights of S&P 500 constituents. I have access to a Bloomberg terminal. Any thoughts on how/where I might calculate/find these data? P.S. I'm looking for as much data as ...
2
votes
0answers
640 views

Hobbyist Quants [closed]

I'm interested in investing some money in the stock market, and I have the math background that will make following the math used in quantitative finance possible (with some work). What are the ...
2
votes
3answers
105 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
3answers
3k views

Is there a Bloomberg field for a bonds (upcoming) coupon dates?

For a specific bond I need to calculate the time until each of the upcoming cash flow payments (for obvious reasons). So I wondered if there is a field (bulk data) that gives me all the dates of the ...
1
vote
2answers
305 views

Is it statistically valid to ignore “irrelevant” stock prices during backtesting?

As an amateur trader, I have reasonable success with my current end-of-day trading systems. All my systems are based on at least ONE year of "in-sample" data for backtesting, followed by 6-months of ...
1
vote
3answers
465 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
3answers
160 views

Where can I find a correlation matrix between the revenues of different industries?

I don't need something super complicated, I would just like a quick and dirty way of estimating the correlation coefficients between the revenues of different companies. Information on companies in ...
1
vote
3answers
1k views

Data sources for financials of global equities

I looked through the master list of data sources but could not find any data sources for financial data of global equities. An example would be the balance sheet of, say, ...
1
vote
1answer
36 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
1answer
49 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 ...
1
vote
1answer
91 views

Data on margin volumes?

I came across a Financial Times article today that said "Peaks in margin trading have been a precursor to bear runs in the past, notably in March 2000 and July 2007." I'm curious if anyone here would ...
1
vote
2answers
461 views

Bloomberg Alternative for Quant Fund

Is there an alternative to Bloomberg for someone who only needs historical data (stocks, futures, indices) as well as what Bloomberg calls 'reference data' - i.e. what is the multiplier of ESU4, what ...
1
vote
1answer
37 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
vote
1answer
43 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
1answer
290 views

Market data for options

Looking for recommendations on places to get market data for options. I'm looking at NYSE and NASDAQ only. My current solution is my broker, Tradeking. I can request realtime data for 700 option ...
1
vote
1answer
436 views

Where can I find US public company bankruptcy data

I am doing a thesis about firm survival in time of crisis (2008-2009) and I would like to know where can I find publicly available database about company bankruptcy. Since I have thousands of ...
1
vote
1answer
1k views

Python code to download historical firm data

I am looking for a Python code that scraps a website to download historical firm data such as market capitalization, dividend-yield, and so on. I have a code that downloads the current firm data from ...
1
vote
5answers
714 views

API-based equity screeners?

I know there are APIs from different brokers that allows you to trade and also obtain information about specific companies, but I wonder if there are equity/asset screeners that are API-based and can ...
1
vote
1answer
97 views

What is the distribution of stock splits?

I want to know how rare are splits more extreme than, say, 7:1 (and reverse splits similarly). An answer here points to announcements on Yahoo Finance, but apparently only monthly views. What is a ...
1
vote
1answer
171 views

Direct exchange data via a Vendor

I am considering the option between using direct exchange connections vs using a vendor like Bloomberg for market data. I am interested in daily data and potentially tick by tickdata. Initially I am ...
1
vote
2answers
4k views

where can i get data for foreign exchange order flow

I need data for my thesis research on liquidity of foriegn exchange for order flow (aggregated daily) per currency traded for a period over the last 10-15 years. help!!
1
vote
2answers
1k views

VIX intraday data

Where I can high-frequency intraday data on VIX? Is it available on Bloomberg Terminals? I see many questions posted on Quant.stackexechange about VIX options therefore I am sure someone knows where I ...
1
vote
1answer
141 views

Brent Crude Data

I am trying to locate historical volatility data (5+ years) for Brent Crude? Does anyone know where I might be able to source such data?
1
vote
1answer
256 views

Normalized data

I am new to this. I trained and tested my data using SVM in Matlab with the autoscale option true => the data would be normalized with unit SD. Let's say the training data have the price around 200. ...
1
vote
1answer
98 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
156 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 ...
1
vote
2answers
170 views

How do I find the entity identifier using BSYM?

I am new to BSYM and would like to do an entity-level search (as described here (towards bottom of document). For instance, a search for "APPLE INC" brings up 266 pages. Which one is for the entity? ...
1
vote
1answer
223 views

How to pull stock exchange names for a list of tickers, bloomberg?

How to pull stock exchange names for a list of stocks with tickers, on bloomberg? Please advise the steps so as to paste the list of tickers without having to type tickers one by one.
1
vote
1answer
311 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
131 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
643 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 ...