Difference between revisions of "FXLData"
Jump to navigation
Jump to search
(Created page with "=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. T...") |
|||
| Line 6: | Line 6: | ||
The addin provides four separate functions<br> | The addin provides four separate functions<br> | ||
'''=FXLData()''' | '''=FXLData()''' | ||
| + | [[File:Fxldata example1.PNG|thumb|=FXLData() example]] | ||
* Returns a selected dataset in time-series format with one series per row. | * 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 | * The function has three mandatory arguments: Base URL of the Fusion Registry, Dataflow, Series Key | ||
Revision as of 06:37, 7 September 2021
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 |
