Description

Argus Link is an add-in programme that enables users to access Argus Media data directly in MS Excel ^TM.  The add-in makes it possible to select Argus energy price data from a commodity selection tree and to import the data into Excel to perform data analysis.

System Requirements

The add-in requires the following software installed (note: clients may need system administrator privileges to install/update this software):-

• A windows PC
• Microsoft Excel 2003 sp2
• Microsoft .NET Framework v1.1.4322 (Not the same as .NET Framework v2 or v3, though they can be concurrently installed)
• Active Internet access (HTTP port 80)

 

Argus Link needs a valid user name & password for link to be active.

 

Download here: ArgusLink

 

Frequently Asked Questions

Installation issues

1. I cannot install Argus Link

In corporate networks, computer usage policies and software management controls often require software to be installed by authorised network personnel, please check with your IT department.

2. I have installed Argus Link but the menus and tools bars are not displayed in Excel

Excel has a feature to disable 3^rd party software add-ins.  In Excel select Help, About Microsoft Office Excel (or About Microsoft Excel), Disabled Items  if this line “addin:Argus Excel addin” appears deselect and then restart Excel.

For users of early versions of Argus Link, the add-in could be installed twice simultaneously, preventing either from working.  If the add-in appears twice in control panel add or remove programs, uninstall both versions and re-install from the download location.

Updating issues

From time to time the Argus Link is updated. The add-in will detect the existence of a newer version at this stage the user may either update or ignore the notice.  If you ignore the update the next time you start Excel and use Argus Link you will be prompted to update again. Argus advises clients to keep the add-in fully updated, any support issues will always start with checking the latest installed version.  The version is available from the Argus drop down menu in Excel.

1. I have been prompted to update but it failed?

Once you select update you must close Excel (and save any open workbooks) before selecting the “Run” option.  You can “Save” the new add-in and install later if you wish.

Using Argus Link

1. How can I change the delivery/contract timing/period for the data selected?

Use drop-down list in the "period" column in the bottom section of the add-in window.

2. What is the "conversion unavailable" comment I get in some cells?

No conversion factors exists in the system or conversion is impossible

3. Why do I find discrepancies in some values when I convert a price using currencies and units?

While we endeavour to be as accurate as possible, discrepancies can occur in the conversion process due to the rounding of conversion factors held in the Argus database.

4. I cannot find an assessment or my search returned empty cells. Why?

There are several possibilities why some prices are not available to you:-

• You may not be permissioned for them.
• The date range you are permissioned to see, is outside the requested date range.
• You may have select a date range where an assessments doesn't have values (either not started or discontinued).
• You are looking for discontinued assessments and have not selected the  "include inactive prices" check box.

Please contact the Argus support team if you believe the assessment you're look for is missing from the list. support@argusmedia.com

5. Why is the returned data shaded blue?

The returned data is part of an embedded query, to allow for complete removal and to clarify to users what is part of this query the data is both shaded and protected.  Users are advised to use value lookups or Excel formula to work with the returned data rather than to directly manipulate the returned data.  Good practice, we suggest, would be to use one worksheet to return all Argus data queries and a separate worksheet to analyse the data.

6. If a data query does not work as I expect, how can I get help without sending an Excel file that may contain sensitive corporate information?

The data query(s) used to extract Argus data can be saved as separate files, (named *.aastor)  Open Argus Link with the active cell in the workbook inside the boundaries of an Argus data range.  The active query should be displayed in the tool.   Select “Save from the top left of the tool” and name the query, the file extension *.aastor will automatically be added.  Send this file to Argus support support@argusmedia.com and we will replicate the query in a neutral excel file and return it with any necessary adjustments.

Miscellaneous issues

1. Is an API for Argus prices available?

Yes. Please contact Argus sales team for details: sales@argusmedia.com

For all other queries, contact support@argusmedia.com