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.

1
vote
4answers
963 views

How are OHLC bars made from bid, ask, and last trade prices?

This seems like a very basic question, but the Internet does not seem to know, so: If you have a stream of bid, ask, and last trade prices, how do you convert those into periodic open/high/low/close ...
1
vote
1answer
217 views

Information on Security Information Processor (SIP)

I'm trying to better understand what information is disseminated by the SIP. In essence, if somewhere were to observe the SIP only what would he see?
1
vote
1answer
115 views

Why are Yahoo's “Adj closed” data changing over time?

I downloaded MSFT historical data from Yahoo Finance a year ago and re-downloaded it today again. I turns our the two datasets are different. E.g., today I got Adj Close of MSFT for ...
1
vote
2answers
243 views

How do I get a list of all ETFs / REITs?

I am currently doing a research which will need ETF and REITs' historical data back in early 2000s. The problem is I do not know what symbols existed back in then, unlike indices like S&P and DOW,...
1
vote
1answer
614 views

Getting quote stream via fix-api 4.3

I'm new to FIX api,so far i did following (on QUICKFIX) logged on to quote-session subscribed to market data sent "single-message" quote-request for an instrument (EUR/USD for example) ...
1
vote
1answer
160 views

Interest rate models

I'm studying by myself how to model interest rates. Is there any database in which I can find accurate data for indices like Libor, Euribor, Eonia etc?
1
vote
2answers
56 views

Finding a stock traded at two venues

For a project of mine I need to find a stock that is traded on two venues, e.g. NYSE and NASDAQ, but could be others. So I ...
1
vote
2answers
298 views

How do I find the entity identifier using BSYM?

