Discussions
»
Product and Service Development
»
Data Related Questions
»
Remove the need to input ticker symbol everytime I convert data in downloader - HELP PLEASE
Rank: Newbie
Groups: Registered, Registered Users
Joined: 2/21/2011(UTC)
Posts: 5
|
Hi All,
Just started using metastock, and could not find the solution to my problem any where, so any help would be appreciated.
I have multiple csv files that i convert from ASCII text to metastock. (EOD data on each US stock listed on DOW, NASDAQ, etc )
Every single time as I convert the files - it asks me to input a ticker symbol.
I convert about 300 stocks daily, so its 300 time consuming clicks everyday as the downloader converts each security.
Any help or suggestion would be great!
Thank you all.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 3/6/2010(UTC)
Posts: 113
Location: London
|
Your CSV files should contain a ticker column. What is the source of the files, if you don't mind me asking?
|
|
|
|
|
|
Rank: Newbie
Groups: Registered, Registered Users
Joined: 2/21/2011(UTC)
Posts: 5
|
Hi there, my csv files basically has 5 columns, ohlc prices and volume. no ticker symbol, the only way to identify it is the csv file name.
more than happy to send you a file.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 3/6/2010(UTC)
Posts: 113
Location: London
|
Your data probably looks something like this: Quote:<date>,<open>,<high>,<low>,<close>,<volume>
2/24/2011,10.2,10.5,10.1,10.3,1234 To stop the Downloader asking for the ticker symbol each time, it should look like this (maximum no. of characters in ticker symbol is 14) Quote:<ticker>,<date>,<open>,<high>,<low>,<close>,<volume>
SAMPL,2/24/2011,10.2,10.5,10.1,10.3,1234 You could use Excel or an advanced text editor (e.g. Notepad++), record and run a macro to automate the process. Alternatively, if you want you could use keyboard emulator software that "presses" the enter key x number of times. You might also be interested in creating a custom symbol file: http://forum.equis.com/forums/thread/19533.aspxSorry if my solutions may seem difficult to implement, but I don't know an easier method, apart from using a third party software that would do all this for you, if you know any.
|
|
|
|
|
|
| Users browsing this topic |
|
Guest (Hidden)
|
Discussions
»
Product and Service Development
»
Data Related Questions
»
Remove the need to input ticker symbol everytime I convert data in downloader - HELP PLEASE
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.
