[EquisMetaStock Group] Plotting monthly data on a daily chart

["bex1210" <hmw3@xxxxxxxxxxxxxx>]

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 --------------------~--> 
Has someone you know been affected by illness or disease?
Network for Good is THE place to support health awareness efforts!
http://us.click.yahoo.com/Rcy2bD/UOnJAA/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/