Importing market data into Excel is the first step in building a trading model. Market data such as prices, volume, spreads, dividends, etc. is needed to feed a trading model’s calculations.

There are several ways to get market data into your Excel spreadsheet. Click on the links below to learn more about each method:

Manual entry or copy-paste
Text file import
Real time DDE link from a data vendor or broker
Web Query to a free Internet data provider
SQL to a market data warehouse or “data farm” database