FXLData - Revision history

Vmurrell: /* Download */

2025-11-17T11:49:11Z

‎Download

2024-10-21T12:23:41Z

‎Download

2024-10-21T12:20:47Z

‎Download

2024-07-22T11:47:06Z

‎Administrative functions

2023-12-03T15:24:16Z

‎Quick start

2023-12-03T15:22:51Z

‎Quick start

2023-12-03T15:09:15Z

‎Function Reference

2023-12-03T14:56:02Z

‎=FXLDataV()

2023-12-03T14:53:03Z

‎=FXLDataV()

2023-12-03T14:43:12Z

‎=FXLData()

@@ Line 5: / Line 5: @@
 =Download=
-Download the latest version [[File:FXLData July2024.zip]] July 2024.
+Download the latest version [[File:FXLData-August-2025.zip]] August 2025.
 See the [[FXLData Changelog]] for recent changes, updates and bug fixes.

@@ Line 5: / Line 5: @@
 =Download=
-Download the latest version [[File:R1-1-0-00-RFS-05-07-24.zip]] July 2024.
+Download the latest version [[File:FXLData July2024.zip]] July 2024.
 See the [[FXLData Changelog]] for recent changes, updates and bug fixes.

@@ Line 5: / Line 5: @@
 =Download=
-Download the latest version [[File:FXLData 1-2-6.zip]] 24 February 2023
+Download the latest version [[File:R1-1-0-00-RFS-05-07-24.zip]] July 2024.
 See the [[FXLData Changelog]] for recent changes, updates and bug fixes.

@@ Line 87: / Line 87: @@
 <span style="color:red;>'''=FXLDataVersion()'''</span>
 * Returns the software version number and build date
 ====Microsoft 365 Excel 2018 and later====

@@ Line 15: / Line 15: @@
 # Paste the following formula into a cell
   =FXLDataV("https://demo.metadatatechnology.com/FusionRegistry","WB,WDI_POVERTY","A")
-A sample 100 series of annual ECB exchange rates data will be retrieved from Metadata Technology's public demonstration Fusion Registry service and inserted directly into the sheet.
+A sample 100 series of annual data will be retrieved from Metadata Technology's public demonstration Fusion Registry service and inserted directly into the sheet.
 The [[FXLData Wizard]] provides tools to help with the task of building FXLData formulas.

@@ Line 169: / Line 169: @@
 | 12||IncludeAttributes || Boolean<br><code>TRUE</code> includes series attributes in the component breakdown<br><code>FALSE</code> excludes attributes|| FALSE || Optional<br>Defaults to <code>TRUE</code>
 |}
 ====FXLDataUrl()===

@@ Line 211: / Line 211: @@
 | 1||RegUrl|| The base URL of the Fusion Registry service || <nowiki>https://demo.metadatatechnology.com/FusionRegistry</nowiki> || style="background-color:pink;" |Mandatory
 |-
-| 2||Dataflow || Options:<br>1. The dataflow to query conforming to the SDMX REST specification for data queries<br>2. A blank string - in this case the Dataflow(s) to query must be specified as part of the Expression. || EXR<br>ECB,EXR,1.0 || style="background-color:pink;" | Mandatory
+| 2||Dataflow || Options:<br>1. The dataflow to query conforming to the SDMX REST specification for data queries<br>2. A blank string - in this case the Dataflow(s) to query must be specified as part of the Expression. || WB<br>WB,WDI_POVERTY,1.0 || style="background-color:pink;" | Mandatory
 |-
 | 3||Expression || Options:<br>1. A [[Series Key|series key]] <br>2. A dataflow and series key expression <dataflow>/<series key><br>3. A [[Anatomy_of_the_Data_Browser#Series_List_From_Series_Basket|JSON series basket expression]] which must be a cell reference and cannot be a literal value<br>4. The keyword 'all' to select all series in the dataset|| A<br>A.CAD+HUF+INR...E<br>all<br>ECB,EXR,1.0/A.HUF...E<br>C4 (cell reference)||style="background-color:pink;" | Mandatory

@@ Line 199: / Line 199: @@
 * The ID of the Dataflow
 * A series key specifying which series to retrieve, or simply 'all' to retrieve all series
-  =FXLDataV("<nowiki>https://demo.metadatatechnology.com/FusionRegistry</nowiki>","EXR","all")
+  =FXLDataV("https://demo.metadatatechnology.com/FusionRegistry","WB,WDI_POVERTY","A")
 By default, the number of series returned is capped at 100, but can be altered using the ''MaxSeries'' argument

@@ Line 131: / Line 131: @@
 '''Use Case'''<br>
-This parameterised form is suitable for hand coding in a spreadsheet. Like all Excel functions, the arguments can be literal values, cell references or Excel expressions allowing the creation of complex data models. In its simplest form, only three arguments are required:
+This parameterised form is suitable for hard coding in a spreadsheet. Like all Excel functions, the arguments can be literal values, cell references or Excel expressions allowing the creation of complex data models. In its simplest form, only three arguments are required:
 * The 'base URL' of the Fusion Registry to connect to
 * The ID of the Dataflow