|
PureBytes Links
Trading Reference Links
|
CMA wrote:
>
> Has anyone figured out how to
> 1) get free end-of-day data from the net;
> 2) import that ASCII file into Excel;
> 3) manipulate the data in Excel to produce a file,
> 4) which Downloader can use to update MSPRO?
>
> 1) and 2) should be quite easy; but 3) and 4) could be tough.
> CMA
>
You don't need Excel, the Downloader and text editor will do the job -
please, see the attached text file.
BTW, we are supplying custom made DownLoader's add-on for converting
virtually any ASCII file into MetaStock. The utility is transparent for
user - you only see additional "Preconvert" buttom on Convert dialogue
(see the attached GIF file).
If you want details, please contact me by private e-mail.
Regards,
Zvi
--
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
_/ _/
_/ ZVI OREN, CONSILIUM e-mail: consilium@xxxxxxx _/
_/ 6 Bartenurah St., Petah-Tiqwa tel: 972-3-9224720 _/
_/ 49330, Israel fax: 972-3-9242182 _/
_/ _/
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
Attachment Converted: "c:\eudora\attach\preconv11.gif"
In order for an ASCII source file to convert properly, the file must be
arranged correctly. Use any text editor to arrange data in the ASCII
comma delimited file as:
<ticker>,<per>,<date>,<time>,<open>,<high>,<low>,<close>,<vol>,<o/i>
A header line can be placed at the top of the ASCII file to specify the
arrangement of the data. This allows you to arrange the data in any
order you wish. The line below shows this:
<date>,<vol>,<high>,<low>,<close>,<ticker>
Open Metastock and start Downloader from Metastock's Tools Menu. From
Downloader's Tools Menu, select Convert. This will give you the
Convert Securities pop up window. Select ASCIl text for the Source
File type, then provide the folder and file name of your ASCll file.
For the Destination File type select MetaStock followed by the file name
and folder in which you wish to save the converted data. Then click on
the Options button and select any of the conversion options you wish.
When you are finished, click the OK button and your files will be
converted to Metastock.
|