ARGUS Direct for Spreadsheets
The Argus Direct for Spreadsheets platform is a tool that enables subscribers to download Argus prices and other data directly into Excel. It is easy to create spreadsheet templates containing key prices that refresh automatically. Excel functionality can be used in the normal way to create charts, pivot tables and other types of output. The menu provides access to Argus' range of data, and users can specify price types (e.g. daily prices, midpoints, monthly averages), currency, date ranges and other options.
Downloadable data template
The Argus Direct platform add-in for spreadsheets enables customers to download, manipulate and integrate data within Excel. The Argus Direct platform subscribers can download the Excel add-in here. An installation guide and user manual are also available.
Argus has created sample data templates for key products designed to assist subscribers with downloading and using Argus data inside Excel. Once the add-in has been installed, these templates can be downloaded, saved and then refreshed, pulling through the latest data. Subscribers can also amend their spreadsheets to add or include data.
Please note that as multiple options are available with the add-in, such as changing currency or unit, numbers may differ slightly from those published in the corresponding reports.
For assistance with any aspect of Argus Direct, contact support@argusmedia.com or call your local office.
Useful links
After you download the Argus Direct for Spreadsheets Excel add-in:- Access the user guide
- Review the installation guide
- Read frequently asked questions
For more information about the Excel add-in or any other aspect of the Argus Direct suite of services, contact support@argusmedia.com or call your local office.
ARGUS Direct for Spreadsheets recent updates
Argus Direct for Spreadsheets version 6.1.5
Release date: 03 November 2018
Enhancements
- Allowed selective refresh: single table, whole worksheet or whole workbook
- Added an option to display metadata used in price series coding
- Added highlighting of inactive series (if enabled)
- Allowed movement of resulted dataset within a worksheet without a need to redefine the query
- Added more configuration parameters into Settings dialog box
- Metadata caching mechanism updated
- "Add All" button added to choose all pre-filtered series and place into selection box
Bug fixes
- Minor bug fixes
Argus Direct for Spreadsheets version 6.1.4
Release date: 11 January 2018
Enhancements
- Made compatible with the latest Microsoft updates (resolved installer "manifest file" issue)
- Changed the handling of series that are no longer permissioned to a user (lifted restrictions on the editing/refreshing queries with inaccessible price series)
- Suppressed update notification popup on the minor version number change
Bug fixes
- Minor bug fixes
Argus Direct for Spreadsheets version 6.1.3
Release date: 22 August 2017
Enhancements
- Added support for "Sheet!A1" syntax in cell selection
- Forward curves data retrieval added
- Search improvements
Bug fixes
- Minor bug fixes
Argus platforms
Learn about the various delivery methods we offer to ensure that you have access to our reports, prices, market insight, fundamentals data and news in ways that empower your business decisions.