|
PureBytes Links
Trading Reference Links
|
Hi,
Assuming you have version 97 or above of Excel then the following lines of
code in a worksheets codemodule will put a timestamp next to the cell being
changed. It will only look for changes in the first column.
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target.Column = 1 Then
Target.Offset(0, 1) = Now
End If
End Sub
I think the chartissue is best solved by separating incoming data from the
array used by the chart. The latter could for example take only the x:th
latest items from the first dataarray. The chart would then look at a fixed
array (in size and place) but with changing values.
I hope this helps
Jonas
> -----Original Message-----
> From: Johan Labuschagne [mailto:johan@xxxxxxxxxxx]
> Sent: den 20 februari 1999 11:24
> To: omega-list@xxxxxxxxxx
> Subject: Graph from DDE link in EXCEL-Help
>
>
> Hi
> I am a newbie in a country where Omega does not allow their
> file format for
> intra day (any) downloading.
>
> As a solution I now can get a 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
>
>
|