logo
Welcome Guest! To enable all features please Registers on the forum or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
sarcasm  
#1 Posted : 12 years ago
sarcasm

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.
haddison  
#2 Posted : 12 years ago
haddison

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.
jjstein  
#3 Posted : 12 years ago
jjstein

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)
sarcasm  
#4 Posted : 12 years ago
sarcasm

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?
sarcasm  
#5 Posted : 12 years ago
sarcasm

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?
haddison  
#6 Posted : 12 years ago
haddison

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.
sarcasm  
#7 Posted : 12 years ago
sarcasm

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??
haddison  
#8 Posted : 12 years ago
haddison

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)
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.

information You have 1 unread message(s) in your Inbox.