Discussions
»
Product and Service Development
»
MetaStock
»
The downloader and import data from excel (xlsx)????
Rank: Newbie
Groups: Registered, Registered Users
Joined: 9/5/2012(UTC)
Posts: 4
|
I use metastock for technical analysis, I recently tried to import data from excel (xlsx) the last five years the stock market values since the format (xls) has only 65,000 lines. The downloader didn't recognize the data file format (xlsx) to convert. How can I solve this problem.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 3/6/2010(UTC)
Posts: 113
Location: London
|
I don't think it is possible to convert from xlsx, only xls.
Even if you have more than 65,000 lines in the xlsx file, The Downloader only supports this number of lines anyway, so it wouldn't make a difference.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 5/13/2005(UTC)
Posts: 715
Location: Midwest, USA
Was thanked: 1 time(s) in 1 post(s)
|
|
|
|
|
|
|
Rank: Newbie
Groups: Registered, Registered Users
Joined: 9/5/2012(UTC)
Posts: 4
|
How do you introduce to the stock market data if they are huge?? do you divide your database?
|
|
|
|
|
|
Rank: Newbie
Groups: Registered, Registered Users
Joined: 9/5/2012(UTC)
Posts: 4
|
How do you introduce to the stock market data if they are huge?? do you divide your database?
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 3/6/2010(UTC)
Posts: 113
Location: London
|
Yes. I do this all the time. I wrote my own program to do this.
|
|
|
|
|
|
Rank: Newbie
Groups: Registered, Registered Users
Joined: 9/5/2012(UTC)
Posts: 4
|
Thx for your reply, but can i ask you pls what kind of program do you use??
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 3/6/2010(UTC)
Posts: 113
Location: London
|
The program is a Windows EXE that I wrote in C# .NET.
I download a lot of data from ForexTester dot com - they have free historical intraday forex data going back to 2001 (updated monthly). The format is the correct Metastock format except the number of lines, i.e. the files are huge and over 1 million lines, so I split them into smaller files.
If you PM me one of the files you have, I can split it into smaller files for you for free. I don't know whether you can send large attachments over PM or whether the mods accept this. If they don't, then I apologise!
|
|
|
|
|
|
| Users browsing this topic |
|
Guest (Hidden)
|
Discussions
»
Product and Service Development
»
MetaStock
»
The downloader and import data from excel (xlsx)????
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.
