EasyData Excel Add-In user manual

The EasyData Excel Add-In enables users to update Excel spreadsheets containing data queries with the latest up-to-date data from EasyData.

What is a data query?

A data query is a selection of time series indicators saved in an Excel file. A file with one or more data queries can be refreshed at any time to update the file with the latest available data points. Data queries save time by eliminating the need to find and download selections of time series every time an EasyData user wants to obtain the latest data points.

Requirements

1. You need a subscription to the EasyData service to use the EasyData Excel Add-In.
2. You need Microsoft Excel to use the Add-In.

Obtain the EasyData Excel Add-In.

The EasyData Excel Add-In can be found in the Office Store.

1. Open Microsoft Excel.
2. Click on the Insert menu item.
3. Click on Get Add-ins to find and add the EasyData Excel Add-In to your Excel.

Download a selection of time series indicators as a data query from the EasyData website

1. Visit www.easydata.co.za in your preferred browser and log in.
2. Click on Selections next to the EasyData logo.
3. Click on one of your selections to view the selection.
4. Click on the Download button and download the .xlsx file.

Refresh an existing data query with the latest available data points

1. Open the file in Microsoft Excel.
2. Click on the Add-ins tab.
3. Click on the Launch icon in the EasyData Add-In.
4. Log in with your EasyData credentials.
5. Click on the Find data queries on worksheet button.
6. Click on the Refresh data queries button to update the workbook with the latest up-to-date data from EasyData.