Talk:Dow Jones Industrial Average

From Geohashing

This phrase "Opening of the Dow Jones" seems to be used very loosely. Could it be made somewhat more explicit? Whose figure is used? I complain because [1] effectively says that there's no such thing as the "opening" of the Dow - instead it's the NYSE that opens, and the Dow is just computed from that. For the time calculation, how about less ambiguity like referring directly to 9:30am New York Time (if that's correct), or something? 130.194.80.156 08:32, 20 June 2008 (UTC)

Nearly every finance-page lists the value for the DOW's "Opening". No matter how it is defined internally, that's simply the value used for the calculation. --Hermann 22:58, 3 July 2008 (UTC)
Nearly every finance-page lists a different DJ opening value. Channel N24's teletextpage, which you added to this page for manual use, only shows one decimal place, as does channel Pro7. If I use that value in my offline calculator, I get coordinates which are different from irc.peeron.com. Channel n-tv shows 2 decimal places, but yesterday (2008-09-17) they were slightly different from irc.peeron.com, leading to very different coordinates. This either means that there are multiple correct coordinates for every day (which I think is not a good idea) or that only the official implementation's coordinates (i.e. the finance.google.com opening value, which seems to be identical to finance.yahoo.com's) may be used. Danatar 15:11, 18 September 2008 (UTC)
Ack, and as we found out the hard way, the value is still being adjusted after its initial posting. -- Relet 20:00, 18 September 2008 (UTC)
The comic itself reserves space for two decimal places. Do sources agree on the value of these at least? Let's find out how that opening value is actually calculated. -- Relet 20:49, 30 September 2008 (UTC)
I don't know what n-tv lists as opening price, but it differs so blatantly, that it must be something different. Possibly the dow jones index at the opening of the European stock market? -- Relet 21:06, 30 September 2008 (UTC)

Here are lists of historical prices of the DJI from various sources: Anybody find a difference? -- Relet 21:01, 30 September 2008 (UTC)

N-tv differing wildly from everything: http://www.derivate.n-tv.de/showpage.asp?pageid=72&inbwnr=387 <- "Eröffnung" means opening.

Opening differs between Yahoo and Google for August 24 2010! --Fasanen 09:23, 26 August 2010 (UTC)
Where did you see this? Here are the values that were retrieved automatically for 2010-08-24 by my "source" with the corresponding timestamps (DJ local time):
djindexes.com      10173.0498047000  2010-08-24 09:30:22
finance.yahoo.com  10173.0500000000  2010-08-24 09:30:43
google.com/finance 10173.0500000000  2010-08-24 09:31:03

--Crox 05:14, 27 August 2010 (UTC)

I visited the Yahoo link above. It displays an opening of 10170.86 for 2010-08-24. --Fasanen 06:34, 27 August 2010 (UTC)
that's obviously a mistake/bug then :o) it's not uncommon, that's why my source waits for three different sources to agree before giving out the opening value... --Crox 16:49, 27 August 2010 (UTC)
Good strategy. Geohashing seems like operating a space shuttle ;-) When in hands of finance, figures can be all over the place! I'll report the error to Yahoo and never trust them any more :-) --Fasanen 18:06, 27 August 2010 (UTC)

2012-05-29

something strange happened today... at 09:30 yahoo, google and djindexes.com all reported an opening value of 12455.36 (12455.3603516), but somehow later they all changed their mind and now report 12454.83 (12454.8300781) instead. I've now updated my source to reflect the change. --Crox 18:05, 29 May 2012 (EDT)

2013-04-25

Not sure if it's a new issue or not, but the Yahoo! page(s) linked to no longer provide valid data. The "quotes.csv" file contains merely "Missing Symbols List." and the Yahoo! page (ichart.finance.yahoo.com/etc.) returns a 404. Nessalc (talk) 10:28, 25 April 2013 (EDT)

KML calculator

I have made a calculator the relies on your DJIA source. I'm assuming that if it gains in popularity, other calculators will be used less so your server load might stay about the same. Is this OK with you? Thanks. --Sourcerer (talk) 16:17, 17 January 2016 (EST)

Hi Sourcerer, was this comment addressed to me? In any case I'm not worried. By the way your KML tool also works with Marble (although I haven't tested it extensively yet). Regards, --Crox (talk) 13:00, 23 January 2016 (EST)

2018-12-18

For the record: on 2018-12-18, Yahoo initially showed 23986.83 (ie the correct value for 2018-12-17), then changed to 23769.10. Other sources (WSJ, MSN, Google) show 23769.13. --Crox (talk) 17:00, 18 December 2018 (UTC)

I think you were right to use 23769.13, everyone but Yahoo seems to use it, including nyse.com. --Fippe (talk) 18:27, 18 December 2018 (UTC)

2019-03-18

This has never happened before... Looks like everyone changed their mind shortly after 09:30. 

 | 2019-03-18 | finance.yahoo.com   | 2019-03-18 09:30:11 | 25720.9600000000 |
 | 2019-03-18 | msn.com             | 2019-03-18 09:30:11 | 25720.9600000000 |
 | 2019-03-18 | quotes.wsj.com      | 2019-03-18 09:30:11 | 25720.9600000000 |
 
 | 2019-03-18 | finance.yahoo.com   | 2019-03-18 09:31:45 | 25801.8800000000 |
 | 2019-03-18 | msn.com             | 2019-03-18 09:31:45 | 25801.8800000000 |
 | 2019-03-18 | quotes.wsj.com      | 2019-03-18 09:31:45 | 25801.8800000000 |

I obviously need to add a check to fail when the opening matches the previous value. This happened before, but never on different sources at the same time so it was not an issue.

--Crox (talk) 14:07, 18 March 2019 (UTC)


And it's not getting better:
 | 2019-03-18 | finance.yahoo.com   | 2019-03-18 10:11:07 | 25721.0000000000 |
 | 2019-03-18 | msn.com             | 2019-03-18 10:11:08 | 25801.8800000000 |
 | 2019-03-18 | quotes.wsj.com      | 2019-03-18 10:11:08 | 25801.8800000000 |
Since Google is now reporting 25801.88 too, we'll just ignore Yahoo.
--Crox (talk) 14:19, 18 March 2019 (UTC)
So this means geohashing.info is incorrect, which is a pity - I like the point there better :) --Thomcat (talk) 15:23, 18 March 2019 (UTC)
Fixed my database--Eupeodes (talk) 20:50, 18 March 2019 (UTC)
FYI the additional safety check is now in place (opening value cannot be equal to opening value of the previous day even if all sources agree), and as far as I can tell it's working properly.
--Crox (talk) 22:23, 20 March 2019 (UTC)
Retrieved from "https://geohashing.site/index.php?title=Talk:Dow_Jones_Industrial_Average&oldid=67652"
Powered by MediaWiki