Discussions
»
Product and Service Development
»
MetaStock
»
Problem on Creating New Security and Convert
Rank: Newbie
Groups: Registered, Registered Users
Joined: 3/29/2009(UTC)
Posts: 4
|
1.) I have data in .CSV so I converted to .XLS.
2.) It's 1 minute YMM9.
The steps I did were in the pictures and also the problem.
What did I do wrong?
1.) Does date have to be converted to " / " instead of " . "
I changed that but still get the same problem
2.) Is there any wrong settings at my security creating stage?
3.) My YMM9 doesn't even show its name for chart opening in Metastock
but my newly created daily chart has. How would I solve this problem?
|
|
|
|
|
|
Rank: Newbie
Groups: Registered, Registered Users
Joined: 3/29/2009(UTC)
Posts: 4
|
|
|
|
|
|
|
Rank: Newbie
Groups: Registered, Registered Users
Joined: 3/29/2009(UTC)
Posts: 4
|
|
|
|
|
|
|
Rank: Newbie
Groups: Registered, Registered Users
Joined: 3/29/2009(UTC)
Posts: 4
|
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 10/28/2004(UTC)
Posts: 3,111
Location: Perth, Western Australia
Was thanked: 16 time(s) in 16 post(s)
|
Hi torofish, It pays to read the Downloader help file on the subject: Downloader Help File :: Quattro/1-2-3 and Excel Source File Layout wrote:
In order for a Quattro/1-2-3 or Excel source file to convert properly, the spreadsheet must be arranged correctly. This section explains the proper arrangement. Note that Quattro and 1-2-3 spreadsheets must be saved as WKS files to convert properly.
1. The data must be in columns. Each column must have a heading that describes what data is in the column. The only required columns are DATE and CLOSE. Optional columns are TICKER, PER, OPEN, HIGH, LOW, VOLUME, and O/I. The column names must be spelled as shown here. The column headings must all be on the same row.
2. The dates must be in the mm/dd/yy style and must be formatted as text labels (i.e., the @DATE function cannot be used).
3. The data must be in ascending order (dates increase as you move down the spreadsheet).
4. The spreadsheet cannot be open when attempting to perform the actual conversion in The DownLoader.
Hope this helps. wabbit [:D]
|
|
|
|
|
|
| Users browsing this topic |
|
Guest (Hidden)
|
Discussions
»
Product and Service Development
»
MetaStock
»
Problem on Creating New Security and Convert
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.
