Hot answers tagged

13

That was the devaluation of the French franc on 8 August, 1969 (by 12.5% in terms of par value), decided by President Pompidou and his finance minister Giscard d'Estaing. In those days exchange rates were quasi-fixed but subject to periodic realignments (the so-called Bretton Woods system of exchange rates, which was replaced by today's floating rate system ...


9

You are not clear if you want the S&P500 index (SPY), OPRA Options or the Futures. Having spent a lot of time exploring vendors, here is a summary to help you (in alphabetical order): AlgoSeek.com : Intraday data back to 2007 for US Equities, Futures and Options. So you can get S&P 500 data. Intraday they have tick, 1 sec, 1 min and 5 min OHLC bars....


7

Markit Pricing Data is a prime source for cds data (not free).


4

Compustat supports unlimited data export keeps the history of disbanded entities provides restatements since 1950 + point-in-time data since 1986 coverage since 1950 list of variables (data guide) Compustat is a S&P subsidiary. It goes as a plugin for CapitalIQ (also S&P), WRDS, CRSP, and other platforms. Pricing starts from \$3k. A platform ...


3

Better than Markit, you can have a look at https://www.datagrapple.com/ (subscription is free). About 1000 CDS are covered. Daily end-of-day prices (mid of a best bid/offer order book) from Jan 2006 and continues on an ongoing basis. There are the charts you want starting 2006. I think you may also be able to subscribe to an intra-day livefeed if you want.


3

I dont know of any provider that fulfills your whole requirements, but perhaps I can give you some useful information. General thoughts: Some vendors (e.g. MSCI) can have statements in their license agreements that prohibit an entity from storing historical data older than e.g. 3 years. This could be one obstacle in finding a supplier who has full 10 year ...


2

Thomson Reuters Tick History. Reasons you might want to use it: 1) It has just about everything you could possibly imagine, going back a long way, and more. 2) The API is (mostly) straightforward to use, so you can download tons of stuff without mucking around in Excel or spreadsheets of any kind. 3) The data can arrive pre-cleaned. Of course, it is ...


2

Morningstar Morningstar partnered with Quantopian, and the latter published the structure of Morningstar's equity fundamentals database: https://www.quantopian.com/help/fundamentals Quantopian users can use this data for free.


2

Most of the information is not publicly available, nor are the data free of charge. One of the better sources is Kenny Tang's book, Tang, K., Ed. (2010). Weather Risk Management: A guide for corporations, hedge funds and investors, Risk Books. ISBN-13: 9781904339687


2

Stock / ETF at 5-minute intervals can be downloaded from Yahoo Finance. See the code below: from urllib import urlretrieve import numpy as np, pandas as pd, sys import datetime as dt, requests import datetime, re, StringIO symbol = sys.argv[1] url='http://chartapi.finance.yahoo.com/instrument/1.0/%s/chartdata;type=quote;range=3d/csv' % symbol response = ...


2

For what concerns Forex data which is, however financial data after all, I often use http://www.histdata.com/. Their data is delivered in .CSV format. For timeframes, I quote the website: We can only deliver you time ordered Tick and M1 (1 minute) data. The data that we have available is organized by forex-pair/year/month. They also provide data for ...


2

I did not know this provider, but had a look. for daily data, the url seems to be http://www.netfonds.no/quotes/paperhistory.php?paper=GOOG.O&csv_format=txt for market depth: http://www.netfonds.no/quotes/posdump.php?date=20160303&paper=E-SABL.BTSE&csv_format=txt for intraday trades: http://www.netfonds.no/quotes/tradedump.php?paper=E-SABL.BTSE&...


2

From On Valuing Constant Maturity Swap Spread Derivatives "The CMS tickers are represented as USSWAPyy, where yy is the year indicator. For Example the tickers for CMS 30 yrs and CMS 2 yrs are USSWAP30 and USSWAP02 respectively"


2

There's a very simple explanation. The NYSE trading floor only deals in NYSE-listed stocks. NYSE have other venues (such as Arca) that allow you to trade listings from other exchanges. The following site has a very good summary of "tape" versus the volume traded at each venue. https://www.batstrading.com/market_summary/ Note that Tape B contains trades ...


