Importing multiple ascii symbols and data

Questions about MultiCharts .NET and user contributed studies.
idnotbe
Posts: 10
Joined: 16 Mar 2010
Has thanked: 3 times

Importing multiple ascii symbols and data

Postby idnotbe » 22 Dec 2019

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

idnotbe
Posts: 10
Joined: 16 Mar 2010
Has thanked: 3 times

Re: Importing multiple ascii symbols and data

Postby idnotbe » 24 Dec 2019

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

Image
Attachments
1.jpg
(59.63 KiB) Not downloaded yet

User avatar
Svetlana MultiCharts
Posts: 645
Joined: 19 Oct 2017
Has thanked: 3 times
Been thanked: 163 times

Re: Importing multiple ascii symbols and data

Postby Svetlana MultiCharts » 07 Feb 2020

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.
multiple symbols mapping.png
(363.52 KiB) Not downloaded yet


Return to “MultiCharts .NET”