FXLData what's new in R1.3.03 - Revision history

Vmurrell: /* Functions */

2026-02-16T12:19:44Z

‎Functions

2026-02-16T12:01:29Z

‎Functions

2026-02-16T11:57:34Z

2026-02-16T11:57:12Z

2025-08-13T10:57:00Z

‎Functions

2025-08-13T10:54:38Z

2025-08-11T13:20:26Z

2025-08-11T13:17:57Z

‎FXLData Tab

2025-08-11T13:17:18Z

‎Rest Arguments

2025-08-11T13:12:46Z

← Older revision		Revision as of 12:19, 16 February 2026
Line 93:		Line 93:

	[[FXLDataLookup_and_FXLDataPeriod_Functions \|You can read more in this article.]]		[[FXLDataLookup_and_FXLDataPeriod_Functions \|You can read more in this article.]]
		+
		+	===== System Properties =====
		+	A new option is available on the FXL Data tab which, when selected, will display information as shown in the example aside.
		+
		+	[[File:Click-sys-info-ER.png\|thumb]]

	=== Refresh ===		=== Refresh ===

← Older revision		Revision as of 12:01, 16 February 2026
Line 87:		Line 87:

	[[File:TimeFormatFrequencyID.png\|500px]]		[[File:TimeFormatFrequencyID.png\|500px]]
		+
		+	===== New Functions introduced =====
		+
		+	These options are available but are currently in beta test.
		+
		+	[[FXLDataLookup_and_FXLDataPeriod_Functions \|You can read more in this article.]]

	=== Refresh ===		=== Refresh ===

← Older revision		Revision as of 10:57, 13 August 2025
Line 87:		Line 87:

	[[File:TimeFormatFrequencyID.png\|500px]]		[[File:TimeFormatFrequencyID.png\|500px]]
		+
		+	=== Refresh ===
		+	FXLData no longer uses the normal Excel calculations in Microsoft 365. As a result, if a change is made as describe here [[Refresh - FXLData#Refresh\| Refresh article]] a manual refresh is necessary.
		+
		+	The Refresh option is no longer restricted to older versions of Excel, the options available are detailed [[Refresh - FXLData#Office 2010-2019 Excel and Microsoft 365 Excel working in legacy Mode\|here.]]
		+
		+	Note that if the formula itself is deleted, you will also need to delete any returned data.

← Older revision		Revision as of 10:54, 13 August 2025
Line 78:		Line 78:
	* max		* max
	* time-format-frequency-id		* time-format-frequency-id
		+
		+	=== Other point to note ===
		+	==== Functions ====
		+	The TimeFormatFrequencyID parameter is now available when using the Functions:
		+	* FXLDataURL
		+	* FXLDataURLV
		+	* FXLDataURLFact
		+
		+	[[File:TimeFormatFrequencyID.png\|500px]]

@@ Line 9: / Line 9: @@
 == FXLData Tab ==
-On opening Excel and enabling the latest version of the FX Data add-in, you will several significant changes on the FXLData Tab within Excel.
+On opening Excel and enabling the latest version of the FX Data add-in, you will see several significant changes on the FXLData Tab within Excel.
 [[File:Appearance.png|800px]]

← Older revision	Revision as of 11:57, 16 February 2026
(No difference)

← Older revision	Revision as of 13:20, 11 August 2025
(No difference)

← Older revision		Revision as of 13:17, 11 August 2025
Line 49:		Line 49:

	[[File:Rest-argument-builder-button.png\|1000-px]]		[[File:Rest-argument-builder-button.png\|1000-px]]
		+
		+	To use the Builder, select a dataflow and then click on the Builder button.
		+
		+	Click the button to access the builder.
		+
		+	[[File:Rest-argument-builder.png\|1200-px]]
		+
		+	'''Apply Button'''
		+
		+	When the Apply button is pressed in the REST Arguments Builder, it performs the following action:
		+
		+	* It populates the REST Args box on the main Wizard screen with the constructed query string based on the enabled and valid arguments.
		+	* It does not execute the FXLData function or retrieve any data at this stage.
		+	* To actually run the query and fetch data into Excel, the user must return to the Wizard screen and press its Apply button.
		+	This separation ensures the user can review and finalize their full query setup before triggering data retrieval.
		+
		+	====Interaction with the Wizard====
		+	'''Existing Arguments'''
		+
		+	If the wizard already contains rest arguments when the Builder is opened, it will attempt to interpret and reconstruct the existing argument as accurately as possible.
		+
		+	[[File:Rest-arguments-box.png\|1200-px]]
		+
		+	'''Arguments handled via the Wizard'''
		+
		+	* startperiod
		+	* endperiod
		+	* max
		+	* time-format-frequency-id

← Older revision		Revision as of 13:12, 11 August 2025
Line 32:		Line 32:

	[[File:Diagnostic tool.png\|1000px]]		[[File:Diagnostic tool.png\|1000px]]
		+
		+	== FXLData Wizard ==
		+
		+	===Dataflow Selection===
		+
		+	A new selection box has been added to make it easier to select a dataflow.
		+
		+	[[File:Dataflow selection.png\|1000px]]
		+
		+	===Selecting Items===
		+	[[File:Codelist display.png\|1000px]]
		+
		+	===Rest Arguments===
		+
		+	The Wizard (available from the FXL Data tab) now includes a button to select the Rest Arguments Builder. Which can be used to specify additional SDMX query arguments that are not available through other options in the User Interface, such as round=2 for rounding numeric values. It is intended for the advanced user who needs finer control over the query behaviour.
		+
		+	[[File:Rest-argument-builder-button.png\|1000-px]]