| | | >> | Task: Download historical stock data for the past three months for Microsoft Corp. (MSFT) and Intel Corp. (INTC). Next >> - Start Microsoft Excel and create new workbook (click
icon on the Excel toolbar). - Select
item under the BulkQuotesXL menu to create new download project worksheet: - Enter MSFT and INTC tickers into Ticker column:
- Select B2 cell and enter string "=TODAY()-90" to set default-for-all-tickers Start Date to date 90 days ago:
- Select C2 cell and enter string "=TODAY()" to set default-for-all-tickers End Date to Today's Date:
- Leave default-for-all-tickers Periodicity as daily; Data Direction as FTB (From Top to Bottom); Data Location as AUTO (spreadsheet names will be generated automatically); Data Beginning as A1 (upper-left cell of downloaded data); Data Source as Yahoo; Data Fields as DTOHLCVP:
- Select
item under the BulkQuotesXL menu to start download process. Task Results - Two worksheets will be created named INTC and MSFT.
- Historical data will be downloaded for past three months.
- Resulting status message will be written to K column for each ticker.
Next >> | | | | |