|
PureBytes Links
Trading Reference Links
|
You can split a cell's contents, containing OLE linked data, to other cells in the sheet.
When using MetaStock to OLE link data (indicators) to Excel, this will work from physical
Charts only (eg the "xxxxxx.MWC" files, where x is the name). Chats always, as being an
unique file type, require registration in Win95/98/NT.
Split the cells by using the "function catagories" found in the Excel formula's function Toolbox.
(note: formula is taken from the "Text" function category)
-in a spreadsheet Click on a cell left at the top
-Select, by pressing down the left mouse button and moving the mouse down the sheet whilest
staying within the or a column, any of the required cells
-this will highlight(=black) the selected -in one straight move selection- cells
-let the mouse pointer float above the highlighted selection and right Click the mouse
-Press "Paste Special" and in the next Dialog Window Click on "Paste Link as CSV" for the
Charts' Price(Close) indicator or any other indicator to be OLE linked
-give the processor enough time to "calculate" and process the Link(also this depends upon the
amount of cells selected for the Link)
-When Link is visable in a cell usualy(depending on Link's choosen underlaying object) the
following contents will be displayed(printed) in the cell
19980226,1550.75
where:
the comma character seperates the Date from the Price
-Click on any blanc cell on the right and paste or type the following(in the formula editor or in the cell)
=DIVIDE(T(A903);1;6)
-and in another cell on the right paste or type
=DIVIDE(T(A903);8;24)
where:
= is the character used to announce to Excel the new start of a formula
DIVIDE("cell #";"first position";"last postion") is the function(formula should not contain any spaces)
and where:
"cell #" is the OLE cell cross-rate number (eg the cells positition on sheet)
; is a seperator character(semi-colon)
"first position" is the first OLE cell's character (eg the 1)
; is a seperator character(semi-colon)
"last position" is the last charcter (eg the 6) of the OLE cell's first linked part(eg the Date)
Note here that a seperator is also counted as a single induvidual position( or character)
and that in the second formula, the OLE cell's second linked part(eg the Price) is being transited, eg
the 8 is the 8th position in the original OLE cell and the 24 is being used as the last character position
(most of the time using 24 will cover for most positions(eg large values/Prices).
Finaly, the T("text") function calls on the text being Cells solid "displayed" contents in the OLE link.
Also, the DDE(dynamic data exchange) is not the same Object Linking and Embedding
orientated as OLE is, and should therefore not be used as the Name for the above linking of
objects(eg the Charts or the charts' Indicators) to any documents or spreadsheets.
Linking Data from Excel to Metastock "can" give mutulated indicators, eg due to reasons like not
having synchronised dates for the data sheet(s) used, eg when linking data from Metastock to Excel
and having calculations done on only certain periods and linking these results back to Metastock.
Regards,
Ton Maas
ms-irb@xxxxxx
----- Original Message -----
From: Johan Labuschagne <johan@xxxxxxxxxxx>
To: <metastock@xxxxxxxxxxxxx>
Sent: vrijdag 26 februari 1999 7:56
Subject: Excel and DDE link -- Help!
>Hi
>I am a newbie in intraday charting with EOD programs. I now can get a
>Intraday data feed with a DDE link into Excel.
>
>The DDE link is in one exel cell and I want to draw a graph with time and
>price as the two axis.
>
>My Question:
>How do you get this DDE link cell be date and time stamped and copy it to
>another line (all the time) to build a database to plot say every 20
>minutes in EXCEL??
>
>Any VB trick, macro or anything that can help is welcome!
>
>Thank you very much for your time!
>Johan Labuschagne
>
|