Support Center

Excel Addin

Last Updated: Apr 11, 2016 09:20AM UTC

About the Data Hub and Data Hub (Plus)


The Utilidex Addin is available for download direct from the Microsoft App Store.  The Addin is available in two versions:
 
  • Utilidex Data Hub
  • Utilidex Data Hub (Plus)


The Utilidex Data Hub product contains energy market data, including network price information and energy price information.  We will be adding data elements throughout the rest of Calendar year 2016, based off user feedback.  

The Utilidex Data Hub (Plus) product is for current customers of utilidex, who have already signed up for one of the starter, standard or enterprise editions.  In addition to accessing energy market data, customers can also download their energy data direct from their Hub.

For more information on the different packages, and products of utilidex please visit www.utilidex.com or contact us on enquiries@utilidex.com
 

Downloading the Addin


You will be able to download the excel app direct from the Microsoft App Store.  Simply click on the Store, located in the Insert Tab and search for Utilidex.  Then select the appropriate version, and click on insert.  Please download the Data Hub package if you simply wish to have energy data (and don't have a current Utilidex Starter, Standard or Enterprise Package) or use the Data hub (Plus) package if you have a Starter, Standard or Enterprise Package product from utilidex.


Navigating around, using the tiles


All data is available by clicking on the relevant tiles on the side pane, in Excel.  When using the Data Hub (Plus) Product you will be presented with Market Data and My Data tabs.  In the Data Hub Product you will go straight through to the Energy Data and Network Data.

Below is an example of the screen available by clicking on the My Data tab.  In the below example, we now have the ability to check Trades, Positions, Forecasted Data, Within Day Prices and Metering.


Reviewing your energy data

 

In order to view your data, first select the cell within Excel that you wish to return data to (in the below example we have opted for A1).  Select one of the panes of data (Trades, Position, Forecast, Pricing, Metering) and you will be presented with the key inputs to complete:  





Select the date range and data that you would like and when you're ready hit on the submit button and your data will be returned direct into Excel:



Downloading the Addin

 

Our goal with the Excel Addin is to enable you to easily download data and analyse this direct in excel.  Whether that is important energy market data (energy prices, network charges) or your own data from the Hub.  We're always interested to receive feedback on what extra data sources you would like to see in the product, so please email enquiries@utilidex.com to request further data items that you would like to see added.

Contact Us

  • Email Us
  • One Canada Square
    Canary Wharf
    E14 5AB
617efc3528f9a59d486332f8e9b8115c@utilidex.desk-mail.com
https://cdn.desk.com/
false
desk
Loading
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
about
false
Invalid characters found
/customer/en/portal/articles/autocomplete