The tag has no usage guidance.

learn more… | top users | synonyms

5
votes
4answers
155 views

Where to get long time historical intraday data?

I am looking for long time historical intraday day data on the S&P500 composite for a time horizon like 10 years with a - for example 10-minutes tick - or prices for call/put options on the ...
4
votes
3answers
2k views

How is historical data for forex collected or computed?

I'm looking at four sources of forex data, as compiled in the question, What data sources are available online? And I think I must be misunderstanding something, perhaps something fundamental, but I'm ...
4
votes
3answers
177 views

Why was NASDAQ(or other index) not fluctuating in 70s and 80s?

Today I have a search of historical NASDAQ back to 70s and noticed the index was slightly increasing in 70s-early 90s and rising up and down in recent decade of years. Why would that happen? The only ...
4
votes
1answer
176 views

Historical Financial Statement to Backtest in R

I would like to preface this by saying I am preparing for an upcoming internship this summer so I am extremely new to Quant Finance. At my university we have access to Datastream by Thomson Reuters ...
4
votes
1answer
307 views

time in time series database - UTC or local

I strictly store UTC time stamps inside time series files or databases, mainly to allow processing several time series together. Timezone information is kept with each time series file or item, so ...
4
votes
3answers
692 views

Where to find historical stock news and other events?

So, I am working on a strategy that has pin-pointed some very interesting events in the form of extremely low volatility. The phenomena spans the past few years and a wide variety of symbols. Now, to ...
3
votes
2answers
156 views

Is there a better way to price options than with historical volatility?

I know that annualized historical volatility calculated with closing prices is a much rougher estimate than implied volatility for the correct "volatility" parameter in options pricing models. ...
3
votes
5answers
266 views

CAC40 components historical data

I'm looking for historical data of the CAC40 components. I looked at these previously asked questions: What data sources are available online? Finding historical data for indices as well as Yahoo ...
3
votes
1answer
189 views

Measuring and proxies for leverage in the financial system

It can be argued that the leverage - reflected by how much collateral people or firms need to put down to borrow and might lose if they fail to pay the loan back - used in the financial system is one ...
3
votes
1answer
395 views

Where can I get historical ticker change database?

There's 30 days worth of data at http://www.otcmarkets.com/marketActivity/symbol-changes - but I'm really looking for the past 10 years, or 5 years if only that is possible. Any dice? The closest ...
3
votes
1answer
188 views

Backtesting on historical option data

I have downloaded some daily historical option data for a timespan of 10 years and want to perform trading backtests with them. Data are European index options, on ODAX. My question is about realistic ...
3
votes
1answer
378 views

What is lagged interest rate?

I am trying to reproduce a plot in "Statistics and Data engineering for Financial Engineering" by D. Ruppert. The author uses the risk free returns data available in the Ecdat package in R. ...
2
votes
5answers
133 views

Data provider for daily futures settlement prices

Is there a data provider that has historical daily settlement prices for download? I'm interested in a provider that spans multiple exchanges.
2
votes
3answers
211 views

Hedge fund database with daily data

I am looking for a hedge fund database that provides returns daily. Is there any data provider that gives daily data?
2
votes
2answers
146 views

Where can end-of-day price volume data for Japanese stocks be downloaded or subscribed to?

Yahoo finance and google finance do not provide such data. Where can one download Japanese stock data?
2
votes
1answer
322 views

Moody's Sovereign Ratings: Clarification on Definitions and Symbols

I'm working with sovereign ratings at present. With regard to Moody's there are a few things unclear to me in their definitions. Both questions refer to the sovereign rating history in Bloomberg CSDR ...
2
votes
1answer
284 views

Aren't Technical Indicators calculated on Adjusted Close Price?

I would assume that day to day movement in stock can be accurately compared with the Adjusted Close Price and not simply the Close Price, taking into account Stock Splits Dividends etc. ...
2
votes
1answer
541 views

Google historical prices on Yahoo Finance before split?

I recently noticed that the price history for Google (GOOG) on Yahoo Finance only goes back to when the stock split. For a while I thought they just hadn't gotten around to adjusting the close prices ...
2
votes
1answer
211 views

Call option on a Mutual Fund

I am trying to price a call option on a mutual fund. Given the lack of market implied data, I am going to estimate the fund´s expected volatility using as a reference its historical volatility ...
2
votes
1answer
349 views

corporate action data

Can someone recommend a good source for corporate action data? I need at the very least: ticker changes, dividends, splits, acquisitions and delistings. I historically used Bloomberg Back Office and ...
2
votes
1answer
60 views

Free source of historical ETF units outstanding data?

I am looking for a free source of historical daily data of the number of outstanding units of ETFs and ETNs. On a Bloomberg, this would be "VXX.SO Index HP" or something like that. Does anyone know ...
2
votes
1answer
163 views

Yahoo YQL missing industry “Industrial Metals & Minerals”

