Data Functions

Data functions differs from Source to Source.

Source list contains the data sources which you have subscription(i.e. ISE Stocks, Turkish Mutual Funds, ISE Bonds&Bills, etc.).

If you want to learn available data vendors for any country or market, please send an e-mail to sales@EquityRT.com.

Data functions are categorized into the following groups:

Daily: Daily() function returns daily data set of the selected source.

‘(Raw)’-defined daily data for Security Markets is also available. Raw data shows the value which is not rearranged due to Capital Increase or Dividend actions.

Parameter	Description	Default Value
Security	Ticker of the selected security	CurrentSecurity
Date	You can select a date or write a date function.	CurrentDay
Daily Data	Selected daily data
Currency	Selected currency	CurrentCurrency
Rollback	Yes/No. If data is not available for the selected quarter and you want the calculations to be done with the previous data then select "Yes". If you don't want any calculations to be done then select "No".	CurrentRollback
Display Unit	Calculated result will be displayed in this unit. (If it is greater than 1 it will be divided by the value and will be multiplied otherwise.)	1
--Example--	Daily Data=Market Capitalization Daily(CurrentSecurity, CurrentDay, "mcap", CurrentCurrency, CurrentRollback, 1)

Sessionly: Sessionly() function returns sessionly data set of the selected source.

‘(Raw)’-defined sessionly data for Security Markets is also available. Raw data shows the value which is not rearranged due to Capital Increase or Dividend actions.

Parameter	Description	Default Value
Security	Ticker of the selected security	CurrentSecurity
Date	You can select a date or write a date function.	CurrentDay
Sessionly Data	Selected sessionly data
Currency	Selected currency	CurrentCurrency
Rollback	Yes/No. If data is not available for the selected quarter and you want the calculations to be done with the previous data then select "Yes". If you don't want any calculations to be done then select "No".	CurrentRollback
Display Unit	Calculated result will be displayed in this unit. (If it is greater than 1 it will be divided by the value and will be multiplied otherwise.)	1
--Example--	Sessionly Data=Close; Sessionly(CurrentSecurity, CurrentDay, "close", CurrentCurrency, CurrentRollback, 1)

Weekly: Weekly() function returns weekly data set of the selected source.

Parameter	Description	Default Value
Security	Ticker of the selected security	CurrentSecurity
Date	You can select a date or write a date function.	CurrentDay
Weekly Data	Selected weekly data
Currency	Selected currency	CurrentCurrency
Rollback	Yes/No. If data is not available for the selected quarter and you want the calculations to be done with the previous data then select "Yes". If you don't want any calculations to be done then select "No".	CurrentRollback
Display Unit	Calculated result will be displayed in this unit. (If it is greater than 1 it will be divided by the value and will be multiplied otherwise.)	1
--Example--	Weekly Data=Net Asset Value Weekly(CurrentSecurity, CurrentDay, "netAssetValue", CurrentCurrency, CurrentRollback, 1)

Quarterly: Following function return financial table items of the selected template and table type. You should use Financial() functions to get the cumulative values of the quarterly items. The syntax and parameters of the function are as following;

Parameter	Description	Default Value
Security	Ticker of the selected security	CurrentSecurity
Quarter	Selected quarter	CurrentQuarter
Item Code	Item code of the selected financial item	CurrentItemCode
Template	Selected template	CurrentTemplate
Currency	Selected currency	CurrentCurrency
Inf.Quarter	The quarter which will be used as the reference inflation quarter
Rollback	Yes/No. If data is not available for the selected quarter and you want the calculations to be done with the previous data then select "Yes". If you don't want any calculations to be done then select "No".	CurrentRollback
Method	Announced, Calculated, Announced/Calculated. Calculated indicates the difference between the last quarter item value and the previous quarter. Announced indicates the item value in the last quarter financial table. Announced/Calculated indicates that the system looks for the announced item first, if not available then calculates the value.	Calculated
Inflation	The inflation index which will be used in the calculation. If this field is empty, then Tools>Options>Inflation Security definition will be used	CurrentInflation
Display Unit	Calculated result will be displayed in this unit. (If it is greater than 1 it will be divided by the value and will be multiplied otherwise.)	1
--Example-1--	Template=XI_29, Table Type=Balance Sheet, Data Field=Total Assets; Financial(CurrentSecurity, CurrentQuarter, 1000, Template(“XI_29”), CurrentCurrency, Empty, CurrentRollback, Calculated, Empty, 1)
--Example-2--	Template=BDDK-S, Table Type=Income Statement, Data Field=Net Profit; Financial(CurrentSecurity, CurrentQuarter, 319200, Template(“XI_29”), CurrentCurrency, Empty, CurrentRollback, Calculated, Empty, 1)

Monthly: Monthly() function is valid for the Macro Economic Indicators Sources only.

