CHECK Expert+

About Excel Premium

All information provided by CHECK is available in Excel.

excel image

User may utilize every domestic/overseas market or non-market information(Equity, Futures/Options, Bond, FX, Overseas, Economic indicators, Financials) through Excel.

Features on Excel Premium

Uses fast and stable data infrastructure.

Uses fast and stable data infrastructure.

Provides fast and stable data.
Takes immediate responses with Data search process.
Practices stable communication environment.

All data is available in Excel function format.

All data is available in Excel function format.

Improves usability by enabling Excel functions for all data.
Maximized effectiveness on data collection and investment analysis work using Excel U/I.

CHCECK Expert+ provides the latest equipment and software.

CHCECK Expert+ provides the latest equipment and software.

PC with the latest gadgets : Dual Core Processor 3.0Hz/500GB HDD /2GB memory or more.
Provides LED monitor for all users for better convenience.
Provides the latest Security S/W(V3) to deal with security breach.

Provides domestic/overseas market or non-market information.

Provides domestic/overseas market or non-market information.

Searches time series data(Executed/intra) in Excel function format.
Upgraded time series data not only for current market price.

Customized screen using Excel.

Customized screen using Excel.

Customizes analysis screen based on Excel.
User's specific analysis logic is added to calculate using Data search functions.

Provides easy U/I.

Provides easy U/I.

Generates function easily using Wizard function.
Beginner can use Chart Wizard for Data reduction.

Proposes new financial data analysis tool.

Proposes new financial data analysis tool.

Provides data processing function similar to Excel with server calculation function.
Analyzes every product using financial calculation function(Approx.. 700 Quantlib functions) needed for financial engineering.

Excel Premium - Main Function

Excel Premium screen

All about Excel Premium

Excel Premium screen : data search

Data Search Beginners

Excel Premium screen : data search with mouse

Quick data search with Drag & Drop

Excel Premium screen : data search with function wizard

Data search for premium users-Functions

Excel Premium screen : option setting

Search option settings

All about Excel Premium

Excel Premium is the tool exclusively developed for users and enable to bring and process data from CHECK terminal.

CHECK Template	Recall template	Provides screen examples with Excel.
CHECK Data	Data Search	Imports data in desired form using functions.
CHECK Tools	Symbol Search	Makes my own price chart.
	Item Search	Makes my own price chart.
	Function Wizard	Imports data in desired form using functions.
	ez Chart	Shows data in chart easy and fast.
	Table Search	Utilizes CT functions.
	Reload	Reload data per fields.
Refresh	Settings	Changes settings.
CHECK Support	Notice	Notice/Manuals for Excel Premium.
CHECK Support	help	Notice/Manuals for Excel Premium.

Data Search for Beginners

Data type are as below.

Excel Premium screen : data search

Market Data	Searches various type of market data.
Daily	Searches Data history per day/week/month.
Tick-RT	Appends Tick data in RT.
Intra-Time series	Appends Tick data in 10sec/1min.
Specific Search	Searches specific data easily with search type settings.

Data Search Condition Settings

Excel Premium screen : daily data

Click Search button or input symbol code.
Select category.(Auto recall)
Search item which correspondent both to stock and daily data in list.
Click arrow button to select needed items.
Add frequently used items to favorite items.
Layout option settings

Excel Premium screen : daily data layout

Sets data output location and method. When selecting 'Table', data will be shown as price chart.
Sets period/numbers of data search.
Sets search period as 1 day, 1 week, 1 month or more.
Marks empty values as '0' or '-'.
Click 'Complete' to search data.

Search Result Screen

Excel Premium screen : data search results

Type code or click search button.
refer to tooltips
(Ex : If '005930' is changed to '005380', data changes to Hyundai Mtr from Samsung Elec.)

Please note data retrieving is similar to above for price data, tick data, intra data, specific search.

Data search for premium users - Functions

Searches data just like using functions provided by Excel premium without data condition setting.

Excel Premium screen : data search with function wizard

CT(Check Tick) Function	To search price data in real-time.
CH(Check History) Function	To search daily price data.
CTS(Check Tick Series) Function	To check trick data.
CIS(Check Intra Series) Function	To search intra time series data.
CLIST(Check LIST) Function	To search rankings and trading status.

Excel Premium screen : function wizard manual