Mass data import

Questions about MultiCharts and user contributed studies.
duration
Posts: 175
Joined: 20 Dec 2005

Mass data import

Postby duration » 14 Feb 2011

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,

rondot samuel ws
Posts: 103
Joined: 05 Sep 2007
Has thanked: 8 times
Been thanked: 6 times

Re: Mass data import

Postby rondot samuel ws » 22 Feb 2011

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...


duration wrote: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,


Return to “MultiCharts”