I am new to BSYM and would like to do an entity-level search (as described here (towards bottom of document). For instance, a search for "APPLE INC" brings up 266 pages. Which one is for the entity? ...
1
vote
2answers
1k views

How to adjust historical data highs/lows for splits and dividends?

When I download historical data from yahoo finance, only the closing price is adjusted for dividends/splits. Is there a way of figuring out the factor by which lets say the highs/lows have to be ...
1
vote
1answer
193 views

Are there industry standards form market data server and real time linux kernel?

I'm wondering if there is some standard in the industry about the version of the linux kernel of a computer to run a market data engine on it. (market data engine = connect to brokers, subscribe to ...
1
vote
1answer
173 views

Where to obtain Eurex level 2 historical order book data from?

What are some possible sources to obtain Eurex level 2 historical order book data from? Unfortunately I have only been able to find 1 source - namely Eurex itself, which charges 2000 Euro/month for ...
1
vote
2answers
369 views

Real-time market data from the exchanges: what should we be aware of?

We receive daily end-of-day data from a data vendor (i.e. not direct from an exchange) and are comfortable with this. We are now wanting to receive live data, and after a few enquiries we are feeling ...
1
vote
2answers
236 views

Where can I find a guide to implement the FAST protocol from scratch having already a FIX implementation ready?

I need to implement a FAST engine from scratch without using any open source or commercial FAST implementations. The FAST spec does not help much so I am not sure from where to start. Have anyone done ...
1
vote
1answer
165 views

Company rank within an industry

I'm looking at the list of companies in the S&P 500 Pure Value Index. For each firm, I want to obtain the dividend yield industry percentile rank and the PEG ratio industry percentile rank. I've ...
1
vote
1answer
27 views

Historical quotes / prices of multiasset options

I am working on Lévy copulas, and I would like to try calibrating such techniques on real data. Where can I find quotes for multi-asset options? It could be exchange options or any other type of ...
1
vote
1answer
80 views

Is there a straightforward way to get a “family tree” for a stock?

I would like to find a way to generate what might be called a "family tree" for a stock. Given a stock symbol and a future date, I'd like a graph (either literally or represented in list or other ...
1
vote
0answers
40 views

Is there a way to pull SPX index option open interest daily data?

Currently I just use Bloomberg API in Excel for preliminary data analysis and manipulation, and I have one function call that gives me the ticker and IV today ...
1
vote
0answers
25 views

What are industry-standard terms for MBIS “situational bid”?

In the data feed from Municipal Bond Information Services there is a field called "situational bid", which is defined in their reference as "Bids on a security that is being offered for sale." If I ...
1
vote
0answers
42 views

How to make use of sector index returns data to analyze the overall stock market index

I have a set of indices returns data, namely, ...
1
vote
0answers
39 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
170 views

List of US Industry sector ETFs that map to ICB classification

I am in the prcess of carrying out intra-and intra sector analysis of US stocks, and am proxing sectors with sector ETFs. I therefore, need to catalog the list of US sector ETFs - but have been unable ...
1
vote
1answer
316 views

historical data on orders and executions

I've implemented a simple trading system that gets orders with FIX, manage them in limit order books, calculate relative prices and, execute order book, runs multiple sessions (auctions and normal) by ...
1
vote
0answers
99 views

1 minute data: Japan, Australia and India stocks

Where I can find 1 minute historical market data for Japan, Australia and India stocks markets?
1
vote
0answers
74 views

Missing sequence numbers in TAQ Quote data

I am looking at NYSE sample TAQ Quote data for Apple stock (link at the bottom of the post) and I have noticed large discontinuities in the data intervals. For example, these two are two succesive ...
1
vote
1answer
40 views

Public Company Competitors?

Where can I input a stock ticker and get back a list of the top 3-5 competitors of the stock? E.g. if I input F, I get GM, etc. It would be great if this could also give me data for delisted stocks.
1
vote
0answers
40 views

How can we track historical valuations of factor portfolios in emerging markets (in terms of P/B or P/E e.g.)?

We can analyze factor investment approaches (momentum, low vol, quality, dividend, ...) for example by looking at the corresponding MSCI indices. Doing so we can read of today's valuations (P/E, ...
1
vote
1answer
548 views

Interpreting description of a particular (momentum-based) data processing technique

I'm attempting to prepare data in the same manner as section 2 of this paper. I'm finding it a bit of a struggle. Could someone check (/improve upon) my interpretation regarding the 2 sections I have ...
1
vote
0answers
62 views

How can I discover dark pool orders in an order book?

I'm learning order flow. I would like to differentiate between aggregated dark pool volume and aggregated algo trading volume. Is there a way to tell orders coming from a dark pool from algo orders?
1
vote
0answers
34 views

Feedback on Video Metadata Extraction

I've developed/patented a metadata extraction methodology, which we've used to build a variety of alternative datasets for funds. One of the more difficult issues in this field, is getting useful ...
1
vote
0answers
25 views

Sample data of quarterly (annualized) real GDP growth

I am looking for a database that provides me the quarterly (annualized) real GDP growth (quarter t and t-1) of US, Germany and England. For the US data i went here: https://www.philadelphiafed.org/...
1
vote
0answers
40 views

Historical UK Gilt 2-year and 5-year data

Data on the Medium (approx. 5-years) and Short (approx. 2-years) futures contract listed on ICE only goes back to 2009. Is anyone able to point me towards where I can get a longer time series, perhaps ...
1
vote
0answers
63 views

NZX market depth data

Can someone point into the right direction for NZX market depth data specifically for individuals? I have tried many vendors but seem to be coming up with "institution-only" responses.
1
vote
0answers
92 views

Calculating Asset Returns

The question pertains to a simple phenomenon. There is gold futures listed on Exchange A and Exchange B. Exchange A and Exchange B overlap times with A and B starting 8 hours later and A and B ...
1
vote
0answers
2k views

Get: Historic S&P500 Market Cap

I need the market cap of the S&P500 components on 2.6.2013. It should be easily downloadable via Bloomberg, but I dont have this databank. E.g. you could use ...
1
vote
3answers
523 views

How can I determine U.S. market capitalization percent using WFE data?

It seems that I should be able to readily compute U.S. market capitalization percentage of global capitalization using data reported from this page at the World Federation of Exchanges. How can I ...
1
vote
1answer
75 views

FTSE AIM Components From 2000, 2001, … 2013

From where can I get a list of historical component lists for the FTSE AIM Index as well as other indices? I see that there is a page for data sources here, but that page does not contain what I am ...
0
votes
1answer
5k views

Is there a piratebay for data(bases)? (here, talking about historical financial data) [closed]

I would like to, for example, access (and later, upload), for example, historical financial data for the S&P500. If a piratebay for databases existed, maybe we could freely share information that ...
0
votes
3answers
629 views

Where can I find CMS swap trading prices?

I am writing a paper about CMS swap. To do so, I'd like to compare different theoretical pricing methods of these instruments to the "real prices" i.e. prices used in the marketplace. But I don't ...
0
votes
1answer
385 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 ...
0
votes
4answers
234 views

Correlation of Asynchronous Brownian Motion

I am trying to use the closing prices of the S&P 500 and the Nikkei Index to see how they are correlated (assuming they are exactly 12 hours apart). In order to test my method, I have generated ...
0
votes
1answer
297 views

How to download historical composition of a Stock Index with monthly prices

for a Quantitative project in Asset Management, I need to obtain for each year -on a long period (20 years) - the different historical constituents and their prices on a monthly basis for a given ...
0
votes
2answers
131 views

Obtain prices for list of stocks

I have a spreadsheet with a large number of ticker symbols. Is there any site that can get the current or past (either works) price for each of these stocks in one fell swoop? Paste in the list of ...
0
votes
1answer
155 views

Calculating company-level market capitalisations from share quantities and values

I want to calculate company-level market cap values for stock exchanges listed by Bloomberg. I gather this can be calculated as the product of share price and the total of shares in circulation. But ...
0
votes
2answers
545 views

Is there any public data to get OIS for differal time (1d, 1W, 1M, …, 10Y)?

I want to get data of Overnight Index Swap, also known as OIS rate, there is any public why to get this always from yesterday? For example, I want to get EFFR(Effective Federal Funds Rate), I can get ...
0
votes
3answers
691 views

Alternative to Bloomberg Excel Add-In for EOD Stock Prices

Is there a more cost-effective alternative to Bloomberg Excel Add-In? 90% of the time I only use Bloomberg to download security (hundreds of U.S. and international stocks) historical price data. The ...
0
votes
1answer
896 views

Is NASDAQ file “nasdaqtraded.txt” a list of all common stocks traded on NYSE, NASDAQ and AMEX?

A prior post had stated how to get a list of all common stocks traded on NYSE, NASDAQ and AMEX - via NASDAQ site at ftp.nasdaqtrader.com in ...
0
votes
2answers
62 views

Definitive way of figuring out companies with multiple classes of stocks

Is there a definitive way of mapping tickers to companies for companies with multiple listed tickers? For example, GOOG and GOOGL are both Google (or now Alphabet), or BRK.A and BRK.B are both ...
0
votes
1answer
297 views

Level II market data (equities)

I have been playing around with some equities historical market data and I understand that different exchanges have different definitions of what Level II (Limit Order Book) data means. What I'm ...
0
votes
1answer
236 views

Finding historical data for indices [duplicate]

Where can I find historical data for option prices on a given index ? Ideally I'd like to find for a period of several months 1) historical prices on options on a given index 2) historical prices on ...
0
votes
1answer
35 views

Do you use seasonally or non seasonally adjusted index in analysis

I am constructing an inflation factor that includes the gdp deflator, the PPI for finished goods, and a spot commodity index. Do I uses seasonally or nonseasonally adjusted historical series? Thank ...