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.
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.2.0
Release date: 07 April 2021
Enhancements
- Added “Always use current date” option for period End Date
- Proxy server handling now includes “Use system proxy settings” option
- Added support for Excel named tables
- Access to log file and settings file made easier by right-clicking “About” dialog box
- Added redundancy to query definition storage, mitigating accidental loss of queries
- New query definition export file format (.adquery) added allowing to save/load all queries in a workbook
- Added batch update controls for periods and units for selected series (if applicable) added
Bug fixes
- Minor bug fixes
- Bug related to OLE/DDE timeout fixed
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.