converting daily data to weekly and monthly

["Walter Lake" <wlake@xxxxxxxxx>]

I don't know how the Metastock approach works exactly, maybe Ton can add
this to his wonderful collector's articles about Metastock-Excel links.

I think that you have to create a new security, i.e., Wahoo_weekly because
once you start a security with daily data in Downloader you can't switch it.

This is a quote from the Downloader Help files:

"... Periodicity.  Choose the desired periodicity for the security.  Choose
Intraday if you want to maintain intraday price data (e.g., tick, 5-minute,
hourly, etc.).  Choose Daily if you want to maintain price data for each day
that the security trades.  Choose Weekly if you want to maintain price data
for the security on a weekly basis (Friday to Friday).  Choose Monthly if
you want to maintain price data for the security on a monthly basis
(month-end to month-end).

Note that once the periodicity is chosen for the security, it cannot be
changed.  You can only choose the periodicity for a security when it is
first added. ..."

So, I guess that you take your daily data in XL ... run it into MS ...
create a new security in monthly format ... then run it back into XL. I
don't know what the limit is ... but 30 year continuous contracts are
probably going to be well over MS's limits <G>

Best regards

Walter