The INFGET() Function
INFGET() allows to retrieve profile, fundamental and estimates data for companies, and time series (historical prices, historical Market Cap, historical Estimates) for companies and instruments.
Notes:
- In case historical data is not available, the forecast data is returned and displayed instead.
- None of the arguments are case sensitive. You can get help on the function in Excel by hitting SHIFT + F3
Syntax
|
INFGET(company_code, field_name, period, advanced_parameter) |
|||
|
company_code |
Infront Analytics company identifier. Note: only Company Code and Instrument Code are supported currently. In future version, the service could be extended to support ISIN or Bloomberg Code natively. INFCODECONVERT() can be passed to this argument to convert an ISIN into a Company Code for instance.
Example: 00378EF (Company Code for Danone), LSE:VOD (Instrument Code for Vodafone) |
||
|
field_name |
The name of the field to retrieve. Only the keywords and names in Field Name Settings Table may be used.
Example: Net Sales, NETSALES, EBITDA, EPS, EPS Recurring |
||
|
period |
The optional period argument defines the desired period or reference date for the data. Only the keywords in Period and Reference Date Settings Tables may be used. Note : in case of conflict between the period parameter and advanced_parameter settings, period parameter takes precedence. |
||
|
advanced_parameter |
The optional advanced_parameter argument is used to specify additional information on the request such as the date, the currency, the source database etc. It can be passed a 2-dimensional array with a set of keyword-value pair. Only the keyword/value pairs described in the Advanced_parameter Settings Table may be used. Example:
|
Examples
|
Code |
=INFGET("21298EX","CLOSE",,"{'referenceDate':'20141104'}") =INFGET("21298EX","CLOSE",20141104) |
|
Description |
Historical close price for Vodafone on the 4th of November 2014. If no point value is available for the specified date, can go backward up to 10 calendar days. |
|
Code |
=INFGET("21298EX","CLOSE",,"{'referenceDate':'today'; 'currency':'EUR'}") |
|
Description |
Split adjusted, Historical close price for Vodafone. If no point value is available for the specified date, can go backward up to 10 calendar days. The price is returned converted in EUR |
|
Code |
=INFGET("21298EX","CLOSE",,"{'referenceDate':'CMS'}") |
|
Description |
Split adjusted, Historical close price for Vodafone, the first day of the current month (rolling format). If no point value is available for the specified date, can go backward up to 10 calendar days. |
|
Code |
=INFGET("30088EX","MARKETCAP") |
|
Description |
Current Market Cap for the company "30088EX" i.e. HSBC Holdings plc |
|
Code |
=INFGET("30088EX","MARKETCAP",,"{'referenceDate':20160331}" ) |
|
Description |
Market Cap for the company "30088EX" i.e. HSBC Holdings plc on 31 March 2016. |
|
Code |
=INFGET("30088EX","MARKETCAP",20160331) |
|
Description |
Market Cap for the company "30088EX" i.e. HSBC Holding plc on 31 March 2016. |
|
Code |
=INFGET("00453EF","EBITDA","LASTY","{'datasettype':'historical}") =INFGET("00453EF","EBITDA","LASTY") |
|
Description |
Last available historical Net Sales for the company "00453EF", i.e. Peugeot. |
|
Code |
=INFGET("00453EF","EBITDA","LASTY","{'source':'WVB'; 'datasettype':'historical'}") |
|
Description |
Last available historical Net Sales on WVB database for the company "00453EF", i.e. Peugeot. |
|
Code |
=INFGET("21298EX","EBITDA","CY+1", "{'datasettype':'forecast}") =INFGET("21298EX","EBITDA","FY1") |
|
Description |
Forecast Net Sales for the company "21298EX" i.e. Vodafone for the next year. |
|
Code |
=INFGET("21298EX","EBIT",2015) |
|
Description |
Historical EBIT for the company "21298EX" i.e. Vodafone for 2015 |
|
Code |
=INFGET("21298EX","EBIT",2017) |
|
Description |
EBIT for the company "21298EX" i.e. Vodafone for 2017, Historical if available, Forecast in not. |
