Questions tagged [historical-data]
The historical-data tag has no usage guidance.
273
questions
0
votes
0answers
36 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
45 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
20 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
64 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
46 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
42 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
22 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
2answers
44 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
92 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
103 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
33 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
81 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
54 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
27 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
80 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 ...
1
vote
1answer
43 views
Any database with all of companies previous CEO's?
I'm doing some research on CEO's and company chairmen and I'm looking for a database that contains this data for all the public US companies. The data needs dates associated with the names as well. I'...
0
votes
1answer
47 views
I have missing data on my portfolio weightings but it can be solved through stock prices - how can I code to find this? [closed]
firstly I would like to say sorry for the title - its not the best. In fact its crap.
Here is my problem (I am new to coding btw - still learning)
I am using Python on my MacBook - using Terminal.
I ...
0
votes
0answers
28 views
Obtain order level data for German stocks
in the context of my dissertation I am working on high frequency trading and would like to investigate its effects on the German stock market. For this purpose I will need the order activities of a ...
1
vote
1answer
74 views
where to find historical ticker data for securities no longer in s&p 500 index?
im looking for the complete intraday ticker data time-series for a number of securities that formerly were part of the s&p 500 index. eg.
PGN, Progress Energy Inc, removed from index 2012 because: ...
0
votes
1answer
89 views
How important is the chronological ordering of historical returns?
The returns of asset $A$ in chronological order are
0.03
0.01
-0.04
0.02
0.05
-0.10
0.02
The expected return, or sample mean, is $-0.00143$ while its sample ...
0
votes
0answers
32 views
Using a rolling mean or median to fill missing values
I have some 1-minute bar data. The first datapoint has time t0 and the last one t1. 99.5% of the data between the first timestamp and the last timestamp is there and 0.5% is missing (NaN values). I ...
0
votes
2answers
33 views
Daily US stock price data provider with opening Auction prices
I'm looking for a data provider with historical open auction prices (i.e. not opening trade as found on most providers) for SP500 stocks. This is the price obtained by a MOO order.
Thanks.
0
votes
0answers
18 views
Discrepancy for apple insider trades between Yahoo finance and other sources
https://finance.yahoo.com/quote/AAPL/insider-transactions/
https://www.marketbeat.com/stocks/NASDAQ/AAPL/insider-trades/
Yahoo says there is insider net buying over the past 12 months.
Other sources ...
0
votes
1answer
56 views
Working with 1 minute bar returns - do I throw out the first return of the day?
I am doing some academic work and using 1 minute bar data. I am wondering if when calculating the return time series, do I need to throw out the first return of the day because it is the return ...
2
votes
1answer
158 views
Is it always better to use the entire distribution of a financial returns series, not just $\mu$ and $\sigma$?
In finance models that use historical returns for inputs, including option pricing models, forecasting and portfolio optimization, only the statistical moments of the returns distribution, $\mu$ and $\...
1
vote
1answer
59 views
How to download full daily historical data of MSCI AC Asia Index
I'm trying to download the daily historical data of the MSCI AC Asia Index. I've been testing different combinations of the following url: https://www.msci.com/eqb/esg/performance/110.0.all.html using ...
0
votes
2answers
57 views
Portfolio rebalance - How many data back do I need to perform sharpe ratio optimization
if I do a periodical rebalance of my portfolio based on sharpe ratio optimization, how many historical data should I take in account for optimizing with respect to the frequency of rebalancing?
For ...
1
vote
0answers
112 views
Did AlphaVantage drop the swedish stock exchange?
I have used AlphaVantage in the past to get data for the Stockholm Stock Exchange: I don't remember exactly the symbol I used, but it was something along the line of OMX:ABB or STO:ABB (for, say, ABB)....
0
votes
0answers
17 views
How can I obtain old Form 10-K filings?
I am trying to find old filings of Form 10-K. I am looking for some filings from the 1950s, 1960s and 1970s (i.e. filings in the era before the existence of EDGAR). Where can I get them? Are the ...
0
votes
2answers
80 views
Historical SPX Intraday data with volume
I am looking for historical SPX 1minute data containing volume.
Anyone knows where to get them from?
Thank you,
0
votes
0answers
30 views
Master thesis concerning DAX ETFs
I am currently trying to develop a thesis proposal related to the DAX German index or more precisely DAX ETFs however i am struggling with finding data regarding DAX ETFs, what i wanted to know is, if ...
1
vote
1answer
142 views
Backtesting with Level 2 depth of book
I'm new to automated trading. I'm in the process of coding the methodology I've been using manually for a few weeks into a quantitative algorithm using IBKR and Python.
I read everywhere I should ...
0
votes
2answers
86 views
Wha't the best place to grab historical sophisticated data about stocks?
I am looking for an API which allow me to grab a data about companies & their stocks in the historical perspective. Like not only prices, but let's say balance sheets & cashflow statements ...
4
votes
2answers
147 views
How to make a trading universe of liquid futures contracts
I am forming a universe of liquid futures/liquid FX forwards. I want a list of all liquid contracts, the key word being liquid. This is for an academic project, but you could imagine liquid being ...
0
votes
1answer
68 views
Download historical index data, like SP500, using Python. History going back to at least 1960, if not further back
I want to download historical data for different indices. I am using Python for this. I used the following code.
...
1
vote
1answer
62 views
Historical energy market data for European power Futures and Options?
I have been trying hard to find some historical futures and options electricity data for EEX offerings. I need the data for a model I am writing, however I have not found any free resources so far. It ...
0
votes
0answers
178 views
Download historical MSCI/GICS Sector Index data
Similar to Where do I get historic performance data of the MSCI World Growth/Value index, I'm looking for historical data for the MSCI Sector Indexes (Energy, Material, Industrials, Financials and so ...
1
vote
1answer
123 views
Historical S&P 500 OPTION data on WRDS, no access to Option Metrics
I'm looking for historical data of S&P500 options. I have access to Wharton Research Data Services (WRDS), however, my university does not provide access to Option Metrics. Is there another way ...
0
votes
0answers
33 views
Where to retrieve financial data? [duplicate]
I am struggeling finding an updated list of free sources for historical financial data. My main interest is for intraday european stock markets data and companies' fundamentals data, but it would be ...
0
votes
0answers
49 views
How are the return values in BatchGetSymbols calculated?
I have retrieved price data of SP500 stocks using BatchGetSymbols library.
When I view the dataframe I see there are calculated return columns in the dataframe as seen in the following picture:
...
0
votes
0answers
35 views
What is the difference between quotes and candles?
Actually I have a software development task to develop a little web app that could analyze some liquid stocks quotes considering OHLC values.
So I'm researching some OpenAPI where I have found a ...
0
votes
0answers
31 views
Free resource to pull historical market cap data in Python? [duplicate]
I am trying to replicate the Russell 1000 with the top 25 stocks using a capitalization weighted method. I can pull historical price data from pandas(yahoo or quandl) with no problems. I need to pull ...
1
vote
1answer
129 views
Is there an API that can return the current market cap of a publicly-traded company?
I am trying to find an API which will return the current market cap of US stocks for a financial data visualization project, and I haven't had much luck finding anything. Preferably, I'd like to have ...
0
votes
2answers
166 views
Where to get historical price and fundamental data for global equities?
I'm looking for reliable research data on global equity fundamentals, but I'm not sure which vendor provides these (and preferably only these) features:
Programmatic access of data.
Coverage of ...
3
votes
1answer
69 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
...
1
vote
1answer
152 views
Interest Rate Swap curve: CMS vs. OIS?
I'm working on a project where we're trying to create a database model where we can (daily) update collected data in order to make RPA predictions.
We received data from Interest Rate Curves called ...
3
votes
1answer
132 views
time series data modeling for deep learning
what is the best format to feed the input data, which are time series with varying density over time, to a deep learning network, while at any iteration we want to feed a batch of data including a ...
1
vote
1answer
101 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?
1
vote
0answers
49 views
Permanent stock referencer
I am building a data set of stock market data and was wondering how (what algorithm) to use (internally) to assign a key to each stock so that they key will remain the same always (tickers change and ...
5
votes
2answers
247 views
Missing data in historical simulation VaR
A historical simulation approach to VaR estimation relies on the availability of historical data. What do we do when there is no data (say, spot price and implied volatility surface) as, for example, ...
