3

Comparing the data on google finance

https://finance.google.com/finance/historical?q=stwd&start=60&num=30&ei=DgUZWqCTBMi2uASdl4u4CQ

and on nasdaq

http://www.nasdaq.com/symbol/stwd/historical

The open and low data for Jul 31, 2017 is missing or shown as dash.

enter image description here

while on nasdaq that data is there Why is that so?

1
  • One explanation is that the market maker makes a change on behalf of the government that legislates it. They don't want you to see what it looks like when a dark pool tops off from empty, or empties from full, and other variations, and see a volume data point 7 orders of magnitude bigger than biggest one in the last 10 years. In any case, there is information gain between missing data and above average variance in the price, doubly so when back filled later, there could be a self fulfilling prophecy component. Market maker's behavior moves price and can withhold mass reappropriation events. Jan 9 at 19:08

2 Answers 2

2

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 Quandl. Each has a very easy API (application programming interface) and they only require you to register an email address. There are restrictions on the amount of data you can grab everyday, but those limits are very generous for a single investor.

I am not associated with Tiingo, Barchart, or Quandl. While initially using Yahoo and Google finance as data feeds, I have now switched entirely to the other three. Their data and API is much easier to deal with.

1

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 20170731.

The only logical conclusion is that there's an issue with Google Finance. You should contact them for support to fix the omitted data.

NASDAQ:STWD had the following Open, High and Close for 31 Jul 2017: Open: 21.96 High: 22.09 Low: 21.88 Close: 22.04

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .