New answers tagged

0

It appears that Google doesn't support downloading data for the Dow Jones Industrial Average and quite possibly the S&P 500 Index too. See the end of this thread: http://www.mrexcel.com/forum/excel-questions/471110-web-query-obtain-historical-stock-data-using-google-finance.html.


3

1 - For historical reasons options expire on Saturdays, before noon. This has to do with potential reconciliation issues that are largely gone nowadays because of back-office automation. Practically, you can think of SPX index options as expiring at index settle, which is 4:00 pm EST on Fridays for PM expiring options, or 9:30 am EST on Fridays for serial ...



Top 50 recent answers are included