Try these example queries
- databases - displays list of available databases
- database("xeno").categories - view all categories in "xeno" database
- databases.? - displays list of available properties and functions
- databases.u? - displays the usage help
- category("xeno","equity").items.Values(Database, CodeType, Code) - view all items in the "equity" category
- item("xeno", "RIC31239", "reuters").description - view description of the "RIC31239" item
- item("xeno", "RIC31239", "reuters").availprops - view available properties of the "RIC31239" item
- item("xeno", "RIC31239", "reuters").PriceOfferClose - view PriceOffer Close time-series
- item("xeno", "RIC31239", "reuters").priceofferclose.volatility - calculates the volatility of a time series
- item("xeno", "RIC31239", "reuters").priceofferclose.volatility(60) - 60 day vol series
- item("xeno", "RIC31239", "reuters").priceofferclose.data('01-12-1994') - value on date
- item("xeno", "RIC31239", "reuters").priceofferclose.data('01-12-1994','10-12-1994') - series between dates
- item("xeno", "RIC31239", "reuters").priceofferclose.data('01-12-1994','10-12-1994', 2) - series with step
- item("xeno", "RIC31239", "reuters").priceofferclose.data('01-12-1994',) - all points on or after date
- item("xeno", "RIC31239", "reuters").priceofferclose.data(,'01-12-1994',100) - all points on or after date with step equal to 100 days
- item("xeno", "RIC31239", "reuters").priceofferclose.data(,'01-12-1994', '1.5M') - all points on or after date with step equal to 1.5 months
- item("xeno", "RIC31239", "reuters").Values( priceofferclose - priceofferclose.firstvalue ) - series change since first value
- item("xeno", "RIC31239", "reuters").Values( priceofferclose - priceofferclose.firstvalue ).Cells(1,1) - same query as above, selecting a specific cell in the result grid
- (item("xeno", "RIC31239", "reuters").priceofferclose + item("xeno", "RIC31239", "reuters").priceofferopen)/2 - average of two series on date
- item("Public", "Spread Validation", "File Export").Definition.Result2D("L") - Executing Formula Grid performing spread validation