Questions tagged [market-data]

Market-data includes all questions relative to data acquisition for the different financial products. It can also include questions about how market data are computed.

Filter by
Sorted by
Tagged with
0
votes
0answers
34 views

Options Exchanges vs Equity Exchanges

I appreciate help in understanding difference between Options exchanges and Equities exchanges, and the domain language used. Per The Options Clearing Corporation (OCC), I see they have exchanges ...
2
votes
0answers
57 views

How to identify active vs inactive ISINs?

Background I understand that through the work of ANNA and GLEIF, the relationships between ISINs and their respective LEI (Legal Entity Identifier) are now more accessible. GLEIF API Lookup To lookup ...
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
0answers
37 views

Source for Intraday or High-frequency stock price data

I am in search for intraday (some observations per day would be fine) or high-frequency data for stock prices. I have for example 3.000 ISIN numbers of German companies and want to get the intraday/...
0
votes
0answers
32 views

Algorithm: from bid-ask data to footprint

I want to write a little program that will display me a footprint in real time Basically I have the following data: ...
10
votes
1answer
754 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 ...
0
votes
0answers
23 views

How to handle negative income tax when calculating EBIT

I am using the formula (Net income + interest expense + tax expense) to get my calculation What happens if the Income tax expense is negative for that year do you still add that negative number or do ...
0
votes
0answers
27 views

How to calculate NOPAT if the effective tax rate is 0 or negative

I am trying to calculate NOPAT for L S STARRETT CO. The effive tax rate I calculated for 2020 was -0.09% Operating Income was -5.3 mill. Using the NOPAT formula Operating Profit * (1 - tax rate) I got ...
0
votes
2answers
83 views

Determine market and ice-berg order types from live trade and quote data

I have tick and quote live data from Polygon and Interactive Brokers. Looking at the conditions I can't see info on market or iceberg orders: https://polygon.io/docs/...
0
votes
1answer
60 views

Sources for historical financial ratios?

I wanted to know if there are any sources for historical financial ratios for Indian equities? If yes please share. Thank you.
0
votes
0answers
38 views

Delta hedge analysis - volatility rapidly growing

I'm working with a hedge expirement design, where I daily hedge with EGARCH(1,1) forecasted volatilty based on a moving evaluation of the past 126 days. However, I can't seem to understand the profit ...
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 ...
2
votes
0answers
29 views

Empircal data analysis delta hedge error of Black-Scholes by Mark Davis

Regarding Mark Davis derivation of the delta-hedging error occuring in the black-scholes as a result of difference in realized volatility and implied volatily. The formula reads as follows: $$ Z_t = \...
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
35 views

Realized volatility calculations from real dataset

I am working with a dataset from: http://web.math.ku.dk/~rolf/Svend/ named data 1. I'm currently setting up a delta hedge for periods of 3 months. So currently we are starting at the start data of the ...
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
1answer
76 views

How could I identify peers of companies (stocks) at scale?

Context: I'm making a small script to screen through thousands of companies at scale. A feature that I want to include would be relative metrics, e.g. is this company growing faster than its peers, ...
0
votes
1answer
213 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
31 views

Commercially redistributable derivative market data source

Is there any derivatives market data source that gives permisson to use this data in a financial model and then sell a product with it? (derivatives valuation for example) I'm looking for a cheap ...
2
votes
4answers
319 views

Alternatives to Zipline backtester / Alternatives to futures data from Quandl

I intend to set up a fully automated system for trading equities and futures. As preparation for this project, I worked through a couple of books on the topic, e.g., "Trading Evolved" by ...
0
votes
0answers
20 views

Can an ISIN have a mixed issuance?

In principle, an ISIN is issued by one entity (which can, of course, issue multiple ISINs). However, can an ISIN have a mixed issuance?
2
votes
2answers
414 views

What are the proper ways to do order book downsampling?

I have an access to the order book dataset, which was sampled with resolution that is too high for my sandbox experiments with it. Because of that, I was wondering, what would be the correct way to ...
0
votes
1answer
32 views

Why do 1min intraday price histories from AlphaVantage have different sample counts?

I've downloaded intraday price histories from alphavantage for a dozen or so symbols, with the same parameters (1 minute interval) for each. Presumably this data represents prices in one minute ...
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
0answers
27 views

Rounding errors in EOD prices in Yahoo finance

AAPL closing price in the CSV export file is 130.839996 whereas the web interface shows 130.84. Is it safe to assume that the Yahoo EOD database stores prices as floats hence the rounding errors? I'm ...
1
vote
1answer
98 views

The best approach for screening ATH values for equities

I am trying to automate the trading strategy that I have been previously executing manually. I am having problems with figuring out the most efficient way for a specific step of the strategy. An ...
0
votes
1answer
158 views

