|
PureBytes Links
Trading Reference Links
|
Daniel Martinez wrote:
>
> MetaStock Users:
> I just downloaded the DOW (^DJI) from 1928 to the present. I rarely use the
> Downloader. Because the dates are in descending order, I don't know how to
> incorporate the data into MetaStock. Can anyone tell me how this is done?
>
> This is a sample of the data:
> Date,Open,High,Low,Close,Volume
> 30-Oct-1998,8591.58,8718.25,8481.39,8592.1001,7850000
> 29-Oct-1998,8371.22,8539.83,8305.5401,8495.03,6994000
> 28-Oct-1998,8372.7401,8504.04,8271.5501,8371.9701,6775000
> 27-Oct-1998,8503.7901,8586.69,8309.92,8366.04,7645000
> 26-Oct-1998,8483.96,8564.03,8349.57,8432.21,6099100
> 23-Oct-1998,8531.34,8589.01,8366.04,8452.29,6376400
> 22-Oct-1998,8519.03,8629.17,8334.12,8533.14,7549000
> 21-Oct-1998,8504.6701,8641.02,8380.7201,8519.23,7451000
> 20-Oct-1998,8540.0901,8713.62,8419.08,8505.85,9582000
>
> The dates don't appear to be in a MetaStock readable format. Since I'm rather
> new at using the Downloader, I'm not sure. If there is a utility which will
> reverse the order, please send me the URL or file.
>
Daniel,
If you intend to use this data frequently, we can supply you with
custom-made add-on to DownLoader, which will do the work.
But if it is only one-time job, use the text editor (Txtpad32 is my
choice):
1. "Replace all" -month- by number (e.g., -May- by 05).
2. Switch to "Block mode", "Cut" first 2 positions (day) from entire
file and "Paste" them after year, "Cut" next 2 positions (month)
and "Paste" them between year and day.
3. Return to regular mode.
4. Perform "Sort" by first 8 positions.
5. Add header as first line:
<DTYYYYMMDD>,<OPEN>,<HIGH>,<LOW>,<CLOSE>,<VOLUME>.
Now you have MetaStock compatible ASCII file!
Regards,
Zvi
--
===================================================================
"WE CAN MAKE ANY ASCII FILE METASTOCK-COMPATIBLE!"
ZVI OREN, CONSILIUM e-mail: consilium@xxxxxxx
|