A new version of the Excel Plugin has been released. Read about it here.
Excel Data Workstation v3 is an advanced Microsoft Excel add-in (or plugin), free to download and install for Oxford Economics clients. EDW v3 fulfils our desire to make it really easy to work in Excel with subscription content drawn from Oxford Economics' online data & research services, and desktop modelling and forecasting software. Economic forecasts for 200+ countries, 100+ industries, and 4,000+ cities can be pulled directly from the Global Data Workstation and/or the Global Model Workstation. Hundreds of latest analysis & research articles from My Oxford can be retrieved and searched. The user experience is focused on speed and simplicity without requiring you to leave Excel.
Customers must have a subscription to one or more of the following products/services to take advantage of the facilities in Excel Data Workstation:
- Retrieves forecast data series from either Global Data Workstation or Global Model Workstation.
- On-demand refresh of data using built-in automation of Excel Data Workstation commands.
- Direct model database connectivity, retrieval can include residuals, stacked quarters layout, and multiple measurements
- Direct export of sheet data to local model databases and Eviews
- A browser for viewing the latest analysis from Oxford Economics from within Excel
- New scripting commands, including the ability to automate direct model database connections
- Improved high quality charts
- Zero installation – double click to run
- Application is code-signed with a trusted Oxford Economics' digital security certificate
- Big speed and data formatting improvements
- Refreshed plugin data sheets co-exist nicely with your other worksheets
Download the latest EXE installer file by clicking the link below: http://tools.oxfordeconomics.com/ExcelPlugin/Downloads.aspx
Follow the instructions below to download and install the latest version of Excel Data Workstation. Once installed, an Oxford Economics menu item will appear in Microsoft Excel. Click on this menu to show a ribbon holding a number of functions as shown in the figure following.
- Microsoft Windows versions greater than Windows XP (i.e. will not work in Windows XP)
- Microsoft Excel 2007 | 2010 | 2013 | 2016 (64-bit recommended)
- An active internet connection to use the online Global Data Workstation
- Remove or disable all older versions of the Excel Data Workstation
To begin, first ensure you meet all of the prerequisites listed above. Especially, check that all earlier versions of the Excel Data Workstation are removed or disabled. If not, please go into Add/Remove Programs find the Oxford Economics Excel Data Workstation, and uninstall.
Next, extract the .XLL files from your download, select and double click the version corresponding to your version of Excel (i.e. either 64- or 32-bit), and Excel will open with the Oxford Economics menu loaded. You will be prompted to load the plug-in automatically.
We recommend you mouse over the controls to read the fairly detailed tooltips provided. This is a good way to quickly get an idea of the features available.
Mondrian Dashboards v4
- You can freely download 44 high quality charts in five dashboards of key economic forecast indicators.
- Dashboards available for both annual and quarterly data series.
- Dashboards cover all locations and 36 indicators in all measurements.
- Reproduces all the built-in dashboards of the new Global Model Workstation and Global Data Workstation:
- Forecast/Scenario Overview
- GDP and its components
- Inflation and its determinants
- Trade and balance of payments
- Labour market
(Documentation for v4 Mondrian dashboards is the same as v3, which can be found here.)
The user guide is available in Excel Data Workstation by clicking on General | Arrow to open the About box and then choosing User Guide to open the user guide PDF document in your default PDF reader application.
The version number of the user guide distributed with EDW is consistent with the installed version of the add-in.
Click here to download the latest user guide without installing Excel Data Workstation.
James Mills is a Software Developer at Oxford Economics.
Arvindra Sehmi is Chief Information Officer and Director of IT at Oxford Economics.