|
PureBytes Links
Trading Reference Links
|
Because of the millenium, the dates format have also changed, eg positions for the year from
2 to 4 positions and therefore the formula should also read as follows:
=DIVIDE(T(A903);1;8)
-and in another cell on the right paste or type
=DIVIDE(T(A903);10;24)
Also note that I have used a custom "Close Only" indicator(eg, C) as underlay(=chart object),
created in a seperate OLE folder holding my OLE Charts, and ofcourse selected and clicked
the Copy option givin in Metastock, prior before "Paste Link"ing it into the Excel sheet, eg in
this instance into the cell in Column "A" and on Row "903".
The cell "A904" now reads the Date like 19990226 and the cell "A905" now reads the Price
like 1550.75 (note the dot " . " is a character or position as well)
(you can alter the sequences by tweaking the formula and also by using more cells to break-up
the segment parts over more cells, eg "A904" =1999 and "A905" = 02 and "A906" = 26 and
"A907" = 1550 only)
To plainly ommit the century and have cell "A904" reading as 99 , then the first formula should
read as follows:
=DIVIDE(T(A903);3;8)
Regards,
Ton Maas
ms-irb@xxxxxx
----- Original Message -----
From: A.J. Maas <anthmaas@xxxxxx>
To: <metastock@xxxxxxxxxxxxx>
Sent: zaterdag 27 februari 1999 0:36
Subject: Re: Excel and DDE link -- Help!
>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
>>
>
>
|