in Search

downloading yahoo data

Last post 10-25-2009, 14:01 by muheeb. 3 replies.
Sort Posts: Previous Next
  •  09-08-2009, 19:51 30633

    downloading yahoo data

    Hi all. It has probably been asked before but there's too many posts to wade through to find. I'm having trouble converting csv files to metastock, from yahoo. Can someone run it through step by step?  I have Professional 8 version. Thanks.
  •  09-09-2009, 16:07 30646 in reply to 30633

    Re: downloading yahoo data

    The easiest way to do that would be to buy HQuote Pro.  It's something like $ 50.
  •  09-13-2009, 14:55 30715 in reply to 30646

    Re: downloading yahoo data

    I think it's 70 euros now. I also believe it's too much for data you can get for free with a few lines of code.

    I've also had this problem with csv files and i think i've figured it out now:
    - open the csv file in Excel
    - chose "save as" and chose the file type ".xls"

    You can then use the Downloader that comes with MetaStock: from the top menu -> Tools->Convert, chose Excel file type for the source file and the rest I think you can manage by yourself.

    In my case, the convertion stopped with an error: "maximum warnings exceeded". If this happens to you too, open the "Convert" dialog again. Chose "Options" and set the "Message Limits" (you'll see 2 fields there: "max errors" and "max warnings") to a higher value. I've set it to 25000, and the process completed successfully :D

    But what I've done was to supress the warnings resulting from the convertion. The donwloader did not tell me what those warnings were about, it just gave me the error I've mentioned above. Now I'm not sure if I can trust the data. I've checked a few random values against the values on yahoo website and they were correct....but i'm still worried...

    And vekian, don't rush into throwing your money on software to download free data. I'll be writing my own software for this and i'll make it available for free of course. And i'm planning to have this done very soon.
  •  10-25-2009, 14:01 31003 in reply to 30715

    Re: downloading yahoo data

    did you write that software?..I am so looking forward for it
View as RSS news feed in XML