Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [data]

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

0
votes
0answers
42 views

API returning company tickers found in provided news article

I'm looking for a REST API (paid or free) that accepts a string containing a news article (example below) as payload and returns an array of company tickers (eg TSLA for Tesla) mentioned in the ...
0
votes
1answer
43 views

Generate scenarios of multiple related parameters

Assume I have three industry datasets: interest rates, inflation and unemployment. Data contains information of last ten years and it's monthly. Now, I would like to create N possible scenarios of ...
1
vote
1answer
42 views

ETF performance/returns

I was going over some ETF return data on yahoo finance and encountered some numbers that did not make sense to me. The image below shows a ytd return of 17.94% and 13.52%. I checked ETF.com and ETFdb ...
1
vote
2answers
75 views

where to download current composition of popular indexes?

What are reliable sources to download plain-text files listing current composition of various popular indexes such as S&P 500 (SPX) or Dow Jones Industrials (DJI) or Nasdaq 100 (NDX) ? At a ...
0
votes
0answers
21 views

Where can I get large dataset [duplicate]

Where can I get large unbiased dataset for all stocks in the world (and not just the historical price but also the balance sheets fact and ratios). By unbiased I mainly mean to: 1. not being ...
1
vote
1answer
71 views

Efficient computing of stock returns taking dividends into account

I have two DataFrames as follows: Dividends: ...
0
votes
0answers
17 views

Termstrc data preparation from Bloomberg terminal

I am trying to use the R package termstrc to estimate yield curves for the Czech Republic. I have found the structure of the required class ...
1
vote
1answer
97 views

Which data provider do you recommend? [duplicate]

i need to run optimization models and backtests on developed market equities. I have access to Refinitivs Eikon, but it doesnt have a backtest tool and downloading the data is a challenge on his own. ...
2
votes
1answer
96 views

Data: Why is a firm stock delisted?

Shumway (1997) highlights that stock returns in cross-sectional portfolio analysis have to be adjusted for firm delistings. The CRSP database maintains a monthly delisting file (msedelist) with ...
1
vote
1answer
50 views

What preprint repositories are available online?

Besides data sources, what preprint archives are available for academics and practitioners in the fields of Quantitative Finance and Economics? I have subscribed Google Scholar alerts and regularly ...
2
votes
1answer
89 views

Volume or Dollar bars vs. volatility normalized and demeaned financial time series

In his book - Advances in Financial Machine Learning, Marcos Lopez de Prado familiarises the reader with a number of ways of normalizing our financial time series data. Below I provide a couple of ...
0
votes
0answers
40 views

Best database source to download large number of stock prices [duplicate]

I am wondering what databases exists where I can download stock prices from 2006 to today with the following features 1) using Python API 2) using Bloomberg tickers (e.g. AAPL US Equity) 3) free ...
0
votes
1answer
55 views

Mean Variance optimization on hourly data with gaps

I'm building a mean variance optimizer for a portfolio of FX, commodity and bond futures. The input data is hourly returns for each underlying. Given each underlying has different market opening hours,...
0
votes
0answers
30 views

Data request: Option prices for a liquid index/stock

Currently doing a course project on option pricing as a part of my undergraduate studies. However I cannot find a free dataset $D=[d_1,d_2,...,d_N]$, which would represent a time-serie of daily option ...
1
vote
2answers
79 views

Datasource of all scheduled news events for S&P 500 stocks

I am looking for a datasource which contains all news events specific to equities of the S&P 500, whose release date was scheduled in advance. That is, I am not looking for surprise news. For ...
1
vote
1answer
93 views

Loan Level Data for Residential Mortgage Backed Securities

I'm looking for loan level detail for Residential Mortgage Backed Securities. The SEC requires that form ABS-EE (individual level asset data) be filed for all offerings backed by residential ...
1
vote
1answer
152 views

Are Kenneth French Research Returns log-Returns?

Does anyone know if Kenneth French's return data on his website is log returns?
0
votes
2answers
72 views

Imputation of missing returns

