Technical analysis software add-ins for Microsoft Excel.
Home|Products|Order|Downloads|Support
Task 1: RSI>>Download data

Task: Download historical stock data for the past three months for Microsoft Corp. (MSFT) and Intel Corp. (INTC).

Next >>
  1. Start Microsoft Excel and create new workbook (click icon on the Excel toolbar).
  2. Select item under the BulkQuotesXL menu to create new download project worksheet:
  3. Enter MSFT and INTC tickers into Ticker column:
  4. Select B2 cell and enter string "=TODAY()-90" to set default-for-all-tickers Start Date to date 90 days ago:
  5. Select C2 cell and enter string "=TODAY()" to set default-for-all-tickers End Date to Today's Date:
  6. 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:
  7. 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 >>
Home|Products|Order|Downloads|Support