|
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
>
Daniel,
You can read the data into EXCEL, as CSV text.
- Change the date format.
- Sort by date (ascending order)
- Insert columns for the symbol, period, and open interest
- Set the symbol to DJI, period to D, and open interest to 0
- Save the file in CSV text format
Now you can import into the DownLoader
Regards,
Tim
|