QUICK REFERENCE
1.1. Minimum Requirements
1.2. System Tools
1.2.1. Help
1.2.2. Status Indicator
1.2.3. Connection Indicator
1.2.4. Idiom
1.2.5. Connect to Real Time Excel Network
1.2.6. Disconnect from Real Time Excel Network
1.2.7. Computer Identification
1.2.8. Data Reception
1.2.9. Data Transmission
1.2.10. System Settings
1.1. Minimum Requirements
- Operation System: Windows XP, Windows 2000, Windows ME or Windows 98
- This system has no been tested to Windows 95, but may not face troubles.
- Microsoft Excel with version: Excel 2003, Excel XP or Excel 2000
- There are restrictions to Excel 97 version (see details in help files).
- Memory: Minimum of 128 MB 1
- Hard Disk space: 10 MB
- Browser Internet Explorer or Netscape installed 2
1
Total amount of memory may interfere with update speed of transmitted data and with system network (CoRTEx) performance.
2
Allows access to manual and help files available in the Internet.
1.2. System Tools
1.2.1. Help
Access:
- Menu - Broadcaster | Help on line
 - Toolbar Broadcaster
Description: Runs browser Internet Explorer or Netscape in Élin Duxus web page for system manual and help for functions.
1.2.2. Status Indicator
Access:
- Menu - Broadcaster | Status
 - Toolbar Broadcaster
Description: Allows user to verify systems available updates as well as signature/license status. If signature/license expires, all functionalities will be over and will return #N/A (version 1.0.4 and older) or !Expired! (version 1.0.5).
- - Running normal
 - License is about to expire  - System blocked – signature or license need to be revalidated.
1.2.3. Connection Indicator
Access:
 - Toolbar Broadcaster
Description: Shows connection status of current Microsoft Excel instance. Do not runs any other operation or action in the system..
 - Disconnected from Excel Real time Network (CoRTEx) - - Connected to Excel Real time Network (CoRTEx)
1.2.4. Idiom
Access:
- Menu - Broadcaster | Idiom
Description: Idiom setting.
Includes options for Portuguese (Brazil) or English (USA).
After change the idiom, it is necessary to restar Microsoft Excel.
Available in version 1.0.3 and superiors.
1.2.5. Connect to Real Time Excel Network
Access:
- Menu - Broadcaster | Connect
 - Toolbar Broadcaster
Description: Connect on Microsoft Excel instantce to Excel Real Time Network (CoRTEx).
Excel 97 limitation
Important:
Use the combination of keys CTRL + ALT+ SHIFT + F9 only in Excel 97 and only when a new file with reception and transmission functions is opened. This combinations of keys will force a calculation of all functions and will allow system to works normal even in Excel 97.
|
1.2.6. Disconnect from Real Time Excel Network
Access:
- Menu - Broadcaster | Disconnect
 - Toolbar Broadcaster
Description: Disconnect one Microsoft Excel instance from Excel Real time Network (CoRTEx).
1.2.7. Computer Identification
Access:
- Menu - Broadcaster | My computer
Description: Returns workstation’s name in a message box. This name is used in Excel Real time Network to identify all instances of Excel opened in the workstation that are connected to system network.
1.2.8. Data Reception
Access:
- Menu - Insert | Function | Broadcaster
 - Toolbar Standard | Broadcaster
Description:
Receives, in real time, a data transmitted in Excel Real Time Network (CoRTEx).
Call: BD.ALIAS ( Alias, Server)
Argument |
Type |
Description |
Alias |
string |
Alias or nickname of a data transmitted by a server. Must be a string.
|
Server |
string |
Name of computer or workstation that is broadcasting a data in real time using a nickname or alias. Must be a string equals to the name of workstation that transmits the data.
|
Usage example:
- Alias: "rate"
- Server: “fixed_income_trader"
= BD.ALIAS( " rate ", " fixed_income_trader ")
1.2.9. Data Transmission
Access:
- Menu - Insert | Function | Broadcaster
- - Toolbar Standard | Broadcaster
Description:
Transmits a data over Excel Real time Network. Returns the same data transmitted.
Call: BD.BROAD ( Data, Alias)
Argument |
Type |
Description |
Data |
string, double |
Data or information to be transmitted. Must be a string, a number or a cell (containing a string or a number or containing a function returning a string or a number).
|
Alias |
string |
Alias or nickname of data broadcasted. Must be a string that will be used to identify the data in reception.
|
Usage example:
- Data: 14.5%
- Alias: "rate"
= BD.BROAD( 0,145, "rate")
1.2.10. System Settings
Access:
- Menu - Broadcaster | Settings
 - Toolbar Broadcaster
Description: Show system settings screen.
System settings screen
To change update color, choose equivalent option in section Visual Effects.
To change background color, choose one from color list. Do the same for font color.
|
