Release notes

See what's been improved to make the Excel Add-in even better.

Infront Excel Add-in

16.12.2020 - Version 3.24.6 - Hotfix

New features

  • None

Improvements

  • None

Bug fixes

  • Export to Excel
    Fix a bug on “Export to Excel” function from IPT, which it not working in some cases.

Known Issues

  • None

14.12.2020 - Version 3.24.5

New features

  • Server Installer now available

Improvements to existing features

  • User Installation
    Major stability improvements.

Bug fixes

  • Functions Module
    Fix a bug on panels, which in some cases, the Functions module crash when Internet connection was lost.

Known issues

  • None

13.12.2020 - Version 3.23.3 - Hotfix

New features

  • None

Improvements

  • None

Bug fixes

  • Excel add-in files
    Update expired certificate.

Known Issues

  • None

09.11.2020 - Version 3.23.2

New features

  • INFGET() panel
    Add new widget Company Info (default estimates/fundamentals source & template)
  • Excel ribbon
    Add new option to switch interactively between standard Excel errors (#N/A) and detailed errors.
  • HTTPS proxy
    Handle personalized HTTPS proxy (OLB case).

Improvements

  • INFGET() Audit panel
    Improve error messages on audit panel.
  • Quick Report
    Improve behaviour on large QR with more than 3000 companies/instruments codes.
  • INFGETTABLE() function
    Improve error message

Bug fixes

  • INFGET() panel
    Fix a bug on date picker (in some cases today’s date couldn’t be selected).

Known Issues

  • None

26.10.2020 - Version 3.22.4 - Hotfix

New features

  • None

Improvements

  • None

Bug fixes

  • Connection
    Fix a bug on connection tab, which in some cases crashed Data Engine application.
  • Quick Report
    Fix a bug on big Quick Report (over 3000 companies), which in some cases, stopped the refresh.

Known Issues

  • None

19.10.2020 - Version 3.22.3

New features

  • Infront Estimates details
    Add new function INTGETTABLE(companyCode, "ESTIMATESASREPORTED", advanced_parameters).
  • CITRIX environment
    Handle CITRIX environment.
  • Proxy settings
    Handle SOCKS proxy and HTTP proxy.

Improvements

  • Data Engine Global settings
    Add a new button on connection settings to import IPT configuration.
  • INFGET() Panel
    Add new widget on panel to display Field template and source availability.
    Improve error notification on panel.

Bug fixes

  • INFGET() functions
    Fix a bug, which in some cases, slow down the INFGET() queries calculation.
    Fix a bug, which in some cases, returns an error #Err 1006.

Known Issues

  • None

22.09.2020 - Version 3.21.4 - Hotfix

New features

  • None

Improvements

  • None

Bug fixes

  • INFGET() functions
    Change the root url from pre-production server to production.

Known Issues

  • None

14.09.2020 - Version 3.21.3

New features

  • INFGET() Function
    Add new setting to display always #N/A on error or detailed error.
  • INFGETHIST() Panel
    Add new setting to display new output header.

Improvements

  • INFGETHIST() Panel
    Improve handle of Target price frequency.
  • INFGET() & INFGETHIST() Panel
    Improve global behavior of panel controls.

Bug fixes

  • INFGET() Panel
    Fix bug on INFGET() panel, when sometimes, a future period was set.

Known Issues

  • None

27.07.2020 - Version 3.20.3

New features

  • None

Improvements

  • Update mechanism
    Improve update mechanism.
  • INFGET() panel
    Improve showing default values used on panel.
  • Global settings
    Improve global settings windows when Microsoft Excel restart is required.
  • Mail to support
    Improve “mail to support” function.

Bug fixes

  • INFGET() Panel
    Fix bug on INFGET() panel, when sometimes, a period was automatically set for Company Info fields.
  • INFGETHIST() Panel
    Fix bug on INFGETHIST() panel, on format output “full table”, when sometimes, a cell reference was wrong.
  • Engine
    Fix bug on right click menu on systray icon which not displayed in some cases.
  • Miscellaneous
    Fix bug on authentication mechanism on INFGET() which returns “#Err connection” in some cases.

Known Issues

  • None

06.07.2020  - Version 3.19.3

New features

  • INFGETDETAILS() function
    Add new array function “INFGETDETAILS” to retrieve Officers, Upcoming Events & Shareholders for a company.

Improvements

  • Time Series
    Extend back days to 90 days for intraday data.
  • Quick Report
    Change format for Outstanding Shares fields to always display in unit.
  • INFGETHIST() & INFGETDETAILS() function
    Improve array functions to support Instrument Code as entry.
  • Miscellaneous
    Improve authentication mechanism.

Bug fixes

  • INFGET() Panel
    Fix bug on INFGET() panel, when sometimes, Beta parameter is displayed for non-beta fields
  • Engine
    Fix bug on systray icon which does not appear at startup.
    Fix bug on “load add-in at excel startup” functionality, which does not work in some cases.

Known Issues

  • None

Version 3.18.2 (28th May, 2020)

New features

  • INFGET() function
    Add new field “Consensus recommendation” - (CONSRECO).

Improvements

  • INFGET() & INFGETHIST() Panel
    Add a calendar to set dates into ReferenceDate parameter.
  • INFGETHIST() function
    Add “payment date” column for dividends request.
  • INFGETHIST() Panel
    Improve documentation for INFGETHIST() function.
    Improve error notification on panel.

Bug fixes

  • Quick Report & Time Series
    Fix bug on QR & TS, when company name contains @.

Known Issues

  • None

14.05.2020 - Version 3.17.4 - Hotfix

New features

  • None

Improvements

  • None

Bug fixes

  • INFGET() Panel
    Fix bug on field selection, when in some cases, it was impossible to select one.
  • INFGETHIST() Panel
    Fix bug on field selection, when in some cases, it was impossible to select one.

Known Issues

  • None

12.05.2020 - Version 3.17.3

New features

  • New panel to build INFGETHIST() array function
  • INFGETHIST() array function
    Get history on Target Price
  • Excel Template
    New model “Earnings Consensus Estimates” built with INFGET() functions. The data are provided by Infront.
  • INFGET()
    Add new field “Days in Account Payable” - (DAYSACCPAYABLE).

Improvements

  • INFGET() Panel
    Improve error messages notifications.

Bug fixes

  • Quick Lookup
    Fix bug on Quick Lookup, when in some cases, Nordics characters were not displayed.
  • INFGET() Panel
    Fix bug on fields search, when in some cases, first letters of the search were deleted.

Known Issues

  • Auto update
    Creation of a repair-installation package to fix bug of auto update mechanism on v3.12.3

    Download.

14.04.2020 - Version 3.16.1

New features

  • New array function INFGETHIST()
  • Get history on Market Capitalization
    Get history on Outstanding Shares
    Get history on Dividends
    Get history on Close Price
  • INFGET() : New setting for default period parameter for fields which are available with historical and forecast period

Improvements

  • Engine
    Improve notification on Communication Error between Microsoft Excel and Infront Excel add-in. Creation of new help guide to solve these issues.

Bug fixes

  • Quick Report
    Fix bug on old QR, when in some cases, changing list has no effect.

Known Issues

  • Auto update
    Creation of a repair-installation package to fix bug of auto update mechanism on v3.12.3

    Download

09.03.2020 - Version 3.15.3

New features

  • New option to get updates for pre-release versions

Improvements

  • INFCODECONVERT() new output fields
    Ticker.
    Company name.
  • Engine
    Improve notification on error connection.

Bug fixes

  • Time Series
    Fix bug on Intraday timestamp.
  • Quick Report & Time Series
    Fix bug on wizard interface on Index constituents download functionality.
  • Engine
    Fix Engine crash if workbook name contains specials characters.
  • IPT users
    Fix bug on restriction on FactSet source.
    Fix bug on portfolio functionalities.
    Fix bug on Connection settings.

Known Issues

  • Auto update
    Creation of a repair-installation package to fix bug of auto update mechanism on v3.12.3

    Download

12.02.2020  - Version 3.14.2

New features

  • Full support of Microsoft Excel 2010

Improvements

  • Quick Report & Time Series
    Improve stability and performance on large amount of data.
    Improve information notification when error occurs.

Bug fixes

  • Time Series
    Fix bug on Intraday when multiples instruments are requested.
  • INFGET() - Panel
    Fix bug on INFGET() panel when absolute reference with F4 is used
    Fix bug on INFGET() panel when the 3rd parameter of the function is empty
  • INFGET()
    Fix bug (decimal issue) on multiples ratio with regional settings others than English.
  • Templates
    Fix bug on Excel templates, when using "set peers" function
  • Engine
    Fix Engine crash if workbook name contains specials characters
  • IPT users
    Fix bug on untimely authentication notification
    Fix bug on Help Center access
  • Fix bug on Help link which pointed to 404 page

Known Issues

  • Auto update
    Creation of a repair-installation package to fix bug of auto update mechanism on v3.12.3

    Download

 

15.01.2020 - Version 3.13.1

New features

  • INFGET()
    The field “Target Price” is now available.

Improvements

  • INFGET() audit
    Replace Company code by a list of detailed information of the instrument requested.
  • Time Series
    Improve stability and performance when same instrument is requested multiples time.

Bug fixes

  • Time Series
    Fix bug on “Cents adjustment” function which returned a false result in some cases.
  • INFGET() - Panel
    Fix bug on “Enterprise Value” field, on default “Reference Date” parameter.
  • INFGET()
    Fix bug on restricted fields which crashed Microsoft Excel in some cases.
  • Auto update
    Fix bug on auto update mechanism.

Known Issues

  • Auto update
    Creation of a repair-installation package to fix bug of auto update mechanism on v3.12.3

    Download