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 suppose that you could assign a symbol of some sort, then use the name listed in your data. Once you have the symbold created, you could manually enter the data you want using the Downloader. e.g., Horizon US Equity Fund USD USD 0.489 N.A 13 Jan 2006 might be converted as follows:
<ticker>,<per>,<date>,<high>,<low>,<close>,<vol>
HUSE1,D,060113,0,0,0,0.489
FAQ wrote:How to create a custom symbol file
-Open a new ASCII file in a text editor (e.g. WordPad, Notepad).
-Type the list of securities to add to the symbol database using one of the following formats:
OPTION 1
,,
Example:
Microsoft,MSFT,NASD
Apple Computer,AAPL,NASD
Oracle,ORCL,NASD
Iomega,IOM,NYSE
There should be no spaces before or after commas. Each individual security must be entered on a separate line in the text editor. The and entries are completely optional.
OPTION 2
Example:
MSFT
AAPL
ORCL
IOM
In this example above, the ASCII file contains only one field per line (I.e., the symbol). Since the is not provided, The DownLoader will attempt to provide a from the existing Symbol Database. For example, since the Symbol Database in The DownLoader associates the symbol 'MSFT' to the security name 'Microsoft' the name 'Microsoft' will automatically be used in the field. However, if The DownLoader does not find a match for the in the existing list, the symbol itself will be used in place of the .
-Save the ASCII file with the extension '.SYM' (e.g. 'COMPUTER.SYM')
Note that when you save the file in Notepad or WordPad, you should choose 'All Files' from the Files of type drop list. If you do not, a '.TXT' extension will be added after the file name (e.g. 'COMPUTER.SYM.TXT'). If this happens, rename the file in Windows Explorer so the Symbol Database will correctly recognize the file format.
-Place the ASCII file in the same folder as The DownLoader program.
(E.G. 'C:\\Program Files\\Equis\ he DownLoader')
-Open The DownLoader and display the Symbol Database.
-The name of the newly created Symbol Database file will be displayed in the type menu of the Symbol Database.
You'll have to play with it to get the format that you desire. I used the vol column as a placeholder in the above example. That is obviously wrong. Also, search the forum for 'data conversion'. You might get some more ideas.
HTH,
|
