Hello,
I am running MC6 on Windows 7 64-bit.
I have many historical data in .csv format that I would like to import.
At the moment, I am importing each file manually in QuoteManager.
Is there a way to programme some sort of script (like an Excel VBA script) that would:
1. Look for keywords in each filename of a folder
2. Will import the file if the keyword matches the symbol name in QuoteManager.
3. Will then delete the file and look for other filenames with matching keywords.
Many thanks,
Mass data import
-
- Posts: 103
- Joined: 05 Sep 2007
- Has thanked: 8 times
- Been thanked: 6 times
Re: Mass data import
Hi,
you could try with :
http://www.xstarter.com/
but it really depends how many symbols you have in QuoteManager and if you add some (it change the position of each in the list)
If you have few symbols and many file for each symbol, it's quicker to concat data file before import them manually.
If you add data often maybe it's better to use "Map ascii" (in menu file) than import data
In all case it's a boring job...
you could try with :
http://www.xstarter.com/
but it really depends how many symbols you have in QuoteManager and if you add some (it change the position of each in the list)
If you have few symbols and many file for each symbol, it's quicker to concat data file before import them manually.
If you add data often maybe it's better to use "Map ascii" (in menu file) than import data
In all case it's a boring job...
Hello,
I am running MC6 on Windows 7 64-bit.
I have many historical data in .csv format that I would like to import.
At the moment, I am importing each file manually in QuoteManager.
Is there a way to programme some sort of script (like an Excel VBA script) that would:
1. Look for keywords in each filename of a folder
2. Will import the file if the keyword matches the symbol name in QuoteManager.
3. Will then delete the file and look for other filenames with matching keywords.
Many thanks,