Latest Lists

Where can I find a daily complete list of the opening prices in column form of all ETFs Exchange Traded Fund?

I have created an excel spreadsheet for tracking each ETFs (Exchange Trading Funds) performance. One piece of data that I enter for each trading day is the opening prices for ETFs. Presently I look up the individual opening price through my brokerage account, but this is extremely time consuming. I download the percentage of return performance (YTD year-to-date, 1 minth, 3 month, 1 year and 3 year) presently from Morningstar and IBD (Investors Business Daily) but this does not give me the daily opening price. Thank you.

Public Comments

1. MSN has an add-in for Excel that allows direct downloads to a spreadsheet. It's free and should allow you to solve your problem.