Excel static provider

Modified on 2017/03/30 07:10 by Eugene — Categorized as: Providers

What is it

This is a static provider that allows access to historical data stored in Excel 97/2010 files (XLS and XLSX formats). It can be helpful to quickly browse an occasional Excel document without having to export its data to CSV. Read a special note at the bottom regarding XLSX files.

Note to Wealth-Lab 64-bit edition users

Important: On 64-bit operating systems (x64), installed Microsoft Access Database Engine 2010 Redistributable is a prerequisite.

If you plan to use 64-bit WL6 on a 64-bit OS, please download and install AccessDatabaseEngine_X64.exe, if you need to get back to using 32-bit WL6 on a 64-bit OS, uninstall the 64-bit ACE (Access Database Engine) and install AccessDatabaseEngine.exe, andd vice versa. Both drivers can not be installed and used simultaneously.

The Excel provider will not work on x64 systems if no ACE 2010 driver was installed. Finally, Access Database Engine 2007 is not suitable as it doesn't have a 64-bit driver.

Setup

Follow these steps to set the provider up:

  1. Point to an Excel 97/2010 (XLS/XLSX) file by clicking on the "File..." button.
  2. The checkbox "Header in first row?" should be enabled if the first row contains column names e.g. "Symbol", "Date", "Open", "Close" etc. and cleared if the spreadsheet contains data only.
    • If you've modified this checkbox by mistake, you will need to select the Excel sheet again.
  3. After setting the checkbox, select an Excel sheet containing DOHLCV data.
  4. Select the column containing symbol name(s). This will populate the preview box on the left.
  5. Finish the DataSet creation by assigning proper columns for Date, Open, High, Low, Close and Volume (custom series are optional). Make sure the data types are assigned properly!

Setting up an Excel DataSet

Setting up an Excel DataSet


Resources

Below are some resources of publicly available data the Excel provider can be used with:


Notes and limitations