I'm trying to calculate a historical VaR for a portfolio of futures, however there are certain days for which some assets are missing prices. Since the portfolio consists of many spread positions, the ...
0
votes
1answer
183 views

Bloomberg's Open Market Data Initiative

I am reading about OMDI: https://www.bloomberg.com/company/announcements/bloomberg-opens-its-data-distribution-technology/ After reading that, I am still not sure: Is it free? If so, what kind of ...
0
votes
0answers
23 views

Collateralized Bond Obligations History

Collateralized Bond Obligations (CBOs) were a form of CDOs that were more popular in the early 2000s. I am looking for: Historical loss rates on their tranches (if available) Whether historically any ...
0
votes
0answers
90 views

Credit Default Swap transaction data

I'm looking for historical transaction data for (OTC) Credit Default Swaps. One option is to take a look on DTCC Data: http://www.dtcc.com/repository-otc-data.aspx Are there other options to get the ...
0
votes
1answer
38 views

Kenneth Frenches Data library return data to price data?

I have downloaded the industry portfolios from Kenneth Frenches data library, I am wondering if anyone knows where I can find the price data? Can I convert it even if I don't have a starting value? ...
3
votes
1answer
70 views

How to obtain data for Benford's Law analysis?

First off, let me be specific as to what I mean by "Benford's Law analysis": I'm looking to test, given some data, if the set of first significant digits are independent, identically distributed ...
1
vote
1answer
73 views

Simulating trading strategies

I want to simulate real time trading strategies. For simplicity, let's say I only want to simulate a long-only portfolio on S&P500. I have a couple of questions: Is there a place online where ...
0
votes
1answer
329 views

How to deal with missing value in a time series stock market data?

I have collected data for the period of 2002 to 2018 for following indices Nifty (India), NASDAQ (US), ADX (UAE) and TASI (Saudi Arabia). After collection, I have arranged data in a single sheet with ...
1
vote
5answers
495 views

10 years intraday for a single stock

For a personal experiment I need to acquire 10 years worth of data (with time resolution hourly at least) for a single stock. It doesn't really matter which stock, and the data doesn't need to be very ...
1
vote
0answers
26 views

Identifying primary share class of U.S. firms and deleting excess observations

I have a fairly large dataset of CRSP firms with their daily closing prices from 2006 till 2017. I need to filter the data so that I have one daily observation per unique firm. I've identified the ...
2
votes
2answers
112 views

How do I calculate bad debt on revolving credit?

I have a revolving credit system. A customer purchases and then has 6 months to pay off the purchase. i.e. Purchase for 60 in Jan and then need to pay 10 a month in Feb, Mar, Apr, May, Jun, Jul. The ...
2
votes
1answer
70 views

Downloading historical data of “Financial Account Data”

I would like to know how to download historical data from www.federalreserve.gov/apps/fof/FOFTables.aspx Please advise.
1
vote
1answer
546 views

Automatically get iShares ETF holdings

I heard that ETF's must publicly report their holdings all the time. I have seen that for example on the iShares website I can download the list of holdings as a csv file: https://www.ishares.com/us/...
0
votes
0answers
33 views

Bond Data on UK corporate

I have got data from FRED on Moody's Seasoned Aaa Corporate Bond Yield. Does anyone know where I can get such UK data on this? If not, would using exchange rates and the interest rate parity theorem ...
2
votes
2answers
328 views

Classifying stocks by industry (free)

Is there anyway to get the stock symbols of an exchange classified by industry? For example: AMD-semiconductor The best I could find was this page: https://money.cnn.com/data/sectors/tech/electronic/...
2
votes
0answers
22 views

Mapping international firms in I/B/E/S to Compustat

Follow up to my previous question on how to map I/B/E/S to Compustat. A big chunk of firms in both Compustat and I/B/E/S failed to map via CRSP for me. After some investigation, I noticed that they ...
0
votes
1answer
64 views

Subset selection to identify independent variables that impact the market?

