Rank: Newbie
Groups: Registered, Registered Users, Subscribers Joined: 9/9/2009(UTC) Posts: 1
|
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.
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users Joined: 5/20/2008(UTC) Posts: 53
|
The easiest way to do that would be to buy HQuote Pro. It's something like $ 50.
|
|
|
|
Rank: Member
Groups ready for retrieval: Registered, Registered Users, Subscribers Joined: 9/5/2009(UTC) Posts: 18
|
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.
|
|
|
|
Rank: Member
Groups: Registered, Registered Users Joined: 10/25/2009(UTC) Posts: 11
|
did you write that software?..I am so looking forward for it
|
|
|
|
Users browsing this topic |
Guest (Hidden)
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.