Genic DataGridFeatures
Genic DataGrid is designed for the trader, analyst or research professional for market direction, pricing and trading strategies and back-testing analysis. We are continuously develop our software in conjunction with our clients to ensure we meet the ever-evolving market requirements.

VISUALISATION

Key FeaturesVersion 1.3Version 2.0
Absolute Graph
Differential Graph
Ratio Graph
Plimsoll Chart
Candlestick Chart
Bar Chart
Graph N Days
Graph Any Data Frequency
Cross-hair Tracking
Define Titles & Legends
Custom Data Axis
Custom Line Colours
Custom Line Thickness
Custom Background
Chart Zooming
De-select Instruments for Graphing
Save Charts in Multiple Formats
Build Portfolios
3 D Charting
Surface Charting
Seasonality

DATA SELECTION

Key FeaturesVersion 1.3Version 2.0
Multiple Data Selection
iTunes-Like Navigation
Multiple Portfolios
Specify Units
Specify Currency Conversion Source
Specify Currency
Change Frequency of Instruments
Select Averaging Methods
Data Range: From
Data Range: Between
Data Range: Maximum
Data Range: Last N Days
Date Range: Last N Weeks, Months, Quarters, Years
Data Range: On
Data Range: Today

In-Built Reporting

Key FeaturesVersion 1.3Version 2.0
Column Report
Differential Report
Monthly Report
Correlation/ Covariance Report
Basis Analysis Report
Hedge Analysis Report
Statistical Summary Report
OLAP Reporting
User Definable Reporting

GRAPH MANIPULATIONS

Key FeaturesVersion 1.3Version 2.0
Envelope Time Series
Filter Based on Meta-Data
Calculate Trend Lines
Define Legends
Copy Reporting Data
Decimal Place Configuration
Build Portfolios
Import Portfolios
Export Portfolios
Import Formulas
Export Formulas
Save Charts in Multiple Formats
Create Spark/ Dark Spreads

Technical Analysis

Key FeaturesVersion 1.3Version 2.0
Momentum
Moving Average (MACD)
Rate of Change
RSI
Trend Line
Moving Average -Beginning
Moving Average -Centrered
Moving Average -End
Moving Average – Offset Period
Linear-Weighted Moving Average -Beginning
Linear-Weighted Moving Average -Centered
Linear-Weighted Moving Average -End
Exponentially-Smoothed Moving Average -Beginning
Exponentially-Smoothed Moving Average - Centered
Exponentially-Smoothed Moving Average -End
Confidence Intervals

FREQUENCY OPTIONS

Key FeaturesVersion 1.3Version 2.0
15 Minutely
30-Minutely
Hourly
Business
Daily
Weekly
Monthly
Quarterly
Yearly
Quoted Only
Intra-Day
Scale Method - Average
Scale Method - Summed
Scale Method - Beginning
Scale Method - End

AGGREGATION OPTIONS

Key FeaturesVersion 1.3Version 2.0
Quoted Average
Weekday Average
Calendar Average
Monthly Average
Partial Average
Scale Method - Average
Scale Method - Summed
Scale Method - Beginning
Scale Method -End

DATA FILL OPTIONS

Key FeaturesVersion 1.3Version 2.0
Interpolate
Back Fill
Forward Fill
Custom

FORMULAS

Key FeaturesVersion 1.3Version 2.0
User-Defined Formulas
Nested Formulas
Arithmetic Formulas (+,-,*,/)
Concatenation of series
Shift (Lag/Lead)
Count periods
Auto-Correlation
Auto-Covariance
Least-Squares Regression
Absolute
Round
Truncate
Exponential Value
IF then Else
Natural Logs
Maximum Value
Minimum Value
Null Value
Opening Value
Power of
Random Number Generator
Square Root
Sum
Count Business Days
Count Values
Count Missing Values
Count Quoted Values
Day of Week
Month of Year
Hour of Day
Minute of Hour
Interpolate
Standard Deviation
Mean
Moving Average
Correlation
Co-Variance
Exponential Weighted Average
Linear Weighted Average
RSI
Log Return
Momentum
Percentage Change
ROC
RSI
Rebase
Scale

EXCEL Functionality

Key FeaturesVersion 1.3Version 2.0
Export to Excel
Full Use of Excel Functionality
Use Cell References For Arguments
Update Cell
Update Row/ Column
Update Sheet
Update Workbook
Automatic Login/Logout
Update From Excel in Genic DataManager
Supporting Material
Genic DataGrid