2

This is available directly from MSCI's website: MSCI End of Day Index Data Search. If you click on an index name, you can download the entire history.


1

Well you have to be more flexible in your thinking. If you believe that a spike in libor might occur, you have to manipulate the model to produce that scenario. How about just moving the yield curve to that scenario and revaluing the portfolio. Or jack the libor volatilty by a factor of 20. This reminds me of why some banks blew up in the crisis. ...


1

If you really just want the charts, you can get this on the TD Ameritrade platform. You do need a funded account, so it is not exactly "free" but there aren't any fees associated with it. In their desktop client, you can select "On Demand" mode. This gives you the ability to rewind to earlier points in history for sim trading purposes. Just rewind back ...


1

What I would do : Step 1. Calculate $V=\sum_i \frac{\Delta P_i^2}{dt_i}$ Step 2. Annualize V. $V_a=\frac{V}{T}$ Step 3. Find $\sigma = \sqrt{V_a}$


1

I've collected minute data for forex scarped by yahoo finance for last year Columns: Timestamp,close,high,low,open,volume https://www.dropbox.com/sh/1j4gitwy81oo0k7/AACoPasZR4dVHkMNXxUnZwr6a?dl=0


1

I agree on Richard. the simpler you choose, the better it is so as to get reliable estimates. What's your data frequency? purpose? For model construction as far as I am concerned, daily data from 2010 is enough. Otherwise, you could use a proxy asset for asset D depending on its nature. To clarify, if D is an ETF let's say CAC 40 ETF, concatenate its return ...


1

You can consider old prices for Stocks B, C and D to be "missing data" and apply techniques used by Statisticians to deal with such missing data. One approach, the EM algorithm, suggests you estimate the covariance for the common period, use that covariance matrix and the available data to generate pseudo data for the back period for the third stock and re-...


1

The short answer: Take all time series starting from 2010 (at most). The covarianc-matrix tells you something about the assets for a certain amount of time. E.g. if I estiamte the covaraince matrix of those 4 assets taking into account data from the last year (!) then I can expect that this matrix remains valid for the coming 1-3 months - if the markets don'...


1

You're getting confused because data providers will actually give you "continuous" contracts which are not the ones traded. When you get in a future contract trade, you buy a future contract which has an expiry date. After that date, the contract does not exist anymore, money is exchanged against underlying for those who still have a position. When you do ...


1

S&P Compustat is the standard for most academic research.


1

If you really want accuracy, the answer is the SEC. Otherwise, you'll have to expect some inaccuracies. Bloomberg I would probably rank highest of the ones listed, but this is more qualitative than quantitative, as I know of no studies that suggest it to be most accurate.


1

Native support is very limited. TradeStation's WebAPI pretty much works with any language because it is wrapped in HTTP calls using RESTful. If a platform has an API that supports std C/C++ interfaces, you can write a wrapper to extend the API to python. Search for "Calling C from Python". It is more work to code, but otherwise your choices are very ...


1

This is an old post, but I thought I would offer the following facts: 1) QQ claims to be sited in the Empire State Building, Suite 2100. (https://quantquote.com/contact.php) That is false. They do not lease or sublease that address. 2) The VM message on their sales line is a standard carrier-provided one such as a private individual would have. It does ...


1

You can get minutely as-traded prices for all US securities on Quantopian, for free. You can't download the original data, but you can query it, analyze it, and do your research within a hosted IPython notebook on the website. Once you register, go to https://www.quantopian.com/research and check the get_pricing() demo notebook. Disclosure: I work at ...


1

I would second Colin's proposal of Reuters Tick History or perhaps BB B-PIPE. The pricing model is especially attractive in your case since you are mainly interested in a finite subset of tickers, i.e. the S&P 500 composite, and they cover a very large set of exchanges. The choice between exchange and data vendor is largely a matter of cost-to-symbols ...


1

If 15 trading days 1-min data is enough for you, try HQD software http://www.ashkon.com/downloader.html



Only top voted, non community-wiki answers of a minimum length are eligible