[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Problem with Downloader and Creating a New Security



PureBytes Links

Trading Reference Links

Kornberg Family wrote:

>  Hi,I trade the Australian market and have tried to create a "new"
> security - the DOW! I sourced historical data from Yahoo and
> downloaded it into csv format.The fields were correct in the
> file:date,open,high,low,close (an example of the data appears below)
>
> 990827,11198.45,11295.33,11021.15,11090.17
>
> 990826,11326.04,11393.48,11133.86,11198.45
>
> 990825,11282.38,11428.94,11106.31,11326.04
>
> 990824,11297.54,11404.88,11135.76,11283.3
> I then used the downloader to convert the ascii data into Metastock
> format.  As no ticker was listed in the file, when prompted I put in
> DOW.  The conversion went happily along.  The problem is that the
> following data appeared in the Metastock FileDate Open High Low Close
> Volume08/25/1999 11106.3 11282.4 11428.9 11106.3 11326 0
> 08/26/1999 11133.9 11326.0 11393.5 11133.9 11198 0
> 08/27/1999 11021.2 11198.5 11295.3 11021.2 11090 0
> It appears that somehow the downloader has transposed the column data
> and copies the data to volume.  My daily download data is in the same
> format with no hitches!Any suggestions would be gratefully accepted.
> [Andrew :-)]

Hi Kornberg,

Should you be interested in getting free end of day quotes for Metastock
from yahoo, I would
strongly advise you going to http://www.xmlworks.com and downloading the
Quotemonster program. It is less than about 50Kb.

There is also a link to download the perl binary which you will also
need. Once downloaded all you will have to do is execute the script e.g

c:\nyse\perl qm 900102 990831 to update all the securities in the
tickers.txt file from the 1st of January 1990 to present date.
These csv files will then be correctly imported into metastock format
with the downloader. It works great.Should you not be able to get it
working, I would gladly send you my script bat files and some crontabs.

The only downside to this is yahoo does not include volume on the Dow
Industrials and transportations. Anyway one cannot complain for free
stuff.

Regards
Shawn  Andrew


--
"It's not whether you are right or wrong that matters.
But how much money you make when right and how much you don't lose when
wrong."
       - George Soros

<x-html><!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<html>
<body bgcolor="#FFFFFF">
Kornberg Family wrote:
<blockquote TYPE=CITE>&nbsp;<span 
class=150190407-31081999><font face="Arial"><font size=-1>Hi,</font></font></span><span 
class=150190407-31081999></span><span class=150190407-31081999><span class=150190407-31081999><font face="Arial"><font size=-1>I
trade the Australian market and have tried</span> to create a "new" security
- the DOW!&nbsp;<span class=150190407-31081999>I sourced historical data
from Yahoo and downloaded it into csv format.</font></font></span><span class=150190407-31081999></span><span class=150190407-31081999><font face="Arial"><font size=-1>The
fields were correct in the file:</font></font></span><span class=150190407-31081999></span><span 
class=150190407-31081999><font face="Arial"><font size=-1>date,open,high,low,close
(an example of the data appears below)</font></font></span><span class=150190407-31081999></span><span class=150190407-31081999>
<p><span 
class=150190407-31081999></span><font face="Arial"><font size=-1>990827,11198.45,11295.33,11021.15,11090.17</font></font>
<p><font face="Arial"><font size=-1>990826,11326.04,11393.48,11133.86,11198.45</font></font>
<p><font face="Arial"><font size=-1>990825,11282.38,11428.94,11106.31,11326.04</font></font>
<p><font face="Arial"><font size=-1>990824,11297.54,11404.88,11135.76,11283.3</font></font>
<br></span><span class=150190407-31081999></span><span class=150190407-31081999><font face="Arial"><font size=-1>I
then used the downloader to convert the ascii data into Metastock format.&nbsp;
As no ticker was listed in the file, when prompted I put in DOW.&nbsp;
The conversion went happily along.&nbsp; The problem is that the following
data appeared in the Metastock File</font></font></span></span><span 
class=150190407-31081999></span><span class=150190407-31081999><font face="Arial"><font size=-1>Date
Open High Low Close Volume</font></font></span><span 
class=150190407-31081999></span><span 
class=150190407-31081999><font face="Arial"><font size=-1>08/25/1999
11106.3 11282.4 11428.9 11106.3 11326 0</font></font>
<br><font face="Arial"><font size=-1>08/26/1999 11133.9 11326.0 11393.5
11133.9 11198 0</font></font>
<br><font face="Arial"><font size=-1>08/27/1999 11021.2 11198.5 11295.3
11021.2 11090 0</font></font>
<br></span><span 
class=150190407-31081999></span><span class=150190407-31081999><font face="Arial"><font size=-1>It
appears that somehow the downloader has transposed the column data and
copies the data to volume.&nbsp; My daily download data is in the same
format with no hitches!</font></font></span><span 
class=150190407-31081999></span><span class=150190407-31081999><font face="Arial"><font size=-1>Any
suggestions would be gratefully accepted.</font></font></span><span 
class=150190407-31081999></span><span class=150190407-31081999><img SRC="cid:part1.37CBA031.19FD9E@xxxxxxxxxxxxx"; ALT="Andrew :-)" BORDER=0 ></span></blockquote>

<p><br>Hi Kornberg,
<p>Should you be interested in getting free end of day quotes for Metastock
from yahoo, I would
<br>strongly advise you going to http://www.xmlworks.com and downloading
the Quotemonster program. It is less than about 50Kb.
<p>There is also a link to download the perl binary which you will also
need. Once downloaded all you will have to do is execute the script e.g
<p>c:\nyse\perl qm 900102 990831 to update all the securities in the tickers.txt
file from the 1st of January 1990 to present date.
<br>These csv files will then be correctly imported into metastock format
with the downloader. It works great.Should you not be able to get it working,
I would gladly send you my script bat files and some crontabs.
<p>The only downside to this is yahoo does not include volume on the Dow
Industrials and transportations. Anyway one cannot complain for free stuff.
<p>Regards
<br>Shawn&nbsp; Andrew
<br>&nbsp;
<p>--
<br>"It's not whether you are right or wrong that matters.
<br>But how much money you make when right and how much you don't lose
when wrong."
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; - George Soros
<br>&nbsp;
</body>
</html>
</x-html>
Attachment Converted: "c:\eudora\attach\00FF000002011.gif"