Calculation of market price for option at underlying strike price at some point in future

Would appreciate clarification on the below scenario. If a put option was sold at the start of the week, when the broker (Interactive Brokers) calculates the cost basis (the premium collected) are the ...
1
vote
0answers
28 views

Whitespace in Option Symbols

A while ago exchange-traded option symbols migrated to a 21-character descriptor, formalized by the Options Clearing Corporation (OCC), consisting of: 7 characters: root or underlying symbol 6 ...
0
votes
1answer
202 views

BQL Question [New to BQL and programming in general]

I have this BQL query to grab a list of Russell 3000 members and get the firm names. Is there any way I can grab other data with the company names such as industry/sector name, total assets, EPS, etc.....
9
votes
2answers
3k views

Without Bloomberg, how can retail investors know how many shares have been shorted daily?

Many friends can't afford a Bloomberg terminal, particularly when the pandemic has unemployed some of them. This answer can't assist them. How else can amateur investors determine the number of ...
0
votes
0answers
73 views

Resources for Bayesian methods

I will be joining a risk management firm in a few months, and I was wondering if some of you could help we with resources on certain methods. Some of the things that I would be called upon to work on ...
2
votes
1answer
96 views

US Equity Real-time Market Data Feed Pricing

I'm trying to compare the minimum cost of subscribing to primary sources of real-time market data on NYSE and NASDAQ for last sale and level 1 top-of-book quotes. Use cases are log to files, store ...
0
votes
1answer
148 views

Swap data- couldn't find any

I'm a student and i amm looking for a swaps rates historical data for long tenors in purpose to estimate yield curve (for example in GBP). My question is where could I find it?
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
31 views

Find the stock exchanges a security is traded in given a CIK?

I have all the CIKs and relative tickers of all the traded securities that I need (https://www.sec.gov/include/ticker.txt). My question is: How do I find the stock exchange that a gives security is ...
0
votes
0answers
43 views

Which exact interest rate should I use for valuing equity index futures (ie. SPX, MXEA)?

I'm trying to build a model that values futures for equity indicies like SPX. For example, this product link here. I know that the model is simple (please correct me if I'm wrong): $$ S_{T} =S_{0}e^{(...
0
votes
1answer
415 views

Symbol for the Dow Jones Industrial Average in Alphavantage.co

Is there a way to retrieve EOD and intraday data for the Dow Jones from Alphavantage.co API? I tried DJI, DJIA, DJA. None worked.
0
votes
0answers
72 views

How to download all tickers listed in the Tokyo stock exchange?

I'm trying to download all tickers listed in the Tokyo stock exchange (according to their website, there should be 3,756 tickers in total). What I have tried so far: I have tried the Yahoo-ticker-...
1
vote
3answers
209 views

Top 500 Companies in the World – Data

At the basis of an algorithm, I need an Excel/CSV file containing the world's top 500 companies (with respect to market cap, preferably free-float if possible) by Name, Country, Market-Cap (in USD, or ...
0
votes
0answers
24 views

Where to find Caps/Floor historical data?

I'm trying to calibrate the Lognormal Forward Libor Model to market data, in order to calculate market implied volatilities. However, I'm having some troubles finding any Cap/Floor historic price. Not ...
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
98 views

ICE futures settlement prices change with zero volume and zero OI

I found that all of the electricity futures prices (on ICE) at a particular hub changed on December 2, even though a) most had zero open interest and zero volume, and b) the quoted prices are EOD ...
0
votes
2answers
164 views

Download Curve in the past via TIA Bloomberg in Python

I am using TIA package in Python to download an interest rate curve. Using the following script I get the last curve. How do I specify a date in the past to have a curve in the past? ...
0
votes
0answers
146 views

Using AlphaVantage to get Fundamental data from Brazil Stock exchange (or other country than US)

I noticed that I can request Fundamental data from AlphaVantage API but I just managed to get US stocks Fundamental Data (like AAPL, MSFT, IBM and etc) but nothing from others countries, like from ...
0
votes
0answers
35 views

How can I know the distribution of how many shares were bought in specific price?

Given a stock and any time $t$, is there a way to find the distribution $f_t$ $$f_t: \text{price}\ p \rightarrow \text{in current time $t$, how many shares were bought in price $p$}$$ For example, a ...
1
vote
0answers
250 views

1 Factor Hull And White Swaption Calibration

I'm trying to calibrate a Hull and White model with constant volatility, mean reversion and theta such that the model can reproduce the initial Term Structure. I'm using this python code adapted from &...
0
votes
1answer
46 views

Accesssing buyers and sellers of futures contracts

I'm attempting to access all futures contracts traded for a given day. Reading the Quandl blog: https://blog.quandl.com/api-for-futures-data to access futures contract use the python code: ...
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
2 3 4 5
9