Discussions
»
Product and Service Development
»
MetaStock
»
HELP! How to develop a new chart using data from excel file?
Rank: Newbie
Groups: Registered, Registered Users
Joined: 1/4/2006(UTC)
Posts: 5
|
Dear all,
I am new user of Metastock. I am currently using Real-time data.
Yet, I need to do an analysis of an overseas stock which does not have real-time data. However, I only have data of this stock in excel format. How can i create a metastock chart using Downloader?
Thanks in advance for any helpful reply.
Whitehorse
:cry:
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 3/19/2005(UTC)
Posts: 2,995
Was thanked: 14 time(s) in 10 post(s)
|
Hi wh-
The format that the Downloader is looking for is exactly this:
Symbol, periodicity, date, time, open, high, low, close, volume, and open interest.
There is more than one way to do this, but one way to convert your Excel file is to open the Downloader and select TOOLS | CONVERT, then follow the prompts. This method will create a new security file that you can open directly in MS. Another way to selectively import data for an existing security is to copy the data from Excel to the clipboard. Open the security to be modified in the Downloader using FILE | OPEN. Then highlight the area(s) that you want the clipboard data to occupy and paste it into place.
|
|
|
|
|
|
Rank: Newbie
Groups: Registered, Registered Users, Subscribers
Joined: 5/9/2006(UTC)
Posts: 1
|
Can I use another downloader program to download data into MetaStock?
The program I am using is called Sharenet download service from South Africa.
The history database I managed to import successfully but I can't get the daily downloaded files
into MS.
PSE can somebody help!
A.M.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 3/19/2005(UTC)
Posts: 2,995
Was thanked: 14 time(s) in 10 post(s)
|
I believe that this can only be done manually. If you just want a chart view, you might consider linking the data DDE from Excel or another application.
|
|
|
|
|
|
Rank: Newbie
Groups: Registered, Registered Users
Joined: 1/4/2006(UTC)
Posts: 5
|
StorkBite wrote:Hi wh-
The format that the Downloader is looking for is exactly this:
Symbol, periodicity, date, time, open, high, low, close, volume, and open interest.
There is more than one way to do this, but one way to convert your Excel file is to open the Downloader and select TOOLS | CONVERT, then follow the prompts. This method will create a new security file that you can open directly in MS. Another way to selectively import data for an existing security is to copy the data from Excel to the clipboard. Open the security to be modified in the Downloader using FILE | OPEN. Then highlight the area(s) that you want the clipboard data to occupy and paste it into place.
Dear Administrator,
Thank you for your reply. I did not have MS with me now. I will follow and try when I get to office.
By the way, one more question: how to update the chart/ I mean...end-of-day, I will update my excel file. So how can I update the MS chart?
Thanks again for your attention and your assistance.
:D
|
|
|
|
|
|
| Users browsing this topic |
|
Guest (Hidden)
|
Discussions
»
Product and Service Development
»
MetaStock
»
HELP! How to develop a new chart using data from excel file?
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.
