Logout

NetDania functions

The following NetDania functions are available:

  • =GetQuote("instrument", "source", "fields")

    Where:

    <instrument> Represents the symbol of the instrument e.g. EURUSD, USDJPY

    <source> Defines the data source from where to retrieve the data e.g. idc

    <field> Represents the name of the field to monitor e.g. LAST. Supported fields are: LAST, BID, ASK, MID_PRICE, CHANGE, TIME, HIGH, LOW, OPEN, CLOSE, VOLUME, %CHANGE, 1 MONTH ASK, 1 MONTH BID, 1 WEEK ASK, 1 WEEK BID, 10 MONTHS ASK, 10 MONTHS BID, 11 MONTHS ASK, 11 MONTHS BID, 12 MONTHS BID,12 MONTHS ASK, 1MONTH_CHANGE, 1MONTH_CLOSE, 1MONTH_PERCENT_CHANGE, 1WEEK_CHANGE, 1WEEK_CLOSE, 1WEEK_PERCENT_CHANGE, 1YEAR_CHANGE, 1YEAR_CLOSE, 1YEAR_PERCENT_CHANGE, 2 MONTHS ASK, 2 MONTHS BID, 2 WEEKS ASK, 2 WEEKS BID, 3 MONTHS ASK, 3 MONTHS BID, 3 WEEKS ASK, 3 WEEKS BID, 3MONTH_CHANGE, 3MONTH_CLOSE, 3MONTH_PERCENT_CHANGE, 4 MONTHS ASK, 4 MONTHS BID, 5 MONTHS ASK, 5 MONTHS BID, 52 W HIGH, 52 W LOW, 6 MONTHS ASK, 6 MONTHS BID, 7 MONTHS ASK, 7 MONTHS BID, 8 MONTHS ASK, 8 MONTHS BID, 9 MONTHS ASK, 9 MONTHS BID, AMOUNT_TURNOVR, ASK_10Y, ASK_1Y, ASK_2Y, ASK_3Y, ASK_4Y, ASK_5Y, ASK_6Y, ASK_7Y, ASK_SIZE, AVG_PRICE, BETA, BID_10Y, BID_1Y, BID_2Y, BID_3Y, BID_4Y, BID_5Y, BID_6Y, BID_7Y, BID_SIZE, CHANGE, CONTRIBUTOR, DEBT_TO_EQUITY, DIVIDEND, EARN_PER_PRICE_EST, EARN_PER_SHARE, EARN_PER_SHARE_EST, EQUITY_PER_SHARE, LAST/BID/ASK, NAME, O/N ASK, O/N BID, OPEN INTEREST, PERCENT_CHANGE, PIP VALUE (USD), PRICE_PER_EARN_EST, PRV_VOLUME, PRV_YEAR_CLOSE, S/N ASK, S/N BID, SALES_PER_SHARE, SETTLEMENT PRICE, T/N ASK, T/N BID, TOTAL_SHARES, VOLUME_INC, Y %CHANGE, Y CHANGE, YEAR_CHANGE, YEAR_HIGH, YEAR_LOW, YEAR_PERCENT_CHANGE, YIELD

  • =GetChartLive("instrument", "source", "timescale", "fields", "latestAtTop", "addHeaders", "points", "", "")

    Where:

    <instrument> Represents the symbol of the instrument e.g. EURUSD, USDJPY

    <source> Defines the data source from where to retrieve the data. If source is undefined, the source "idc" will be used.

    <timescale> Sets the time scale to be used when retrieving historical data. The following time scales are available: "TICKS", "1SEC", "2SEC", "3SEC", "4SEC", "5SEC", "10SEC", "15SEC", "30SEC", "1MIN", "2MIN", "3MIN", "4MIN", "5MIN", "10MIN", "15MIN", "30MIN", "1HOUR", "2HOURS", "3HOURS", "4HOURS", "6HOURS", "8HOURS", "12HOURS", "DAILY", "WEEKLY", "MONTHLY". If timescale is undefined, a default value of "1HOUR" will be used.

    <field> Define which fields will be requested, when retrieving historical data. Supported fields are: "DATE", "OPEN", "HIGH", "LOW", "CLOSE", "VOLUME".

    <latestAtTop> If "Yes", data will be inserted in descending order, which is the default. If set to "No", data will be inserted in ascending order. If undefined, the default will be used.

    <addHeaders> If "Yes", a header describing the field type (e.g. "HIGH") will be inserted above. If undefined, a default value of "No" will be used, and no headers will be inserted.

    <points> Defines the number of historical data points (bars) that will be retrieved, if available. If undefined, a default value of 50 is used.

  • =getChartSyncCell("instrument", "source", "timescale", "fields", "latestAtTop", "addHeaders", "points", "", "", row, column)

    Where:

    <instrument> Represents the symbol of the instrument e.g. EURUSD, USDJPY

    <source> Defines the data source from where to retrieve the data. If source is undefined, the source "idc" will be used.

    <timescale> Sets the time scale to be used when retrieving historical data. The following time scales are available: "TICKS", "1SEC", "2SEC", "3SEC", "4SEC", "5SEC", "10SEC", "15SEC", "30SEC", "1MIN", "2MIN", "3MIN", "4MIN", "5MIN", "10MIN", "15MIN", "30MIN", "1HOUR", "2HOURS", "3HOURS", "4HOURS", "6HOURS", "8HOURS", "12HOURS", "DAILY", "WEEKLY", "MONTHLY". If timescale is undefined, a default value of "1HOUR" will be used.

    <field> Define which fields will be requested, when retrieving historical data. Supported fields are: "DATE", "OPEN", "HIGH", "LOW", "CLOSE", "VOLUME".

    <latestAtTop> If "Yes", data will be inserted in descending order, which is the default. If set to "No", data will be inserted in ascending order. If undefined, the default will be used.

    <addHeaders> If "Yes", a header describing the field type (e.g. "HIGH") will be inserted above. If undefined, a default value of "No" will be used, and no headers will be inserted.

    <points> Defines the number of historical data points (bars) that will be retrieved, if available. If undefined, a default value of 50 is used.

    <row> Defines the row for which the data is displayed.

    <column> Defines the column for which the data is displayed.

  • =getLastChartLive("instrument", "source", "timescale", "fields", "latestAtTop", "addHeaders", "points")

    Where:

    <instrument> Represents the symbol of the instrument e.g. EURUSD, USDJPY

    <source> Defines the data source from where to retrieve the data. If source is undefined, the source "idc" will be used.

    <timescale> Sets the time scale to be used when retrieving historical data. The following time scales are available: "TICKS", "1SEC", "2SEC", "3SEC", "4SEC", "5SEC", "10SEC", "15SEC", "30SEC", "1MIN", "2MIN", "3MIN", "4MIN", "5MIN", "10MIN", "15MIN", "30MIN", "1HOUR", "2HOURS", "3HOURS", "4HOURS", "6HOURS", "8HOURS", "12HOURS", "DAILY", "WEEKLY", "MONTHLY". If timescale is undefined, a default value of "1HOUR" will be used.

    <field> Define which fields will be requested, when retrieving historical data. Supported fields are: "DATE", "OPEN", "HIGH", "LOW", "CLOSE", "VOLUME".

    <latestAtTop> If "Yes", data will be inserted in descending order, which is the default. If set to "No", data will be inserted in ascending order. If undefined, the default will be used.

    <addHeaders> If "Yes", a header describing the field type (e.g. "HIGH") will be inserted above. If undefined, a default value of "No" will be used, and no headers will be inserted.

    <points> Defines the number of historical data points (bars) that will be retrieved, if available. If undefined, a default value of 50 is used.

  • =getBidChartLive("instrument", "source", "timescale", "fields", "latestAtTop", "addHeaders", "points")

    Where:

    <instrument> Represents the symbol of the instrument e.g. EURUSD, USDJPY

    <source> Defines the data source from where to retrieve the data. If source is undefined, the source "idc" will be used.

    <timescale> Sets the time scale to be used when retrieving historical data. The following time scales are available: "TICKS", "1SEC", "2SEC", "3SEC", "4SEC", "5SEC", "10SEC", "15SEC", "30SEC", "1MIN", "2MIN", "3MIN", "4MIN", "5MIN", "10MIN", "15MIN", "30MIN", "1HOUR", "2HOURS", "3HOURS", "4HOURS", "6HOURS", "8HOURS", "12HOURS", "DAILY", "WEEKLY", "MONTHLY". If timescale is undefined, a default value of "1HOUR" will be used.

    <field> Define which fields will be requested, when retrieving historical data. Supported fields are: "DATE", "OPEN", "HIGH", "LOW", "CLOSE", "VOLUME".

    <latestAtTop> If "Yes", data will be inserted in descending order, which is the default. If set to "No", data will be inserted in ascending order. If undefined, the default will be used.

    <addHeaders> If "Yes", a header describing the field type (e.g. "HIGH") will be inserted above. If undefined, a default value of "No" will be used, and no headers will be inserted.

    <points> Defines the number of historical data points (bars) that will be retrieved, if available. If undefined, a default value of 50 is used.

  • =getAskChartLive("instrument", "source", "timescale", "fields", "latestAtTop", "addHeaders", "points")

    Where:

    <instrument> Represents the symbol of the instrument e.g. EURUSD, USDJPY

    <source> Defines the data source from where to retrieve the data. If source is undefined, the source "idc" will be used.

    <timescale> Sets the time scale to be used when retrieving historical data. The following time scales are available: "TICKS", "1SEC", "2SEC", "3SEC", "4SEC", "5SEC", "10SEC", "15SEC", "30SEC", "1MIN", "2MIN", "3MIN", "4MIN", "5MIN", "10MIN", "15MIN", "30MIN", "1HOUR", "2HOURS", "3HOURS", "4HOURS", "6HOURS", "8HOURS", "12HOURS", "DAILY", "WEEKLY", "MONTHLY". If timescale is undefined, a default value of "1HOUR" will be used.

    <field> Define which fields will be requested, when retrieving historical data. Supported fields are: "DATE", "OPEN", "HIGH", "LOW", "CLOSE", "VOLUME".

    <latestAtTop> If "Yes", data will be inserted in descending order, which is the default. If set to "No", data will be inserted in ascending order. If undefined, the default will be used.

    <addHeaders> If "Yes", a header describing the field type (e.g. "HIGH") will be inserted above. If undefined, a default value of "No" will be used, and no headers will be inserted.

    <points> Defines the number of historical data points (bars) that will be retrieved, if available. If undefined, a default value of 50 is used.

