Questions tagged [historical-data]
Use this tag for questions about historical financial and economic data and its application to personal finance.
149 questions
0
votes
0
answers
83
views
Is options exercise information published?
For a particular options contract, I can find out its time and sales, open interest, etc., but is the exercise/lapse statistics also published? i.e., how many contracts are exercised today, how many ...
- 153
0
votes
1
answer
85
views
Long term debt calculation in balance sheet - Yahoo vs Marketwatch
I am trying to calculate the long term debt from the balance sheet, comparing yahoo finance with marketwatch.
Let's take MSFT as example. In yahoo finance, the quarterly "Long Term Debt And ...
- 3
0
votes
1
answer
126
views
Use of the data from sites like NASDAQ and others
I am designing a site to publish some insights about big companies, their financial reports that I need to scrape from other website like NASDAQ, Bezinga etc. Is this allowed to publish this data in ...
- 103
1
vote
2
answers
130
views
How can I know the historical returns for a Vanguard bond fund, disregarding changes in share price?
This question is really about bond funds in general, but Vanguard funds are what I have experience with, so the details of my question and screenshots will be specific to them. But I hope this ...
- 298
-1
votes
2
answers
298
views
How is a seasonality chart calculated for a specific stock?
I have seen several websites offer a Seasonality chart for stocks, and I tried to recreate it, but my results have the general line pattern, but its not the same as what I see on other sites.
My ...
- 732
1
vote
2
answers
141
views
What would be the instrument/index with the most historical data available for something similar to TLT aka a bonds fund? [closed]
I would like to have as much historical data as possible regarding a bonds fund performance similar to the iShares 20+ Year Treasury Bond ETF (TLT).
For now I have this source but it goes back to only ...
- 21
0
votes
0
answers
83
views
Am I grabbing data incorrectly, or are massive chunks of data missing from Yahoo Finance?
13 month treasury bill has almost half of its data missing 2010-2022
Has anyone else encountered this problem? This is ticker "IRX", for reference. This also happens with others big datasets,...
0
votes
1
answer
70
views
Local Crime Data (Drug) for Property Buying or Leasing [closed]
Folks,
I am looking for online data sources that have historical data on crime incidents.
I have looked at a few sources simply by googling:
crimemapping.com
local police department - incident ...
- 451
0
votes
0
answers
52
views
What's the USD/TRY rate in 1961?
I can't find this information anywhere on the internet. Help
Earliest data I found is in 1990
I'm looking for 1961 average or a specific month or day. I'll accept any kind of data. Thanks
8
votes
2
answers
2k
views
Is it routine for historical stock price data to be revised?
I noticed that the price history of AT&T stock (T) prior to April 11, 2022 is about 25% lower today than it was a week ago. That is to say that when I click on my favorite financial websites and ...
3
votes
1
answer
232
views
Historic Forex Rates - why are they different and what's the source of truth
I am looking for historical FX data. During the course of my research, I've found that various free providers don't seem to agree on the numbers.
For example, searching for USDGBP rates on Friday 30th ...
- 133
2
votes
0
answers
64
views
What could possibly explain this minor data difference from my bank? [closed]
Half a year ago, I logged into my bank's website and fetched all transaction records for my account as far back as it allowed me, which meant down to the first day of 2009. Saved as CSV file.
For ...
- 21
1
vote
1
answer
91
views
Are there publicly available data to demonstrate the predictive power of credit scores?
Credit reference agencies assign and distribute a credit score for individuals based on their financial behavior. The implication is that this score has predictive power, such that an individual with ...
- 490
0
votes
1
answer
72
views
Where can I find the stocks online/offline data? [closed]
I have 3 questions:
1- Where can I find the historical data of stocks and cryptocurrencies, etc. as .CSV file for free?
2- Where can I get online data of stocks/cryptocurrencies for free? I mean a ...
user82352
2
votes
1
answer
113
views
Cryptic data coming from tiingo [closed]
I am trying out tiingo API and made the following call:
headers = {
'Content-Type': 'application/json'
}
requestResponse = requests.get("https://api.tiingo.com/tiingo/daily/aapl/prices?...
- 121
0
votes
2
answers
72
views
How home prices behaves during and after great inflation 1970s in USA
Is there any chart/data or research on average home prices during 1970s in USA in big cities (NY, LA etc.).
I'm particularly interested in average price per square meter between 1970 to 1985.
- 465
0
votes
1
answer
80
views
Searching for stock risk measure where a value of around 15 is fine
I am reading through some stock analysis documents (unfortunately they don't seem to be available online). They calculate something that they call "risk". For Amazon stocks its around 18 (...
- 1
0
votes
1
answer
82
views
How to find information on bond buyers?
To better assess my bond investments, I want to see what institutions are buying US treasuries in the auctions over the last three months. Just want to see if there is any change in the composition of ...
- 271
0
votes
0
answers
47
views
Why i have different historical prices of AAPL between Quandl and Yahoo Finance? How should I behave in cases like this? [duplicate]
I'm a programmer and recently I'm approaching to the world of trading. Now I'm attempting to obtain historical data of AAPL.
This is code for obtaining historical data from Quandl:
import datetime
...
- 101
1
vote
1
answer
962
views
How to Calculate S&P Monthly Average Closing Price?
When I look at monthly S&P 500 prices at a site such as Multpl, they state "all prices are monthly average closing prices." e.g. https://www.multpl.com/s-p-500-historical-prices/table/...
2
votes
1
answer
221
views
Why do some dates not have any data on the Federal Reserve historical currency data?
Example: https://www.federalreserve.gov/releases/h10/hist/dat00_al.htm
Some of the days, such as 12-Nov-01, say ND instead of a price. I assume that this means "No Data", but it's not ...
- 21
3
votes
2
answers
313
views
Why are there so many glitches in stock market (equity) data?
In a recent question (Were the shareholders of ZTNO (Zoom Technologies Inc.) just hustled?), I asked about an equity (stock) that appeared to suddenly go to zero. Other community members helpfully ...
- 1,146
1
vote
0
answers
44
views
Earnings coverage calculation confusion
I am working my way through security analysis by Benjamin Graham (sixth edition) and have come across some calculations that do not make sense to me. This is the paragraph that precedes the data that ...
- 11
9
votes
7
answers
4k
views
How much should retail investors spend on financial data subscriptions?
Retail investors can subscribe to financial data portals such as Morningstar Premium, Yahoo Finance Premium, Value Line, etc. Is there a general guideline on the maximum amount one should spend on ...
- 17.2k
5
votes
1
answer
1k
views
If one were to have invested in a 1920 German index fund, when would they have recovered after 1930-40 devaluations?
So I have seen a question recently about safe investments (govt bonds etc), and someone said index funds were safer over a 30 year period, because you would be losing to inflation with the current low ...
- 670
0
votes
1
answer
43
views
Schiller Stock Data
I was analysing the data provided by Schiller (http://www.econ.yale.edu/~shiller/data.htm). On the first row (year 1871) the value for CPI index is 12.46. Anyone know the source of this value? I ...
- 1
2
votes
1
answer
102
views
Interpreting ETF historic data
I'm trying to wrap my head around ETFs and am looking at various metrics to compare and trying to understand them, but I'm having some troubles to interpret them.
To understand the characteristics of ...
- 121
0
votes
1
answer
69
views
Washington Gas Light Company serial preferred stock $5.00 series [closed]
Where can I find the historical price of this preferred stock, especially for May 2020.
0
votes
1
answer
325
views
Calculating Sharpe ratio for my trade strategy
I've been analyzing NIFTY 50 with some basic trading strategy where I come in and out of trade continuously. The time frame I'm testing my strategy is 7 years. I'm unable to understand how to ...
0
votes
1
answer
52
views
Historical stock price of Anadarko Corporation Jan. 8 and May 26, 1983 [duplicate]
I am looking for the common stock price of Anadarko Corporation for January 8 and May 26, 1983.
Can anyone help?
- 1
0
votes
2
answers
60
views
Are there full price graphs of currently traded stocks? [closed]
If so, where are they? Robinhood limits graphs to 5 years and TD Ameritrade limits them to 3. I am interested in finding full data of stock prices from the start to now. I am investing in the Dow ...
1
vote
1
answer
426
views
USA average salary, historical data 1930-now [closed]
Is there a historical data for average salary in USA, maybe not very precise, starting ideally from year 1930?
Any type of salary, before or after tax, and any average - mean, median would be ok.
P....
- 187
0
votes
1
answer
88
views
Why did the VIX trade for so much around Q4 2011?
It looks like the TVIX in 2011 was trading at some unimaginable prices. $2B USD? Marketwatch has these same numbers.
Were these numbers real? How? This seems like an amazing bit of trivia from ...
- 107
21
votes
5
answers
4k
views
History of marginal-rate taxation in the US
I recently came across an article that made me think about marginal tax rates in the US. Specifically, in the fourth paragraph there is the statement:
He once asked me to explain to her that if she ...
- 440
1
vote
2
answers
265
views
I have old stock certificates in Antares Resources Corporation. Does this old stock have any value?
I have a Common Stock certificate for 310 shares of Antares Resources Corporation issued March 24, 1997. The corporate seal shows a 1958 date. I believe the company changed its name and ticker symbol ...
24
votes
2
answers
10k
views
Did Johnson and Johnson really pay a 25% quarterly dividend in 1978?
I looked through some of the old Dow Jones stocks for a project I'm working on and found some inconsistency with JNJ stock. For a share price of $1.66 they appeared to pay $0.42 in quarterly dividends ...
- 821
0
votes
1
answer
191
views
How to interpret returns on index funds
I don't quite understand how investing into index funds works, or how to interpret the average historical returns.
Let's say that, 10 years ago, I decided to invest $30,000 dollars at the end of each ...
4
votes
2
answers
772
views
What kind of stocks were commonly traded in the 70s?
I'm doing a school project on four fictional people who are about to retire in 2020 and have worked since 1975. Three of them consistently invested $1,000 per month (adjusted for inflation) into ...
- 821
0
votes
5
answers
515
views
Why is interest paid on the outstanding amount instead of the whole amount of a loan?
For a large proportion of loans, why is interest paid on the outstanding amount instead of the entire amount of a loan?
For example, for a 100.000 loan with a 10% interest, basic logic would imply ...
- 1,415
0
votes
1
answer
59
views
Historical Data For Options? [closed]
Is there a site where I can get historical options data? Where I can see what the price of a particular option was several days ago?
0
votes
1
answer
184
views
Where can I get historical stock data from different companies from the 70s to today [closed]
I'm trying to calculate what a person would have earned if he invested all his savings into random stocks until retirement from 1975 to today.
Basically I just a need a set of stock market data that ...
- 821
2
votes
3
answers
170
views
Over what time frame should we evaluate whether an active trading strategy is successful?
I have been playing around with some different active trading strategies by looking at historical stock data. However, I am running into some difficulties in how to define whether a strategy actually "...
- 151
-1
votes
1
answer
44
views
UK FTSE Sector Indicies Data [closed]
I am trying to find an on source of FTSE ICB indicies from which I can download historical and current data from. for example I can view the current value of such indices here but I want to also ...
- 101
1
vote
0
answers
70
views
Daily spread measure for products in crypto exchanges?
I'm now trying to trade in crypto, and I want to get a measure of the liquidity of products listed in exchange.
Trading volume is a good measure, and easy to obtain.
Spread is also a good measure, ...
- 111
2
votes
1
answer
77
views
How can I view a portfolio's historical performance? [closed]
I have a premium Morningstar subscription. It provides a wealth of information and is mostly enough for my information needs.
I'm able to create portfolios and watchlists, and watch their performance ...
- 621
2
votes
1
answer
967
views
How can I get the historical data of stocks being ranked in Zacks Investment?
I am looking at Zacks Stock Market Research web site and it has rankings for stocks like 'Sell', 'Buy', 'Strong Sell', 'Hold' etc.
I would like to retrieve historical data of the stock rankings going ...
- 21
4
votes
1
answer
276
views
How many ETFs have been closed so far?
I am thinking about investing my money in an ETF as they seem to be a relatively safe way to invest money over a long term (~20 years).
However, I don't like the "seem to be". Are there numbers on ...
- 936
-1
votes
1
answer
96
views
mean vs current values to compute indicators
First time writing a question here!
I'm creating a simple bot to trade with stock. It uses indicators such as Moving Averages or Bollinger bands to evaluate the price of the stock and decide whether ...
- 101
1
vote
0
answers
213
views
What were quarterly values of the MSCI "WMA Private Investor Income Index" (TR) for the last 5-6 years?
In the UK, the WMA indices are quite popular with "wealth management" types for benchmarking performance of clients' multi-asset portfolios.
I'm interested in finding the historic values of the WMA ...
- 4,022
0
votes
1
answer
1k
views
Flat lines in candlestick charts
I'm creating software that will perform technical analysis on stock data. I'm using single day sessions. I've noticed data where the open, close, high, and low prices are the same. When I pull these ...
- 13