[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[EquisMetaStock Group] Re: Plotting monthly data on a daily chart



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/