PureBytes Links
Trading Reference Links
|
The simplest solution that comes to mind, is to plot a 1-period moving
average of the monthly data on a daily chart.
jose '-)
http://www.metastocktools.com
--- In equismetastock@xxxxxxxxxxxxxxx, "bex1210" <hmw3@xxxx> wrote:
> I have MS 8.01. I have data which is supplied in a monthly format,
> which I want to plot on a daily chart. I want to plot a point every
> trading day.
>
> My data looks like this:
> 1/3/2005 23.14
> 1/4/2005
> 1/5/2005
> x
> x
> 1/31/2005
> 2/1/2005 27.54
> 2/2/2005
> x
> x
>
> I want in to look like this:
> 1/3/2005 23.14
> 1/4/2005 23.14
> 1/5/2005 23.14
> x 23.14
> x 23.14
> 1/31/2005 23.14
> 2/1/2005 27.54
> 2/2/2005 27.54
> x 27.54
> x 27.54
>
> I know that I can use Excel and a brute force manual method; but I
> have 30 years of this monthly data. So I am wondering if someone has
> a clever way of "automating" this process?
>
> Thanks in advance,
>
> Harry
------------------------ Yahoo! Groups Sponsor --------------------~-->
In low income neighborhoods, 84% do not own computers.
At Network for Good, help bridge the Digital Divide!
http://us.click.yahoo.com/EpW3eD/3MnJAA/cosFAA/BefplB/TM
--------------------------------------------------------------------~->
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/equismetastock/
<*> To unsubscribe from this group, send an email to:
equismetastock-unsubscribe@xxxxxxxxxxxxxxx
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
|