Questions tagged [data]

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

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

How do you identify top shareholders in SEC filings?

Schedule 13D is filed when a shareholder crosses 5% ownership and 13F is filed by fund managers to list their portfolio holdings. These are the only filings that I am currently aware of related to ...
0
votes
0answers
36 views

How can I calculate the annual Standard Deviation for Sharpe Ratio of Daily Portfolio Returns?

I'm somewhat confused with regards to calculating the annual standard deviation and Sharpe ratio for my portfolio of daily returns. I have daily data ranging from 1960-2020 and use Excel to make some ...
1
vote
2answers
289 views

Where do big data companies get data?

First time posting at Quantitative Finance, hope the question is well suited in this stack section. I was wondering, where does big companies like Bloomberg or Reuters get their data? Since now, in my ...
0
votes
0answers
23 views

Where to find retail trading volume data?

I have plans to work on a paper to study a possible correlation between fluctuations (volatility) in the European and American markets with retail trading activity, either dollar and/or ticket volume. ...
0
votes
1answer
41 views

Historical Fundamentals Data for Sectors

I am interested in a one-time download of GICS sector (e.g. XL- etfs) historical fundamentals data (in particular, point-in-time price/book ratios). Does anyone know where this can be found? I am ...
0
votes
0answers
25 views

I cannot find any complete data for sp500 stocks dating back 20 years [duplicate]

I am building my own framework backtesting sp500 pricing data dating back several years. Mainreason being that I want to get a representative result of my own trading strategy. The mainproblem of this ...
0
votes
2answers
81 views

Getting US equity data for commercial use?

If you were a hobbyist in the process of building a subscription site that people are willing to pay for, how would you get US equity data in a commercially available form? I just need EOD delayed ...
0
votes
0answers
22 views

Interpreting flows divided by AUM

For a panel regression of some public fund flows, I have standardized the net flows by dividing flows at month $t$ by $AUM_{t-1}$. This puts the flows into perspective, but I feel that this kind of ...
0
votes
2answers
62 views

Where can I get fundamental data on US public stocks in original form?

I'm looking for fundamental data on US public companies. If anyone could recommend paid or free sources of the fundamentals in original, non-standardized form that would be great. I tried scraping the ...
1
vote
2answers
303 views

What kind of data cleansing/scrubbing are hedge funds doing?

It's a well-known fact that several hedge funds have a handful of PhDs just doing data cleansing. All day. Every day. What kind of data cleansing are they actually doing? Is it really that difficult? ...
0
votes
0answers
91 views

Python - DCF Model & reliable free Data?

on the following website i found a really nice DCF Model. https://codingandfun.com/discounted-cash-flow-with-python-valuing-a-company/ Well it didnt work like the code which was published so i had to ...
2
votes
1answer
102 views

Help with pulling company fundamentals from EDGAR

I need help understanding why there are many different values for a specific metric reported by a company's 10-K or 10-Q in the EDGAR database. I've downloaded the entire US equity universe in JSON ...
2
votes
0answers
85 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
39 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
68 views

Fama-French factors creation using Bloomberg data

