FXLData

FXLData addin for Excel

The FXLData addin provides a collection of Excel functions that can be used to retrieve data directly from Fusion Registry into normal worksheets.

The functions work like normal Excel formulas such as =sum() and =average() with the exception that the result is an array of series and observation values spanning multiple rows and columns rather than a single cell. Microsoft's documentation provides useful background information on how that these array formulas work in Excel.

The addin provides four separate functions
=FXLData()

• Returns a selected dataset in time-series format with one series per row.
• The function has three mandatory arguments: Base URL of the Fusion Registry, Dataflow, Series Key
• A further nine optional arguments can be specified including: maximum number of series to retrieve, start / end period, labels, headers and whether dimensions and attributes are shown

Examples

=FXLData("https://demo.metadatatechnology.com/FusionRegistry","ECB,EXR,1.0","A...")
=FXLData("https://demo.metadatatechnology.com/FusionRegistry","ECB,EXR,1.0","A...",1000,"round=2",2010,2020,both,true,true,true,false)
=FXLData(C14,C4,C7,C15,C13,C5,C6,C12,C9,C8,C10,C11)

=FXLData()	Returns a selected dataset in time-series format with one series per row. The function has three mandatory arguments, plus a number of optional.	Example
=FXLDataUrl()	Returns a selected dataset	Example
Example	Example	Example
Example	Example	Example