Questions tagged [data]

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

Filter by
Sorted by
Tagged with
3
votes
1answer
42 views

Aggregating quotes data for different time frames

I need to aggregate data for a higher time frame. I have data for 1 min time frame as follows ...
0
votes
0answers
37 views

Historical data for total market capitalization

I'm working on a data analytics certificate and need historical data on the total market capitalization for the US for a course project. Can anyone suggest a source? Thanks!
2
votes
4answers
359 views

Px last in Bloomberg

This is my first post to this forum. I want to calculate security returns , so therefore, I have downloaded the PX last price from Bloomberg. My question is: What is PX last in Bloomberg? Is this ...
1
vote
1answer
43 views

S&P 500 dividend data [closed]

I could not find S&P 500 dividend data on S&P 500 official site. Does anybody know where to find it?
3
votes
0answers
52 views

Identifying the same company behind stocks traded in different exchanges (e.g. CUSIP and WKN in 1990ies)

I would like to merge two data sources with companies headquartered in Germany between 1980-2000, but listed in Germany and the US. One source identifies "German companies" by their CUSIP, the other ...
1
vote
1answer
45 views

EONIA capitalisé jour tr eur: can't find index data! Do you know what kind of index is?

To get EONIA capitalisé jour tr eur index returns (monthly returns from 01/2007 until the most recent) is challenging. First i googled the index name searching for the ISIN or the index provider ...
2
votes
2answers
71 views

How does duplicate data affect backtesting?

Before developing a trading strategy, one should clean and preprocess his data set. It is very common that a data set contains huge number of duplicates. Question: How does duplicate data affect ...
1
vote
1answer
75 views

Availability of GC Repo Rates for Different Maturities

I am trying to replicate a Covered Interest Rate Parity arbitrage trade using General Collateral Repo rates for my Bachelor Thesis. My problem is that I do not have the necessary knowledge of what ...
1
vote
1answer
31 views

Why files in this SEC filing is not downloadable?

Quarterly report for MC Donalds has list of documents but there's no way to download it. It has only one text file available for the download. How the other documents could be downloaded, like the "...
4
votes
0answers
82 views

Anyone know if this daily report discontinue to publish? Goldman Sachs - “Global Index Volatility and Correlation Monitor”

I used to receive this daily report in my workplace from Goldman Sachs mailing list but the mailing list discontinued in May 2019 without any notice. The report is an pdf attachment which send from "...
1
vote
1answer
77 views

What methods of Data-Screening are necessary before starting an analysis with Thomson Reuters Datastream?

So im currently focussing my research on Momentum-Trading Strategies. I downloaded Constitutents of different All Share indices (including Price, Return index, Market value and Dividend Yield). For ...
0
votes
0answers
27 views

Tickers of companies included in Euro Stoxx 600

I'm trying to analyze the historical data of the individual companies that are part of the Euro Stoxx 600 index. For that, I am using a Python code that needs the tickers of the companies. Due to my ...
0
votes
0answers
38 views

Why do these Monthly vs. daily plots differ?

I got my data from Thomson Reuters Datastream. As an Input for my plot i calculated daily Returns based on the Return-Index provided by datastream. Then i plotted the Monthly and the daily Returns.(...
2
votes
1answer
44 views

Pull IDX stocks with alphavantage?

How do I pull data for stocks on the indonesian stock exchange (https://www.idx.co.id/en-us/market-data/stocks-data/list-of-stocks/) with alphavantage? What is the symbol I should pass? I've tried for ...
0
votes
0answers
30 views

Is there an official way to access all SICs code for a huge list of CIKs code from Edgar?

after reading this https://opendata.stackexchange.com/questions/857/is-there-a-resource-to-look-up-the-standard-industrial-classification-codes-that I realized that the CIK-to-SIC mapping list is not ...
0
votes
0answers
26 views

Data Vendors for Equity Risk Premium, Risk Free Rate and Equity Index Price [duplicate]

I've been searching to see if there are vendors that could provide datasets for these 3 categories. Any recommendations? Thanks
1
vote
1answer
144 views

Using AlphaVantage For Japan/Shanghai/Hong Kong/Shenzhen stock exchange data?

Can I use AlphaVantage to pull data from Asian stock markets? I've been able to do it for others such as the London stock exchange, India stock exchange, Australian stock exchange etc. but haven't got ...
0
votes
0answers
28 views

high quality daily data [duplicate]

I am analysing some trading strategies, so lots of high quality data is needed. I have been using yahoo finance which provides a lot of high quality daily data on stocks and indices. Currently I am ...
0
votes
1answer
50 views

Estimating monthly GDP growth based on quarterly data

Apologies for this newbie question. Given the following quarterly GDP growth: ...
0
votes
0answers
49 views

How to work with vine copula in R?

I have returns of 4 stocks: stock1, stock2, stock3, stock4. And I use R and library(VineCopula) to do: ...
0
votes
0answers
52 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
54 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 ...
2
votes
1answer
50 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 ...
2
votes
2answers
84 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
23 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 ...
2
votes
1answer
80 views

Efficient computing of stock returns taking dividends into account

I have two DataFrames as follows: Dividends: ...
0
votes
0answers
22 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
118 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
101 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
53 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 ...
5
votes
1answer
261 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
41 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
56 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
35 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
81 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
179 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
231 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
91 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
250 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
25 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
1answer
39 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
78 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 ...
0
votes
4answers
211 views

Filling a few missing data in time series?

I'm writing a paper about Uncertainty indices like VIX, etc. I already collected all data but it seems that some of the variables got a few or a little more missing data. I have daily and monthly data ...
1
vote
1answer
80 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
572 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
899 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
71 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.
2
votes
1answer
825 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/...