|
PureBytes Links
Trading Reference Links
|
Jose:
Perhaps I don't understand, but I tried two different approaches:
neither worked.
1. Plotted a 1 period SMA ON the monthly data/monthly chart. Then did
a Ctrl-C of the SMA to an inner window on the daily chart. Just got a
series of dots; one on the first day of each month.
2) Copied the monthly data to the daily chart. (this plots a series of
dots on the first day of each month). Then plotted a 1 period SMA in
that window. Got 1 dot/month on top of the monthly data dots.
Did I misinterpret what you were suggesting?
Harry
--- In equismetastock@xxxxxxxxxxxxxxx, "Jose Silva" <josesilva22@xxxx>
wrote:
> 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 --------------------~-->
What would our lives be like without music, dance, and theater?
Donate or volunteer in the arts today at Network for Good!
http://us.click.yahoo.com/Tcy2bD/SOnJAA/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/
|