Given a lot of market-related features (~100 independent variables such as emerging market, developed market, s&p 500, tech sector returns, etc), I need to select a subset of them that are ideally ...
3
votes
1answer
298 views

how to treat NA values in Compustat and CRSP

In some years, some accounting values of some companies are missing in Compustat and CRSP. How do I treat those missing values ? Should I replace those with zeros or just simply delete years in which ...
3
votes
1answer
143 views

Data sources for historical Eurex settlement option prices

I am looking for long history for historical settlement option prices at EUREX. This seems to be more challenge than I could imagine. Eurex themselves doesn't offer that data unfortunately (they only ...
1
vote
2answers
131 views

How to test the CAPM empirically and how do I use this Kenneth French dataset?

I'd like to test whether CAPM holds. My guess is that I first need to find a market portfolio. Then, over some period, I calculate its excess return $R_M - r_f$. Then I calculate the return of some ...
1
vote
0answers
30 views

amount of data - option pricer calibration

A practical question. When you calibrate an option pricer (whatever the model is), do you use data from several days or just one day (last trading day)? I noted some papers use data from one single ...
2
votes
2answers
605 views

Mapping I/B/E/S to Compustat via 6-digit CUSIP

I am trying to link Thomson Reuter's I/B/E/S dataset with Compustat. Both I obtained via WRDS. The only halfway useful info I could find was on a two year old forum post, which suggests to go through ...
1
vote
0answers
43 views

How to handle database updates for splits/dividends?

I'm finding it an difficult task to maintain a database of stock prices. My main problem is how to efficiently handle splits and dividends. Is it better to handle this in a database with adjusted ...
0
votes
3answers
400 views

Appropriate way to normalize Bollinger Bands?

I am playing around with using neural nets to make predictions on market trends. I am currently feeding in a portfolio of historical data of many stocks, and am now implementing several technical ...
2
votes
1answer
895 views

Real-time limit order book data of desired depth

Is it possible to get real-time NASDAQ limit order book data feed somewhere? I would need a stream of the limit order book data, preferably something similar to: Along with the respective events ...
1
vote
1answer
99 views

Dividend Yield Goyal and Welch (2008)

Following the Goyal and Welch (2008) stock return predictability data, does anyone know how they calculate the dividend yield from the dataset that they provide on Amit Goyals website http://www.hec....
0
votes
1answer
116 views

Where can I find historical data for Europe listed ETFs?

I'm currently working on building a portfolio optimization tool for European ETFs such as: (SYMBOL/ISIN/description) IQQF / IE00B0M63730 / iShares MSCI AC Far East ex-Japan UCITS ETF EXW1 / ...
0
votes
1answer
140 views

(Self studying) Finding data on Bloomberg

I apologize for asking this very simple question, but I was reading through this chart for the first time, and I would like to know where on Bloomberg can I find data like these, since I have to price ...
0
votes
1answer
241 views

Download bond yields R

I need to download bonds yields using R. I tried, as usual, I did for stocks: spc <- new.env() setDefaults(getSymbols,src="FRED") getSymbols("^AT0000386198", env = spc, from = "2010-01-01", to =...
7
votes
2answers
894 views

Why don't data sources use ISIN instead of symbol?

I've been messing around with stock data off and on for a year or two and just recently found out about the ISIN. Up until I found some data from Siblis Research, none of the other data sources used ...
1
vote
0answers
38 views

Transform 24hr cumulative volume to sampled periods

I have a Python Dataframe with cryptocurrency data that has three columns: time, 24hr volume and price. The time is the time at which the data was received from the exchange, price is the last price ...
1
vote
0answers
125 views

Any databases with CEO letters and shareholder letters?

I am researching disclosures on CEO letters and Shareholder letters present in annual reports of listed companies in the London Stock Exchange. Can someone recommend a database where the annual ...
4
votes
2answers
357 views

Retrieval of MSCI factor index performance data from the web

I hope this question is on-topic. What is a convenient way to get MSCI index performance data from the web? I would be interested in daily performance data of the factor indices momentum, minvol, ...