The standard FF factors as published by K. French (https://mba.tuck.dartmouth.edu/pages/faculty/ken.french/data_library.html) are created using CRSP data. If one downloads the (US) factors, the first ...
0
votes
0answers
26 views

Finding historical data

I need T-bill rates in order to use it as risk-free asset from Jan,2003 t0 today.(monthly data) I don't know how to find it. Can you please suggest your idea about how to find it?
1
vote
1answer
34 views

Search for historical balance sheet data

I would like to run backtests on swedish companies. How I can retrieve historical balance sheet data?
11
votes
1answer
857 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
16 views

Top 50 Nasdaq composite index by volume in 2020

Where can I find the data about the top 50 Nasdaq composite index by volume in 2020 and top top 50 NYSE Nyse by volume in 2020? I use Google but can't find any accurate data.
0
votes
1answer
252 views

Bloomberg API / Excel Add In - Delisted Stocks

So I am using the Bloomberg Excel add in but can also use the API. My dilemma is I have a list of tickers containing SP500 historical constituents and I have retrieved 600 of them from an alternative ...
0
votes
0answers
31 views

Expected return and risk profile from a given scenario

I have this scenario: "Designing a model on python but firstly, needing an equation to work from. It's a project aimed at decentralizing drug discovery. So, we're planning on running some screens ...
0
votes
1answer
73 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
113 views

Historical ISM report on business?

Is there any place to download historical ISM ROB (report on business)? The website only shows current and previous month. ISM ROB
0
votes
0answers
123 views

Historical component changes of EURO STOXX 50 index

I would like to download the historical component changes of EURO STOXX 50 index to conduct an academic research. That is, I would like to know the historical changes to the composition of these ...
0
votes
1answer
173 views

How to get Adj.Open, High and Low prices?

I am trying to get adj.Open , adj.High and adj.Low prices. Most data sources like yahoo and google finance provide only adj.close price. Is it possible to derive other adj. prices using close and adj....
0
votes
1answer
108 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 ...
0
votes
0answers
39 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
1answer
82 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
0answers
37 views

How to retrieve all hidden units from Datastream?

From this website, I have the total asset of Apple is 338 billion USD in 2019, but when I download from Datastream, the result is just only 338 million USD. And Datastream even displays the currency ...
0
votes
0answers
23 views

Interest rate caps and floors - where to get data [duplicate]

Hey I need some prices of interest rate caps and floors for model calibration. Where can I get (or eventually buy) data?
1
vote
0answers
18 views

Where to find a list of all the operable exploration / mining companies conducting operations in Canada [closed]

Looking to create a database firstly of all the exploration / mining companies conducting research in Canada. TSX and TSX-V have very nice spreadsheets with several filtering operations, which is very ...
0
votes
0answers
36 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 ...
1
vote
2answers
733 views

When looking for arbitrage among a LARGE amount of assets, is there an optimal way?

Looking for arbitrage opportunities when looking at 3 pairs of related currencies is easy. However if we assume that we have a large amount of currencies, is there an optimal way to swipe through them ...
0
votes
0answers
211 views

Is alpha vantage api for fundamental data reliable?

Can anyone speak to the reliability of the Alpha Vantage (AV) api for fundamental stock data? I have tried for a couple of stocks to get balance sheet data, and it seems close to accurate but I feel ...
0
votes
1answer
56 views

Non-fixed stationary "conversion"

Dear users of StackExchange, I was wondering why the log returns of a fixed period of time is such a common use in "transforming" a time series into a more stationary one? I thought that ...
0
votes
0answers
25 views

Historical Economic Release Calendar

Does anyone know if any providers have a historical economic release calendar? For example, releases of things like ADP private employment, or ISM surveys? I ask because I would like to backtest a ...
3
votes
2answers
1k views

Red Black Trees for Limit Order Book

Why do people suggest using red black trees/balanced binary trees for the levels in a limit order book? Why are they algorithmically ideal?
0
votes
0answers
26 views

Derivatives notional amount in BankFocus

I'm searching for the notional amount of derivatives in banks' balance sheets. I'm using "BankFocus" (ex Bankscope) to download data. In balance sheet i find just the fair value of ...
2
votes
2answers
470 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
0answers
26 views

looking for mortgage backed securities TBA notification and settlement dates

I was curious if anyone knows where to find TBA notification and settlement dates prior to June 1999. Of course the recent ones are available from SIFMA and this PDF here https://www.sifma.org/wp-...
0
votes
0answers
86 views

Python: Parametric Portfolio optimization with data from Kenneth French

I am fairly new to Python and struggling right now. I am trying to build the parametric portfolio policies by Brandt (2009) with the data of the Fama French Factors by Kenneth French, which is taken ...
1
vote
3answers
844 views

How to structure a stock market data database

I would like to download stock market data from the internet (for example by scraping…) and organize them in a database (I am using python and SQL) which updates daily or on request. (The idea is to ...
1
vote
3answers
103 views

OHLC Data for US Govt. Treasury Yields?

Is there open-high-low-close data available at the daily timescale for yields? The data I can find from the Federal Reserve reports only one price, and moreover, I'm not sure when the data is reported....
-2
votes
1answer
137 views

What are good examples of using Big Data for a trading strategy?

As the title say, I am looking for trading strategies in the stock, bond, forex market, that rely on the usage of Big Data. The more out of the box strategy the better. Also if anyone knows any ...
0
votes
2answers
301 views

Large data of Equity Price download from Eikon thomson reuters datastream

I like to download all Chinese ( more than 4000 stocks) stocks daily price data from 1990 to 2020 from Eikon Thomson Reuters datastream. However, I failed to select and download all stocks together. ...
1
vote
2answers
138 views

Alternative data providers

What data vendors/providers have you come across or used for alternative datasets? Not talking about market data here. Things like rainfall, coronavirus stats, new car production in China etc. I
0
votes
1answer
47 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
250 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 ...
0
votes
1answer
156 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
1answer
234 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
2 3 4 5
10