Infront toolbar and right-click menu in Excel

 

When the add-in is loaded in Excel, a tab called Infront appears in the menu bar.

 

 

Click this tab to show the Infront toolbar, which is the starting point for all add-in functions.

 

Infront toolbar

 

The Infront toolbar has the following commands:

  • Connection: enter here your account credentials to allow the add-in to connect to the Infront Analytics platform; to avoid entering your password multiple times, you can click the Advanced Settings link and check the Save Password option in the Options dialog.
  • Refresh Workbook: refresh all Infront Analytics data tables in either the active workbook or the active worksheet.
  • Quick Report: create a new Quick Report from scratch.
  • Time Series: create a new Time Series from scratch.
  • Download List: download the constituents of a personal list, a market index, or a predefined list of comparable companies.
  • Model Library: access our library of pre-built Excel models.
  • Function INFGET(): insert or edit the INFGET() function from the dedicated panel.
  • Recalculate Formula: recalculate all formula in the active workbook.
  • Restart Engine: cancel pending data updates and restart the add-in when it does not seem to respond.
  • Options: view and edit add-in options such as preferences for Excel startup or connection mode.
  • Help Center: access Help Center articles, contact Infront Analytics support, check the latest release notes, or check your add-in version, installation path and get the latest add-in updates.

 

Infront options in right-click menu 

Some additional options appear in the right-click menu:

  • Company Code Lookup: convert a company name/ISIN code/ticker into a Company Code (Infront Analytics company identifier).
  • Upload List of Companies: upload to the web a new personal list from a list of Company Codes in Excel.
  • New INFGET(): insert the INFGET() function from the dedicated panel 
  • Edit Function: edit an INFGET() function that has been inserted in the sheet 
  • Audit Function: get the audit trail on the INFGET() function that has been inserted in the sheet 
  • Field Picker: get the list of all available field items for the INFGET() function and pick the one you need