|
Starting Up MarketLink
"Communications Online" displayed briefly in the MarketLink interface confirms a successful log on to your Netfeed Server. Setting the default formula format to ‘String’ will ensure your links to any type of data are successful.
Creating Live Data Links in Excel
Live data links can be created in Excel by using “drag & drop” or “copy & paste” functions of WorldWatch Insight. Live links can also be created by typing the formula directly into Excel.
Using WorldWatch Insight to Create Live Links
- In WorldWatch Insight, ensure that "Excel" is selected in Tools\Options\Preferences.
- Select a block of data in WorldWatch Watch Insight. Drag & Drop
- Click and hold the left mouse button while pointing in the selected block. Drag the block to Excel, then release the mouse button. The formula(s) will automatically be created in Excel. Copy & Paste
- Select Edit\Copy from the WorldWatch menu. Click in Excel. Select Edit\Paste from Excel’s menu.
Note: WorldWatch Insight is not required to be open for the links to remain live in Excel.
Typing the Formula Into Excel
You may type the required formula into any Excel cell and create a live link to data available on the Netfeed Server.
This is an example formula: =MLINK|MFDC!’.DJI,LAST’ The formula must always be in UPPER CASE.
This example formula links the current value of the Dow Jones Index, as published by Marketfeed, into the cell.
You will always use this part: =MLINK|
This part is used for the Marketfeed data feed: MFDC!
This part refers to the quote or page symbol and the data : ’.DJI,LAST’
To type a quote link, use the symbol, then the data element. The data element is indicated either by a MarketLink-recognized name, called a literal, or the FID (field identification number).
Some MarketLink recognized literals and the associated FID:
- LAST (6)
- ASK (25)
- HIGH (12)
- NETCHNG (11)
- BID (22)
- HST_CLOSE (21)
- LOW (13)
- PCTCHNG (56)
Use the MarketLink manual for reference to other literals. Another example using the FID: =MLINK|MFDC!’IBM,6’ To type a page link, use the page name, row number, row offset(number of characters to left of desired data), the number of characters desired and a numeric(N) or string(S) designation. Example: =MLINK|MFDC!’MMKU,R3,19,4,S’
R3 refers to the row.
19 is the number of characters or spaces in front of the desired data.
4 is the number of characters in the desired data.
S is a 'string' request, allowing numbers or letters to be linked.
Note: Using N, for numeric data, would work here. N would not work if the desired data were 3MO, for example.
Opening a Spreadsheet with Live Links
Before opening a spreadsheet that was saved with live links, be sure that MarketLink is logged on to the Netfeed Server. When the spreadsheet opens, the following message appears: Select Yes to re-establish your live links.
|
