|
PureBytes Links
Trading Reference Links
|
Sorry that my reply had to be send in 3 mails...............
>The DDE link is in one exel cell and I want to draw a graph with time and
>price as the two axis.
See the other 2 mails as in how to split cells. Now link any other cell in the sheet, by
typing the following formula in the new cell:
=B906
where:
= is the attention signal for Excel to know that a formula follows
B906 is the value referenced, eg the cell in column B and on Row 906
Now you can also choose to reference any of these cells in any cells somewhere else in
the sheet, cells singly or cells that are part of a (your) particular sequence of cells.
If cell B1,C1 and B4,C4 and B8,C8 etc. are the data feeds' every 20min (split-up) data cells,
and B2,C2 and B3,C3 the other 5min. cells, then you could start a brand new column
(say column D and E) and have in these new columns' cells the cells D1(=B1), E1(=C1)
and D2(=B4), E2(=C4) and D3(=B8), E3(=C8) etc., to reference to the in column A choosen
cells by using the above (is equal to, is content from) formula.
Highlighting(=black) on sheet1 these D and E-columns' new cells will have these cells being
selected, then Click Copy, and on the workmenu bar Click on "Insert|Worksheet" and in the
new worksheet's upper left cell A1 paste and link the clipboards' data(sheet1) as Paste Link,
this will then have the A and B column on this sheet2 to be activated as well.
So:
-sheet1 is the received daily feed
-sheet2 is the to sheet1 linked 20min feed
-sheet3 is the to sheet2 linked 20min Chart
To create this sheet3 and Chart:
On the workmenu Click "Insert|Worksheet" for another sheet to be added to the workmap,
highlight the sheet's TAB at the very bottom(if it isn't already) and Click on the Graphics-button
at the button bar(s) at the top, or choose "Insert|Chart" from the workmenu bar.
In the Chart Wizard refer to the "20min" cells on sheet2, or when working in the same sheet
an easier way is to Select the cells (like in sheet2) prior to starting a "new" Chart, eg prior to
starting the Chart Wizard.
When the Wizard starts choose a type(try Line) and choose the particular type(see the examples
given). Press Next and as the DataRange type the range for the data cells on sheet2 or Click
the squared tiny box to enable you to Select the cells for the Range. Also Apply Columns.
In the above example the Range should look like this:
=Sheet2!$A$1:$B$50
where:
= is the standard "for Excel only" formula reminder
Sheet2 is the sheet mentioned above
! is the symbol character for the Link (always to be followed by Range)
$A$1 is start of Range (read as From)
: is the Range's begin and end seperator
$B$50 is end of Range (read as To)
Note:
the $ character sets a fixed column and a fixed Row and this linking a particular
range on a particular sheet is then not (a) variable (anymore)
Now finishing the Wizard will then have the Chart to pop-up and for any adjustments to be made
on the Chart's Layout, Clock the build-in Help, read on up in books and do lots of fiddling and
practising on it and then will get you to have Charts' arrangements to be set as in how you would
like the Chart to be arrangend.
For more in depth information also be refered to your ISP or News program for any of the Excel,
Excel97, Excel2000beta newsgroups on Usenet, eg:
msnews.microsoft.com
Regards,
Ton Maas
ms-irb@xxxxxx
>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!
----- 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
>
|