Parameter	Description	Default Value
Security	Ticker of the selected security	CurrentSecurity
Month	You can select a month or write a date function.	CurrentMonth
Data Field	Selected Monthly data
Currency	Selected currency	CurrentCurrency
Rollback	Yes/No. If data is not available for the selected quarter and you want the calculations to be done with the previous data then select "Yes". If you don't want any calculations to be done then select "No".	CurrentRollback
Inflation	The inflation index which will be used in the calculation. If this field is empty, then Tools>Options>Inflation Security definition will be used	CurrentInflation
Display Unit	Calculated result will be displayed in this unit. (If it is greater than 1 it will be divided by the value and will be multiplied otherwise.)	1
--Example--	Data Field=Close; Monthly(CurrentSecurity, CurrentMonth, "close", CurrentCurrency, CurrentRollback, 1)

Splits/Capital Increase Actions: CapitalIncrease() function returns data presented in the Capital Increase form. (Valid for equities only.)

Parametre	Description	Default Value
Security	Ticker of the selected security	CurrentSecurity
Day	You can select a date or write a date function	CurrentMonth
Data Field	Selected data field
Currency	Selected currency	CurrentCurrency
Display Unit	Calculated result will be displayed in this unit. (If it is greater than 1 it will be divided by the value and will be multiplied otherwise.)	1
--Example--	Data Field=Capital Increase (Nominal); CapitalIncrease(CurrentSecurity, CurrentDay, "rights", CurrentCurrency, 1)

Dividend: Dividend() function returns data presented in the Dividend form (Valid for equities only).

Parametre	Açıklama	Default Value
Security	Ticker of the selected security	CurrentSecurity
Day	You can select a date or write a date function	CurrentMonth
Data Field	Selected data field
Currency	Selected currency	CurrentCurrency
Display Unit	Calculated result will be displayed in this unit. (If it is greater than 1 it will be divided by the value and will be multiplied otherwise.)	1
Example Example 2 Example 3 Example 4	Data Field=Dividend Future; DividendFuture(CurrentSecurity, CurrentDay, PeriodStartDate, Field) Dividend Future returns the future dividend payment value. Veri Adı=Temettü Ödeme Oranı ise; Data Field=Dividend Payout Ratio DividendPaymentRatio(CurrentSecurity,Date) Returns the rate of total gross dividend for specified date to the end of previous year net income of the selected security. Calculation= Specified Date's Year Beginning and End range “Total Gross Dividend”/Previous Year End “Net Earnings” Data Field= DPSTTM; DPSTTM (Security,Date,IsGross,Currency) Returns total gross or net dividend (yearly) of selected security for specified date. Calculation=If Dividend Payment Frequency for specified date=0;(the year of selected date -1)taken If Dividend Payment Frequency for specified date<previous year;(the year of selected date-1) taken If Dividend Payment Frequency for specified date>previous year;(the year of selected date -1)taken to calculate total dividend. Data Field=Dividend Yield TTM; DividendYieldTTM(Security,Date,IsGross,Currency) Returns dividend yield (yearly)of selected security for specified date. Calculation=If Dividend Payment Frequency for specified date=0;(the year of selected date -1)taken If Dividend Payment Frequency for specified date<previous year;(the year of selected date-1) taken If Dividend Payment Frequency for specified date>previous year;(the year of selected date -1) taken to calculate Dividend Yield with (adj.DPSTTM/Close (Raw))*100 formulation.

Security Info: SecurityInfo() functions returns the rows presented in the Company Profile form.

Parameter	Description	Default Value
Security	Ticker of the selected security	CurrentSecurity
Data Field	Selected data field

Example

Example 2

Example 3

Example 4

Example 5

Example 6

Example 7

Example 8

Data Field= Security Region;

SecurityRegion(CurrentSecurity)

Returns the region as database code for the selected security.

Data Field= Security Primary Code;

SecuirtyPrimaryCode(CurrentSecurity)

Returns the main security for the related securities.

Data Field= Security Exhange;

SecurityExchange

Returns the exchange of the security.

Data Field= Security Region Name;

SecurityRegionName(CurrentSecurity)

Returns the region for the selected security.

Data Field= Security Cap;

SecurityCap(CurrentSecurity)

Returns the security cap for the selected security.

Data Field= Security Cap Name;

SecurityCapName(CurrentSecurity)

Returns the security cap for the selected security.

Data Field= Security Daily Currency;

SecurityDailyCurrency(CurrentSecurity)

Returns the currency for daily data of the selected security.

Data Field= SecurityNameToCode;

SecurityNameToCode(SecurityName,Source,date)

Returns the security code for the selected security and source.

Custom: The data set of the custom securities you created in the Data Service Application.

Ratios

Ratio List