If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

North American Stock Market Indexes with 52-Week Performance Chart

Thread starter DRSteele
Start date Jul 16, 2020

Overview Discussion

DRSteele

Well-known Member

Jul 16, 2020

DRSteele submitted a new Excel article:

North American Stock Market Indexes with 52-Week Performance Chart - Using Excel's new Data Type for Stocks, we can easily generate a list of stock market data

In an effort to help those struggling to find stock names and symbols for Data Types | Stocks, I put in some effort. I have uploaded to OneDrive a file containing all the stocks in the TSX Composite, the Dow Jones Industrial Average, the S&P500 and the NASDAQ100, current as of July 2020. Refresh All will update the entire file, and the Tables can be sorted any way desired. Included are hyperlinks that open a web browser...