Skip to main content
38 votes
Accepted

What happened to Home Depot's Stock in 1988?

It's got to be a bad chunk of data on Google. Yahoo finance does not show that anomaly for 1988, nor does the chart from Home Depot's investor relations site:
Ben Miller's user avatar
  • 116k
12 votes
Accepted

Mutual fund historic prices, seen @ Google and Yahoo, don't match my activity

VFIAX closed at 421.39 on 12/20/2021 (both Google and Yahoo show this). I suspect that Vanguard filled your order on the 20th, not the 21st. It's possible that the funds were settled the next day - ...
D Stanley's user avatar
  • 137k
10 votes
Accepted

How can I compare multiple mutual funds on a single chart at once?

Thanks, Bob Baerker for getting me on the right track! I'd like to post my own answer. (This works for stocks or mutual funds--doesn't really matter). Go to www.marketwatch.com In the top right, ...
Gabriel Staples's user avatar
5 votes
Accepted

The dividend yield of AMC is reported differently on different financial info websites. How do I know which is correct?

For the past 5 quarters the dividend has been 20 cents per quarter. So based on a price of $4.46, the yield would be 17.95% which is what Robinhood says (raspberry sound!). However, the dividend has ...
Bob Baerker's user avatar
  • 76.8k
5 votes

Get Revenue Details in Google Sheets using Google Finance

Use this formula in Google Sheets: =IMPORTXML("https://www.google.com/finance/quote/TSLA:NASDAQ","//table//tr[contains(@class,'roXhBd')]") This will bring up a list of the company'...
user107993's user avatar
5 votes

How can I compare multiple mutual funds on a single chart at once?

BigCharts will graph up to 10 symbols at once. http://bigcharts.marketwatch.com/ Enter a symbol and select "Advanced Chart" Click on "Compare To" Enter other symbols and Voila! , you have ...
Bob Baerker's user avatar
  • 76.8k
5 votes
Accepted

How does stock Ref/Id work on google finance?

AN8068571086 is the International Securities Identification Number (ISIN https://www.investopedia.com/terms/i/isin.asp) for SCHLUMBERGER N.V. (LTD.). An ISIN is an international symbol for a company's ...
MD-Tech's user avatar
  • 9,023
4 votes
Accepted

Google Finance gain value incorrect because of currency fluctuation

You can easily build a Google Sheet spreadsheet to track what you want as Sheet has a 'googlefinance()' function to look-up the same prices and data you can enter and track in a Google Finance ...
davmp's user avatar
  • 2,283
4 votes
Accepted

Google stock graphs: What does the percentage point refer to?

Tesla has risen $211.78 during the time period demarcated by the two vertical lines. The current price is $573.00 on 4/09/20 The earlier price is $361.22 on 3/18/20 $211.78 divided by $361.22 is 58....
Bob Baerker's user avatar
  • 76.8k
3 votes
Accepted

How do I adjust number of shares after a stock split on google-finance?

The only ways I see to adjust a portfolio on Google Finance are to delete a position and to record a transaction. Depending on whether the cost basis of the original lot was adjusted, you could either ...
D Stanley's user avatar
  • 137k
3 votes
Accepted

Why does historical price data not go back all the way on Google Finance?

Google Finance and Yahoo Finance have been transitioning their API (data interface) over the last 3 months. They are currently unreliable. If you're just interested in historical price data, I would ...
rocketman's user avatar
  • 907
3 votes
Accepted

Splits shown in historic data in Google Finance vs Yahoo Finance

Actually there was no split in GOOG on 27 Mar 2014. What happened is as follows: Google Inc (at the time, now called Alphabet) had class A shares trading as NASDAQ:GOOG. In early 2014 it announced ...
Richard at NorgateData's user avatar
2 votes
Accepted

Why are historical prices of stocks different on different websites? Which one should I believe?

On Monday, the 27th of June 2011, the XIV ETF underwent a 10:1 share split. The Yahoo Finance data correctly shows the historic price data adjusted for this split. The Google Finance data does not ...
not-nick's user avatar
  • 6,418
2 votes

Moving from Google Finance to Yahoo Finance

Perhaps you should use your own tracking software, such as GnuCash, Quicken, Mint, or even Excel. The latter would work given you say you're manually putting in your transactions. There's lots of ...
davmp's user avatar
  • 2,283
2 votes
Accepted

What happens if I get approved for financing, but don't make the purchase?

Nothing will happen. It will not affect your credit score. You are not in trouble. :) Assuming that you didn't already agree to a purchase contract, you are not obligated to purchase simply because ...
Ben Miller's user avatar
  • 116k
2 votes

Why is some data missing on google finance for historical quotes

Data from both Yahoo Finance and Google Finance have been unreliable for over a year. Suggest that you investigate other financial data aggregators; some very good free ones are Tiingo, Barchart, and ...
rocketman's user avatar
  • 907
2 votes

NVDA stock After Hours spike on Google Finance

Answer: something else (it's complicated!) After-hours and pre-hours trading is not subject to any price barriers or halts, and is mostly unregulated accordingly. Trading errors/spikes are a ...
Richard at NorgateData's user avatar
1 vote

NVDA stock After Hours spike on Google Finance

This is a frequently asked question. More often than not, sharp spikes are due to bad data. For example: Bad Data 1 Bad Data 2 Bad Data 3 and so on ...
Bob Baerker's user avatar
  • 76.8k
1 vote

Get Revenue Details in Google Sheets using Google Finance

The documentation for the GOOGLEFINANCE API lists the attributes that are available depending on the type of security you're querying. None of them give you any detail about revenue - the closest is ...
D Stanley's user avatar
  • 137k
1 vote

I am struggling to work out this bond formula

I am not familiar with the formula you used. The value of the bond is the present value of all its coupons plus the present value of its payments. So, if we assume that the bond is going to pay off ...
Bob's user avatar
  • 1,711
1 vote
Accepted

Can GoogleFinance function produce an analyst recommendation?

An analyst recommendation is a recommendation provided by an analyst; a human being who works out statistically by various means whether the stock is under- over- or fairly priced. Most news sources' ...
MD-Tech's user avatar
  • 9,023
1 vote

Why is some data missing on google finance for historical quotes

From the perspective of a data vendor, the answer is quite simple. This should not occur. We have multiple data sources for US stock data, and none of them showed any issue for NASDAQ:STWD on ...
Richard at NorgateData's user avatar
1 vote

Why are Key Statistics for the same company different on various sites?

There is a calculation for this which is based on an estimate: Return on Equity %: The current fiscal years estimated earnings per share (EPS) divided by the book value per share. which can vary ...
Paul Sweatte's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible