stock exchange averages in a cell

I am using office 365 Excel and wish to have the Dow Jones Industrial, the S&P 500, and the Nasdaq averages each downloaded into their respective cell. Is there a way to get these numbers off the internet and into Excel? (either writing a function or purchasing a commercial add-in)
Ollie Mayes

Alan - Thanks for the response, but I still need help.
I downloaded and followed the readme instructions.
When loading the PMStockQuote,xlsx spreadsheet, I get the following message

The file format and extension of PMStockQuote.xll don't match.

If I load anyway I get over 3,000 lines of binary code.
If I do not load, the spreadsheet opens in protected mode and if I enable editing, nothing works.
Did I miss something on the download website?
Ollie

Alan,
The formula works perfectly, but I really want the end of day averages for S&P 500, Dow 30, and Nasdaq.
I went to the finance.yahoo web site and see these averages listed at the very top of the page.
I am trying to find a way to download these averages into Excel.
Perhaps there is a historical chart and I can get the last day from it
Ollie

Alan,

I found the Yahoo Index symbols (^GSPC (S&P%00), ^IXIC (Nasdaq), and ^DJI (DOW).
Using the Website formula --
The S&P and Nasdaq work perfectly and you solved the problem.
The Dow Industrials symbol returns a #VALUE. As soon as I solve this one, I will have just what I want.
Thank you very much.
Ollie

I have come to the conclusion that the DJI index is not downloadable at least from YAHOO.
I will keep on working, and I thank you very much for the formula that solved the other two.
Ollie