ARGUS Direct for Spreadsheets

ARGUS Direct for Spreadsheets

Argus Direct spreadsheets

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.

ARGUS Direct for Spreadsheets recent updates

Argus Direct for Spreadsheets version 6.2.1

Release date: 30 Aug 2021

Enhancements

  • Changed default encryption protocol to TLS 1.2

 

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.