|
Name |
Function |
Description |
|
AdjustedIPOPrice |
AdjustedIPOPrice(security,currency) |
Returns the Adjusted IPO Price of the selected security in terms of the selected currency. |
|
BankFinancialMarketShare |
BankFinancialMarketShare (security,quarter) |
Returns the market share value of the selected financial item of the security for the specified date in the selected group. |
| DailyFiltered | DailyFiltered(security,day,field,currency,subGroup,excludedSubGroup) | Returns the daily field value filtered of the selected security for the specified date due to the group selection. |
|
DividendYieldAvg |
DividendYieldAvg(security,date1,date2,mcap1,mcap2,isGross) |
Returns the average dividend yield of the selected security with respect to the specified market capitalization day interval. |
|
DividendYieldPerYear |
DividendYieldPerYear(security,date1,date2,mcap1,mcap2,isGross) |
Returns the dividend yield per year of the selected security with respect to the specified market capitalization day interval. |
|
ExistsInGroup |
ExistsInGroup(security,group) |
Returns whether the selected security belongs to the specified group or not. |
| FinancialAnnouncementFrequency | FinancialAnnouncementFrequency(security,template) | Returns the frequency (like Q or H) of financials announcement for selected security and template by checking last 9 quaters. |
| FinancialCAGR | FinancialCAGR(security,template,item,quarter) | Returns the compound annual growth rate of the selected security for the specified quarters. Calculation: ((Financials Item (Last Period) / Financials Item (First Period) ^ ( 1 / Number of Years) – 1) * 100 |
| FinancialMarketSharePps | FinancialMarketSharePps (security,template,item,quarter) | Returns the market share percentage points change of the selected security for the specified quarters in the selected group. Calculation: BankFinancialMarketShare (Last Period) - BankFinancialMarketShare (First Period) |
| FinancialPps | FinancialPps (security,template,item,quarter) | Returns the percentage points change of the selected security for the specified quarters. Calculation: Financials Item (Last Period) - Financials Item (First Period) |
|
FinancialTemplate |
FinancialTemplate(security,quarter,tableType) |
Returns the type of the template of the selected security for the specified quarter and table type. |
|
FreeFloat |
FreeFloat(security,day) |
Returns the free float of the selected security for the specified day. |
|
GroupDailyFiltered |
GroupDailyFiltered(group,day,field,currency,subGroup,excludedSubGroup) |
Returns the total value of the daily data of the selected group and subgroup with excluding option. |
|
GroupMarketShare |
GroupMarketShare(group,day,field,currency) |
Returns the market share value of the selected subgroup in the selected group. |
|
GroupMonthlySummation |
GroupMonthlySummation(group,month1,month2,field,currency) |
Returns the total value of the monthly data of the selected group for the specified date interval in terms of the selected currency. |
|
GroupOfSecurity |
GroupOfSecurity(security,group,day) |
Returns the specified type of group of the selected security. |
|
GroupPeriodicallyChgAvg |
GroupPeriodicallyChgAvg(group,date,the number of Periods) |
Returns the average of daily, weekly or monthly sectoral data change for specified the number of periods. |
|
GroupSecurity |
GroupSecurity(group,no,day,subGroup) |
Returns the names of the securities both belong to the selected subgroup and selected group or index. |
|
GroupSecurityCount |
GroupSecurityCount(group,day,day2,subGroup) |
Returns the number of the securities both belong to the selected subgroup and selected group or index. |
|
GroupSecurityList |
GroupSecurityList(group,no,date) |
Returns the names of the securities contained in the selected group or index due to the specified no. |
|
IndexWeight |
IndexWeight(security,day,group) |
Returns the index weight value of the selected security for the specified date in the selected group. |
|
Inflation |
Inflation(source,inflation,month) |
Returns the inflation value of the selected index for the specified month. |
|
InflationRate |
InflationRate(source,inflation,month,month2) |
Returns the change of inflation value of the selected index for the specified month interval. |
|
MarketShare |
MarketShare(security,date,field,group) |
Returns the market share value of the selected security for the specified date in the selected group. |
|
MonthlySummation |
MonthlySummation(security,month1,month2,field,currency) |
Returns the total value of the monthly data of the selected security for the specified date interval in terms of the selected currency. |
|
MonthOffset |
MonthOffset(security,date) |
Returns the difference of fiscal year and calender year of the selected security in terms of months. |
| QuarterOffset | QuarterOffset(security,date) | Returns the difference of fiscal year and calender year of the selected security in terms of quarters. |
| SecurityGroup | SecurityGroup(security,groupType,day) | Returns the manager, launcher, index, sector of the selected fund for the specified day. |
|
SecurityGroupByOrder |
SecurityGroupByOrder(security,groupType,no) |
Returns the manager, launcher, index, sector of the selected fund for the specified day. |
|
SecurityName |
SecurityName(security,date) |
Returns the long name of the selected security. |
| SumDividendGross | SumDividendGross(security,day1,day2,currency,coefficient) | Returns the total gross dividend value of the selected security for the specified date interval in terms of the selected currency. |
| SumDividendNet | SumDividendNet(security,day1,day2,currency,coefficient) | Returns the total net dividend value of the selected security for the specified date interval in terms of the selected currency. |
| SumRightCapital | SumRightCapital(security,day1,day2,currency,coefficient) | Returns the total nominal value of the right capital of the selected security for the specified date interval in terms of the selected currency. |
| TradingDayCount | TradingDayCount(day1,day2,security) | Returns the number of trading days for the selected security for the specified date interval. |