Let's say there is data like this...
DATE,TIME,SYMBOL,OPEN,HIGH,LOW,CLOSE,VOLUME
20190930,1455,000250,33950,34000,33900,34000,3536
20190930,1500,000250,33950,34150,33950,34150,4819
20190930,1505,000250,34150,34150,34050,34100,2886
....
the number of symbols (000250 in the above lines) are ~2,800.
so it is not feasible to import them manually.
I know Multicharts cannot import multiple ascii symbols at once.
I wonder if Multicharts.Net can do it or not with C# programming.
and if it can, where can i get the references? (class name in the help file, examples...)
Importing multiple ascii symbols and data
Re: Importing multiple ascii symbols and data
I also tried to import the symbols and data with ASCII Mapping. (attached file)
ASCII Mapping can detect the files in the folder and the resolution in the files.
but it requires inputting "Symbol" which should be read from the file automatically.
otherwise "OK" button is not activated.
any method to import multiple symbols and data from text files??
ASCII Mapping can detect the files in the folder and the resolution in the files.
but it requires inputting "Symbol" which should be read from the file automatically.
otherwise "OK" button is not activated.
any method to import multiple symbols and data from text files??
- Attachments
-
- 1.jpg
- (59.63 KiB) Not downloaded yet
- Svetlana MultiCharts
- Posts: 645
- Joined: 19 Oct 2017
- Has thanked: 3 times
- Been thanked: 163 times
Re: Importing multiple ascii symbols and data
Hello, Idnotbe,
You can use the ASCII Mapping option (QuoteManager->File->Map ASCII):
https://www.multicharts.com/trading-sof ... ping_ASCII
To do it please change the file format at first — Symbol field should be on the first place
SYMBOL,DATE,TIME,OPEN,HIGH,LOW,CLOSE,VOLUME
000250,20190930,1455,33950,34000,33900,34000,3536
000250,20190930,1500,33950,34150,33950,34150,4819
000250,20190930,1505,34150,34150,34050,34100,2886
Then please follow the steps:
1. Open ASCII Mapping window and select the path to the file.
2. Select File’s field radio button
3. After that the file is displayed as 2800 strings in the ASCII Mapping dialogue.
Also, a Symbol column containing each symbol from your file appears.
4. Select exchange and category. Columns in this dialogue support multi-selection.
5. Then modify the resolution. Click on the blue link to modify the first sub-file. Select the desired resolution, for example 5 minutes, and check if all fields and columns are determined correctly.
6. Click OK. Resolution shall be modified for all columns automatically.
7. Click OK in the ASCII Mapping dialogue. Symbols with the specified names shall be created in QuoteManager and linked to the corresponding data from the file.
You can use the ASCII Mapping option (QuoteManager->File->Map ASCII):
https://www.multicharts.com/trading-sof ... ping_ASCII
To do it please change the file format at first — Symbol field should be on the first place
SYMBOL,DATE,TIME,OPEN,HIGH,LOW,CLOSE,VOLUME
000250,20190930,1455,33950,34000,33900,34000,3536
000250,20190930,1500,33950,34150,33950,34150,4819
000250,20190930,1505,34150,34150,34050,34100,2886
Then please follow the steps:
1. Open ASCII Mapping window and select the path to the file.
2. Select File’s field radio button
3. After that the file is displayed as 2800 strings in the ASCII Mapping dialogue.
Also, a Symbol column containing each symbol from your file appears.
4. Select exchange and category. Columns in this dialogue support multi-selection.
5. Then modify the resolution. Click on the blue link to modify the first sub-file. Select the desired resolution, for example 5 minutes, and check if all fields and columns are determined correctly.
6. Click OK. Resolution shall be modified for all columns automatically.
7. Click OK in the ASCII Mapping dialogue. Symbols with the specified names shall be created in QuoteManager and linked to the corresponding data from the file.