How to Create a Database of Stock Prices, Commodity Prices, Stock Price Indices and Economic Data.
Originally published: 11/12/2018 16:12
Last version published: 16/06/2019 10:56
Publication number: ELQ-59544-2
View all versions & Certificate

How to Create a Database of Stock Prices, Commodity Prices, Stock Price Indices and Economic Data.

This tool helps the user to create a database of stock and economic metrics, accompanied by a step-by-step method.

This tool, brought to you by Ed Bodmer, is a detailed guide which explains the process of creating a database, comparing:

- Historic stock price indices
- Commodity prices
- Stock price indices
- Economic data

This database can be updated automatically, with new dates and new series, such as stocks, economic series, commodity prices and stock indices.

To use this file, it is a simply a question of entering stock tickers, symbols for stork indices, commodity price symbols from the Federal Reserve Economic Database (FRED), and codes for economic series.

This tool will explain include tips, videos and a PowerPoint to demonstrate how to do so.

The file attached will import data from Yahoo finance monthly. It is possible to change the importation frequency to daily or weekly, for example.

Also included is an easy to follow guide on how to use stock, commodity and economic database sections. There is a blank file attached to be used for working through the steps, with a second file showing the completed version.

If you have any questions or problems that arise, don't hesitate to start a discussion below, or e-mail me at To access more of my tools and templates, please visit my channel page.

This Best Practice includes
3 Excel Spreadsheet

Acquire business license for $10.00

Add to cart

Add to bookmarks



keyboard_arrow_downShow all

People using this Best Practice also downloaded


More Best Practices from Prof. Ed Bodmer

See all

Any questions on How To Create A Database Of Stock Prices, Commodity Prices, Stock Price Indices And Economic Data.?

The user community and author are here to help. Go ahead!

4.4 / 5 (12 votes)

please wait...