Questions tagged [historical-data]
The historical-data tag has no usage guidance.
304
questions
0
votes
0answers
20 views
Best stock market data streaming API that covers Foreign exchanges, Tadawul (Saudi Arabia) and Dubai Financial Market (UAE)?
I am just getting started with stock markets data streaming APIs. I would like to gain from your experiences with the different APIs out there to help choose the most suitable service provider for me, ...
0
votes
0answers
31 views
How to calculate price and volume samples of a multi-product series?
I am reading Marcos de Prado's Advances in Financial Machine Learning. In a section titled "the ETF Trick", he explains how to calculate periodic price and volume samples for a basket of ...
0
votes
1answer
49 views
YFinance incoherent daily and hourly values
I'm comparing daily and hourly values extracted from YFinance in Python.
I'm expecting the open value of the first hour of the market to be equal to the daily open value of the corresponding day, and ...
0
votes
0answers
20 views
How minutely volume data is summarized from the actual transactions?
import yfinance as yf
data = yf.Ticker('CFLT').history(interval='1m', start='2021-07-09', end='2021-07-10')
Using the above python3 code, I can get the minutely ...
1
vote
0answers
50 views
Seeking historical market cap for S&P 500 by sector
I'd like to obtain the historical market capitalization for the S&P 500. I'm seeking monthly data back to 1945. I'd like to examine only non-financial stocks, so the sector would be needed as well....
10
votes
1answer
755 views
What's the most efficient way to store options and time series data for backtesting?
I would like to know what database would you guys use for storing around 500GB-1TB of options and time series tick data.
The idea is to use it for backtesting so it would have to be as efficient as ...
1
vote
0answers
59 views
What should be the minimum length of historical data used for analysis?
What should be the minimal length of historical data to do "practical" portfolio analysis to achieve "sane" results?
There are several questions here on what should be done when a ...
0
votes
0answers
46 views
Historical component changes of EURO STOXX or STOXX Europe 600 index
I would like to download the historical component changes of EURO STOXX or STOXX Europe 600 index to conduct an academic research. That is, I would like to know the historical changes to the ...
0
votes
2answers
128 views
Where can I find complete historical lists of companies on major US exchanges for backtesting?
I am backtesting a trading strategy on historical US stock data. I'm currently sourcing data from S&P's Capital IQ. I have no trouble getting stock price data for a specific company. I also have ...
1
vote
1answer
40 views
Historical data for 3 month and 6 month lows for NYSE or Nasdaq
I'm trying to find the historical data for 3 month or 6 month lows.
Thinkorswim has it (NYLO3M) and barcharts.com has it (M3LN) but they don't match...and thinkorswim only goes back to 2012.
Does ...
1
vote
2answers
53 views
Find current and historic (15 years) delistings in the US stock market
I wonder if there is any source for the following information concerning stock delistings in the US stock market:
date and stock symbol of the delisting (required)
covers at least 15 years history (...
0
votes
0answers
26 views
Perfect in-sample size for out-sampling volatility prediction (EGARCH(1,1)
I have a few questions regarding in-sample size for volatility forecasting in EGARCH(1,1). I'm currently sitting with a dataset consisting of 1387 trading days of the S&P-500 index. I would like ...
0
votes
1answer
70 views
Algorithm / source to calculate historical expiry dates of futures
I can find several source on this site where to find expiry dates of coming futures contracts.
I am looking for a (e.g. Python) algorithm or a data source where I can find historical dates when a ...
2
votes
2answers
75 views
Deciding (p,q) in garch and model test on empirical data
I'm currently working on a dataset containing data from the 29 January till the 29 July 2009. In the dataset I have prices of the S&P 500 index for all days. Furthermore, I have the implied ...
0
votes
0answers
33 views
Question about the coverage of Datastream compared to WorldScope regarding US data
Thomson Reuters Datastream is claimed as a very comprehensive data source. I did some comparisons and also conducted research myself and cast doubt on that, especially for US data.
I used the paper of ...
0
votes
0answers
26 views
Adjusted close time series: Frequency of historical updates
When working with stock market data for strategy / analysis purposes, I am well aware that I have to distinguish between unadjusted and adjusted prices.
I understand that historical adjusted prices ...
0
votes
0answers
37 views
Where to find Historical price data (csv preferable) for global Gov bonds and markets. All dollar denominated?
I'm doing a lengthy backtest on a certain portfolio and i've managed to get FTSE 100 data going back to 05-30-1990, where could I find data for global Government bonds going back to that date?
A csv ...
0
votes
1answer
217 views
Bloomberg python API - intraday tick/bar request for options?
Is it possible to request intraday tick/bar data for a particular option (e.g. AMC 4/30 10c @ $0.91) with the python bloomberg BLPAPI? I've managed to do pull intraday tick data (with ...
0
votes
0answers
21 views
Where can I find historic company fundamental data forecasts?
There's seems to be many sources (these questions have a nice answers/summaries historic fundamentals
data sources ) having company historic fundamentals such as earnings, PE etc.
However, there's a ...
0
votes
3answers
113 views
Historical Ticker Symbols Data Source (for Creating Tradable Universe)
I would've guessed this question would have been answered somewhere on here before, but I have been going down rabbit holes for days trying to figure it out with no luck...
I want to backtest ...
0
votes
0answers
30 views
Scale price and returns
Through Bloomberg I have downloaded some data related to the Bloomberg Euro Aggregate Bond Index, however I think I am wrong. I was convinced to have taken the historical prices of the index (in ...
2
votes
0answers
60 views
Are there any APIs to retrieve stock buybacks and dividends to calculate ERP?
I'm in the process of building a Python library to value stocks using a FCF model and one of the first steps is calculating an implied equity premium. I know there a few ways of doing this, but ...
2
votes
1answer
55 views
What are the eurozone bond indices? And where can I find them?
I am trying to calculate the performance of a portfolio of fixed-income funds domiciled and operating exclusively in Europe through a multi-factor model. To do this I need historical data of several ...
0
votes
0answers
19 views
As reported financial statements historical data [duplicate]
May I request for suggestions on data vendors for historical as reported fundamental data? For example as reported eps, as reported revenue, as reported depreciation and amortization expenses?
I tried ...
0
votes
1answer
50 views
How do I get European tick size or historical intraday opening and closing prices?
I'm looking for each European stock, the tick size.
Given that obtaining this information directly is difficult (I don't think that databases, even the ones for academic purposes provides this ...
0
votes
0answers
66 views
I require help to find a good data source for my thesis
I require help to find a good data source for my master thesis.
I am doing a regression analysis for macroeconomic indicators and valuation multiples, for eurozone stocks.
I need quarterly information ...
0
votes
1answer
37 views
should I persist the daily/weekly bar data
Suppose a small quant group (4 guys) and the tick data is in hand, shall they persist the historical daily/weekly or even smaller scale like hourly/minutes bars data, or just do the on-demand ...
0
votes
2answers
187 views
Storing options EOD time series in Flat Files
I have purchased data for EOD settlements of options prices for USA futures for personal use. I will not need multiple user access or real time access. I am not an expert programmer but use C# and R ...
1
vote
1answer
191 views
Historical intraday dataset with penny stocks with a gap-up of 10% or above
I am trying to find intraday datasets of pennystocks. My criteria for the dataset is that it needs to only contain pennystocks where the gap-up was 10% or above.
I am looking for a free option but ...
1
vote
2answers
135 views
Recreating Bid-Ask from Transactions data
A database only has transactions/trades for a given instrument.
In order to recreate bid-ask of the instrument to estimate the average bid-ask spread, what process does one need to follow?
what are ...
0
votes
0answers
54 views
Modeling electricity prices ($/kWh) for Simulation
I want to run a Simulation in Matlab that involves the running costs of an electronic device which consists of the power consumption of this said device. The simulation should run for the next 1-5 ...
1
vote
0answers
62 views
Historical data on valuations for internet companies during dot-com bubble
I am looking for data on historical valuations for internet companies during the years of the dot-com bubble (2000 - 2002). I know that big auditors have or at least have access to such data on ...
1
vote
1answer
155 views
Historical Constituents S&P 500
In order to backtest a few strategies I'm searching for a (free) csv/excel file of tickers included in the s&p 500 during specified years (say, 1970).
Do you happen to know where I can find ...
0
votes
0answers
37 views
Help getting 1-min historical data (suds object) from BarChart into Pandas Dataframe
I've been searching around and haven't found what seems like an easy task to get historical data from the BarChart API into a Pandas dataframe with the index set as the time stamp. Here's a few ...
1
vote
0answers
56 views
Yahoo finance forex prices
Good morning, I apologize for my poor english, I'm not an expert and I need your help...
do you know how daily prices are calculated on Yahoo Finance Historical data?
Let me give you an example, if ...
0
votes
0answers
63 views
Calculate VaR using method of historical simulation
A bank invests € $1.000.000$ in a hedge fund. The last 500 daily returns can be taken from a database. The worst 20 returns are
-4.58 -2.95 -2.95 -2.93 -2.17 -2.08 -2.06 -1.98 -1.94 -...
0
votes
1answer
118 views
Covariance matrix for historical series w/ different start and end dates
I am trying to compute the variance-covariance matrix of my portfolio composed by some shares of different companies. I would select a time horizon of two years but for some shares of one company I ...
0
votes
0answers
21 views
Availability of historical data on variance swaps [duplicate]
I want to do research on variance swaps. Where can I get/buy historical data (other than Markit)?
0
votes
1answer
265 views
What is the formula for calculating adjusted closing price after a rights issue?
I know how to calculate adjusted closing prices in case of splits, dividends, etc but I'm not able to figure out how it's done in case of a rights issue.
2
votes
2answers
73 views
List of public US (NYSE, Nasdaq) companies that filed for bankruptcy in the last 10 years
I am working on a Data Science project on bankruptcy prediction. I am looking for a list of listed US companies that filed for bankruptcy in the last 10 years but I am really struggling to find any ...
0
votes
2answers
61 views
How to get commodity futures settlement timepoints?
I need to find some easy approach to get the daily settlement times (not the exact milisecond, just the general rule hh:mm) for multiple commodity futures (agriculture, metals, energy) on multiple ...
1
vote
0answers
112 views
How to merge Trade ticks with Bid_Ask ticks from IB API reqHistoricalTicks, like the Time&Sales window?
reqHistoricalTicks returns data with 1 second precision, so only looking at timestamp is not enough to merge them. But it seems that the Time&Sales window in ...
1
vote
3answers
96 views
SEC Rule 611 Trade Through (OHLC Data Distortions) - with visual example
Has anyone ever quantified or understand the impact of distortions to the High/Low of the day based on SEC Rule 611 pass through trades? These are trades that happen outside NBBO (national best bid ...
0
votes
3answers
457 views
Implied Volatility - Historical data
I'm wondering if there's a place where I can find free or very cheap historical implied volatility data. Specifically, I'm looking to get at least a few years' worth of daily IV data for maybe a few ...
2
votes
2answers
270 views
How to calculate monthly returns in R for every company in a dataset of 4000 companies?
I want to calculate monthly returns for a time series of 4000 companies between 2014 and 2019.
This is how my dataset looks like
I'm using the following code to calculate the returns
nyseamex <- ...
0
votes
0answers
35 views
Is there no fix to improving portfolio risk estimation under small sample size?
When asked if copula are needed to calculate portfolio Value-at-Risk, it is said that "You can use historical method if you have sufficiently enough data". But actually copula are also ...
0
votes
2answers
95 views
Implied volatility data
I am looking for historical implied volatility data, and I see that QUANDL has this data from two sources - ORATS and Quantcha. I was wondering if people have any views on which data is higher quality ...
1
vote
2answers
63 views
Is there an API for retrieving up-to-date intraday 1 minute bar data by Date AND Time ranges?
I'm looking for an API that has an endpoint for fetching 1min bar data by Time in at least a minute of precision as opposed to just by date.
0
votes
0answers
135 views
How to download stock time series for multiple companies in Eikon?
I want to download several historical stock price histories from Eikon at once.
This is the stock data of several hundred companies. Therefore, it is far too time-consuming for me to download them all ...
0
votes
1answer
87 views
How to up-sample monthly returns into daily returns?
I know how to down-sample daily returns (large-sample data) to monthly returns (small-sample data) by using rolling windows, which feels like estimating a sub-sample from the population (something ...