Notes

Token parameter

All the above functions can receive a token parameter (the last parameter in the list) with the login token in case the client has it already. This parameter will be use to retrieve data.

Open XLS file exported from NetStation

By default, when you first time open an XLS file exported from NetStation, Excel 365 is not able to identify NetDania formulas. However, you press the button "Refresh Formulas" from the menu or if you login using the login screen, the formulas will be refreshed and the calculation will be done as expected.

Testing if Excel add-in is installed

In order to test if the NetDania add-in is already installed and, in case the add-in is not installed, to provide users with an information message/link you can use the Excel formula below:

=IFERROR(GETQUOTE("AUDCAD", "idc", "HIGH"), "The required custom function is not available. Please install the plugin or addon. For installation instructions, visit: https://office.netdania.com/excel/installation.html")

User Login

Initial Login

  • The user will not be automatically logged into the Add-in account.
  • Users must manually log in during their first interaction with the NetDania Excel Add-in.

Account Creation

  • Standalone Add-in accounts cannot be created by the user.
  • Users attempting to create an account will be redirected to the Payments website.
  • The NetDania team will set up corporate accounts with access to the Excel Add-in through corporate.netdania.com.

Instrument Search

  • Please note that the intruments and the providers are case sensitive.
  • Example: Use "EURUSD" instead of "eurusd" and "VERV.ch" instead of "VERV.CH" for intrumets and "idc" instead of "IDC" for providers.

Language Requirements

  • The only supported language for column names in the Excel Add-in is English.
  • Ensure that all column headers and related text are formatted in English to maintain compatibility.

Add-in Behavior

  • The Add-ins are not removed from the Excel list after clearing the cache