When I issue the following query select * from yahoo.finance.industry where id="133" I get the following results ...
2
votes
1answer
89 views

Create 10-K Filing Database

I am finance grad student, and working to create a financial statement database. My objective is to download an income statement, balance sheet, and statement of cash flows for every publicly traded ...
2
votes
1answer
329 views

Bloomberg-alternatives for intraday stock price data?

Given the limitation Bloomberg imposes in terms of the number of days you can go into the past when retrieving historical intraday data, what are similarly reliable alternative solutions? I require ...
2
votes
2answers
136 views

Why are Quantquote historical trades different vom ActiveTick historical trades

I bought quantquote.com historical data of AAPL on second basis. To comapre I also got activetick.com For activetick I used the historical trading API. If you look at around 15:13:53 you see that ...
2
votes
1answer
348 views

S&P 500 total return since 1956

I'm looking for monthly data of the S&P 500 total return since 1956. I have looked into Bloomberg and Datastream, but it looks like there are data only from 1988.
2
votes
2answers
114 views

Where can I get equivalent of 3 months libor or swap historical data?

Please note: I have already checked your standard "Historical data sources" link, but it does not have the data I need: I am looking for 5 years of libor/swap data for major currencies. Daily, or ...
2
votes
1answer
100 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
276 views

Downloading high-frequency data: S&P 500

can I ask you where am I doing something wrong when downloading high-frequency (5-min) S&P 500 data ("USA500.IDX") from https://www.dukascopy.com/swiss/english/marketwatch/historical/ and when ...
2
votes
0answers
52 views

How to Handle Error in SEC Filings

Sometimes I see obvious errors in the 10-K or 10-Q filings that appear to go uncorrected in subsequent filings for the same period. For example, on June 9, 2014 Apple, Inc. did a 7-to-1 stock split. ...
2
votes
3answers
202 views

Calculate bond returns from yields

I have to construct and evaluate portfolio of bonds and stocks, namely I need to get return on portfolio, standard deviation and sharpe ratios. I have weekly data that contains stock prices, and I ...
1
vote
2answers
2k 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 ...
1
vote
3answers
1k views

Are PX_BID and PX_ASK on Bloomberg closing bid/ask? or are they daily averaged?

Bloomberg provides PX_BID and PX_ASK on a daily basis, but it's not clear exactly where these numbers come from. Are they closing bid and ask prices, or are they averaged over the entire day? For ...
1
vote
2answers
292 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
1answer
126 views

Mysterious disappearance of options from historical datasets

I am in the process of analyzing historical options data, and I keep finding options that mysteriously disappear before they are due to expire. For example: For the QQQ $69 Put, ...
1
vote
2answers
92 views

How To Account For Inflation Over Historical Data

I believe inflation is greatly affecting my sample data, even when using percent-changes for movements. I have read this post, which recommends the formula ((Current-Base Year CPI) * Price) / ...
1
vote
1answer
82 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
1answer
57 views

“Equivalent” data sets despite different numbers

Are the historical data sets of short term treasury bill rates considered the same as the historical data sets of savings account interest rates because by definition they are both risk free rates of ...
1
vote
2answers
378 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
2answers
112 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
vote
2answers
103 views

Does the correlation of matrices have explanatory power when building a pattern recognition model?

I'm using 8 different variables (with daily observations) with the purpose to compare different months across the historical data. For that purpose I calculate the correlation between each month and ...
1
vote
1answer
82 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
2answers
207 views

Historic Value at Risk - Ratios vs. Differences

Quick Summary on Historic VaR Let $S_0,...,S_n$ be the daily values of some stock (where $S_0$ is the current value). Then for $i=1,\ldots,n$ we let $$\hat r_i:=S_{i-1}/S_i \quad \text{and}\quad \hat ...
1
vote
1answer
143 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
263 views

constructing best bid/ask from NASDAQ TotalView-ITCH data

anybody know how to construct a intraday stock price from NASDAQ TotalView-ITCH data? I would need to know the price in millisecond, so I would need two rows: timestamp (for every millisecond) and ...
1
vote
2answers
327 views

Where can I get historical fundamental data for multiple companies in a single CSV file?

Summary I seek an explicit reference to a source that gives me a fixed URL, e.g. http://example.com/?isin=US1912161007 or ...
1
vote
1answer
158 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
2answers
57 views

I have some historical options data, and there are duplicates of some options, how to filter them

I have some historical EOD options data for 2013, and there are duplicates listed for same strikes/expirations. I was told that by the provider that this is due to "special one-time cash payout" for ...
1
vote
3answers
325 views

Daily option data

I am wondering where I can pull daily (hourly, by-the-minute, etc. even better) option data for a particular underlying. I would prefer a database I could scrape through and API, but would not mind ...
1
vote
1answer
248 views

Analog - Pattern Recognition model using KNN

I'm building a pattern recognition model for my master thesis. The idea is to build a framework with some Macro variables (long/short term rates; rates differential; equity; fx; vix) in order to find ...